nerdexam
Microsoft

DP-300 · Question #47

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…

The correct answer is From the Azure portal, export the Azure Resource Manager templates; Change the server name and related variables in the templates; From the Azure portal, deploy the templates.; From the database project, deploy the database schema and permissions. 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…

Submitted by rania.sa· Mar 6, 2026Implement and Manage Infrastructure as Code / Deploy and Configure Azure Resources

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:

Exhibit

DP-300 question #47 exhibit

Answer Area

Drag items

Change the Active Directory Admin on TestServer1Change the server name and related variables in the templatesFrom the database project, deploy the database schema and permissionsAdd IP addresses to the firewallFrom the Azure portal, export the Azure Resource Manager templatesFrom the Azure portal, deploy the templates.

Correct arrangement

  • From the Azure portal, export the Azure Resource Manager templates
  • Change the server name and related variables in the templates
  • From the Azure portal, deploy the templates.
  • From the database project, deploy the database schema and permissions

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.

Topics

#Azure Resource Manager#ARM Templates#Azure SQL Database#SSDT Deployment

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice