Microsoft
70-466 · Question #78
70-466 Question #78: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #78. The question stem and answer options stay visible for context.
Build a tabular data model
Question
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 2012 database that contains a fact table named Sales. The fact table has more than 80 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.)
Options
- AConfigure the database to use DirectQuery mode. Create a columnstore index on all the columns of the fact table.
- BConfigure the database to use In-Memory mode. Create a clustered index which includes all of the foreign key columns of the fact table.
- CConfigure the database to use In-Memory mode. Create a columnstore index on all the columns of the fact table.
- DConfigure the database to use DirectQuery mode. Create a clustered index which includes all of the foreign key columns of the fact table.
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SSAS tabular DirectQuery#In-Memory mode#columnstore index#large fact table performance