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?

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.

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.

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

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

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.

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

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.

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.

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

upload upgrade_bundle path=path_to_upgrade_bundle

upgrade upload_bundle path=path_to_upgrade_bundle upload bundle

path=path_to_upgrade_bundle upgrade bundle

upload upgrade_bundle path=path_to_upgrade_bundle

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?

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

Database files must exist in the Windows OS boot drive.

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

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

SQL Server instance must be in single-user mode.

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

Installer package for database software

Database server VM registered with NDB

Patch file for the installed databases

Installer package for database software

Preconfigured OS image from Prism Element

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

When the source database and NDB Server containers are different.

When the source database and NDB VM are on the same container.

When the source and destination database containers are different.

When the source database and NDB provisioning container are the same.

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?

* Daily snapshot retention (days): 7 * Continuous log retention (days): 5

* Continuous log retention (days): 7 * Daily snapshot retention (days): 5

* Continuous log retention (days): 5 * Weekly snapshot retention (weeks): 1

* Weekly snapshot retention (weeks): 1 * Continuous log retention (days): 7

* Daily snapshot retention (days): 7 * Continuous log retention (days): 5

What does an NDB compute profile contain?

vCPUs, cores per vCPU, and the amount of memory for the database server VM.

Windows domain name (FQDN), domain user, and password.

VLAN that the new database server VM will use.

An image of the database and operating system generated from the registered database server VM.

An administrator enables NDB Multi-Cluster on ClusterA. Cluster B is then registered with NDB. What are the different NDB Service VMs present in each Nutanix cluster?

Cluster A: 1 NDB Server, 1 NDB Agent Cluster B: 1 NDB Agent

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

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

Download the QCOW2 image file of NDB and upload it to Prism Element.

NDB is offered as a SaaS service and doesn't require any installations.

Download the QCOW2 image file of NDB and upload it to Prism Element.

Run LCM update to get the latest version of NDB.

Open Prism Central and enable the NDB VM in the settings menu.

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

* Daily snapshot retention: 7 days * Snapshots per Day: 2

* Daily snapshot retention: 7 days * Daily snapshot at: 2

* Weekly snapshot retention: 1 week * Daily Snapshot at: 2

* Weekly snapshot retention: 1 week * Snapshots per Day: 2

* Daily snapshot retention: 7 days * Snapshots per Day: 2

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?

Configure Time Machine to create a clone from a daily snapshot at 7:00am.

Authorize the developer in RBAC to create clones as required.

Run a script which creates a clone from the latest snapshot at 7:00am.

Configure Time Machine to create a clone from a daily snapshot at 7:00am.

Configure a done with a daily Data Refresh Schedule at 7:00am.

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?

The patch must have been applied using NDB.

The database must be shut down.

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

The database must be in read-only mode.

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

Update the profile and set available state to All.

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.

What is required to create an NDB Software Profile?

Installer package for database software

Database server VM registered with NDB

Patch file for the installed databases

OS image registered with Prism Element

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?

Create a Software Profile Version with PostgreSQL 13.8.

Create a new Software Profile with PostgreSQL 13.8.

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

Create a new Database Parameters profile for PostgreSQL server 13.8.

Create a Software Profile Version with PostgreSQL 13.8.

When preparing to provision multiple database server VMs, an administrator is tasked with configuring this set of VMs with the same number of cores per vCPU.What is the easiest way for the administrator to accomplish this task?

Create a Compute Profile and apply it to the VMs during provisioning.

Update the VMs after provisioning and enter the changes to the vCPU cores.

After provisioning the VMs. update the DEFAULT_OOB_COMPUTE Profile.

Create a Windows Domain Profile that will synchronize the configurations.

An administrator needs to deploy a cumulative update (CU) for SQL Server.What steps would the administrator take to prepare this deployment with NDB?

Apply the patch to the profile VM, then create a new Software Profile version using the profile VM as the source.

Apply the patch to the profile VM, delete the existing Software Profile and create a new Software Profile using the profile VM as the source.

Create a new Software Profile version using the CU executable and publish that version.

Apply the patch to the profile VM, then create a new Software Profile version using the profile VM as the source.

Create a new Software Profile using the CU executable and publish that profile.

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?

Select Update and modify the Removal schedule.

Update the Removal schedule to the desired date.

Update the Removal schedule to the end of the month.

Remove the Removal schedule, then add the desired removal schedule.

Select Update and modify the Removal schedule.

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.

More than one HA proxy VM is down.

Which response shows two ways to upgrade an NDB Server?

One-click Upgrade and Offline Upgrade

Out-of-Place Upgrade and In-place Upgrade

One-click Upgrade and In-place Upgrade Auto

One-click Upgrade and Offline Upgrade

What is purpose of the NDB Database Agent service?

Schedules and monitors the NDB-related operations.

Temporarily stores the transaction logs.

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

Schedules and monitors the NDB-related operations.

Contains an instance of the database engine software.

An administrator needs to provide the least-privilege access to a newly-hired engineer whose task is to add new VLANs or IP Pools in NDB.Which role should the administrator select to complete this task?

Database Infrastructure Administrator

How can an administrator exclude Kernel patches for the Linux OS using the most efficient means?

Exclude the appropriate repositories on the VM prior to patching.

Define a pre-script to disable the repositories in the Patch Now advanced options

Exclude the appropriate repositories on the VM prior to patching.

Exclude the appropriate repositories on the VM and reboot prior to patching.

Define a pre-script to disable the repositories in the Maintenance Window advanced options.

Within NDB, an administrator needs to register a PostgreSQL database server VM with a database.Where should the database data and log files be located in order to successfully complete this task?

On the same disk as the binary installation

On the same disk as the operating system

Nutanix NCP-DB Practice Test 1 - Free Online Exam Prep & Questions

Question 1 / 40

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

Snapshot schedules

Clone Management

Data retention policies

Recovery Time Objective

Comment (0)

Nutanix NCP-DB Practice Test 1

Question

Nutanix NCP-DB Practice Tests

Practice Tests