Dumps4free
Discount Offer
Go Back on NCP-DB Exam
Available in 1, 3, 6 and 12 Months Free Updates Plans
PDF: $15 $60

Test Engine: $20 $80

PDF + Engine: $25 $99



Pass exam with Dumps4free or we will provide you with three additional months of access for FREE.

NCP-DB Practice Test

Whether you're a beginner or brushing up on skills, our NCP-DB practice exam is your key to success. Our comprehensive question bank covers all key topics, ensuring you’re fully prepared.


Page 2 out of 30 Pages

A developer requests a new development database environment. The Era administrator identifies that there are insufficient resources on the development cluster. Which two profiles should the administrator adjust to get the copy to fit within the resources available? (Choose two.)


A. Network


B. Software


C. Compute


D. Database Parameters





C.   Compute

D.   Database Parameters

Explanation: In the context of Nutanix Database Automation (NCP-DB), when there are insufficient resources on a development cluster, the administrator can adjust the Compute and Database Parameters profiles 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.

For which database engine does Era support rolling back a patch using CLI?


A. PostgreSQL


B. Oracle


C. Microsoft SQL Server


D. MongoDB





B.   Oracle

Explanation: Nutanix Era supports a variety of database engines, including Oracle, PostgreSQL, MySQL, and Microsoft SQL Server1. However, when it comes to rolling back a patch using the Command Line Interface (CLI), this feature is specifically supported for the Oracle database engine1. This allows for efficient validation of critical database updates and simplifies database rollback1. Please note that while Era does provide support for other database engines, the ability to rollback a patch using CLI is currently specific to Oracle1.

An administrator needs to create a custom PostgreSQL HA software profile. Which software component manages the state of the cluster and handles failover?


A. etcd


B. keepa lived


C. HAProxy


D. Patroni





D.   Patroni

Explanation:
NDB supports PostgreSQL HA software profiles for provisioning PostgreSQL databases with high availability. PostgreSQL HA software profiles consist of three components: etcd, HAProxy, and Patroni.
etcd is a distributed key-value store that provides a reliable way to store configuration data across a cluster of machines. etcd is used by Patroni to store and synchronize the cluster state and configuration.
HAProxy is a load balancer that distributes incoming requests to the PostgreSQL nodes. HAProxy is used to expose a single endpoint for database connections even as the roles of the individual nodes change.
Patroni is a template for PostgreSQL high availability. Patroni is responsible for managing the state of the cluster and handling failover. Patroni uses etcd as the distributed configuration store and relies on HAProxy for load balancing.
Therefore, the software component that manages the state of the cluster and handles failover is Patroni.

A developer with RBAC privileges in Era needs to refresh an existing DB Clone. What steps must the developer take to perform the refresh?


A. Navigate to Databases > Sources, Select the appropriate Database from the table and Refresh Clone from the Database Actions menu.


B. Navigate to Databases > Clones, Select the appropriate clone from the table, click Refresh, select the desired Point In Time or Snapshot and click Refresh


C. Navigate to Time Machines Select the appropriate Database Time Machine from the table end Refresh Clone from the Actions menu.


D. Navigate to Databases > Clones, Select the appropriate clone from the table, choose





B.   Navigate to Databases > Clones, Select the appropriate clone from the table, click Refresh, select the desired Point In Time or Snapshot and click Refresh

Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, to refresh an existing DB Clone, a developer with RBAC privileges in Era needs to navigate to Databases > Clones. From there, they select the appropriate clone from the table, click Refresh, select the desired Point In Time or Snapshot, and then click Refresh12. This process allows the developer to update the cloned database3.

An administrator would like to use Era for Copy Data Management operations on an Availability Group (AG) database. The AG database is hosted on replicas with different named instances, as shown below:
• SQLAGNI\EMR
• SQLAGN2\EMR
• SQLAGN3\DW
SQLAGN3\DW is running the Analytics service that needs real-time data.
How should the administrator register the database in Era?


A. Register the database as an Availability database.


B. Register the database as a Standalone database,


C. Register the SQLAGN3 from AG cluster and register the database as Availability database,





A.   Register the database as an Availability database.

According to the Nutanix Database Automation (NCP-DB) learning documents, when dealing with an Availability Group (AG) database, the database should be registered as an Availability database1. This is because the AG database is hosted on replicas with different named instances, and registering it as an Availability database allows for Copy Data Management operations to be performed across all instances. This is particularly important when services such as the Analytics service running on SQLAGN3\DW require realtime data1.


Page 2 out of 30 Pages
Previous