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 62
Question 610
An administrator uses a DML trigger to log unauthorized table changes and assumes the trigger alone prevents data exfiltration. Choose TWO: one correct response and one verification of success.
Explanation
Correct Answers
Unauthorized selects are blocked by permissions and legitimate data changes produce reliable audit records. Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing.
Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing.
Incorrect Answers
Enforce database-side authorization for the invoking identity and validate tenant access rather than trust the function argument alone. Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing. Unauthorized selects are blocked by permissions and legitimate data changes produce reliable audit records.
Create an appropriately permissioned view that projects only authorized aggregated fields. Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing. Unauthorized selects are blocked by permissions and legitimate data changes produce reliable audit records.
The service can query approved totals and receives an authorization error for direct sensitive table reads. Keep granular permissions as the access barrier and implement carefully tested triggers only for appropriate data-change auditing. Unauthorized selects are blocked by permissions and legitimate data changes produce reliable audit records.
Question 611
A frequently executed dashboard query filters a narrow index but retrieves many extra columns through repeated key lookups. Which TWO options together specify a corrective step and a meaningful test?
Explanation
Correct Answers
The chosen change lowers total reads without an unacceptable index maintenance penalty. The corresponding check is whether assess a covering index or query projection change with real selectivity and write overhead.
Assess a covering index or query projection change with real selectivity and write overhead. The chosen change lowers total reads without an unacceptable index maintenance penalty.
Incorrect Answers
The validated remedy shortens lock waits and separate deadlock monitoring remains stable. The chosen change lowers total reads without an unacceptable index maintenance penalty.
Measure actual fragmentation, page density, workload plans, and maintenance impact before a rebuild policy. The chosen change lowers total reads without an unacceptable index maintenance penalty.
Choose transactional locking or isolation that enforces the reservation invariant under concurrency. The chosen change lowers total reads without an unacceptable index maintenance penalty. Assess a covering index or query projection change with real selectivity and write overhead.
Question 612
A finance team wants governed SQL access to source files outside its operational database without importing a fresh copy for every query. Which technical principle explains the correct response?
Explanation
Correct Answer
External tables can expose remote data logically while preserving data-location and access considerations.
Incorrect Answers
Schema flexibility must be balanced with data integrity and queryability rather than chosen by column count alone. External tables can expose remote data logically while preserving data-location and access considerations.
Uniqueness keys must encode the business scope of identity rather than an arbitrary column. External tables can expose remote data logically while preserving data-location and access considerations.
A graph model can express connected entities but it is not automatically better for simple relational lookups. External tables can expose remote data logically while preserving data-location and access considerations.
Question 613
A sales query must retrieve the latest approved regional price for each product and selecting MAX date alone produces mismatched prices. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Every product row matches the latest approved price in its own region as of the test date. A sales query must retrieve the latest approved regional price for each product and selecting MAX date alone produces mismatched prices. Use a properly correlated subquery or APPLY pattern that ties price, region, approval status, and effective date together.
Use a properly correlated subquery or APPLY pattern that ties price, region, approval status, and effective date together. A sales query must retrieve the latest approved regional price for each product and selecting MAX date alone produces mismatched prices.
Incorrect Answers
Use a common table expression to define the intermediate eligible set once and validate its filters. A sales query must retrieve the latest approved regional price for each product and selecting MAX date alone produces mismatched prices. Use a properly correlated subquery or APPLY pattern that ties price, region, approval status, and effective date together.
Use an exact validated pattern and a supported REGEXP_COUNT function where available. A sales query must retrieve the latest approved regional price for each product and selecting MAX date alone produces mismatched prices. Use a properly correlated subquery or APPLY pattern that ties price, region, approval status, and effective date together.
All representative sensitive tokens are masked while non-account numbers remain intact. A sales query must retrieve the latest approved regional price for each product and selecting MAX date alone produces mismatched prices. Every product row matches the latest approved price in its own region as of the test date.
Question 614
A web application database login has db_owner privileges solely because its installation script creates a few tables during deployment. What technical finding would substantiate this root cause?
Explanation
Correct Answer
Application credential inspection shows ALTER and DROP privileges over unrelated schema objects. Least privilege distinguishes runtime data access from administrative deployment responsibilities.
Incorrect Answers
The current logs show query counts but cannot identify permission grant activity or responsible principals. Least privilege distinguishes runtime data access from administrative deployment responsibilities. Application credential inspection shows ALTER and DROP privileges over unrelated schema objects.
The function principal appears in an admin role despite processing one published change feed. Least privilege distinguishes runtime data access from administrative deployment responsibilities. Application credential inspection shows ALTER and DROP privileges over unrelated schema objects.
A database support login can read every salary directly in plaintext despite lacking a payroll role. Least privilege distinguishes runtime data access from administrative deployment responsibilities. Application credential inspection shows ALTER and DROP privileges over unrelated schema objects.
Question 615
A developer asks Copilot to fix a production query and reports that the database is repaired because the chat returned corrected code. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
The query explanation shows proposed changes but the database still contains the original stored procedure. Generated SQL text is not evidence of a successful database change.
Incorrect Answers
The malicious instruction appears in a database comment rather than an approved developer request. Generated SQL text is not evidence of a successful database change. The query explanation shows proposed changes but the database still contains the original stored procedure.
The faster version silently drops refunds because a new INNER JOIN filters unmatched rows. Generated SQL text is not evidence of a successful database change. The query explanation shows proposed changes but the database still contains the original stored procedure.
A test configuration points at an unapproved external model endpoint while developers paste production schema details. Generated SQL text is not evidence of a successful database change. The query explanation shows proposed changes but the database still contains the original stored procedure.
Question 616
A reporting service needs current invoice totals but must not expose underlying customer identifiers and the API currently queries raw tables directly. Which next step most directly resolves this SQL solution issue?
Explanation
Correct Answer
Create an appropriately permissioned view that projects only authorized aggregated fields. Views can present controlled data shapes but underlying permissions must still enforce security.
Incorrect Answers
Make reference-data seeding idempotent using stable keys and transactional checks. Views can present controlled data shapes but underlying permissions must still enforce security. Create an appropriately permissioned view that projects only authorized aggregated fields.
Review trigger nesting, rowset handling, and the necessity of the write-back operation. Views can present controlled data shapes but underlying permissions must still enforce security. Create an appropriately permissioned view that projects only authorized aggregated fields.
Use a stored procedure with an explicit transaction, input validation, and appropriate error handling. Views can present controlled data shapes but underlying permissions must still enforce security. Create an appropriately permissioned view that projects only authorized aggregated fields.
Question 617
An update trigger writes back to the same customer table and some releases cause chains of repeated updates and log expansion. Which observation is the strongest evidence for the reported problem?
Explanation
Correct Answer
A single business update produces multiple trigger invocations and unexpectedly many row writes. Triggers execute within database write workflows and need safeguards against recursion and broad unintended effects.
Incorrect Answers
An injected failure leaves the order header committed while required detail lines are missing. Triggers execute within database write workflows and need safeguards against recursion and broad unintended effects. A single business update produces multiple trigger invocations and unexpectedly many row writes.
The attempted update fails because SQL cannot map a calculated view field to one base column. Triggers execute within database write workflows and need safeguards against recursion and broad unintended effects. A single business update produces multiple trigger invocations and unexpectedly many row writes.
A privileged test account can still select restricted rows despite the trigger firing on writes. Triggers execute within database write workflows and need safeguards against recursion and broad unintended effects. A single business update produces multiple trigger invocations and unexpectedly many row writes.
Question 618
A release changes a table consumed by an older mobile API but no backward-compatibility window or rollback plan exists. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
Staging API calls fail immediately after the database rename while some clients cannot update overnight. Schema evolution should account for clients with independent deployment cycles.
Incorrect Answers
A staged test user can query sensitive salary columns without being assigned an appropriate role. Schema evolution should account for clients with independent deployment cycles. Staging API calls fail immediately after the database rename while some clients cannot update overnight.
The merge compiles each branch separately but produces conflicting definitions in the combined model. Schema evolution should account for clients with independent deployment cycles. Staging API calls fail immediately after the database rename while some clients cannot update overnight.
Predeployment comparison shows the live procedure body differs from the reviewed project model. Schema evolution should account for clients with independent deployment cycles. Staging API calls fail immediately after the database rename while some clients cannot update overnight.
Question 619
A semantic search service compares embedding vectors with inconsistent magnitudes and treats raw dot-product scores as comparable cosine similarity. What would be a valid post-database-change verification?
Explanation
Correct Answer
Benchmark ordering matches a validated metric-specific reference calculation. The supporting symptom is: The same semantic candidate changes rank mainly because of vector magnitude rather than meaning.
Incorrect Answers
Results remain relevant and exclude ineligible inventory under tested status changes. The supporting symptom is: The same semantic candidate changes rank mainly because of vector magnitude rather than meaning. Benchmark ordering matches a validated metric-specific reference calculation.
A tested query returns the expected nearest vector rows with reproducible distance values. The supporting symptom is: The same semantic candidate changes rank mainly because of vector magnitude rather than meaning. Benchmark ordering matches a validated metric-specific reference calculation.
A combined benchmark retrieves both precise code matches and relevant related explanations. The supporting symptom is: The same semantic candidate changes rank mainly because of vector magnitude rather than meaning. Benchmark ordering matches a validated metric-specific reference calculation.
Question 620
A coding assistant recommends several indexes on an order database without seeing production write frequency or storage quotas. What should the database developer verify to confirm the suspected cause?
Explanation
Correct Answer
The suggested indexes improve one sample query but double write latency during batch imports. AI suggestions must be benchmarked against production-like workload tradeoffs rather than adopted by confidence.
Incorrect Answers
The malicious instruction appears in a database comment rather than an approved developer request. AI suggestions must be benchmarked against production-like workload tradeoffs rather than adopted by confidence. The suggested indexes improve one sample query but double write latency during batch imports.
A proposed query runs faster in a developer test but returns records belonging to other tenants. AI suggestions must be benchmarked against production-like workload tradeoffs rather than adopted by confidence. The suggested indexes improve one sample query but double write latency during batch imports.
MCP tool metadata shows privileges that include schema changes and unrelated sensitive tables. AI suggestions must be benchmarked against production-like workload tradeoffs rather than adopted by confidence. The suggested indexes improve one sample query but double write latency during batch imports.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 60 - 10 Questions (Last Reviewed 14-Nov-2026)
- Microsoft DP-800 Practice Test 61 - 10 Questions (Last Reviewed 13-Nov-2026)
- Microsoft DP-800 Practice Test 62 - 10 Questions (Last Reviewed 12-Nov-2026)
- Microsoft DP-800 Practice Test 63 - 10 Questions (Last Reviewed 11-Nov-2026)
- Microsoft DP-800 Practice Test 64 - 10 Questions (Last Reviewed 10-Nov-2026)