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 76

Question 750

A compliance team needs cryptographically verifiable evidence that ledger entries were not silently altered. Which preventive practice BEST addresses the underlying risk over time?

  1. Protect history access and plan retention and schema migration.
  2. Protect digests independently and audit administrative access.
  3. Use a dedicated serialized legal numbering process if gaplessness is mandatory.
  4. Monitor exhaustion and limit allocation rights.

Explanation

Correct Answer

B:

Protect digests independently and audit administrative access. This guards against recurrence because ledger tamper evidence supports verification; it does not prevent every privileged misuse. The direct remediation is: Assess SQL ledger tables with digest storage and verification controls.

Incorrect Answers

A:

Protect history access and plan retention and schema migration. The current task instead requires this action: protect digests independently and audit administrative access.

C:

Use a dedicated serialized legal numbering process if gaplessness is mandatory.

D:

Monitor exhaustion and limit allocation rights. The current task instead requires this action: protect digests independently and audit administrative access.

Question 751

A maintainer assumes instruction files guarantee that unsafe SQL will never be proposed. Which preventive practice BEST addresses the underlying risk over time?

  1. Version guidance with source code and test patterns.
  2. Protect branches with required security code review.
  3. Audit actual changes rather than counting prompt compliance.
  4. Revalidate Fabric feature availability when capacity policies change.

Explanation

Correct Answer

C:

Audit actual changes rather than counting prompt compliance. This guards against recurrence because prompt instructions influence suggestions but are not mandatory security policies. The direct remediation is: Keep static SQL checks, pull-request review and least-privilege deployment despite instructions.

Incorrect Answers

A:

Version guidance with source code and test patterns. The current task instead requires this action: audit actual changes rather than counting prompt compliance.

B:

Protect branches with required security code review. The current task instead requires this action: audit actual changes rather than counting prompt compliance.

D:

Revalidate Fabric feature availability when capacity policies change. The current task instead requires this action: audit actual changes rather than counting prompt compliance.

Question 752

A SQL-backed support catalog has reliable source records but its semantic-search index becomes stale whenever product descriptions change. Which engineering step should come first when designing a supported refresh path?

  1. Call the embedding API synchronously inside every OLTP transaction before inspecting change-processing options.
  2. Drop and recreate the external embedding model after every data change.
  3. Increase chunk size for all documents without tracking which source records changed.
  4. Identify a supported source-change signal such as Change Tracking, CDC or an applicable trigger binding, then plan a retry-safe embedding update worker.

Explanation

Correct Answer

D:

A supported change detector plus durable refresh processing addresses the real missing link between source edits and derived vectors.

Incorrect Answers

A:

A slow external call within each transaction can increase lock duration and couple database availability to model latency.

B:

Model-definition churn does not provide a robust source-change signal or reliable update ordering.

C:

Chunk-size tuning may alter retrieval quality but cannot detect edits or deletions in the source table.

Question 753

A build agent uses a local path outside the Git repository to load schema fragments. Which acceptance check is MOST directly related to this scenario?

  1. A clean clone builds the same schema model.
  2. DACPAC inspection contains the new approved procedure.
  3. Drift detection flags the unexpected column change before publish.
  4. A test environment with modified index triggers a drift report.

Explanation

Correct Answer

A:

A clean clone builds the same schema model. This is the decisive observable evidence after implementing move or reference supported source files in a reproducible repository layout. It tests the underlying requirement: Untracked local dependencies make CI builds nondeterministic.

Incorrect Answers

B:

DACPAC inspection contains the new approved procedure. However, that result would not establish the required outcome: a clean clone builds the same schema model.

C:

Drift detection flags the unexpected column change before publish. However, that result would not establish the required outcome: a clean clone builds the same schema model.

D:

A test environment with modified index triggers a drift report. However, that result would not establish the required outcome: a clean clone builds the same schema model.

Question 754

A developer expects to pass a table directly as the return scalar of a UDF. Which technical property or constraint MOST directly matters here?

  1. Optimizer visibility can differ between inline and multistatement TVFs.
  2. A scalar function returns a single value, whereas a TVF returns columns and rows.
  3. Parameterization separates user values from executable SQL syntax.
  4. Unclear resolution and parameter types create ambiguous deployment behavior.

Explanation

Correct Answer

B:

A scalar function returns a single value, whereas a TVF returns columns and rows. This explains why the corrective action is to define a table-valued return signature rather than a scalar type for multiple rows. Confirm the diagnosis when the function composes correctly in a FROM clause.

Incorrect Answers

A:

Optimizer visibility can differ between inline and multistatement TVFs. The actual technical constraint is that a scalar function returns a single value, whereas a TVF returns columns and rows.

C:

Parameterization separates user values from executable SQL syntax. The actual technical constraint is that a scalar function returns a single value, whereas a TVF returns columns and rows.

D:

Unclear resolution and parameter types create ambiguous deployment behavior. The actual technical constraint is that a scalar function returns a single value, whereas a TVF returns columns and rows.

Question 755

A tiny corpus of 800 embeddings requires deterministic exhaustive nearest-neighbor results. Which preventive practice BEST addresses the underlying risk over time?

  1. Maintain an exact KNN baseline for regression testing.
  2. Maintain population monitoring and language-specific word breakers.
  3. Reassess costs as the corpus grows.
  4. Validate runtime-specific function availability.

Explanation

Correct Answer

C:

Reassess costs as the corpus grows. This guards against recurrence because exact search compares the candidate vectors directly without ANN recall tradeoffs. The direct remediation is: Use exact KNN with a distance expression and top-k ordering.

Incorrect Answers

A:

Maintain an exact KNN baseline for regression testing. The current task instead requires this action: reassess costs as the corpus grows.

B:

Maintain population monitoring and language-specific word breakers. The current task instead requires this action: reassess costs as the corpus grows.

D:

Validating runtime-specific function availability addresses a different database behavior; the relevant distinction is that reassess costs as the corpus grows.

Question 756

A SQL vector search query produces results with reversed relevance due to sorting distances descending. Which technical action BEST resolves the primary problem?

  1. Generate query embeddings with the same approved model and dimension as the column.
  2. Align metric and model embedding guidance across index creation and query evaluation.
  3. Benchmark supported ANN index tuning and rebuild/retraining options against exact KNN results.
  4. Order an exact VECTOR_DISTANCE result ascending for nearest neighbors.

Explanation

Correct Answer

D:

Order an exact VECTOR_DISTANCE result ascending for nearest neighbors. This targets the primary issue because smaller distances represent closer vectors for common distance functions. Verification: Known nearest-neighbor fixtures appear first in the final order. Prevent recurrence: Test sorting after any metric change.

Incorrect Answers

A:

Generate query embeddings with the same approved model and dimension as the column. The relevant technical condition instead is that order an exact VECTOR_DISTANCE result ascending for nearest neighbors.

B:

Aligning metric and model embedding guidance across index creation and query evaluation addresses a different database behavior; the relevant distinction is that order an exact VECTOR_DISTANCE result ascending for nearest neighbors.

C:

Approximate structures trade memory, speed and recall depending on data and configuration.

Question 757

A security reviewer sees a scalar function attempting data modifications inside a SELECT. Which test result BEST demonstrates that the intended solution is working?

  1. A read-only function compiles while the separate write path has explicit authorization.
  2. A measured rewrite returns identical values with lower CPU.
  3. The function composes correctly in a FROM clause.
  4. Attack strings are treated as data and queries return only intended rows.

Explanation

Correct Answer

A:

A read-only function compiles while the separate write path has explicit authorization. This is the decisive observable evidence after implementing move the state-changing operation into an approved stored procedure or application transaction. It tests the underlying requirement: T-SQL UDFs have restrictions on side effects and cannot be arbitrary transactional commands.

Incorrect Answers

B:

A measured rewrite returns identical values with lower CPU. However, that result would not establish the required outcome: a read-only function compiles while the separate write path has explicit authorization.

C:

The function composes correctly in a FROM clause. However, that result would not establish the required outcome: a read-only function compiles while the separate write path has explicit authorization.

D:

Attack strings are treated as data and queries return only intended rows. However, that result would not establish the required outcome: a read-only function compiles while the separate write path has explicit authorization.

Question 758

An application hits a sequence maximum and cannot allocate more identifiers. Which technical principle BEST explains the relevant design decision?

  1. Sequence numbers can be consumed even when transactions roll back or cache is lost.
  2. Finite ranges exhaust and enabling CYCLE without safety checks may repeat identifiers.
  3. Metadata-based partition switching requires strict schema and partition alignment.
  4. Missing future boundaries force incoming values into the existing terminal partition.

Explanation

Correct Answer

B:

Finite ranges exhaust and enabling CYCLE without safety checks may repeat identifiers. This explains why the corrective action is to review SEQUENCE data type, MAXVALUE and cycle policy before changing generation. Confirm the diagnosis when a high-watermark test verifies continued unique allocation within supported limits.

Incorrect Answers

A:

Sequence numbers can be consumed even when transactions roll back or cache is lost. The actual technical constraint is that finite ranges exhaust and enabling CYCLE without safety checks may repeat identifiers.

C:

Metadata-based partition switching requires strict schema and partition alignment. The actual technical constraint is that finite ranges exhaust and enabling CYCLE without safety checks may repeat identifiers.

D:

Missing future boundaries force incoming values into the existing terminal partition. The actual technical constraint is that finite ranges exhaust and enabling CYCLE without safety checks may repeat identifiers.

Question 759

A security alert misses privileged ALTER ROLE operations because only SELECT activity is audited. Following remediation, what safeguard BEST prevents a repeat of this specific failure?

  1. Retain logs immutably where required and limit audit administrators.
  2. Rehearse key recovery and avoid distributing keys in scripts.
  3. Monitor audit health and gaps after version upgrades.
  4. Reset pooled connections and validate context on each request.

Explanation

Correct Answer

C:

Monitor audit health and gaps after version upgrades. This guards against recurrence because data read auditing does not automatically cover every administrative event. The direct remediation is: Configure appropriate permission and role-change audit action groups.

Incorrect Answers

A:

Retain logs immutably where required and limit audit administrators. The current task instead requires this action: monitor audit health and gaps after version upgrades.

B:

Rehearse key recovery and avoid distributing keys in scripts. The current task instead requires this action: monitor audit health and gaps after version upgrades.

D:

Reset pooled connections and validate context on each request. The current task instead requires this action: monitor audit health and gaps after version upgrades.

Question 760

An engineer applies RRF to scores normalized per request and calls it a rank-based algorithm. Which technical action BEST resolves the primary problem?

  1. Use RRF to reward documents ranking highly across multiple candidate lists.
  2. Use exact KNN with a distance expression and top-k ordering.
  3. Evaluate indexed ANN search with measured recall/latency tradeoffs.
  4. Compute ranks within each result list before applying reciprocal-rank contributions.

Explanation

Correct Answer

D:

Compute ranks within each result list before applying reciprocal-rank contributions. This targets the primary issue because RRF operates on list positions and is distinct from raw score interpolation. Verification: A simple manual calculation matches fusion output. Prevent recurrence: Keep rank offset and truncation policies documented.

Incorrect Answers

A:

Using RRF to reward documents ranking highly across multiple candidate lists addresses a different database behavior; the relevant distinction is that compute ranks within each result list before applying reciprocal-rank contributions.

B:

Exact search compares the candidate vectors directly without ANN recall tradeoffs.

C:

Approximate indexes trade exact completeness for faster retrieval on large corpora.

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