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 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?
Explanation
Correct Answer
A project needs explicit versioned dependencies to support repeatable builds.
Incorrect Answers
Schema evolution should account for clients with independent deployment cycles. A project needs explicit versioned dependencies to support repeatable builds.
Database project source code must include secure authorization decisions, not just schema shapes. A project needs explicit versioned dependencies to support repeatable builds.
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?
Explanation
Correct Answer
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 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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
The web application runs normal queries while an attempted schema modification is denied.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
Either the complete authorized order is committed or the entire unit of work is rolled back.
Incorrect Answers
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.
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.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
Change event streaming separates producer tables from subscriber access when correctly configured.
Incorrect Answers
Caching must respect correctness and freshness requirements for mutable business records. Change event streaming separates producer tables from subscriber access when correctly configured.
Deployable API configuration is part of the governed application artifact. Change event streaming separates producer tables from subscriber access when correctly configured.
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?
Explanation
Correct Answer
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
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.
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.
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?
Explanation
Correct Answer
An API test enforces page size and returns deterministic next pages without missing or duplicating items.
Incorrect Answers
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.
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.
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
- 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)
- 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)