Nutanix NCP-DB Practice Questions

Which disk is omitted from a Software Profile?

A. System Page File

B. SQL Installation

C. User Database

D. System Database

A. System Page File

Explanation:
According to the Nutanix Database Automation (NCP-DB) course, a Software Profile is a template that defines the configuration of the database engine, such as the version, edition, features, and parameters1. It also specifies the disk layout for the database installation, such as the size, type, and mount point of each disk1. However, the System Page File disk is omitted from the Software Profile, as it is automatically created by the NDB service based on the memory size of the database server VM1. The other options are included in the Software Profile, as they are essential for the database operation and performance1.

Refer to the exhibit.

An administrator is receiving critical NDB email alerts regarding storage for the DBA database, which is a member of a database group.
How would the administrator remediate the issue within NDB?

A. From the Database Summary page for the DBA database, use the Scale option to grow the storage accordingly.

B. From the Databases page, select the Database group and Scale the storage from the Database Actions menu.

C. From Prism Central, add additional storage to the VM, then expand the log storage via the database tools.

D. From the Alerts page, select the alert, choose Set Status to Resolved, and Scale the storage via the Resolve Now dialogue box.

A. From the Database Summary page for the DBA database, use the Scale option to grow the storage accordingly.

Explanation: The administrator can remediate the issue of critical storage alerts by scaling up the storage directly from the Database Summary page for that specific DBA database. This action allows for an increase in storage capacity to alleviate space constraints and prevent future critical alerts related to storage space1. The other options are not correct, as they either involve scaling the entire database group, which may not be necessary or desired, or require additional steps outside of NDB, which may not be feasible or efficient.

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.

B. PITR-based SLAs are not supported for database groups containing mixed Recovery Model

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.

How can Era be configured to send alert notifications to email recipients?

A. From Administration select Era Service then go to Era service name and setup email notification,

B. From Administration, select access control then add a user end setup email notification.

C. From Administration, select Ere Service then go to configure notification widget and then click update to update SMTP server configuration

D. From Administration select access control, select SMTP and then click update to update SMTP sewer configuration.

C. From Administration, select Ere Service then go to configure notification widget and then click update to update SMTP server configuration

Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, to configure Era to send alert notifications to email recipients, you need to go to the Administration section, select Era Service, then go to the configure notification widget. From there, you can update the SMTP server configuration1. This allows Era to use the SMTP server to send alert notifications to the specified email recipients1.

Within NDB, an administrator needs to register a PostgreSQL database server VM with a database. Where should the database data and log files be located in order to successfully complete this task?

A. On a separate mount point

B. On the same mount point

C. On the same disk as the binary installation

D. On the same disk as the operating system

A. On a separate mount point

Explanation:
To register a PostgreSQL database server VM with a database on NDB, the database data and log files must be located on a separate mount point from the operating system and the binary installation. This is because NDB uses the mount point as the identifier for the database server VM and the database. If the data and log files are on the same mount point as the operating system or the binary installation, NDB will not be able to recognize them as a valid database server VM or database. Therefore, the administrator should create a separate mount point for the data and log files and specify it during the registration process.

Which two methods can be used to upgrade Era? (Choose two.)

A. Nutanix LCM

B. Offline Upgrade

C. Rolling Upgrade

D. One-click Upgrade

B. Offline Upgrade

D. One-click Upgrade

Explanation:
Nutanix Era can be upgraded using the Offline Upgrade and One-click Upgrade methods. The Offline Upgrade method involves manually downloading the software update and applying it to the Era instance. The One-click Upgrade method allows you to upgrade Era directly from the Era management console with a single click, provided that the Era instance has internet connectivity and can reach the Nutanix software update portal1.