Winter Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: geek65

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

Questions 4

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 5

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

Options:

A.

22 and 9440

B.

80 and 443

C.

3205 and 3260

D.

5985 and 5986

Buy Now
Questions 6

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?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 7

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?

Options:

A.

Create a new Software Profile with PostgreSQL 13.8.

B.

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

C.

Create a new Database Parameters profile for PostgreSQL server 13.8.

D.

Create a Software Profile Version with PostgreSQL 13.8.

Buy Now
Questions 8

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

Buy Now
Questions 9

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

Buy Now
Questions 10

An administrator needs to work with databases and time machines, but not database parameter profiles. Which role satisfies this requirement?

Options:

A.

Database Administrator (DBA)

B.

super Administrator

C.

Database Infrastructure Administrator

D.

Infrastructure Administrator

Buy Now
Questions 11

When registering a new Nutanix Cluster with Era, what component is installed on the target Nutanix cluster via the Register Nutanix Cluster workflow?

Options:

A.

Era Sewer

B.

Era Agent

C.

API Server

D.

Repository Server

Buy Now
Questions 12

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

Options:

A.

VLAN must be IPAM.

B.

VLAN must be static.

C.

Both clusters must be registered in NDB.

D.

Nutanix Cluster Management must be enabled.

Buy Now
Questions 13

An administrator needs to take multiple snapshots per day and retain them for one week. How should the administrator define and schedule the SLA?

Options:

A.

• Daily snapshot retention: 7 days

• Daily snapshot at: 2

B.

• Weekly snapshot retention: 1 week

• Daily Snapshot at: 2

C.

• Weekly snapshot retention: 1 week

• Snapshots per Day: 2

D.

• Daily snapshot retention: 7 days

• Snapshots per Day: 2

Buy Now
Questions 14

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?

Options:

A.

Software Profile Version

B.

Network

C.

Compute

D.

Database Parameters

Buy Now
Questions 15

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?

Options:

A.

Oracle

B.

MySQL

C.

Microsoft SQL

D.

PostgreSQL

Buy Now
Questions 16

Which disk is omitted from a Software Profile?

Options:

A.

System Page File

B.

SQL Installation

C.

User Database

D.

System Database

Buy Now
Questions 17

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

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.

Buy Now
Questions 20

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?

Options:

A.

extend_storage

B.

update

C.

database

D.

data_percent

Buy Now
Questions 21

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,

Buy Now
Questions 22

An administrator needs to protect a database with a Point In Time Recovery (PITR) SLA that provides a minimum of seven days of log

recovery.

What is the minimum Default SLA that meets this requirement?

Options:

A.

DEFAULT_008 GOLD SLA

B.

DEFAULT_008 BRONZE SLA

C.

DEFAULT_008 SILVER SLA

D.

DEFAULT_008 BRASS SLA

Buy Now
Questions 23

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

Buy Now
Questions 24

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

Options:

A.

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.

B.

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

C.

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.

D.

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.

Buy Now
Questions 25

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.

Buy Now
Questions 26

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.

Buy Now
Questions 27

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

Options:

A.

Point in time

B.

Restore point

C.

Backup

D.

Snapshot

Buy Now
Questions 28

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,

Buy Now
Questions 29

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 30

An administrator is tasked with auditing NDB SLAs. What data will the administrator be reviewing?

Options:

A.

Snapshot schedules

B.

Clone Management

C.

Data retention policies

D.

Recovery Time Objective

Buy Now
Questions 31

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?

Options:

A.

The patch must have been applied using NDB.

B.

The database must be shut down.

C.

The patch must have been applied on Grid home only using NDB.

D.

The database must be in read-only mode.

Buy Now
Questions 32

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 33

Which Era component collects logs and snapshots from the database?

Options:

A.

Profiles

B.

Era Database Agent

C.

SLAs

D.

Time Machine

Buy Now
Questions 34

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

Buy Now
Questions 35

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?

Options:

A.

5 GB

B.

10GB

C.

15GB

D.

20 GB

Buy Now
Questions 36

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

Buy Now
Questions 37

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?

Options:

A.

Database files must exist in the Windows OS boot drive.

B.

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

C.

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

D.

SQL Server instance must be in single-user mode.

Buy Now
Questions 38

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 39

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 40

Which two statements best describe the features and functionality of Era Oracle patching? (Choose two.)

Options:

A.

Era does not require native Oracle Utility OpatchAuto to create the patch profile,

B.

Era patching can be automated using REST API/CLI for scheduled patching many Oracle servers in a fleet patching scenario,

C.

Era patching for Oracle databases has automatic rollback if any of the steps in the patching workflow fails.

D.

Era Oracle fleet patching can be rolled back if issues ere encountered after successful patching.

Buy Now
Questions 41

What does the Era I-Click Provisioning service do?

Options:

A.

Cloning with security inserting pre and post masking scripts

B.

Customizable recovery SLAs for continuous RPOs

C.

Create space-efficient database snapshots

D.

Create space-efficient clones and zero-byte database clones

Buy Now
Questions 42

What is purpose of the NDB Database Agent service?

Options:

A.

Temporarily stores the transaction logs.

B.

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

C.

Schedules and monitors the NDB-related operations.

D.

Contains an instance of the database engine software.

Buy Now
Questions 43

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
Exam Code: NCP-DB
Exam Name: Nutanix Certified Professional - Database Automation (NCP-DB) v6.5
Last Update: Nov 21, 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