Pass Microsoft DP-800 Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers!
30 Days Free Updates, Instant Download!
Microsoft DP-800 Practice Test 70
Question 690
A help-desk knowledge table is updated frequently but its embeddings are only generated during an initial import, leaving search results stale. Which TWO options together specify a corrective step and a meaningful test?
Explanation
Correct Answers
A changed row's embedding is refreshed within the accepted time window and old results no longer dominate. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.
Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.
Incorrect Answers
Version the model configuration and compare outputs, latency, and contracts before controlled replacement. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records. A changed row's embedding is refreshed within the accepted time window and old results no longer dominate.
A staged migration passes regression benchmarks and retains a clear rollback route. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records. A changed row's embedding is refreshed within the accepted time window and old results no longer dominate.
Design section-aware chunks with appropriate overlap and metadata, then measure answer evidence coverage. Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records.
Question 691
A developer asks a coding assistant to optimize a stored procedure and accepts generated SQL that removes a tenant filter to improve latency. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
A negative tenant-access test fails safely while approved queries retain correct row scope and performance.
Incorrect Answers
A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure. A negative tenant-access test fails safely while approved queries retain correct row scope and performance.
The assistant ignores the embedded command and logs no attempt to access the secret table. A negative tenant-access test fails safely while approved queries retain correct row scope and performance.
The assisted workflow operates against the expected test environment and refuses unapproved production operations. A negative tenant-access test fails safely while approved queries retain correct row scope and performance.
Question 692
A team switches between hosted models in a coding assistant and assumes all model endpoints have identical data handling terms. Which TWO options together specify a corrective step and a meaningful test?
Explanation
Correct Answers
Review each configured model's data processing, retention, region, and tenant policy before sending SQL schema or examples.
Approved sessions use an allowed endpoint and unapproved configurations are blocked or corrected. Review each configured model's data processing, retention, region, and tenant policy before sending SQL schema or examples.
Incorrect Answers
New suggestions follow the documented conventions and still pass independent pull-request review. Review each configured model's data processing, retention, region, and tenant policy before sending SQL schema or examples. Approved sessions use an allowed endpoint and unapproved configurations are blocked or corrected.
Replace live values with safe synthetic examples and enforce repository secret and privacy scanning. Review each configured model's data processing, retention, region, and tenant policy before sending SQL schema or examples.
Compare recommendations with actual workload plans, maintenance costs, and performance tests before approval. Review each configured model's data processing, retention, region, and tenant policy before sending SQL schema or examples.
Question 693
A SQL-based document assistant splits contracts every fixed number of characters and frequently separates a clause from its exception and heading. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
A test query retrieves complete relevant clause context and the answer cites the exception. A SQL-based document assistant splits contracts every fixed number of characters and frequently separates a clause from its exception and heading.
Incorrect Answers
The model returns schema-valid fields with acceptable extraction accuracy and appropriate human review. A SQL-based document assistant splits contracts every fixed number of characters and frequently separates a clause from its exception and heading. A test query retrieves complete relevant clause context and the answer cites the exception.
Database transactions remain available during a model outage and embeddings catch up after recovery. A SQL-based document assistant splits contracts every fixed number of characters and frequently separates a clause from its exception and heading. A test query retrieves complete relevant clause context and the answer cites the exception.
A reconciled manifest shows every eligible record has a valid versioned embedding or a tracked error. A SQL-based document assistant splits contracts every fixed number of characters and frequently separates a clause from its exception and heading. A test query retrieves complete relevant clause context and the answer cites the exception.
Question 694
A pricing service caches DAB responses but customers continue receiving superseded prices after a time-sensitive promotion update. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Caching must respect correctness and freshness requirements for mutable business records.
Incorrect Answers
Change event streaming separates producer tables from subscriber access when correctly configured. Caching must respect correctness and freshness requirements for mutable business records.
Data API builder configuration determines service surface and must follow least-privilege exposure. Caching must respect correctness and freshness requirements for mutable business records.
GraphQL relationships need explicit API modeling beyond raw relational keys. Caching must respect correctness and freshness requirements for mutable business records.
Question 695
A multiyear events table is partitioned by event date but a nonaligned reporting index makes partition switching unexpectedly difficult. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
Index alignment and constraints are part of a working partition-maintenance design.
Incorrect Answers
Database constraints enforce integrity across multiple clients rather than relying solely on user interfaces. Index alignment and constraints are part of a working partition-maintenance design.
Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone. Index alignment and constraints are part of a working partition-maintenance design.
Temporal history tracks row versions for point-in-time inspection rather than relying on audit guesses. Index alignment and constraints are part of a working partition-maintenance design.
Question 696
A finance team wants governed SQL access to source files outside its operational database without importing a fresh copy for every query. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
Nightly copies drift from the source and duplicate storage increases each reporting cycle. External tables can expose remote data logically while preserving data-location and access considerations.
Incorrect Answers
Integrity checks identify line rows with identifiers missing from the invoice parent table. External tables can expose remote data logically while preserving data-location and access considerations. Nightly copies drift from the source and duplicate storage increases each reporting cycle.
Repeated JSON field extraction dominates CPU and the plan scans the entire case table. External tables can expose remote data logically while preserving data-location and access considerations. Nightly copies drift from the source and duplicate storage increases each reporting cycle.
Storage inspection finds most optional attribute columns are NULL in nearly every row. External tables can expose remote data logically while preserving data-location and access considerations. Nightly copies drift from the source and duplicate storage increases each reporting cycle.
Question 697
A developer stores embeddings as comma-separated NVARCHAR values and converts them on every search operation. Which technical principle explains the correct response?
Explanation
Correct Answer
Typed vector storage is preferable to ad hoc serialization when supported by the SQL engine.
Incorrect Answers
Vector retrieval must not bypass the same row-level authorization as ordinary SQL queries. Typed vector storage is preferable to ad hoc serialization when supported by the SQL engine.
Vector indexes must apply consistent distance semantics from training evaluation to retrieval. Typed vector storage is preferable to ad hoc serialization when supported by the SQL engine.
Vector distance functions compare numeric embedding representations, not lexical JSON text. Typed vector storage is preferable to ad hoc serialization when supported by the SQL engine.
Question 698
A team deploys DAB behind a gateway and assumes the backend is safe because the gateway normally authenticates users. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
Direct unauthenticated calls fail while gateway-routed authorized traffic succeeds. The supporting symptom is: A test can call the DAB backend URL directly without the gateway's identity checks.
Incorrect Answers
The endpoint rejects unapproved filters and returns correct authorized shipment matches. The supporting symptom is: A test can call the DAB backend URL directly without the gateway's identity checks. Direct unauthenticated calls fail while gateway-routed authorized traffic succeeds.
An authorized nested query returns correct variants while excluded records remain inaccessible. The supporting symptom is: A test can call the DAB backend URL directly without the gateway's identity checks. Direct unauthenticated calls fail while gateway-routed authorized traffic succeeds.
The published API exposes only the expected shipment fields and rejects forbidden routes. The supporting symptom is: A test can call the DAB backend URL directly without the gateway's identity checks. Direct unauthenticated calls fail while gateway-routed authorized traffic succeeds.
Question 699
A team puts a remote inference call inside a database trigger so every customer update must wait for an embedding service response. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Move inference to an appropriate asynchronous change processing flow or tightly bound the operation after evaluating failure risk. This gives the verification result for the issue: A team puts a remote inference call inside a database trigger so every customer update must wait for an embedding service response.
Database transactions remain available during a model outage and embeddings catch up after recovery. This gives the verification result for the issue: A team puts a remote inference call inside a database trigger so every customer update must wait for an embedding service response.
Incorrect Answers
Embed only approved semantically relevant fields and retain a secure linkage to source permissions. This gives the verification result for the issue: A team puts a remote inference call inside a database trigger so every customer update must wait for an embedding service response. Move inference to an appropriate asynchronous change processing flow or tightly bound the operation after evaluating failure risk.
Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks. This gives the verification result for the issue: A team puts a remote inference call inside a database trigger so every customer update must wait for an embedding service response. Move inference to an appropriate asynchronous change processing flow or tightly bound the operation after evaluating failure risk.
A replay-safe feed propagates additions, updates, and deletions without a full rebuild. This gives the verification result for the issue: A team puts a remote inference call inside a database trigger so every customer update must wait for an embedding service response. Move inference to an appropriate asynchronous change processing flow or tightly bound the operation after evaluating failure risk.
Question 700
A help-desk knowledge table is updated frequently but its embeddings are only generated during an initial import, leaving search results stale. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Embedding stores need a maintenance strategy that follows authoritative source changes.
Incorrect Answers
Asynchronous embedding generation decouples inference latency from transactional writes. Embedding stores need a maintenance strategy that follows authoritative source changes.
Embedding metadata enables quality monitoring, reconciliation, and safe model evolution. Embedding stores need a maintenance strategy that follows authoritative source changes.
Synchronous external calls inside write transactions can couple availability to a remote inference service. Embedding stores need a maintenance strategy that follows authoritative source changes.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 68 - 10 Questions (Last Reviewed 06-Nov-2026)
- Microsoft DP-800 Practice Test 69 - 10 Questions (Last Reviewed 05-Nov-2026)
- Microsoft DP-800 Practice Test 70 - 10 Questions (Last Reviewed 04-Nov-2026)
- Microsoft DP-800 Practice Test 71 - 10 Questions (Last Reviewed 03-Nov-2026)
- Microsoft DP-800 Practice Test 72 - 10 Questions (Last Reviewed 02-Nov-2026)