NCP-DB practice question 25 of 35

Nutanix NDB gives an administrator the ability to create highly-available database pairs with which two databases? (Choose two.)

Full set: 251 questions
Answer options
A: MySQL
B: PostgreSQL Correct answer
C: SQL Server Correct answer
D: MariaDB
Correct Answer:
B. PostgreSQL; C. SQL Server
Explanation

Nutanix Database Service (NDB) provides built-in, automated high availability (HA) provisioning for specific database engines. For PostgreSQL, NDB configures a database cluster using Patroni, creating a primary server and one or more replicas for failover. For Microsoft SQL Server, NDB automates the deployment and configuration of Always On Availability Groups (AGs), which consist of a primary replica and one or more secondary replicas. While NDB supports managing MySQL and MariaDB, it does not offer a comparable integrated HA pairing feature during the initial provisioning workflow.

Why Incorrect

A. MySQL: NDB does not provide a native, automated HA pairing or clustering feature for MySQL during the provisioning process.
D. MariaDB: NDB does not provide a native, automated HA pairing or clustering feature for MariaDB during the provisioning process.

References

1. Nutanix Database Service (NDB) User Guide v2.5, Chapter: "Database Provisioning", Section: "High Availability for PostgreSQL", states "NDB enables you to provision a high availability (HA) PostgreSQL database server cluster."

2. Nutanix Database Service (NDB) User Guide v2.5, Chapter: "Database Provisioning", Section: "High Availability for SQL Server", states "NDB enables you to provision a SQL Server database that is part of an Always On Availability Group (AG)."

3. Nutanix Database Service (NDB) User Guide v2.5, Chapter: "Database Provisioning", Sections: "Provisioning a MySQL Database" and "Provisioning a MariaDB Database" describe single-instance provisioning without a built-in HA option.

Scroll to Top