You plan to implement a fault tolerance solution for a Microsoft SQL Server database. The solution must provide failover storage on the local network.
You need to ensure that the solution can route traffic to failover storage by using SMB 3.0.
Which storage option should you use?
A . Cluster Shared Volumes
B . Microsoft Azure Blob storage
C . Always On availability group
D . Stretch Database
Answer: A
Explanation:
Clustered Shared Volumes (CSV) is a new clustered file system in Windows Server that is a layer of abstraction above the NTFS file system in a WSFC environment. It allows all Nodes in the failover cluster to read and write to the CSV volume. CSV leverages the investments Microsoft have made in SMB 3.0, such as SMB Direct and SMB Multichannel.
SQL Server 2014 was the first version of SQL Server to support CSVs.
References: https://www.microsoftpressstore.com/articles/article.aspx?p=2832586&seqNum=5
Leave a Reply