Exam DP-800 Topic 1 Question 78 Discussion

Actual exam question for Microsoft's DP-800 exam
Question #: 78
Topic #: 1

You have an Azure SQL database that stores order data.
A reporting query aggregates monthly revenue per customer runs frequently.
You need to reduce how long it takes to retrieve the calculated values. The solution must NOT alter any underlying table structure.
What should you do?

A. Create a view by using ORDER BY without TOP, and then create a unique clustered index on the view. B. Create a view without using WITH SCHEMABINDING, and then create a nonclustered index on the view. C. Create a view by using GROUP BY, and then create a unique clustered index on the view. D. Create a view by using WITH SCHEMABINDING, include COUNT_BIG(*), and then create a unique clustered index on the view.

Suggested Answer: D Vote an answer

Creating an indexed view using WITH SCHEMABINDING, including COUNT_BIG(*), and creating a unique clustered index is a valid and effective approach to significantly improve the performance of your frequent reporting query without altering the underlying table structure.
This process materializes the aggregated data and stores it physically in the database, so the query optimizer can read from the precomputed view rather than rescanning the base tables every time the query runs.
Reference:
https://learn.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views

by Bess at Jun 25, 2026, 09:24 PM

Limited Time Offer

15%

Off

Get Premium DP-800 Questions as Interactive Self Test Engine or PDF

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business