Microsoft DP-800 Practice Test 2 - Prepaway
Practice Exams:

Pass Microsoft DP-800 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!

30 Days Free Updates, Instant Download!

Verified By Experts
Premium File
$69.99 $76.99

DP-800 Premium ETE File


  • Premium File 101 Questions & Answers. Last Update: Nov 06, 2026
Whats Included:
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

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?

  1. Use a supported SQL vector type with dimension compatibility checks and an appropriate data design.
  2. Build a labeled query set and track recall at k, precision, latency, and failure slices.
  3. Apply product availability and eligibility rules before or during semantic ranking and verify result scope.
  4. Use full-text or exact filtering for identifiers and assess hybrid search for broader natural-language queries.

Explanation

Correct Answer

D:

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

A:

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.

B:

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.

C:

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?

  1. Audit coverage is incomplete without secure durable retention and controlled access.
  2. Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available.
  3. A friendly UI never substitutes for server-side field and entity access controls.
  4. Encryption at rest does not replace database access controls for authenticated query operations.

Explanation

Correct Answer

A:

Audit coverage is incomplete without secure durable retention and controlled access.

Incorrect Answers

B:

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.

C:

A friendly UI never substitutes for server-side field and entity access controls. Audit coverage is incomplete without secure durable retention and controlled access.

D:

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?

  1. The assisted workflow operates against the expected test environment and refuses unapproved production operations.
  2. A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure.
  3. Tests confirm exact expected totals for refunds, null values, and normal billing records.
  4. A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions.

Explanation

Correct Answer

C:

Tests confirm exact expected totals for refunds, null values, and normal billing records.

Incorrect Answers

A:

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.

B:

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.

D:

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?

  1. Security boundaries must be enforced even when clients can freely modify requests.
  2. Access prevention and accountable security monitoring are complementary controls.
  3. Data masking is a presentation-level control and inference exposure needs separate review.
  4. Security auditing requires deliberate event selection, integrity, and lifecycle management.

Explanation

Correct Answer

C:

Data masking is a presentation-level control and inference exposure needs separate review.

Incorrect Answers

A:

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.

B:

Access prevention and accountable security monitoring are complementary controls. Data masking is a presentation-level control and inference exposure needs separate review.

D:

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?

  1. Staging API calls fail immediately after the database rename while some clients cannot update overnight.
  2. Unit tests pass while a real GraphQL query fails on a missing relationship field.
  3. The merge compiles each branch separately but produces conflicting definitions in the combined model.
  4. The repository contains SQL objects but no successful project build artifact or referenced model resolution.

Explanation

Correct Answer

B:

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

A:

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.

C:

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.

D:

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?

  1. Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter.
  2. Separate migrations into a controlled deployment identity and grant the runtime only needed object operations.
  3. Apply DAB roles, entity permissions, and backend identity least privilege with negative tests.
  4. Apply service authentication, tool allowlists, scoped SQL permissions, and approval for state changes.

Explanation

Correct Answer

D:

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

A:

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.

B:

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.

C:

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?

  1. Assistant context files are source-controlled assets that must follow normal information security standards.
  2. Tool routing must be unambiguous when an AI assistant can reach multiple data environments.
  3. AI-assisted development does not remove developer responsibility for SQL authorization and correctness.
  4. AI assistant availability depends on environment settings, entitlements, and tenant governance.

Explanation

Correct Answer

D:

AI assistant availability depends on environment settings, entitlements, and tenant governance.

Incorrect Answers

A:

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.

B:

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.

C:

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?

  1. A tested query returns the expected nearest vector rows with reproducible distance values.
  2. Results remain relevant and exclude ineligible inventory under tested status changes.
  3. The deployed index and benchmark use the same metric and meet target relevance.
  4. Negative cross-tenant searches reveal no unauthorized chunks or metadata.

Explanation

Correct Answer

A:

A tested query returns the expected nearest vector rows with reproducible distance values.

Incorrect Answers

B:

Results remain relevant and exclude ineligible inventory under tested status changes. A tested query returns the expected nearest vector rows with reproducible distance values.

C:

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.

D:

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?

  1. The merged project builds and a staged migration preserves all approved fields.
  2. A clean rebuild and incremental deployment produce identical authorized lookup mappings.
  3. The pipeline rejects the faulty change and accepts the corrected procedure with verified results.
  4. A dry run validates the intended server/database identity and production release targets only that environment.

Explanation

Correct Answer

D:

A dry run validates the intended server/database identity and production release targets only that environment.

Incorrect Answers

A:

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.

B:

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.

C:

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?

  1. The assisted workflow operates against the expected test environment and refuses unapproved production operations.
  2. New suggestions follow the documented conventions and still pass independent pull-request review.
  3. The assistant ignores the embedded command and logs no attempt to access the secret table.
  4. The tool returns only approved lakehouse metadata and rejects unauthorized workspace access.

Explanation

Correct Answer

D:

The tool returns only approved lakehouse metadata and rejects unauthorized workspace access.

Incorrect Answers

A:

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.

B:

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.

C:

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?

  1. Query Store shows the same query hash shifted to a more expensive plan after deployment.
  2. A blocked request waits behind a long-running transaction but no deadlock victim is recorded.
  3. A simultaneous test creates two confirmed bookings for one remaining seat.
  4. The plan includes hundreds of thousands of lookups for columns absent from the nonclustered index.

Explanation

Correct Answer

D:

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

A:

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.

B:

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.

C:

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