nutanix‐database‐automation‐ncp‐db‐ncp‐db‐65‐exam‐questions_2 - itnett/FTD02H-N GitHub Wiki

I'll create a simulated exam experience for you with 75 questions, including multiple choices for each, explanations for the correct answers, and clarifications for common pitfalls. Let's start with the first set of questions. I'll provide 10 questions at a time to ensure it's manageable.

Nutanix Certified Professional - Database Automation (NCP-DB) Exam Simulation

Section 1: NDB Concepts and General Knowledge

Question 1:
What is the primary goal of configuring NDB high availability?

  • A. Ensuring the availability and uptime of the NDB service
  • B. Optimizing query execution for faster data processing
  • C. Reducing network latency and improving performance
  • D. Securing the NDB instance with strong access controls

Correct Answer: A. Ensuring the availability and uptime of the NDB service
Explanation: The main purpose of configuring high availability in NDB is to ensure the continuous availability of the NDB service, reducing downtime during failures. Options B, C, and D are not the primary goals of high availability.

Question 2:
Which of the following is NOT typically included in Time Machine SLAs?

  • A. Data retention periods for snapshots
  • B. Frequency of snapshots
  • C. Specific user access controls
  • D. Log backup retention policies

Correct Answer: C. Specific user access controls
Explanation: Time Machine SLAs define data retention and backup frequency but do not include specific user access controls, which are handled separately through NDB’s access management features.

Question 3:
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

Correct Answer: B. Download the QCOW2 image file of NDB and upload it to Prism Element
Explanation: To install NDB on Nutanix AHV, the first step is to download the QCOW2 image file from the Nutanix Support Portal and upload it to Prism Element. Option A is incorrect because NDB is not offered as a SaaS. Options C and D are also incorrect as they assume NDB is already present.

Question 4:
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. 20GB

Correct Answer: C. 15GB
Explanation: A minimum of 15GB is recommended to ensure enough space for Oracle patches, updates, and temporary files. Choosing less could lead to space constraints during the patching process.

Question 5:
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

Correct Answer: C. Installer package for database software
Explanation: An installer package is needed to create or update a software profile in NDB. A pre-existing database server VM or patch file does not satisfy the requirement for creating a new software profile version.

Question 6:
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

Correct Answer: B. Set VM-Host Affinity
Explanation: Setting VM-Host Affinity ensures that database server VMs stay on specific hosts during the upgrade, maintaining their availability. Removing or unsetting affinity could cause disruption.

Question 7:
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

Correct Answer: A. 443 and 9440
Explanation: Ports 443 (HTTPS) and 9440 (Prism Central management) are used for secure API calls between NDB components. The other ports are unrelated to API communication in this context.

Question 8:
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

Correct Answer: D. upload upgrade_bundle path=path_to_upgrade_bundle
Explanation: The correct syntax for the NDB CLI command to upload the upgrade bundle for an offline upgrade is upload upgrade_bundle path=path_to_upgrade_bundle.

Question 9:
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.

Correct Answer: A. The patch must have been applied using NDB.
Explanation: NDB can only roll back patches that were applied using its own tools, ensuring it has the necessary rollback points and data.

Question 10:
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

Correct Answer: D. Database Parameters
Explanation: Database Parameter profiles allow administrators to configure initialization variables specific to different types of workloads (e.g., OLTP, DW).

Continue with More Questions?

Would you like to proceed with more questions, or focus on specific areas of the exam? Let me know how you would like to continue!

Let's continue with the next set of 10 questions to help you simulate the Nutanix Certified Professional - Database Automation (NCP-DB) exam.

Section 2: Deploy and Configure NDB Solutions

Question 11:
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

Correct Answer: B. API Server
Explanation: The API Server needs to be on the same Layer 2 (L2) network as other NDB management components to ensure smooth communication and functionality. The API server coordinates actions across the NDB infrastructure.

Question 12:
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

Correct Answer: A. Installer package for database software
Explanation: To create an NDB Software Profile, you need the installer package for the relevant database software, which contains all necessary files for installation and configuration.

Question 13:
Which port must be opened on the domain controller to support SQL Server AG provisioning by Era?

  • A. 389
  • B. 636
  • C. 9389
  • D. 5985

Correct Answer: C. 9389
Explanation: Port 9389 is required for SQL Server Availability Group (AG) provisioning by Era to allow communication with the domain controller. This port is used by the Windows Remote Management (WinRM) service.

Question 14:
What action should an administrator take to patch a PostgreSQL database that is part of a highly available setup?

  • A. Shut down the primary database server VM.
  • B. Perform a rolling upgrade during OS patching.
  • C. Patch the primary node first, then patch the replicas.
  • D. Disable high availability before patching.

Correct Answer: B. Perform a rolling upgrade during OS patching.
Explanation: A rolling upgrade ensures minimal downtime by patching one database server VM at a time. It starts with the secondary servers and then moves to the primary server.

Question 15:
An administrator needs to ensure continuous data protection for an Oracle database on NDB. Which SLA category should be configured to achieve this?

  • A. Daily
  • B. Weekly
  • C. Continuous
  • D. Monthly

Correct Answer: C. Continuous
Explanation: The Continuous SLA category is designed for scenarios requiring ongoing data protection, such as frequent log backups and near real-time recovery points.

Question 16:
A customer wants to provision an Oracle Database environment from Era. What is a prerequisite for this action?

  • A. Create a network profile for the Oracle database
  • B. Configure high availability for the Oracle cluster
  • C. Create a software profile using an existing installation
  • D. Set up a storage container in Prism Element

Correct Answer: C. Create a software profile using an existing installation
Explanation: To provision an Oracle Database environment from Era, you must first create a software profile based on an existing installation to ensure all configurations are correctly set.

Question 17:
An administrator wants to restore a SQL Server database using the last known good configuration. Which feature in NDB allows this?

  • A. Point-in-Time Recovery (PITR)
  • B. Snapshot Recovery
  • C. Log Catch-Up
  • D. Database Rebuild

Correct Answer: A. Point-in-Time Recovery (PITR)
Explanation: PITR allows administrators to restore a database to a specific point in time, minimizing data loss by utilizing transaction logs and backups.

Question 18:
How does NDB handle log catch-up for PostgreSQL instances?

  • A. Using the pg_basebackup command
  • B. Using the archive command
  • C. Using the pg_log_dump command
  • D. Using the restore command

Correct Answer: B. Using the archive command
Explanation: The archive command is used by NDB to perform log catch-up operations for PostgreSQL instances, ensuring that all transaction logs are safely stored and can be used for recovery.

Question 19:
Which factor is NOT typically considered when selecting a database engine for provisioning?

  • A. Data consistency and transaction support
  • B. Hardware and infrastructure requirements
  • C. Developer community and support resources
  • D. Network latency and bandwidth

Correct Answer: D. Network latency and bandwidth
Explanation: While network latency and bandwidth can impact database performance, they are not direct factors in selecting a database engine. The choice is usually based on data consistency, hardware compatibility, and community support.

Question 20:
Which statement is true regarding alert policies in NDB?

  • A. All alert policies are disabled by default.
  • B. Alerts can only be configured by the Super Administrator.
  • C. All alert policies are enabled by default, and their severity is set to "Critical."
  • D. Alerts are retained indefinitely unless manually deleted.

Correct Answer: C. All alert policies are enabled by default, and their severity is set to "Critical."
Explanation: NDB enables all alert policies by default, with the severity level set to "Critical" to ensure that administrators are notified of significant events immediately.

Section Summary:

These questions cover key topics related to deploying and configuring NDB solutions, handling database patching, performing data protection and recovery operations, and understanding the management and monitoring features of Nutanix Era.

Would you like to proceed with the next set of questions, or focus on a specific area of the exam? Let me know how you would like to continue!