70-473 · Question #121
You plan to migrate an on-premises database to Microsoft Azure. The planned deployment will include an Always On Failover Cluster Instance of Microsoft SQL Server. You need to implement a storage solu
The correct answer is C. Azure Blob storage. While Azure Blob storage is not suitable for hosting SQL Server database files directly for a Failover Cluster Instance, it can be utilized as a cost-effective storage solution for other deployment aspects, such as storing database backups or cluster witness files.
Question
Options
- AAzure Table Storage
- BStorage Spaces Direct
- CAzure Blob storage
- DSAN virtualization
How the community answered
(14 responses)- A7% (1)
- C79% (11)
- D14% (2)
Why each option
While Azure Blob storage is not suitable for hosting SQL Server database files directly for a Failover Cluster Instance, it can be utilized as a cost-effective storage solution for other deployment aspects, such as storing database backups or cluster witness files.
Azure Table Storage is a NoSQL key-value store and is completely unsuitable for storing SQL Server relational database files or backups.
Storage Spaces Direct (S2D) is a technology that aggregates locally attached disks on Azure Virtual Machines to create shared storage for a Failover Cluster Instance, rather than being a standalone Azure storage service that is implemented directly for the database files.
Although Azure Blob storage cannot directly host the primary data files (MDF/LDF) for a SQL Server Always On Failover Cluster Instance, it is a common and cost-effective solution for storing SQL Server database backups. Blob storage can also be used for a cloud witness share for the Windows Server Failover Cluster, which is a component of an FCI deployment.
SAN virtualization is a technology for managing and provisioning storage in traditional on-premises data centers and is not an Azure-native storage service or solution for Azure deployments.
Concept tested: Azure storage options for SQL Server deployments
Source: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/storage-configuration
Topics
Community Discussion
No community discussion yet for this question.