Microsoft DP-800 Questions & Answers

Orphan inserts fail and approved delete scenarios behave as specified. However, that result would not establish the required outcome: direct SQL inserts with negative prices fail without affecting valid rows.

Reconciled payment totals match control calculations to the cent. However, that result would not establish the required outcome: direct SQL inserts with negative prices fail without affecting valid rows.

A controlled report benchmark shows lower elapsed time and logical IO. However, that result would not establish the required outcome: direct SQL inserts with negative prices fail without affecting valid rows.

External tables abstract remote data but do not automatically remove network or predicate-pushdown costs. The actual technical constraint is that temporal history captures prior row versions when system versioning is enabled.

Misaligned indexes can block efficient partition maintenance. The actual technical constraint is that temporal history captures prior row versions when system versioning is enabled.

Partitioning is most helpful when queries constrain the partition key. The actual technical constraint is that temporal history captures prior row versions when system versioning is enabled.

Minimize trigger side effects and audit dependent trigger paths. The current task instead requires this action: protect audit table writes and limit trigger permissions.

Implement idempotent retry and bounded transaction duration. The current task instead requires this action: protect audit table writes and limit trigger permissions.

Keep procedure signatures under source control. The current task instead requires this action: protect audit table writes and limit trigger permissions.

Tamper-resistant off-host retention is stronger evidence than only local logs.

Dynamic SQL may execute under a permission context different from static ownership chains.

Server-side encryption can decrypt inside SQL with authorized key access, unlike client-controlled Always Encrypted.

A point-in-time query returns the former invoice values after an update. However, that result would not establish the required outcome: a benchmark improves queue throughput while meeting durability requirements.

That check would verify a different scenario: A developer partitions an orders table by CreatedAt but filters primarily by CustomerId and observes no gain. It is evidence for benchmark partition elimination against actual predicates instead of assuming partitioning is an index replacement, not the stated requirement. For this case, it does not directly prove the requested outcome; the distinguishing issue is memory-optimized OLTP can reduce contention but adds feature and durability constraints. The specifically relevant observable acceptance test is: A benchmark improves queue throughput while meeting durability requirements.

High-ID inserts and all dependent joins work in migration tests. However, that result would not establish the required outcome: a benchmark improves queue throughput while meeting durability requirements.

AI chat providers and extensions may retain shared content outside the database boundary. The actual technical constraint is that generated code can violate least privilege even if it appears syntactically correct.

A malicious or compromised MCP server may exfiltrate data or supply unsafe tool behavior. The actual technical constraint is that generated code can violate least privilege even if it appears syntactically correct.

Prompt instructions influence suggestions but are not mandatory security policies. The actual technical constraint is that generated code can violate least privilege even if it appears syntactically correct.

Enforce secret masking and log retention policy. The current task instead requires this action: audit assignments and revoke stale principals.

Avoid overwriting locally maintained fields unexpectedly. The current task instead requires this action: audit assignments and revoke stale principals.

Review seed-data changes like schema changes. The current task instead requires this action: audit assignments and revoke stale principals.

Least-privilege object permissions reduce exposed DDL and direct data paths.

High-volume blanket logging can impact throughput and reveal sensitive inputs.

Passwordless CI reduces secret leakage and rotation burden when configured with scoped trust.

Normalized test vectors have unit norm within floating tolerance. However, that result would not establish the required outcome: a known test vector reports the correct dimension property.

The result returns ten or fewer allowed chunks ordered by similarity. However, that result would not establish the required outcome: a known test vector reports the correct dimension property.

The corrected query executes and returns expected similar records. However, that result would not establish the required outcome: a known test vector reports the correct dimension property.

Syntactic JSON validity alone does not prove a mapped SQL object exists. The actual technical constraint is that configuration must resolve the correct database per environment without leaking secrets.

DAB entity projection and permissions determine the API data surface. The actual technical constraint is that configuration must resolve the correct database per environment without leaking secrets.

REST endpoint mapping supplies predictable URLs and HTTP operations. The actual technical constraint is that configuration must resolve the correct database per environment without leaking secrets.

Document leakage tradeoffs before enabling secure enclaves. The current task instead requires this action: rehearse key recovery and avoid distributing keys in scripts.

Tracking principal creation across environments would not correct following remediation, what safeguard BEST prevents a repeat of this specific failure. Rehearse key recovery and avoid distributing keys in scripts.

Expire elevation and log the migration transaction. The current task instead requires this action: rehearse key recovery and avoid distributing keys in scripts.