Microsoft DP-800 Questions & Answers

Referential integrity prevents orphan children unless cascade or other actions are deliberately configured. The actual technical constraint is that application-layer validation alone can be bypassed by other writers.

A sequence can allocate numbers independently of one table identity property. The actual technical constraint is that application-layer validation alone can be bypassed by other writers.

Metadata-based partition switching requires strict schema and partition alignment. The actual technical constraint is that application-layer validation alone can be bypassed by other writers.

Monitor source availability and credential rotation. The current task instead requires this action: protect history access and plan retention and schema migration.

Alert before exhaustion and avoid cycling keys with retained history.

Keep statistics and partition maintenance procedures current. The current task instead requires this action: protect history access and plan retention and schema migration.

Nested or recursive trigger behavior can cause cycles and unexpected work.

Reviewing dependency effects and change the schema-bound view deliberately before modifying underlying objects would not correct a developer tries to audit deleted rows using only the inserted pseudo-table. Use the deleted pseudo-table correctly for DELETE and before-image values.

Per-row scalar function calls may create expensive repeated execution on some workloads.

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

The identity creates an approved test object but cannot alter production schemas. However, that result would not establish the required outcome: a test UPDATE appears in protected audit storage with correct identity.

Anonymous calls fail while authorized SQL workloads succeed. However, that result would not establish the required outcome: a test UPDATE appears in protected audit storage with correct identity.

Temporal history captures prior row versions when system versioning is enabled. The actual technical constraint is that memory-optimized OLTP can reduce contention but adds feature and durability constraints.

A default supplies a value on omission, not a guarantee against explicit bad values. The actual technical constraint is that memory-optimized OLTP can reduce contention but adds feature and durability constraints.

Finite ranges exhaust and enabling CYCLE without safety checks may repeat identifiers. The actual technical constraint is that memory-optimized OLTP can reduce contention but adds feature and durability constraints.

Use pre-send secret scanning and developer training. The current task instead requires this action: protect branches with required security code review.

Record feature enablement and organizational restrictions. The current task instead requires this action: protect branches with required security code review.

Scan instruction files during pull-request review. The current task instead requires this action: protect branches with required security code review.

Redact secrets from diagnostics and use structured error codes. The relevant technical condition instead is that use dedicated scoped workload identity with least-privilege resource grants.

A declarative project can validate database object definitions before deployment.

Branch policies are governance controls that prevent unreviewed deployment inputs.

The API executes the report but cannot drop objects or select unrelated tables. However, that result would not establish the required outcome: the legitimate procedure succeeds while unrelated objects remain inaccessible.

Model calls and retrieval calls each succeed only with required scopes. However, that result would not establish the required outcome: the legitimate procedure succeeds while unrelated objects remain inaccessible.

An export returns only rows permitted to its assigned role. However, that result would not establish the required outcome: the legitimate procedure succeeds while unrelated objects remain inaccessible.

Normalizing vector length separates direction from magnitude for suitable similarity metrics. The actual technical constraint is that vector metadata functions describe representation without parsing serialized JSON arrays.

Approximate structures trade memory, speed and recall depending on data and configuration. The actual technical constraint is that vector metadata functions describe representation without parsing serialized JSON arrays.

Distance semantics affect neighbor ordering and recall. The actual technical constraint is that vector metadata functions describe representation without parsing serialized JSON arrays.

Keep config schema and object references versioned together. The current task instead requires this action: block accidental production connection strings in repository review.

Monitor connection failures and restrict ingress. The current task instead requires this action: block accidental production connection strings in repository review.

Keep deployment artifacts and change history. The current task instead requires this action: block accidental production connection strings in repository review.

Randomized encryption does not support general plaintext pattern matching inside the engine.

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

RLS enforces row filtering in the database rather than relying on every query to remember a filter.