DP-300 Certification Practice Question #161

Question

You have an Azure SQL managed instance named Server1 and an Azure Blob Storage account named storage1 that contains Microsoft SQL Server database backup files.

You plan to use Log Replay Service to migrate the backup files from storage1 to Server1. The solution must use the highest level of security when connecting to storage1.

Which PowerShell cmdlet should you run, and which parameter should you specify to secure the connection? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

To migrate database backup files from an Azure Blob Storage container using the Log Replay Service (LRS) to an Azure SQL Managed Instance, you must use the `Start-AzSqlInstanceDatabaseLogReplay` cmdlet to initiate the process. To satisfy the requirement for the highest level of security, you should configure LRS to authenticate using the managed identity of the SQL Managed Instance by specifying the `ManagedIdentity` parameter for the storage container identity. This eliminates the need to generate and expose shared access signatures (SAS tokens) or storage account access keys.

More DP-300 practice questions