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 35

Question 340

Different reporting tools duplicate a sensitive sales join and occasionally disagree on calculations. Which technical principle BEST explains the relevant design decision?

  1. SCHEMABINDING protects referenced definitions against incompatible schema changes.
  2. SQL triggers run per statement and inserted can contain multiple rows.
  3. Nested or recursive trigger behavior can cause cycles and unexpected work.
  4. A view centralizes a query contract without storing a second copy by default.

Explanation

Correct Answer

D:

A view centralizes a query contract without storing a second copy by default. This explains why the corrective action is to create a governed view projecting the approved join and columns. Confirm the diagnosis when both tools return the same verified sales metric from the view.

Incorrect Answers

A:

SCHEMABINDING protects referenced definitions against incompatible schema changes. The actual technical constraint is that a view centralizes a query contract without storing a second copy by default.

B:

SQL triggers run per statement and inserted can contain multiple rows. The actual technical constraint is that a view centralizes a query contract without storing a second copy by default.

C:

Nested or recursive trigger behavior can cause cycles and unexpected work. The actual technical constraint is that a view centralizes a query contract without storing a second copy by default.

Question 341

A developer exposes a write-capable MCP database tool to an agent with no approval boundary. Following remediation, what safeguard BEST prevents a repeat of this specific failure?

  1. Keep a tool allowlist and capture authenticated invocations.
  2. Rate-limit expensive query shapes and monitor access logs.
  3. Review grants after schema migrations.
  4. Add rate limiting and request audit trails.

Explanation

Correct Answer

A:

Keep a tool allowlist and capture authenticated invocations. This guards against recurrence because agents can turn natural-language requests into real database mutations if tools permit. The direct remediation is: Scope MCP tool actions and require human confirmation for consequential changes.

Incorrect Answers

B:

Rate-limit expensive query shapes and monitor access logs. The current task instead requires this action: keep a tool allowlist and capture authenticated invocations.

C:

Reviewing grants after schema migrations would not correct following remediation, what safeguard BEST prevents a repeat of this specific failure. Keep a tool allowlist and capture authenticated invocations.

D:

Add rate limiting and request audit trails. The current task instead requires this action: keep a tool allowlist and capture authenticated invocations.

Question 342

A container app's managed identity can log in but cannot read the required database view. Which technical action BEST resolves the primary problem?

  1. Use Microsoft Entra-based managed identity authentication where supported.
  2. Create or map the appropriate principal and grant minimum SQL permissions.
  3. Review execution context and grant only required underlying object rights securely.
  4. Use Always Encrypted with keys managed outside the database and supported client drivers.

Explanation

Correct Answer

B:

Create or map the appropriate principal and grant minimum SQL permissions. This targets the primary issue because azure identity authentication and database authorization are distinct checks. Verification: The app reads the intended view but cannot read private financial objects. Prevent recurrence: Track principal creation across environments.

Incorrect Answers

A:

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

C:

Dynamic SQL may execute under a permission context different from static ownership chains.

D:

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

Question 343

A customer-support assistant must classify multilingual complaints with a small latency budget. What observed evidence would BEST confirm successful remediation?

  1. A labeled photo-and-text set yields correct asset annotations.
  2. All dependent procedures run in staging against the new model.
  3. Blind tests meet per-language quality and p95 response targets.
  4. An authorized test generates an embedding with the expected size.

Explanation

Correct Answer

C:

Blind tests meet per-language quality and p95 response targets. This is the decisive observable evidence after implementing evaluate multilingual compact and large models on representative language and latency benchmarks. It tests the underlying requirement: A larger model is not automatically the best fit for cost, speed or multilingual accuracy.

Incorrect Answers

A:

A labeled photo-and-text set yields correct asset annotations. However, that result would not establish the required outcome: blind tests meet per-language quality and p95 response targets.

B:

All dependent procedures run in staging against the new model. However, that result would not establish the required outcome: blind tests meet per-language quality and p95 response targets.

D:

An authorized test generates an embedding with the expected size. However, that result would not establish the required outcome: blind tests meet per-language quality and p95 response targets.

Question 344

A trigger on SalesLine inserts assumes only one row appears in inserted and updates one summary incorrectly. What is the MOST relevant technical distinction in this situation?

  1. Synchronous trigger work participates in the calling transaction and can increase latency.
  2. T-SQL UDFs have restrictions on side effects and cannot be arbitrary transactional commands.
  3. A scalar function produces one value for each call but may affect query optimization.
  4. SQL triggers run per statement and inserted can contain multiple rows.

Explanation

Correct Answer

D:

SQL triggers run per statement and inserted can contain multiple rows. This explains why the corrective action is to rewrite the DML trigger to handle the inserted/deleted pseudo-tables as sets. Confirm the diagnosis when a 50-row INSERT updates all required summary totals correctly.

Incorrect Answers

A:

Synchronous trigger work participates in the calling transaction and can increase latency. The actual technical constraint is that SQL triggers run per statement and inserted can contain multiple rows.

B:

T-SQL UDFs have restrictions on side effects and cannot be arbitrary transactional commands. The actual technical constraint is that SQL triggers run per statement and inserted can contain multiple rows.

C:

A scalar function produces one value for each call but may affect query optimization. The actual technical constraint is that SQL triggers run per statement and inserted can contain multiple rows.

Question 345

An app selects an enormous model for every short product tag and then exceeds budget. Which ongoing control is MOST relevant after the issue is fixed?

  1. Track model quality drift and escalation thresholds.
  2. Reject unexpected fields and never trust generated totals without validation.
  3. Keep source citations and access metadata attached.
  4. Review boundary cases during chunker changes.

Explanation

Correct Answer

A:

Track model quality drift and escalation thresholds. This guards against recurrence because model size increases cost and latency without guaranteeing proportional quality gains. The direct remediation is: Benchmark smaller models and route complex cases only when quality needs justify it.

Incorrect Answers

B:

Reject unexpected fields and never trust generated totals without validation.

C:

Keep source citations and access metadata attached. The current task instead requires this action: track model quality drift and escalation thresholds.

D:

Review boundary cases during chunker changes. The current task instead requires this action: track model quality drift and escalation thresholds.

Question 346

A billing schema is owned by finance but anyone in the repository can approve SQL changes. What is the MOST appropriate immediate corrective approach?

  1. Use protected branch triggers, environment approval gates and deployment-specific identities.
  2. Configure CODEOWNERS and required reviews for the finance database paths.
  3. Include an appropriate staged data migration and backfill before constraint enforcement.
  4. Compare live database schema against the project model before approval.

Explanation

Correct Answer

B:

Configure CODEOWNERS and required reviews for the finance database paths. This targets the primary issue because path ownership helps route high-impact DDL for accountable review. Verification: A billing SQL PR requires a finance-code-owner approval before merge. Prevent recurrence: Keep ownership mapping updated when teams change.

Incorrect Answers

A:

Using protected branch triggers, environment approval gates and deployment-specific identities would not correct a billing schema is owned by finance but anyone in the repository can approve SQL changes. Configure CODEOWNERS and required reviews for the finance database paths.

C:

Including an appropriate staged data migration and backfill before constraint enforcement would not correct a billing schema is owned by finance but anyone in the repository can approve SQL changes. Configure CODEOWNERS and required reviews for the finance database paths.

D:

Manual changes create drift between intended declarative source and deployed objects.

Question 347

A junior engineer accepts an AI-generated DROP TABLE migration without checking dependencies. What observed evidence would BEST confirm successful remediation?

  1. A security review finds no production secrets in prompt logs or history.
  2. A test tool call reads metadata while unauthorized writes are denied.
  3. Migration rehearsal retains required tables and supports rollback.
  4. The session lists the current intended tools and returns valid metadata.

Explanation

Correct Answer

C:

Migration rehearsal retains required tables and supports rollback. This is the decisive observable evidence after implementing review the generated diff, run it in an isolated test database, and require approval. It tests the underlying requirement: AI suggestions are proposals, not change-control authorization.

Incorrect Answers

A:

A security review finds no production secrets in prompt logs or history. However, that result would not establish the required outcome: migration rehearsal retains required tables and supports rollback.

B:

A test tool call reads metadata while unauthorized writes are denied. However, that result would not establish the required outcome: migration rehearsal retains required tables and supports rollback.

D:

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

Question 348

An Azure SQL procedure needs to send a controlled JSON prompt to an approved external model API. What is the MOST relevant technical distinction in this situation?

  1. An authorization error occurs before model inference can produce valid content.
  2. JSON encoding preserves numeric representation better than locale-dependent concatenation.
  3. Transport errors must be separated from valid inference responses.
  4. The stored procedure enables outbound HTTP but requires correct permissions, endpoint reachability and payload formatting.

Explanation

Correct Answer

D:

The stored procedure enables outbound HTTP but requires correct permissions, endpoint reachability and payload formatting. This explains why the corrective action is to build the request payload and call sp_invoke_external_rest_endpoint through a supported secure configuration. Confirm the diagnosis when a staging request returns the expected status and schema-valid response.

Incorrect Answers

A:

An authorization error occurs before model inference can produce valid content. The actual technical constraint is that the stored procedure enables outbound HTTP but requires correct permissions, endpoint reachability and payload formatting.

B:

JSON encoding preserves numeric representation better than locale-dependent concatenation. The actual technical constraint is that the stored procedure enables outbound HTTP but requires correct permissions, endpoint reachability and payload formatting.

C:

Transport errors must be separated from valid inference responses. The actual technical constraint is that the stored procedure enables outbound HTTP but requires correct permissions, endpoint reachability and payload formatting.

Question 349

A supplier feed sometimes sends malformed JSON in an otherwise valid text column. Which ongoing control is MOST relevant after the issue is fixed?

  1. Keep the supplier contract and dead-letter handling versioned.
  2. Reject unknown fields and bound payload size before committing.
  3. Keep precision/scale decisions in schema review and financial regression tests.
  4. Measure write overhead and index usage before adopting more indexes.

Explanation

Correct Answer

A:

Keep the supplier contract and dead-letter handling versioned. This guards against recurrence because malformed payloads can break downstream JSON_VALUE and OPENJSON processing. The direct remediation is: Validate JSON structure on ingestion using supported native JSON type or ISJSON checks where applicable.

Incorrect Answers

B:

Reject unknown fields and bound payload size before committing. The current task instead requires this action: keep the supplier contract and dead-letter handling versioned.

C:

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

D:

Measure write overhead and index usage before adopting more indexes.

Question 350

A publicly exposed DAB instance floods SQL with unauthenticated expensive read requests. Which implementation decision BEST addresses this requirement?

  1. Configure supported network access, managed identity and database permissions.
  2. Harden ingress, authentication, rate limiting and query bounds before production exposure.
  3. Use an appropriate DAB cache TTL or disable cache for volatile inventory fields.
  4. Configure DAB entity relationships with matching source/target keys.

Explanation

Correct Answer

B:

Harden ingress, authentication, rate limiting and query bounds before production exposure. This targets the primary issue because autoscaling the API does not eliminate downstream database exhaustion or unauthorized access. Verification: Load tests enforce limits and approved users retain service. Prevent recurrence: Use telemetry and abuse alerting across API and SQL.

Incorrect Answers

A:

Publishing the API does not grant the host network or SQL access automatically.

C:

Response caching trades freshness for latency and may serve obsolete facts.

D:

Correct GraphQL relationship metadata enables nested retrieval of related records.

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