QuestionQ116

VerifiedPlan and implement data platform resources

You have a resource group named App1Dev that contains an Azure SQL Database server named DevServer1. DevServer1 includes an Azure SQL Database instance called DB1. The schema and permissions for DB1 are saved in a Microsoft SQL Server Data Tools (SSDT) database project.

You need to populate a new resource group, App1Test, with the DB1 database and an Azure SQL server named TestServer1. The resources in App1Test must use the same configurations as the resources in App1Dev.

Which four actions should you perform, in sequence?

Drag & Drop
Explanation

Exporting an ARM template captures the Azure resource configuration. Updating the server name and dependent template variables adapts it for TestServer1, then deployment provisions the target resources in App1Test. Deploying the SSDT database project subsequently applies DB1’s schema and permissions.

Learn more

Community Discussion

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