DP-300 Question #47: Real Exam Question with Answer & Explanation

Question

Drag and Drop 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. Answer:

Explanation

The correct sequence follows a logical infrastructure-as-code deployment workflow: first export the ARM templates from App1Dev (capturing the existing configuration of DevServer1 and DB1), then modify the server name and variables to reflect TestServer1 and App1Test, then deploy the modified templates to create the new resource group with matching configurations, and finally deploy the database schema and permissions from the SSDT project to populate DB1 with the correct structure and access controls. This approach ensures the new environment mirrors the original without manual reconfiguration.

No community discussion yet for this question.