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 5
Question 40
A GitHub Copilot chat connects to a SQL MCP server configured with a broad administrator identity and developers plan to run generated queries against production. Select TWO: the best action and the outcome that confirms it worked.
Explanation
Correct Answers
Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution. A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions.
A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions. The corresponding check is whether reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.
Incorrect Answers
The assistant ignores the embedded command and logs no attempt to access the secret table. A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.
Replace live values with safe synthetic examples and enforce repository secret and privacy scanning. A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.
Create reviewed repository instruction files that specify migration, test, and secure coding conventions without embedding secrets. A permission test limits the tool to permitted read or approved write scopes and blocks forbidden actions. Reconfigure the MCP endpoint with least-privilege access and narrow approved operations before any production execution.
Question 41
A supplier sends one JSON payload containing an array of shipment items and the importer currently saves the array as an opaque string. Which outcome shows the requirement is met without introducing a new risk?
Explanation
Correct Answer
A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency. The supporting symptom is: The database stores one row per shipment but cannot query per-item quantities or product codes.
Incorrect Answers
The validation error results in a fully consistent rollback and a diagnostic error response. The supporting symptom is: The database stores one row per shipment but cannot query per-item quantities or product codes. A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency.
A test reconciles cumulative balances with the ledger using explicit ordering. The supporting symptom is: The database stores one row per shipment but cannot query per-item quantities or product codes. A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency.
Every product row matches the latest approved price in its own region as of the test date. The supporting symptom is: The database stores one row per shipment but cannot query per-item quantities or product codes. A test payload yields the correct line records and rejects invalid quantities without losing transaction consistency.
Question 42
A support platform stores optional case attributes in a JSON column and filters on a frequent nested risk-level property at scale. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Design JSON access and indexing according to the engine's supported JSON features and test the predicate. Semi-structured JSON still needs deliberate schema validation and indexing for predictable filtering.
Incorrect Answers
Evaluate normalized, JSON, or sparse-column designs against actual query needs and engine support. Semi-structured JSON still needs deliberate schema validation and indexing for predictable filtering. Design JSON access and indexing according to the engine's supported JSON features and test the predicate.
Evaluate system-versioned temporal tables with history retention and appropriate access controls. Semi-structured JSON still needs deliberate schema validation and indexing for predictable filtering. Design JSON access and indexing according to the engine's supported JSON features and test the predicate.
Implement a correctly scoped foreign key and repair existing violations before enabling trusted enforcement. Semi-structured JSON still needs deliberate schema validation and indexing for predictable filtering. Design JSON access and indexing according to the engine's supported JSON features and test the predicate.
Question 43
An engineering help-desk needs exact error-code matching plus conceptually relevant troubleshooting articles and neither keyword nor vectors alone performs well. What should the database developer verify to confirm the suspected cause?
Explanation
Correct Answer
Keyword search misses paraphrases while vector-only search misses rare literal error codes. Hybrid search can combine complementary lexical precision and semantic recall.
Incorrect Answers
An Arabic customer question fails to retrieve an otherwise relevant Spanish-language document. Hybrid search can combine complementary lexical precision and semantic recall. Keyword search misses paraphrases while vector-only search misses rare literal error codes.
Fast approximate results sometimes omit the known closest passage in labeled tests. Hybrid search can combine complementary lexical precision and semantic recall. Keyword search misses paraphrases while vector-only search misses rare literal error codes.
Users routinely find the correct manual beyond the top ten results or not at all. Hybrid search can combine complementary lexical precision and semantic recall. Keyword search misses paraphrases while vector-only search misses rare literal error codes.
Question 44
A cloud database enables disk encryption but an application team assumes that prevents its overly privileged SQL login from reading confidential rows. What would be a valid post-database-change verification?
Explanation
Correct Answer
Compromised low-privilege identities cannot read unrelated protected data in a controlled test.
Incorrect Answers
Test audit events remain retrievable and immutable for the required retention period. Compromised low-privilege identities cannot read unrelated protected data in a controlled test.
The negative test remains denied and generates a protected record adequate for investigation. Compromised low-privilege identities cannot read unrelated protected data in a controlled test.
The web application runs normal queries while an attempted schema modification is denied. Compromised low-privilege identities cannot read unrelated protected data in a controlled test.
Question 45
A team exposes SQL data through Data API builder but assumes API authentication alone prevents access to every table. Which technical principle explains the correct response?
Explanation
Correct Answer
API exposure needs authorization at both application endpoint and SQL permission layers.
Incorrect Answers
Dynamic Data Masking limits incidental exposure but does not encrypt storage or replace granular authorization. API exposure needs authorization at both application endpoint and SQL permission layers.
Encryption strength and operational availability both depend on disciplined key lifecycle management. API exposure needs authorization at both application endpoint and SQL permission layers.
Encryption mode and query capabilities must be chosen together; not every plaintext operation remains available. API exposure needs authorization at both application endpoint and SQL permission layers.
Question 46
A database project adds a broad GRANT SELECT to PUBLIC because a generated SQL suggestion says it simplifies application connectivity. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Reject the broad grant and model only narrowly required role permissions in reviewed project files. Database project source code must include secure authorization decisions, not just schema shapes.
Incorrect Answers
Configure the supported SDK-style project, dependencies, and build validation in CI. Database project source code must include secure authorization decisions, not just schema shapes. Reject the broad grant and model only narrowly required role permissions in reviewed project files.
Use an approved workload identity and least-privilege deployment role per environment. Database project source code must include secure authorization decisions, not just schema shapes. Reject the broad grant and model only narrowly required role permissions in reviewed project files.
Version reference data in a reviewed idempotent deployment process with migration tests. Database project source code must include secure authorization decisions, not just schema shapes. Reject the broad grant and model only narrowly required role permissions in reviewed project files.
Question 47
A shared SQL table stores tickets for many clients and an application bug omits its WHERE tenant predicate. What is the MOST appropriate initial remediation?
Explanation
Correct Answer
Implement database-enforced row-level security using an appropriate security predicate and trustworthy session identity. Row-level security enforces data visibility in the database independently of application query discipline.
Incorrect Answers
Constrain query permissions and review inference risks rather than treating masking as sufficient protection. Row-level security enforces data visibility in the database independently of application query discipline. Implement database-enforced row-level security using an appropriate security predicate and trustworthy session identity.
Enforce authorized tenant scoping through backend policies and service identity rather than trust the caller's filter. Row-level security enforces data visibility in the database independently of application query discipline. Implement database-enforced row-level security using an appropriate security predicate and trustworthy session identity.
Configure protected audit export and retention consistent with organizational policy. Row-level security enforces data visibility in the database independently of application query discipline. Implement database-enforced row-level security using an appropriate security predicate and trustworthy session identity.
Question 48
A CRM team compares names with common prefix and transcription variations and wants an explainable candidate ranking. Which test result would demonstrate the fix worked?
Explanation
Correct Answer
Validation demonstrates calibrated candidate ranking and flagged low-confidence matches.
Incorrect Answers
A test reconciles cumulative balances with the ledger using explicit ordering. Validation demonstrates calibrated candidate ranking and flagged low-confidence matches.
The parser yields exactly the valid intended tags and records malformed entries for remediation. Validation demonstrates calibrated candidate ranking and flagged low-confidence matches.
The report labels missing prior observations and computes deltas only when a comparison exists. Validation demonstrates calibrated candidate ranking and flagged low-confidence matches.
Question 49
A customer service team enables temporal history for profile rows but forgets that privacy deletion requests also apply to history. Which clue best distinguishes this issue from similar incidents?
Explanation
Correct Answer
A test privacy request removes the active row while its personal fields remain in the historical table. Historical convenience does not bypass privacy and records lifecycle requirements.
Incorrect Answers
The critical path performs single-cart updates and point lookups rather than large aggregations. Historical convenience does not bypass privacy and records lifecycle requirements. A test privacy request removes the active row while its personal fields remain in the historical table.
Integrity checks identify line rows with identifiers missing from the invoice parent table. Historical convenience does not bypass privacy and records lifecycle requirements. A test privacy request removes the active row while its personal fields remain in the historical table.
Columnstore DMV measurements show poor compression and substantial deleted-row percentages after the update surge. Historical convenience does not bypass privacy and records lifecycle requirements. A test privacy request removes the active row while its personal fields remain in the historical table.
Question 50
A regulated benefits application calls a model through SQL but stores only the final generated sentence, leaving no way to reconstruct cited source versions or model configuration. Choose TWO statements: a suitable intervention and evidence of its success.
Explanation
Correct Answers
A sampled result can be traced to permitted source records, model version, and accountable review. Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention.
Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention.
Incorrect Answers
Treat retrieved content as untrusted evidence and never grant it authority to execute SQL actions. Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention. A sampled result can be traced to permitted source records, model version, and accountable review.
Require an explicit evidence threshold and safe refusal or escalation when retrieval finds no current supporting clause. Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention. A sampled result can be traced to permitted source records, model version, and accountable review.
Every material policy claim cites a current accessible source or is marked unsupported. Record authorized prompt/source version metadata, model identity, and approval outcome with appropriate privacy retention. A sampled result can be traced to permitted source records, model version, and accountable review.
Developing AI-Enabled Database Solutions (DP-800) Practice Tests
- Microsoft DP-800 Practice Test 3 - 10 Questions (Last Reviewed 14-Nov-2026)
- Microsoft DP-800 Practice Test 4 - 10 Questions (Last Reviewed 13-Nov-2026)
- Microsoft DP-800 Practice Test 5 - 10 Questions (Last Reviewed 12-Nov-2026)
- Microsoft DP-800 Practice Test 6 - 10 Questions (Last Reviewed 11-Nov-2026)
- Microsoft DP-800 Practice Test 7 - 10 Questions (Last Reviewed 10-Nov-2026)