Pass Microsoft DP-800 Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers!
30 Days Free Updates, Instant Download!
Microsoft DP-800 Practice Test 4
Question 30
A team deploys DAB behind a gateway and assumes the backend is safe because the gateway normally authenticates users. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
Require and test appropriate service-level authentication and network restrictions at every reachable endpoint.
Direct unauthenticated calls fail while gateway-routed authorized traffic succeeds. Require and test appropriate service-level authentication and network restrictions at every reachable endpoint.
Incorrect Answers
A bounded query or optimized mapping meets latency targets under representative load. Require and test appropriate service-level authentication and network restrictions at every reachable endpoint.
Configure appropriate pagination, result limits, and role-level filtering in DAB. Require and test appropriate service-level authentication and network restrictions at every reachable endpoint.
Configure the supported DAB GraphQL relationship mapping and test nested authorization across entities. Require and test appropriate service-level authentication and network restrictions at every reachable endpoint.
Question 31
A database procedure concatenates order rows into an unescaped text string before sending them to a model, causing malformed or ambiguous prompts. Which TWO options together specify a corrective step and a meaningful test?
Explanation
Correct Answers
An independent JSON parser accepts the request and preserves each expected field and row. The corresponding check is whether convert the approved structured rows to valid JSON with supported SQL JSON construction functions.
Convert the approved structured rows to valid JSON with supported SQL JSON construction functions. An independent JSON parser accepts the request and preserves each expected field and row.
Incorrect Answers
A controlled request cites the active policy and does not require a model retraining cycle. An independent JSON parser accepts the request and preserves each expected field and row.
Parse and validate the returned model response envelope and expected JSON fields before storing results. An independent JSON parser accepts the request and preserves each expected field and row.
Implement retrieval-augmented generation using approved current SQL policy records with source citations. An independent JSON parser accepts the request and preserves each expected field and row.
Question 32
A SQL service calls an external model and assumes its output is always a plain text answer, but the service contract requires structured fields and safe errors. What is the underlying reason for the corrective step?
Explanation
Correct Answer
External model responses are untrusted service results and need robust parsing and error handling.
Incorrect Answers
RAG supplies current grounded evidence without encoding every business fact in model weights. External model responses are untrusted service results and need robust parsing and error handling.
A structured interchange format can make SQL-to-model data safer and less ambiguous than string concatenation. External model responses are untrusted service results and need robust parsing and error handling.
A RAG solution must acknowledge unsupported questions rather than invent source authority. External model responses are untrusted service results and need robust parsing and error handling.
Question 33
A bank needs to reconstruct the prior values of an account preference after customer service overwrote a row and the current table only stores the latest state. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Evaluate system-versioned temporal tables with history retention and appropriate access controls. A time-based query returns the correct historical version and retention follows policy.
A time-based query returns the correct historical version and retention follows policy.
Incorrect Answers
Assess supported external table capabilities and data-source credentials for the chosen SQL platform. A time-based query returns the correct historical version and retention follows policy. Evaluate system-versioned temporal tables with history retention and appropriate access controls.
A rehearsed partition switch completes and representative queries retain acceptable plans. A time-based query returns the correct historical version and retention follows policy.
Keep a row-oriented transactional design for the hot selective workload and benchmark analytical indexes separately. A time-based query returns the correct historical version and retention follows policy.
Question 34
An incentive report ranks top sellers by revenue but ties must follow a documented business tie-break rather than unpredictable row ordering. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
Use an appropriate window rank and secondary order according to the published tie rule. An incentive report ranks top sellers by revenue but ties must follow a documented business tie-break rather than unpredictable row ordering.
Repeated runs produce the expected ranking and tie handling for the same data. An incentive report ranks top sellers by revenue but ties must follow a documented business tie-break rather than unpredictable row ordering. Use an appropriate window rank and secondary order according to the published tie rule.
Incorrect Answers
Use LAG partitioned by product and ordered by report month, then check handling for missing months. An incentive report ranks top sellers by revenue but ties must follow a documented business tie-break rather than unpredictable row ordering. Use an appropriate window rank and secondary order according to the published tie rule.
The graph query returns the verified two-hop relationships without inventing direct account links. An incentive report ranks top sellers by revenue but ties must follow a documented business tie-break rather than unpredictable row ordering. Repeated runs produce the expected ranking and tie handling for the same data.
Evaluate REGEXP_REPLACE with a narrowly tested account-token pattern and independent sensitive-data detection. An incentive report ranks top sellers by revenue but ties must follow a documented business tie-break rather than unpredictable row ordering. Use an appropriate window rank and secondary order according to the published tie rule.
Question 35
A telemetry ingestion service sees hot-row latch contention in a small transient state table during bursty writes. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs.
Incorrect Answers
Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs.
Indexes should match useful predicates and sort requirements rather than being added indiscriminately. Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs.
Columnstore health depends on ingestion and modification patterns as well as index creation. Memory-optimized designs address specific concurrency patterns and require explicit durability tradeoffs.
Question 36
A database contains product-description embeddings and needs to calculate distances to an incoming query vector over a small reference sample. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Use supported VECTOR_DISTANCE with a compatible metric and deterministic ranking checks. Vector distance functions compare numeric embedding representations, not lexical JSON text.
Incorrect Answers
Evaluate supported VECTOR_SEARCH and suitable vector indexes with quality and latency benchmarking. Vector distance functions compare numeric embedding representations, not lexical JSON text. Use supported VECTOR_DISTANCE with a compatible metric and deterministic ranking checks.
Implement supported index update or rebuild processes tied to source and vector lifecycle events. Vector distance functions compare numeric embedding representations, not lexical JSON text. Use supported VECTOR_DISTANCE with a compatible metric and deterministic ranking checks.
Compare ANN and exact-nearest-neighbor methods using agreed recall and latency thresholds. Vector distance functions compare numeric embedding representations, not lexical JSON text. Use supported VECTOR_DISTANCE with a compatible metric and deterministic ranking checks.
Question 37
A T-SQL workflow builds a prompt for an external language model but includes every row and confidential identifier regardless of question scope. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
The request sends only approved fields and the model receives sufficient task context. The operating rule is: External REST calls from SQL must minimize disclosed data and enforce endpoint security.
Incorrect Answers
Every material policy claim cites a current accessible source or is marked unsupported. The operating rule is: External REST calls from SQL must minimize disclosed data and enforce endpoint security. The request sends only approved fields and the model receives sufficient task context.
Valid responses populate the correct schema while failures are logged and retried safely. The operating rule is: External REST calls from SQL must minimize disclosed data and enforce endpoint security. The request sends only approved fields and the model receives sufficient task context.
A sampled result can be traced to permitted source records, model version, and accountable review. The operating rule is: External REST calls from SQL must minimize disclosed data and enforce endpoint security. The request sends only approved fields and the model receives sufficient task context.
Question 38
A bookings database allows negative guest counts and missing initial status fields because web clients supply values inconsistently. What should the database developer verify to confirm the suspected cause?
Explanation
Correct Answer
A direct SQL write bypasses the front-end validator and saves invalid guest counts. Database constraints enforce integrity across multiple clients rather than relying solely on user interfaces.
Incorrect Answers
Integrity checks identify line rows with identifiers missing from the invoice parent table. Database constraints enforce integrity across multiple clients rather than relying solely on user interfaces. A direct SQL write bypasses the front-end validator and saves invalid guest counts.
Nightly copies drift from the source and duplicate storage increases each reporting cycle. Database constraints enforce integrity across multiple clients rather than relying solely on user interfaces. A direct SQL write bypasses the front-end validator and saves invalid guest counts.
Current application counters collide under concurrent insert attempts and operators require IDs to be unique rather than consecutive. Database constraints enforce integrity across multiple clients rather than relying solely on user interfaces. A direct SQL write bypasses the front-end validator and saves invalid guest counts.
Question 39
A regulated SQL system must reconstruct who changed permission grants last week but the database has no retained audit evidence. What should the database developer verify to confirm the suspected cause?
Explanation
Correct Answer
The current logs show query counts but cannot identify permission grant activity or responsible principals. Security auditing requires deliberate event selection, integrity, and lifecycle management.
Incorrect Answers
A test prompt can invoke an ALTER TABLE through the assistant without human authorization. Security auditing requires deliberate event selection, integrity, and lifecycle management. The current logs show query counts but cannot identify permission grant activity or responsible principals.
A test user changes the tenant value and retrieves another client's otherwise protected rows. Security auditing requires deliberate event selection, integrity, and lifecycle management. The current logs show query counts but cannot identify permission grant activity or responsible principals.
The compromised application identity reads plaintext fields from normal SQL queries despite encrypted storage. Security auditing requires deliberate event selection, integrity, and lifecycle management. The current logs show query counts but cannot identify permission grant activity or responsible principals.
Question 40
A GitHub Copilot chat connects to a SQL MCP server configured with a broad administrator identity and developers plan to run generated queries against production. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution. A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions.
A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions. The corresponding check is whether reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.
Incorrect Answers
The assistant ignores the embedded command and logs no attempt to access the secret table. A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.
Replace live values with safe synthetic examples and enforce repository secret and privacy scanning. A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.
Create reviewed repository instruction files that specify migration, test, and secure coding conventions without embedding secrets. A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 2 - 10 Questions (Last Reviewed 15-Nov-2026)
- Microsoft DP-800 Practice Test 3 - 10 Questions (Last Reviewed 14-Nov-2026)
- Microsoft DP-800 Practice Test 4 - 10 Questions (Last Reviewed 13-Nov-2026)
- Microsoft DP-800 Practice Test 5 - 10 Questions (Last Reviewed 12-Nov-2026)
- Microsoft DP-800 Practice Test 6 - 10 Questions (Last Reviewed 11-Nov-2026)