Which three of the following configurations would best meet these requirements?

You work as a Database Administrator (DBA) at a company named ABC.com. The
company has a SQL Server 2012 infrastructure.

You have a database named CorpDB1. You need to create a fact table in CorpDB1 that will
expand to contain billions of rows.
You need to design the most efficient table to maximize the performance of queries. Users
must be able to choose up to 12 dimension tables and up to a maximum of 4 facts for any
query. Measures will be aggregated by the queries by using any of the 12 dimensions. You
need to include a columnstore index for the table.
Which three of the following configurations would best meet these requirements? (Choose
three)

A.
Configure 12 dimensional key columns in the fact table.

B.
Configure 4 measure columns in the fact table.

C.
Configure 4 dimensional key columns in the fact table.

D.
Configure 12 measure columns in the fact table.

E.
Use only the dimensional key columns for the columnstore index.

F.
Use only the measure columns for the columnstore index.

G.
Use the dimensional key columns and the measure columns for the columnstore index.

Explanation: