Which data access strategy should you use?

You are planning to develop a SQL Server Analysis Services (SSAS) tabular project. The
project will be deployed to a SSAS server that has 16 GB of RAM.
The project will source data from a SQL Server database that contains a fact table named
Sales. The fact table has more than 60 billion rows of data.
You need to select an appropriate design to maximize query performance.
Which data access strategy should you use? (More than one answer choice may achieve
the goal. Select the BEST answer.)

A.
Configure the database to use DirectQuery mode. Create a clustered index which
includes all of the foreign key columns of the fact table.

B.
Configure the database to use In-Memory mode. Create a clustered index which includes
all of the foreign key columns of the fact table.

C.
Configure the database to use In-Memory mode. Create a columnstore index on all the
columns of the fact table.

D.
Configure the database to use DirectQuery mode. Create a columnstore index on all the
columns of the fact table.