DP-800 Question Preview

Safe Public Question Preview 8

Only the demo-safe public version is shown here. Correct answers, full explanations, internal IDs, and paid-only content stay protected.

Multiple ChoiceDesign and develop database solutions
Question 8. You need to recommend a solution to lesolve the slow dashboard query issue. What should you recommend?
A. Create a clustered index on Lastupdatedutc.
B. On Fleetid, create a nonclustered index that includes Lastupdatedutc. inginestatus, and BatteryHealth.
C. On Lastupdatedutc. create a nonclustered index that includes Fleetid.
D. On Fleetid, create a filtered index where lastupdatedutc > DATEADD(DAV, -7, SYSuTCOATETIME()).
Explanation is locked. Start the demo or unlock full access to review explanations inside the protected test engine.

Related Safe Previews

FAQ

Does this page show the answer?

No. Answers and explanations are protected inside the private test engine.