Microsoft DP-800 Exam Dumps, Practice Test Questions

100% Latest & Updated Microsoft DP-800 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!

Microsoft DP-800  Premium File
$54.99
$49.99

DP-800 Premium File

  • Premium File: 101 Questions & Answers. Last update: Nov 9, 2026
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

DP-800 Premium File

Microsoft DP-800  Premium File
  • Premium File: 101 Questions & Answers. Last update: Nov 9, 2026
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$54.99
$49.99

Microsoft DP-800 Practice Test 60

Question 590

A report must reuse last month's stable query plan after regression. The team selects: Use Query Store plan forcing cautiously with monitoring. Which implementation action puts this design into practice?

  1. Force a known-good Query Store plan when supported
  2. Configure Query Store capture policy
  3. Use Query Store to compare prior and current execution plans
  4. Create index on leading selective filters and needed includes

Explanation

Correct Answer

A:

Force a known-good Query Store plan when supported. This is the concrete setup for use query store plan forcing cautiously with monitoring, and verify forced plan status and performance under live skew supplies a direct confirmation.

Incorrect Answers

B:

Configure Query Store capture policy. This is relevant when a service has intermittent timeout and unknown query cause. Here, force a known-good Query Store plan when supported.

C:

Use Query Store to compare prior and current execution plans. This is relevant when an API has latency spikes after an index disappears. Here, force a known-good Query Store plan when supported.

D:

Create index on leading selective filters and needed includes. This concerns a query returns a small result but reads millions of rows. Here, force a known-good Query Store plan when supported.

Question 591

A report must reuse last month's stable query plan after regression. After implementing the design, which check most directly validates the expected behavior?

  1. Verify plan seeks date index
  2. Verify forced plan status and performance under live skew
  3. Confirm plan performance differs by parameter distribution
  4. Compare CPU and elapsed time under matched workload

Explanation

Correct Answer

B:

Verify forced plan status and performance under live skew. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that plan forcing conflicts with changed query or schema shape.

Incorrect Answers

A:

Verify plan seeks date index. This is relevant when an index on a date column is ignored when where converts the column. Instead, verify forced plan status and performance under live skew.

C:

Confirm plan performance differs by parameter distribution. This is relevant when a parameterized procedure is fast for one customer and slow for another. Instead, verify forced plan status and performance under live skew.

D:

Compare CPU and elapsed time under matched workload. This concerns a report performs thousands of per-row scalar function calls. Instead, verify forced plan status and performance under live skew.

Question 592

A report must reuse last month's stable query plan after regression. A test instead finds: Forced plan fails to apply after schema change. Which underlying issue best explains this finding?

  1. Query performance history was not captured
  2. Log storage throughput or latency is the limiting factor
  3. Plan changed after schema or index modification
  4. Plan forcing conflicts with changed query or schema shape

Explanation

Correct Answer

D:

Plan forcing conflicts with changed query or schema shape. It accounts for the specific observed failure: forced plan fails to apply after schema change. The intended solution is use query store plan forcing cautiously with monitoring with the required setup.

Incorrect Answers

A:

Query performance history was not captured. This concerns no historical plans exist for the incident window. Instead, plan forcing conflicts with changed query or schema shape.

B:

Log storage throughput or latency is the limiting factor. This concerns transactions wait despite low cpu usage. Instead, plan forcing conflicts with changed query or schema shape.

C:

Plan changed after schema or index modification. This concerns querying time changes abruptly after deployment. Instead, plan forcing conflicts with changed query or schema shape.

Question 593

A database team wants table definitions versioned with application code. Which database design or engineering approach most directly meets this requirement?

  1. Choose target SQL platform and compatibility accurately
  2. Run SQL Database Project drift comparison
  3. Use separate deployment identity with scoped DDL rights
  4. Create a SQL Database Project with source-controlled schema

Explanation

Correct Answer

D:

Create a SQL Database Project with source-controlled schema. The implementation is store tables, views, procedures as project sql files; success can be checked by build dacpac and compare model to target schema. The method addresses the stated data and workload constraint.

Incorrect Answers

A:

Choose target SQL platform and compatibility accurately. This concerns selecting engine-specific targets. Instead, create a SQL Database Project with source-controlled schema.

B:

Run SQL Database Project drift comparison. This is relevant when a team notices production schema does not match approved source. Instead, create a SQL Database Project with source-controlled schema.

C:

Use separate deployment identity with scoped DDL rights. This concerns using least privilege for database deploy. Instead, create a SQL Database Project with source-controlled schema.

Question 594

A database team wants table definitions versioned with application code. The team selects: Create a SQL Database Project with source-controlled schema. Which implementation action puts this design into practice?

  1. Ensure view and proc compile against latest schema
  2. Configure secret scanning and pre-commit detection
  3. Store tables, views, procedures as project SQL files
  4. Define build job, secrets, approvals and deployment job

Explanation

Correct Answer

C:

Store tables, views, procedures as project SQL files. This is the concrete setup for create a sql database project with source-controlled schema, and build dacpac and compare model to target schema supplies a direct confirmation.

Incorrect Answers

A:

Ensure view and proc compile against latest schema. This concerns a team updates views and stored procedures in one change. Instead, store tables, views, procedures as project SQL files.

B:

Configure secret scanning and pre-commit detection. This concerns avoiding secrets in prs. Instead, store tables, views, procedures as project SQL files.

D:

Define build job, secrets, approvals and deployment job. This concerns a github workflow deploys SQL to azure after a merge. Instead, store tables, views, procedures as project SQL files.

Question 595

A database team wants table definitions versioned with application code. After implementing the design, which check most directly validates the expected behavior?

  1. Build dacpac and compare model to target schema
  2. Verify target versions after each stage
  3. Check job logs do not show credential values
  4. Check dacpac output and build diagnostics

Explanation

Correct Answer

A:

Build dacpac and compare model to target schema. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that schema was maintained only by manual portal edits.

Incorrect Answers

B:

Verify target versions after each stage. This concerns staged promotion of SQL schema changes. Instead, build dacpac and compare model to target schema.

C:

Check job logs do not show credential values. This concerns SQL authentication secret. Instead, build dacpac and compare model to target schema.

D:

Check dacpac output and build diagnostics. This concerns predictable schema model compilation in CI. Instead, build dacpac and compare model to target schema.

Question 596

A database team wants table definitions versioned with application code. A test instead finds: Production objects are not reproducible from source. Which underlying issue best explains this finding?

  1. Schema drift detection is disabled
  2. Schema was maintained only by manual portal edits
  3. Secret checks are missing or bypassed
  4. Tests were not isolated from production database

Explanation

Correct Answer

B:

Schema was maintained only by manual portal edits. It accounts for the specific observed failure: production objects are not reproducible from source. The intended solution is create a sql database project with source-controlled schema with the required setup.

Incorrect Answers

A:

Schema drift detection is disabled. This concerns manual production hotfix goes undetected. Here, schema was maintained only by manual portal edits.

C:

Secret checks are missing or bypassed. This concerns token appears in checked-in config. Here, schema was maintained only by manual portal edits.

D:

Tests were not isolated from production database. This concerns unit tests mutate live business rows. Here, schema was maintained only by manual portal edits.

Question 597

A project build fails because referenced object is in another database. Which database design or engineering approach most directly meets this requirement?

  1. Run SQL Database Project drift comparison
  2. Add a database reference to the SQL Database Project
  3. Track reference data scripts in source control
  4. Choose target SQL platform and compatibility accurately

Explanation

Correct Answer

B:

Add a database reference to the SQL Database Project. The implementation is configure reference dacpac or project with sqlcmd variable; success can be checked by build and resolve external reference warnings. The method addresses the stated data and workload constraint.

Incorrect Answers

A:

Run SQL Database Project drift comparison. This is relevant when a team notices production schema does not match approved source. Instead, add a database reference to the SQL Database Project.

C:

Track reference data scripts in source control. This concerns a SQL project includes static region codes that change rarely. Instead, add a database reference to the SQL Database Project.

D:

Choose target SQL platform and compatibility accurately. This concerns selecting engine-specific targets. Instead, add a database reference to the SQL Database Project.

Question 598

A project build fails because referenced object is in another database. The team selects: Add a database reference to the SQL Database Project. Which implementation action puts this design into practice?

  1. Define Microsoft.Build.Sql SDK project and build target
  2. Configure secret scanning and pre-commit detection
  3. Configure reference dacpac or project with SQLCMD variable
  4. Fail workflow on project build or dacpac validation error

Explanation

Correct Answer

C:

Configure reference dacpac or project with SQLCMD variable. This is the concrete setup for add a database reference to the sql database project, and build and resolve external reference warnings supplies a direct confirmation.

Incorrect Answers

A:

Define Microsoft.Build.Sql SDK project and build target. This concerns predictable schema model compilation in CI. Instead, configure reference dacpac or project with SQLCMD variable.

B:

Configure secret scanning and pre-commit detection. This concerns avoiding secrets in prs. Instead, configure reference dacpac or project with SQLCMD variable.

D:

Fail workflow on project build or dacpac validation error. This concerns stopping deployment on SQL model validation errors. Instead, configure reference dacpac or project with SQLCMD variable.

Question 599

A project build fails because referenced object is in another database. After implementing the design, which check most directly validates the expected behavior?

  1. Build against chosen SQL Server/Azure SQL target
  2. Build and resolve external reference warnings
  3. Compare deployed dacpac hash to approved build
  4. Run failure simulation in test and measure recovery

Explanation

Correct Answer

B:

Build and resolve external reference warnings. This verifies the requirement in the case rather than merely confirming that a job ran; an opposing result can reveal that external database reference is missing.

Incorrect Answers

A:

Build against chosen SQL Server/Azure SQL target. This concerns selecting engine-specific targets. Instead, build and resolve external reference warnings.

C:

Compare deployed dacpac hash to approved build. This concerns immutable artifact traceability. Instead, build and resolve external reference warnings.

D:

Run failure simulation in test and measure recovery. This concerns an approved rollback strategy. Instead, build and resolve external reference warnings.

Question 600

A project build fails because referenced object is in another database. A test instead finds: Object names are unresolved at build time. Which underlying issue best explains this finding?

  1. Reference-data script was destructive rather than reconciliatory
  2. Project target platform mismatches deployed engine
  3. External database reference is missing
  4. Dependent modules were not validated against model

Explanation

Correct Answer

C:

External database reference is missing. It accounts for the specific observed failure: object names are unresolved at build time. The intended solution is add a database reference to the sql database project with the required setup.

Incorrect Answers

A:

Reference-data script was destructive rather than reconciliatory. This concerns deploying overwrites custom production values. Here, external database reference is missing.

B:

Project target platform mismatches deployed engine. This concerns feature script compiles locally but fails in azure. Here, external database reference is missing.

D:

Dependent modules were not validated against model. This concerns procedure references an obsolete column. Here, external database reference is missing.

Developing AI-Enabled Database Solutions (DP-800) Practice Tests

UP

SPECIAL OFFER: GET 10% OFF

This is ONE TIME OFFER

ExamSnap Discount Offer
Enter Your Email Address to Receive Your 10% Off Discount Code

A confirmation link will be sent to this email address to verify your login. *We value your privacy. We will not rent or sell your email address.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.