DP-900 • Practice Test 27
Free DP-900 practice test — 15 questions with explanations. Set 27. No signup required.
A company uses Azure SQL Database for an order management system. They have a table 'Orders' with columns: OrderID (PK), CustomerID, OrderDate, TotalAmount. Queries that filter on OrderDate are slow. They create a nonclustered index on OrderDate. However, after many inserts, the index becomes fragmented and page splits occur frequently. Which action should the DBA take to maintain query performance?
Choose an answer to begin — your selection is scored in the full session.
15 questions · instant feedback and full explanations after every question.