DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ65

VerifiedSecure, optimize, and deploy database solutions

You have a database containing production data. Its schema is stored in a Git repository as an SDK-style SQL database project and includes the following reference data.

Question Image

A deployment pipeline may be automatically rerun after a transient failure.

You need to deploy the reference data as part of the same CI/CD process. Rerunning the pipeline must yield the same result and must not create duplicate rows.

What should you do?

Explanation

A post-deployment script runs as part of every SQL database-project deployment. Making its reference-data changes idempotent with IF NOT EXISTS inserts or correctly keyed MERGE logic ensures a rerun preserves the intended data state without inserting duplicate rows.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!