Question 22
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 →A database engineering team wants an AI assistant to suggest T-SQL refactorings based on live schema metadata from SQL Server and Fabric. The solution must avoid broad, unrestricted direct database access. Which implementation should you recommend?
- AConnect the assistant to MCP endpoints that expose only the required context.
- BGrant sysadmin access so the assistant can inspect every object directly.
- CDisable schema validation to reduce prompt size.
- DStore all schema metadata in screenshots and ask the assistant to infer the model visually.