This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
What are some scenarios where SQL Server on Azure Virtual Machines is a better option than Azure SQL Managed Instance?
When you need direct access to the operating system or file system, such as installing non-Microsoft or custom agents on the same virtual machine alongside SQL Server.
When you heavily rely on features supported by Azure SQL Managed Instance, such as FileStream/FileTable, PolyBase, and cross-instance transactions.
When your business requires staying at a particular version of Azure SQL Managed Instance.
What does the 'how' aspect of SQL Server migration planning encompass?
Recognizing the benefits after the migration is completed.
The evaluation of the amount of downtime that the organization is willing to tolerate.
The selection of appropriate migration tools and the development of a comprehensive migration plan.
What is the purpose of using SQL Server Always On availability group (AG) feature during migration?
To create an availability group listener on the source and target.
To minimize downtime during migration by extending an on-premises database into the cloud.
To create a Windows Server Failover Cluster on the source and target.
What are the advantages of backing up to block blob instead of page blob in Azure Blob Storage for SQL Server 2016 and later versions?
Block blobs offer safer authorization, improved backup performance, and support for larger database backups compared to page blob.
Page blobs offer safer authorization compared to block blob.
Block blobs offer better support for smaller database backups compared to page blob.
You must answer all questions before checking your work.
Was this page helpful?