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

Nutanix NCP-DB Nutanix Certified Professional - Database Automation (NCP-DB) Exam Practice Test

Demo: 43 questions
Total 146 questions

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

Question 1

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

Options:

A.

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

B.

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

C.

Update the profile and set the status to Published.

D.

Update the profile and set available state to All.

Question 2

Which statement describes a user in Era with the Database Infrastructure Admin role?

Options:

A.

The user is able to manage software profiles, Network Profiles. database Instance parameter profiles and time machine SLA

B.

The user is able to manage software profiles, Network Profiles. database parameter profiles end Time Machine SLAs,

C.

The user is able to manage database profiles, Network Profiles, database Instance parameter profiles and time machine SLA

D.

The user is able to manage software profiles, database parameter profiles and SLAs

Question 3

How should an administrator create a database clone using the Era IJI?

Options:

A.

Select Databases, Clones, Create Clone.

B.

Select Databases, Sources, select a source database and then choose Create Clone.

C.

Select Time Machines, select e source database end then choose Create Clone.

D.

Select Database Server VMs, select a database server VM and then choose Create Clone.

Question 4

An administrator needs to change the maximum number of database connections during the cloning workflow.

Which Era profile should the administrator choose?

Options:

A.

Compute

B.

Database Parameters

C.

Network

Question 5

What is required to create an NDB Software Profile?

Options:

A.

Installer package for database software

B.

Database server VM registered with NDB

C.

Patch file for the installed databases

D.

OS image registered with Prism Element

Question 6

When provisioning a new database, which two options are available for the target? (Choose two.)

Options:

A.

Provision database to an existing registered

B.

Provision database to an existing container.

C.

Provision databases to e new container.

D.

Provision database to a new database sender\cluster.

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

Question 8

Which two network prerequisites are required to deploy an Era instance in production? (Choose two.)

Options:

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.

Question 9

How would an administrator enter the NDB command line to change the static IP address on the NDB VM?

Options:

A.

era-server

B.

era

C.

cerebro_cli

D.

arithmos cli

Question 10

A developer requests a new development database environment. The Era administrator identifies that there are insufficient resources on the

development cluster.

Which two profiles should the administrator adjust to get the copy to fit within the resources available? (Choose two.)

Options:

A.

Network

B.

Sofware

C.

Compute

D.

Database Parameters

Question 11

What two reference resources are available for Nutanix Era APIs? (Choose two.)

Options:

A.

Nutanix Support Portal

B.

Nutanix.dev API Reference

C.

Era API Explorer

D.

Era GitHub API Repository

Question 12

How should an administrator modify the Alert Severity level within Era?

Options:

A.

From the dropdown menu choose Alerts Policies. Choose the Policy to be modified and set the desired severity level.

B.

From the dropdown menu choose Alerts > List. Select the message to be changed end choose Set Status to Resolved or Set Status to Acknowledged.

C.

From the dropdown menu choose Alerts Policies. Chose the Poliq to be modified and chose either Set Enabled or Set Disabled,

D.

From the dropdown menu choose Alerts > Policies. Then choose Update next to Alert Retention,

Question 13

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?

Options:

A.

The administrator is logged in with the Super Admin account.

B.

An email address is required for the Super Admin account.

C.

The administrator is logged in with the Database Admin account.

D.

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

Question 14

What is required to cre110ate a network profile in Era?

Options:

A.

The network must contain static IP addresses.

B.

The network must be added to Era.

C.

The network must be managed by Era.

D.

The network must provide IP address management.

Question 15

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

Question 16

What is the most efficient way to get information on REST APIs for a task in Era?

Options:

A.

Log into Ere VM end run to list ell the REST APIs.

B.

Navigate to Swagger REST in Era GI-II.

C.

Navigate to and look for the desired

D.

use API equivalent button in a workflow.

Question 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

Question 18

An administrator needs to distribute NDB management plane components.

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

Options:

A.

NDB Agent

B.

API Server

C.

Repository VMs

D.

HA Proxy VMs

Question 19

An administrator would like to use Era for Copy Data Management operations on an Availability Group (AG) database. The AG database is hosted on replicas with different named instances, as shown below:

• SQLAGNI\EMR

• SQLAGN2\EMR

• SQLAGN3\DW

SQLAGN3\DW is running the Analytics service that needs real-time data.

How should the administrator register the database in Era?

Options:

A.

Register the database as an Availability database.

B.

Register the database as a Standalone database,

C.

Register the SQLAGN3 from AG cluster and register the database as Availability database,

Question 20

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

Question 21

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

Options:

A.

Grid home

B.

Oracle home

C.

Application home

D.

user home

Question 22

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.

Question 23

An administrator needs to provision a 3-node MSSQL Server AG with the following configuration:

• Two database server VMS including the primary replica on a local site

• A third database server VM on a remote site

How many IP addresses will the network at each site require?

Options:

A.

2 Cluster VIP and 1 listener IP on the local site

B.

1 Cluster VIP and 1 listener IP on the remote site

2 IPs in the local site and 1 on the remote site for the database server nodes

1 Cluster VIP on the local site

1 Cluster VIP and 1 Listener IP on the remote site

2 IPs in the local site and 1 on the remote site for the database server nodes

C.

I Cluster VIP end I Listener IP on the local site

1 Listener IP on the local site

2 IPs in the local site and I on the remote site for the database server nodes

D.

Cluster VIP end I Listener IP on the local site

1 Cluster VIP and 1 Listener IP on the remote site

2 IPs in the local site and 1 on the remote site for the database server nodes

Question 24

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.

Question 25

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

Question 26

Which two methods can be used to upgrade Era? (Choose two.)

Options:

A.

Nutanix LCM

B.

Offline Upgrade

C.

Rolling Upgrade

D.

One-click U pgrade

Question 27

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?

Options:

A.

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.

B.

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.

C.

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, this thaws the Time Machine and it resumes operation so the clone can be refreshed.

D.

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.

Question 28

An administrator needs to migrate a large 1/0-intensive database that doesn't support multi-disk layout.

How should the storage be provisioned with Era to support the database while optimizing performance?

Options:

A.

Volume Group

B.

Volume Group with Load Balancing

C.

Storage Spaces

D.

vDisk based provisioning

Question 29

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?

Options:

A.

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

B.

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

C.

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

D.

Select the snapshots & replicate them to each Nutanix cluster.

Question 30

How can HA drivers for a Database VM be upgraded?

Options:

A.

One-click software upgrade

B.

Database VM OS patching

C.

LCM driver upgrade

D.

Database software patching

Question 31

An administrator is trying to register a Nutanix cluster for Multi-Cluster provisioning.

The Era cluster is setup with following configuration:

• Era Multi-Cluster is enabled.

Era Server storage container and Era provisioning container are different on the Era cluster.

What should the administrator configure?

Options:

A.

Storage mapping between Era server container end remote container thet is used for provisioning DBs,

B.

Disks that span across Era Server storage container and Era provisioning container.

C.

Storage mapping between Era container and a remote container that is not used for provisioning databases.

D.

Separate remote containers for provisioning Era Agent VM end database Server VMs.

Question 32

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.

Question 33

How does NDB send notifications when alerts are generated?

Options:

A.

SNMP

B.

APIs

C.

Pulse

D.

Email

Question 34

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

Question 35

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

Options:

A.

443 and 9440

B.

443 and 8080

C.

3205 and 3260

D.

5985 and 9389

Question 36

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

Question 37

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?

Options:

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.

Question 38

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

Options:

A.

Recovery Plans

B.

Data Access Management

C.

Data Protection

D.

Service Level Agreements

Question 39

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?

Options:

A.

Update the software profile to include the ASMLIB driver.

B.

Install ASMLIB on the NDB server.

C.

Update the NDB driver config to enable ASMLIB for Oracle.

D.

Install ASMLIB on the database server.

Question 40

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

Options:

A.

Databases

B.

Snapshots

C.

Clones

D.

SLAs

Question 41

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?

Options:

A.

Copies the specific database files to the source volume

B.

Replaces source volume with specific db disks

C.

Replaces the source volume with the snapshot volume

D.

Copies all database files to the source volume

Question 42

Which default roles are available within Era for Role-Based Access Control?

Options:

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

Question 43

How can Era be config90ured to send alert notifications to email recipients?

Options:

A.

From Administration select Era Service then go to Era service name and setup email notification,

B.

From Administration, select access control then add a user end setup email notification.

C.

From Administration, select Ere Service then go to configure notification widget and then click update to update SMTP server configuration

D.

From Administration select access control, select SMTP and then click update to update SMTP sewer configuration.

Demo: 43 questions
Total 146 questions