Microsoft DP-800 Questions & Answers

Alert on per-document cost and failed queue age. The current task instead requires this action: validate dimension and model version before inserting.

Version endpoint changes and restrict model creation rights. The current task instead requires this action: validate dimension and model version before inserting.

Protect queue durability and retry idempotently. The current task instead requires this action: validate dimension and model version before inserting.

The two interfaces expose related data but have different query syntax and operation models.

API endpoint changes can break consumers even if the underlying database remains healthy.

Configuration must resolve the correct database per environment without leaking secrets.

Different representative parameter values meet latency targets after tuning. However, that result would not establish the required outcome: the slow query and time window are identified from supported telemetry.

Simultaneous sale tests yield at most the available stock quantity. However, that result would not establish the required outcome: the slow query and time window are identified from supported telemetry.

A stale client receives a conflict and cannot overwrite the newer row. However, that result would not establish the required outcome: the slow query and time window are identified from supported telemetry.

Authorized query transformations and inference can expose sensitive values despite masking. The actual technical constraint is that high-privilege identities can typically view underlying unmasked values.

An open endpoint may expose inputs, outputs or costly compute to unauthorized callers. The actual technical constraint is that high-privilege identities can typically view underlying unmasked values.

API generation does not automatically imply that exposed data is appropriately authorized. The actual technical constraint is that high-privilege identities can typically view underlying unmasked values.

Monitor truncation and fall back to SQL aggregates for precise counts.

Keep business arithmetic outside uncontrolled model generation. The current task instead requires this action: cap retries and alert on repeated model service failures.

Audit access metadata and citation validity. The current task instead requires this action: cap retries and alert on repeated model service failures.

Including an appropriate staged data migration and backfill before constraint enforcement would not correct a new index exists in a branch but production queries still use the prior plan. Build/publish the reviewed SQL Database Project to the intended target with verification.

Branch policies are governance controls that prevent unreviewed deployment inputs.

Configuring CODEOWNERS and required reviews for the finance database paths would not correct a new index exists in a branch but production queries still use the prior plan. Build/publish the reviewed SQL Database Project to the intended target with verification.

An audit shows requests use the intended approved endpoint. However, that result would not establish the required outcome: a test tool call reads metadata while unauthorized writes are denied.

Test prompts contain representative synthetic values, not real identifiers. However, that result would not establish the required outcome: a test tool call reads metadata while unauthorized writes are denied.

A test session follows enterprise policy without exposing restricted repo content. However, that result would not establish the required outcome: a test tool call reads metadata while unauthorized writes are denied.

MCP access to a lakehouse is constrained by Fabric and identity permissions. The actual technical constraint is that a malicious or compromised MCP server may exfiltrate data or supply unsafe tool behavior.

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

Copilot in Fabric availability can depend on region, capacity and tenant policies. The actual technical constraint is that a malicious or compromised MCP server may exfiltrate data or supply unsafe tool behavior.

Set sensible MAXRECURSION and detect cycles. The current task instead requires this action: document whether reusable results require temp tables or views.

Include a stable tie-breaker and monitor late events. The current task instead requires this action: document whether reusable results require temp tables or views.

Specifying missing predecessor behavior explicitly addresses a different database behavior; the relevant distinction is that document whether reusable results require temp tables or views.

Replacing excessive privileges with minimum SELECT and no UNMASK entitlement would not correct a security team treats DDM as protection against users with broad SELECT and inference query rights. Combine masking with column permissions and other controls based on actual threat model.

Agents can turn natural-language requests into real database mutations if tools permit.

An open endpoint may expose inputs, outputs or costly compute to unauthorized callers.

Captured outbound JSON excludes restricted notes and includes needed metrics. However, that result would not establish the required outcome: an API test reads amounts with correct decimal interpretation.

A fixture response yields the expected text without transport headers. However, that result would not establish the required outcome: an API test reads amounts with correct decimal interpretation.

The computed amount matches audited ledger SQL exactly. However, that result would not establish the required outcome: an API test reads amounts with correct decimal interpretation.