Nutanix NCP-DB Practice Questions

Which command can be used to assign a static IP address to the Era VM on ESXi?
set
era-server > era
era-server >
An administrator is trying to register an Oracle Database Server VM to Era.
Which dependency must be met?

A. SUDO NOPASS access is required

B. Enable reQUIREetty setting on the source database

C. /TEMP folder must have read-only permissions

D. set path = /sbin:/bin:/usr/sbin:/usr/bin

A. SUDO NOPASS access is required

Explanation:
To register an Oracle Database Server VM to Era in Nutanix Database Automation (NCP-DB), certain dependencies must be met. One of these is that SUDO NOPASS access is required1. This allows the Era service to perform necessary operations on the Oracle Database Server VM. As for assigning a static IP address to the Era VM on ESXi, you can use the vSphere Client to configure static IP settings2. However, this is not directly related to the registration of an Oracle Database Server VM to Era. Please note that these answers are based on the information available as of my last update in 2021 and may need to be verified with the most recent Nutanix Database Automation (NCP-DB) documentation or resources.

An administrator enables NDB Multi-Cluster on Cluster A. Cluster B is then registered with NDB. What are the different NDB Service VMs present in each Nutanix cluster?

A. Cluster A: 1 NDB Server
Cluster B: 1 NDB Agent

B. Cluster A: 1 NDB Agent
Cluster B: 1 NDB Server, 1 NDB Agent

C. Cluster A: 1 NDB Server, 1 NDB Agent
Cluster B: 1 NDB Agent

D. Cluster A: 1 NDB Agent
Cluster B: 1 NDB Server

C. Cluster A: 1 NDB Server, 1 NDB Agent
Cluster B: 1 NDB Agent

Explanation:
NDB Multi-Cluster is a feature that allows multiple Nutanix clusters to share a common NDB service for database management and automation. NDB service consists of two components: NDB Server and NDB Agent. NDB Server is the central component that provides the web UI, REST API, and database orchestration logic. NDB Agent is the component that runs on each Nutanix cluster and communicates with the NDB Server to perform database operations.
When NDB Multi-Cluster is enabled on Cluster A, it becomes the primary cluster that hosts the NDB Server VM. Cluster B, which is registered with NDB, becomes a secondary cluster that hosts only the NDB Agent VM. Therefore, Cluster A has both NDB Server and NDB Agent, while Cluster B has only NDB Agent. This configuration allows Cluster B to leverage the NDB service running on Cluster A for database management and automation.

A database administrator wants to define initialization variables for different types of database engines and workloads, like OLTP and DW. What type of profile would be used?

A. Software Profile Version

B. Network

C. Compute

D. Database Parameters

Explanation:
The database parameters profile is used to define the initialization variables for different types of database engines and workloads, such as OLTP and DW. The database parameters profile allows the database administrator to customize the configuration settings for each database engine, such as Oracle, SQL Server, PostgreSQL, and MySQL. The database parameters profile can also be applied to different database operations, such as provisioning, cloning, and patching. The database parameters profile helps to optimize the performance and functionality of the databases according to the specific requirements and best practices of each database engine and workload.
The software profile version is used to define the software version and edition for each database engine, such as Oracle 19c Enterprise Edition or SQL Server 2019 Standard Edition. The software profile version is required for provisioning new databases and patching existing databases. The software profile version helps to ensure the compatibility and compliance of the databases with the supported software versions and editions.
The network profile is used to define the network configuration and security settings for the database server VMs and the databases, such as the IP address, subnet mask, gateway, DNS, firewall rules, and SSL certificates. The network profile is required for registering new database server VMs and provisioning new databases. The network profile helps to ensure the connectivity and protection of the database server VMs and the databases within the network environment.
The compute profile is used to define the compute resources and storage policies for the database server VMs and the databases, such as the CPU, memory, disk size, disk type, compression, deduplication, and replication factor. The compute profile is required for provisioning new databases and cloning existing databases. The compute profile helps to ensure the availability and efficiency of the database server VMs and the databases within the Nutanix cluster.

An administrator would like to use Era for Copy Data Management operations on an Availability Group (AG) database. The AG database is hosted on replicas with different named instances, as shown below:
• SQLAGNI\EMR
• SQLAGN2\EMR
• SQLAGN3\DW
SQLAGN3\DW is running the Analytics service that needs real-time data.
How should the administrator register the database in Era?

A. Register the database as an Availability database.

B. Register the database as a Standalone database,

C. Register the SQLAGN3 from AG cluster and register the database as Availability database,

A. Register the database as an Availability database.

According to the Nutanix Database Automation (NCP-DB) learning documents, when dealing with an Availability Group (AG) database, the database should be registered as an Availability database1. This is because the AG database is hosted on replicas with different named instances, and registering it as an Availability database allows for Copy Data Management operations to be performed across all instances. This is particularly important when services such as the Analytics service running on SQLAGN3\DW require realtime data1.

An administrator has received a request to clone a source production database to an existing development server. Which two actions must be taken to complete this task?

A. The development server must be registered by Era in order to receive the clone.

B. The development server must be registered by Era and authorized to host clones from the Time Machine.

C. The development server must be authorized for the database Time Machine.

D. The development server must have the IP and credentials provided during cloning.

A. The development server must be registered by Era in order to receive the clone.

D. The development server must have the IP and credentials provided during cloning.

Explanation:
According to the Nutanix Database Automation (NCP-DB) Learning documents12, to clone a source production database to an existing development server, the following actions must be taken:
A. The development server must be registered by Era in order to receive the clone1. This is because Nutanix Era is a database management tool that manages the lifecycle of databases and their copies. Registering the development server with Era allows it to manage the database on that server.
D. The development server must have the IP and credentials provided during cloning2. This is necessary for Era to access the development server and perform the cloning operation. The IP address and credentials are used to establish a connection to the development server. Without these details, Era would not be able to access the server and perform the cloning operation.

What step should be taken to make the profile available to all users:

A. Create an Access Control role with the Create Profile right and assign to all users.

B. Create an Access Control group with the desired users and grant it the Database Admin role.

C. Update the profile and set the status to Published.

D. Update the profile and set available state to All.

Explanation:
The correct answer is D because it allows the administrator to make the profile available to all users without requiring any additional permissions or roles. A profile is a collection of settings that define how NDB manages a database server or a database. By default, a profile is only available to the user who created it and the Database Admin role. To make a profile available to all users, the administrator can update the profile and set the available state to All. This will enable all users to view and use the profile for their database operations. The other options are not correct because they either require additional steps or do not achieve the desired outcome. Option A is not correct because creating an Access Control role with the Create Profile right and assigning it to all users will only allow them to create their own profiles, not use the existing one. Option B is not correct because creating an Access Control group with the desired users and granting it the Database Admin role will only make the profile available to those users, not all users. Option C is not correct because updating the profile and setting the status to Published will not change the availability of the profile, only the state of the profile. A published profile is a profile that has been tested and verified by the administrator and is ready for use. A draft profile is a profile that is still under development or testing and is not ready for use.