McAfee Secure

Exam Code: DP-800

Exam Name: Developing AI-Enabled Database Solutions

Certification Provider: Microsoft

Corresponding Certification: Microsoft Certified: SQL AI Developer Associate

Questions & Answers

Microsoft DP-800 Questions & Answers

Study with Up-To-Date REAL Exam Questions and Answers from the ACTUAL Test

Questions & Answers

101 Questions & Answers with Testing Engine

"Developing AI-Enabled Database Solutions Exam", also known as DP-800 exam, is a Microsoft certification exam.

Pass your tests with the always up-to-date DP-800 Exam Engine. Your DP-800 training materials keep you at the head of the pack!

Satisfaction Guaranteed

Money Back Guarantee

Testking provides hassle-free money back guarantee with our products. That is because we have 100% trust in the abilities of our professional and experience product team, and our record is a proof of that.

99.6% PASS RATE
Was: $137.49
Now: $124.99

Microsoft DP-800 Practice Test 92

Question 910

A stored procedure passes DECIMAL prices as unquoted strings with locale commas and model summaries misstate values. Which technical reason BEST explains the proposed correction?

  1. Data minimization reduces prompt exposure and cost without losing relevant context.
  2. JSON encoding preserves numeric representation better than locale-dependent concatenation.
  3. Context-window constraints and cost require bounded prompt construction.
  4. Rate limiting is often transient and should not erase durable database work.

Explanation

Correct Answer

B:

JSON encoding preserves numeric representation better than locale-dependent concatenation. This explains why the corrective action is to serialize numeric SQL types as valid JSON numbers with explicit unit metadata. Confirm the diagnosis when an API test reads amounts with correct decimal interpretation.

Incorrect Answers

A:

Data minimization reduces prompt exposure and cost without losing relevant context. The actual technical constraint is that JSON encoding preserves numeric representation better than locale-dependent concatenation.

C:

Context-window constraints and cost require bounded prompt construction. The actual technical constraint is that JSON encoding preserves numeric representation better than locale-dependent concatenation.

D:

Rate limiting is often transient and should not erase durable database work. The actual technical constraint is that JSON encoding preserves numeric representation better than locale-dependent concatenation.

Question 911

One document ranks first in both lexical and vector results while another appears only ninth in one. What maintenance or governance control BEST reduces recurrence of this problem?

  1. Keep rank offset and truncation policies documented.
  2. Test sorting after any metric change.
  3. Avoid counting duplicates in one list twice.
  4. Reassess costs as the corpus grows.

Explanation

Correct Answer

C:

Avoid counting duplicates in one list twice. This guards against recurrence because RRF sums reciprocal functions of positions across lists. The direct remediation is: Use RRF to reward documents ranking highly across multiple candidate lists.

Incorrect Answers

A:

Keep rank offset and truncation policies documented. The current task instead requires this action: avoid counting duplicates in one list twice.

B:

Test sorting after any metric change. The current task instead requires this action: avoid counting duplicates in one list twice.

D:

Reassess costs as the corpus grows. The current task instead requires this action: avoid counting duplicates in one list twice.

Question 912

An application needs encrypted values at rest but server-side procedures must decrypt a small field. Which implementation decision BEST addresses this requirement?

  1. Use Always Encrypted with keys managed outside the database and supported client drivers.
  2. Use Microsoft Entra-based managed identity authentication where supported.
  3. Remove keys and use deployment-time secret references or supported managed identity.
  4. Evaluate SQL column-level encryption with explicit key and certificate controls.

Explanation

Correct Answer

D:

Evaluate SQL column-level encryption with explicit key and certificate controls. This targets the primary issue because server-side encryption can decrypt inside SQL with authorized key access, unlike client-controlled Always Encrypted. Verification: Approved procedures decrypt the target values and unauthorized roles cannot open keys. Prevent recurrence: Separate key custodianship and audit key usage.

Incorrect Answers

A:

Always Encrypted protects configured column values from the SQL engine during normal processing.

B:

Managed identities remove a static SQL password from the deployed application configuration.

C:

Repository history retains secrets even after a visible commit is removed.

Question 913

An RLS policy uses SESSION_CONTEXT set directly from untrusted request text. Which measurable outcome BEST verifies that the requirement is satisfied?

  1. A spoofed request cannot change access to another tenant's rows.
  2. An export returns only rows permitted to its assigned role.
  3. The app reads the intended view but cannot read private financial objects.
  4. A forged admin header fails while valid signed identities receive correct rights.

Explanation

Correct Answer

A:

A spoofed request cannot change access to another tenant's rows. This is the decisive observable evidence after implementing derive tenant identity from verified authentication and tightly controlled session setup. It tests the underlying requirement: Session context is only safe as an authorization input when callers cannot impersonate other tenants.

Incorrect Answers

B:

An export returns only rows permitted to its assigned role. However, that result would not establish the required outcome: a spoofed request cannot change access to another tenant's rows.

C:

The app reads the intended view but cannot read private financial objects. However, that result would not establish the required outcome: a spoofed request cannot change access to another tenant's rows.

D:

A forged admin header fails while valid signed identities receive correct rights. However, that result would not establish the required outcome: a spoofed request cannot change access to another tenant's rows.

Question 914

A deployment blindly INSERTs static country rows on every run and fails with duplicates. Which technical reason BEST explains the proposed correction?

  1. Reference data is usually broadly readable to repository collaborators.
  2. Repeatable deployments must not assume reference rows are absent.
  3. A valid model build cannot verify current deployed state.
  4. Automated execution without authorization can promote unreviewed schema changes.

Explanation

Correct Answer

B:

Repeatable deployments must not assume reference rows are absent. This explains why the corrective action is to use idempotent keyed upserts or appropriate repeat-safe seed operations. Confirm the diagnosis when running the seed twice leaves the same validated rows.

Incorrect Answers

A:

Reference data is usually broadly readable to repository collaborators. The actual technical constraint is that repeatable deployments must not assume reference rows are absent.

C:

A valid model build cannot verify current deployed state. The actual technical constraint is that repeatable deployments must not assume reference rows are absent.

D:

Automated execution without authorization can promote unreviewed schema changes. The actual technical constraint is that repeatable deployments must not assume reference rows are absent.

Question 915

An application expects a 64-bit vendor identifier but its SQL key column is INT and may overflow. What maintenance or governance control BEST reduces recurrence of this problem?

  1. Keep precision/scale decisions in schema review and financial regression tests.
  2. Check memory capacity and unsupported features before migration.
  3. Validate client parameter types and index-size effects before deployment.
  4. Protect history access and plan retention and schema migration.

Explanation

Correct Answer

C:

Validate client parameter types and index-size effects before deployment. This guards against recurrence because an INT cannot represent IDs above its signed range. The direct remediation is: Select BIGINT after modeling value range, foreign keys and migration effects.

Incorrect Answers

A:

Keep precision/scale decisions in schema review and financial regression tests.

B:

Check memory capacity and unsupported features before migration. The current task instead requires this action: validate client parameter types and index-size effects before deployment.

D:

Protect history access and plan retention and schema migration. The current task instead requires this action: validate client parameter types and index-size effects before deployment.

Question 916

An order detail table is queried by CustomerId and CreatedAt and performs repeated full scans. Which implementation decision BEST addresses this requirement?

  1. Replace FLOAT money arithmetic with appropriately sized DECIMAL precision and scale.
  2. Evaluate range partitioning with boundary values aligned to retention and typical filters.
  3. Use compatible staging tables and ALTER TABLE SWITCH after checking alignment and constraints.
  4. Design a useful composite rowstore index with leading keys matching the filters and inspect the execution plan.

Explanation

Correct Answer

D:

Design a useful composite rowstore index with leading keys matching the filters and inspect the execution plan. This targets the primary issue because a missing selective access path forces large table or clustered-index scans. Verification: The representative query reads fewer pages and retains correct ordered rows. Prevent recurrence: Measure write overhead and index usage before adopting more indexes.

Incorrect Answers

A:

Binary floating-point approximations cannot represent every decimal currency value exactly.

B:

Partition elimination can reduce scanned partitions when predicates are sargable.

C:

Using compatible staging tables and ALTER TABLE SWITCH after checking alignment and constraints would not correct an order detail table is queried by CustomerId and CreatedAt and performs repeated full scans. Design a useful composite rowstore index with leading keys matching the filters and inspect the execution plan.

Question 917

A user asks for 'how to prevent late shipment penalties' but document text says 'service-level liquidated damages'. Which acceptance check is MOST directly related to this scenario?

  1. The known penalty clause ranks in a held-out test query.
  2. The exact SKU returns and misleading near codes do not.
  3. A controlled CONTAINS query succeeds after population completes.
  4. Known phrase and inflection tests return expected articles.

Explanation

Correct Answer

A:

The known penalty clause ranks in a held-out test query. This is the decisive observable evidence after implementing use semantic vector retrieval to recognize conceptual meaning beyond exact words. It tests the underlying requirement: Embedding search can retrieve related ideas even without matching literal tokens.

Incorrect Answers

B:

The exact SKU returns and misleading near codes do not. However, that result would not establish the required outcome: the known penalty clause ranks in a held-out test query.

C:

A controlled CONTAINS query succeeds after population completes. However, that result would not establish the required outcome: the known penalty clause ranks in a held-out test query.

D:

Known phrase and inflection tests return expected articles. However, that result would not establish the required outcome: the known penalty clause ranks in a held-out test query.

Question 918

A Copilot MCP configuration points at a stale server with changed schema metadata. Which technical property or constraint MOST directly matters here?

  1. Different model endpoints can have different data governance and retention arrangements.
  2. Tool discovery and endpoint configuration determine accessible operations.
  3. Editor AI availability depends on licensing, identity and permitted configuration.
  4. Copilot in Fabric availability can depend on region, capacity and tenant policies.

Explanation

Correct Answer

B:

Tool discovery and endpoint configuration determine accessible operations. This explains why the corrective action is to update and validate the MCP connection and available tool schema in the client. Confirm the diagnosis when the session lists the current intended tools and returns valid metadata.

Incorrect Answers

A:

Different model endpoints can have different data governance and retention arrangements. The actual technical constraint is that tool discovery and endpoint configuration determine accessible operations.

C:

Editor AI availability depends on licensing, identity and permitted configuration. The actual technical constraint is that tool discovery and endpoint configuration determine accessible operations.

D:

Copilot in Fabric availability can depend on region, capacity and tenant policies. The actual technical constraint is that tool discovery and endpoint configuration determine accessible operations.

Question 919

A product API caches inventory counts for an hour and customers see stale stock after orders. Which preventive practice BEST addresses the underlying risk over time?

  1. Use consistent ordering and monitor costly filters.
  2. Enforce SQL row-level security against cross-customer traversal.
  3. Document invalidation and avoid caching sensitive responses incorrectly.
  4. Validate input parameters and avoid excessive execution privileges.

Explanation

Correct Answer

C:

Document invalidation and avoid caching sensitive responses incorrectly. This guards against recurrence because response caching trades freshness for latency and may serve obsolete facts. The direct remediation is: Use an appropriate DAB cache TTL or disable cache for volatile inventory fields.

Incorrect Answers

A:

Use consistent ordering and monitor costly filters. The current task instead requires this action: document invalidation and avoid caching sensitive responses incorrectly.

B:

Enforce SQL row-level security against cross-customer traversal. The current task instead requires this action: document invalidation and avoid caching sensitive responses incorrectly.

D:

Validate input parameters and avoid excessive execution privileges. The current task instead requires this action: document invalidation and avoid caching sensitive responses incorrectly.

Question 920

Queries filter millions of product rows by a JSON property and repeatedly scan payloads. What should the SQL developer do FIRST to address the specific issue?

  1. Use OPENJSON with a typed WITH schema and transactional parent-child inserts.
  2. Use a shared SQL SEQUENCE with NEXT VALUE FOR in supported database environments.
  3. Evaluate range partitioning with boundary values aligned to retention and typical filters.
  4. Evaluate supported JSON index or indexed computed-column path for that SQL platform and version.

Explanation

Correct Answer

D:

Evaluate supported JSON index or indexed computed-column path for that SQL platform and version. This targets the primary issue because unindexed JSON path predicates can incur expensive row-by-row parsing. Verification: The execution plan uses the chosen path access strategy and returns matching products. Prevent recurrence: Benchmark maintenance overhead and verify deployment-specific feature support.

Incorrect Answers

A:

Parsing nested arrays into typed rows reduces fragile manual string extraction.

B:

A sequence can allocate numbers independently of one table identity property.

C:

Partition elimination can reduce scanned partitions when predicates are sargable.

Developing AI-Enabled Database Solutions (DP-800) Practice Tests