Microsoft DP-800 Practice Test 12 - Prepaway
Practice Exams:

Pass Microsoft DP-800 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers!

30 Days Free Updates, Instant Download!

Verified By Experts
Premium File
$69.99 $76.99

DP-800 Premium ETE File


  • Premium File 101 Questions & Answers. Last Update: Nov 06, 2026
Whats Included:
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

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.

  1. Design a governed temporal retention and deletion procedure across current and historical data.
  2. Define a composite uniqueness constraint across the tenant identifier and invoice code.
  3. Design JSON access and indexing according to the engine's supported JSON features and test the predicate.
  4. The reviewed process handles personal data in both periods according to retention obligations.
  5. Queries find the correct risk values with less CPU and no loss of document validity.

Explanation

Correct Answers

A:

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.

D:

The reviewed process handles personal data in both periods according to retention obligations.

Incorrect Answers

B:

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.

C:

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.

E:

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?

  1. Implement retrieval-augmented generation using approved current SQL policy records with source citations.
  2. Convert the approved structured rows to valid JSON with supported SQL JSON construction functions.
  3. Parse and validate the returned model response envelope and expected JSON fields before storing results.
  4. Bound and rerank retrieved context, preserve meaningful chunk metadata, and benchmark answer coverage.

Explanation

Correct Answer

A:

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

B:

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.

C:

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.

D:

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.

  1. Use a common table expression to define the intermediate eligible set once and validate its filters.
  2. Evaluate a graph MATCH query against the node and edge model and check result completeness.
  3. A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency.
  4. Use LAG partitioned by product and ordered by report month, then check handling for missing months.
  5. The report labels missing prior observations and computes deltas only when a comparison exists.

Explanation

Correct Answers

D:

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.

E:

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

A:

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.

B:

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.

C:

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?

  1. An index-refresh test removes deleted records and retrieves updated relevant chunks.
  2. A pre-insert check identifies incompatible vectors and routes them to repair before indexing.
  3. A tested query returns the expected nearest vector rows with reproducible distance values.
  4. A combined benchmark retrieves both precise code matches and relevant related explanations.

Explanation

Correct Answer

A:

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

B:

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.

C:

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.

D:

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?

  1. Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment.
  2. Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment.
  3. Rotate the exposed credential and move secrets to an approved secret store with restricted pipeline identity.
  4. Block promotion until data impact and an approved migration strategy are verified.

Explanation

Correct Answer

A:

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

B:

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.

C:

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.

D:

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?

  1. During review the team cannot tell which policy revision or model produced an earlier recommendation.
  2. The generated exception is absent from all retrieved approved policy records.
  3. After a policy update the model repeats the previous threshold because its context is stale.
  4. Orders with quotes or line breaks break the payload and some item boundaries disappear.

Explanation

Correct Answer

D:

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

A:

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.

B:

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.

C:

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?

  1. Semantic similarity is one retrieval signal and cannot override transactional business constraints.
  2. Search evaluation needs relevance metrics rather than simple nonempty result counts.
  3. Hybrid search can combine complementary lexical precision and semantic recall.
  4. Vector distance functions compare numeric embedding representations, not lexical JSON text.

Explanation

Correct Answer

B:

Search evaluation needs relevance metrics rather than simple nonempty result counts.

Incorrect Answers

A:

Semantic similarity is one retrieval signal and cannot override transactional business constraints. Search evaluation needs relevance metrics rather than simple nonempty result counts.

C:

Hybrid search can combine complementary lexical precision and semantic recall. Search evaluation needs relevance metrics rather than simple nonempty result counts.

D:

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?

  1. Automated deployment identities should be scoped to the resources and actions they operate.
  2. A project needs explicit versioned dependencies to support repeatable builds.
  3. A database project compiles and validates schema dependencies, not merely stores scripts.
  4. Database project source code must include secure authorization decisions, not just schema shapes.

Explanation

Correct Answer

D:

Database project source code must include secure authorization decisions, not just schema shapes.

Incorrect Answers

A:

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.

B:

A project needs explicit versioned dependencies to support repeatable builds. Database project source code must include secure authorization decisions, not just schema shapes.

C:

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?

  1. Extract the required JSON property and convert it to an appropriate numeric type with invalid-data handling.
  2. Use an appropriate window rank and secondary order according to the published tie rule.
  3. Use supported edit-distance similarity functions to rank candidates and preserve a human confirmation step.
  4. Use supported JSON construction and aggregation functions with an explicit schema and null treatment.

Explanation

Correct Answer

B:

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

A:

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.

C:

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.

D:

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?

  1. A GROUP BY query returns a latest timestamp but cannot reliably choose the associated payload when timestamps tie.
  2. An item containing quotes causes the generated JSON string to fail a parser test.
  3. A basic replace misses some token variations and leaves identifiers in test messages.
  4. The current scoring treats harmless name variations and unrelated records as equally likely duplicates.

Explanation

Correct Answer

A:

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

B:

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.

C:

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.

D:

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?

  1. Approved salary searches work through a supported secure design without weakening confidentiality.
  2. Cross-tenant negative tests block forbidden rows even when the application filter is omitted.
  3. Unauthorized context switching is rejected and each user remains restricted to their approved tenant.
  4. Modified client filters cannot expand the account's authorized row scope.

Explanation

Correct Answer

A:

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

B:

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.

C:

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.

D:

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