Microsoft DP-800 Practice Test 26
Question 250
At BrightPath Studios, a developer pastes production connection strings into Copilot chat. The observed constraint is: Unreviewed prompts could expose credentials. What operational condition would provide the earliest useful regression warning?
- Monitor cross-workspace access attempts
- Monitor prompt leakage warnings and policy violations
- Monitor suspicious tool requests and boundary violations
- Monitor migration impact and drift
Explanation
Correct Answer
B:
Unreviewed prompts could expose credentials. Monitor prompt leakage warnings and policy violations. Prompts and repository instructions can accidentally expose credentials. Remove secrets from context and rely on approved managed secret stores.
Incorrect Answers
A:
“Monitor cross-workspace access attempts” concerns Broad access would expose unrelated workspace files; the reported problem instead is Unreviewed prompts could expose credentials. Monitor prompt leakage warnings and policy violations. Prompts and repository instructions can accidentally expose credentials. Remove secrets from context and rely on approved managed secret stores.
C:
“Monitor suspicious tool requests and boundary violations” concerns AI assistant may treat database metadata as instructions; the reported problem instead is Unreviewed prompts could expose credentials. Monitor prompt leakage warnings and policy violations. Prompts and repository instructions can accidentally expose credentials. Remove secrets from context and rely on approved managed secret stores.
D:
“Monitor migration impact and drift” concerns DDL change could destroy legacy data or break dependencies; the reported problem instead is Unreviewed prompts could expose credentials. Monitor prompt leakage warnings and policy violations. Prompts and repository instructions can accidentally expose credentials. Remove secrets from context and rely on approved managed secret stores.
Question 251
A database engineer at Lakeview Services is investigating this case: An AI tool proposes a query that joins billing tables. The relevant finding is: Generated SQL may produce accidental many-to-many amplification. What initial check best narrows the technical cause without altering business data?
- Inspect provenance of retrieved comments and tool-call logs
- Inspect generated DDL and dependent objects before merging
- Review approved model inventory and repository code disclosure policy
- Review join keys, row estimates and generated SQL before execution
Explanation
Correct Answer
D:
Generated SQL may produce accidental many-to-many amplification. Review join keys, row estimates and generated SQL before execution. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
Incorrect Answers
A:
“Inspect provenance of retrieved comments and tool-call logs” concerns AI assistant may treat database metadata as instructions; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Review join keys, row estimates and generated SQL before execution. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
B:
“Inspect generated DDL and dependent objects before merging” concerns DDL change could destroy legacy data or break dependencies; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Review join keys, row estimates and generated SQL before execution. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
C:
“Review approved model inventory and repository code disclosure policy” concerns Tool options vary in token limits, privacy policy and quality; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Review join keys, row estimates and generated SQL before execution. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
Question 252
Crownridge Travel is responsible for an Azure SQL or Microsoft SQL workload. An AI tool proposes a query that joins billing tables. Operational evidence: Generated SQL may produce accidental many-to-many amplification. Which proposed change is the most suitable response to the observed constraint?
- Require human code review and test-driven validation of AI output
- Treat schema content as untrusted data and restrict agent tool permissions
- Require reviewed reversible migration plus backup and approvals
- Configure an approved metadata-only MCP tool with least privilege
Explanation
Correct Answer
A:
Generated SQL may produce accidental many-to-many amplification. Require human code review and test-driven validation of AI output. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
Incorrect Answers
B:
“Treat schema content as untrusted data and restrict agent tool permissions” concerns AI assistant may treat database metadata as instructions; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Require human code review and test-driven validation of AI output. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
C:
“Require reviewed reversible migration plus backup and approvals” concerns DDL change could destroy legacy data or break dependencies; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Require human code review and test-driven validation of AI output. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
D:
“Configure an approved metadata-only MCP tool with least privilege” concerns Broad access would expose unrelated workspace files; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Require human code review and test-driven validation of AI output. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
Question 253
At Oakridge Advisors, an AI tool proposes a query that joins billing tables. The observed constraint is: Generated SQL may produce accidental many-to-many amplification. What isolated pilot would provide the strongest evidence before rollout?
- Compare candidate-generated SQL on a fake project with tests
- Inject benign adversarial text into a test comment
- Run generated query against bounded synthetic relational fixtures
- Run a synthetic prompt containing a fake credential under policy review
Explanation
Correct Answer
C:
Generated SQL may produce accidental many-to-many amplification. Run generated query against bounded synthetic relational fixtures. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
Incorrect Answers
A:
“Compare candidate-generated SQL on a fake project with tests” concerns Tool options vary in token limits, privacy policy and quality; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Run generated query against bounded synthetic relational fixtures. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
B:
“Inject benign adversarial text into a test comment” concerns AI assistant may treat database metadata as instructions; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Run generated query against bounded synthetic relational fixtures. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
D:
“Run a synthetic prompt containing a fake credential under policy review” concerns Unreviewed prompts could expose credentials; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Run generated query against bounded synthetic relational fixtures. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
Question 254
A database engineer at Horizon Communications is investigating this case: An AI tool proposes a query that joins billing tables. The relevant finding is: Generated SQL may produce accidental many-to-many amplification. Which acceptance result most directly demonstrates the requirement has been satisfied?
- Only intended lakehouse metadata is returned
- Assistant does not execute unauthorized data exports
- Row counts and billing totals match reference results
- Schema change preserves required data and rollback succeeds
Explanation
Correct Answer
C:
Generated SQL may produce accidental many-to-many amplification. Row counts and billing totals match reference results. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
Incorrect Answers
A:
“Only intended lakehouse metadata is returned” concerns Broad access would expose unrelated workspace files; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Row counts and billing totals match reference results. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
B:
“Assistant does not execute unauthorized data exports” concerns AI assistant may treat database metadata as instructions; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Row counts and billing totals match reference results. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
D:
“Schema change preserves required data and rollback succeeds” concerns DDL change could destroy legacy data or break dependencies; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Row counts and billing totals match reference results. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
Question 255
Brookfield Labs is responsible for an Azure SQL or Microsoft SQL workload. An AI tool proposes a query that joins billing tables. Operational evidence: Generated SQL may produce accidental many-to-many amplification. What operational condition would provide the earliest useful regression warning?
- Monitor suspicious tool requests and boundary violations
- Monitor migration impact and drift
- Monitor audit events and permission drift
- Monitor anomalous query plans and regressions
Explanation
Correct Answer
D:
Generated SQL may produce accidental many-to-many amplification. Monitor anomalous query plans and regressions. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
Incorrect Answers
A:
“Monitor suspicious tool requests and boundary violations” concerns AI assistant may treat database metadata as instructions; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Monitor anomalous query plans and regressions. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
B:
“Monitor migration impact and drift” concerns DDL change could destroy legacy data or break dependencies; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Monitor anomalous query plans and regressions. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
C:
“Monitor audit events and permission drift” concerns Prompt context must not broaden Fabric workspace access; the reported problem instead is Generated SQL may produce accidental many-to-many amplification. Monitor anomalous query plans and regressions. A generated join can multiply rows when keys are not unique on both sides. Review relationship cardinality and actual row counts before running or publishing it.
Question 256
At Cascade Manufacturing, a team wants code suggestions that follow a common schema naming convention. The observed constraint is: Assistant creates inconsistent column and object names. What initial check best narrows the technical cause without altering business data?
- Inspect repository guidance and Copilot instruction file scope
- Review approved model inventory and repository code disclosure policy
- Inspect workspace role and Copilot feature availability
- Inspect provenance of retrieved comments and tool-call logs
Explanation
Correct Answer
A:
Assistant creates inconsistent column and object names. Inspect repository guidance and Copilot instruction file scope. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
Incorrect Answers
B:
“Review approved model inventory and repository code disclosure policy” concerns Tool options vary in token limits, privacy policy and quality; the reported problem instead is Assistant creates inconsistent column and object names. Inspect repository guidance and Copilot instruction file scope. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
C:
“Inspect workspace role and Copilot feature availability” concerns Prompt context must not broaden Fabric workspace access; the reported problem instead is Assistant creates inconsistent column and object names. Inspect repository guidance and Copilot instruction file scope. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
D:
“Inspect provenance of retrieved comments and tool-call logs” concerns AI assistant may treat database metadata as instructions; the reported problem instead is Assistant creates inconsistent column and object names. Inspect repository guidance and Copilot instruction file scope. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
Question 257
A database engineer at Clearwater Utilities is investigating this case: A team wants code suggestions that follow a common schema naming convention. The relevant finding is: Assistant creates inconsistent column and object names. Which proposed change is the most suitable response to the observed constraint?
- Require reviewed reversible migration plus backup and approvals
- Treat schema content as untrusted data and restrict agent tool permissions
- Add reviewed project instructions that describe conventions without secrets
- Remove secrets and use sanctioned secret stores and prompt boundaries
Explanation
Correct Answer
C:
Assistant creates inconsistent column and object names. Add reviewed project instructions that describe conventions without secrets. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
Incorrect Answers
A:
“Require reviewed reversible migration plus backup and approvals” concerns DDL change could destroy legacy data or break dependencies; the reported problem instead is Assistant creates inconsistent column and object names. Add reviewed project instructions that describe conventions without secrets. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
B:
“Treat schema content as untrusted data and restrict agent tool permissions” concerns AI assistant may treat database metadata as instructions; the reported problem instead is Assistant creates inconsistent column and object names. Add reviewed project instructions that describe conventions without secrets. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
D:
“Remove secrets and use sanctioned secret stores and prompt boundaries” concerns Unreviewed prompts could expose credentials; the reported problem instead is Assistant creates inconsistent column and object names. Add reviewed project instructions that describe conventions without secrets. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
Question 258
Cedarbridge Health is responsible for an Azure SQL or Microsoft SQL workload. A team wants code suggestions that follow a common schema naming convention. Operational evidence: Assistant creates inconsistent column and object names. What isolated pilot would provide the strongest evidence before rollout?
- Request sample code from tool against a disposable repository branch
- Execute proposed migration against a disposable database snapshot
- Test with read-only sample data under allowed and denied roles
- Request schema list using an isolated low-privileged identity
Explanation
Correct Answer
A:
Assistant creates inconsistent column and object names. Request sample code from tool against a disposable repository branch. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
Incorrect Answers
B:
“Execute proposed migration against a disposable database snapshot” concerns DDL change could destroy legacy data or break dependencies; the reported problem instead is Assistant creates inconsistent column and object names. Request sample code from tool against a disposable repository branch. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
C:
“Test with read-only sample data under allowed and denied roles” concerns Prompt context must not broaden Fabric workspace access; the reported problem instead is Assistant creates inconsistent column and object names. Request sample code from tool against a disposable repository branch. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
D:
“Request schema list using an isolated low-privileged identity” concerns Broad access would expose unrelated workspace files; the reported problem instead is Assistant creates inconsistent column and object names. Request sample code from tool against a disposable repository branch. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
Question 259
At Ashwood Solutions, a team wants code suggestions that follow a common schema naming convention. The observed constraint is: Assistant creates inconsistent column and object names. Which acceptance result most directly demonstrates the requirement has been satisfied?
- Suggestions follow documented naming rules and pass lint/tests
- Chosen model yields auditable output without exposing sensitive schema
- Assistant does not execute unauthorized data exports
- Approved schema discovery works and unauthorized functions fail
Explanation
Correct Answer
A:
Assistant creates inconsistent column and object names. Suggestions follow documented naming rules and pass lint/tests. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
Incorrect Answers
B:
“Chosen model yields auditable output without exposing sensitive schema” concerns Tool options vary in token limits, privacy policy and quality; the reported problem instead is Assistant creates inconsistent column and object names. Suggestions follow documented naming rules and pass lint/tests. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
C:
“Assistant does not execute unauthorized data exports” concerns AI assistant may treat database metadata as instructions; the reported problem instead is Assistant creates inconsistent column and object names. Suggestions follow documented naming rules and pass lint/tests. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
D:
“Approved schema discovery works and unauthorized functions fail” concerns Client config points to an outdated URL and unsupported auth; the reported problem instead is Assistant creates inconsistent column and object names. Suggestions follow documented naming rules and pass lint/tests. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
Question 260
A database engineer at Seabrook University is investigating this case: A team wants code suggestions that follow a common schema naming convention. The relevant finding is: Assistant creates inconsistent column and object names. What operational condition would provide the earliest useful regression warning?
- Monitor instruction drift and ignored conventions
- Monitor migration impact and drift
- Monitor connection errors and token expiry
- Monitor audit events and permission drift
Explanation
Correct Answer
A:
Assistant creates inconsistent column and object names. Monitor instruction drift and ignored conventions. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
Incorrect Answers
B:
“Monitor migration impact and drift” concerns DDL change could destroy legacy data or break dependencies; the reported problem instead is Assistant creates inconsistent column and object names. Monitor instruction drift and ignored conventions. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
C:
“Monitor connection errors and token expiry” concerns Client config points to an outdated URL and unsupported auth; the reported problem instead is Assistant creates inconsistent column and object names. Monitor instruction drift and ignored conventions. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.
D:
“Monitor audit events and permission drift” concerns Prompt context must not broaden Fabric workspace access; the reported problem instead is Assistant creates inconsistent column and object names. Monitor instruction drift and ignored conventions. Repository-specific guidance can constrain naming conventions and schemas for generated SQL, but the instructions must be version-controlled and scoped to the project.