Because of a cost reduction program, many Microsoft SQL server instances will be consolidated on DB server VMs managed by NDB using a medium compute profile. Database administrators are concerned about DB storage capacity and are looking to expand it.Which NDB task should be performed?

Update the Database server VMs.

An NDB environment has been deployed with three Nutanix clusters. An administrator has been asked to create a Microsoft SQL Server software profile for each of these clusters.Which is a requirement to create the above-mentioned profiles?

Each cluster must host a VM with the DB engine.

Compute profile must be created first on every cluster.

Enable Multi-cluster capabilities for NDB.

Enable High Availability for the current NDB Service.

Each cluster must host a VM with the DB engine.

An administrator has been asked to add a new Nutanix AHV cluster to the current single default container for DB provisioning.Which configuration should be performed before enabling NDB multi-cluster?

Add both clusters under Prism Central management and verify NDB is registered to the same Prism Central Instance. environment using a storage container as the

Deploy Nutanix Self Service VM and use blueprints to allow NDB to deploy databases on multiple clusters.

Configure datastore mapping within Prism Element Protection Domains.

Enable High Availability for NDB service on the Administration page.

Add both clusters under Prism Central management and verify NDB is registered to the same Prism Central Instance. environment using a storage container as the

A new web application performs up to 200 concurrent connections to a PostgreSQL database. An administrator needs to configure the system to provision those DB servers.Which action would easily help the administrator achieving this goal?

Provision a PostqreSQL HA Instance.

Use Post Create Command when provisioning the DB.

Create a new Database Parameters profile.

Edit the API equivalent shell script to apply the setting.

Provision a PostqreSQL HA Instance.

A Development team is asking for updated data for a cloned MongoDB instance that is being used as source data for a script. Which task should be performed by an NDB administrator?

Clone the DB from the latest point in time data.

A DBA executed a script which corrupted an Oracle DB managed by NDB. After few minutes, the NDB administrator has been asked to create a copy of the DB using the latest available snapshot.Which actions should be taken?

Select the snapshot from Time Machine and create a new clone.

Fail the Oracle cluster over to a surviving RAC node.

Select the snapshot from Time Machine and create a new clone.

Use Time Machine to create a clone from file-level database backup.

Provision a new Oracle DB and perform log catch-up.

It becomes necessary to remove an existing database clone. 'To minimize the impact of that removal to users, an administrator would like to schedule this operation for weekend hours.When scheduling this removal, other than the specified date/time, which option in the Update Removal Schedule is pre-selected as non-optional?

Delete supporting snapshot from NDB.

Create an alert before removal.

Delete supporting snapshot from NDB.

Unregister the database clone from NDB.

Delete the database clone from the VM.

An administrator needs to provision PostgreSQL instance from a software profile. The software profile was created from a VM with services such as etcd, HAProxy, Patroni and keepalived installed.What should the administrator perform to successfully provision an HA instance?

Provision an HA instance with the services disabled.

Provision an HA instance with the services enabled.

Disable the services, create a software profile version, and provision an HA instance.

Provision an HA instance with the services disabled.

Enable the services, create a software profile version, and provision an HA instance.

An administrator begins an SQL database clone deletion, but notices it fails almost immediately.What could be the cause of this failure?

The clone has been marked as Immutable.

A refresh operation is in progress.

The clone has been marked as Immutable.

The database was not marked as Offline before the operation.

The database data drives are shared with other applications.

A vCenter instance which manages multiple clusters including a Nutanix cluster hosting NDB service crashed. After deploying a dedicated new vCenter server, the administrator needs to update vCenter setting within NDB.Which action should be performed?

Update cluster settings from the NDB administration page.

Click the Getting Started page and perform the configuration wizard.

Update cluster settings from the NDB administration page.

Open the maintenance page in NDB and configure the cluster settings.

Wait 60 minutes and Prism Central will automatically sync NDB.

Refer to the exhibit. An administrator has opened the Enable Multi-Cluster configuration for an NDB instance, but the wizard does not present the VLAN, as shown in the exhibit.Which configuration allows to choose a VLAN in the drop-down box?

A network profile must be created first.

Verify if subnet leverages advanced network control.

IP address pool must be managed in NDB.

VLAN subnet must use IP address management.

A DBA team needs to release PostgreSQL HA instances using a dedicated subnet.Which action is mandatory before creating the network profile?

A VLAN must be added to NDB networks.

The subnet in Prism Element must be iPAM configured.

The DB VMs must be registered first.

A VLAN must be added to NDB networks.

Configure Network Segmentation.

A quality assurance team noticed a significant change between a cloned database they are currently using versus the one used one week ago. They created an SQL script to verify the differences.Which task should be performed by an NDB administrator to provide the correct database to the QA team?

Clone database selecting Point in Time data.

Create a clone database from a snapshot.

Clone database selecting Point in Time data.

Perform a Log Catch Up operation.

An administrator has been asked to provision a new Oracle single instance database, but cannot proceed with the first step of the wizard. Which statement best describes the current situation?

Time Machine is not configured.

No remote clusters are configured.

A snapshot must be taken on the original DB.

An administrator would like to leverage the Oracle restore feature within NDB for a RAC database.Prior to the restoration operation, what must the administrator do?

Ensure the database is registered with NDB.

Ensure the database is in a Down state.

Ensure the database is registered with NDB.

Ensure the database is in an Up state.

Ensure more than one node of the RAC is reachable.

For supported Linux based database VM's managed by NDB, how would an administrator keep software profiles updated for provisioning new database VMs?

Apply patches to a database VM for each supported database engine, then create a new software profile version for each supported database VM for each one using the updated database VM as the source.

Create a Maintenance window under the policy menu, then under Database VM, add the database VMs to that maintenance window and check both Database and Operating system updates.

Apply patches to a database VM for each supported database engine, then create a new software profile version for each supported database VM for each one using the updated database VM as the source.

Associate the newly provisioned database VMs with a maintenance window so they are keep updated.

In the Administrator menu drop down, go the Maintenance tab and choose Download Upgrade

An administrator needs to restore databases provisioned with a shared disk configuration on Windows Storage Spaces What happens when NDB runs the restore operation?

NDB restores the disk that are associated with the database.

NDB copies the DB files to be restored to the source volume.

NDB replaces the source volume with the snapshot volume.

NDB performs Tail Log backup to backup any remaining logs.

While using Time Machine (TM) to restore a source database, the option to restore data to Point in Time is not available. What should an administrator do to restore databases to Point in Time?

Update TM SLA to BRONZE or higher.

Restore Source DB using a snapshot

Update TM SLA to BRONZE or higher.

Create DB clone using a snapshot.

Update TM SLA to BRASS or lower.

During maintenance, a team wants to power off the repository VM. The VM is not the primary or synchronized copy node. What is the expected outcome?

There will be no service interruption.

The HAProxy VMs will failover instead.

There will be no service interruption.

Manual interaction will be required to restore service.

NDB services will fail over immediately.

A database administrator wants to be notified in advance before any database clones are removed using a removal schedule What is the best way to configure this notification?

Select the Create an Alert Before Removal option.

Create a Playbook to create an alert based on the removal event.

Select the Create an Alert Before Removal option.

Build a custom report in Prism to report on these events.

Configure SMTP alerts for all actions in NDB.

An administrator needs to provision multiple database clones from the same source database for different purposes, such as QA and Test/Development. To avoid resource starving, the administrator wants to differentiate VM resources for each department.What is the most efficient way to accomplish this task?

Create multiple Compute profiles.

Leverage NCM Self Service to deploy database clones.

Use a VM Template for each department.

Generate a playbook to resize database VMs when released.

A clone needs to be created on an existing database server, but there are no Authorized database servers defined to support the cloned database.In which two ways can Database Server VMs be authorized during a Clone Create operation? (Choose two.)

Within Time Machine, use the Actions menu and Authorize Database Server VMs to identify which database server VMs to authorize for clones.

During the Clone creation process, click the plus icon to authorize one or more database server VMs.

Within Time Machine, use the Actions menu and Authorize Database Server VMs to identify which database server VMs to authorize for clones.

Within the Database Server VM Summary window, update the database sever to be authorized for supporting cloned databases.

During the Clone creation process, click the plus icon to authorize one or more database server VMs.

During the database server provisioning process, flag the database server to be authorized for supporting cloned databases.

As administrator has been asked to add a database to a PostgreSQL instance already managed by NDB.Which task should be performed?

Add a new database to a source DB.

Register a new DB VM to add the DB.

Provision a new DB server VM and add the new DB.

Update a database clone to add a new DB.

A database administrator wants to clone an SQL database that has Transparent Data Encryption (TDE) enabled.Which two steps must be taken on the target server for this clone to be successful? (Choose two.)

Backup the keystore bundle file from the source database server VM.

Run the post-clone command script.

Backup the .cer and .pvk files from the source database server VM.

Backup the keystore bundle file from the source database server VM.

Run the pre-clone command script.

Run the post-clone command script.

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

A Log Catchup gap has occurred, impacting the ability to perform point-in-time restore (PITR) operations to create a clone or perform a database restore.

Which two statements below are true for the NDB Time Machine Heal Snapshot feature? (Choose two.)

Become a Premium Member for full access

Unlock Premium Member

Nutanix NCP-DB Practice Test 5

Question

Nutanix NCP-DB Practice Tests

Practice Tests