Nutanix NCP-DB Nutanix Certified Professional - Database Automation v6.5 Exam Practice Test

Page: 1 / 14
Total 146 questions
Question 1

An Era-managed production MSSQL database crashed during a busy holiday weekend and the administrator has to restore the database to

the most recent timestamp with an objective to reduce the restore time and minimize data loss.

What option should the administrator do to achieve this objective?



Answer : B

Nutanix Era is a database management solution that automates and simplifies database administration tasks such as provisioning, patching, cloning, and backup.In the event of a database crash, the most effective way to minimize data loss and reduce restore time is to perform a restore of the source database by selecting the most recent point in time and including the Tail log Backup12.

The Tail log Backup includes all the transactions that have occurred since the last transaction log backup, which helps to minimize data loss.By selecting the most recent point in time for the restore, the administrator ensures that the database is restored to the state it was in just before the crash, thereby reducing the amount of data that needs to be reprocessed or reentered12.This approach aligns with the Nutanix Era's capabilities and best practices for database recovery12.


Question 2

An administrator needs to provision a database for test purposes with a data protection policy that minimizes storage usage.

How should the administrator best complete this task?



Answer : C

Nutanix Database Automation (NCP-DB) allows administrators to manage Service Level Agreements (SLAs) for databases. These SLAs define the data protection policies for databases. In this case, to minimize storage usage for a test database, the administrator should select the built-in NONE SLA.This SLA is configured for no snapshot or log backup, thus minimizing storage usage1.


Question 3

An administrator needs to provision a 3-node MSSQL Server AG with the following configuration:

* Two database server VMS including the primary replica on a local site

* A third database server VM on a remote site

How many IP addresses will the network at each site require?

A.

2 Cluster VIP and 1 listener IP on the local site



Answer : D

The correct answer is D. When setting up a 3-node MSSQL Server AG with two database server VMs on a local site and a third database server VM on a remote site, the network at each site will require the following IP addresses:

1 Cluster VIP and 1 Listener IP on the local site123.

1 Cluster VIP and 1 Listener IP on the remote site123.

2 IPs in the local site and 1 on the remote site for the database server nodes123.

This configuration ensures that each node in the cluster has a unique IP address, and each cluster and listener also has a unique IP address.This is necessary for the proper functioning of the cluster and to ensure that all nodes can communicate with each other and with clients123.


Question 4

What is the most efficient way to get information on REST APIs for a task in Era?



Answer : D

. This is because it allows the database to be refreshed at the exact time specified (9:30 PM) with the most recent data. The other options either perform the snapshot before the desired time or do not specify when the snapshot would occur. Please note that the exact answer might depend on the specific database system and its capabilities. Always refer to the database's documentation for the most accurate information.


Question 5

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?



Answer : A

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.


Question 6

Which two Oracle software components does Era patch? (Choose two.)



Answer : A, B

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)Grid home2B)Oracle home2

These components are crucial for the operation of Oracle databases and keeping them updated ensures data security and efficient validation of critical database updates1.Please refer to the official Nutanix documentation and training materials for more detailed information2.


Question 7

What is required to cre110ate a network profile in Era?



Answer : B

According to the Nutanix Database Automation (NCP-DB) learning documents, to create a network profile in Era, the network must be added to Era1.This is because Era needs to have control over the network in order to manage the databases effectively1.Once the network is added to Era, it can be used for various operations such as provisioning new databases, managing existing databases, and more1.


Page:    1 / 14   
Total 146 questions