You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A SQL Server Analysis Services (SSAS) cube named SalesCube1 is loaded with daily sales
data from a SQL Server data mart named DMSales. The source data is read from a SQL
Server 2012 database. The DMSales data mart uses a star schema.
Two tables in DMSales include a total of 80 flag columns. The tables containing the flag
columns have the same granularity as the fact table. The flag columns each have 12
different indicators values which are reused by some flags.
You need to modify the DMSales schema to maximize cube processing and query
performance and to enable users to use all flags and indicators to slice the data.

The table used for the date dimension needs to be modified to include a numeric surrogate
key and the surrogate key needs to be added to the fact table.
Which two of the following schema modifications should you perform? (Choose two)

A.
The surrogate key should be defined using the INT data type.

B.
The surrogate key should be defined using the BIGINT data type.

C.
A single fact dimension should be created in each table for the flags and indicators contained in
the table.

D.
Each different combination of flag and indicator should be combined in a single dimension.

Explanation: