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 16

Question 150

An Azure SQL table contains textual cases but the vector column is always NULL. What observed evidence would BEST confirm successful remediation?

  1. A throttled test recovers without duplicate vector records or budget spikes.
  2. Test rows contain supported dimension vectors and corresponding text IDs.
  3. A bilingual test set retrieves correct permitted items for each locale.
  4. Updated products receive new embeddings within the freshness SLA.

Explanation

Correct Answer

B:

Test rows contain supported dimension vectors and corresponding text IDs. This is the decisive observable evidence after implementing call the approved embedding model through a supported integration and store fixed-dimension results. It tests the underlying requirement: Embeddings are computed numeric representations and are not created merely by defining a VECTOR column.

Incorrect Answers

A:

A throttled test recovers without duplicate vector records or budget spikes. However, that result would not establish the required outcome: test rows contain supported dimension vectors and corresponding text IDs.

C:

A bilingual test set retrieves correct permitted items for each locale. However, that result would not establish the required outcome: test rows contain supported dimension vectors and corresponding text IDs.

D:

Updated products receive new embeddings within the freshness SLA. However, that result would not establish the required outcome: test rows contain supported dimension vectors and corresponding text IDs.

Question 151

A mobile application needs standard resource CRUD with query-string filters rather than a custom GraphQL client. What is the MOST relevant technical distinction in this situation?

  1. The two interfaces expose related data but have different query syntax and operation models.
  2. Configuration must resolve the correct database per environment without leaking secrets.
  3. REST endpoint mapping supplies predictable URLs and HTTP operations.
  4. Syntactic JSON validity alone does not prove a mapped SQL object exists.

Explanation

Correct Answer

C:

REST endpoint mapping supplies predictable URLs and HTTP operations. This explains why the corrective action is to expose an authorized DAB REST endpoint with approved methods and resource paths. Confirm the diagnosis when GET/PATCH tests enforce intended roles and return expected status codes.

Incorrect Answers

A:

The two interfaces expose related data but have different query syntax and operation models. The actual technical constraint is that REST endpoint mapping supplies predictable URLs and HTTP operations.

B:

Configuration must resolve the correct database per environment without leaking secrets. The actual technical constraint is that REST endpoint mapping supplies predictable URLs and HTTP operations.

D:

Syntactic JSON validity alone does not prove a mapped SQL object exists. The actual technical constraint is that REST endpoint mapping supplies predictable URLs and HTTP operations.

Question 152

A managed Azure SQL database experiences variable latency but no server-level OS metrics are available. Which ongoing control is MOST relevant after the issue is fixed?

  1. Measure regressions before using hints or recompilation globally.
  2. Monitor version store and update conflicts.
  3. Document isolation assumptions in critical transaction code.
  4. Combine query data with Azure Monitor and service limits.

Explanation

Correct Answer

D:

Combine query data with Azure Monitor and service limits. This guards against recurrence because platform-native query insight tools expose historical workload statistics for managed instances. The direct remediation is: Use Query Performance Insight and supported Azure/SQL monitoring evidence.

Incorrect Answers

A:

Measure regressions before using hints or recompilation globally. The current task instead requires this action: combine query data with Azure Monitor and service limits.

B:

Monitor version store and update conflicts. The current task instead requires this action: combine query data with Azure Monitor and service limits.

C:

Document isolation assumptions in critical transaction code. The current task instead requires this action: combine query data with Azure Monitor and service limits.

Question 153

A team grants db_owner to a reporting account expecting DDM to hide confidential salaries. What is the MOST appropriate immediate corrective approach?

  1. Replace excessive privileges with minimum SELECT and no UNMASK entitlement.
  2. Combine masking with column permissions and other controls based on actual threat model.
  3. Grant narrowly scoped schema/DDL permissions to its nonproduction identity.
  4. Use targeted audit groups and evaluate performance and retention costs.

Explanation

Correct Answer

A:

Replace excessive privileges with minimum SELECT and no UNMASK entitlement. This targets the primary issue because high-privilege identities can typically view underlying unmasked values. Verification: A role-based test demonstrates restricted account values are masked. Prevent recurrence: Audit schema role memberships after every release.

Incorrect Answers

B:

Authorized query transformations and inference can expose sensitive values despite masking.

C:

Database roles and schema grants can bound an automation's change surface.

D:

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

Question 154

A service treats HTTP 429 from a model as permanent data corruption and deletes pending records. Which measurable outcome BEST verifies that the requirement is satisfied?

  1. Representative requests fit allowed size and retain necessary evidence.
  2. A throttled test eventually succeeds or leaves a recoverable queue record.
  3. An API test reads amounts with correct decimal interpretation.
  4. The computed amount matches audited ledger SQL exactly.

Explanation

Correct Answer

B:

A throttled test eventually succeeds or leaves a recoverable queue record. This is the decisive observable evidence after implementing implement bounded retry/backoff with idempotency and dead-letter handling. It tests the underlying requirement: Rate limiting is often transient and should not erase durable database work.

Incorrect Answers

A:

Representative requests fit allowed size and retain necessary evidence. However, that result would not establish the required outcome: a throttled test eventually succeeds or leaves a recoverable queue record.

C:

An API test reads amounts with correct decimal interpretation. However, that result would not establish the required outcome: a throttled test eventually succeeds or leaves a recoverable queue record.

D:

The computed amount matches audited ledger SQL exactly. However, that result would not establish the required outcome: a throttled test eventually succeeds or leaves a recoverable queue record.

Question 155

A new index exists in a branch but production queries still use the prior plan. Which technical reason BEST explains the proposed correction?

  1. Existing data can prevent otherwise valid stricter schema changes.
  2. Optional checks fail to enforce controls during urgent releases.
  3. Changing project source alone does not apply DDL to the deployed database.
  4. A declarative project can validate database object definitions before deployment.

Explanation

Correct Answer

C:

Changing project source alone does not apply DDL to the deployed database. This explains why the corrective action is to build/publish the reviewed SQL Database Project to the intended target with verification. Confirm the diagnosis when after publish, the target contains the intended index and tested workload improves.

Incorrect Answers

A:

Existing data can prevent otherwise valid stricter schema changes. The actual technical constraint is that changing project source alone does not apply DDL to the deployed database.

B:

Optional checks fail to enforce controls during urgent releases. The actual technical constraint is that changing project source alone does not apply DDL to the deployed database.

D:

A declarative project can validate database object definitions before deployment. The actual technical constraint is that changing project source alone does not apply DDL to the deployed database.

Question 156

A SQL chat assistant needs to read schema metadata but must never issue UPDATE statements. What maintenance or governance control BEST reduces recurrence of this problem?

  1. Maintain a controlled model catalog and audit changes.
  2. Do not grant production DDL permissions directly to AI tools.
  3. Use data-classification and DLP controls on AI-assisted development.
  4. Review grants and server capabilities after updates.

Explanation

Correct Answer

D:

Review grants and server capabilities after updates. This guards against recurrence because tool scope governs what the model can invoke beyond ordinary chat text. The direct remediation is: Configure MCP tools with read-only permissions and disable unneeded write-capable tools.

Incorrect Answers

A:

Maintain a controlled model catalog and audit changes. The current task instead requires this action: review grants and server capabilities after updates.

B:

Do not grant production DDL permissions directly to AI tools.

C:

Use data-classification and DLP controls on AI-assisted development. The current task instead requires this action: review grants and server capabilities after updates.

Question 157

A contractor supplies an unknown MCP server URL that advertises unrestricted database tools. Which implementation decision BEST addresses this requirement?

  1. Reject the endpoint until source, TLS identity and tool effects are reviewed.
  2. Check the configured workspace identity, connector permissions and supported MCP authentication.
  3. Add repository-level Copilot instructions documenting schema conventions and examples.
  4. Remove secret references from instructions and require environment-injected credentials.

Explanation

Correct Answer

A:

Reject the endpoint until source, TLS identity and tool effects are reviewed. This targets the primary issue because a malicious or compromised MCP server may exfiltrate data or supply unsafe tool behavior. Verification: Only the allowlisted server appears and controlled test queries succeed. Prevent recurrence: Manage server allowlists and revoke unused tokens.

Incorrect Answers

B:

MCP access to a lakehouse is constrained by Fabric and identity permissions.

C:

Persistent instruction files help shape suggestions but do not enforce compiler constraints.

D:

Instructions are prompt context and can unintentionally expose confidential values.

Question 158

A developer assumes a CTE named in one statement remains available to the next statement. Which measurable outcome BEST verifies that the requirement is satisfied?

  1. A small hierarchy returns all reachable descendants once under expected rules.
  2. A two-step transformation runs without invalid-object errors.
  3. A test discovers the expected connected device chain.
  4. Known two-hop links are retrieved without unrelated reverse links.

Explanation

Correct Answer

B:

A two-step transformation runs without invalid-object errors. This is the decisive observable evidence after implementing repeat the expression or persist intermediate results in a temporary table when necessary. It tests the underlying requirement: A CTE scope is limited to the single consuming statement.

Incorrect Answers

A:

A small hierarchy returns all reachable descendants once under expected rules. However, that result would not establish the required outcome: a two-step transformation runs without invalid-object errors.

C:

A test discovers the expected connected device chain. However, that result would not establish the required outcome: a two-step transformation runs without invalid-object errors.

D:

Known two-hop links are retrieved without unrelated reverse links. However, that result would not establish the required outcome: a two-step transformation runs without invalid-object errors.

Question 159

A security team treats DDM as protection against users with broad SELECT and inference query rights. Which technical reason BEST explains the proposed correction?

  1. High-privilege identities can typically view underlying unmasked values.
  2. RLS enforces row filtering in the database rather than relying on every query to remember a filter.
  3. Authorized query transformations and inference can expose sensitive values despite masking.
  4. Repository history retains secrets even after a visible commit is removed.

Explanation

Correct Answer

C:

Authorized query transformations and inference can expose sensitive values despite masking. This explains why the corrective action is to combine masking with column permissions and other controls based on actual threat model. Confirm the diagnosis when a simulated low-privilege role cannot infer restricted personal identifiers.

Incorrect Answers

A:

High-privilege identities can typically view underlying unmasked values. The actual technical constraint is that authorized query transformations and inference can expose sensitive values despite masking.

B:

RLS enforces row filtering in the database rather than relying on every query to remember a filter. The actual technical constraint is that authorized query transformations and inference can expose sensitive values despite masking.

D:

Repository history retains secrets even after a visible commit is removed. The actual technical constraint is that authorized query transformations and inference can expose sensitive values despite masking.

Question 160

A stored procedure passes DECIMAL prices as unquoted strings with locale commas and model summaries misstate values. What maintenance or governance control BEST reduces recurrence of this problem?

  1. Enforce outbound allowlists and unit tests for fields.
  2. Keep business arithmetic outside uncontrolled model generation.
  3. Log safe diagnostics and maintain circuit-breaker policy.
  4. Compare model output to authoritative SQL totals.

Explanation

Correct Answer

D:

Compare model output to authoritative SQL totals. This guards against recurrence because JSON encoding preserves numeric representation better than locale-dependent concatenation. The direct remediation is: Serialize numeric SQL types as valid JSON numbers with explicit unit metadata.

Incorrect Answers

A:

Enforce outbound allowlists and unit tests for fields. The current task instead requires this action: compare model output to authoritative SQL totals.

B:

Keep business arithmetic outside uncontrolled model generation. The current task instead requires this action: compare model output to authoritative SQL totals.

C:

Log safe diagnostics and maintain circuit-breaker policy. The current task instead requires this action: compare model output to authoritative SQL totals.

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