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 78

Question 770

A pipeline deploys to production immediately after any branch push. Which technical reason BEST explains the proposed correction?

  1. Path ownership helps route high-impact DDL for accountable review.
  2. Automated execution without authorization can promote unreviewed schema changes.
  3. Repeatable deployments must not assume reference rows are absent.
  4. A text merge can compile but still change business behavior.

Explanation

Correct Answer

B:

Automated execution without authorization can promote unreviewed schema changes. This explains why the corrective action is to use protected branch triggers, environment approval gates and deployment-specific identities. Confirm the diagnosis when unapproved branch commits never reach production.

Incorrect Answers

A:

Path ownership helps route high-impact DDL for accountable review. The actual technical constraint is that automated execution without authorization can promote unreviewed schema changes.

C:

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

D:

A text merge can compile but still change business behavior. The actual technical constraint is that automated execution without authorization can promote unreviewed schema changes.

Question 771

An AI completion recommends sending full customer rows to a third-party LLM for debugging. What maintenance or governance control BEST reduces recurrence of this problem?

  1. Do not grant production DDL permissions directly to AI tools.
  2. Record feature enablement and organizational restrictions.
  3. Use data-classification and DLP controls on AI-assisted development.
  4. Review extension policy and entitlements quarterly.

Explanation

Correct Answer

C:

Use data-classification and DLP controls on AI-assisted development. This guards against recurrence because development convenience does not override privacy, residency or retention duties. The direct remediation is: Mask or synthesize sensitive data and confirm approved data-handling contracts.

Incorrect Answers

A:

Do not grant production DDL permissions directly to AI tools.

B:

Record feature enablement and organizational restrictions. The current task instead requires this action: use data-classification and DLP controls on AI-assisted development.

D:

Review extension policy and entitlements quarterly. The current task instead requires this action: use data-classification and DLP controls on AI-assisted development.

Question 772

A pull request contains table renames and a developer approves it using only line counts. Which implementation decision BEST addresses this requirement?

  1. Enforce protected branches and required pull-request approvals.
  2. Pin supported SDK/project package versions and restore dependencies before build.
  3. Move or reference supported source files in a reproducible repository layout.
  4. Review migration impact, data retention and dependent object behavior before approval.

Explanation

Correct Answer

D:

Review migration impact, data retention and dependent object behavior before approval. This targets the primary issue because DDL diffs have operational consequences beyond text formatting. Verification: A staging publish preserves expected historical data and references. Prevent recurrence: Use deployment reports and rollback planning for destructive changes.

Incorrect Answers

A:

Branch policies are governance controls that prevent unreviewed deployment inputs.

B:

SDK-style builds depend on resolved tooling and compatible target platforms.

C:

Moving or reference supported source files in a reproducible repository layout would not correct a pull request contains table renames and a developer approves it using only line counts. Review migration impact, data retention and dependent object behavior before approval.

Question 773

A developer routes a confidential schema prompt through an unapproved external model selection. Which measurable outcome BEST verifies that the requirement is satisfied?

  1. An audit shows requests use the intended approved endpoint.
  2. A test tool call reads metadata while unauthorized writes are denied.
  3. Generated examples show placeholders and approved secret references.
  4. A test completion appears under an authorized developer identity.

Explanation

Correct Answer

A:

An audit shows requests use the intended approved endpoint. This is the decisive observable evidence after implementing select an organization-approved model and review data-routing settings before sending schema text. It tests the underlying requirement: Different model endpoints can have different data governance and retention arrangements.

Incorrect Answers

B:

A test tool call reads metadata while unauthorized writes are denied. However, that result would not establish the required outcome: an audit shows requests use the intended approved endpoint.

C:

Generated examples show placeholders and approved secret references. However, that result would not establish the required outcome: an audit shows requests use the intended approved endpoint.

D:

A test completion appears under an authorized developer identity. However, that result would not establish the required outcome: an audit shows requests use the intended approved endpoint.

Question 774

Two writers use rowversion checks but ignore the affected-row count on UPDATE. Which technical reason BEST explains the proposed correction?

  1. A read-then-write race can oversell without a concurrency constraint.
  2. Optimistic concurrency only works if conflicts are detected, not silently overwritten.
  3. Access path and estimated cardinality changes can explain runtime degradation.
  4. Opposite lock acquisition sequences can form a cyclic wait.

Explanation

Correct Answer

B:

Optimistic concurrency only works if conflicts are detected, not silently overwritten. This explains why the corrective action is to require an expected rowversion predicate and verify rows affected before confirming success. Confirm the diagnosis when a stale client receives a conflict and cannot overwrite the newer row.

Incorrect Answers

A:

A read-then-write race can oversell without a concurrency constraint. The actual technical constraint is that optimistic concurrency only works if conflicts are detected, not silently overwritten.

C:

Access path and estimated cardinality changes can explain runtime degradation. The actual technical constraint is that optimistic concurrency only works if conflicts are detected, not silently overwritten.

D:

Opposite lock acquisition sequences can form a cyclic wait. The actual technical constraint is that optimistic concurrency only works if conflicts are detected, not silently overwritten.

Question 775

A customer API returns all 500,000 sales rows in one response and clients time out. What maintenance or governance control BEST reduces recurrence of this problem?

  1. Document invalidation and avoid caching sensitive responses incorrectly.
  2. Version the API contract and publish schema changes responsibly.
  3. Use consistent ordering and monitor costly filters.
  4. Disallow unneeded mutation verbs and log requests.

Explanation

Correct Answer

C:

Use consistent ordering and monitor costly filters. This guards against recurrence because unbounded result sets waste bandwidth and can overload SQL and API memory. The direct remediation is: Configure controlled pagination, sorting and maximum page size for the DAB entity.

Incorrect Answers

A:

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

B:

Version the API contract and publish schema changes responsibly. The current task instead requires this action: use consistent ordering and monitor costly filters.

D:

Disallow unneeded mutation verbs and log requests. The current task instead requires this action: use consistent ordering and monitor costly filters.

Question 776

A developer swallows every SQL exception and returns success to upstream callers. Which implementation decision BEST addresses this requirement?

  1. Make transaction operations idempotent using a stable request ID and uniqueness constraints.
  2. Validate acyclic parent relationships and bound recursion depth.
  3. Include an explicit window ORDER BY with unique tie-breaker columns.
  4. Use CATCH to log safely and rethrow meaningful failures rather than masking them.

Explanation

Correct Answer

D:

Use CATCH to log safely and rethrow meaningful failures rather than masking them. This targets the primary issue because silently suppressed exceptions create false evidence of committed work. Verification: A simulated constraint error reaches the caller with no false success. Prevent recurrence: Avoid logging secrets or raw customer payloads.

Incorrect Answers

A:

Transient retries can replay committed work even after client-side timeouts.

B:

A cycle can repeatedly regenerate the same nodes in a recursive CTE.

C:

Window ranking order is defined by its OVER clause, not the outer result sort.

Question 777

A report uses a scalar function on every row and has unexpected CPU cost. Which acceptance check is MOST directly related to this scenario?

  1. A measured rewrite returns identical values with lower CPU.
  2. A read-only function compiles while the separate write path has explicit authorization.
  3. A test UPDATE completes once with expected values and no recursion error.
  4. Attack strings are treated as data and queries return only intended rows.

Explanation

Correct Answer

A:

A measured rewrite returns identical values with lower CPU. This is the decisive observable evidence after implementing inspect the function execution mode and consider set-based expressions or eligible scalar UDF inlining. It tests the underlying requirement: Per-row scalar function calls may create expensive repeated execution on some workloads.

Incorrect Answers

B:

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

C:

A test UPDATE completes once with expected values and no recursion error. However, that result would not establish the required outcome: a measured rewrite returns identical values with lower CPU.

D:

Attack strings are treated as data and queries return only intended rows. However, that result would not establish the required outcome: a measured rewrite returns identical values with lower CPU.

Question 778

Several related tables need unique identifiers from one coordinated numeric source. Which technical property or constraint MOST directly matters here?

  1. Sequence numbers can be consumed even when transactions roll back or cache is lost.
  2. A sequence can allocate numbers independently of one table identity property.
  3. A default supplies a value on omission, not a guarantee against explicit bad values.
  4. Binary floating-point approximations cannot represent every decimal currency value exactly.

Explanation

Correct Answer

B:

A sequence can allocate numbers independently of one table identity property. This explains why the corrective action is to use a shared SQL SEQUENCE with NEXT VALUE FOR in supported database environments. Confirm the diagnosis when concurrent inserts receive nonconflicting sequence-generated identifiers.

Incorrect Answers

A:

Sequence numbers can be consumed even when transactions roll back or cache is lost. The actual technical constraint is that a sequence can allocate numbers independently of one table identity property.

C:

A default supplies a value on omission, not a guarantee against explicit bad values. The actual technical constraint is that a sequence can allocate numbers independently of one table identity property.

D:

Binary floating-point approximations cannot represent every decimal currency value exactly. The actual technical constraint is that a sequence can allocate numbers independently of one table identity property.

Question 779

A team wants a readable multi-step T-SQL query that filters and then aggregates customer orders. Which preventive practice BEST addresses the underlying risk over time?

  1. Implement graph integrity checks on writes.
  2. Limit traversal depth and track source/target referential rules.
  3. Inspect plans when a CTE is referenced repeatedly.
  4. Specify ordering when supported and required by consumers.

Explanation

Correct Answer

C:

Inspect plans when a CTE is referenced repeatedly. This guards against recurrence because a CTE improves query readability but is not automatically materialized into a persistent table. The direct remediation is: Use a nonrecursive CTE as a named query expression in the next SELECT.

Incorrect Answers

A:

Implement graph integrity checks on writes. The current task instead requires this action: inspect plans when a CTE is referenced repeatedly.

B:

Limit traversal depth and track source/target referential rules. The current task instead requires this action: inspect plans when a CTE is referenced repeatedly.

D:

Specify ordering when supported and required by consumers. The current task instead requires this action: inspect plans when a CTE is referenced repeatedly.

Question 780

A REST client needs filtering on a public product type but must never filter private margin columns. What should the SQL developer do FIRST to address the specific issue?

  1. Configure controlled pagination, sorting and maximum page size for the DAB entity.
  2. Map the database view as a DAB entity and restrict permitted operations.
  3. Create and validate a supported DAB JSON configuration with connection and entity definitions.
  4. Configure entity fields, authorization and supported filter behavior to expose only permitted fields.

Explanation

Correct Answer

D:

Configure entity fields, authorization and supported filter behavior to expose only permitted fields. This targets the primary issue because DAB entity projection and permissions determine the API data surface. Verification: A permitted category filter works but margin fields remain inaccessible. Prevent recurrence: Audit API surface after schema changes.

Incorrect Answers

A:

Unbounded result sets waste bandwidth and can overload SQL and API memory.

B:

Mapping a view can create a governed projection with narrower permissions than base tables.

C:

DAB generates endpoints from explicit configuration rather than automatically exposing every table.

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