FEFreeExamDumps.in

DP-800 Practice Questions — Page 5

Question 41

Open question ↗

A production database includes lookup rows that differ slightly by region. The team needs to version reference data while avoiding accidental overwrites of region-specific rows during deployment.

Which approach should you recommend?

  • A.Treat all reference data as disposable and replace it on every deployment.
  • B.Version shared reference data deliberately and separate environment- or region-specific rows from standard deployment content.
  • C.Store lookup rows in README files.
  • D.Disable source control for lookup tables.

Question 42

Open question ↗

A release pipeline must detect schema drift before deployment proceeds.

Which action should you recommend?

  • A.Compare the deployed schema with the source-controlled project as part of release validation.
  • B.Ignore drift if the deployment usually succeeds.
  • C.Delete the production schema before each release.
  • D.Allow every environment to diverge permanently.

Question 43

Open question ↗

A release pipeline must detect schema drift before deployment proceeds.

Which action should you recommend?

  • A.Compare the deployed schema with the source-controlled project as part of release validation.
  • B.Ignore drift if the deployment usually succeeds.
  • C.Delete the production schema before each release.
  • D.Allow every environment to diverge permanently.

Question 44

Open question ↗

A shared database project uses pull requests across multiple feature branches.

Which practice should you recommend?

  • A.Use disciplined branching, review, and merge controls with rollback planning.
  • B.Commit directly to main for every change.
  • C.Delete release branches before testing.
  • D.Avoid source control for schemas.

Question 45

Open question ↗

A team needs an automated strategy to test stored procedures and deployment artifacts before release.

Which approach should you recommend?

  • A.Add unit, integration, and smoke checks to the pipeline.
  • B.Rely on a single developer's memory.
  • C.Skip testing for database changes.
  • D.Test only after production deployment.

Question 46

Open question ↗

Your team stores schema definitions in a SQL Database Project. Every pull request must confirm that the project builds successfully and that deployment scripts are valid before merge.

Which pipeline step should you add?

  • A.Compile the SQL Database Project and fail the build on validation errors.
  • B.Allow direct commits to the release branch without validation.
  • C.Skip pre-deployment checks to reduce build time.
  • D.Generate migration scripts manually on developer laptops only.

Question 47

Open question ↗

A downstream service processes order-change events asynchronously.

Which retry design is most appropriate?

  • A.Use durable messaging and retry patterns for transient failures.
  • B.Require users to rerun the workflow manually every time.
  • C.Store pending events in screenshots.
  • D.Disable retries entirely.

Question 48

Open question ↗

A solution exposes a stored procedure through an API and must keep a stable request and response contract for clients.

Which approach should you recommend?

  • A.Define and version the procedure-backed API contract deliberately.
  • B.Change parameter names at random across releases.
  • C.Expose every internal helper procedure publicly.
  • D.Use server admin credentials in each client.

Question 49

Open question ↗

An operations team needs alerts when SQL-backed APIs exceed normal latency thresholds.

Which action should you recommend?

  • A.Configure Azure Monitor metrics and alerts for the SQL-integrated solution.
  • B.Wait for users to report slowness.
  • C.Disable telemetry to reduce noise.
  • D.Use screenshots as the primary observability mechanism.

Question 50

Open question ↗

An operations team needs alerts when SQL-backed APIs exceed normal latency thresholds.

Which action should you recommend?

  • A.Configure Azure Monitor metrics and alerts for the SQL-integrated solution.
  • B.Wait for users to report slowness.
  • C.Disable telemetry to reduce noise.
  • D.Use screenshots as the primary observability mechanism.