When provisioning an PostgreSQL HA Instance, what are the minimum and maximum number of DB server VMs that can be deployed in a cluster?
A. Min 2, Max 6
B. Min 2, Max 4
C. Min 1. Max 3
D. Min 3, Max 5
Explanation:
When provisioning a PostgreSQL HA Instance using NDB, the minimum and maximum number of DB server
VMs that can be deployed in a cluster are 2 and 4, respectively. A PostgreSQL HA Instance is a database
instance that provides high availability and fault tolerance for PostgreSQL databases using the Patroni
framework. Patroni is a Python-based tool that manages PostgreSQL configuration and performs automatic
failover and switchover operations. Patroni relies on a distributed consensus store, such as etcd, Consul, or
ZooKeeper, to store and synchronize the cluster state and leader information. NDB supports etcd as the
consensus store for PostgreSQL HA Instances. NDB allows the administrator to provision PostgreSQL HA
Instances with different sizes and configurations, such as small, medium, large, or custom. The size of the
PostgreSQL HA Instance determines the number of DB server VMs, the number of etcd nodes, the CPU,
memory, and disk resources, and the replication factor of the database. The minimum number of DB server
VMs for a PostgreSQL HA Instance is 2, which corresponds to a small size instance. This configuration
provides one leader and one follower DB server VM, and one etcd node. The maximum number of DB server
VMs for a PostgreSQL HA Instance is 4, which corresponds to a large size instance. This configuration
provides one leader and three follower DB server VMs, and three etcd nodes. The other options are not valid
for a PostgreSQL HA Instance, as they either do not provide enough redundancy or exceed the supported limit
of DB server VMs.
When performing a SQL Server Restore Source Database operation, what is a valid reason an administrator would choose the Restore Location as New Location?
A. The log files are needed to petform the point in time restore.
B. The administrator wants to restore to a new location and have Era apply Nutanix best practices.
C. The administrator wants to keep the original schema in place.
D. The database files are on a disk with other database files and the administrator wants to get the database restored as quickly as possible.
Explanation:
When performing a SQL Server Restore Source Database operation in Nutanix Database Automation (NCPDB),
an administrator might choose the Restore Location as New Location if they want to restore to a new
location and have Era apply Nutanix best practices1. This is because Nutanix Era automates and simplifies
database management, allowing the administrator to manage databases at scale, and it applies Nutanix best
practices during the restore process1. This ensures optimal performance and reliability of the restored
database1.
Which action should be completed before updating Oracle Database software?
A. Verify CVMs have the required memory allocated.
B. Perform rolling reboots of the Oracle Database VMs.
C. Verify the Oracle OS version is supported on AHV.
D. Download the PSU from Oracle support.
Explanation:
Before updating Oracle Database software, you need to download the Patch Set Update (PSU) from Oracle
support. A PSU is a collection of critical and security patches for Oracle products. You need to have a valid
Oracle account and access to the My Oracle Support portal to download the PSU. You also need to check the
compatibility and prerequisites of the PSU before applying it to your Oracle Database software. NDB uses outof-
place patching for Oracle, which means you need to create a new software profile version with the patched
Oracle software and use it to update your existing databases.
An administrator created a database clone that is scheduled for removal on the last day of the month. A request has been received to keep the clone for an additional 14 days. After selecting the desired clone, how should the administrator satisfy this task?
A. Update the Removal schedule to the desired date.
B. Update the Removal schedule to the end of the month.
C. Remove the Removal schedule, then add the desired removal schedule.
D. Select Update and modify the Removal schedule.
Explanation:
The Removal schedule is a feature of Nutanix Era that allows you to specify when a database clone will be
automatically deleted. You can modify the Removal schedule of an existing clone by selecting the clone from
the Clones page, clicking on the Update button, and changing the Removal schedule option to the desired
date. This way, you can extend or shorten the lifespan of a clone as per your requirements. You do not need to
remove the existing Removal schedule and add a new one, as this would be an unnecessary step. You also do
not need to update the Removal schedule to the end of the month, as this would not meet the request of
keeping the clone for an additional 14 days.
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
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:
How can an administrator exclude Kernel patches for the Linux OS using the most efficient means?
A. Define a pre-script to disable the repositories in the Patch Now advanced options
B. Exclude the appropriate repositories on the VM prior to patching.
C. Exclude the appropriate repositories on the VM and reboot prior to patching.
D. Define a pre-script to disable the repositories in the Maintenance Window advanced options.
Explanation:
NDB supports Linux OS patching for database server VMs. Linux OS patching is performed by using the
yum or apt package managers, depending on the Linux distribution. To exclude Kernel patches for the Linux
OS, the administrator can disable or exclude the appropriate repositories on the VM prior to patching. This
can be done by editing the yum.conf or apt.conf files, or by using the --disablerepo or --exclude options in the
yum or apt commands. This way, the administrator can control which patches are applied to the VM without
affecting other VMs or requiring additional scripts or reboots.
Which two network prerequisites are required to deploy an Era instance in production? (Choose two.)
A. NTP, DNS servers, gateway, and subnet mask must be available and visible to Ere,
B. One static IP address must be available and changed using CLI after VM deployment.
C. A storage container must be available es a prerequisite.
D. An SMTP server and details must be provided for notifications.
Option A: Nutanix Era requires network prerequisites like NTP, DNS servers, gateway, and subnet
mask to be available and visible. These are essential for the proper functioning of the Era instance1.
Option B: One static IP address must be available and can be changed using CLI after VM
deployment. This is necessary for the Era VM to communicate with other components in the network1.
Option C: While a storage container is necessary for Nutanix infrastructure, it is not a network
prerequisite specifically for deploying an Era instance.
Option D: An SMTP server and details are typically used for sending notifications, but they are not a
network prerequisite for deploying an Era instance. They are more related to the operational aspect post deployment.
Which two Oracle software components does Era patch? (Choose two.)
A. Grid home
B. Oracle home
C. Application home
D. user home
Explanation:
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:
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
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.
Within the NDB GUI, an administrator needs to set the shortest schedule interval possible for a database log catch up. Which value, in minutes, will satisfy this requirement?
A. 5
B. 10
C. 15
D. 30
Explanation:
The NDB GUI allows an administrator to set the schedule interval for a database log catch up, which is the
process of collecting transaction logs periodically from the source databases and storing them in the time
machine. The shortest possible value for this interval is 15 minutes, as per the NDB documentation1. This
means that the NDB time machine will capture the database logs every 15 minutes and use them for backup,
restore, clone, and refresh operations.
References: Nutanix Database Management & Automation (NDMA),
page 29; Nutanix Support & Insights, section “Log Catch-up”
An administrator needs to take multiple snapshots per day and retain them for one week. How should the administrator define and schedule the SLA?
A. • Daily snapshot retention: 7 days
• Daily snapshot at: 2
B. • Weekly snapshot retention: 1 week
• Daily Snapshot at: 2
C. • Weekly snapshot retention: 1 week
• Snapshots per Day: 2
D. • Daily snapshot retention: 7 days
• Snapshots per Day: 2
Explanation:
The correct answer is D because it matches the requirement of taking multiple snapshots per day and
retaining them for one week. Option A is incorrect because it only takes one snapshot per day, which is not
enough for the administrator’s need. Option B is incorrect because it only retains the snapshots for one week,
which means the older snapshots will be deleted after seven days. Option C is incorrect because it only takes
two snapshots per week, which is not frequent enough for the administrator’s need.
What are two supported entities that metadata tags can be applied to? (Choose two.)
A. Databases
B. Snapshots
C. Clones
D. SLAs
Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, metadata tags can be applied
to various entities in Nutanix Era for better database inventory management1. Among the options provided,
Databases and Clones are two entities that support metadata tags1. These tags can be used to categorize,
search, and manage these entities more effectively1. Please note that the information might be available in the
Nutanix Database Automation (NCP-DB) course materials or in the Nutanix Era documentation.
Page 3 out of 13 Pages |
Previous |