Microsoft DP-800 Questions & Answers

Monitor connection failures and restrict ingress. The current task instead requires this action: use telemetry and abuse alerting across API and SQL.

Block accidental production connection strings in repository review. The current task instead requires this action: use telemetry and abuse alerting across API and SQL.

Use consistent ordering and monitor costly filters. The current task instead requires this action: use telemetry and abuse alerting across API and SQL.

Asynchronous change-based updates decouple embedding cost from OLTP commit latency.

Splitting within essential context can reverse meaning and reduce retrieval accuracy.

A larger model is not automatically the best fit for cost, speed or multilingual accuracy.

A seeded unsafe suggestion is blocked by independent controls. However, that result would not establish the required outcome: sQL file suggestions follow database style while other files retain appropriate conventions.

Test prompts contain representative synthetic values, not real identifiers. However, that result would not establish the required outcome: sQL file suggestions follow database style while other files retain appropriate conventions.

An audit shows requests use the intended approved endpoint. However, that result would not establish the required outcome: sQL file suggestions follow database style while other files retain appropriate conventions.

Dynamic SQL may execute under a permission context different from static ownership chains. The actual technical constraint is that least-privilege object permissions reduce exposed DDL and direct data paths.

Dynamic masking is evaluated at query output rather than permanently altering storage. The actual technical constraint is that least-privilege object permissions reduce exposed DDL and direct data paths.

RLS enforces row filtering in the database rather than relying on every query to remember a filter. The actual technical constraint is that least-privilege object permissions reduce exposed DDL and direct data paths.

Use supplemental identifiers and human approval for merges. The current task instead requires this action: review false merges by language and short-name length.

Record retry policy and distinguish transient from permanent errors. The current task instead requires this action: review false merges by language and short-name length.

Specify ordering when supported and required by consumers. The current task instead requires this action: review false merges by language and short-name length.

Different SQL engine flavors do not guarantee identical DDL feature support.

Including an appropriate staged data migration and backfill before constraint enforcement would not correct a team updates an SDK-style SQL project but CI cannot resolve its package dependencies. Pin supported SDK/project package versions and restore dependencies before build.

Manual changes create drift between intended declarative source and deployed objects.

A sample network returns the known minimal path when explicitly requested. However, that result would not establish the required outcome: a test discovers the expected connected device chain.

Valid test codes match and invalid or truncated codes do not. However, that result would not establish the required outcome: a test discovers the expected connected device chain.

Mixed-case sample descriptions preserve nonmatching text. However, that result would not establish the required outcome: a test discovers the expected connected device chain.

Exact search compares the candidate vectors directly without ANN recall tradeoffs. The actual technical constraint is that approximate indexes trade exact completeness for faster retrieval on large corpora.

Vector operations require dimension compatibility. The actual technical constraint is that approximate indexes trade exact completeness for faster retrieval on large corpora.

Normalizing vector length separates direction from magnitude for suitable similarity metrics. The actual technical constraint is that approximate indexes trade exact completeness for faster retrieval on large corpora.

Bound query depth and verify field-level permissions. The current task instead requires this action: version the API contract and publish schema changes responsibly.

Use telemetry and abuse alerting across API and SQL. The current task instead requires this action: version the API contract and publish schema changes responsibly.

Review view changes and role grants together. The current task instead requires this action: version the API contract and publish schema changes responsibly.

Using idempotent keyed upserts or appropriate repeat-safe seed operations would not correct an engineer commits environment-specific secrets inside a reference-data CSV. Remove sensitive values and parameterize environment configuration outside version control.

Using dedicated scoped workload identity with least-privilege resource grants would not correct an engineer commits environment-specific secrets inside a reference-data CSV. Remove sensitive values and parameterize environment configuration outside version control.

Changing project source alone does not apply DDL to the deployed database.

The approved insert path updates expected base rows while report totals remain correct. However, that result would not establish the required outcome: a migration test catches incompatible column modification before production.

The audit records exact old values in multirow deletion tests. However, that result would not establish the required outcome: a migration test catches incompatible column modification before production.

Tests resolve the intended procedure and handle null/invalid inputs. However, that result would not establish the required outcome: a migration test catches incompatible column modification before production.