BenchMark Quizzes by MDFT Pro

Deploy Database to New Resource Group with Same Configuration

You work for MDFT Pro, a well-known training agency that provides Microsoft certification courses. Mark, the DevOps Engineer, has set up a development environment in a resource group named CourseDev that contains an Azure SQL Database server named DevCourseSQL. This server hosts an Azure SQL database named StudentDB containing course enrollment data. The schema and permissions for StudentDB have been carefully designed and are saved in a Microsoft SQL Server Data Tools (SSDT) database project for version control.

Mark now needs to create a test environment to validate changes before deploying to production. You need to populate a new resource group named CourseTest with the StudentDB database and an Azure SQL Server named TestCourseSQL. The resources in CourseTest must have identical configurations to the resources in CourseDev to ensure accurate testing.

Which four actions should you perform in sequence?

Choose all correct answers from the options below.

Explanations for each answer:

From the Azure portal, export the Azure Resource Manager templates is correct. Exporting ARM templates from the existing resources captures their current configuration, ensuring consistency between environments.
Change the server name and related variables in the templates is correct. Modifying the templates to use the new server name (StudentTestSQL) and updating related variables prepares the templates for the test environment.
From the Azure portal, deploy the templates is correct. Deploying the modified templates creates the new SQL Server and infrastructure in the TestCourses resource group with matching configuration.
From the database project, deploy the database schema and permissions is correct. Using the SSDT database project to deploy the schema and permissions ensures the test database matches the development database structure.
Add IP addresses to the firewall is incorrect. While firewall configuration may be needed eventually, it's not part of the core sequence for deploying the database with the same configuration.
Change the Active Directory admin on StudentTestSQL is incorrect. Changing the AD admin is not required as part of the basic deployment sequence and can be configured separately if needed.

Learn more about exporting ARM templates:

Export Azure Resource Manager Templates

Practice Exam

Deploy Database to New Resource Group with Same Configuration

Discuss this question on social media: