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 2
Question 10
A product support database must find tickets containing exact hardware model codes and a proposal uses semantic vector matching alone. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Use full-text or exact filtering for identifiers and assess hybrid search for broader natural-language queries. Lexical and semantic relevance target different retrieval needs and are often complementary.
Incorrect Answers
Use a supported SQL vector type with dimension compatibility checks and an appropriate data design. Lexical and semantic relevance target different retrieval needs and are often complementary. Use full-text or exact filtering for identifiers and assess hybrid search for broader natural-language queries.
Build a labeled query set and track recall at k, precision, latency, and failure slices. Lexical and semantic relevance target different retrieval needs and are often complementary. Use full-text or exact filtering for identifiers and assess hybrid search for broader natural-language queries.
Apply product availability and eligibility rules before or during semantic ranking and verify result scope. Lexical and semantic relevance target different retrieval needs and are often complementary. Use full-text or exact filtering for identifiers and assess hybrid search for broader natural-language queries.
Question 11
A regulated app writes SQL audit logs to short-lived storage and a retention job removes investigation evidence before the mandated period. What is the underlying reason for the corrective step?
Explanation
Correct Answer
Audit coverage is incomplete without secure durable retention and controlled access.
Incorrect Answers
Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available. Audit coverage is incomplete without secure durable retention and controlled access.
A friendly UI never substitutes for server-side field and entity access controls. Audit coverage is incomplete without secure durable retention and controlled access.
Encryption at rest does not replace database access controls for authenticated query operations. Audit coverage is incomplete without secure durable retention and controlled access.
Question 12
An AI coding assistant proposes rewriting a billing query, but the team has no regression fixture for null taxes and partial refunds. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
Tests confirm exact expected totals for refunds, null values, and normal billing records.
Incorrect Answers
The assisted workflow operates against the expected test environment and refuses unapproved production operations. Tests confirm exact expected totals for refunds, null values, and normal billing records.
A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure. Tests confirm exact expected totals for refunds, null values, and normal billing records.
A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions. Tests confirm exact expected totals for refunds, null values, and normal billing records.
Question 13
A support role sees masked card numbers but can execute broad aggregate and comparison queries that might reveal protected details. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
Data masking is a presentation-level control and inference exposure needs separate review.
Incorrect Answers
Security boundaries must be enforced even when clients can freely modify requests. Data masking is a presentation-level control and inference exposure needs separate review.
Access prevention and accountable security monitoring are complementary controls. Data masking is a presentation-level control and inference exposure needs separate review.
Security auditing requires deliberate event selection, integrity, and lifecycle management. Data masking is a presentation-level control and inference exposure needs separate review.
Question 14
A Data API builder release works with mocked SQL queries but fails in staging because its real entity mapping differs from deployed database schema. What should the database developer verify to confirm the suspected cause?
Explanation
Correct Answer
Unit tests pass while a real GraphQL query fails on a missing relationship field. Integration tests detect cross-component contracts that isolated builds do not verify.
Incorrect Answers
Staging API calls fail immediately after the database rename while some clients cannot update overnight. Integration tests detect cross-component contracts that isolated builds do not verify. Unit tests pass while a real GraphQL query fails on a missing relationship field.
The merge compiles each branch separately but produces conflicting definitions in the combined model. Integration tests detect cross-component contracts that isolated builds do not verify. Unit tests pass while a real GraphQL query fails on a missing relationship field.
The repository contains SQL objects but no successful project build artifact or referenced model resolution. Integration tests detect cross-component contracts that isolated builds do not verify. Unit tests pass while a real GraphQL query fails on a missing relationship field.
Question 15
A SQL MCP server advertises a generic execute-query tool that can run destructive statements using elevated credentials. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Apply service authentication, tool allowlists, scoped SQL permissions, and approval for state changes. MCP tools expand the attack surface and require standard service and database authorization.
Incorrect Answers
Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter. MCP tools expand the attack surface and require standard service and database authorization. Apply service authentication, tool allowlists, scoped SQL permissions, and approval for state changes.
Separate migrations into a controlled deployment identity and grant the runtime only needed object operations. MCP tools expand the attack surface and require standard service and database authorization. Apply service authentication, tool allowlists, scoped SQL permissions, and approval for state changes.
Apply DAB roles, entity permissions, and backend identity least privilege with negative tests. MCP tools expand the attack surface and require standard service and database authorization. Apply service authentication, tool allowlists, scoped SQL permissions, and approval for state changes.
Question 16
A Fabric SQL team wants contextual AI assistance but the feature is disabled for the workspace and owners assume every user has access automatically. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
AI assistant availability depends on environment settings, entitlements, and tenant governance.
Incorrect Answers
Assistant context files are source-controlled assets that must follow normal information security standards. AI assistant availability depends on environment settings, entitlements, and tenant governance.
Tool routing must be unambiguous when an AI assistant can reach multiple data environments. AI assistant availability depends on environment settings, entitlements, and tenant governance.
AI-assisted development does not remove developer responsibility for SQL authorization and correctness. AI assistant availability depends on environment settings, entitlements, and tenant governance.
Question 17
A database contains product-description embeddings and needs to calculate distances to an incoming query vector over a small reference sample. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
A tested query returns the expected nearest vector rows with reproducible distance values.
Incorrect Answers
Results remain relevant and exclude ineligible inventory under tested status changes. A tested query returns the expected nearest vector rows with reproducible distance values.
The deployed index and benchmark use the same metric and meet target relevance. A tested query returns the expected nearest vector rows with reproducible distance values.
Negative cross-tenant searches reveal no unauthorized chunks or metadata. A tested query returns the expected nearest vector rows with reproducible distance values.
Question 18
A deployment script hardcodes a development database endpoint and CI unexpectedly connects to test during a production release. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
A dry run validates the intended server/database identity and production release targets only that environment.
Incorrect Answers
The merged project builds and a staged migration preserves all approved fields. A dry run validates the intended server/database identity and production release targets only that environment.
A clean rebuild and incremental deployment produce identical authorized lookup mappings. A dry run validates the intended server/database identity and production release targets only that environment.
The pipeline rejects the faulty change and accepts the corrected procedure with verified results. A dry run validates the intended server/database identity and production release targets only that environment.
Question 19
A developer attaches a Fabric lakehouse MCP endpoint to a chat that also has access to multiple confidential workspaces. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
The tool returns only approved lakehouse metadata and rejects unauthorized workspace access.
Incorrect Answers
The assisted workflow operates against the expected test environment and refuses unapproved production operations. The tool returns only approved lakehouse metadata and rejects unauthorized workspace access.
New suggestions follow the documented conventions and still pass independent pull-request review. The tool returns only approved lakehouse metadata and rejects unauthorized workspace access.
The assistant ignores the embedded command and logs no attempt to access the secret table. The tool returns only approved lakehouse metadata and rejects unauthorized workspace access.
Question 20
A frequently executed dashboard query filters a narrow index but retrieves many extra columns through repeated key lookups. What technical finding would substantiate this root cause?
Explanation
Correct Answer
The plan includes hundreds of thousands of lookups for columns absent from the nonclustered index. Covering access paths may avoid repeated lookups but extra index width has costs.
Incorrect Answers
Query Store shows the same query hash shifted to a more expensive plan after deployment. Covering access paths may avoid repeated lookups but extra index width has costs. The plan includes hundreds of thousands of lookups for columns absent from the nonclustered index.
A blocked request waits behind a long-running transaction but no deadlock victim is recorded. Covering access paths may avoid repeated lookups but extra index width has costs. The plan includes hundreds of thousands of lookups for columns absent from the nonclustered index.
A simultaneous test creates two confirmed bookings for one remaining seat. Covering access paths may avoid repeated lookups but extra index width has costs. The plan includes hundreds of thousands of lookups for columns absent from the nonclustered index.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 1 - 10 Questions (Last Reviewed 16-Nov-2026)
- 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)