mcAfee Secure Website
exam =5
exam =6

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

Reliable & Actual Study Materials for DP-800 Exam Success

101 Questions & Answers with Testing Engine

"DP-800: Developing AI-Enabled Database Solutions" Testing Engine covers all the knowledge points of the real Microsoft DP-800 exam.

The latest actual DP-800 Questions & Answers from Pass4sure. Everything you need to prepare and get best score at DP-800 exam easily and quickly.

exam =7
Guarantee

Satisfaction Guaranteed

Pass4sure has a remarkable Microsoft Candidate Success record. We're confident of our products and provide no hassle product exchange. That's how confident we are!

99.3% Pass Rate
Was: $137.49
Now: $124.99

Microsoft DP-800 Practice Test 20

Question 190

An internal chatbot must answer HR policy questions only from current approved company documents. The team implemented this change: Retrieve tenant-authorized current chunks and supply citations in a constrained prompt. Which result would best confirm the change worked?

  1. Responses cite correct active passages or abstain when evidence is missing.
  2. Accept a cited policy paragraph even after that document was revoked or superseded.
  3. Mark a helpful-sounding policy response correct even when its quoted paragraph cannot be found.
  4. Accept links that open a homepage while the answer quotes unsupported policy amounts.

Explanation

Correct Answer

A:

Responses cite correct active passages or abstain when evidence is missing. Retrieval-augmented generation grounds model output in retrieved authorized policy passages. RAG can still hallucinate or misinterpret retrieved evidence.

Incorrect Answers

B:

RAG inputs must be both current and authorized; high relevance cannot rehabilitate retired or inaccessible policy text.

C:

Every material policy claim should trace to an approved passage; insufficient evidence requires abstention or escalation.

D:

Grounding requires exact-source attribution, authorized retrieval and source-to-claim correspondence. The key condition is “Responses cite correct active passages or abstain when evidence is missing.”.

Question 191

Anonymous users appear to inherit a data API builder admin role because token role claims were mapped incorrectly. The team implemented this change: Fix claim validation and map only trusted application roles to allowed operations. Which result would best confirm the change worked?

  1. Anonymous and lower-role tests fail to perform restricted mutations.
  2. Verify that an admin-labeled request succeeds while never testing anonymous and low-privilege callers.
  3. Treat a successful anonymous GET as proof that anonymous POST and DELETE are denied.
  4. Confirm the backend can connect to SQL without exercising any forbidden API operation.

Explanation

Correct Answer

A:

Anonymous and lower-role tests fail to perform restricted mutations. API authorization relies on validated token claims and explicit mapping to backend permissions. A valid token is not equivalent to authorization for every exposed entity.

Incorrect Answers

B:

Caller-controlled role strings are not trusted authorization; token validation and explicit entity/action grants must be enforced.

C:

Public reads and privileged mutations are distinct actions; anonymous operations require independent deny tests and minimal grants.

D:

Backend connectivity does not establish caller identity or entity authorization; effective DAB role and least-privilege restrictions must be tested.

Question 192

A microservice opens a new SQL connection for every request and saturates login resources during bursts. The team implemented this change: Enable bounded pooling with sensible backoff and transaction hygiene. Which result would best confirm the change worked?

  1. Single-client SQL queries stay below the normal latency target.
  2. The initial connection burst finishes without errors during a short smoke test.
  3. At least one reconnect succeeds during a high-rate retry storm.
  4. Load tests show stable connection counts and fewer connection failures.

Explanation

Correct Answer

D:

Load tests show stable connection counts and fewer connection failures. Connection pooling reuses authenticated sessions and can reduce repeated connection overhead. Excessively large pools can overwhelm the SQL server.

Incorrect Answers

A:

That observation could pass while the problem persists: Connection creation and pool caps are distinct resource limits; test reuse, backoff and load distribution.

B:

This acceptance test measures the wrong outcome: Pooling requires correct lifecycle hygiene; leaks and open transactions still starve the pool.

C:

The suggested success signal is inadequate because Bounded pooling, jitter and backoff are needed to avoid amplifying SQL connection saturation. The suggested measurement would appear successful even in a reproducible case where the original failure remains.

Question 193

A role has GRANT SELECT but one user receives access denied due to another inherited DENY. Initial testing shows: Intended principal reads approved objects while unrelated access remains denied. Which limitation should the team still consider?

  1. SQL effective permissions are determined by a single direct grant, independent of other principals.
  2. Removing a DENY cannot alter access to other objects granted through inherited roles.
  3. Execution context never changes effective SQL permission evaluation.
  4. Broad removal of DENY can expose data through other inherited grants.

Explanation

Correct Answer

D:

Broad removal of DENY can expose data through other inherited grants. Effective SQL permissions combine principals and may be affected by explicit DENY. Remove conflicting unneeded role membership or redesign least-privilege grants safely.

Incorrect Answers

A:

Permissions combine direct and inherited memberships and explicit DENY; inspect effective rights.

B:

Fix the precise role conflict while keeping unrelated denied objects and principles protected.

C:

Validate under the actual principal, roles, module context and relevant GRANT/DENY sources. The genuine residual limitation is: Broad removal of DENY can expose data through other inherited grants.

Question 194

A service needs to run two reporting procedures but currently has db_owner permission. The team proposes this approach: Revoke broad roles and grant only approved module-level permissions. Which technical principle supports this approach?

  1. A reporting user with a limited SELECT grant cannot modify tables even when also a db_owner member.
  2. Database object-level EXECUTE and SELECT grants can narrow rights compared with broad ownership.
  3. Hiding write buttons in an application prevents a db_owner SQL identity from making direct destructive calls.
  4. GRANT EXECUTE on selected reports must be paired with membership in db_owner to resolve table dependencies.

Explanation

Correct Answer

B:

Database object-level EXECUTE and SELECT grants can narrow rights compared with broad ownership. New workflows may fail until grants are deliberately reviewed.

Incorrect Answers

A:

That explanation assumes the wrong technical cause: SQL effective permissions include roles and inherited grants; explicitly remove broad ownership and test denied mutations.

C:

The proposed mechanism is not sufficient because UI controls do not revoke backend permissions; enforce least privilege directly in SQL and verify it.

D:

This inference does not follow from the SQL or service behavior: Module execution context and bounded object grants can provide approved work without db_owner privileges. The stated assumption would still allow the documented defect to occur, so it cannot explain why the proposed fix works.

Question 195

A department rotates encryption keys but mistakenly assumes database ciphertext will be automatically rewritten for every scheme. The team proposes this approach: Plan an approved rotation including backup and re-encryption steps where necessary. Which technical principle supports this approach?

  1. Changing a key metadata label causes all existing database ciphertext to be reencrypted automatically.
  2. Every SQL encryption feature uses the same rotation procedure and re-encrypts data at the same layer.
  3. Encryption key rotation requires feature-specific metadata and sometimes data re-encryption procedures.
  4. A successful new-value encryption proves every legacy row is recoverable after deleting old key material.

Explanation

Correct Answer

C:

Encryption key rotation requires feature-specific metadata and sometimes data re-encryption procedures. Premature deletion of old keys can permanently block recovery of stored data.

Incorrect Answers

A:

That explanation assumes the wrong technical cause: Rotation must follow the scheme-specific key hierarchy and may need key rewrap or data re-encryption and rollback.

B:

The proposed mechanism is not sufficient because TDE, column keys and client-side Always Encrypted have distinct hierarchies and supported migration contracts.

D:

This inference does not follow from the SQL or service behavior: Recovery and migration must be tested against old and new values before revoking previous decryption capacity. The stated assumption would still allow the documented defect to occur, so it cannot explain why the proposed fix works.

Question 196

A SQL schema change is forward-only because historical customer data has been transformed. The team is considering this step: Plan a corrective migration with backups, dry run and explicit recovery criteria. What evidence should they review before proceeding?

  1. Assess reversibility, backup state, restore time and data contract.
  2. Inspect only the reverse DDL script and omit transformed historical customer data and the recovery point.
  3. Examine only whether yesterday’s backup exists and ignore transactions accepted since it was taken.
  4. Read only the new schema catalog and omit applications still bound to the older column contract.

Explanation

Correct Answer

A:

Assess reversibility, backup state, restore time and data contract. Some database migrations require tested rollforward correction rather than naive rollback.

Incorrect Answers

B:

This evidence check would miss the central issue: Schema rollback cannot reconstruct discarded transformations; plan corrective rollforward and tested recovery.

C:

The proposed diagnostic comparison leaves a gap: Recovery needs explicit RPO/RTO, post-backup reconciliation and rehearsal; rollforward may be safer.

D:

Such observations do not establish the required mechanism: Review application/data contracts and use staged evolution when mixed versions can run during rollout. The candidate check cannot distinguish the required state from a superficial symptom, and so does not justify the proposed change.

Question 197

Service calls time out while CPU remains low and many sessions wait on locks. The team is considering this step: Find and correct the blocking transaction or query with approved procedures. What evidence should they review before proceeding?

  1. Inspect active requests, blocking session IDs, long-running transactions and locks.
  2. Collect only CPU utilization and omit blocking_session_id, waits and transaction state.
  3. Check only the count of active SQL sessions, not the actual blocking chain or locked object.
  4. Review historic execution time averages but omit current lock resources and pending transactions.

Explanation

Correct Answer

A:

Inspect active requests, blocking session IDs, long-running transactions and locks. DMVs can expose blocking sessions, wait types and transaction states.

Incorrect Answers

B:

This evidence check would miss the central issue: Blocking is about lock ownership and transaction lifetime; inspect DMVs/wait chains before changes.

C:

The proposed diagnostic comparison leaves a gap: Use request/transaction DMVs and waiting-resource evidence; termination may trigger lengthy rollback.

D:

Such observations do not establish the required mechanism: Execution-plan analysis can complement lock investigation but does not substitute for live wait and blocker evidence. The candidate check cannot distinguish the required state from a superficial symptom, and so does not justify the proposed change.

Question 198

An API payload contains a JSON array of product lines that must become relational rows. Which implementation step most directly addresses this requirement?

  1. Parse with OPENJSON and explicit typed column mappings in an isolated staging step.
  2. Store each incoming product-line JSON array as one unvalidated NVARCHAR row and defer relational mapping indefinitely.
  3. Rely on implicit conversion from every JSON quantity string to SQL INT, ignoring malformed values and error handling.
  4. Flatten the product-line JSON array with string splitting on commas rather than parse element objects and keys.

Explanation

Correct Answer

A:

OPENJSON can expand array elements into rows with a WITH schema. Parse with OPENJSON and explicit typed column mappings in an isolated staging step. Every valid line item maps to the expected row and rejected input is logged.

Incorrect Answers

B:

The downstream SQL process needs one typed row per product line. Use OPENJSON typed mappings and controlled staging.

C:

Explicit typed mapping and rejected-input logging are required; malformed numeric quantities may fail conversion.

D:

Commas may occur inside JSON strings and do not preserve object structure. Parse product-line objects using JSON-aware rowset functions.

Question 199

Two customers book the final seat at the same moment and both see success. The team implemented this change: Make seat decrement/reservation atomic under appropriate isolation with retry. Which result would best confirm the change worked?

  1. Demonstrate that each customer's request succeeds independently with one seat left in separate test runs.
  2. Measure 99th-percentile booking latency while accepting two committed reservations for the same final seat.
  3. Count rejected API requests after load without reconciling committed bookings with the remaining seat inventory.
  4. Concurrent test produces at most one successful final-seat booking.

Explanation

Correct Answer

D:

Concurrent test produces at most one successful final-seat booking. SERIALIZABLE or an equivalent atomic update can enforce business invariants under concurrency.

Incorrect Answers

A:

Isolated runs do not create the simultaneous contention needed to detect final-seat overbooking.

B:

Good latency is not a substitute for the exclusivity invariant; the test must establish a single successful winner.

C:

Rejection counts may reflect timeouts rather than data correctness; reconcile outcomes with the seat ledger.

Question 200

The NoticeEvents table may contain NULL recipient identifiers. A team proposes a correlated NOT EXISTS query to find users without a matching required-notice delivery. Why is this safer than an unguarded NOT IN over recipient identifiers?

  1. NOT IN silently ignores all NULL values in its subquery before testing users.
  2. NOT EXISTS needs only the notice code; correlation to each outer user is unnecessary.
  3. NOT EXISTS tests for the absence of rows satisfying its correlated predicates, avoiding NOT IN's NULL-sensitive unknown result.
  4. Counting any notice received by a user proves that the particular required notice was received.

Explanation

Correct Answer

C:

For each user, the correlated subquery checks whether a delivery row matching that user and notice exists. NOT EXISTS is based on the existence of such rows, whereas NOT IN can yield UNKNOWN when its subquery includes NULL.

Incorrect Answers

A:

A NULL in the NOT IN result set can make comparisons UNKNOWN, preventing expected unmatched rows from being returned. The operator does not automatically discard NULLs.

B:

Without a recipient correlation, NOT EXISTS tests the whole table for the notice rather than absence for the current user; it can return all users or none.

D:

An unrelated notice is not proof that this user received the mandated notice. The predicate must include the required notice code and delivery condition.

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