nerdexam
Microsoft

DP-300 · Question #249

You have an on-premises Microsoft SQL Server 2019 instance named SQL1 that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named MI1 and an…

The correct answer is A. Generate a shared access signature (SAS). For backup and restore process first you need to backup to Azure Storage and in order to authenticate to Azure Storage first you need to create SAS through which authentication would be done and .bak file would be created on Azure storage…

Submitted by olafpl· Mar 6, 2026Plan and implement data platform resources

Question

You have an on-premises Microsoft SQL Server 2019 instance named SQL1 that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named MI1 and an Azure Storage account named storage1. You plan to migrate db1 to MI1 by using the backup and restore process. You need to ensure that you can back up db1 to storage1. The solution must meet the following requirements: - Use block blob storage. - Maximize security. What should you do on storage1?

Options

  • AGenerate a shared access signature (SAS).
  • BCreate an access policy.
  • CRotate the storage keys.
  • DEnable infrastructure encryption.

How the community answered

(31 responses)
  • A
    81% (25)
  • B
    13% (4)
  • C
    3% (1)
  • D
    3% (1)

Explanation

For backup and restore process first you need to backup to Azure Storage and in order to authenticate to Azure Storage first you need to create SAS through which authentication would be done and .bak file would be created on Azure storage. https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server- to-managed-instance-guide?view=azuresql#backup-and-restore

Topics

#backup to URL#SAS token#block blob storage#SQL MI migration

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice