Microsoft DP-800 Practice Test 18 - 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 18

Question 170

A database project compiles locally but CI fails because a referenced shared database model exists only on one developer's machine. What distinction makes the recommended approach appropriate?

  1. Schema evolution should account for clients with independent deployment cycles.
  2. Database project source code must include secure authorization decisions, not just schema shapes.
  3. A project needs explicit versioned dependencies to support repeatable builds.
  4. Deployment configuration and identity should jointly prevent cross-environment mistakes.

Explanation

Correct Answer

C:

A project needs explicit versioned dependencies to support repeatable builds.

Incorrect Answers

A:

Schema evolution should account for clients with independent deployment cycles. A project needs explicit versioned dependencies to support repeatable builds.

B:

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

D:

Deployment configuration and identity should jointly prevent cross-environment mistakes. A project needs explicit versioned dependencies to support repeatable builds.

Question 171

An API that calls Azure SQL has intermittent timeouts but the team monitors only average SQL CPU and cannot tie failures to individual requests. What technical finding would substantiate this root cause?

  1. A simulated retry creates duplicate downstream notifications for one business event.
  2. API discovery lists internal employee and financial tables unrelated to shipment tracking.
  3. The production service starts with a default configuration missing the intended entity permissions.
  4. Users report timeouts while infrastructure charts show normal CPU and no request trace.

Explanation

Correct Answer

D:

Users report timeouts while infrastructure charts show normal CPU and no request trace. Correlated telemetry can reveal failures that resource-average monitoring alone misses.

Incorrect Answers

A:

A simulated retry creates duplicate downstream notifications for one business event. Correlated telemetry can reveal failures that resource-average monitoring alone misses. Users report timeouts while infrastructure charts show normal CPU and no request trace.

B:

API discovery lists internal employee and financial tables unrelated to shipment tracking. Correlated telemetry can reveal failures that resource-average monitoring alone misses. Users report timeouts while infrastructure charts show normal CPU and no request trace.

C:

The production service starts with a default configuration missing the intended entity permissions. Correlated telemetry can reveal failures that resource-average monitoring alone misses. Users report timeouts while infrastructure charts show normal CPU and no request trace.

Question 172

A mobile inventory API requires a JSON object per warehouse containing an array of item summaries, and string concatenation produces malformed output for quoted names. What is the MOST appropriate initial remediation?

  1. Use a common table expression to define the intermediate eligible set once and validate its filters.
  2. Use an appropriate window rank and secondary order according to the published tie rule.
  3. Use a suitable SUM window ordered by transaction event and a deterministic secondary key.
  4. Use supported JSON construction and aggregation functions with an explicit schema and null treatment.

Explanation

Correct Answer

D:

Use supported JSON construction and aggregation functions with an explicit schema and null treatment. Native JSON functions help create valid structured output instead of fragile manual string concatenation.

Incorrect Answers

A:

Use a common table expression to define the intermediate eligible set once and validate its filters. Native JSON functions help create valid structured output instead of fragile manual string concatenation. Use supported JSON construction and aggregation functions with an explicit schema and null treatment.

B:

Use an appropriate window rank and secondary order according to the published tie rule. Native JSON functions help create valid structured output instead of fragile manual string concatenation. Use supported JSON construction and aggregation functions with an explicit schema and null treatment.

C:

Use a suitable SUM window ordered by transaction event and a deterministic secondary key. Native JSON functions help create valid structured output instead of fragile manual string concatenation. Use supported JSON construction and aggregation functions with an explicit schema and null treatment.

Question 173

A web application database login has db_owner privileges solely because its installation script creates a few tables during deployment. What would be a valid post-database-change verification?

  1. Approved salary searches work through a supported secure design without weakening confidentiality.
  2. The function processes authorized events while negative access tests deny unrelated tables.
  3. Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers.
  4. The web application runs normal queries while an attempted schema modification is denied.

Explanation

Correct Answer

D:

The web application runs normal queries while an attempted schema modification is denied.

Incorrect Answers

A:

Approved salary searches work through a supported secure design without weakening confidentiality. The web application runs normal queries while an attempted schema modification is denied.

B:

The function processes authorized events while negative access tests deny unrelated tables. The web application runs normal queries while an attempted schema modification is denied.

C:

Authorized model calls succeed with least privilege and no plaintext key is exposed to unrelated readers. The web application runs normal queries while an attempted schema modification is denied.

Question 174

A reporting service needs current invoice totals but must not expose underlying customer identifiers and the API currently queries raw tables directly. Which observation is the strongest evidence for the reported problem?

  1. The second deployment creates more lookup codes than the first although the business catalog is unchanged.
  2. A privileged test account can still select restricted rows despite the trigger firing on writes.
  3. An access audit shows the reporting service can read full customer rows although it only needs totals.
  4. The attempted update fails because SQL cannot map a calculated view field to one base column.

Explanation

Correct Answer

C:

An access audit shows the reporting service can read full customer rows although it only needs totals. Views can present controlled data shapes but underlying permissions must still enforce security.

Incorrect Answers

A:

The second deployment creates more lookup codes than the first although the business catalog is unchanged. Views can present controlled data shapes but underlying permissions must still enforce security. An access audit shows the reporting service can read full customer rows although it only needs totals.

B:

A privileged test account can still select restricted rows despite the trigger firing on writes. Views can present controlled data shapes but underlying permissions must still enforce security. An access audit shows the reporting service can read full customer rows although it only needs totals.

D:

The attempted update fails because SQL cannot map a calculated view field to one base column. Views can present controlled data shapes but underlying permissions must still enforce security. An access audit shows the reporting service can read full customer rows although it only needs totals.

Question 175

A shared function retrieves customer contract records using a tenant identifier supplied by an untrusted caller. What should the database developer verify to confirm the suspected cause?

  1. A caller can pass another tenant ID and currently obtain rows belonging to it.
  2. The second deployment creates more lookup codes than the first although the business catalog is unchanged.
  3. A single business update produces multiple trigger invocations and unexpectedly many row writes.
  4. An injected failure leaves the order header committed while required detail lines are missing.

Explanation

Correct Answer

A:

A caller can pass another tenant ID and currently obtain rows belonging to it. Parameterization does not itself establish a row-level security boundary.

Incorrect Answers

B:

The second deployment creates more lookup codes than the first although the business catalog is unchanged. Parameterization does not itself establish a row-level security boundary. A caller can pass another tenant ID and currently obtain rows belonging to it.

C:

A single business update produces multiple trigger invocations and unexpectedly many row writes. Parameterization does not itself establish a row-level security boundary. A caller can pass another tenant ID and currently obtain rows belonging to it.

D:

An injected failure leaves the order header committed while required detail lines are missing. Parameterization does not itself establish a row-level security boundary. A caller can pass another tenant ID and currently obtain rows belonging to it.

Question 176

A checkout workflow inserts an order and several details through separate client requests, leaving partial orders when one call fails. How should the SQL engineering team confirm the issue is truly resolved?

  1. A one-row and batch update test each produce only expected changes with bounded trigger work.
  2. Unauthorized selects are blocked by permissions and legitimate data changes produce reliable audit records.
  3. Either the complete authorized order is committed or the entire unit of work is rolled back.
  4. Representative small and large parameter tests both meet latency with acceptable compilation cost.

Explanation

Correct Answer

C:

Either the complete authorized order is committed or the entire unit of work is rolled back.

Incorrect Answers

A:

A one-row and batch update test each produce only expected changes with bounded trigger work. Either the complete authorized order is committed or the entire unit of work is rolled back.

B:

Unauthorized selects are blocked by permissions and legitimate data changes produce reliable audit records. Either the complete authorized order is committed or the entire unit of work is rolled back.

D:

Representative small and large parameter tests both meet latency with acceptable compilation cost. Either the complete authorized order is committed or the entire unit of work is rolled back.

Question 177

A multitenant billing application assumes invoice codes are globally unique but the actual rule requires uniqueness only within each tenant. Which outcome shows the requirement is met without introducing a new risk?

  1. The reviewed process handles personal data in both periods according to retention obligations.
  2. The revised schema supports required searches while reducing unnecessary storage and migration burden.
  3. Each tenant has unique invoice codes while other tenants can reuse the same code safely.
  4. Malformed inputs are rejected and valid representative payloads remain queryable.

Explanation

Correct Answer

C:

Each tenant has unique invoice codes while other tenants can reuse the same code safely. A multitenant billing application assumes invoice codes are globally unique but the actual rule requires uniqueness only within each tenant.

Incorrect Answers

A:

The reviewed process handles personal data in both periods according to retention obligations. A multitenant billing application assumes invoice codes are globally unique but the actual rule requires uniqueness only within each tenant. Each tenant has unique invoice codes while other tenants can reuse the same code safely.

B:

The revised schema supports required searches while reducing unnecessary storage and migration burden. A multitenant billing application assumes invoice codes are globally unique but the actual rule requires uniqueness only within each tenant. Each tenant has unique invoice codes while other tenants can reuse the same code safely.

D:

Malformed inputs are rejected and valid representative payloads remain queryable. A multitenant billing application assumes invoice codes are globally unique but the actual rule requires uniqueness only within each tenant. Each tenant has unique invoice codes while other tenants can reuse the same code safely.

Question 178

A high-volume retail database must publish changes to downstream near-real-time consumers without exposing operational credentials to every subscriber. Which concept should guide the database developer in this situation?

  1. Caching must respect correctness and freshness requirements for mutable business records.
  2. Deployable API configuration is part of the governed application artifact.
  3. Change event streaming separates producer tables from subscriber access when correctly configured.
  4. An API contract should expose bounded domain operations rather than unrestricted SQL execution.

Explanation

Correct Answer

C:

Change event streaming separates producer tables from subscriber access when correctly configured.

Incorrect Answers

A:

Caching must respect correctness and freshness requirements for mutable business records. Change event streaming separates producer tables from subscriber access when correctly configured.

B:

Deployable API configuration is part of the governed application artifact. Change event streaming separates producer tables from subscriber access when correctly configured.

D:

An API contract should expose bounded domain operations rather than unrestricted SQL execution. Change event streaming separates producer tables from subscriber access when correctly configured.

Question 179

A global incident system includes support notes in six languages and its English-only embedding model retrieves poor results for non-English tickets. What should the database developer do FIRST within approved procedures?

  1. Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks.
  2. Evaluate multimodal models or appropriately separated image/text embeddings with clear data handling rules.
  3. Evaluate multilingual embedding models against labeled cross-language retrieval tests and relevant privacy constraints.
  4. Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation.

Explanation

Correct Answer

C:

Evaluate multilingual embedding models against labeled cross-language retrieval tests and relevant privacy constraints. Embedding model suitability depends on supported languages and measured retrieval performance.

Incorrect Answers

A:

Use an event-driven Azure Function SQL trigger pattern with durable retries and source version checks. Embedding model suitability depends on supported languages and measured retrieval performance. Evaluate multilingual embedding models against labeled cross-language retrieval tests and relevant privacy constraints.

B:

Evaluate multimodal models or appropriately separated image/text embeddings with clear data handling rules. Embedding model suitability depends on supported languages and measured retrieval performance. Evaluate multilingual embedding models against labeled cross-language retrieval tests and relevant privacy constraints.

D:

Benchmark a suitable supported model for structured output on representative invoices and enforce schema validation. Embedding model suitability depends on supported languages and measured retrieval performance. Evaluate multilingual embedding models against labeled cross-language retrieval tests and relevant privacy constraints.

Question 180

A public inventory endpoint returns an unbounded number of rows and one client can exhaust resources by requesting the entire catalog. How should the SQL engineering team confirm the issue is truly resolved?

  1. Consumers receive authorized change events and cannot read unrelated database records.
  2. An API test enforces page size and returns deterministic next pages without missing or duplicating items.
  3. Direct unauthenticated calls fail while gateway-routed authorized traffic succeeds.
  4. The published API exposes only the expected shipment fields and rejects forbidden routes.

Explanation

Correct Answer

B:

An API test enforces page size and returns deterministic next pages without missing or duplicating items.

Incorrect Answers

A:

Consumers receive authorized change events and cannot read unrelated database records. An API test enforces page size and returns deterministic next pages without missing or duplicating items.

C:

Direct unauthenticated calls fail while gateway-routed authorized traffic succeeds. An API test enforces page size and returns deterministic next pages without missing or duplicating items.

D:

The published API exposes only the expected shipment fields and rejects forbidden routes. An API test enforces page size and returns deterministic next pages without missing or duplicating items.

Developing AI-Enabled Database Solutions (DP-800) Practice Tests