HOTSPOT
You are designing a fact table that has 100 million rows and 1,800 partitions. The partitions are defined based
on a column named OrderDayKey. The fact table will contain:
Data from the last five years
A clustered columnstore index
A column named YearMonthKey that stores the year and the month
Multiple transformations will be performed on the fact table during the loading process. The fact table will be
hash distributed on a column named OrderId.
You plan to load the data to a staging table and to perform transformations on the staging table. You will then
load the data from the staging table to the final fact table.
You need to design a solution to load the data to the fact table. The solution must minimize how long it takes to
perform the following tasks:
Load the staging table.
Transfer the data from the staging table to the fact table.
Remove data that is older than five years.
Query the data in the fact table.
How should you configure the tables? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Answer: