Practice Free NCP-DB-6.5 Exam Online Questions
Question #51
Refer to the exhibit.
An administrator attempts to provision their first clustered database environment with NDB. The operation fails with the Operation Error shown in the exhibit.
Which database engine was being deployed during this operation?
- A . Oracle
- B . MySQL
- C . Microsoft SQL
- D . PostgreSQL
Correct Answer: B
B
Explanation:
The error message in the exhibit indicates that the operation failed during the “Create and Register Database Server VMs” step because “Provisioning of all the observers simultaneously took more than two hours.” This type of error is associated with MySQL, as it involves observers which are a part of MySQL Group Replication, used for ensuring high availability1. The other options are not related to the error message, as they do not use observers or Group Replication for clustering.
Reference:
1: Nutanix Database Automation (NCP-DB) course, Module 5: Database High Availability, Lesson 5.2:
MySQL Group Replication, slide 7
B
Explanation:
The error message in the exhibit indicates that the operation failed during the “Create and Register Database Server VMs” step because “Provisioning of all the observers simultaneously took more than two hours.” This type of error is associated with MySQL, as it involves observers which are a part of MySQL Group Replication, used for ensuring high availability1. The other options are not related to the error message, as they do not use observers or Group Replication for clustering.
Reference:
1: Nutanix Database Automation (NCP-DB) course, Module 5: Database High Availability, Lesson 5.2:
MySQL Group Replication, slide 7
Question #52
In NDB, which two Time Machine options are available when creating a database clone? (Choose two.)
- A . Point in time
- B . Restore point
- C . Backup
- D . Snapshot
Correct Answer: A, D
A, D
Explanation:
The correct answer is A and D because these are the two Time Machine options that are available when creating a database clone in NDB. Point in time allows the user to specify a date and time to create a clone from a specific point in the database history. Snapshot allows the user to select a previously taken snapshot to create a clone from a consistent state of the database.
Option B is incorrect because Restore point is not a Time Machine option, but a feature that allows the user to restore a source database to a previous point in time.
Option C is incorrect because Backup is not a Time Machine option, but a feature that allows the user to backup a database to a remote location.
Reference: The following sources provide more information about the Time Machine options and cloning features in NDB:
Nutanix Database Management & Automation (NDMA) course, Module 4: Protecting Databases
Using Time Machine, Lesson 4.2: Cloning Databases
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.2: Cloning Databases
[Nutanix Support & Insights], NDB Time Machine Under the Hood
A, D
Explanation:
The correct answer is A and D because these are the two Time Machine options that are available when creating a database clone in NDB. Point in time allows the user to specify a date and time to create a clone from a specific point in the database history. Snapshot allows the user to select a previously taken snapshot to create a clone from a consistent state of the database.
Option B is incorrect because Restore point is not a Time Machine option, but a feature that allows the user to restore a source database to a previous point in time.
Option C is incorrect because Backup is not a Time Machine option, but a feature that allows the user to backup a database to a remote location.
Reference: The following sources provide more information about the Time Machine options and cloning features in NDB:
Nutanix Database Management & Automation (NDMA) course, Module 4: Protecting Databases
Using Time Machine, Lesson 4.2: Cloning Databases
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.2: Cloning Databases
[Nutanix Support & Insights], NDB Time Machine Under the Hood
Question #53
An administrator needs to enable multi-cluster to setup NDB HA.
What should the administrator configure for the NDB Agent to satisfy this requirement?
- A . Name Prefix
- B . Network Profile
- C . Static VLAN
- D . Compute Profile
Correct Answer: B
B
Explanation:
To enable multi-cluster setup for NDB High Availability (HA), the administrator must configure the NDB Agent with a Network Profile. A Network Profile defines the networking settings (e.g., VLANs, IP ranges) that the NDB Agent uses to communicate across clusters. This is critical for multi-cluster HA, as it ensures consistent network configuration for replication, failover, and data synchronization between clusters. The Network Profile must be properly configured to handle inter-cluster traffic and latency requirements (e.g., <25ms RTT).
Other options are irrelevant:
B
Explanation:
To enable multi-cluster setup for NDB High Availability (HA), the administrator must configure the NDB Agent with a Network Profile. A Network Profile defines the networking settings (e.g., VLANs, IP ranges) that the NDB Agent uses to communicate across clusters. This is critical for multi-cluster HA, as it ensures consistent network configuration for replication, failover, and data synchronization between clusters. The Network Profile must be properly configured to handle inter-cluster traffic and latency requirements (e.g., <25ms RTT).
Other options are irrelevant:
Question #54
Which port should be opened to ensure the NDB server, NDB agent, and NDB database agent can communicate with the registered cluster via REST API calls?
- A . 2009
- B . 3205
- C . 3260
- D . 9440
Correct Answer: A
A
Explanation:
To ensure the NDB server, NDB agent, and NDB database agent can communicate with the registered
cluster via REST API calls, port 2009 must be opened. This port is used by NDB components to facilitate RESTful communication with the Nutanix cluster (e.g., Prism Element or Prism Central) for operations such as provisioning, monitoring, and management. Proper firewall configuration to allow traffic on this port is a prerequisite for NDB’s integration with the cluster.
Other options are incorrect:
B. 3205: Not a standard NDB port; used for other Nutanix services.
C. 3260: Associated with iSCSI, not REST API communication.
D. 9440: Used for Prism Element’s HTTPS management interface, not NDB-specific REST calls.
Thus, the verified answer is A, reflecting NDB’s REST API requirements.
Official Nutanix Database Automation
Reference: Nutanix Database Management & Automation (NDMA) course, Module 2: Deploying and Configuring
an NDB Solution, Lesson 2.1: Network and Port Requirements.
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5 Knowledge Objectives, Section 2: Deploy and Configure an NDB Solution, Objective 2.1: Prepare Hosts (applicable to v6.10). Nutanix NDB Installation Guide: "Network Ports and Protocols" section, specifying port 2009.
A
Explanation:
To ensure the NDB server, NDB agent, and NDB database agent can communicate with the registered
cluster via REST API calls, port 2009 must be opened. This port is used by NDB components to facilitate RESTful communication with the Nutanix cluster (e.g., Prism Element or Prism Central) for operations such as provisioning, monitoring, and management. Proper firewall configuration to allow traffic on this port is a prerequisite for NDB’s integration with the cluster.
Other options are incorrect:
B. 3205: Not a standard NDB port; used for other Nutanix services.
C. 3260: Associated with iSCSI, not REST API communication.
D. 9440: Used for Prism Element’s HTTPS management interface, not NDB-specific REST calls.
Thus, the verified answer is A, reflecting NDB’s REST API requirements.
Official Nutanix Database Automation
Reference: Nutanix Database Management & Automation (NDMA) course, Module 2: Deploying and Configuring
an NDB Solution, Lesson 2.1: Network and Port Requirements.
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5 Knowledge Objectives, Section 2: Deploy and Configure an NDB Solution, Objective 2.1: Prepare Hosts (applicable to v6.10). Nutanix NDB Installation Guide: "Network Ports and Protocols" section, specifying port 2009.
Question #55
What happens to the primary member in a MongoDB Server Cluster during the NDB patching process?
- A . It is patched last and is restored to its original state.
- B . It becomes a read-only member during the patching process.
- C . It is skipped during the patching process to ensure no downtime.
- D . It is patched first and then becomes a secondary member.
Correct Answer: D
D
Explanation:
According to the NDB documentation, the NDB patching process for MongoDB Server Cluster follows these steps1:
NDB identifies the primary member of the MongoDB Server Cluster and patches it first.
NDB triggers a failover to elect a new primary member from the remaining secondary members.
NDB patches the former primary member, which becomes a secondary member after the failover.
NDB patches the remaining secondary members one by one.
NDB verifies the patching status and the cluster health.
This process ensures that the MongoDB Server Cluster always has a primary member available to handle write operations, while minimizing the downtime and the impact on the cluster performance.
Reference: Nutanix Support & Insights, section “Patching a MongoDB Server Cluster”
D
Explanation:
According to the NDB documentation, the NDB patching process for MongoDB Server Cluster follows these steps1:
NDB identifies the primary member of the MongoDB Server Cluster and patches it first.
NDB triggers a failover to elect a new primary member from the remaining secondary members.
NDB patches the former primary member, which becomes a secondary member after the failover.
NDB patches the remaining secondary members one by one.
NDB verifies the patching status and the cluster health.
This process ensures that the MongoDB Server Cluster always has a primary member available to handle write operations, while minimizing the downtime and the impact on the cluster performance.
Reference: Nutanix Support & Insights, section “Patching a MongoDB Server Cluster”
Question #56
Which NDB HA control plane VM is upgraded first during an NDB upgrade?
- A . NDB Server
- B . Leader NDB API Server
- C . Leader HAProxy
- D . NDB Agent VMs
Correct Answer: B
B
Explanation:
During an NDB upgrade, the upgrade process follows a specific order to maintain stability and HA. The Leader NDB API Server is upgraded first. This server coordinates API requests and ensures the control plane remains operational. Upgrading the leader first minimizes disruption, as subsequent components (e.g., other API servers, HAProxy) rely on its leadership role. Once the leader is upgraded, the remaining NDB HA control plane VMs (e.g., follower API servers, HAProxy) are updated in sequence.
Other options are incorrect:
B
Explanation:
During an NDB upgrade, the upgrade process follows a specific order to maintain stability and HA. The Leader NDB API Server is upgraded first. This server coordinates API requests and ensures the control plane remains operational. Upgrading the leader first minimizes disruption, as subsequent components (e.g., other API servers, HAProxy) rely on its leadership role. Once the leader is upgraded, the remaining NDB HA control plane VMs (e.g., follower API servers, HAProxy) are updated in sequence.
Other options are incorrect:
Question #57
While registering an Always on Availability Group database, an administrator selects the following option:
Multiple Databases as a Group with One Time Machine
Which statement is true regarding this chosen option?
- A . PITR-based SLAs are supported for database groups containing mixed Recovery Model.
- B . PITR-based SLAs are not supported for database groups containing mixed Recovery Model
- C . Point in Time Clones are not supported by Database Groups.
- D . PITR-based SLAs are not supported for database groups.
Correct Answer: B
B
Explanation:
Nutanix Database Automation (NCP-DB) introduces the concept of MS SQL Server database groups, which allows multiple databases running in the same database instance to be grouped as one Time Machine entity1. This applies to both single DB Server VM setups, standalone databases, as well as to Availability Group databases1. However, it does not support Point In Time Recovery (PITR)-based Service Level Agreements (SLAs) for database groups containing mixed Recovery Models. This means that if the databases within the group have different recovery models, PITR-based SLAs cannot be applied to the group as a whole.
B
Explanation:
Nutanix Database Automation (NCP-DB) introduces the concept of MS SQL Server database groups, which allows multiple databases running in the same database instance to be grouped as one Time Machine entity1. This applies to both single DB Server VM setups, standalone databases, as well as to Availability Group databases1. However, it does not support Point In Time Recovery (PITR)-based Service Level Agreements (SLAs) for database groups containing mixed Recovery Models. This means that if the databases within the group have different recovery models, PITR-based SLAs cannot be applied to the group as a whole.
Question #58
Which two Oracle software components does Era patch? (Choose two.)
- A . Grid home
- B . Oracle home
- C . Application home
- D . user home
Correct Answer: A, B
A, B
Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, Era provides out-of-band patching of databases to eliminate database configuration sprawl1.
The two Oracle software components that Era patches are:
A, B
Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, Era provides out-of-band patching of databases to eliminate database configuration sprawl1.
The two Oracle software components that Era patches are:
Question #58
Which two Oracle software components does Era patch? (Choose two.)
- A . Grid home
- B . Oracle home
- C . Application home
- D . user home
Correct Answer: A, B
A, B
Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, Era provides out-of-band patching of databases to eliminate database configuration sprawl1.
The two Oracle software components that Era patches are:
A, B
Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, Era provides out-of-band patching of databases to eliminate database configuration sprawl1.
The two Oracle software components that Era patches are:
Question #60
An administrator selected Bronze SLA for Era Time Machine during database registration.
Which two capabilities are supported by the Time Machine for this database? (Choose two,)
- A . Provwonng
- B . Log Catch up
- C . Cloning
- D . Snapshots
Correct Answer: B D
B D
Explanation:
The Nutanix Era Time Machine provides various capabilities depending on the Service Level Agreement (SLA) selected during database registration1. For a database with a Bronze SLA, the Time Machine supports both “Log Catch up” and "Snapshots"2. “Log Catch up” allows the Time Machine to keep up with the latest changes in the database by capturing log data2. “Snapshots” are point-in-time copies of the database that can be used for recovery or cloning2.
B D
Explanation:
The Nutanix Era Time Machine provides various capabilities depending on the Service Level Agreement (SLA) selected during database registration1. For a database with a Bronze SLA, the Time Machine supports both “Log Catch up” and "Snapshots"2. “Log Catch up” allows the Time Machine to keep up with the latest changes in the database by capturing log data2. “Snapshots” are point-in-time copies of the database that can be used for recovery or cloning2.