DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ38

Implement a secure environment

You have an Azure SQL Managed Instance named Server1 and an Azure Blob Storage account named storage1 that holds Microsoft SQL Server database backup files.

You plan to use Log Replay Service to migrate the backups from storage1 to Server1. The solution must use the strongest security level when it connects to storage1.

Which PowerShell cmdlet should you run, and which parameter should you specify to secure the connection?

Select
Cmdlet:
Parameter:
Explanation

Start-AzSqlInstanceDatabaseLogReplay initiates Log Replay Service. Its storage-container identity can be set to ManagedIdentity, which lets the managed instance authenticate to Blob Storage without using a storage account key or SAS token; this is the most secure listed authentication method.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!