This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
A database administrator applied a hotfix directly to production by adding a missing index. The SQL Database Project doesn't have this index. What is this situation called, and which tool detects it?
Schema drift, detected by schema comparison
A build error, detected by dotnet build
A merge conflict, detected by Git
A deployment failure, detected by SqlPackage Publish
Which GitHub Actions action deploys a .dacpac file to Azure SQL Database and can automatically configure firewall rules for the runner?
azure/sql-action
azure/webapps-deploy
actions/upload-artifact
azure/login
A developer writes a SQL Server unit test for a stored procedure that should raise an error when a required parameter is NULL. Which attribute marks the test as expecting a SQL exception?
[ExpectedException]
[ExpectedSqlException]
[TestMethod]
[ShouldThrow]
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?