Provisioning SQL Databases — Question 10

You have a Microsoft Azure SQL database in the US West region.
You need to create a replica in the US East region.
Which cmdlet should you run first?

Answer options

• A. New-AzureRmAvailabilitySet
• B. New-AzureRmLoadBalancer
• C. New-AzureRmSqlDatabaseSecondary
• D. New-AzureRmSqlElasticPool
• E. New-AzureRmVM
• F. New-AzureRmSqlServer
• G. New-AzureRmSqlDatabaseCopy
• H. New-AzureRmSqlServerCommunicationLink

Correct answer: G

Explanation

The correct answer is G, New-AzureRmSqlDatabaseCopy, because it is specifically used to create a copy of an existing SQL database in another region. The other options do not pertain to the replication of SQL databases; for instance, New-AzureRmSqlDatabaseSecondary is used for creating a secondary database for geo-replication, which is not the same as creating a new copy.