Question 6
DP-800 is a newly released exam. These practice questions reflect our best current understanding — the exact wording and question formats may change in the live exam until the certification matures. Use them to learn the concepts, not to memorize.
DP-800 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.
Details →You manage an Azure SQL Database that supports a busy ecommerce site. Queries frequently filter by `OrderDate` and `CustomerId`, while nightly reports aggregate totals by month. Insert performance must remain acceptable during business hours. Which two actions should you recommend? Each correct answer presents part of the solution.
- ACreate a clustered index aligned to the main lookup pattern and add nonclustered indexes for common selective predicates.
- BAdd a separate heap copy of the Orders table for reporting queries.
- CReview index maintenance overhead and avoid creating unused overlapping indexes.
- DReplace relational indexes with JSON payload storage for all order attributes.