McAfee Secure

Exam Code: DP-800

Exam Name: Developing AI-Enabled Database Solutions

Certification Provider: Microsoft

Corresponding Certification: Microsoft Certified: SQL AI Developer Associate

Microsoft DP-800 Questions & Answers

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

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 67

Question 660

A stored procedure passes DECIMAL prices as unquoted strings with locale commas and model summaries misstate values. Which measurable outcome BEST verifies that the requirement is satisfied?

  1. Captured outbound JSON excludes restricted notes and includes needed metrics.
  2. A fixture response yields the expected text without transport headers.
  3. The computed amount matches audited ledger SQL exactly.
  4. An API test reads amounts with correct decimal interpretation.

Explanation

Correct Answer

D:

An API test reads amounts with correct decimal interpretation. This is the decisive observable evidence after implementing serialize numeric SQL types as valid JSON numbers with explicit unit metadata. It tests the underlying requirement: JSON encoding preserves numeric representation better than locale-dependent concatenation.

Incorrect Answers

A:

Captured outbound JSON excludes restricted notes and includes needed metrics. However, that result would not establish the required outcome: an API test reads amounts with correct decimal interpretation.

B:

A fixture response yields the expected text without transport headers. However, that result would not establish the required outcome: an API test reads amounts with correct decimal interpretation.

C:

The computed amount matches audited ledger SQL exactly. However, that result would not establish the required outcome: an API test reads amounts with correct decimal interpretation.

Question 661

One document ranks first in both lexical and vector results while another appears only ninth in one. Which technical reason BEST explains the proposed correction?

  1. RRF sums reciprocal functions of positions across lists.
  2. RRF operates on list positions and is distinct from raw score interpolation.
  3. Approximate retrieval may omit key passages, degrading downstream grounding.
  4. Small synthetic benchmarks understate index and memory behavior at scale.

Explanation

Correct Answer

A:

RRF sums reciprocal functions of positions across lists. This explains why the corrective action is to use RRF to reward documents ranking highly across multiple candidate lists. Confirm the diagnosis when the joint top-ranked item receives the expected combined score.

Incorrect Answers

B:

RRF operates on list positions and is distinct from raw score interpolation. The actual technical constraint is that RRF sums reciprocal functions of positions across lists.

C:

Approximate retrieval may omit key passages, degrading downstream grounding. The actual technical constraint is that RRF sums reciprocal functions of positions across lists.

D:

Small synthetic benchmarks understate index and memory behavior at scale. The actual technical constraint is that RRF sums reciprocal functions of positions across lists.

Question 662

An application needs encrypted values at rest but server-side procedures must decrypt a small field. What maintenance or governance control BEST reduces recurrence of this problem?

  1. Protect client-side keys and plan query limitations and rotation.
  2. Separate key custodianship and audit key usage.
  3. Keep firewall, identity and database grants under independent review.
  4. Rotate signing keys and validate audiences and issuers.

Explanation

Correct Answer

B:

Separate key custodianship and audit key usage. This guards against recurrence because server-side encryption can decrypt inside SQL with authorized key access, unlike client-controlled Always Encrypted. The direct remediation is: Evaluate SQL column-level encryption with explicit key and certificate controls.

Incorrect Answers

A:

Protect client-side keys and plan query limitations and rotation. The current task instead requires this action: separate key custodianship and audit key usage.

C:

Keep firewall, identity and database grants under independent review. The current task instead requires this action: separate key custodianship and audit key usage.

D:

Rotate signing keys and validate audiences and issuers. The current task instead requires this action: separate key custodianship and audit key usage.

Question 663

An RLS policy uses SESSION_CONTEXT set directly from untrusted request text. Which implementation decision BEST addresses this requirement?

  1. Verify RLS behavior under every service principal and prohibit unnecessary bypass roles.
  2. Use targeted audit groups and evaluate performance and retention costs.
  3. Derive tenant identity from verified authentication and tightly controlled session setup.
  4. Configure appropriate permission and role-change audit action groups.

Explanation

Correct Answer

C:

Derive tenant identity from verified authentication and tightly controlled session setup. This targets the primary issue because session context is only safe as an authorization input when callers cannot impersonate other tenants. Verification: A spoofed request cannot change access to another tenant's rows. Prevent recurrence: Reset pooled connections and validate context on each request.

Incorrect Answers

A:

Security enforcement must be tested with the exact executing principal.

B:

High-volume blanket logging can impact throughput and reveal sensitive inputs.

D:

Data read auditing does not automatically cover every administrative event.

Question 664

A deployment blindly INSERTs static country rows on every run and fails with duplicates. Which measurable outcome BEST verifies that the requirement is satisfied?

  1. Repository scans show no live credentials while seed records remain deterministic.
  2. A test release with a failing security check is blocked.
  3. Preflight reports match the authorized database identity and schema.
  4. Running the seed twice leaves the same validated rows.

Explanation

Correct Answer

D:

Running the seed twice leaves the same validated rows. This is the decisive observable evidence after implementing use idempotent keyed upserts or appropriate repeat-safe seed operations. It tests the underlying requirement: Repeatable deployments must not assume reference rows are absent.

Incorrect Answers

A:

Repository scans show no live credentials while seed records remain deterministic. However, that result would not establish the required outcome: running the seed twice leaves the same validated rows.

B:

A test release with a failing security check is blocked. However, that result would not establish the required outcome: running the seed twice leaves the same validated rows.

C:

Preflight reports match the authorized database identity and schema. However, that result would not establish the required outcome: running the seed twice leaves the same validated rows.

Question 665

An application expects a 64-bit vendor identifier but its SQL key column is INT and may overflow. Which technical property or constraint MOST directly matters here?

  1. An INT cannot represent IDs above its signed range.
  2. Binary floating-point approximations cannot represent every decimal currency value exactly.
  3. A default supplies a value on omission, not a guarantee against explicit bad values.
  4. Partitioning is most helpful when queries constrain the partition key.

Explanation

Correct Answer

A:

An INT cannot represent IDs above its signed range. This explains why the corrective action is to select BIGINT after modeling value range, foreign keys and migration effects. Confirm the diagnosis when high-ID inserts and all dependent joins work in migration tests.

Incorrect Answers

B:

Binary floating-point approximations cannot represent every decimal currency value exactly. The actual technical constraint is that an INT cannot represent IDs above its signed range.

C:

A default supplies a value on omission, not a guarantee against explicit bad values. The actual technical constraint is that an INT cannot represent IDs above its signed range.

D:

Partitioning is most helpful when queries constrain the partition key. The actual technical constraint is that an INT cannot represent IDs above its signed range.

Question 666

An order detail table is queried by CustomerId and CreatedAt and performs repeated full scans. Which preventive practice BEST addresses the underlying risk over time?

  1. Keep precision/scale decisions in schema review and financial regression tests.
  2. Measure write overhead and index usage before adopting more indexes.
  3. Keep statistics and partition maintenance procedures current.
  4. Use transactional change control and rehearse rollback.

Explanation

Correct Answer

B:

Measure write overhead and index usage before adopting more indexes. This guards against recurrence because a missing selective access path forces large table or clustered-index scans. The direct remediation is: Design a useful composite rowstore index with leading keys matching the filters and inspect the execution plan.

Incorrect Answers

A:

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

C:

Keep statistics and partition maintenance procedures current. The current task instead requires this action: measure write overhead and index usage before adopting more indexes.

D:

Use transactional change control and rehearse rollback. The current task instead requires this action: measure write overhead and index usage before adopting more indexes.

Question 667

A user asks for 'how to prevent late shipment penalties' but document text says 'service-level liquidated damages'. What should the SQL developer do FIRST to address the specific issue?

  1. Use indexed lexical/full-text or exact filter matching appropriate to the identifier.
  2. Evaluate performance with representative corpus size, concurrency and update rates.
  3. Use semantic vector retrieval to recognize conceptual meaning beyond exact words.
  4. Use exact token or punctuation-normalized full-text matching alone, without a semantic embedding or a curated synonym mapping.

Explanation

Correct Answer

C:

Use semantic vector retrieval to recognize conceptual meaning beyond exact words. This targets the primary issue because embedding search can retrieve related ideas even without matching literal tokens. Verification: The known penalty clause ranks in a held-out test query. Prevent recurrence: Keep source citations and authorization filtering.

Incorrect Answers

A:

Embedding similarity can confuse near-looking product codes that must match exactly.

B:

Small synthetic benchmarks understate index and memory behavior at scale.

D:

The query terms and contract language are conceptually related but not lexically identical. Exact token matching without a maintained synonym map does not reliably retrieve the "liquidated damages" clause.

Question 668

A Copilot MCP configuration points at a stale server with changed schema metadata. Which acceptance check is MOST directly related to this scenario?

  1. An audit shows requests use the intended approved endpoint.
  2. Migration rehearsal retains required tables and supports rollback.
  3. Test prompts contain representative synthetic values, not real identifiers.
  4. The session lists the current intended tools and returns valid metadata.

Explanation

Correct Answer

D:

The session lists the current intended tools and returns valid metadata. This is the decisive observable evidence after implementing update and validate the MCP connection and available tool schema in the client. It tests the underlying requirement: Tool discovery and endpoint configuration determine accessible operations.

Incorrect Answers

A:

An audit shows requests use the intended approved endpoint. However, that result would not establish the required outcome: the session lists the current intended tools and returns valid metadata.

B:

Migration rehearsal retains required tables and supports rollback. However, that result would not establish the required outcome: the session lists the current intended tools and returns valid metadata.

C:

Test prompts contain representative synthetic values, not real identifiers. However, that result would not establish the required outcome: the session lists the current intended tools and returns valid metadata.

Question 669

A product API caches inventory counts for an hour and customers see stale stock after orders. Which technical property or constraint MOST directly matters here?

  1. Response caching trades freshness for latency and may serve obsolete facts.
  2. Unbounded result sets waste bandwidth and can overload SQL and API memory.
  3. Configuration must resolve the correct database per environment without leaking secrets.
  4. Autoscaling the API does not eliminate downstream database exhaustion or unauthorized access.

Explanation

Correct Answer

A:

Response caching trades freshness for latency and may serve obsolete facts. This explains why the corrective action is to use an appropriate DAB cache TTL or disable cache for volatile inventory fields. Confirm the diagnosis when after a stock change, clients see updated counts within the defined freshness SLA.

Incorrect Answers

B:

Unbounded result sets waste bandwidth and can overload SQL and API memory. The actual technical constraint is that response caching trades freshness for latency and may serve obsolete facts.

C:

Configuration must resolve the correct database per environment without leaking secrets. The actual technical constraint is that response caching trades freshness for latency and may serve obsolete facts.

D:

Autoscaling the API does not eliminate downstream database exhaustion or unauthorized access. The actual technical constraint is that response caching trades freshness for latency and may serve obsolete facts.

Question 670

Queries filter millions of product rows by a JSON property and repeatedly scan payloads. Which preventive practice BEST addresses the underlying risk over time?

  1. Reject unknown fields and bound payload size before committing.
  2. Benchmark maintenance overhead and verify deployment-specific feature support.
  3. Do not treat allocation order as committed business transaction order.
  4. Keep statistics and partition maintenance procedures current.

Explanation

Correct Answer

B:

Benchmark maintenance overhead and verify deployment-specific feature support. This guards against recurrence because unindexed JSON path predicates can incur expensive row-by-row parsing. The direct remediation is: Evaluate supported JSON index or indexed computed-column path for that SQL platform and version.

Incorrect Answers

A:

Reject unknown fields and bound payload size before committing. The current task instead requires this action: benchmark maintenance overhead and verify deployment-specific feature support.

C:

Do not treat allocation order as committed business transaction order.

D:

Keep statistics and partition maintenance procedures current. The current task instead requires this action: benchmark maintenance overhead and verify deployment-specific feature support.

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