nerdexam
Microsoft

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.

Design and implement data storage

Question

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 solution for the planned deployment. Which storage solution should you implement?

Options

  • AAzure Table Storage
  • BStorage Spaces Direct
  • CAzure Blob storage
  • DSAN virtualization

How the community answered

(14 responses)
  • A
    7% (1)
  • C
    79% (11)
  • D
    14% (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.

AAzure Table Storage

Azure Table Storage is a NoSQL key-value store and is completely unsuitable for storing SQL Server relational database files or backups.

BStorage Spaces Direct

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.

CAzure Blob storageCorrect

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.

DSAN virtualization

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

#SQL Server FCI#Azure VMs#shared storage#high availability

Community Discussion

No community discussion yet for this question.

Full 70-473 Practice