NCP-DB-6.5 Nutanix Database Automation (NCP-DB) v6.5 Exam Dumps

dumps2024-10-05T10:05:10+08:00

NCP-DB-6.5 Nutanix Database Automation (NCP-DB) v6.5 exam information is here for your study. There are 75 multiple-choice questions, and you have 120 minutes to answer all the questions. The available language is English. The exam price is $199. We provide the latest Nutanix Database Automation (NCP-DB) v6.5 NCP-DB-6.5 exam dumps, which are the best material for you to study. Free Nutanix Certification NCP-DB-6.5 exam dumps are available below.

Page 1 of 5

1. For an NDB offline upgrade, which NDB CLI command should be used to upload the upgrade bundle?

upgrade upload_bundle path=path_to_upgrade_bundle upload bundle

path=path_to_upgrade_bundle upgrade bundle

path=path_to_upgrade_bundle

upload upgrade_bundle path=path_to_upgrade_bundle

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

Database Agent

NDB Drive

Time Machine

NDB Profiles

3. An administrator needs to patch an Oracle Database Server VM and must ensure Grid home is allocated sufficient storage space.

At a minimum, how much space must be available for Grid home prior to completing this task?

5GB

10GB

15GB

20 GB

4. An administrator needs to register a SQL Server Single Node Database Server VM with NDB.

Which condition must exist prior to the administrator completing this task?

Database files must exist in the Windows OS boot drive.

The login account provided must be a member of the sysadmin role.

The SQL service account should not have read privileges on the mount points.

SQL Server instance must be in single-user mode.

5. An administrator needs to restore a database provisioned on Storage Spaces. The virtual disks are shared with multiple databases.

Which restore method is supported?

Disk-based restore via NDB GUI

Disk-based restore via NDB CLI

Copy-based restore via NDB GUI

Copy-based restore via NDB CLI

6. What is required to create an NDB Software Profile Version for PostgreSQL?

Database server VM registered with NDB

Patch file for the installed databases

Installer package for database software

Preconfigured OS image from Prism Element

7. What is the minimum frequency in minutes configurable for NDB Log Catch-up operation?

120

8. Which ports are used by the NDB database agent for API calls?

443 and 9440

443 and 8080

3205 and 3260

5985 and 9389

9. 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

10. 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?

Page 2 of 5

11. 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.

12. 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

13. What does an NDB compute profile contain?

vCPUs, cores per vCPU, and the amount of memory for the database server V

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 V

14. An administrator enables NDB Multi-Cluster on Cluster A. 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

15. 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 ND

Open Prism Central and enable the NDB VM in the settings menu.

16. 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

17. 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.

18. An administrator needs to perform LCM upgrades on an AHV cluster registered with NDB. The cluster hosts NDB-provisioned database server VMs that are part of a database server cluster.

What should the administrator do to allow the DB Server VMs to stay available while the cluster is being upgraded?

Update Nutanix Cluster

Set VM-Host Affinity

Remove Nutanix Cluster

Unset VM-Host Affinity

19. The NDB user interface can display which language option?

Korean

Japanese

French

German

20. A database administrator wants to define initialization variables for different types of database engines and workloads, like OLTP and DW.

What type of profile would be used?

Software Profile Version

Network

Compute

Database Parameters

Page 3 of 5

21. An administrator needs to roll back an Oracle patch on a database server VM using NDB.

What is required for this action to be successful?

The patch must have been applied using ND

The database must be shut down.

The patch must have been applied on Grid home only using ND

The database must be in read-only mode.

22. Which ports must be open between the NDB server and Controller VMs to facilitate iSCSI connections?

22 and 9440

80 and 443

3205 and 3260

5985 and 5986

23. An administrator needs to distribute NDB management plane components.

Which NDB HA VM needs to be deployed on the same L2 network?

NDB Agent

API Server

Repository VMs

HA Proxy VMs

24. What step should be taken to make the profile available to all users:

Create an Access Control role with the Create Profile right and assign to all users.

Create an Access Control group with the desired users and grant it the Database Admin role.

Update the profile and set the status to Published.

Update the profile and set available state to All.

25. What is required to create an NDB Software Profile?

Installer package for database software

Database server VM registered with NDB

Patch file for the installed databases

OS image registered with Prism Element

26. An administrator needs to patch a PostgreSQL database server VM from version 13.4 to 13.8.

What is the first step within the NDB patching workflow to accomplish this task?

Create a new Software Profile with PostgreSQL 13.8.

Create a maintenance window and add this PostgreSQL server 13.8 to the queue.

Create a new Database Parameters profile for PostgreSQL server 13.8.

Create a Software Profile Version with PostgreSQL 13.8.

27. When preparing to provision multiple database server VMs, an administrator is tasked with configuring this set of VMs with the same number of cores per vCPU.

What is the easiest way for the administrator to accomplish this task?

Create a Compute Profile and apply it to the VMs during provisioning.

Update the VMs after provisioning and enter the changes to the vCPU cores.

After provisioning the VMs. update the DEFAULT_OOB_COMPUTE Profile.

Create a Windows Domain Profile that will synchronize the configurations.

28. An administrator needs to deploy a cumulative update (CU) for SQL Server.

What steps would the administrator take to prepare this deployment with NDB?

Apply the patch to the profile VM, delete the existing Software Profile and create a new Software Profile using the profile VM as the source.

Create a new Software Profile version using the CU executable and publish that version.

Apply the patch to the profile VM, then create a new Software Profile version using the profile VM as the source.

Create a new Software Profile using the CU executable and publish that profile.

29. 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?

Update the Removal schedule to the desired date.

Update the Removal schedule to the end of the month.

Remove the Removal schedule, then add the desired removal schedule.

Select Update and modify the Removal schedule.

30. Which policies define Time Machine data availability across multiple registered clusters in NDB?

Recovery Plans

Data Access Management

Data Protection

Service Level Agreements

Page 4 of 5

31. An administrator has configured NDB HA across multiple Nutanix clusters.

Which failure scenario will require manual interaction for the recovery?

More than one API Server VM is down.

One repository VM is down.

More than one HA proxy VM is down.

NDB Server process is down.

32. Which disk is omitted from a Software Profile?

System Page File

SQL Installation

User Database

System Database

33. Which response shows two ways to upgrade an NDB Server?

Out-of-Place Upgrade and In-place Upgrade

One-click Upgrade and In-place Upgrade Auto

Upgrade and Manual Upgrade

One-click Upgrade and Offline Upgrade

34. What is purpose of the NDB Database Agent service?

Temporarily stores the transaction logs.

Hosts one or more source databases for the same time machine.

Schedules and monitors the NDB-related operations.

Contains an instance of the database engine software.

35. An administrator needs to provide the least-privilege access to a newly-hired engineer whose task is to add new VLANs or IP Pools in NDB.

Which role should the administrator select to complete this task?

Database Administrator

Super Administrator

Database Infrastructure Administrator

Infrastructure Administrator

36. How can an administrator exclude Kernel patches for the Linux OS using the most efficient means?

Define a pre-script to disable the repositories in the Patch Now advanced options

Exclude the appropriate repositories on the VM prior to patching.

Exclude the appropriate repositories on the VM and reboot prior to patching.

Define a pre-script to disable the repositories in the Maintenance Window advanced options.

37. Within NDB, an administrator needs to register a PostgreSQL database server VM with a database.

Where should the database data and log files be located in order to successfully complete this task?

On a separate mount point

On the same mount point

On the same disk as the binary installation

On the same disk as the operating system

38. What is causing this issue?

The VLAN is DHCP

The VLAN is static

The VLAN is stretched

The VLAN is IPAM

39. An administrator is trying to register a database server VM with NDB.

Which file types will prevent the registration from being successful if located in the C: drive?

Page

System

Database

Backup

40. Which statement is true regarding the NDB alert retention feature?

NDB supports alert retention globally.

NDB supports retention at the individual policy.

NDB supports retention at the grouped policy.

NDB supports retention at the registered cluster.

Page 5 of 5

41. A request is received to refresh a database clone from a new manual snapshot. When the administrator attempts to create the new snapshot from the Time Machine, it is in a Frozen state.

What causes a Time Machine to enter the Frozen state and what are the administrator's options to complete the request?

Cause: The Time Machine enters a Frozen state when the database is de-registered without removing the Time Machine. Resolution: The Time Machine must be paused, then the database re-registered with a new Time Machine and a new clone created.

Cause: The Time Machine enters a Frozen state when the database is de-registered without removing the Time Machine. Resolution: To complete the request the database must be re-registered in NDB, create a new Time Machine and create a new clone.

Cause: The Time Machine enters a Frozen state after too many snapshot or log catchup failures. Resolution: Remediate the snapshot or log catchup failures, this thaws the Time Machine, allowing normal operations to continue and the request can be completed.

42. Refer to the exhibit.

An administrator attempts to provision their first clustered database environment with NDB. The operation fails with the Operation Error shown in the exhibit.

Which database engine was being deployed during this operation?

Oracle

MySQL

Microsoft SQL

PostgreSQL

43. Which two options can NDB leverage to refresh a database clone? (Choose two.)

Cerebro logs

Snapshots

Transaction logs

Templates

44. Which NDB feature collects logs and snapshots from databases?

Database Restore

Time Machine

SLA

One-click Patching

45. What happens to the primary member in a MongoDB Server Cluster during the NDB patching process?

It is patched last and is restored to its original state.

It becomes a read-only member during the patching process.

It is skipped during the patching process to ensure no downtime.

It is patched first and then becomes a secondary member.

46. Refer to the exhibit.

A request is received to provision a new Oracle SIHA DB & VM to test ASMLIB on OEL79 and Oracle 19c. When walking through the provisioning workflow, only ASMFD is available in the ASM Driver drop down.

What is necessary to provision the requested SIHA DB and DB VM with ASMLIB?

Update the software profile to include the ASMLIB driver.

Install ASMLIB on the NDB server.

Update the NDB driver config to enable ASMLIB for Oracle.

Install ASMLIB on the database server.

NCP-DB-6.5 Nutanix Database Automation (NCP-DB) v6.5 Exam Dumps

NCP-DB-6.5 Nutanix Database Automation (NCP-DB) v6.5 Exam Dumps

Share this post

Leave a Reply Cancel reply

Related Posts