| 1 | What are the licensing and edition requirements for using Always On Availability Groups in SQL Server? SQL Server › Always On Availability Groups | SQL Server | Always On Availability Groups | Intermediate |
| 2 | How would you plan a disaster recovery strategy that combines Always On Availability Groups across multiple data centers with regular backups? SQL Server › Always On Availability Groups | SQL Server | Always On Availability Groups | Advanced |
| 3 | What is an Always On Availability Group in SQL Server, and what problem does it solve? SQL Server › Always On Availability Groups | SQL Server | Always On Availability Groups | Beginner |
| 4 | What is the difference between the primary replica and secondary replicas in an Always On Availability Group? SQL Server › Always On Availability Groups | SQL Server | Always On Availability Groups | Beginner |
| 5 | What is the difference between automatic failover and manual failover in an Always On Availability Group? SQL Server › Always On Availability Groups | SQL Server | Always On Availability Groups | Intermediate |
| 6 | What is an availability group listener, and why is it important for applications connecting to an Always On Availability Group? SQL Server › Always On Availability Groups | SQL Server | Always On Availability Groups | Intermediate |
| 7 | How do you decide between synchronous commit mode and asynchronous commit mode for a specific replica in an Always On Availability Group? SQL Server › Always On Availability Groups | SQL Server | Always On Availability Groups | Advanced |
| 8 | How does replication compare to Always On Availability Groups for keeping data synchronized across multiple servers, and when would you choose one over the other? SQL Server › Replication | SQL Server | Replication | Advanced |
| 9 | What is SQL Server replication, and what problem does it help solve? SQL Server › Replication | SQL Server | Replication | Beginner |
| 10 | What are the three main types of replication in SQL Server, and how do they differ? SQL Server › Replication | SQL Server | Replication | Beginner |
| 11 | What are the main differences between SQL Server Express, Standard, and Enterprise editions? SQL Server › SQL Server Architecture & Editions | SQL Server | SQL Server Architecture & Editions | Beginner |
| 12 | What are the licensing implications and cost considerations when choosing between SQL Server editions for a growing company? SQL Server › SQL Server Architecture & Editions | SQL Server | SQL Server Architecture & Editions | Advanced |
| 13 | How do you automate regular backups in SQL Server so they run consistently without manual effort? SQL Server › Backup & Recovery | SQL Server | Backup & Recovery | Intermediate |
| 14 | How would you design a comprehensive backup and recovery strategy for a large, business critical database with strict recovery time and recovery point objectives? SQL Server › Backup & Recovery | SQL Server | Backup & Recovery | Advanced |