Based on Official Syllabus Topics of Actual Nutanix NCP-DB Exam [Q21-Q43]

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

Point in time

Restore point

Backup

Snapshot

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

443 and 9440

443 and 8080

3205 and 3260

5985 and 9389

NO.23 An administrator has created a new SQL Server software profile version to apply the latest cumulative update.
What should the administrator do to make it available to all users?

Set the status of the existing software profile version to Unpublished.

Update the software profile version and set the status to Published.

Deprecate the existing software profile version and use the new one.

Select the software profile version with the update and optimization,

NO.24 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.

NO.25 An administrator is asked to refresh a database everyday at 9:30PM with data from as close to the refresh time as possible.
What is the best way achieve this requirement?

Schedule an SLA policy to perform snapshot everyday at 9PM.

Schedule an SLA policy that performs a snapshot at 99M and log catchup for every 15 min.

Schedule e log catchup everyday at 9:30PM.

Schedule an SLA policy to perform snapshot everyday at 9.30PM.

NO.26 A legal team wants to audit a quarter end (July 31st) banking transaction event and asks the administrator to create a SQL database from the timeframe.
What action should the administrator perform within Era?

Provision a database and attach the July 31st backup from Time Machine.

Restore a backup from July 31st, Recover the database to bring the database up.

Provision a database, restore the backup from Ju)’ 31st, and Recover the database to bring the database up.

Create a clone from July 31st snapshot in Time Machine.

NO.27 How does NDB send notifications when alerts are generated?

SNMP

APIs

Pulse

Email

NO.28 An administrator was asked to change the snapshot schedule for a given database. The administrator discovered that the time machine is in a paused state.
How should the administrator change the schedule?

Select the Time Machine; under Action select Update end define an appropriate schedule.

Clone the Time Machine and define an appropriate schedule for the clone.

Select Time Machine: Under actions Resume the Time Machine and then Update to define an appropriate schedule.

Clone the database and define an appropriate schedule for the clone.

NO.29 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,)

Provwonng

Log Catch up

Cloning

Snapshots

NO.30 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.

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

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

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

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

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

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

Era Sewer

Era Agent

API Server

Repository Server

NO.33 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

NO.34 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.

NO.35 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?

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

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

Merge the changes into an existing software profile.

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

NO.36 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.

NO.37 What is required to cre110ate a network profile in Era?

The network must contain static IP addresses.

The network must be added to Era.

The network must be managed by Era.

The network must provide IP address management.

NO.38 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

NO.39 What are two of the required steps to provision a new network in Clusters and extend it to Era? (Choose two.)

Add a new.’ subnet to the correct VPC.

Add the new subnet end VLAN in Network Configuration in PE.

Add the new VLAN in Ere Networks.

Add the new network in Era Multi-Clu5ter Management

NO.40 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.

NO.41 Which NDB feature collects logs and snapshots from databases?

Database Restore

Time Machine

SLA

One-click Patching

NO.42 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:
* SQLAGNIEMR
* SQLAGN2EMR
* SQLAGN3DW
SQLAGN3DW is running the Analytics service that needs real-time data.
How should the administrator register the database in Era?

Register the database as an Availability database.

Register the database as a Standalone database,

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

NO.43 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

Based on Official Syllabus Topics of Actual Nutanix NCP-DB Exam [Q21-Q43]

Leave a Reply Cancel reply

NCP-DB Practice Tests

Related Certifications

Recent Posts

Categories

Archives