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 20
Question 190
A logistics service wants a read-only REST endpoint for approved shipment status but an API prototype exposes every warehouse table by default. What technical finding would substantiate this root cause?
Explanation
Correct Answer
API discovery lists internal employee and financial tables unrelated to shipment tracking. Data API builder configuration determines service surface and must follow least-privilege exposure.
Incorrect Answers
Users report timeouts while infrastructure charts show normal CPU and no request trace. Data API builder configuration determines service surface and must follow least-privilege exposure. API discovery lists internal employee and financial tables unrelated to shipment tracking.
The production service starts with a default configuration missing the intended entity permissions. Data API builder configuration determines service surface and must follow least-privilege exposure. API discovery lists internal employee and financial tables unrelated to shipment tracking.
The poller rereads the full customer table for every sync despite only a few changes. Data API builder configuration determines service surface and must follow least-privilege exposure. API discovery lists internal employee and financial tables unrelated to shipment tracking.
Question 191
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 would be a valid post-database-change verification?
Explanation
Correct Answer
The graph query returns the verified two-hop relationships without inventing direct account links.
Incorrect Answers
The revised query uses one reviewed eligibility definition and reconciles all quarter totals. The graph query returns the verified two-hop relationships without inventing direct account links.
Every product row matches the latest approved price in its own region as of the test date. The graph query returns the verified two-hop relationships without inventing direct account links.
A test excludes substring lookalikes and includes exact intended JSON matches. The graph query returns the verified two-hop relationships without inventing direct account links.
Question 192
An AI-enabled SQL workflow calls a model service with an API key stored in a database object accessible to developers. What should the database developer verify to confirm the suspected cause?
Explanation
Correct Answer
Source inspection exposes a credential that can invoke the model service outside the approved workflow. Model endpoints are security-sensitive downstream services and credentials must be governed.
Incorrect Answers
The application repository contains a password reused across several deployments. Model endpoints are security-sensitive downstream services and credentials must be governed. Source inspection exposes a credential that can invoke the model service outside the approved workflow.
A direct query by a client login returns tickets belonging to a different tenant. Model endpoints are security-sensitive downstream services and credentials must be governed. Source inspection exposes a credential that can invoke the model service outside the approved workflow.
Changing a query parameter returns records for another tenant in a replay test. Model endpoints are security-sensitive downstream services and credentials must be governed. Source inspection exposes a credential that can invoke the model service outside the approved workflow.
Question 193
A compliance analyst must count structured incident tags embedded in a text column, but searching a broad substring overcounts ordinary words. Which technical principle explains the correct response?
Explanation
Correct Answer
Pattern specificity matters as much as the function chosen for regular-expression counts.
Incorrect Answers
Regex substitution supports structured redaction only when patterns are thoroughly validated. Pattern specificity matters as much as the function chosen for regular-expression counts.
Converting free-form values to rows requires explicit delimiter and validation semantics. Pattern specificity matters as much as the function chosen for regular-expression counts.
Window functions can rank related rows while retaining access to complete row values. Pattern specificity matters as much as the function chosen for regular-expression counts.
Question 194
A developer asks a coding assistant to optimize a stored procedure and accepts generated SQL that removes a tenant filter to improve latency. Which technical principle explains the correct response?
Explanation
Correct Answer
AI-assisted development does not remove developer responsibility for SQL authorization and correctness.
Incorrect Answers
Correctness regression testing is essential when AI assistance alters set and join semantics. AI-assisted development does not remove developer responsibility for SQL authorization and correctness.
Tool routing must be unambiguous when an AI assistant can reach multiple data environments. AI-assisted development does not remove developer responsibility for SQL authorization and correctness.
Giving an assistant tools extends its action surface and must not imply unrestricted administrative authority. AI-assisted development does not remove developer responsibility for SQL authorization and correctness.
Question 195
A payroll application stores compensation values in Azure SQL but database administrators should not see their plaintext through routine SQL queries. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
A database support login can read every salary directly in plaintext despite lacking a payroll role. Always Encrypted can protect data from database-side operators when client and key boundaries are designed correctly.
Incorrect Answers
A crafted query requests a hidden financial column and receives its original value. Always Encrypted can protect data from database-side operators when client and key boundaries are designed correctly. A database support login can read every salary directly in plaintext despite lacking a payroll role.
A rehearsal shows authorized applications cannot decrypt data after an uncoordinated key update. Always Encrypted can protect data from database-side operators when client and key boundaries are designed correctly. A database support login can read every salary directly in plaintext despite lacking a payroll role.
A simulated investigation cannot retrieve last month's database permission changes because the logs expired. Always Encrypted can protect data from database-side operators when client and key boundaries are designed correctly. A database support login can read every salary directly in plaintext despite lacking a payroll role.
Question 196
A SQL project tracks application tables but lookup status codes are manually edited in production, causing different values across environments. Which next step most directly resolves this SQL solution issue?
Explanation
Correct Answer
Version reference data in a reviewed idempotent deployment process with migration tests. Static reference data can be part of database release reproducibility and should be governed.
Incorrect Answers
Use an expand-and-contract migration or controlled compatibility strategy with rollback testing. Static reference data can be part of database release reproducibility and should be governed. Version reference data in a reviewed idempotent deployment process with migration tests.
Reject the broad grant and model only narrowly required role permissions in reviewed project files. Static reference data can be part of database release reproducibility and should be governed. Version reference data in a reviewed idempotent deployment process with migration tests.
Resolve schema conflicts with a model diff and tests before approving the combined pull request. Static reference data can be part of database release reproducibility and should be governed. Version reference data in a reviewed idempotent deployment process with migration tests.
Question 197
A mobile application needs to learn which customer IDs changed since its last successful sync without storing complete before-and-after value history. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Use supported Change Tracking with a version watermark and controlled rehydration of current rows. This gives the verification result for the issue: A mobile application needs to learn which customer IDs changed since its last successful sync without storing complete before-and-after value history.
A client retrieves only changed keys since its saved version and safely handles retention gaps. This gives the verification result for the issue: A mobile application needs to learn which customer IDs changed since its last successful sync without storing complete before-and-after value history.
Incorrect Answers
A test request can be traced across API and SQL dependencies to the failing span. This gives the verification result for the issue: A mobile application needs to learn which customer IDs changed since its last successful sync without storing complete before-and-after value history. A client retrieves only changed keys since its saved version and safely handles retention gaps.
Version the DAB configuration and use environment-specific secret injection and validation during deployment. This gives the verification result for the issue: A mobile application needs to learn which customer IDs changed since its last successful sync without storing complete before-and-after value history. A client retrieves only changed keys since its saved version and safely handles retention gaps.
Configure the supported DAB GraphQL relationship mapping and test nested authorization across entities. This gives the verification result for the issue: A mobile application needs to learn which customer IDs changed since its last successful sync without storing complete before-and-after value history. Use supported Change Tracking with a version watermark and controlled rehydration of current rows.
Question 198
A fraud analyst stores account-device links in graph tables but manually joins three edge tables to detect accounts connected through a shared device. Which TWO options together specify a corrective step and a meaningful test?
Explanation
Correct Answers
The graph query returns the verified two-hop relationships without inventing direct account links. Evaluate a graph MATCH query against the node and edge model and check result completeness.
Evaluate a graph MATCH query against the node and edge model and check result completeness.
Incorrect Answers
The emitted payload parses correctly and matches required warehouse/item associations. Evaluate a graph MATCH query against the node and edge model and check result completeness. The graph query returns the verified two-hop relationships without inventing direct account links.
Use a suitable SUM window ordered by transaction event and a deterministic secondary key. Evaluate a graph MATCH query against the node and edge model and check result completeness.
Evaluate REGEXP_REPLACE with a narrowly tested account-token pattern and independent sensitive-data detection. Evaluate a graph MATCH query against the node and edge model and check result completeness.
Question 199
An engineering help-desk needs exact error-code matching plus conceptually relevant troubleshooting articles and neither keyword nor vectors alone performs well. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
Combine lexical and vector retrieval under controlled filters and evaluate hybrid result quality.
A combined benchmark retrieves both precise code matches and relevant related explanations. Combine lexical and vector retrieval under controlled filters and evaluate hybrid result quality.
Incorrect Answers
Use supported VECTOR_DISTANCE with a compatible metric and deterministic ranking checks. Combine lexical and vector retrieval under controlled filters and evaluate hybrid result quality.
Apply product availability and eligibility rules before or during semantic ranking and verify result scope. Combine lexical and vector retrieval under controlled filters and evaluate hybrid result quality.
Language-sliced tests retrieve authorized relevant records with accepted coverage. Combine lexical and vector retrieval under controlled filters and evaluate hybrid result quality.
Question 200
An AI coding assistant proposes rewriting a billing query, but the team has no regression fixture for null taxes and partial refunds. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
The faster version silently drops refunds because a new INNER JOIN filters unmatched rows. Correctness regression testing is essential when AI assistance alters set and join semantics.
Incorrect Answers
Authorized staff cannot access the expected assistant despite seeing it in a marketing demonstration. Correctness regression testing is essential when AI assistance alters set and join semantics. The faster version silently drops refunds because a new INNER JOIN filters unmatched rows.
The query explanation shows proposed changes but the database still contains the original stored procedure. Correctness regression testing is essential when AI assistance alters set and join semantics. The faster version silently drops refunds because a new INNER JOIN filters unmatched rows.
A proposed query runs faster in a developer test but returns records belonging to other tenants. Correctness regression testing is essential when AI assistance alters set and join semantics. The faster version silently drops refunds because a new INNER JOIN filters unmatched rows.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 18 - 10 Questions (Last Reviewed 30-Oct-2026)
- Microsoft DP-800 Practice Test 19 - 10 Questions (Last Reviewed 29-Oct-2026)
- Microsoft DP-800 Practice Test 20 - 10 Questions (Last Reviewed 28-Oct-2026)
- Microsoft DP-800 Practice Test 21 - 10 Questions (Last Reviewed 27-Oct-2026)
- Microsoft DP-800 Practice Test 22 - 10 Questions (Last Reviewed 26-Oct-2026)