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

Answer : B

In the context of Nutanix Database Automation (NCP-DB), a Super Admin has the authority to apply patch profiles. However, if a patch is marked as deprecated, even if it's published, it cannot be applied.This is because deprecation is a status that indicates the patch is outdated or has been superseded by a newer version, and thus should not be used1.This behavior ensures that only the most up-to-date and secure patches are applied to the system, maintaining the integrity and security of the database environment1.

Answer : B

Nutanix Era enables you to clone your source databases and refresh the database clones by using snapshots or transaction logs1.For an online retail application that requires data to be synchronized between multiple SQL Server databases, having all the databases present in the same Database Virtual Machine (DBVM) and registering them in Era with Multiple Databases as a Group with one Time Machine would be the most efficient way to fulfill this requirement1.This approach allows for clearer reporting from multiple databases at the same time for consistency at the end of each business day1.

Answer : C

Nutanix Era (NDB) utilizes DEFAULT_008 SLAs with varying frequencies for snapshots and log backups to achieve different recovery point objectives (RPOs). Here's how they compare:

DEFAULT_008 GOLD SLA:Typically has frequent log backups (e.g., every 15 minutes) and snapshots every few hours. This is designed for critical databases with very low RPOs.

DEFAULT_008 SILVER SLA:Offers a balance between protection and resource usage. Log backups might occur every hour with snapshots less frequently. This SLA is often suitable for databases requiring a good RPO without being overly resource-intensive.

DEFAULT_008 BRONZE SLA:Has less frequent log backups (e.g., every few hours) and less frequent snapshots. This is used for databases with less stringent RPO requirements.

DEFAULT_008 BRASS SLA:This has infrequent log backups and is usually considered the least protective SLA with the longest potential RPO

Reasoning:

Since the requirement is to have at least a 7-day log recovery period, any SLA with more frequent log backups than daily is excessive. The DEFAULT_008 SILVER SLA, with its hourly log backups, easily satisfies this requirement, offering the ability to restore to a point in time within the last hour of the past seven days.

Nutanix Era User Guide/SLA Management:https://portal.nutanix.com/page/documents/details?targetId=Nutanix-NDB-User-Guide-v2_5:top-sla-management-c.html]

Answer : A

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.

Answer : C, D

In the context of Nutanix Database Automation (NCP-DB), when there are insufficient resources on a development cluster, the administrator can adjust theComputeandDatabase Parametersprofiles to make the copy fit within the available resources1. The Compute profile includes settings related to CPU and memory resources, which can be adjusted to fit within the available resources.The Database Parameters profile includes settings that control the behavior and resource usage of the database, which can also be adjusted to optimize resource usage1.

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.

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.