Microsoft DP-800 Questions & Answers

Optimistic concurrency only works if conflicts are detected, not silently overwritten.

Lock waits are not resolved merely by allocating faster compute.

Instance metrics alone do not identify which cached statements consume resources.

Authorized clients read/write after rotation and revoked keys no longer work. However, that result would not establish the required outcome: supported equality or enclave test cases behave as designed without broad plaintext exposure.

A spoofed request cannot change access to another tenant's rows. However, that result would not establish the required outcome: supported equality or enclave test cases behave as designed without broad plaintext exposure.

An export returns only rows permitted to its assigned role. However, that result would not establish the required outcome: supported equality or enclave test cases behave as designed without broad plaintext exposure.

Embedding static credentials in SQL code can expose model access and billing. The actual technical constraint is that identity permission at one Azure service does not imply access to adjacent resources.

Untrusted headers cannot be treated as authenticated authorization claims. The actual technical constraint is that identity permission at one Azure service does not imply access to adjacent resources.

Passwordless CI reduces secret leakage and rotation burden when configured with scoped trust. The actual technical constraint is that identity permission at one Azure service does not imply access to adjacent resources.

Set sensible MAXRECURSION and detect cycles. The current task instead requires this action: implement graph integrity checks on writes.

Limit traversal depth and track source/target referential rules. The current task instead requires this action: implement graph integrity checks on writes.

Keep review logs and a reversible merge mechanism. The current task instead requires this action: implement graph integrity checks on writes.

Measuring workload resource patterns and choose an appropriate compute/service tier or scaling policy would not correct a dev wants to enable all query optimization flags globally because one report is slow. Use targeted measured configuration changes and a rollback plan rather than blindly enabling trace flags.

A poor cardinality estimate can induce unsuitable joins and memory grants.

Platform-native query insight tools expose historical workload statistics for managed instances.

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

Cross-tenant queries expose no IDs or snippets from denied records. However, that result would not establish the required outcome: normalized test vectors have unit norm within floating tolerance.

Results contain one entry per source passage in a stable ranking. However, that result would not establish the required outcome: normalized test vectors have unit norm within floating tolerance.

Window ranking order is defined by its OVER clause, not the outer result sort. The actual technical constraint is that LAG references a preceding ordered row without self-joining every record.

JSON_VALUE extracts a scalar path, while OPENJSON can shred collections. The actual technical constraint is that LAG references a preceding ordered row without self-joining every record.

Graph relationships support path queries but still need guarded edge permissions. The actual technical constraint is that LAG references a preceding ordered row without self-joining every record.

Combine DAB permissions with SQL RLS where applicable. The current task instead requires this action: rotate signing keys and validate audiences and issuers.

Do not use masking as the sole defense for highly sensitive fields.

Reviewing grants after schema migrations addresses a different database behavior; the relevant distinction is that rotate signing keys and validate audiences and issuers.

FREETEXT expands linguistic meaning and is not equivalent to exact phrase matching.

Normalizing vector length separates direction from magnitude for suitable similarity metrics.

Vector search ranks stored embeddings by distance but must honor source permissions.

A test UPDATE appears in protected audit storage with correct identity. However, that result would not establish the required outcome: a simulated service administrator cannot erase the retained central record.

Supported equality or enclave test cases behave as designed without broad plaintext exposure. However, that result would not establish the required outcome: a simulated service administrator cannot erase the retained central record.

Authorized clients read/write after rotation and revoked keys no longer work. However, that result would not establish the required outcome: a simulated service administrator cannot erase the retained central record.

Modeling size increases cost and latency without guaranteeing proportional quality gains concerns a different mechanism; the relevant technical point is that unconstrained prose is fragile to parse and can omit required keys.

Deterministic chunk identity reduces unnecessary inference and preserves provenance. The actual technical constraint is that unconstrained prose is fragile to parse and can omit required keys.

Frequent numeric fields add update cost and can weaken semantic relevance. The actual technical constraint is that unconstrained prose is fragile to parse and can omit required keys.