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 19
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.
Question 181
An inventory update and fulfillment job update the same tables in opposite orders and periodic SQL deadlock victims trigger retries. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Analyze the deadlock graph and standardize access order or shorten transactions based on evidence. Repeated parallel tests no longer reproduce the deadlock and functional outcomes remain correct.
Repeated parallel tests no longer reproduce the deadlock and functional outcomes remain correct. The corresponding check is whether analyze the deadlock graph and standardize access order or shorten transactions based on evidence.
Incorrect Answers
Concurrent fulfillment produces consistent stock and conflicting updates are retried or rejected. Repeated parallel tests no longer reproduce the deadlock and functional outcomes remain correct. Analyze the deadlock graph and standardize access order or shorten transactions based on evidence.
Use an atomic update or optimistic concurrency check to prevent lost updates. Repeated parallel tests no longer reproduce the deadlock and functional outcomes remain correct. Analyze the deadlock graph and standardize access order or shorten transactions based on evidence.
Use Query Store to compare recorded plans and runtime metrics, then test an appropriate plan-correction strategy. Repeated parallel tests no longer reproduce the deadlock and functional outcomes remain correct. Analyze the deadlock graph and standardize access order or shorten transactions based on evidence.
Question 182
A repository instruction file contains real customer identities and sample tokens because the developer copied a production incident into the guide. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Replace live values with safe synthetic examples and enforce repository secret and privacy scanning. Assistant context files are source-controlled assets that must follow normal information security standards.
Incorrect Answers
Compare recommendations with actual workload plans, maintenance costs, and performance tests before approval. Assistant context files are source-controlled assets that must follow normal information security standards. Replace live values with safe synthetic examples and enforce repository secret and privacy scanning.
Create reviewed repository instruction files that specify migration, test, and secure coding conventions without embedding secrets. Assistant context files are source-controlled assets that must follow normal information security standards. Replace live values with safe synthetic examples and enforce repository secret and privacy scanning.
Add representative test data and assert the business outputs before accepting the generated change. Assistant context files are source-controlled assets that must follow normal information security standards. Replace live values with safe synthetic examples and enforce repository secret and privacy scanning.
Question 183
A database team knows only that an Azure SQL service is slower after peak traffic but does not know which query consumes resources. What technical finding would substantiate this root cause?
Explanation
Correct Answer
Resource charts show high CPU while the team has no ranked list of query costs. Performance tuning should begin with measured high-impact queries rather than random configuration changes.
Incorrect Answers
The captured plan was compiled with a tiny tenant ID and scans badly when reused for a huge tenant. Performance tuning should begin with measured high-impact queries rather than random configuration changes. Resource charts show high CPU while the team has no ranked list of query costs.
A simultaneous test creates two confirmed bookings for one remaining seat. Performance tuning should begin with measured high-impact queries rather than random configuration changes. Resource charts show high CPU while the team has no ranked list of query costs.
A blocked request waits behind a long-running transaction but no deadlock victim is recorded. Performance tuning should begin with measured high-impact queries rather than random configuration changes. Resource charts show high CPU while the team has no ranked list of query costs.
Question 184
A checkout workflow inserts an order and several details through separate client requests, leaving partial orders when one call fails. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
Use a stored procedure with an explicit transaction, input validation, and appropriate error handling. Either the complete authorized order is committed or the entire unit of work is rolled back.
Either the complete authorized order is committed or the entire unit of work is rolled back. The accompanying action is to use a stored procedure with an explicit transaction, input validation, and appropriate error handling.
Incorrect Answers
Create an appropriately permissioned view that projects only authorized aggregated fields. Either the complete authorized order is committed or the entire unit of work is rolled back. Use a stored procedure with an explicit transaction, input validation, and appropriate error handling.
Make reference-data seeding idempotent using stable keys and transactional checks. Either the complete authorized order is committed or the entire unit of work is rolled back.
A revised query returns identical outputs with materially less CPU under production-like data. Either the complete authorized order is committed or the entire unit of work is rolled back.
Question 185
A customer analytics query calls an expensive scalar UDF for every row and slows dramatically during monthly aggregation. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
Set-based SQL processing can avoid per-row procedural overhead when the function is compatible.
Incorrect Answers
Procedure performance can vary with parameter cardinality even when SQL text is unchanged. Set-based SQL processing can avoid per-row procedural overhead when the function is compatible.
Table-valued functions encapsulate reusable relational logic and must be tested for parameter behavior. Set-based SQL processing can avoid per-row procedural overhead when the function is compatible.
Views can present controlled data shapes but underlying permissions must still enforce security. Set-based SQL processing can avoid per-row procedural overhead when the function is compatible.
Question 186
A policy assistant cannot find an approved exception clause but generates a confident one from similarly worded historic notes. Which technical principle explains the correct response?
Explanation
Correct Answer
A RAG solution must acknowledge unsupported questions rather than invent source authority.
Incorrect Answers
External REST calls from SQL must minimize disclosed data and enforce endpoint security. A RAG solution must acknowledge unsupported questions rather than invent source authority.
A structured interchange format can make SQL-to-model data safer and less ambiguous than string concatenation. A RAG solution must acknowledge unsupported questions rather than invent source authority.
RAG context assembly trades completeness, relevance, cost, and model window constraints. A RAG solution must acknowledge unsupported questions rather than invent source authority.
Question 187
A product catalog stores an occasionally filtered JSON status and developers want a reliable indexed search across supported SQL versions. Which technical principle explains the correct response?
Explanation
Correct Answer
Semi-structured filtering benefits from access-path design tied to engine/version capabilities.
Incorrect Answers
Partitioning can make range maintenance practical when keys and boundaries match retention policy. Semi-structured filtering benefits from access-path design tied to engine/version capabilities.
Columnstore storage can improve scan-heavy analytics but its operational tradeoffs must be tested. Semi-structured filtering benefits from access-path design tied to engine/version capabilities.
Columnstore health depends on ingestion and modification patterns as well as index creation. Semi-structured filtering benefits from access-path design tied to engine/version capabilities.
Question 188
A database project adds a broad GRANT SELECT to PUBLIC because a generated SQL suggestion says it simplifies application connectivity. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
Unauthorized test principals receive access-denied errors while application queries still work.
Reject the broad grant and model only narrowly required role permissions in reviewed project files. Unauthorized test principals receive access-denied errors while application queries still work.
Incorrect Answers
Version reference data in a reviewed idempotent deployment process with migration tests. Unauthorized test principals receive access-denied errors while application queries still work.
Use schema drift detection against the authoritative SQL Database Project and reconcile the change before deployment. Unauthorized test principals receive access-denied errors while application queries still work.
The pipeline rejects the faulty change and accepts the corrected procedure with verified results. Unauthorized test principals receive access-denied errors while application queries still work.
Question 189
A multitenant application uses SESSION_CONTEXT for an RLS predicate but allows ordinary users to supply any tenant identifier in the login request. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
A test user changes the tenant value and retrieves another client's otherwise protected rows. RLS predicate quality depends on the integrity of the identity information it consumes.
Incorrect Answers
A direct query by a client login returns tickets belonging to a different tenant. RLS predicate quality depends on the integrity of the identity information it consumes. A test user changes the tenant value and retrieves another client's otherwise protected rows.
Application credential inspection shows ALTER and DROP privileges over unrelated schema objects. RLS predicate quality depends on the integrity of the identity information it consumes. A test user changes the tenant value and retrieves another client's otherwise protected rows.
A test prompt can invoke an ALTER TABLE through the assistant without human authorization. RLS predicate quality depends on the integrity of the identity information it consumes. A test user changes the tenant value and retrieves another client's otherwise protected rows.
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.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- 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)
- Microsoft DP-800 Practice Test 21 - 10 Questions (Last Reviewed 27-Oct-2026)