SA Cert Section 2

Question 1

What is High Availability

(A.O.MDT)

Answer 1

ability of a system to remain accessible, operational, minimizing down time

Question 2

How does a company achieve HA

(R)

Answer 2

This is achieved through redundancy. Redundancy means maintaining multiple copies of data (replica sets).

This provides a backup resource, ensuring a seamless transition to ensure high uptime and availability.

Question 3

Workload isolation

S.D.W

Answer 3

separating different types of database workloads (transactional, analytical) to prevent them from interfering with each other. This helps improve performance, reliability, and resource efficiency.

Question 4

What is Sharding? Give an example.

H.S. G

Answer 4

Method of horizontal scaling by distributing data across multiple servers.

Examples of Sharding include Geo-based sharding (location based sharding). Data is partitioned based on geographic location to users, placing data closer to where it’s accessed to reduce latency.