Nutanix Certified Professional - Database Automation (NCP-DB v7.5) Questions and Answers
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?
For an NDB offline upgrade, which NDB CLI command should be used to upload the upgrade bundle?
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?
An administrator needs to deploy a database resilient cluster engine across three clusters. Which database engine can be used for this scenario?
An administrator needs to restore a database provisioned on Storage Spaces. The virtual disks are shared with multiple databases.
Which restore method is supported?
How can Era be config90ured to send alert notifications to email recipients?
An administrator needs to protect a database with a Point In Time Recovery (PITR) SLA that provides a minimum of seven days of log
recovery.
What is the minimum Default SLA that meets this requirement?
An administrator begins an SQL database clone deletion, but notices it fails almost immediately.
What could be the cause of this failure?
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?
At 2:15 PM, an application developer accidentally executes a destructive DROP TABLE command on a production Oracle database managed by NDB. The last scheduled daily snapshot occurred at midnight, but log catch-up is enabled and healthy. The developer requires a copy of the data exactly as it appeared at 2:10 PM to recover the lost table without interrupting the live production instance.
How should the NDB administrator proceed?
An administrator is setting up an NDB VM in a highly segmented environment in which only specific ports are allowed.
Before deploying the NDB VM, which two options identify ports that must be open to the Controller VMs (CVMs)? (Choose two.)
An administrator has been tasked with cloning a production HR database but needs to anonymize the database during the cloning process.
Which command should the administrator execute using the NDB CLI to anonymize the database?
An administrator enables NDB Multi-cluster.
Which NDB Service component is deployed on a dedicated VM?
An administrator needs to migrate a large 1/0-intensive database that doesn't support multi-disk layout.
How should the storage be provisioned with Era to support the database while optimizing performance?
An administrator has run into an error when provisioning a new Oracle database VM.
What is the best action that the administrator should perform in the NDB GUI to provide the most complete picture to send to Nutanix support on that specific operation?
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?
What is the terminology used for registering an existing database with Era?
Which statement describes a user in Era with the Database Infrastructure Admin role?
How can an administrator exclude Kernel patches for the Linux OS using the most efficient means?
Nutanix NDB gives an administrator the ability to create highly-available database pairs with which two databases? (Choose two.)
An administrator is attempting to enable high availability (HA) for NDB across three Nutanix clusters located in separate data centers. If the network latency between two clusters exceeds 25ms RTT, what impact might this have on the NDB HA setup?
An administrator needs to create a software profile.
What should the administrator do first with the VM that will be used as the template for this task?
An administrator is creating a Windows Domain profile in Era.
Which optional field can be skipped and provided during the provisioning process?
Which action should be completed before updating Oracle Database software?
Where should an administrator perform an upgrade within the Era management interface?
An organization has NDB HA enabled across multiple Nutanix clusters.
If two clusters are using ESXi and one cluster is using AHV, which additional component is necessary to support cross-hypervisor compatibility?
An NDB administrator wants to configure object storage for database log backups.
What step must be completed first to enable Nutanix Objects for use in NDB?
How should an administrator modify the Alert Severity level within Era?
An administrator needs to deploy a cumulative update (CU) for SQL Server.
What steps would the administrator take to prepare this deployment with NDB?
Which two network prerequisites are required to deploy an Era instance in production? (Choose two.)
An administrator is looking to provision a relational database management system (RDBMS) in an HA instance. Which two database engines are supported with NDB? (Choose two.)
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?
An administrator wants to view the information for all the roles and the number of users assigned to each of them What role must a user belong to in order to view this information?
What severity level are alert policies set to for ND8?
When doing an Era software upgrade for a Multi-Cluster enabled installation, which component is upgraded first?
An administrator manages an multi-cluster NDB instance with HA enabled. After failure, more than one API server VM is down. How should the administrator restore full functionality?
An administrator is preparing to deploy NDB in a High Availability configuration so that the NDB control plane is distributed across different sites and protected against a failure at the primary data center.
Which prerequisite must be met before enabling NDB High Availability?
An administrator needs to patch multiple Microsoft SQL Server databases managed by NDB.
Which NDB capability simplifies this operation?
How can NDB updates be downloaded for a dark site?
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?
An administrator has deployed an NDB HA setup. An electrical maintenance window needs to be planned and the clusters where NDB is deployed must be powered off.
After shutting down the load balancer server, what should the administrator do next?
When registering SAP HANA Database and Database Server VM there are several (Linux) OS configuration requirements that must be set before registering a database Or a database server VM.
Which system file should the entry, secure_pazh be configured in?
What are two status values that can be set within the Alerts Dashboard? (Choose two.)
Which two statements best describe the features and functionality of Era Oracle patching? (Choose two.)
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?
A database administrator is working with a cloned database and creates a clone removal schedule.
Which two default actions are taken on the cloned database? (Choose two.]
Which statement describes what the Time Machine Heal function can be used for?
An administrator tried to provision Nutanix Database Service (NDB) from Prism Central Marketplace and is getting the error shown in the exhibit.
Which action would have prevented this issue?
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?
A request is received to refresh a database clone from a new manual snapshot. When the administrator attempts to create the new snapshot from the Time Machine, it is in a Frozen state.
What causes a Time Machine to enter the Frozen state and what are the administrator's options to complete the request?

An administrator wants to register a database using a SQL Server User
Where can this user be specified?
While registering a database, the Group Database with One Time Machine option is selected.
What is the key architectural benefit of this option?
An administrator wants to provision a MySQL high-availability instance.
Which option must be enabled in NDB to allow automated routing and failover of application traffic to the database replicas?
When executing an automated database restore or point-in-time log replay on a Linux target host with SELinux configured in Enforcing Mode, how does NDB ensure that the operating-system kernel does not block the attachment of newly restored storage volumes?
Era allows custom metadata to be assigned to entities (clones, time machines, databases, and database servers) by using which component?
What is the minimum frequency in minutes configurable for NDB Log Catch-up operation?
An administrator changed NDB language settings from English to Spanish, but when accessing NDB from a different workstation the language reverts to English.
Which statement describe the matter?
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?
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:
• SQLAGNI\EMR
• SQLAGN2\EMR
• SQLAGN3\DW
SQLAGN3\DW is running the Analytics service that needs real-time data.
How should the administrator register the database in Era?
An administrator has been asked to clone a 2 TB Microsoft SQL Server database within the same Nutanix cluster as the source database and leave the clone in a read-only state.
After the operation completes, how much storage would the Microsoft SQL Server database clone consume without any new writes?
An administrator needs to assign a VLAN to provide IP address to a database VM. What is the procedure to create the Network Profile?
What are two of the required steps to provision a new network in Clusters and extend it to Era? (Choose two.)
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?
An administrator needs to quickly restore a database to a previous point in time following an accidental data modification. The recovery must minimize downtime and avoid completely reinstalling the database.
Which NDB capability should be used?
For which database engine does Era support rolling back a patch using CLI?
An administrator needs to deploy a new PostgreSQL instance but limit the maximum number of database connections after the instance enters production.

Which profile should the administrator configure to meet this requirement?
An administrator changed the NDB language setting from English to Spanish. However, when the administrator accesses NDB from a different workstation, the language reverts to English.
Which statement describes the cause of the language change?
For supported Linux based database VM's managed by NDB, how would an administrator keep software profiles updated for provisioning new database VMs?
An administrator wants to provision a Microsoft SQL Server Always On availability group with a specific IP address for the availability-group listener.
What prerequisite is needed to support this configuration with NDB?
When provisioning a new database, which two options are available for the target? (Choose two.)
An administrator enables NDB High Availability.
What happens if the active NDB API service becomes unavailable?
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.)
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?
A NDB non-administrative user wants to provision an Oracle database leveraging a Software Profile that the administrator created. What must the administrator do to ensure that this user has access to the Oracle Software Profile?
Where would an administrator find the total space being used by all Era clones for a specific database?
What is required to create an NDB Software Profile Version for PostgreSQL?
Before registering a database server VM to NDB, what should an administrator use to verify all required software and configuration dependencies?
Which site needs to be reachable to ensure an NDB server can send periodic telemetry data to the central Nutanix repository over port 443?
An administrator needs to provision a database for test purposes with a data protection policy that minimizes storage usage.
How should the administrator best complete this task?
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?
An administrator needs to restore databases provisioned with a shared disk configuration on Windows Storage Spaces What happens when NDB runs the restore operation?
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?
An online retail application requires data to be synchronized between multiple SQL Server databases. This provides clearer reporting from
multiple databases at the Same time for consistency at the end of each business day.
What is the best way to fulfill this requirement?
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?
Which two profiles are required to provision a new Oracle database through Era? (Choose two.)
An NDB administrator would like to configure a database with a Time Machine protection mode that includes the Log Catchup operation.
What would be the most essential component to make such a configuration possible?
An administrator has been tasked with deploying Microsoft SQL Server database servers in an Active Directory environment. The administrator must use a group Managed Service Account (gMSA) for the SQL Server services.
Which configuration should be created in NDB?
Which file type must be downloaded from the Nutanix Portal for NDB deployment?
An administrator needs to reset the NDB GUI password.
What should the administrator perform from the SSH session?
An administrator is initially setting up Time Machine for a newly-provisioned database. What is the maximum number of snapshots per day that can be configured in the GUI?
When configuring Disaster Recovery (DR) for an Oracle database using Nutanix Database Service (NDB), how does NDB natively automate and orchestrate high-availability data replication between a primary data center and a remote DR site?
An administrator configured a new Active Directory server but is unable to save the configuration.
What must be done before the configuration can be saved?