MCQ King
68 – System Availability MCQ
1 / 25
1. What is the primary purpose of using a Standby Server in SQL Server for high availability?
2 / 25
2. Which RAID level is commonly used to improve fault tolerance and performance for SQL Server databases?
3 / 25
3. In SQL Server, what is the purpose of database mirroring?
4 / 25
4. Which SQL Server high-availability solution provides automatic failover and can be configured with multiple secondary replicas for read scalability?
5 / 25
5. What is the primary purpose of a Failover Cluster in SQL Server?
6 / 25
6. In SQL Server, what is Log Shipping?
7 / 25
7. Which SQL Server high-availability solution involves maintaining a secondary server that is kept in sync with the primary server through transaction log backups?
8 / 25
8. What is the primary advantage of using a Standby Server in SQL Server?
9 / 25
9. Which RAID level provides redundancy by mirroring data across multiple disks and striping them for performance?
10 / 25
10. In SQL Server, what is the primary purpose of Database Mirroring?
11 / 25
11. Which SQL Server high-availability solution allows you to create a secondary copy of the database for read-only queries and reporting?
12 / 25
12. What is the primary purpose of using RAID technology for SQL Server databases?
13 / 25
13. In SQL Server, what is the primary benefit of Database Mirroring in high-availability scenarios?
14 / 25
14. Which RAID level in SQL Server is characterized by disk striping without data redundancy?
15 / 25
15. What is the primary goal of Log Shipping in SQL Server?
16 / 25
16. Which SQL Server high-availability solution involves multiple servers working together in a cluster to provide redundancy and failover support?
17 / 25
17. In SQL Server, what is the primary purpose of AlwaysOn Availability Groups?
18 / 25
18. What is the primary advantage of using RAID 1 (Mirroring) in SQL Server?
19 / 25
19. In SQL Server, what is the primary purpose of RAID 5 (Parity)?
20 / 25
20. Which high-availability solution in SQL Server provides automatic failover support with minimal data loss?
21 / 25
21. What is the primary purpose of AlwaysOn Availability Groups in SQL Server?
22 / 25
22. In SQL Server, what is the primary advantage of RAID 10 (Striping and Mirroring)?
23 / 25
23. Which high-availability solution in SQL Server allows you to configure readable secondary replicas for reporting purposes?
24 / 25
24. What is the primary advantage of using Log Shipping in SQL Server for disaster recovery?
25 / 25
25. When comparing high-availability components in SQL Server, which solution is known for providing both automatic failover and read scalability options?
Your score is
Restart quiz