Microsoft
70-768 · Question #46
70-768 Question #46: Real Exam Question with Answer & Explanation
Sign in or unlock 70-768 to reveal the answer and full explanation for question #46. The question stem and answer options stay visible for context.
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
Unlock 70-768 to see the answer
You've previewed enough free 70-768 questions. Unlock 70-768 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.