DP-700 · Question #105
When a new book cover image arrives in the Files folder, process the image as soon as possible. What should you do to optimize the query experience for the business users?
The correct answer is B. Create and update statistics. To optimize the query experience for business users after new data arrives, you should create and regularly update statistics on your data.
Question
Options
- AEnable V-Order.
- BCreate and update statistics.
- CRun the VACUUM command.
- DIntroduce primary keys.
How the community answered
(29 responses)- A3% (1)
- B93% (27)
- D3% (1)
Why each option
To optimize the query experience for business users after new data arrives, you should create and regularly update statistics on your data.
Enabling V-Order optimizes the physical storage of Parquet files for faster reads, but it doesn't directly inform the query optimizer about data distribution like statistics do.
Creating and updating statistics allows the query optimizer to have up-to-date information about the data distribution, enabling it to generate more efficient execution plans for queries, which directly improves query performance for business users. This is a fundamental optimization technique for analytical workloads where data frequently changes or arrives.
The VACUUM command is used to remove old, unreferenced files from Delta tables and reclaim storage, not to optimize query performance for new data.
Introducing primary keys enforces data integrity and uniqueness but does not directly optimize query performance for analytical queries in the same way that statistics help the query optimizer.
Concept tested: Query optimization - statistics
Source: https://learn.microsoft.com/en-us/fabric/data-warehousing/statistics
Topics
Community Discussion
No community discussion yet for this question.