Microsoft
70-768 · Question #59
You manage your department's SQL Server Analysis Services (SSAS) projects. The sales department uses a tabular model to analyze sales data. Users report excessive wait times when updating the model…
The correct answer is D. Partition the table. See the full explanation below for the reasoning.
Question
You manage your department's SQL Server Analysis Services (SSAS) projects. The sales department uses a tabular model to analyze sales data. Users report excessive wait times when updating the model. You need to improve the performance of the model. What should you do?
Options
- ADefine relationships.
- BCreate a perspective.
- CDefine a hierarchy.
- DPartition the table.
How the community answered
(16 responses)- A6% (1)
- B6% (1)
- C13% (2)
- D75% (12)
Community Discussion
No community discussion yet for this question.