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 12
Question 110
A customer service team enables temporal history for profile rows but forgets that privacy deletion requests also apply to history. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Design a governed temporal retention and deletion procedure across current and historical data. The reviewed process handles personal data in both periods according to retention obligations.
The reviewed process handles personal data in both periods according to retention obligations.
Incorrect Answers
Define a composite uniqueness constraint across the tenant identifier and invoice code. The reviewed process handles personal data in both periods according to retention obligations.
Design JSON access and indexing according to the engine's supported JSON features and test the predicate. The reviewed process handles personal data in both periods according to retention obligations. Design a governed temporal retention and deletion procedure across current and historical data.
Queries find the correct risk values with less CPU and no loss of document validity. The reviewed process handles personal data in both periods according to retention obligations.
Question 111
A finance assistant must answer questions about changing payment policy and the team proposes updating model weights whenever the policy changes. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Implement retrieval-augmented generation using approved current SQL policy records with source citations. RAG supplies current grounded evidence without encoding every business fact in model weights.
Incorrect Answers
Convert the approved structured rows to valid JSON with supported SQL JSON construction functions. RAG supplies current grounded evidence without encoding every business fact in model weights. Implement retrieval-augmented generation using approved current SQL policy records with source citations.
Parse and validate the returned model response envelope and expected JSON fields before storing results. RAG supplies current grounded evidence without encoding every business fact in model weights. Implement retrieval-augmented generation using approved current SQL policy records with source citations.
Bound and rerank retrieved context, preserve meaningful chunk metadata, and benchmark answer coverage. RAG supplies current grounded evidence without encoding every business fact in model weights. Implement retrieval-augmented generation using approved current SQL policy records with source citations.
Question 112
A subscription report needs the difference between current and prior month revenue per product without a complex self-join. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Use LAG partitioned by product and ordered by report month, then check handling for missing months. A subscription report needs the difference between current and prior month revenue per product without a complex self-join.
The report labels missing prior observations and computes deltas only when a comparison exists. A subscription report needs the difference between current and prior month revenue per product without a complex self-join. Use LAG partitioned by product and ordered by report month, then check handling for missing months.
Incorrect Answers
Use a common table expression to define the intermediate eligible set once and validate its filters. A subscription report needs the difference between current and prior month revenue per product without a complex self-join. Use LAG partitioned by product and ordered by report month, then check handling for missing months.
Evaluate a graph MATCH query against the node and edge model and check result completeness. A subscription report needs the difference between current and prior month revenue per product without a complex self-join. Use LAG partitioned by product and ordered by report month, then check handling for missing months.
A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency. A subscription report needs the difference between current and prior month revenue per product without a complex self-join. The report labels missing prior observations and computes deltas only when a comparison exists.
Question 113
A product catalog updates embedding vectors but its approximate index remains stale and searches continue returning deleted descriptions. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
An index-refresh test removes deleted records and retrieves updated relevant chunks. The operating rule is: Search quality depends on keeping index state synchronized with current vector records.
Incorrect Answers
A pre-insert check identifies incompatible vectors and routes them to repair before indexing. The operating rule is: Search quality depends on keeping index state synchronized with current vector records. An index-refresh test removes deleted records and retrieves updated relevant chunks.
A tested query returns the expected nearest vector rows with reproducible distance values. The operating rule is: Search quality depends on keeping index state synchronized with current vector records. An index-refresh test removes deleted records and retrieves updated relevant chunks.
A combined benchmark retrieves both precise code matches and relevant related explanations. The operating rule is: Search quality depends on keeping index state synchronized with current vector records. An index-refresh test removes deleted records and retrieves updated relevant chunks.
Question 114
An operator hot-fixes a production stored procedure outside version control and the next release unexpectedly overwrites the fix. What should the database developer do FIRST within approved procedures?
Explanation
Correct Answer
Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment. Schema drift must be detected before a declarative project deployment changes production objects.
Incorrect Answers
Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment. Schema drift must be detected before a declarative project deployment changes production objects. Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment.
Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity. Schema drift must be detected before a declarative project deployment changes production objects. Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment.
Block promotion until data impact and an approved migration strategy are verified. Schema drift must be detected before a declarative project deployment changes production objects. Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment.
Question 115
A database procedure concatenates order rows into an unescaped text string before sending them to a model, causing malformed or ambiguous prompts. What technical finding would substantiate this root cause?
Explanation
Correct Answer
Orders with quotes or line breaks break the payload and some item boundaries disappear. A structured interchange format can make SQL-to-model data safer and less ambiguous than string concatenation.
Incorrect Answers
During review the team cannot tell which policy revision or model produced an earlier recommendation. A structured interchange format can make SQL-to-model data safer and less ambiguous than string concatenation. Orders with quotes or line breaks break the payload and some item boundaries disappear.
The generated exception is absent from all retrieved approved policy records. A structured interchange format can make SQL-to-model data safer and less ambiguous than string concatenation. Orders with quotes or line breaks break the payload and some item boundaries disappear.
After a policy update the model repeats the previous threshold because its context is stale. A structured interchange format can make SQL-to-model data safer and less ambiguous than string concatenation. Orders with quotes or line breaks break the payload and some item boundaries disappear.
Question 116
A SQL AI search service is deemed successful because every query returns some result, even when relevant records rarely appear in the first page. What distinction makes the recommended approach appropriate?
Explanation
Correct Answer
Search evaluation needs relevance metrics rather than simple nonempty result counts.
Incorrect Answers
Semantic similarity is one retrieval signal and cannot override transactional business constraints. Search evaluation needs relevance metrics rather than simple nonempty result counts.
Hybrid search can combine complementary lexical precision and semantic recall. Search evaluation needs relevance metrics rather than simple nonempty result counts.
Vector distance functions compare numeric embedding representations, not lexical JSON text. Search evaluation needs relevance metrics rather than simple nonempty result counts.
Question 117
A database project adds a broad GRANT SELECT to PUBLIC because a generated SQL suggestion says it simplifies application connectivity. What is the underlying reason for the corrective step?
Explanation
Correct Answer
Database project source code must include secure authorization decisions, not just schema shapes.
Incorrect Answers
Automated deployment identities should be scoped to the resources and actions they operate. Database project source code must include secure authorization decisions, not just schema shapes.
A project needs explicit versioned dependencies to support repeatable builds. Database project source code must include secure authorization decisions, not just schema shapes.
A database project compiles and validates schema dependencies, not merely stores scripts. Database project source code must include secure authorization decisions, not just schema shapes.
Question 118
An incentive report ranks top sellers by revenue but ties must follow a documented business tie-break rather than unpredictable row ordering. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Use an appropriate window rank and secondary order according to the published tie rule. Ranking semantics must reflect whether ties share positions or require deterministic ordered rows.
Incorrect Answers
Extract the required JSON property and convert it to an appropriate numeric type with invalid-data handling. Ranking semantics must reflect whether ties share positions or require deterministic ordered rows. Use an appropriate window rank and secondary order according to the published tie rule.
Use supported edit-distance similarity functions to rank candidates and preserve a human confirmation step. Ranking semantics must reflect whether ties share positions or require deterministic ordered rows. Use an appropriate window rank and secondary order according to the published tie rule.
Use supported JSON construction and aggregation functions with an explicit schema and null treatment. Ranking semantics must reflect whether ties share positions or require deterministic ordered rows. Use an appropriate window rank and secondary order according to the published tie rule.
Question 119
An IoT staging table includes duplicate device readings and analysts need the latest reading per device without deleting historical evidence. What should the database developer verify to confirm the suspected cause?
Explanation
Correct Answer
A GROUP BY query returns a latest timestamp but cannot reliably choose the associated payload when timestamps tie. Window functions can rank related rows while retaining access to complete row values.
Incorrect Answers
An item containing quotes causes the generated JSON string to fail a parser test. Window functions can rank related rows while retaining access to complete row values. A GROUP BY query returns a latest timestamp but cannot reliably choose the associated payload when timestamps tie.
A basic replace misses some token variations and leaves identifiers in test messages. Window functions can rank related rows while retaining access to complete row values. A GROUP BY query returns a latest timestamp but cannot reliably choose the associated payload when timestamps tie.
The current scoring treats harmless name variations and unrelated records as equally likely duplicates. Window functions can rank related rows while retaining access to complete row values. A GROUP BY query returns a latest timestamp but cannot reliably choose the associated payload when timestamps tie.
Question 120
A customer database encrypts every attribute and then expects ordinary range searches across an encrypted salary column without design changes. What would be a valid post-database-change verification?
Explanation
Correct Answer
Approved salary searches work through a supported secure design without weakening confidentiality. A customer database encrypts every attribute and then expects ordinary range searches across an encrypted salary column without design changes.
Incorrect Answers
Cross-tenant negative tests block forbidden rows even when the application filter is omitted. A customer database encrypts every attribute and then expects ordinary range searches across an encrypted salary column without design changes. Approved salary searches work through a supported secure design without weakening confidentiality.
Unauthorized context switching is rejected and each user remains restricted to their approved tenant. A customer database encrypts every attribute and then expects ordinary range searches across an encrypted salary column without design changes. Approved salary searches work through a supported secure design without weakening confidentiality.
Modified client filters cannot expand the account's authorized row scope. A customer database encrypts every attribute and then expects ordinary range searches across an encrypted salary column without design changes. Approved salary searches work through a supported secure design without weakening confidentiality.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 10 - 10 Questions (Last Reviewed 07-Nov-2026)
- Microsoft DP-800 Practice Test 11 - 10 Questions (Last Reviewed 06-Nov-2026)
- Microsoft DP-800 Practice Test 12 - 10 Questions (Last Reviewed 05-Nov-2026)
- Microsoft DP-800 Practice Test 13 - 10 Questions (Last Reviewed 04-Nov-2026)
- Microsoft DP-800 Practice Test 14 - 10 Questions (Last Reviewed 03-Nov-2026)