| 1 | What is SQL Server replication, and what problem does it help solve? SQL Server › Replication | SQL Server | Replication | Beginner |
| 2 | What are the three main types of replication in SQL Server, and how do they differ? SQL Server › Replication | SQL Server | Replication | Beginner |
| 3 | What roles do the publisher, distributor, and subscriber play in a transactional replication setup? SQL Server › Replication | SQL Server | Replication | Intermediate |
| 4 | How do you monitor the health and latency of a transactional replication setup to ensure subscribers are staying reasonably up to date? SQL Server › Replication | SQL Server | Replication | Intermediate |
| 5 | What steps are involved in setting up transactional replication for the first time between a publisher and a new subscriber? SQL Server › Replication | SQL Server | Replication | Intermediate |
| 6 | How would you troubleshoot a transactional replication setup where a subscriber has stopped receiving new changes entirely? SQL Server › Replication | SQL Server | Replication | Advanced |
| 7 | 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 |
| 8 | What is Redis replication, and how does it help improve availability and read scalability? Redis › Redis Replication | Redis | Redis Replication | Beginner |
| 9 | What is replication lag, and what factors can cause a replica to fall noticeably behind its primary server? Redis › Redis Replication | Redis | Redis Replication | Intermediate |
| 10 | How do you check the current replication status and role of a specific Redis instance, whether it is acting as a primary or a replica? Redis › Redis Replication | Redis | Redis Replication | Intermediate |
| 11 | How do you enable TLS encryption for internal replication and cluster bus traffic between Redis nodes, not just for client connections? Redis › TLS & Encryption in Redis | Redis | TLS & Encryption in Redis | Advanced |
| 12 | How does replication work in ElastiCache for Redis to provide high availability? AWS › Amazon ElastiCache (Redis & Memcached) | AWS | Amazon ElastiCache (Redis & Memcached) | Intermediate |
| 13 | How does DMS support continuous data replication using change data capture to minimize downtime during a migration? AWS › AWS Database Migration Service & Application Migration | AWS | AWS Database Migration Service & Application Migration | Intermediate |
| 14 | What is database replication, and how does a Node.js application typically route reads to replicas while sending writes to a primary? Node.js › Databases | Node.js | Databases | Advanced |
| 15 | What is database sharding, and what problem does it solve that replication alone doesn't address? Node.js › Databases | Node.js | Databases | Advanced |
| 16 | How should an organization design a comprehensive database resilience and disaster recovery strategy combining Multi-AZ, read replicas, cross region replication, and automated backups? AWS › RDS & Databases | AWS | RDS & Databases | Advanced |
| 17 | How can S3 Multi-Region Access Points and Cross-Region Replication support building a resilient, low latency, globally distributed storage architecture? AWS › S3 & Storage | AWS | S3 & Storage | Advanced |
| 18 | How do you configure a Redis instance to become a replica of another Redis instance? Redis › Redis Replication | Redis | Redis Replication | Beginner |
| 19 | What is the difference between full resynchronization and partial resynchronization when a replica reconnects to its primary after a temporary disconnection? Redis › Redis Replication | Redis | Redis Replication | Intermediate |
| 20 | How would you design a read scaling strategy using multiple Redis replicas for an application with a very read heavy workload? Redis › Redis Replication | Redis | Redis Replication | Advanced |
| 21 | What happens to a Redis Cluster's replicas during a failover event, and how does the cluster decide which replica gets promoted? Redis › Redis Replication | Redis | Redis Replication | Advanced |
| 22 | 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 |
| 23 | What is Change Data Capture in SQL Server, and what problem does it solve? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Beginner |
| 24 | What is sharding in a Redis Cluster, and why is it necessary for very large datasets? Redis › Cluster Sharding & Hash Slots | Redis | Cluster Sharding & Hash Slots | Beginner |
| 25 | What is the difference between a master node and a replica node within a Redis Cluster? Redis › Clustering | Redis | Clustering | Beginner |
| 26 | What is Redis Sentinel, and what role does it play in providing high availability for a non clustered Redis setup? Redis › Redis Sentinel & High Availability | Redis | Redis Sentinel & High Availability | Beginner |
| 27 | Why does Redis Sentinel recommend running at least three Sentinel instances rather than just one? Redis › Redis Sentinel & High Availability | Redis | Redis Sentinel & High Availability | Beginner |
| 28 | How would you set up a disaster recovery plan for Redis that accounts for an entire data center or region becoming unavailable? Redis › Redis Backup & Disaster Recovery | Redis | Redis Backup & Disaster Recovery | Intermediate |
| 29 | How does an application discover the current primary Redis instance when using Sentinel, especially after a failover has occurred? Redis › Redis Sentinel & High Availability | Redis | Redis Sentinel & High Availability | Intermediate |
| 30 | What is the quorum setting in a Sentinel configuration, and how does it affect the decision to trigger a failover? Redis › Redis Sentinel & High Availability | Redis | Redis Sentinel & High Availability | Intermediate |
| 31 | How would you use Change Data Capture to build a near real time data synchronization pipeline between an operational database and a data warehouse? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Advanced |
| 32 | How would you deploy Redis Sentinel across multiple data centers or availability zones to maximize resilience against a localized failure? Redis › Redis Sentinel & High Availability | Redis | Redis Sentinel & High Availability | Advanced |
| 33 | What is the difference between using Redis Sentinel and using Redis Cluster for achieving high availability, and how would you decide between them? Redis › Redis Sentinel & High Availability | Redis | Redis Sentinel & High Availability | Advanced |