Weekend Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: cramtreat

NCP-DB Nutanix Certified Professional - Database Automation (NCP-DB) Questions and Answers

Questions 4

What is causing this issue?

Options:

A.

The VLAN is DHCP

B.

The VLAN is static

C.

The VLAN is stretched

D.

The VLAN is IPAM

Buy Now
Questions 5

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?

Options:

A.

5

B.

10

C.

15

D.

30

Buy Now
Questions 6

Which two ports can be used by external applications to make API calls to Era? (Choose two.)

Options:

A.

9443

B.

443

C.

8443

D.

9440

Buy Now
Questions 7

An administrator needs to apply a minor version upgrade of the PostgreSQL software to an Era provisioned instance.

Which step should the administrator take before applying the patch?

Options:

A.

Create a new software profile.

B.

Put the database instance into maintenance mode.

C.

Go to the Software Profile Version widget and click update.

D.

Migrate a new software profile.

Buy Now
Questions 8

What feature of Era allows an administrator to create Time Machine policies in a Multi-Cluster configuration?

Options:

A.

Data Access Management

B.

Global Data Protection

C.

Time Machine Cloud Orchestration

D.

Global Service Level Agreement

Buy Now
Questions 9

Which action should be completed before updating Oracle Database software?

Options:

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.

Buy Now
Questions 10

An administrator has applied an Oracle security patch to a database server VM registered in Era.

How do you make this change available to other existing database instances?

Options:

A.

Register the VM as a have' database server VM and then create a software profile using this newly registered VIVI.

B.

Create a n.. software profile version from the patched VM.

C.

Merge the changes into an existing software profile.

D.

Create a new software profile in Era from the patched VM.

Buy Now
Questions 11

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?

Options:

A.

Use an SLA that supports Continuous Log retention.

B.

Update the TM schedule to perform DB Log catch up.

C.

Take a Manual snapshot and use it for DB recovery.

D.

Use Brass SLA & update the Log catch up frequency.

Buy Now
Questions 12

An administrator has configured NDB HA across multiple Nutanix clusters.

Which failure scenario will require manual interaction for the recovery?

Options:

A.

More than one API Server VM is down.

B.

One repository VM is down.

C.

More than one HA proxy VM is down.

D.

NDB Server process is down.

Buy Now
Questions 13

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?

Options:

A.

Page

B.

System

C.

Database

D.

Backup

Buy Now
Questions 14

An administrator selected Bronze SLA for Era Time Machine during database registration.

Which two capabilities are supported by the Time Machine for this database? (Choose two,)

Options:

A.

Provwonng

B.

Log Catch up

C.

Cloning

D.

Snapshots

Buy Now
Questions 15

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

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

Options:

A.

etcd

B.

keepa lived

C.

HAProxy

D.

Patroni

Buy Now
Questions 16

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

Options:

A.

PostgreSQL

B.

Oracle

C.

Microsoft SQL Server

D.

MongoDB

Buy Now
Questions 17

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

Options:

A.

To register multiple Nutanix clusters in NDB

B.

To perform snapshot operations on a single Nutanix cluster

C.

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

D.

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

Buy Now
Questions 18

Which statement is true regarding the NDB alert retention feature?

Options:

A.

NDB supports alert retention globally.

B.

NDB supports retention at the individual policy.

C.

NDB supports retention at the grouped policy.

D.

NDB supports retention at the registered cluster.

Buy Now
Questions 19

When performing a SQL Server Restore Source Database operation, what is a valid reason an administrator would choose the Restore

Location as New Location?

Options:

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.

Buy Now
Questions 20

What are two supported entities that metadata tags can be applied to? (Choose two.)

Options:

A.

Databases

B.

Snapshots

C.

Clones

D.

SLAs

Buy Now
Questions 21

Where would an administrator find the total space being used by all Era clones for a specific database?

Options:

A.

Under the Cloning widget on the Databases > Clones database summary page.

B.

Under the Capacity widget on the Database Server VMS > List database summary page.

C.

On the Era Dashboard Database Summary Table under Clones.

D.

On the Database > Overview dashboard.

Buy Now
Questions 22

Which two Oracle software components does Era patch? (Choose two.)

Options:

A.

Grid home

B.

Oracle home

C.

Application home

D.

user home

Buy Now
Questions 23

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

Which restore method is supported?

Options:

A.

Disk-based restore via NDB GUI

B.

Disk-based restore via NDB CLI

C.

Copy-based restore via NDB GUI

D.

Copy-based restore via NDB CLI

Buy Now
Questions 24

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

How should the administrator accomplish this task?

Options:

A.

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

B.

Apply the patch to all nodes at once.

C.

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

D.

Disable the replica set while patching.

Buy Now
Questions 25

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

Options:

A.

Min 2, Max 6

B.

Min 2, Max 4

C.

Min 1. Max 3

D.

Min 3, Max 5

Buy Now
Questions 26

An administrator has received a request to clone a source production database to an existing development server.

Which two actions must be taken to complete this task?

Options:

A.

The development server must be registered by Era in order to receive the clone.

B.

The development server must be registered by Era and authorized to host clones from the Time Machine.

C.

The development server must be authorized for the database Time Machine.

D.

The development server must have the IP and credentials provided during cloning.

Buy Now
Questions 27

A database admin logs into Era to manage an Oracle Database VM and sees a message Update Available on the Status of the Software Profile Version.

What should the database admin do?

Options:

A.

Manually update the software profile to the latest version

B.

Create and update to the latest software profile version

C.

Era autocratically updates the software profile to the latest version

D.

Schedule Ere to update the software profile to the latest version

Buy Now
Questions 28

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

Options:

A.

10

B.

15

C.

60

D.

120

Buy Now
Questions 29

An administrator wants to enable Multi-Cluster management on an Era installation.

Which prerequisites must be satisfied to complete this task?

Options:

A.

AOS version supported, static VLAN setup in Era Networks

B.

Database Server VMS version supported. Network Profiles setup

C.

Hardware version supported, DHCP Network enabled on Nutanix cluster

D.

Hypervisor version supported, port 9440 open between Era VM and clusters

Buy Now
Questions 30

What does an NDB compute profile contain?

Options:

A.

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

B.

Windows domain name (FQDN), domain user, and password.

C.

VLAN that the new database server VM will use.

D.

An image of the database and operating system generated from the registered database server VM.

Buy Now
Questions 31

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?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 32

Where are two locations an administrator would find the size of a Source Database? (Choose two.)

Options:

A.

On the Era Dashboard Database Summary Table under Source Database.

B.

Under the Capacity widget on the Database Server VMS > List database summary page.

C.

On the Databases > Sources table.

D.

On the Profiles > Database Parameters list for the assigned DB Parameter Profile.

Buy Now
Questions 33

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

Options:

A.

upgrade upload_bundle path=path_to_upgrade_bundle upload bundle

B.

path=path_to_upgrade_bundle upgrade bundle

C.

path=path_to_upgrade_bundle

D.

upload upgrade_bundle path=path_to_upgrade_bundle

Buy Now
Questions 34

While registering an Always on Availability Group database, an administrator selects the following option:

Multiple Databases as a Group with One Time Machine

Which statement is true regarding this chosen option?

Options:

A.

PITR-based SLAs are supported for database groups containing mixed Recovery Model.

B.

PITR-based SLAs are not supported for database groups containing mixed Recovery Model

C.

Point in Time Clones are not supported by Database Groups.

D.

PITR-based SLAs are not supported for database groups.

Buy Now
Questions 35

In an Oracle upgrade scenario using Era. if the source database is on a nor-Nutanix platform, is it possible to upgrade it with an Era

workflow?

Options:

A.

Yes, it is possible to upgrade database instance on a non-Nutanix platform.

B.

Yes, only if the nan-Nutanix platform is big-endian platform,

C.

No, the database instaru:e must be Era managed to Be upgraded

D.

Yes, only if the nori-Nutanix platform is little-endian platform.

Buy Now
Questions 36

An online retail application requires data to be synchronized between multiple SQL Server databases. This provides clearer reporting from

multiple databases at the Same time for consistency at the end of each business day.

What is the best way to fulfill this requirement?

Options:

A.

Have all the databases present in the same DBVM and register databases in Era.

B.

Have all the databases present in the same DBVM and register databases in Era with Multiple Databases as a Group with one Time Machine.

C.

Have all the databases present in the same DBVM and register databases in Era with One Database with One Time Machine.

D.

Have all the databases in the same Availability Group and register databases in Era.

Buy Now
Questions 37

A database administrator is tasked with creating a new clone of a running SQL database. During the clone process, there are no authorized servers are available.

What should the administrator do next?

Options:

A.

Register or provision a new authorized server VIVI.

B.

Click the Action icon to authorize one or more database server VMs.

C.

Register or provision a new database VIVI

D.

Click the Skip icon and choose to authorize later.

Buy Now
Questions 38

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

Options:

A.

Database Agent

B.

NDB Drive

C.

Time Machine

D.

NDB Profiles

Buy Now
Questions 39

Era allows custom metadata to be assigned to entities (clones, time machines, databases, and database servers) by using which component?

Options:

A.

Tags

B.

Notes

C.

Text

D.

Index

Buy Now
Questions 40

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?

Options:

A.

Windows Domain

B.

Network

C.

Database Parameter

D.

Software

Buy Now
Questions 41

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

Options:

A.

Update the database.

B.

Configure the repository.

C.

Configure database high availability.

D.

Update the software profile version.

Buy Now
Questions 42

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

Options:

A.

Enable multi-cluster in NDB.

B.

Disable multi-cluster in ND8.

C.

Register the required Nutanix clusters in ND8.

D.

Delete the TM data from the source database.

Buy Now
Questions 43

An administrator needs to provision a database for test purposes with a data protection policy that minimizes storage usage.

How should the administrator best complete this task?

Options:

A.

Disable the SLA for this database during provisioning.

B.

Create a SLA that only leverages zero-byte snapshots.

C.

Select the built-in NONE SLA that is configured for no snapshot or log backup.

D.

Create a custom SLA for this database that only retains 1 day of snapshots and bogs.

Buy Now
Exam Code: NCP-DB
Exam Name: Nutanix Certified Professional - Database Automation (NCP-DB)
Last Update: May 10, 2024
Questions: 146
NCP-DB pdf

NCP-DB PDF

$28  $80
NCP-DB Engine

NCP-DB Testing Engine

$33.25  $95
NCP-DB PDF + Engine

NCP-DB PDF + Testing Engine

$45.5  $130