Nutanix NCP-DB Practice Questions

146 Questions ...

Updated On : 24-Feb-2025




Prepare with our NCP-DB practice questions and boost your chances of passing the exam effortlessly. Featuring Nutanix exam-like questions, they cover all critical topics and provide detailed explanations to enhance your understanding. Prepare smarter, not harder, and achieve your Nutanix NCP-DB certification goals effortlessly!

Page 7 out of 25 Pages ... Showing Questions in Random order from Exam

An administrator has received a request to clone a source production database to an existing development server. Which two actions must be taken to complete this task?


A. The development server must be registered by Era in order to receive the clone.


B. The development server must be registered by Era and authorized to host clones from the Time Machine.


C. The development server must be authorized for the database Time Machine.


D. The development server must have the IP and credentials provided during cloning.





A.
  The development server must be registered by Era in order to receive the clone.

D.
  The development server must have the IP and credentials provided during cloning.

Explanation:
According to the Nutanix Database Automation (NCP-DB) Learning documents12, to clone a source production database to an existing development server, the following actions must be taken:
A. The development server must be registered by Era in order to receive the clone1. This is because Nutanix Era is a database management tool that manages the lifecycle of databases and their copies. Registering the development server with Era allows it to manage the database on that server.
D. The development server must have the IP and credentials provided during cloning2. This is necessary for Era to access the development server and perform the cloning operation. The IP address and credentials are used to establish a connection to the development server. Without these details, Era would not be able to access the server and perform the cloning operation.

An administrator needs to increase storage for a MongoDB database provisioned using NDB. After launching the NDB CLI, the administrator begins with creating the input file for this operation. Which parameter should the administrator include within the input file?


A. extend_storage


B. update


C. database


D. data_percent





A.
  extend_storage

Explanation:
To increase storage for a MongoDB database provisioned using NDB, the administrator needs to use the extend_storage parameter in the input file for the NDB CLI. This parameter specifies the amount of additional storage to be added to the database server VM in GB. For example, if the current storage size is 100 GB and the administrator wants to increase it to 150 GB, the input file should contain the following line:

  • extend_storage: 50
The other parameters are not relevant for this operation. The update parameter is used to update the database software version, the database parameter is used to specify the database name, and the data_percent parameter is used to specify the percentage of data to be copied during a clone operation.

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


A. 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.


B. 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


C. 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.


D. 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.





B.
  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

Explanation:
NDB supports two modes of log backup management for Microsoft SQL databases: NDB-managed and 3rdparty managed. In the NDB-managed mode, NDB takes full control of the log backups and stores them in the Cerebro log location. In the 3rd-party managed mode, NDB allows the use of external backup tools to backup the logs from the database log destination. However, NDB still needs to capture the logs for its own operations, such as point-in-time recovery, clone refresh, and log catch-up. Therefore, NDB will periodically scan the database log destination and copy the logs to the Cerebro log location. This process requires that the log catch-up begins before the logs get backed up by the 3rd-party tool, otherwise NDB will miss some logs and the operations will fail. If the 3rd-party tool grants exclusive access to the logs, then NDB will not be able to capture them at all, and the operations will not be supported.

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





D.
  HA Proxy VMs

Explanation:
NDB High Availability (HA) is a feature that ensures the availability and reliability of the NDB management plane components, such as the API Server, the Repository VMs, and the NDB Agents. To enable NDB HA, you need to deploy at least three HA Proxy VMs on the same L2 network as the NDB Server VM. The HA Proxy VMs act as load balancers and health monitors for the NDB management plane components, and they also provide a single endpoint for accessing the NDB APIs and UI.

An administrator is trying to register a database server VM with NDB. Which file types will prevent the registration from being successful if located in the C:\ drive?


A. Page


B. System


C. Database


D. Backup





A.
  Page

Explanation:
Page files are temporary files that Windows uses to store data that does not fit in the physical memory. Page files can interfere with the registration of a database server VM with NDB, as they can cause errors or performance issues. Therefore, page files should be located in a separate drive or partition from the C:\ drive, where the NDB agent and other files are installed. System, database, and backup files do not prevent the registration of a database server VM with NDB, as long as they are not corrupted or incompatible with the NDB requirements.

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





D.
  Database Parameters

Explanation:
The database parameters profile is used to define the initialization variables for different types of database engines and workloads, such as OLTP and DW. The database parameters profile allows the database administrator to customize the configuration settings for each database engine, such as Oracle, SQL Server, PostgreSQL, and MySQL. The database parameters profile can also be applied to different database operations, such as provisioning, cloning, and patching. The database parameters profile helps to optimize the performance and functionality of the databases according to the specific requirements and best practices of each database engine and workload.
The software profile version is used to define the software version and edition for each database engine, such as Oracle 19c Enterprise Edition or SQL Server 2019 Standard Edition. The software profile version is required for provisioning new databases and patching existing databases. The software profile version helps to ensure the compatibility and compliance of the databases with the supported software versions and editions.
The network profile is used to define the network configuration and security settings for the database server VMs and the databases, such as the IP address, subnet mask, gateway, DNS, firewall rules, and SSL certificates. The network profile is required for registering new database server VMs and provisioning new databases. The network profile helps to ensure the connectivity and protection of the database server VMs and the databases within the network environment.
The compute profile is used to define the compute resources and storage policies for the database server VMs and the databases, such as the CPU, memory, disk size, disk type, compression, deduplication, and replication factor. The compute profile is required for provisioning new databases and cloning existing databases. The compute profile helps to ensure the availability and efficiency of the database server VMs and the databases within the Nutanix cluster.


Page 7 out of 25 Pages
Previous