Knowledge check

Completed

Choose the best response for each of the questions below. Then select Check your answers.

Check your knowledge

1.

What type of database design should you use for a data warehouse when you want to reduce the data volume of your dimensions?

2.

What is the minimum number of rows you need to bulk insert into a columnstore index?

3.

Which index type is recommended for queries that run large aggregation workloads?