Free Nutanix Certified Professional – Database Automation v6.5 Exam NCP-DB Exam Practice Test

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.

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 NDB.
• Update the Network Profile to include the new VLANs.
• Update Prism Element with the new VLAN and discover it in NDB.
• Create a new Network Profile with the new VLANs.

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

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

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?

• Register or provision a new authorized server VIVI.
• Click the Action icon to authorize one or more database server VMs.
• Register or provision a new database VIVI
• Click the Skip icon and choose to authorize later.

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.

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.

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.

A development team has requested that an administrator provide them a copy of the production Finance database. The business requires that any financial data is masked before going into development.How should the administrator create a clone with masked data for the development environment?

• From the Time Machine, create a clone and paste the masking commands in the post-clone field of the Pre-Post Commands section.
• 1. Create a masking script on the source DB VM, Dev VM or SW Profile VM.2. Create the clone from the Time Machine and define the post-clone option with the full path\name of the masking script.
• 1. Create a script to mask the data.2. Create the clone from the Time Machine and define the post-clone option with the full path\name of the masking script.
• From the Time Machine, create a clone and paste the masking commands in the pre-clone field of the Pre-Post Commands section.

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.