Data Warehousing Quiz

What type of schema contains numeric measures like revenue and quantity?

• Hierarchical schema

• Star schema

• Snowflake schema

• Relational schema

Which key uniquely identifies an instance of a dimension entity?

• Composite key

• Surrogate key

• Alternate key

• Primary key

What distribution option is best for a sales fact table with billions of records?

• CLUSTERED

• HASH

• ROUND_ROBIN

• REPLICATE

Which command should you use to load a staging table with data from files in the data lake?

• INSERT

• LOAD

• COPY

• MERGE

When a customer changes their phone number, the change should be made in the existing row for that customer in the dimension table. What type of slowly changing dimension is this?

• Type 0

• Type 2

• Type 1

• Type 3

What is the default index type recommended for most cases in a data warehouse?

• BITMAP

• HASH

• NONCLUSTERED

• CLUSTERED COLUMNSTORE

Which table type should an insurance company use to store details of customer attributes by which claims will be aggregated?

• Fact table

• Dimension table

• Staging table

• Lookup table

What should you do to optimize load performance in a data warehouse?

• Ignore statistics

• Delete data

• Disable constraints

• Rebuild indexes

In which order should you load tables in the data warehouse?

• Staging tables, then dimension tables, then fact tables

• Staging tables, then fact tables, then dimension tables

• Dimension tables, then staging tables, then fact tables

• Fact tables, then dimension tables, then staging tables

What is used to define table metadata for files in a data lake?

• External keys

• Virtual tables

• Temporary tables

• External tables