NCP-DB-6.10 Nutanix Certified Professional - Database Automation (NCP-DB) v6.10 Exam Free Dumps - Free Latest Dumps for IT Certification Exams

NCP-DB-6.10 Nutanix Certified Professional – Database Automation (NCP-DB) v6.10 Exam Free Dumps

dumps2025-06-17T09:32:47+08:00

To earn Nutanix Certified Professional – Database Automation (NCP-DB) certification, you need to take and pass NCP-DB-6.10 exam. There are 75 multiple-choice questions in real Nutanix NCP-DB-6.10 exam, 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 Certified Professional NCP-DB-6.10 exam dumps, which can help you pass the test easily. Free Nutanix Certified Professional – Database Automation (NCP-DB) v6.10 NCP-DB-6.10 exam dumps are available below.

Page 1 of 8

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 8

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?

A. Cluster A: 1 NDB Server

Cluster B: 1 NDB Agent

B. Cluster A: 1 NDB Agent

Cluster B: 1 NDB Server, 1 NDB Agent

C. Cluster A: 1 NDB Server, 1 NDB Agent

Cluster B: 1 NDB Agent

D. 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 8

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 8

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 8

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.

47. Refer to the exhibit.

An administrator, whose accounts are shown in the exhibit, is trying to add a new database admin as a local user to NDB, but is unable to complete the task.

What is most likely the cause of the issue?

The administrator is logged in with the Super Admin account.

An email address is required for the Super Admin account.

The administrator is logged in with the Database Admin account.

Only users in the domain admins group can create local users.

48. What are two status values that can be set within the Alerts Dashboard? (Choose two.)

Auto

Resolved

Data Resiliency

Acknowledged

49. What is the purpose of Data Access Management policies in NDB Multi-Cluster?

To register multiple Nutanix clusters in NDB

To perform snapshot operations on a single Nutanix cluster

To manage time machine data availability across all registered Nutanix clusters in NDB

To remove data accessibility of a time machine across all registered Nutanix clusters in NDB

50. How does NDB send notifications when alerts are generated?

SNMP

APIs

Pulse

Page 6 of 8

51. An administrator is tasked with auditing NDB SLAs.

What data will the administrator be reviewing?

Snapshot schedules

Clone Management

Data retention policies

Recovery Time Objective

52. Create the clone from the Time Machine and define the post-clone option with the full pathname of the masking script.

D. From the Time Machine, create a clone and paste the masking commands in the pre-clone field of the Pre-Post Commands section.

53. Which statement best describes what happens when a 3rd-party backup tool is chosen to manage log backups for Microsoft SQL in NDB?

If exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will not be supported, but snapshot-based recovery of the databases is supported.

Third-party backups vendors can continue to backup the archived logs from the database log destination. NDB will still be able to capture the logs, considering the log catch-up begins before the logs get backed up

If exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will be supported, but snapshot-based recovery of the databases is not supported.

Third-party backups vendors can continue to backup the binary logs from the binary log location. NDB will still be able to capture the logs, considering the log catch-up begins before the logs get purged.

54. An administrator needs to restore a source database from a snapshot. The database shares the source volume with multiple other databases.

How does NDB handle this database restore operation?

Copies the specific database files to the source volume

Replaces source volume with specific db disks

Replaces the source volume with the snapshot volume

Copies all database files to the source volume

55. When trying to restore a database via Time Machine (TM), the option to restore data to a Point in Time is not available.

What should the administrator do to enable Point in Time Recovery?

Use an SLA that supports Continuous Log retention.

Update the TM schedule to perform DB Log catch up.

Take a Manual snapshot and use it for DB recovery.

Use Brass SLA & update the Log catch up frequency.

56. Which two encryption methods can be used when configuring an SMTP server? (Choose two.)

TLS

SSL

S/MIME

IPsec

57. An administrator needs to increase storage for a MongoDB database provisioned using NDB. After launching the NDB CLI, the administrator begins with creating the input file for this operation.

Which parameter should the administrator include within the input file?

extend_storage

update

database

data_percent

58. An administrator is tasked with providing a Jr DBA with access to NBD with limited capabilities.

This user should only be able to:

• Provision Databases

• Provision Database Servers

• Create Ones

• Refresh Clones

• Patch Database Servers

How can the administrator complete this task?

Clone the Database Admin role, and add the desired privileges.

Create a role with only those privileges, assign the role to the Jr DBA user.

Create a user for the Jr DBA, and assign only those privileges.

Clone the Database Admin role, and remove all but the desired privileges.

59. How can HA drivers for a Database VM be upgraded?

One-click software upgrade

Database VM OS patching

LCM driver upgrade

Database software patching

60. An administrator needs to perform patching on a MongoDB server cluster within an NDB environment.

How should the administrator accomplish this task?

Perform a rolling upgrade, applying the patch to the primary member first, followed by the secondary members.

Apply the patch to all nodes at once.

Perform a rolling upgrade, applying the patch to the secondary members first, followed by the primary member.

Disable the replica set while patching.

Page 7 of 8

61. When provisioning an PostgreSQL HA Instance, what are the minimum and maximum number of DB server VMs that can be deployed in a cluster?

Min 2, Max 6

Min 2, Max 4

Min 1. Max 3

Min 3, Max 5

62. Refer to the exhibit.

An administrator is receiving critical NDB email alerts regarding storage for the DBA database, which is a member of a database group.

How would the administrator remediate the issue within NDB?

From the Database Summary page for the DBA database, use the Scale option to grow the storage accordingly.

From the Databases page, select the Database group and Scale the storage from the Database Actions menu.

From Prism Central, add additional storage to the VM, then expand the log storage via the database tools.

From the Alerts page, select the alert, choose Set Status to Resolved, and Scale the storage via the Resolve Now dialogue box.

63. Which action should be completed before updating Oracle Database software?

Verify CVMs have the required memory allocated.

Perform rolling reboots of the Oracle Database VMs.

Verify the Oracle OS version is supported on AH

Download the PSU from Oracle support.

64. An administrator has been tasked with restoring an Oracle database that has recently failed. The administrator must restore the database to the prior day's state.

Which two restore options could be used? (Choose two.)

Most Recent Time Available

Snapshot

Tail Logs Backup

Point in Time

65. What does a Time Machine frozen status indicate?

The database is paused on the database V

The database was de-registered from NDB without removing the associated time machine.

The NDB agent is stopped on the database V

The Time Machine is paused and all automatic snapshot and log catch-up activities are halted.

66. An administrator needs to create a custom PostgreSQL HA software profile.

Which software component manages the state of the cluster and handles failover?

etcd

keepa lived

HAProxy

Patroni

67. What must be completed within NDB before patching a Linux OS?

Update the database.

Configure the repository.

Configure database high availability.

Update the software profile version.

68. In NDB, which two Time Machine options are available when creating a database clone? (Choose two.)

Point in time

Restore point

Backup

Snapshot

69. What is the first step to add Time Machine (TM) data access to a Nutanix cluster?

Enable multi-cluster in ND

Disable multi-cluster in ND8.

Delete the TM data from the source database.

70. An administrator is adding a stretched VLAN in NDB.

Which VLAN type(s) will satisfy this task?

Only VLANs that are not managed in NDB

Only static VLANs that are managed in NDB

Only dynamic VLANs

Both static and dynamic VLANs

Page 8 of 8

71. An administrator needs to add a stretched VLAN across two clusters in NDB

Which two prerequisites should be met prior to completing this action? (Choose two.)

VLAN must be IPA

VLAN must be static.

Both clusters must be registered in ND

Nutanix Cluster Management must be enabled.

72. A user accidentally drops a table in the database at 10:42pm and the NDB administrator is tasked with restoring the table.

The snapshot schedule is set for every 30 minutes and the log catchup is set for every 15 minutes.

The last available snapshot is at 10:30pm.

What is the optimal path to restore the table back with minimum data loss?

Restore the 10:42pm snapshot.

Restore using point in time till 10:41pm.

Restore using point in time till 10:42pm.

Restore the 10:30pm snapshot.

73. An administrator needs to make new VLANs available when provisioning a Oracle cluster database, which have been added to NDB via the Administration menu.

What needs to be done to expose the new VLANs for provisioning?

Create a new VLAN in Prism Element and discover it in ND

Update the Network Profile to include the new VLANs.

Update Prism Element with the new VLAN and discover it in ND

Create a new Network Profile with the new VLANs.

74. An administrator is interested in using profiles to simplify the database provisioning process. The profile needs to include information related to the SQL service startup account, and the NDB worker service account.

Which profile would help the administrator accomplish this task?

Windows Domain

Network

Database Parameter

Software

75. An administrator would like to replicate database snapshots to remote Nutanix clusters.

What should the administrator do to manage Time Machine data availability across all registered Nutanix clusters in NDB?

Add Data Access to each Nutanix cluster and assign a DAM policy.

Update the cluster's Data Access & select the remote cluster.

Update the SLA on the Time Machine & schedule the remote replication.

Select the snapshots & replicate them to each Nutanix cluster.

76. Why are ports 3205 and 3260 important when working with Era?

These ports facilitate SMB connections

These ports facilitate iSCSI connections

These ports facilitate NFS connections

These ports facilitate CIFS connections

77. What is the terminology used for registering an existing database with Era?

Greenfield Database

Brownfield Database

Cloned Database

Source Database

NCP-DB-6.10 Nutanix Certified Professional – Database Automation (NCP-DB) v6.10 Exam Free Dumps

NCP-DB-6.10 Nutanix Certified Professional – Database Automation (NCP-DB) v6.10 Exam Free Dumps

Share this post

Related Posts