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 71
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.
Question 701
A recommendation service ranks products only by vector similarity and shows discontinued items because business eligibility filters are ignored. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
A discontinued SKU scores high on semantic relevance and appears as an orderable suggestion. Semantic similarity is one retrieval signal and cannot override transactional business constraints.
Incorrect Answers
Execution plans show scans with wildcard matching against long FAQ text columns. Semantic similarity is one retrieval signal and cannot override transactional business constraints. A discontinued SKU scores high on semantic relevance and appears as an orderable suggestion.
Fast approximate results sometimes omit the known closest passage in labeled tests. Semantic similarity is one retrieval signal and cannot override transactional business constraints. A discontinued SKU scores high on semantic relevance and appears as an orderable suggestion.
The query output contains a citation to another tenant's chunk under certain prompts. Semantic similarity is one retrieval signal and cannot override transactional business constraints. A discontinued SKU scores high on semantic relevance and appears as an orderable suggestion.
Question 702
A SQL-based document assistant splits contracts every fixed number of characters and frequently separates a clause from its exception and heading. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
Retrieved passages contain a payment obligation but omit the adjacent exception that changes its meaning. Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed.
Incorrect Answers
The vector table retains deleted product entries and lacks vectors for recent updates. Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed. Retrieved passages contain a payment obligation but omit the adjacent exception that changes its meaning.
Queries in one language miss conceptually matching incident notes written in another. Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed. Retrieved passages contain a payment obligation but omit the adjacent exception that changes its meaning.
Embedding input logs show private identifiers unrelated to the search task. Chunking should preserve semantically necessary context instead of merely maximizing ingestion speed. Retrieved passages contain a payment obligation but omit the adjacent exception that changes its meaning.
Question 703
A product catalog API must retrieve a product with its authorized variants in one GraphQL request but the relationship mapping is not configured. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
An authorized nested query returns correct variants while excluded records remain inaccessible.
Configure the supported DAB GraphQL relationship mapping and test nested authorization across entities. An authorized nested query returns correct variants while excluded records remain inaccessible.
Incorrect Answers
The service returns current approved prices within the agreed freshness interval after a change. An authorized nested query returns correct variants while excluded records remain inaccessible.
Use supported Change Tracking with a version watermark and controlled rehydration of current rows. An authorized nested query returns correct variants while excluded records remain inaccessible. Configure the supported DAB GraphQL relationship mapping and test nested authorization across entities.
Version the DAB configuration and use environment-specific secret injection and validation during deployment. An authorized nested query returns correct variants while excluded records remain inaccessible.
Question 704
A billing dashboard needs a cumulative balance by account across transaction dates and the current solution recalculates all preceding rows in correlated subqueries. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
The existing query performs repeated nested scans and does not order same-time events predictably. Ordered window aggregates express running calculations without repeated per-row rescans.
Incorrect Answers
The current scoring treats harmless name variations and unrelated records as equally likely duplicates. Ordered window aggregates express running calculations without repeated per-row rescans. The existing query performs repeated nested scans and does not order same-time events predictably.
A GROUP BY query returns a latest timestamp but cannot reliably choose the associated payload when timestamps tie. Ordered window aggregates express running calculations without repeated per-row rescans. The existing query performs repeated nested scans and does not order same-time events predictably.
The database stores one row per shipment but cannot query per-item quantities or product codes. Ordered window aggregates express running calculations without repeated per-row rescans. The existing query performs repeated nested scans and does not order same-time events predictably.
Question 705
A SQL database invokes an external model that is replaced by the provider without a tested compatibility plan. What is the underlying reason for the corrective step?
Explanation
Correct Answer
External models are dependencies that need version governance and compatibility testing.
Incorrect Answers
Model modalities and preprocessing must match the stored evidence types. External models are dependencies that need version governance and compatibility testing.
Vector dimensions and model spaces must be compatible for meaningful similarity calculations. External models are dependencies that need version governance and compatibility testing.
Embedding metadata enables quality monitoring, reconciliation, and safe model evolution. External models are dependencies that need version governance and compatibility testing.
Question 706
A cloud database enables disk encryption but an application team assumes that prevents its overly privileged SQL login from reading confidential rows. Which TWO options together specify a corrective step and a meaningful test?
Explanation
Correct Answers
Compromised low-privilege identities cannot read unrelated protected data in a controlled test. A cloud database enables disk encryption but an application team assumes that prevents its overly privileged SQL login from reading confidential rows.
Apply row/object permissions or client-side protection appropriate to the threat model. A cloud database enables disk encryption but an application team assumes that prevents its overly privileged SQL login from reading confidential rows.
Incorrect Answers
Implement database-enforced row-level security using an appropriate security predicate and trustworthy session identity. A cloud database enables disk encryption but an application team assumes that prevents its overly privileged SQL login from reading confidential rows. Apply row/object permissions or client-side protection appropriate to the threat model.
Cross-tenant negative tests block forbidden rows even when the application filter is omitted. A cloud database enables disk encryption but an application team assumes that prevents its overly privileged SQL login from reading confidential rows. Compromised low-privilege identities cannot read unrelated protected data in a controlled test.
Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter. A cloud database enables disk encryption but an application team assumes that prevents its overly privileged SQL login from reading confidential rows. Apply row/object permissions or client-side protection appropriate to the threat model.
Question 707
A bookings database allows negative guest counts and missing initial status fields because web clients supply values inconsistently. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
Both API and direct writes reject invalid counts and insert an appropriate initial status when omitted. The operating rule is: Database constraints enforce integrity across multiple clients rather than relying solely on user interfaces.
Incorrect Answers
Queries find the correct risk values with less CPU and no loss of document validity. The operating rule is: Database constraints enforce integrity across multiple clients rather than relying solely on user interfaces. Both API and direct writes reject invalid counts and insert an appropriate initial status when omitted.
A load test shows lower contention without unacceptable loss of required durable records. The operating rule is: Database constraints enforce integrity across multiple clients rather than relying solely on user interfaces. Both API and direct writes reject invalid counts and insert an appropriate initial status when omitted.
Malformed inputs are rejected and valid representative payloads remain queryable. The operating rule is: Database constraints enforce integrity across multiple clients rather than relying solely on user interfaces. Both API and direct writes reject invalid counts and insert an appropriate initial status when omitted.
Question 708
A shared SQL table stores tickets for many clients and an application bug omits its WHERE tenant predicate. What is the underlying reason for the corrective step?
Explanation
Correct Answer
Row-level security enforces data visibility in the database independently of application query discipline.
Incorrect Answers
Access prevention and accountable security monitoring are complementary controls. Row-level security enforces data visibility in the database independently of application query discipline.
Encryption at rest does not replace database access controls for authenticated query operations. Row-level security enforces data visibility in the database independently of application query discipline.
Least privilege distinguishes runtime data access from administrative deployment responsibilities. Row-level security enforces data visibility in the database independently of application query discipline.
Question 709
A database process sends prompts to an external model with a shared static API credential stored in plain configuration. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
The secret appears in developer-readable config and can invoke the endpoint outside the approved process. Model integration security must cover both database identity and downstream inference access.
Incorrect Answers
Queries in one language miss conceptually matching incident notes written in another. Model integration security must cover both database identity and downstream inference access. The secret appears in developer-readable config and can invoke the endpoint outside the approved process.
Embedding input logs show private identifiers unrelated to the search task. Model integration security must cover both database identity and downstream inference access. The secret appears in developer-readable config and can invoke the endpoint outside the approved process.
New vector inserts fail dimension validation or comparisons return inconsistent similarity results. Model integration security must cover both database identity and downstream inference access. The secret appears in developer-readable config and can invoke the endpoint outside the approved process.
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?
Explanation
Correct Answer
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
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.
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.
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.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- 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)
- Microsoft DP-800 Practice Test 73 - 10 Questions (Last Reviewed 01-Nov-2026)