Câu 101: DP-203: Data Engineering on Microsoft Azure

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?

1. A. an ordered clustered columnstore index
2. B. a materialized view — đáp án hiện tại
3. C. result set caching
4. D. a replicated table