QuestionQ99

VerifiedImplement a secure environment

You have an on-premises Microsoft SQL Server 2019 instance named SQL1 that hosts a database named db1. You have an Azure subscription containing 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 these requirements:

  • Use block blob storage.
  • Maximize security.

What should you do on storage1?

Explanation

SQL Server 2016 and later uses a shared access signature (SAS) for Backup to URL with Azure block blobs. A SAS grants limited, time-bound permissions to the needed blob container and is safer than granting access through a storage account key.

Learn more

Community Discussion

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