Microsoft DP-800 Practice Test 72 - Prepaway
Practice Exams:

Pass Microsoft DP-800 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!

30 Days Free Updates, Instant Download!

Verified By Experts
Premium File
$69.99 $76.99

DP-800 Premium ETE File


  • Premium File 101 Questions & Answers. Last Update: Nov 06, 2026
Whats Included:
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

Microsoft DP-800 Practice Test 72

Question 710

A developer commits an Azure SQL connection string with a password into a pipeline YAML and then deletes the line after review. Which next step most directly resolves this SQL solution issue?

  1. Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment.
  2. Version reference data in a reviewed idempotent deployment process with migration tests.
  3. Resolve schema conflicts with a model diff and tests before approving the combined pull request.
  4. Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity.

Explanation

Correct Answer

D:

Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity. Deleting a committed secret does not remove the exposure or replace credential rotation.

Incorrect Answers

A:

Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment. Deleting a committed secret does not remove the exposure or replace credential rotation. Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity.

B:

Version reference data in a reviewed idempotent deployment process with migration tests. Deleting a committed secret does not remove the exposure or replace credential rotation. Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity.

C:

Resolve schema conflicts with a model diff and tests before approving the combined pull request. Deleting a committed secret does not remove the exposure or replace credential rotation. Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity.

Question 711

A semantic search endpoint scans every vector on each request even when the dataset has grown to millions of chunks. Which technical principle explains the correct response?

  1. Hybrid search can combine complementary lexical precision and semantic recall.
  2. Indexed vector search trades computation and index behavior against recall and resource cost.
  3. Search quality depends on keeping index state synchronized with current vector records.
  4. Search evaluation needs relevance metrics rather than simple nonempty result counts.

Explanation

Correct Answer

B:

Indexed vector search trades computation and index behavior against recall and resource cost.

Incorrect Answers

A:

Hybrid search can combine complementary lexical precision and semantic recall. Indexed vector search trades computation and index behavior against recall and resource cost.

C:

Search quality depends on keeping index state synchronized with current vector records. Indexed vector search trades computation and index behavior against recall and resource cost.

D:

Search evaluation needs relevance metrics rather than simple nonempty result counts. Indexed vector search trades computation and index behavior against recall and resource cost.

Question 712

A GraphQL API maps customer and invoice tables and a consumer can ask for sensitive fields not shown in the application UI. What would be a valid post-database-change verification?

  1. Modified client filters cannot expand the account's authorized row scope.
  2. A test privilege change creates a protected timestamped audit record tied to the correct identity.
  3. The rotation completes without lost access and recovered data can still be decrypted by authorized services.
  4. Unapproved GraphQL fields remain unavailable while normal approved queries operate.

Explanation

Correct Answer

D:

Unapproved GraphQL fields remain unavailable while normal approved queries operate.

Incorrect Answers

A:

Modified client filters cannot expand the account's authorized row scope. Unapproved GraphQL fields remain unavailable while normal approved queries operate.

B:

A test privilege change creates a protected timestamped audit record tied to the correct identity. Unapproved GraphQL fields remain unavailable while normal approved queries operate.

C:

The rotation completes without lost access and recovered data can still be decrypted by authorized services. Unapproved GraphQL fields remain unavailable while normal approved queries operate.

Question 713

An API accepts arbitrary malformed JSON in a text field and downstream reporting intermittently fails during JSON parsing. Choose TWO: one correct response and one verification of success.

  1. Design date-aligned partitions and a tested retention or sliding-window maintenance procedure.
  2. Use a suitable native JSON type or a validity check supported on the target database engine.
  3. Add supported CHECK and DEFAULT constraints consistent with the application contract.
  4. The revised schema supports required searches while reducing unnecessary storage and migration burden.
  5. Malformed inputs are rejected and valid representative payloads remain queryable.

Explanation

Correct Answers

B:

Use a suitable native JSON type or a validity check supported on the target database engine.

E:

Malformed inputs are rejected and valid representative payloads remain queryable. Use a suitable native JSON type or a validity check supported on the target database engine.

Incorrect Answers

A:

Design date-aligned partitions and a tested retention or sliding-window maintenance procedure. Use a suitable native JSON type or a validity check supported on the target database engine.

C:

Add supported CHECK and DEFAULT constraints consistent with the application contract. Use a suitable native JSON type or a validity check supported on the target database engine. Malformed inputs are rejected and valid representative payloads remain queryable.

D:

The revised schema supports required searches while reducing unnecessary storage and migration burden. Use a suitable native JSON type or a validity check supported on the target database engine. Malformed inputs are rejected and valid representative payloads remain queryable.

Question 714

A pipeline uses a shared administrator password to publish SQL Database Project changes to multiple production databases. How should the SQL engineering team confirm the issue is truly resolved?

  1. CI produces a valid model and catches an intentional missing-object reference.
  2. Deployment succeeds only for its intended environment while cross-environment tests fail safely.
  3. Unauthorized test principals receive access-denied errors while application queries still work.
  4. A fresh CI agent restores required references and builds the same model reproducibly.

Explanation

Correct Answer

B:

Deployment succeeds only for its intended environment while cross-environment tests fail safely. A pipeline uses a shared administrator password to publish SQL Database Project changes to multiple production databases.

Incorrect Answers

A:

CI produces a valid model and catches an intentional missing-object reference. A pipeline uses a shared administrator password to publish SQL Database Project changes to multiple production databases. Deployment succeeds only for its intended environment while cross-environment tests fail safely.

C:

Unauthorized test principals receive access-denied errors while application queries still work. A pipeline uses a shared administrator password to publish SQL Database Project changes to multiple production databases. Deployment succeeds only for its intended environment while cross-environment tests fail safely.

D:

A fresh CI agent restores required references and builds the same model reproducibly. A pipeline uses a shared administrator password to publish SQL Database Project changes to multiple production databases. Deployment succeeds only for its intended environment while cross-environment tests fail safely.

Question 715

A legal research system chooses approximate nearest-neighbor search for speed but a small high-stakes sample requires exhaustive top-k accuracy. What would be a valid post-database-change verification?

  1. A pre-insert check identifies incompatible vectors and routes them to repair before indexing.
  2. A benchmark reaches minimum relevant top-k hit rates while respecting service latency.
  3. The selected retrieval method meets the required accuracy and response-time targets for each workload.
  4. Results remain relevant and exclude ineligible inventory under tested status changes.

Explanation

Correct Answer

C:

The selected retrieval method meets the required accuracy and response-time targets for each workload. A legal research system chooses approximate nearest-neighbor search for speed but a small high-stakes sample requires exhaustive top-k accuracy.

Incorrect Answers

A:

A pre-insert check identifies incompatible vectors and routes them to repair before indexing. A legal research system chooses approximate nearest-neighbor search for speed but a small high-stakes sample requires exhaustive top-k accuracy. The selected retrieval method meets the required accuracy and response-time targets for each workload.

B:

A benchmark reaches minimum relevant top-k hit rates while respecting service latency. A legal research system chooses approximate nearest-neighbor search for speed but a small high-stakes sample requires exhaustive top-k accuracy. The selected retrieval method meets the required accuracy and response-time targets for each workload.

D:

Results remain relevant and exclude ineligible inventory under tested status changes. A legal research system chooses approximate nearest-neighbor search for speed but a small high-stakes sample requires exhaustive top-k accuracy. The selected retrieval method meets the required accuracy and response-time targets for each workload.

Question 716

An SQL-based RAG procedure sends hundreds of long retrieved chunks to a model and becomes expensive while often omitting the most relevant clauses due to context limits. What should the database developer do FIRST within approved procedures?

  1. Require an explicit evidence threshold and safe refusal or escalation when retrieval finds no current supporting clause.
  2. Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention.
  3. Bound and rerank retrieved context, preserve meaningful chunk metadata, and benchmark answer coverage.
  4. Implement retrieval-augmented generation using approved current SQL policy records with source citations.

Explanation

Correct Answer

C:

Bound and rerank retrieved context, preserve meaningful chunk metadata, and benchmark answer coverage. RAG context assembly trades completeness, relevance, cost, and model window constraints.

Incorrect Answers

A:

Require an explicit evidence threshold and safe refusal or escalation when retrieval finds no current supporting clause. RAG context assembly trades completeness, relevance, cost, and model window constraints. Bound and rerank retrieved context, preserve meaningful chunk metadata, and benchmark answer coverage.

B:

Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention. RAG context assembly trades completeness, relevance, cost, and model window constraints. Bound and rerank retrieved context, preserve meaningful chunk metadata, and benchmark answer coverage.

D:

Implement retrieval-augmented generation using approved current SQL policy records with source citations. RAG context assembly trades completeness, relevance, cost, and model window constraints. Bound and rerank retrieved context, preserve meaningful chunk metadata, and benchmark answer coverage.

Question 717

An AI-enabled SQL workflow calls a model service with an API key stored in a database object accessible to developers. What is the MOST appropriate initial remediation?

  1. Grant the function only the change-data access it requires and review its output destination.
  2. Configure appropriate SQL auditing to a protected destination with tested retention and access reviews.
  3. Apply service authentication, tool allowlists, scoped SQL permissions, and approval for state changes.
  4. Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers.

Explanation

Correct Answer

D:

Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers. Model endpoints are security-sensitive downstream services and credentials must be governed.

Incorrect Answers

A:

Grant the function only the change-data access it requires and review its output destination. Model endpoints are security-sensitive downstream services and credentials must be governed. Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers.

B:

Configure appropriate SQL auditing to a protected destination with tested retention and access reviews. Model endpoints are security-sensitive downstream services and credentials must be governed. Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers.

C:

Apply service authentication, tool allowlists, scoped SQL permissions, and approval for state changes. Model endpoints are security-sensitive downstream services and credentials must be governed. Choose an approved managed identity access route for the model endpoint where supported and restrict configuration readers.

Question 718

A developer attaches a Fabric lakehouse MCP endpoint to a chat that also has access to multiple confidential workspaces. Choose TWO: one correct response and one verification of success.

  1. Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis.
  2. Tests confirm exact expected totals for refunds, null values, and normal billing records.
  3. Scope the connector to approved lakehouse data and verify the selected identity and workspace permissions.
  4. The tool returns only approved lakehouse metadata and rejects unauthorized workspace access.
  5. Verify tenant/workspace enablement, permissions, and responsible AI policy before configuring Copilot in Fabric.

Explanation

Correct Answers

C:

Scope the connector to approved lakehouse data and verify the selected identity and workspace permissions. The tool returns only approved lakehouse metadata and rejects unauthorized workspace access.

D:

The tool returns only approved lakehouse metadata and rejects unauthorized workspace access. The accompanying action is to scope the connector to approved lakehouse data and verify the selected identity and workspace permissions.

Incorrect Answers

A:

Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis. The tool returns only approved lakehouse metadata and rejects unauthorized workspace access. Scope the connector to approved lakehouse data and verify the selected identity and workspace permissions.

B:

Tests confirm exact expected totals for refunds, null values, and normal billing records. The tool returns only approved lakehouse metadata and rejects unauthorized workspace access. Scope the connector to approved lakehouse data and verify the selected identity and workspace permissions.

E:

Verify tenant/workspace enablement, permissions, and responsible AI policy before configuring Copilot in Fabric. The tool returns only approved lakehouse metadata and rejects unauthorized workspace access. Scope the connector to approved lakehouse data and verify the selected identity and workspace permissions.

Question 719

A payment archive table grows monthly and retention jobs currently delete millions of old rows while blocking online activity. What technical finding would substantiate this root cause?

  1. A direct SQL write bypasses the front-end validator and saves invalid guest counts.
  2. Investigators cannot determine what preference was effective before the latest update from the current table.
  3. A test privacy request removes the active row while its personal fields remain in the historical table.
  4. A purge test causes long blocking and log growth against the single large heap.

Explanation

Correct Answer

D:

A purge test causes long blocking and log growth against the single large heap. Partitioning can make range maintenance practical when keys and boundaries match retention policy.

Incorrect Answers

A:

A direct SQL write bypasses the front-end validator and saves invalid guest counts. Partitioning can make range maintenance practical when keys and boundaries match retention policy. A purge test causes long blocking and log growth against the single large heap.

B:

Investigators cannot determine what preference was effective before the latest update from the current table. Partitioning can make range maintenance practical when keys and boundaries match retention policy. A purge test causes long blocking and log growth against the single large heap.

C:

A test privacy request removes the active row while its personal fields remain in the historical table. Partitioning can make range maintenance practical when keys and boundaries match retention policy. A purge test causes long blocking and log growth against the single large heap.

Question 720

A database contains product-description embeddings and needs to calculate distances to an incoming query vector over a small reference sample. Which concept should guide the database developer in this situation?

  1. Hybrid search can combine complementary lexical precision and semantic recall.
  2. Vector metadata validation prevents mixing incompatible representations in search structures.
  3. Vector distance functions compare numeric embedding representations, not lexical JSON text.
  4. Indexed vector search trades computation and index behavior against recall and resource cost.

Explanation

Correct Answer

C:

Vector distance functions compare numeric embedding representations, not lexical JSON text.

Incorrect Answers

A:

Hybrid search can combine complementary lexical precision and semantic recall. Vector distance functions compare numeric embedding representations, not lexical JSON text.

B:

Vector metadata validation prevents mixing incompatible representations in search structures. Vector distance functions compare numeric embedding representations, not lexical JSON text.

D:

Indexed vector search trades computation and index behavior against recall and resource cost. Vector distance functions compare numeric embedding representations, not lexical JSON text.

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