Microsoft DP-800 Practice Test 68 - 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 68

Question 670

Two feature branches independently modify the same customer table and the merged migration accidentally drops a required column. What is the MOST appropriate initial remediation?

  1. Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity.
  2. Resolve schema conflicts with a model diff and tests before approving the combined pull request.
  3. Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment.
  4. Add end-to-end integration tests using compatible staged SQL schema and actual API configuration.

Explanation

Correct Answer

B:

Resolve schema conflicts with a model diff and tests before approving the combined pull request. Database merge conflicts can affect schema semantics beyond textual file overlap.

Incorrect Answers

A:

Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity. Database merge conflicts can affect schema semantics beyond textual file overlap. Resolve schema conflicts with a model diff and tests before approving the combined pull request.

C:

Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment. Database merge conflicts can affect schema semantics beyond textual file overlap. Resolve schema conflicts with a model diff and tests before approving the combined pull request.

D:

Add end-to-end integration tests using compatible staged SQL schema and actual API configuration. Database merge conflicts can affect schema semantics beyond textual file overlap. Resolve schema conflicts with a model diff and tests before approving the combined pull request.

Question 671

A legal research system chooses approximate nearest-neighbor search for speed but a small high-stakes sample requires exhaustive top-k accuracy. What distinction makes the recommended approach appropriate?

  1. Approximate search gains speed by accepting possible recall loss relative to exact search.
  2. Lexical and semantic relevance target different retrieval needs and are often complementary.
  3. Hybrid search can combine complementary lexical precision and semantic recall.
  4. Search quality depends on keeping index state synchronized with current vector records.

Explanation

Correct Answer

A:

Approximate search gains speed by accepting possible recall loss relative to exact search.

Incorrect Answers

B:

Lexical and semantic relevance target different retrieval needs and are often complementary. Approximate search gains speed by accepting possible recall loss relative to exact search.

C:

Hybrid search can combine complementary lexical precision and semantic recall. Approximate search gains speed by accepting possible recall loss relative to exact search.

D:

Search quality depends on keeping index state synchronized with current vector records. Approximate search gains speed by accepting possible recall loss relative to exact search.

Question 672

A batch embedding job calls a model endpoint without rate-limit handling and silently skips rows when throughput is exceeded. Which observation is the strongest evidence for the reported problem?

  1. Queries in one language miss conceptually matching incident notes written in another.
  2. Job logs show throttled responses while the completion report claims all records were embedded.
  3. The vector table retains deleted product entries and lacks vectors for recent updates.
  4. After endpoint upgrade structured responses no longer satisfy the application's JSON schema.

Explanation

Correct Answer

B:

Job logs show throttled responses while the completion report claims all records were embedded. Reliable embedding generation needs operational controls beyond issuing model requests.

Incorrect Answers

A:

Queries in one language miss conceptually matching incident notes written in another. Reliable embedding generation needs operational controls beyond issuing model requests. Job logs show throttled responses while the completion report claims all records were embedded.

C:

The vector table retains deleted product entries and lacks vectors for recent updates. Reliable embedding generation needs operational controls beyond issuing model requests. Job logs show throttled responses while the completion report claims all records were embedded.

D:

After endpoint upgrade structured responses no longer satisfy the application's JSON schema. Reliable embedding generation needs operational controls beyond issuing model requests. Job logs show throttled responses while the completion report claims all records were embedded.

Question 673

An invoice line table accepts a nonexistent invoice identifier and accounting totals include orphaned lines after imports. What distinction makes the recommended approach appropriate?

  1. Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses.
  2. Semi-structured JSON still needs deliberate schema validation and indexing for predictable filtering.
  3. Ledger features provide tamper-evidence verification but do not replace authorization or backups.
  4. Referential constraints express durable relationships more reliably than application-only checks.

Explanation

Correct Answer

D:

Referential constraints express durable relationships more reliably than application-only checks.

Incorrect Answers

A:

Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses. Referential constraints express durable relationships more reliably than application-only checks.

B:

Semi-structured JSON still needs deliberate schema validation and indexing for predictable filtering. Referential constraints express durable relationships more reliably than application-only checks.

C:

Ledger features provide tamper-evidence verification but do not replace authorization or backups. Referential constraints express durable relationships more reliably than application-only checks.

Question 674

A regulated app writes SQL audit logs to short-lived storage and a retention job removes investigation evidence before the mandated period. How should the SQL engineering team confirm the issue is truly resolved?

  1. Only approved fields are embedded and unauthorized users cannot retrieve protected source or embedding records.
  2. Unauthorized context switching is rejected and each user remains restricted to their approved tenant.
  3. The function processes authorized events while negative access tests deny unrelated tables.
  4. Test audit events remain retrievable and immutable for the required retention period.

Explanation

Correct Answer

D:

Test audit events remain retrievable and immutable for the required retention period. The operating rule is: Audit coverage is incomplete without secure durable retention and controlled access.

Incorrect Answers

A:

Only approved fields are embedded and unauthorized users cannot retrieve protected source or embedding records. The operating rule is: Audit coverage is incomplete without secure durable retention and controlled access. Test audit events remain retrievable and immutable for the required retention period.

B:

Unauthorized context switching is rejected and each user remains restricted to their approved tenant. The operating rule is: Audit coverage is incomplete without secure durable retention and controlled access. Test audit events remain retrievable and immutable for the required retention period.

C:

The function processes authorized events while negative access tests deny unrelated tables. The operating rule is: Audit coverage is incomplete without secure durable retention and controlled access. Test audit events remain retrievable and immutable for the required retention period.

Question 675

A SQL MCP tool returns a table comment that instructs an AI coding assistant to read a secret table and send data to another endpoint. Choose TWO statements: a suitable intervention and evidence of its success.

  1. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.
  2. The assistant ignores the embedded command and logs no attempt to access the secret table.
  3. A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure.
  4. Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis.
  5. Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls.

Explanation

Correct Answers

B:

The assistant ignores the embedded command and logs no attempt to access the secret table. Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls.

E:

Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls.

Incorrect Answers

A:

Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution. Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls. The assistant ignores the embedded command and logs no attempt to access the secret table.

C:

A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure. Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls. The assistant ignores the embedded command and logs no attempt to access the secret table.

D:

Treat the suggestion as untrusted code and require code review, data access tests, and execution plan analysis. Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls. The assistant ignores the embedded command and logs no attempt to access the secret table.

Question 676

An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests. Which TWO options together specify a corrective step and a meaningful test?

  1. Design appropriate cache freshness and invalidation semantics for the business price lifecycle.
  2. Allowed requests invoke the intended procedure and crafted SQL payloads are rejected.
  3. Restrict exposed fields and filtering operations to approved entity properties.
  4. Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging.
  5. A test request can be traced across API and SQL dependencies to the failing span.

Explanation

Correct Answers

D:

Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging. An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests.

E:

A test request can be traced across API and SQL dependencies to the failing span. An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests. Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging.

Incorrect Answers

A:

Design appropriate cache freshness and invalidation semantics for the business price lifecycle. An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests. Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging.

B:

Allowed requests invoke the intended procedure and crafted SQL payloads are rejected. An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests. A test request can be traced across API and SQL dependencies to the failing span.

C:

Restrict exposed fields and filtering operations to approved entity properties. An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests. Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging.

Question 677

An AI-enabled SQL workflow calls a model service with an API key stored in a database object accessible to developers. How should the SQL engineering team confirm the issue is truly resolved?

  1. Test audit events remain retrievable and immutable for the required retention period.
  2. The application connects with its scoped identity while no reusable database password is stored in code.
  3. Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers.
  4. The web application runs normal queries while an attempted schema modification is denied.

Explanation

Correct Answer

C:

Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers. The supporting symptom is: Source inspection exposes a credential that can invoke the model service outside the approved workflow.

Incorrect Answers

A:

Test audit events remain retrievable and immutable for the required retention period. The supporting symptom is: Source inspection exposes a credential that can invoke the model service outside the approved workflow. Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers.

B:

The application connects with its scoped identity while no reusable database password is stored in code. The supporting symptom is: Source inspection exposes a credential that can invoke the model service outside the approved workflow. Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers.

D:

The web application runs normal queries while an attempted schema modification is denied. The supporting symptom is: Source inspection exposes a credential that can invoke the model service outside the approved workflow. Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers.

Question 678

A multilingual knowledge base stores English-only embeddings and assumes a translated query produces equivalent relevance in all supported locales. What distinction makes the recommended approach appropriate?

  1. Full-text search provides token-aware retrieval beyond ordinary substring filters.
  2. Vector semantic performance is model and language dependent, not guaranteed by storing numbers.
  3. Typed vector storage is preferable to ad hoc serialization when supported by the SQL engine.
  4. Hybrid search can combine complementary lexical precision and semantic recall.

Explanation

Correct Answer

B:

Vector semantic performance is model and language dependent, not guaranteed by storing numbers.

Incorrect Answers

A:

Full-text search provides token-aware retrieval beyond ordinary substring filters. Vector semantic performance is model and language dependent, not guaranteed by storing numbers.

C:

Typed vector storage is preferable to ad hoc serialization when supported by the SQL engine. Vector semantic performance is model and language dependent, not guaranteed by storing numbers.

D:

Hybrid search can combine complementary lexical precision and semantic recall. Vector semantic performance is model and language dependent, not guaranteed by storing numbers.

Question 679

A fraud analyst stores account-device links in graph tables but manually joins three edge tables to detect accounts connected through a shared device. What distinction makes the recommended approach appropriate?

  1. Native JSON functions help create valid structured output instead of fragile manual string concatenation.
  2. MATCH expresses graph patterns across documented node and edge relationships.
  3. Regex substitution supports structured redaction only when patterns are thoroughly validated.
  4. Window offset functions simplify ordered comparisons but do not create missing time periods.

Explanation

Correct Answer

B:

MATCH expresses graph patterns across documented node and edge relationships.

Incorrect Answers

A:

Native JSON functions help create valid structured output instead of fragile manual string concatenation. MATCH expresses graph patterns across documented node and edge relationships.

C:

Regex substitution supports structured redaction only when patterns are thoroughly validated. MATCH expresses graph patterns across documented node and edge relationships.

D:

Window offset functions simplify ordered comparisons but do not create missing time periods. MATCH expresses graph patterns across documented node and edge relationships.

Question 680

A semantic search service compares embedding vectors with inconsistent magnitudes and treats raw dot-product scores as comparable cosine similarity. What should the database developer do FIRST within approved procedures?

  1. Use a supported SQL vector type with dimension compatibility checks and an appropriate data design.
  2. Align index metric, query scoring, and model expectations; validate on labeled relevant pairs.
  3. Apply an appropriate normalization strategy such as VECTOR_NORMALIZE and verify the chosen similarity metric.
  4. Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate.

Explanation

Correct Answer

C:

Apply an appropriate normalization strategy such as VECTOR_NORMALIZE and verify the chosen similarity metric. Vector normalization and distance metrics must be consistent across indexing and querying.

Incorrect Answers

A:

Use a supported SQL vector type with dimension compatibility checks and an appropriate data design. Vector normalization and distance metrics must be consistent across indexing and querying. Apply an appropriate normalization strategy such as VECTOR_NORMALIZE and verify the chosen similarity metric.

B:

Align index metric, query scoring, and model expectations; validate on labeled relevant pairs. Vector normalization and distance metrics must be consistent across indexing and querying. Apply an appropriate normalization strategy such as VECTOR_NORMALIZE and verify the chosen similarity metric.

D:

Review supported filter placement and retrieve enough authorized candidates before ranking as appropriate. Vector normalization and distance metrics must be consistent across indexing and querying. Apply an appropriate normalization strategy such as VECTOR_NORMALIZE and verify the chosen similarity metric.

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