Free Nutanix NCP-DB Exam Actual Questions

The questions for NCP-DB were last updated On May 2, 2024

Get All 146 Questions
Question No. 1

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

Show Answer Hide Answer
Correct 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 No. 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?

Show Answer Hide Answer
Correct 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 No. 3

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?

Show Answer Hide Answer
Correct 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 No. 4

Which two processes should an administrator take to create a software profile version for a newly-released Oracle ISc patch? (Choose

two.)

Show Answer Hide Answer
Correct Answer: C, D

To create a software profile version for a newly-released Oracle ISc patch, an administrator should follow these steps:

Download the required patch from MyOracle Support1. This is because Oracle patches are typically available from MyOracle Support, not Microsoft Support.

Apply the patch to the Oracle Home/Grid Home on a cloned VM of the gold image using OPatchAuto1. OPatchAuto is a utility provided by Oracle that automates the process of applying patches to a database.

Ensure success of patch application1. It's important to verify that the patch has been applied successfully to avoid any issues down the line.

Create a new software profile version from the original software profile using the cloned VM where OPatchAuto was run successfully using Era GUI1. This step is necessary to ensure that the new patch is included in the software profile.

Mark the original patch profile as hidden1. This step is optional but can be useful for keeping the software profile clean and organized.

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 No. 5

When registering SAP HANA Database and Database Server VM there are several (Linux) OS configuration requirements that must be set before registering a database Or a database server VM.

Which system file should the entry, secure_pazh be configured in?

Show Answer Hide Answer
Correct Answer: A

Get All 146 Questions Explore Other Nutanix Exams