Nutanix NCP-DB Practice Test - Questions Answers, Page 2

List of questions
Question 11

Which ports are used by the NDB database agent for API calls?
443 and 9440
443 and 8080
3205 and 3260
5985 and 9389
The NDB database agent is a service that runs on each database server VM and communicates with the NDB instance. It uses port 443 for HTTPS API calls and port 9440 for Nutanix cluster API calls. These ports are required to be open on the database server VMs for NDB to function properly.Reference::Nutanix Database Management & Automation (NDMA), page 9;Ports and Protocols
Reference: Chart | Nutanix Community, section ''Nutanix Database Service (NDB)''
Question 12

How would an administrator enter the NDB command line to change the static IP address on the NDB VM?
era-server
era
cerebro_cli
arithmos cli
To change the static IP address on the NDB VM, an administrator would need to enter the NDB command line using thecerebro_clicommand. Thecerebro_clicommand is used to access the Cerebro service, which is responsible for managing the NDB instance and its components. Thecerebro_clicommand can be run from the NDB VM or from any other VM that has network connectivity to the NDB VM. Thecerebro_clicommand has various subcommands and options to perform different tasks, such as changing the IP address, hostname, password, or certificate of the NDB VM. To change the static IP address, the administrator would need to use thecerebro_cli network updatesubcommand with the appropriate parameters, such as the new IP address, netmask, gateway, and DNS servers. Thecerebro_cli network updatesubcommand also requires the administrator to provide the current password of the NDB VM for authentication. After changing the IP address, the administrator would need to restart the NDB VM for the changes to take effect.Reference::
Nutanix Certified Professional - Database Automation (NCP-DB) v6.5, Section 2 - Deploy and Configure an NDB Solution, Objective 2.2: Configure an NDB Instance
Nutanix Database Management & Automation (NDMA) Course, Module 3: Nutanix Database Service (NDB) Installation and Configuration, Lesson 3.2: Configuring NDB, Topic: Changing the IP Address of the NDB VM
Nutanix Database Service (NDB) Command Line Interface Guide, Chapter 2: Cerebro CLI, Section: cerebro_cli network update
Question 13

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?
5
10
15
30
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.Reference::Nutanix Database Management & Automation (NDMA), page 29;Nutanix Support & Insights, section ''Log Catch-up''
Question 14

While adding Time Machine data access to a Nutanix cluster, when is a storage container mapping needed
When the source database and NDB Server containers are different.
When the source database and NDB VM are on the same container.
When the source and destination database containers are different.
When the source database and NDB provisioning container are the same.
Time Machine data access is a feature of Nutanix Database Service (NDB) that allows you to access a point-in-time snapshot of a database without restoring it. To use this feature, you need to create a Data Access Management (DAM) policy that defines the access mode, the source database, the destination cluster, and the storage container mapping. The storage container mapping is needed when the source database and the NDB Server containers are different, because NDB needs to know where to store the metadata and the clone of the source database. If the source database and the NDB Server containers are the same, then NDB will use the same container for both the metadata and the clone.Reference::
Nutanix Certified Professional - Database Automation (NCP-DB), Section 5 - Protect NDB-managed Databases Using Time Machine
Database (NCP-DB) Exam Blueprint Guide - Nutanix, Page 9, Objective 5.6
Nutanix Database Management & Automation (NDMA) course, Module 4, Lesson 4.2 - Data Access Management
Question 15

An administrator needs to maintain five days of time-travel capability to any second, plus an additional seven days of discrete recovery at a daily interval.
How should the administrator define the Frequency and retention on the SLA?
* Continuous log retention (days): 7 * Daily snapshot retention (days): 5
* Continuous log retention (days): 5 * Weekly snapshot retention (weeks): 1
* Weekly snapshot retention (weeks): 1 * Continuous log retention (days): 7
* Daily snapshot retention (days): 7 * Continuous log retention (days): 5
The correct answer is D because it meets the requirements of maintaining five days of time-travel capability to any second and an additional seven days of discrete recovery at a daily interval. Continuous log retention allows the administrator to restore the database to any point in time within the specified number of days, while snapshot retention allows the administrator to restore the database to a specific point in time at a fixed interval. Therefore, by setting the daily snapshot retention to 7 days, the administrator can ensure that there is a discrete recovery point for each day of the week. By setting the continuous log retention to 5 days, the administrator can ensure that there is a time-travel capability to any second within the last five days. The other options do not meet the requirements because they either have less than five days of continuous log retention or less than seven days of snapshot retention.Reference::Nutanix Database Management & Automation (NDMA) course,Nutanix Certified Professional - Database Automation (NCP-DB) certification,Nutanix NCP-DB Certification Exam Syllabus and Study Guide,Nutanix Certified Professional - Database Automation (NCP-DB) datasheet
Question 16

What does an NDB compute profile contain?
vCPUs, cores per vCPU, and the amount of memory for the database server VM.
Windows domain name (FQDN), domain user, and password.
VLAN that the new database server VM will use.
An image of the database and operating system generated from the registered database server VM.
An NDB compute profile defines the CPU and memory resources for the database server VMs that are provisioned using NDB. It does not include any information about the network, domain, or software of the database server VMs. Those are specified in separate profiles, such as network profile, domain profile, and software profile.
Question 17

An administrator enables NDB Multi-Cluster on ClusterA. Cluster B is then registered with NDB. What are the different NDB Service VMs present in each Nutanix cluster?
Cluster A: 1 NDB Server Cluster B: 1 NDB Agent
Cluster A: 1 NDB Agent Cluster B: 1 NDB Server, 1 NDB Agent
Cluster A: 1 NDB Server, 1 NDB Agent Cluster B: 1 NDB Agent
Cluster A: 1 NDB Agent Cluster B: 1 NDB Server
NDB Multi-Cluster is a feature that allows multiple Nutanix clusters to share a common NDB service for database management and automation. NDB service consists of two components: NDB Server and NDB Agent. NDB Server is the central component that provides the web UI, REST API, and database orchestration logic. NDB Agent is the component that runs on each Nutanix cluster and communicates with the NDB Server to perform database operations.
When NDB Multi-Cluster is enabled on Cluster A, it becomes the primary cluster that hosts the NDB Server VM. Cluster B, which is registered with NDB, becomes a secondary cluster that hosts only the NDB Agent VM. Therefore, Cluster A has both NDB Server and NDB Agent, while Cluster B has only NDB Agent. This configuration allows Cluster B to leverage the NDB service running on Cluster A for database management and automation.
Nutanix Database Automation (NCP-DB) Course Details, Section 3.1: NDB Multi-Cluster Overview
Nutanix Database Automation (NCP-DB) Certification Details, Objective 3.1: Configure NDB Multi-Cluster
Nutanix Database Automation (NCP-DB) YouTube Playlist, Video 3.1: NDB Multi-Cluster Overview
Question 18

What is the first step to install NDB on a Nutanix AHV cluster?
NDB is offered as a SaaS service and doesn't require any installations.
Download the QCOW2 image file of NDB and upload it to Prism Element.
Run LCM update to get the latest version of NDB.
Open Prism Central and enable the NDB VM in the settings menu.
To install NDB on a Nutanix AHV cluster, you need to download the QCOW2 image file of NDB from the Nutanix Support Portal and upload it to Prism Element. This image file contains the NDB software and the CentOS operating system. After uploading the image, you need to create a VM from the image and configure the network settings. Then, you need to register the NDB VM with Prism Central and enable the NDB service in the settings menu.Reference::Nutanix Support & Insights,Professional Services: NDB Database Cloning
Question 19

An administrator needs to take multiple snapshots per day and retain them for one week. How should the administrator define and schedule the SLA?
* Daily snapshot retention: 7 days * Daily snapshot at: 2
* Weekly snapshot retention: 1 week * Daily Snapshot at: 2
* Weekly snapshot retention: 1 week * Snapshots per Day: 2
* Daily snapshot retention: 7 days * Snapshots per Day: 2
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.
Nutanix Database Management & Automation (NDMA) course, Module 4: Protecting Databases Using Time Machine, Lesson 4.1: Creating and Modifying SLA Retention Policies
Nutanix Certified Professional - Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section 5 - Protect NDB-managed Databases Using Time Machine
Nutanix Database Service (NDB) User Guide, Chapter 6: Protecting Databases Using Time Machine, Section 6.1: Creating and Modifying SLA Retention Policies
Question 20

A customer has NDB configured to create snapshots of their production databases every 4 hours.
A developer requires a copy of the current production data at 7:00am of each day.
What is the most efficient way to meet this requirement?
Authorize the developer in RBAC to create clones as required.
Run a script which creates a clone from the latest snapshot at 7:00am.
Configure Time Machine to create a clone from a daily snapshot at 7:00am.
Configure a done with a daily Data Refresh Schedule at 7:00am.
Time Machine is a feature of Nutanix Era that allows you to create and manage snapshots of your databases. You can use Time Machine to create clones from any snapshot, either manually or automatically. You can also configure Time Machine to create clones from snapshots based on a schedule, such as daily, weekly, or monthly. This way, you can ensure that your clones are always up to date with the latest data from your production databases. In this scenario, the most efficient way to meet the developer's requirement is to configure Time Machine to create a clone from a daily snapshot at 7:00am. This will save the developer's time and effort, as well as reduce the storage consumption by using the existing snapshots.Reference::
Nutanix Database Management & Automation Training Course
Nutanix Certified Professional - Database Automation datasheet
Nutanix Certified Professional - Database Automation (NCP-DB) 5 Exam
Question