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 25
Question 240
A SQL Database Project changes a discount procedure but the pipeline has only build success checks and no tests of edge-case numeric outputs. Which corrective action best fits the observed symptoms?
Explanation
Correct Answer
Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment. A schema build validates structure but does not prove business-rule correctness.
Incorrect Answers
Configure the supported SDK-style project, dependencies, and build validation in CI. A schema build validates structure but does not prove business-rule correctness. Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment.
Block promotion until data impact and an approved migration strategy are verified. A schema build validates structure but does not prove business-rule correctness. Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment.
Use an expand-and-contract migration or controlled compatibility strategy with rollback testing. A schema build validates structure but does not prove business-rule correctness. Add unit tests covering normal orders, null inputs, boundary discounts, and rollbacks before deployment.
Question 241
A procedure posts an invoice and then calls a failing validation routine; the customer balance remains changed because the error is swallowed. What is the underlying reason for the corrective step?
Explanation
Correct Answer
T-SQL error handling must preserve transaction atomicity rather than merely log exceptions.
Incorrect Answers
MATCH expresses graph patterns across documented node and edge relationships. T-SQL error handling must preserve transaction atomicity rather than merely log exceptions.
Regex substitution supports structured redaction only when patterns are thoroughly validated. T-SQL error handling must preserve transaction atomicity rather than merely log exceptions.
Regular expressions are useful for pattern-based text operations but require careful definitions and performance tests. T-SQL error handling must preserve transaction atomicity rather than merely log exceptions.
Question 242
Two inventory workers read the same quantity, compute a decrement, and then overwrite each other's result without conflict detection. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
A parallel test leaves inventory higher than the total number of fulfilled orders implies. Business data consistency requires protecting read-modify-write sequences.
Incorrect Answers
Query Store shows the same query hash shifted to a more expensive plan after deployment. Business data consistency requires protecting read-modify-write sequences. A parallel test leaves inventory higher than the total number of fulfilled orders implies.
Read workloads show shared/exclusive lock contention during a legitimate batch update. Business data consistency requires protecting read-modify-write sequences. A parallel test leaves inventory higher than the total number of fulfilled orders implies.
A simultaneous test creates two confirmed bookings for one remaining seat. Business data consistency requires protecting read-modify-write sequences. A parallel test leaves inventory higher than the total number of fulfilled orders implies.
Question 243
An Azure Function consumes SQL change events with a credential that also grants access to unrelated financial tables. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Grant the function only the change-data access it requires and review its output destination. Background integrations require narrowly scoped identities just as interactive users do.
Incorrect Answers
Apply DAB roles, entity permissions, and backend identity least privilege with negative tests. Background integrations require narrowly scoped identities just as interactive users do. Grant the function only the change-data access it requires and review its output destination.
Plan coordinated key rotation and recovery testing before replacing or retiring key material. Background integrations require narrowly scoped identities just as interactive users do. Grant the function only the change-data access it requires and review its output destination.
Classify and minimize data before embedding and protect vector storage and retrieval with appropriate permissions. Background integrations require narrowly scoped identities just as interactive users do. Grant the function only the change-data access it requires and review its output destination.
Question 244
A release changes a table consumed by an older mobile API but no backward-compatibility window or rollback plan exists. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Use an expand-and-contract migration or controlled compatibility strategy with rollback testing. Both old and new clients function through the transition and rollback works in a rehearsed test.
Both old and new clients function through the transition and rollback works in a rehearsed test. The accompanying action is to use an expand-and-contract migration or controlled compatibility strategy with rollback testing.
Incorrect Answers
Add a versioned compatible database-model reference and restore dependencies in a clean environment. Both old and new clients function through the transition and rollback works in a rehearsed test.
Resolve schema conflicts with a model diff and tests before approving the combined pull request. Both old and new clients function through the transition and rollback works in a rehearsed test.
The pipeline rejects the faulty change and accepts the corrected procedure with verified results. Both old and new clients function through the transition and rollback works in a rehearsed test. The accompanying action is to use an expand-and-contract migration or controlled compatibility strategy with rollback testing.
Question 245
A development team runs Data API builder with a local configuration but its production container lacks the approved connection settings and role maps. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Version the DAB configuration and use environment-specific secret injection and validation during deployment. A clean deployment uses the reviewed configuration, passes tests, and stores no credentials in the image.
A clean deployment uses the reviewed configuration, passes tests, and stores no credentials in the image. The corresponding check is whether version the DAB configuration and use environment-specific secret injection and validation during deployment.
Incorrect Answers
Enable suitable Application Insights and Log Analytics telemetry with correlation IDs and safe logging. A clean deployment uses the reviewed configuration, passes tests, and stores no credentials in the image. Version the DAB configuration and use environment-specific secret injection and validation during deployment.
A client retrieves only changed keys since its saved version and safely handles retention gaps. A clean deployment uses the reviewed configuration, passes tests, and stores no credentials in the image. Version the DAB configuration and use environment-specific secret injection and validation during deployment.
Expose only approved procedure or entity operations through supported DAB configuration with authorization. A clean deployment uses the reviewed configuration, passes tests, and stores no credentials in the image. Version the DAB configuration and use environment-specific secret injection and validation during deployment.
Question 246
A developer asks Copilot to fix a production query and reports that the database is repaired because the chat returned corrected code. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Separate assistant suggestions from approved, executed changes and verify actual database state through controlled deployment.
A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure. Separate assistant suggestions from approved, executed changes and verify actual database state through controlled deployment.
Incorrect Answers
Eligible users can perform an approved task and excluded users cannot access unsupported capabilities. Separate assistant suggestions from approved, executed changes and verify actual database state through controlled deployment. A reviewed migration is applied through the authorized pipeline and subsequent tests confirm the changed procedure.
Create reviewed repository instruction files that specify migration, test, and secure coding conventions without embedding secrets. Separate assistant suggestions from approved, executed changes and verify actual database state through controlled deployment.
Compare recommendations with actual workload plans, maintenance costs, and performance tests before approval. Separate assistant suggestions from approved, executed changes and verify actual database state through controlled deployment.
Question 247
A supplier sends one JSON payload containing an array of shipment items and the importer currently saves the array as an opaque string. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Use OPENJSON with an explicit schema to expand validated line items into relational rows. A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency.
A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency.
Incorrect Answers
Every product row matches the latest approved price in its own region as of the test date. A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency.
Extract the required JSON property and convert it to an appropriate numeric type with invalid-data handling. A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency.
Evaluate a graph MATCH query against the node and edge model and check result completeness. A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency. Use OPENJSON with an explicit schema to expand validated line items into relational rows.
Question 248
A GraphQL response is slow for deeply nested selections and the team considers adding larger SQL capacity without identifying the expensive path. Which concept should guide the database developer in this situation?
Explanation
Correct Answer
Performance diagnosis should correlate API request complexity with SQL execution work.
Incorrect Answers
Data API builder configuration determines service surface and must follow least-privilege exposure. Performance diagnosis should correlate API request complexity with SQL execution work.
Event-driven consumers need replay-safe logic even when the source binding tracks changes. Performance diagnosis should correlate API request complexity with SQL execution work.
An API contract should expose bounded domain operations rather than unrestricted SQL execution. Performance diagnosis should correlate API request complexity with SQL execution work.
Question 249
A database project adds a broad GRANT SELECT to PUBLIC because a generated SQL suggestion says it simplifies application connectivity. How should the SQL engineering team confirm the issue is truly resolved?
Explanation
Correct Answer
Unauthorized test principals receive access-denied errors while application queries still work. The operating rule is: Database project source code must include secure authorization decisions, not just schema shapes.
Incorrect Answers
A tested failing pull request is blocked and approved changes follow the defined merge path. The operating rule is: Database project source code must include secure authorization decisions, not just schema shapes. Unauthorized test principals receive access-denied errors while application queries still work.
The drift is reviewed, either incorporated or reverted, and deployment reports no unexplained difference. The operating rule is: Database project source code must include secure authorization decisions, not just schema shapes. Unauthorized test principals receive access-denied errors while application queries still work.
Both old and new clients function through the transition and rollback works in a rehearsed test. The operating rule is: Database project source code must include secure authorization decisions, not just schema shapes. Unauthorized test principals receive access-denied errors while application queries still work.
Question 250
A recommendation service ranks products only by vector similarity and shows discontinued items because business eligibility filters are ignored. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
Results remain relevant and exclude ineligible inventory under tested status changes. The operating rule is: Semantic similarity is one retrieval signal and cannot override transactional business constraints.
Incorrect Answers
A combined benchmark retrieves both precise code matches and relevant related explanations. The operating rule is: Semantic similarity is one retrieval signal and cannot override transactional business constraints. Results remain relevant and exclude ineligible inventory under tested status changes.
The combined ranking balances relevant candidates from both lists according to measured relevance. The operating rule is: Semantic similarity is one retrieval signal and cannot override transactional business constraints. Results remain relevant and exclude ineligible inventory under tested status changes.
Relevant terms are found with improved latency and accepted linguistic precision. The operating rule is: Semantic similarity is one retrieval signal and cannot override transactional business constraints. Results remain relevant and exclude ineligible inventory under tested status changes.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 23 - 10 Questions (Last Reviewed 25-Oct-2026)
- Microsoft DP-800 Practice Test 24 - 10 Questions (Last Reviewed 24-Oct-2026)
- Microsoft DP-800 Practice Test 25 - 10 Questions (Last Reviewed 23-Oct-2026)
- Microsoft DP-800 Practice Test 26 - 10 Questions (Last Reviewed 22-Oct-2026)
- Microsoft DP-800 Practice Test 27 - 10 Questions (Last Reviewed 21-Oct-2026)