Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 10
1. Which of the following scenario prefers failover cluster instance over stand alone instance in SQL Server?
Correct Answer is : High Availability
2. Point out the correct statement:
Correct Answer is : The detailed component diagnostics makes it possible to configure a more flexible failover policy
3. Benefits that SQL Server failover cluster instances provide:
Correct Answer is : All of the mentioned
4. The resources owned by WSFC node include:
Correct Answer is : One file share resource, if the FILESTREAM feature is installed
5. Point out the wrong statement:
Correct Answer is : Microsoft Lync Server 2010 supports clustering for Microsoft SQL Server 2005 only
6. Which of the following element is installed locally on each node of the FCI?
Correct Answer is : SQL Server Binaries
7. Which of the the following operation requires to run SQL Server Setup on the node?
Correct Answer is : All of the mentioned
8. A Windows Failover Cluster can support up to _______ nodes.
Correct Answer is : 16
9. Which of the following is a Windows Failover Cluster quorum mode?
Correct Answer is : Node Majority
10. An exciting new feature in SQL Server 2014 is the support for the deployment of a Failover Cluster Instance (FCI) with :
Correct Answer is : Cluster Shared Volumes (CSV)
