Home » Microsoft » 70-473 v.2 » Which three actions should you perform in sequence?
DRAG DROP
You have several web applications that are hosted in the West US region in Microsoft Azure.
You discover that a web application named App4 takes longer than expected to run.
You review the Azure SQL databases in your Azure subscription and discover that all the databases are hosted in the East US region.
You identify that App4 queries the databases.
You need to ensure that App4 queries a local database as quickly as possible.
Which three actions should you perform in sequence?
To answer, move the appropriate cmdlets from the list of cmdlets to the answer area and arrange them in the correct order.
Select and Place:
Correct Answer:
Explanation/Reference:
Explanation:
Box 1: New-AzureRmSqlDatabaseCopy
First copy the database to make a local database available.
To copy a database by using PowerShell, use the New-AzureRmSqlDatabaseCopy cmdlet.
Box 2: Create a Resource Group
Resource groups. Create separate resource groups for the primary region, the secondary region, and for Traffic Manager. This gives you the flexibility to manage each region as a single collection of resources.
Note: Primary and secondary regions. Use two regions to achieve higher availability. One is the primary region. The other region is for failover.
Box 3: New-AzureRmResourceGroupDeployment
The New-AzureRmResourceGroupDeployment cmdlet adds a deployment to an existing resource group. This includes the resources that the deployment requires. An Azure resource is a user-managed Azure entity, such as a database server, database, website, virtual machine, or Storage account.
Incorrect Answers:
A logical server acts as a central administrative point for multiple single or pooled databases, logins, firewall rules, auditing rules, threat detection policies, and failover groups.
The New-AzureRmSqlDatabaseExport command exports an Azure SQL Database as a .bacpac file to a storage account.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-copy
https://docs.microsoft.com/en-us/powershell/module/azurerm.resources/new-azurermresourcegroupdeployment?view=azurermps-6.7.0