Microsoft
70-768 · Question #46
What type of partitioning strategy should you implement to support the analysis of hourly Internet sales transactions?
The correct answer is A. Convert the model to DirectQuery. Add columnstore indexes to the source tables. In the model. See the full explanation below for the reasoning.
Question
What type of partitioning strategy should you implement to support the analysis of hourly Internet sales transactions?
Options
- AConvert the model to DirectQuery. Add columnstore indexes to the source tables. In the model,
- BSet the model to DirectQuery With In-Memory Mode. Define a sample partition for the Internet
- CCreate one partition per day dynamically by running an SSIS package daily to build the new
- DCreate one partition per hour per day dynamically by running an SSIS package each hour to build
How the community answered
(59 responses)- A75% (44)
- B3% (2)
- C15% (9)
- D7% (4)
Community Discussion
No community discussion yet for this question.