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 16
Question 150
A finance report repeats a complicated eligibility expression in several joins and inconsistent copies give different quarter totals. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Use a common table expression to define the intermediate eligible set once and validate its filters. The revised query uses one reviewed eligibility definition and reconciles all quarter totals.
The revised query uses one reviewed eligibility definition and reconciles all quarter totals. The accompanying action is to use a common table expression to define the intermediate eligible set once and validate its filters.
Incorrect Answers
Evaluate REGEXP_REPLACE with a narrowly tested account-token pattern and independent sensitive-data detection. The revised query uses one reviewed eligibility definition and reconciles all quarter totals. Use a common table expression to define the intermediate eligible set once and validate its filters.
Use LAG partitioned by product and ordered by report month, then check handling for missing months. The revised query uses one reviewed eligibility definition and reconciles all quarter totals. Use a common table expression to define the intermediate eligible set once and validate its filters.
The validation error results in a fully consistent rollback and a diagnostic error response. The revised query uses one reviewed eligibility definition and reconciles all quarter totals.
Question 151
Developers can push directly to the default branch and deploy payment-table changes without review or security testing. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
An unreviewed commit lands in the release branch despite failing a required migration test. CI/CD governance starts with source-control policy and controlled approval boundaries.
Incorrect Answers
Unit tests pass while a real GraphQL query fails on a missing relationship field. CI/CD governance starts with source-control policy and controlled approval boundaries. An unreviewed commit lands in the release branch despite failing a required migration test.
Staging rows contain values longer than the proposed target length. CI/CD governance starts with source-control policy and controlled approval boundaries. An unreviewed commit lands in the release branch despite failing a required migration test.
A staged test user can query sensitive salary columns without being assigned an appropriate role. CI/CD governance starts with source-control policy and controlled approval boundaries. An unreviewed commit lands in the release branch despite failing a required migration test.
Question 152
A developer stores embeddings as comma-separated NVARCHAR values and converts them on every search operation. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Use a supported SQL vector type with dimension compatibility checks and an appropriate data design. A test accepts valid vectors, rejects inconsistent dimensions, and reduces conversion work.
A test accepts valid vectors, rejects inconsistent dimensions, and reduces conversion work. The accompanying action is to use a supported SQL vector type with dimension compatibility checks and an appropriate data design.
Incorrect Answers
A benchmark reaches minimum relevant top-k hit rates while respecting service latency. A test accepts valid vectors, rejects inconsistent dimensions, and reduces conversion work.
Combine lexical and vector retrieval under controlled filters and evaluate hybrid result quality. A test accepts valid vectors, rejects inconsistent dimensions, and reduces conversion work.
Apply an appropriate normalization strategy such as VECTOR_NORMALIZE and verify the chosen similarity metric. A test accepts valid vectors, rejects inconsistent dimensions, and reduces conversion work. Use a supported SQL vector type with dimension compatibility checks and an appropriate data design.
Question 153
A SQL Database Project changes a discount procedure but the pipeline has only build success checks and no tests of edge-case numeric outputs. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
A schema build validates structure but does not prove business-rule correctness.
Incorrect Answers
Schema evolution should account for clients with independent deployment cycles. A schema build validates structure but does not prove business-rule correctness.
Database project source code must include secure authorization decisions, not just schema shapes. A schema build validates structure but does not prove business-rule correctness.
Static reference data can be part of database release reproducibility and should be governed. A schema build validates structure but does not prove business-rule correctness.
Question 154
A multilingual knowledge base stores English-only embeddings and assumes a translated query produces equivalent relevance in all supported locales. What should the database developer do FIRST within approved procedures?
Explanation
Correct Answer
Benchmark a multilingual embedding/retrieval strategy and compare language-specific recall. Vector semantic performance is model and language dependent, not guaranteed by storing numbers.
Incorrect Answers
Combine lexical and vector retrieval under controlled filters and evaluate hybrid result quality. Vector semantic performance is model and language dependent, not guaranteed by storing numbers. Benchmark a multilingual embedding/retrieval strategy and compare language-specific recall.
Implement supported index update or rebuild processes tied to source and vector lifecycle events. Vector semantic performance is model and language dependent, not guaranteed by storing numbers. Benchmark a multilingual embedding/retrieval strategy and compare language-specific recall.
Use reciprocal rank fusion or another validated rank combination approach after separate retrieval stages. Vector semantic performance is model and language dependent, not guaranteed by storing numbers. Benchmark a multilingual embedding/retrieval strategy and compare language-specific recall.
Question 155
A payment archive table grows monthly and retention jobs currently delete millions of old rows while blocking online activity. What would be a valid post-database-change verification?
Explanation
Correct Answer
An aged partition is archived or removed through approved procedures without disrupting active payment queries.
Incorrect Answers
Each tenant has unique invoice codes while other tenants can reuse the same code safely. An aged partition is archived or removed through approved procedures without disrupting active payment queries.
An authorized verifier detects simulated unauthorized modifications using a trusted ledger digest. An aged partition is archived or removed through approved procedures without disrupting active payment queries.
The SQL query reads the correct current permitted external records with monitored latency and access controls. An aged partition is archived or removed through approved procedures without disrupting active payment queries.
Question 156
An application wants new FAQ entries to receive embeddings soon after insertion without embedding generation blocking the user-facing SQL transaction. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks. Asynchronous embedding generation decouples inference latency from transactional writes.
Incorrect Answers
Store approved model/version, source ID, timestamp, and change state alongside embeddings. Asynchronous embedding generation decouples inference latency from transactional writes. Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks.
Use Change Tracking or another supported change signal to queue reliable re-embedding of modified source records. Asynchronous embedding generation decouples inference latency from transactional writes. Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks.
Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation. Asynchronous embedding generation decouples inference latency from transactional writes. Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks.
Question 157
A database contains product-description embeddings and needs to calculate distances to an incoming query vector over a small reference sample. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
The current SQL compares serialized embedding strings instead of their numeric coordinates. Vector distance functions compare numeric embedding representations, not lexical JSON text.
Incorrect Answers
The query output contains a citation to another tenant's chunk under certain prompts. Vector distance functions compare numeric embedding representations, not lexical JSON text. The current SQL compares serialized embedding strings instead of their numeric coordinates.
Execution plans show scans with wildcard matching against long FAQ text columns. Vector distance functions compare numeric embedding representations, not lexical JSON text. The current SQL compares serialized embedding strings instead of their numeric coordinates.
An Arabic customer question fails to retrieve an otherwise relevant Spanish-language document. Vector distance functions compare numeric embedding representations, not lexical JSON text. The current SQL compares serialized embedding strings instead of their numeric coordinates.
Question 158
A data quality team sanitizes narratives that may include a recognizable account-number format before an AI summarization step. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
Regex substitution supports structured redaction only when patterns are thoroughly validated.
Incorrect Answers
OPENJSON supports transforming structured arrays into queryable relational data. Regex substitution supports structured redaction only when patterns are thoroughly validated.
T-SQL error handling must preserve transaction atomicity rather than merely log exceptions. Regex substitution supports structured redaction only when patterns are thoroughly validated.
Correlated queries preserve per-row context when selecting related records. Regex substitution supports structured redaction only when patterns are thoroughly validated.
Question 159
A distributed team uses GitHub Copilot for SQL project changes but suggestions repeatedly violate the team's migration and naming conventions. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
New suggestions follow the documented conventions and still pass independent pull-request review. Create reviewed repository instruction files that specify migration, test, and secure coding conventions without embedding secrets.
Create reviewed repository instruction files that specify migration, test, and secure coding conventions without embedding secrets.
Incorrect Answers
Treat retrieved schema documentation as untrusted task data and block unauthorized tool calls. Create reviewed repository instruction files that specify migration, test, and secure coding conventions without embedding secrets. New suggestions follow the documented conventions and still pass independent pull-request review.
Eligible users can perform an approved task and excluded users cannot access unsupported capabilities. Create reviewed repository instruction files that specify migration, test, and secure coding conventions without embedding secrets. New suggestions follow the documented conventions and still pass independent pull-request review.
Compare recommendations with actual workload plans, maintenance costs, and performance tests before approval. Create reviewed repository instruction files that specify migration, test, and secure coding conventions without embedding secrets.
Question 160
A help-desk knowledge table is updated frequently but its embeddings are only generated during an initial import, leaving search results stale. What would be a valid post-database-change verification?
Explanation
Correct Answer
A changed row's embedding is refreshed within the accepted time window and old results no longer dominate.
Incorrect Answers
The FAQ write commits promptly and a background worker creates a matching authorized vector. A changed row's embedding is refreshed within the accepted time window and old results no longer dominate.
Database transactions remain available during a model outage and embeddings catch up after recovery. A changed row's embedding is refreshed within the accepted time window and old results no longer dominate.
A test query retrieves authorized matching image and text records with validated accuracy. A changed row's embedding is refreshed within the accepted time window and old results no longer dominate.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 14 - 10 Questions (Last Reviewed 03-Nov-2026)
- Microsoft DP-800 Practice Test 15 - 10 Questions (Last Reviewed 02-Nov-2026)
- Microsoft DP-800 Practice Test 16 - 10 Questions (Last Reviewed 01-Nov-2026)
- Microsoft DP-800 Practice Test 17 - 10 Questions (Last Reviewed 31-Oct-2026)
- Microsoft DP-800 Practice Test 18 - 10 Questions (Last Reviewed 30-Oct-2026)