nerdexam
Microsoft

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.

Monitor and optimize a data analytics solution

Question

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?

Options

  • AEnable V-Order.
  • BCreate and update statistics.
  • CRun the VACUUM command.
  • DIntroduce primary keys.

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    93% (27)
  • D
    3% (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.

AEnable V-Order.

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.

BCreate and update statistics.Correct

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.

CRun the VACUUM command.

The VACUUM command is used to remove old, unreferenced files from Delta tables and reclaim storage, not to optimize query performance for new data.

DIntroduce primary keys.

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

#Query optimization#Database statistics#Performance tuning#Azure Synapse Analytics

Community Discussion

No community discussion yet for this question.

Full DP-700 Practice