DP-203 · Question #158
DP-203 Question #158: Real Exam Question with Answer & Explanation
Sign in or unlock DP-203 to reveal the answer and full explanation for question #158. The question stem and answer options stay visible for context.
Question
You build a data warehouse in an Azure Synapse Analytics dedicated SQL pool. Analysts write a complex SELECT query that contains multiple JOIN and CASE statements to transform data for use in inventory reports. The inventory reports will use the data and additional WHERE parameters depending on the report. The reports will be produced once daily. You need to implement a solution to make the dataset available for the reports. The solution must minimize query times. What should you implement?
Options
- Aan ordered clustered columnstore index
- Ba materialized view
- Cresult set caching
- Da replicated table
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 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.