Microsoft

DP-300 practice question 7

Administering Microsoft Azure SQL Solutions · free question 7 of 20

Question

You have a resource group named App1Dev that contains an Azure SQL Database server named DevServer1. DevServer1 contains an Azure SQL database named 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 named App1Test with the DB1 database and an Azure SQL Server named TestServer1. The resources in App1Test must have the same configurations as the resources in App1Dev. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Explanation

Exporting the Azure Resource Manager templates from App1Dev captures a snapshot of the existing resource configuration. The server name and related values are then changed, because exported templates usually need adjusting before they can be reused elsewhere. Deploying the templates creates TestServer1 and DB1 in App1Test with matching configurations, and the SSDT database project then deploys the schema and permissions into the new database. Changing the admin or adding firewall addresses would make the configuration differ from App1Dev or is already covered by the template.

Need the theory? Learn it free in the DP-300 course on Godlike Academy

Practice the whole free set

Answer all 20 free DP-300 questions with instant feedback, or unlock all 373 questions with Learn and Exam modes.