This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Choose the best response for each of the questions below.
What type of database design should you use for a data warehouse when you want to reduce the data volume of your dimensions?
Snowflake schema
Star Schema
Third normal form
What is the minimum number of rows you need to bulk insert into a columnstore index?
102,400
1,000,000
1000
Which index type is recommended for queries that run large aggregation workloads?
Columnstore index
Clustered index
Nonclustered index
You must answer all questions before checking your work.
Was this page helpful?