Nutanix Certified Professional - Database Automation (NCP-DB) v6.5 - NCP-DB Exam Practice Test

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?
Correct Answer: D Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
An administrator needs to apply a minor version upgrade of the PostgreSQL software to an Era provisioned instance.
Which step should the administrator take before applying the patch?
Correct Answer: C Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
Which two options can NDB leverage to refresh a database clone? (Choose two.)
Correct Answer: A,C Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
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?
Correct Answer: C Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
When a database-group clone operation is executed for a collection of SQL Server databases, how does NDB ensure point-in-time consistency across the entire group?
Correct Answer: C Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
An administrator created an NDB managed VLAN called PGSQLVLAN40 After deploying PostgreSQL HA, it was noticed that the databases were able to communicate with everything on VLAN 40 only.
What can the administrator do to fix the current issue and going forward?
Correct Answer: D Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
An administrator needs to replace the default Nutanix self-signed certificates in Era.
Which SSL Certificate file format is supported?
Correct Answer: D Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
Which statement describes a user in Era with the Database Infrastructure Admin role?
Correct Answer: A Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
An administrator needs to investigate a database server deployment failure, but the failed database server VM is being destroyed during rollback.
Which global option should the administrator enable so that the database server VM remains deployed after the failure?
Correct Answer: B Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
How can Era be config90ured to send alert notifications to email recipients?
Correct Answer: D Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
An administrator originally configured the storage for an Oracle database running on Nutanix NDB using ASMLib. The administrator would like to scale the size of the database.
What should the administrator do to most efficiently increase the size of the database?
Correct Answer: C Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
A Linux OS is running a PostgreSQL instance that is managed by NDB. This instance is not working properly after a manual OS update, so an administrator has prepared a new Linux DB server VM that is ready to host the data from the broken DB.
Which action should the administrator perform to migrate data to the new DB server VM?
Correct Answer: D Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
A user accidentally drops a table in the database at 10:42pm and the NDB administrator is tasked with restoring the table.
The snapshot schedule is set for every 30 minutes and the log catchup is set for every 15 minutes. The last available snapshot is at 10:30pm.
What is the optimal path to restore the table back with minimum data loss?
Correct Answer: C Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
Which NDB HA control plane VM is upgraded first during an NDB upgrade?
Correct Answer: D Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
When provisioning Microsoft SQL Server utilizing database groups, which statement is true?
Correct Answer: C Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).