You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
The company has a data warehouse named CorpDW. CorpDW is updated with
approximately 100 million new records every week outside business hours.
Data is sometimes queried at month level but more often is queried at the week level using
cube processing and reports.
CorpDW contains a large fact table. You need to configure the table partitioning to ensure
that the performance of the queries is maximized.
Which two of the following options describe how you should you partition the table?
(Choose two).
A.
You should partition the table by hour.
B.
You should partition the table by day.
C.
You should partition the table by week.
D.
You should partition the table by month.
E.
You should partition the table by year.
F.
The partitions should be compressed.
G.
The partitions should not be compressed.
Explanation:
ok