Exam4Training

Nutanix NCP-DB-6.5 Nutanix Certified Professional – Database Automation (NCP-DB) v6.5 Online Training

Question #1

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

  • 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

Reveal Solution Hide Solution

Correct Answer: D
D

Explanation:

For an offline upgrade of the Nutanix Database Automation (NDB), the correct command is ‘upload upgrade_bundle’ followed by the path where the upgrade bundle is located. This command initiates the process of uploading the upgrade bundle to the NDB system.

Reference: Nutanix Database Automation documentation, specifically the section on system upgrade procedures.

Question #2

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

  • A . Database Agent
  • B . NDB Drive
  • C . Time Machine
  • D . NDB Profiles

Reveal Solution Hide Solution

Correct Answer: B
Question #3

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?

  • A . 5GB
  • B . 10GB
  • C . 15GB
  • D . 20 GB

Reveal Solution Hide Solution

Correct Answer: C
Question #4

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?

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

Reveal Solution Hide Solution

Correct Answer: B
Question #5

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

Which restore method is supported?

  • 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

Reveal Solution Hide Solution

Correct Answer: C
Question #6

What is required to create an NDB Software Profile Version for PostgreSQL?

  • A . Database server VM registered with NDB
  • B . Patch file for the installed databases
  • C . Installer package for database software
  • D . Preconfigured OS image from Prism Element

Reveal Solution Hide Solution

Correct Answer: C
Question #7

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

  • A . 10
  • B . 15
  • C . 60
  • D . 120

Reveal Solution Hide Solution

Correct Answer: B
Question #8

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

  • A . 443 and 9440
  • B . 443 and 8080
  • C . 3205 and 3260
  • D . 5985 and 9389

Reveal Solution Hide Solution

Correct Answer: A
Question #9

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

  • A . era-server
  • B . era
  • C . cerebro_cli
  • D . arithmos cli

Reveal Solution Hide Solution

Correct Answer: A
Question #10

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?

  • A . 5
  • B . 10
  • C . 15
  • D . 30

Reveal Solution Hide Solution

Correct Answer: C

Question #11

While adding Time Machine data access to a Nutanix cluster, when is a storage container mapping needed

  • A . When the source database and NDB Server containers are different.
  • B . When the source database and NDB VM are on the same container.
  • C . When the source and destination database containers are different.
  • D . When the source database and NDB provisioning container are the same.

Reveal Solution Hide Solution

Correct Answer: D
Question #12

An administrator needs to maintain five days of time-travel capability to any second, plus an additional seven days of discrete recovery at a daily interval.

How should the administrator define the Frequency and retention on the SLA?

  • A . • Continuous log retention (days): 7
    • Daily snapshot retention (days): 5
  • B . • Continuous log retention (days): 5
    • Weekly snapshot retention (weeks): 1
  • C . • Weekly snapshot retention (weeks): 1
    • Continuous log retention (days): 7
  • D . • Daily snapshot retention (days): 7
    • Continuous log retention (days): 5

Reveal Solution Hide Solution

Correct Answer: D
Question #13

What does an NDB compute profile contain?

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

Reveal Solution Hide Solution

Correct Answer: A
Question #13

What does an NDB compute profile contain?

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

Reveal Solution Hide Solution

Correct Answer: A
Question #15

What is the first step to install NDB on a Nutanix AHV cluster?

  • A . NDB is offered as a SaaS service and doesn’t require any installations.
  • B . Download the QCOW2 image file of NDB and upload it to Prism Element.
  • C . Run LCM update to get the latest version of NDB.
  • D . Open Prism Central and enable the NDB VM in the settings menu.

Reveal Solution Hide Solution

Correct Answer: B
Question #16

An administrator needs to take multiple snapshots per day and retain them for one week.

How should the administrator define and schedule the SLA?

  • 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

Reveal Solution Hide Solution

Correct Answer: C
Question #17

A customer has NDB configured to create snapshots of their production databases every 4 hours.

A developer requires a copy of the current production data at 7:00am of each day.

What is the most efficient way to meet this requirement?

  • A . Authorize the developer in RBAC to create clones as required.
  • B . Run a script which creates a clone from the latest snapshot at 7:00am.
  • C . Configure Time Machine to create a clone from a daily snapshot at 7:00am.
  • D . Configure a done with a daily Data Refresh Schedule at 7:00am.

Reveal Solution Hide Solution

Correct Answer: A
Question #18

An administrator needs to perform LCM upgrades on an AHV cluster registered with NDB. The cluster hosts NDB-provisioned database server VMs that are part of a database server cluster.

What should the administrator do to allow the DB Server VMs to stay available while the cluster is being upgraded?

  • A . Update Nutanix Cluster
  • B . Set VM-Host Affinity
  • C . Remove Nutanix Cluster
  • D . Unset VM-Host Affinity

Reveal Solution Hide Solution

Correct Answer: D
Question #19

The NDB user interface can display which language option?

  • A . Korean
  • B . Japanese
  • C . French
  • D . German

Reveal Solution Hide Solution

Correct Answer: A
Question #20

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?

  • A . Software Profile Version
  • B . Network
  • C . Compute
  • D . Database Parameters

Reveal Solution Hide Solution

Correct Answer: D

Question #21

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?

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

Reveal Solution Hide Solution

Correct Answer: C
Question #22

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

  • A . 22 and 9440
  • B . 80 and 443
  • C . 3205 and 3260
  • D . 5985 and 5986

Reveal Solution Hide Solution

Correct Answer: C
Question #23

An administrator needs to distribute NDB management plane components.

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

  • A . NDB Agent
  • B . API Server
  • C . Repository VMs
  • D . HA Proxy VMs

Reveal Solution Hide Solution

Correct Answer: C
Question #24

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

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

Reveal Solution Hide Solution

Correct Answer: C
Question #25

What is required to create an NDB Software Profile?

  • 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

Reveal Solution Hide Solution

Correct Answer: B
Exit mobile version