Knowledge check

  • 5 minutes

Choose the best response for each of the questions below.

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?