An administrator needs to provision PostgreSQL instance from a software profile. The software profile was created from a VM with services such as etcd, HAProxy, Patroni and keepalived installed. What should the administrator perform to successfully provision an HA instance?
Correct Answer: C
To provision a PostgreSQL HA instance from a software profile created from a VM with services like etcd, HAProxy, Patroni, and keepalived installed, the administrator must ensure the instance aligns with NDB's HA framework. These services (e.g., Patroni for PostgreSQL HA management, HAProxy for load balancing) may conflict with NDB's built-in HA mechanisms. Provisioning an HA instance with these services disabled allows NDB to manage HA using its native replication and failover capabilities (e.g., streaming replication), avoiding duplication or interference from the VM's pre-installed services. Option A (Provision an HA instance with the services enabled) is incorrect because enabling these services may cause conflicts with NDB's HA management. Option B (Disable the services, create a software profile version, and provision an HA instance) is incorrect because disabling services and recreating a profile is unnecessary; the provisioning step can handle service configuration. Option C (Provision an HA instance with the services disabled) is correct as it ensures NDB's HA features take precedence without interference. Option D (Enable the services, create a software profile version, and provision an HA instance) is incorrect due to potential conflicts with NDB's HA implementation. Note: The typo "PostqreSQL" is assumed to mean "PostgreSQL." References Nutanix Database Service (NDB) User Guide, Chapter 4: Managing Database Engines, Section: Provisioning HA Instances Nutanix Certified Professional - Database Automation (NCP-DB) v7.5Blueprint, Section 4: Manage Database Engines
Question 57
What is used to temporarily store the transaction logs of the source database before they are copied to the log?
Correct Answer: A
The Database Agent is used to temporarily store the transaction logs of the source database before they are copied to the log. This is a critical component for ensuring data consistency and recovery in database operations.References:Nutanix Database Automation documentation, focusing on database agents and their roles in transaction log management.
Question 58
An administrator needs to take multiple snapshots per day and retain them for one week. How should the administrator define and schedule the SLA?
Correct Answer: D
The correct answer is D because it matches the requirement of taking multiple snapshots per day and retaining them for one week. Option A is incorrect because it only takes one snapshot per day, which is not enough for the administrator's need. Option B is incorrect because it only retains the snapshots for one week, which means the older snapshots will be deleted after seven days. Option C is incorrect because it only takes two snapshots per week, which is not frequent enough for the administrator's need. The following sources provide more information about the SLA retention policies and how to create and modify them in NDB: Nutanix Database Management & Automation (NDMA) course, Module 4: Protecting Databases Using Time Machine, Lesson 4.1: Creating and Modifying SLA Retention Policies Nutanix Certified Professional - Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section 5 - Protect NDB-managed Databases Using Time Machine Nutanix Database Service (NDB) User Guide, Chapter 6: Protecting Databases Using Time Machine, Section 6.1: Creating and Modifying SLA Retention Policies
Question 59
Which two profiles are required to provision a new Oracle database through Era? (Choose two.)
Correct Answer: B,D
In the Nutanix Database Automation (NCP-DB) framework, provisioning a new Oracle database through Era requires the configuration of both a Compute and a Storage profile1. The Compute profile is used to define the resources allocated to the database, such as CPU and memory, while the Storage profile is used to specify the storage configuration for the database. These profiles are essential in ensuring that the database is provisioned with the necessary resources and storage configurations for optimal performance23.
Question 60
An administrator needs to provision a PostgreSQL cluster instance with an external Load Balancer. Which software can be omitted on the Reference VM while creating the Software Profile?
Correct Answer: B
When provisioning a PostgreSQL cluster instance with an external load balancer in NDB, the administrator creates a software profile from a reference VM. The reference VM typically includes software like Patroni (for HA management), HAProxy (for internal load balancing), keepalived (for high availability IP management), and etcd (for distributed configuration). Since an external load balancer is used, the internal HAProxy can be omitted from the reference VM. NDB will rely on the external load balancer to distribute traffic, eliminating the need for HAProxy in the software profile, while the other components remain essential for cluster management. * Option A (Patroni) is incorrect because Patroni is required for PostgreSQL HA management. * Option B (HAProxy) is correct as it can be omitted when an external load balancer is configured. * Option C (keepalived) is incorrect because keepalived is needed for HA IP failover. * Option D (etcd) is incorrect because etcd is necessary for distributed configuration in the cluster. This adjustment streamlines the profile for external load balancer use. References * Nutanix Database Service (NDB) User Guide, Chapter 4: Managing Software Profiles, Section: Creating Software Profiles for HA Instances * Nutanix Certified Professional - Database Automation (NCP-DB) v6.5 Blueprint, Section 4: Manage Database Software Profiles