Nutanix NCP-DB Practice Questions

146 Questions ...

Updated On : 24-Feb-2025




Prepare with our NCP-DB practice questions and boost your chances of passing the exam effortlessly. Featuring Nutanix exam-like questions, they cover all critical topics and provide detailed explanations to enhance your understanding. Prepare smarter, not harder, and achieve your Nutanix NCP-DB certification goals effortlessly!

Page 6 out of 25 Pages ... Showing Questions in Random order from Exam

Which default roles are available within Era for Role-Based Access Control?


A. prism Admin
• Era Super Admin
• Era Database Admin
Era Infrastructure Admin


B. Super Admin
Database Admin
Database Infrastructure Admin
• Infrastructure Admin


C. Era Oracle Admin
Era SQLServer Admin
• Era PostgreSQL Admin
Era Mariadb Admin


D. Super Admin
Database Admin
Database Infrastructure Admin
prism Infrastructure Admin





A.
  prism Admin
• Era Super Admin
• Era Database Admin
Era Infrastructure Admin

Explanation:
Nutanix Era offers Role-Based Access Control capabilities by organically embedding them in the product. It provides the ability to add and remove users from Era, create and assign roles to users, and associate various privileges with a role1. The default roles available within Era for Role-Based Access Control are:

  • prism Admin
  • Era Super Admin
  • Era Database Admin
Era Infrastructure Admin1 These roles allow for the management of both physical resources like IP addresses and VLANs along with database entities like databases, time-machines, clones, and so on1.

An administrator has created a new SQL Server software profile version to apply the latest cumulative update. What should the administrator do to make it available to all users?


A. Set the status of the existing software profile version to Unpublished.


B. Update the software profile version and set the status to Published.


C. Deprecate the existing software profile version and use the new one.


D. Select the software profile version with the update and optimization,





B.
  Update the software profile version and set the status to Published.

Explanation:
When an administrator creates a new SQL Server software profile version to apply the latest cumulative update, they should update the software profile version and set the status to Published1. This makes the new profile version available to all users. NDB will show available updates for any database server using the software profile as soon as the new profile version is published1.

A user accidentally drops a table in the database at 10:42pm and the NDB administrator is tasked with restoring the table.
The snapshot schedule is set for every 30 minutes and the log catchup is set for every 15 minutes. The last available snapshot is at 10:30pm.
What is the optimal path to restore the table back with minimum data loss?


A. Restore the 10:42pm snapshot.


B. Restore using point in time till 10:41pm.


C. Restore using point in time till 10:42pm.


D. Restore the 10:30pm snapshot.





C.
  Restore using point in time till 10:42pm.

Explanation:
The optimal path to restore the table back with minimum data loss is to use the point in time restore feature of NDB, which allows the administrator to restore the database to a specific point in time based on the available snapshots and logs1. By restoring using point in time till 10:42pm, the administrator can recover the table just before it was dropped by the user, and minimize the data loss to the least possible amount1. The other options are not optimal, as they either involve restoring an older snapshot, which may result in more data loss, or restoring a non-existent snapshot, which is not possible.

An administrator needs to apply a minor version upgrade of the PostgreSQL software to an Era provisioned instance. Which step should the administrator take before applying the patch?


A. Create a new software profile.


B. Put the database instance into maintenance mode.


C. Go to the Software Profile Version widget and click update.


D. Migrate a new software profile.





A.
  Create a new software profile.

Explanation:
Nutanix Database Service (NDB) supports automated minor version upgrades for PostgreSQL1. Before applying the patch, the administrator should create a new software profile2. This is because the software profile contains the database engine binaries and other software required to run the database engine2. Therefore, to apply a minor version upgrade, a new software profile with the updated binaries needs to be created2. Once the new software profile is created, it can be used to patch the PostgreSQL database2.

What is used to temporarily store the transaction logs of the source database before they are copied to the log?


A. Database Agent


B. NDB Drive


C. Time Machine


D. NDB Profiles





A.
  Database Agent

The Database Agent is used to temporarily store the transaction logs of the source database before they are copied to the log. This is a critical component for ensuring data consistency and recovery in database operations.References: Nutanix Database Automation documentation, focusing on database agents and their roles in transaction log management.

Which statement best describes what happens when a 3rd-party backup tool is chosen to manage log backups for Microsoft SQL in NDB?


A. If exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will not be supported, but snapshot-based recovery of the databases is supported.


B. Third-party backups vendors can continue to backup the archived logs from the database log destination. NDB will still be able to capture the logs, considering the log catch-up begins before the logs get backed up


C. If exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will be supported, but snapshot-based recovery of the databases is not supported.


D. Third-party backups vendors can continue to backup the binary logs from the binary log location. NDB will still be able to capture the logs, considering the log catch-up begins before the logs get purged.





B.
  Third-party backups vendors can continue to backup the archived logs from the database log destination. NDB will still be able to capture the logs, considering the log catch-up begins before the logs get backed up

Explanation:
NDB supports two modes of log backup management for Microsoft SQL databases: NDB-managed and 3rdparty managed. In the NDB-managed mode, NDB takes full control of the log backups and stores them in the Cerebro log location. In the 3rd-party managed mode, NDB allows the use of external backup tools to backup the logs from the database log destination. However, NDB still needs to capture the logs for its own operations, such as point-in-time recovery, clone refresh, and log catch-up. Therefore, NDB will periodically scan the database log destination and copy the logs to the Cerebro log location. This process requires that the log catch-up begins before the logs get backed up by the 3rd-party tool, otherwise NDB will miss some logs and the operations will fail. If the 3rd-party tool grants exclusive access to the logs, then NDB will not be able to capture them at all, and the operations will not be supported.


Page 6 out of 25 Pages
Previous