Exam DP-300 topic 3 question 63 discussion

Actual exam question from Microsoft's DP-300

Question #: 63
Topic #: 3

HOTSPOT
-

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.

Show Suggested Answer

Suggested Answer:

by bingomutant at Oct. 10, 2024, 10:23 p.m.

Comments

Submit Cancel

voodoo_sh

9 months, 1 week ago

https://learn.microsoft.com/en-us/powershell/module/az.sql/start-azsqlinstancedatabaselogreplay?view=azps-12.4.0 -StorageContainerIdentity ManagedIdentity Starts a Log Replay service with container identity specified as ManagedIdentity. In this case there is no need to specify StorageContainerSasToken parameter.

upvoted 1 times

...

bingomutant

10 months, 1 week ago

agree with given answer - Cmdlet: Start-AzSqlInstanceDatabaseLogReplay This cmdlet is used to initiate the process of log replay and migration from Azure Blob Storage to an Azure SQL Managed Instance. Parameter: ManagedIdentity Using Managed Identity provides the highest level of security because it eliminates the need for manual credentials (like Shared Access Signatures or Storage Account Keys). Managed Identity securely authenticates the service with Azure Blob Storage without exposing sensitive keys.

upvoted 2 times

...