Practice Free NCP-DB-6.5 Exam Online Questions
Question #71
Which command can be used to assign a static IP address to the Era VM on ESXi?
set
era-server > era
era-server >
An administrator is trying to register an Oracle Database Server VM to Era.
Which dependency must be met?
- A . SUDO NOPASS access is required
- B . Enable reQUIREetty setting on the source database
- C . /TEMP folder must have read-only permissions
- D . set path = /sbin:/bin:/usr/sbin:/usr/bin
Correct Answer: A
A
Explanation:
To register an Oracle Database Server VM to Era in Nutanix Database Automation (NCP-DB), certain dependencies must be met. One of these is that SUDO NOPASS access is required1. This allows the Era service to perform necessary operations on the Oracle Database Server VM. As for assigning a static IP address to the Era VM on ESXi, you can use the vSphere Client to configure static IP settings2. However, this is not directly related to the registration of an Oracle Database Server VM to Era. Please note that these answers are based on the information available as of my last update in 2021 and may need to be verified with the most recent Nutanix Database Automation (NCP-DB) documentation or resources.
A
Explanation:
To register an Oracle Database Server VM to Era in Nutanix Database Automation (NCP-DB), certain dependencies must be met. One of these is that SUDO NOPASS access is required1. This allows the Era service to perform necessary operations on the Oracle Database Server VM. As for assigning a static IP address to the Era VM on ESXi, you can use the vSphere Client to configure static IP settings2. However, this is not directly related to the registration of an Oracle Database Server VM to Era. Please note that these answers are based on the information available as of my last update in 2021 and may need to be verified with the most recent Nutanix Database Automation (NCP-DB) documentation or resources.
Question #72
Which file format is available when downloading a list of alerts?
- A . xlsx
- B . csv
- C . xml D.pdf
Correct Answer: B
B
Explanation:
When downloading a list of alerts from NDB, the available file format is csv (Comma-Separated Values). NDB provides this format to export alert data (e.g., alert ID, timestamp, severity, description) in a structured, machine-readable way that can be easily imported into spreadsheet applications like Microsoft Excel or analyzed programmatically. This aligns with NDB’s focus on operational efficiency and data portability.
Other options are not supported:
B
Explanation:
When downloading a list of alerts from NDB, the available file format is csv (Comma-Separated Values). NDB provides this format to export alert data (e.g., alert ID, timestamp, severity, description) in a structured, machine-readable way that can be easily imported into spreadsheet applications like Microsoft Excel or analyzed programmatically. This aligns with NDB’s focus on operational efficiency and data portability.
Other options are not supported:
Question #73
How would an administrator enter the NDB command line to change the static IP address on the NDB VM?
- A . era-server
- B . era
- C . cerebro_cli
- D . arithmos cli
Correct Answer: C
C
Explanation:
To change the static IP address on the NDB VM, an administrator would need to enter the NDB command line using the cerebro_cli command. The cerebro_cli command is used to access the Cerebro service, which is responsible for managing the NDB instance and its components.
The cerebro_cli command can be run from the NDB VM or from any other VM that has network connectivity to the NDB VM. The cerebro_cli command has various subcommands and options to perform different tasks, such as changing the IP address, hostname, password, or certificate of the NDB VM. To change the static IP address, the administrator would need to use the cerebro_cli network update subcommand with the appropriate parameters, such as the new IP address, netmask, gateway, and DNS servers. The cerebro_cli network update subcommand also requires the administrator to provide the current password of the NDB VM for authentication. After changing the IP address, the administrator would need to restart the NDB VM for the changes to take effect.
Reference:
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5, Section 2 – Deploy and Configure an NDB Solution, Objective 2.2: Configure an NDB Instance
Nutanix Database Management & Automation (NDMA) Course, Module 3: Nutanix Database Service (NDB) Installation and Configuration, Lesson 3.2: Configuring NDB, Topic: Changing the IP Address of the NDB VM
Nutanix Database Service (NDB) Command Line Interface Guide, Chapter 2: Cerebro CLI, Section: cerebro_cli network update
C
Explanation:
To change the static IP address on the NDB VM, an administrator would need to enter the NDB command line using the cerebro_cli command. The cerebro_cli command is used to access the Cerebro service, which is responsible for managing the NDB instance and its components.
The cerebro_cli command can be run from the NDB VM or from any other VM that has network connectivity to the NDB VM. The cerebro_cli command has various subcommands and options to perform different tasks, such as changing the IP address, hostname, password, or certificate of the NDB VM. To change the static IP address, the administrator would need to use the cerebro_cli network update subcommand with the appropriate parameters, such as the new IP address, netmask, gateway, and DNS servers. The cerebro_cli network update subcommand also requires the administrator to provide the current password of the NDB VM for authentication. After changing the IP address, the administrator would need to restart the NDB VM for the changes to take effect.
Reference:
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5, Section 2 – Deploy and Configure an NDB Solution, Objective 2.2: Configure an NDB Instance
Nutanix Database Management & Automation (NDMA) Course, Module 3: Nutanix Database Service (NDB) Installation and Configuration, Lesson 3.2: Configuring NDB, Topic: Changing the IP Address of the NDB VM
Nutanix Database Service (NDB) Command Line Interface Guide, Chapter 2: Cerebro CLI, Section: cerebro_cli network update
Question #74
How does NDB send notifications when alerts are generated?
- A . SNMP
- B . APIs
- C . Pulse
- D . Email
Correct Answer: D
D
Explanation:
NDB sends notifications when alerts are generated via email. The email notifications can be configured to send to one or more recipients, and can be customized to include the alert severity, category, description, and resolution steps. The email notifications help to inform the database administrator and other stakeholders about the status and issues of the NDB-managed databases and operations.
NDB does not send notifications via SNMP, APIs, or Pulse. SNMP is a protocol for collecting and organizing information about managed devices on a network. APIs are interfaces for communicating and exchanging data between different applications or systems. Pulse is a feature of the Nutanix cluster that collects and sends diagnostic and usage data to Nutanix for analysis and support.
Reference:
Nutanix Database Management & Automation Training Course, Module 3: Nutanix Era Deployment, Lesson 3.2: Nutanix Era Deployment, slide 11.
Nutanix Database Management & Automation Training Course, Module 5: Nutanix Era Operations, Lesson 5.1: Nutanix Era Operations, slide 6.
Nutanix Database Management & Automation Training Course, Module 5: Nutanix Era Operations, Lesson 5.2: Nutanix Era Alerts and Notifications, slides 5-7.
D
Explanation:
NDB sends notifications when alerts are generated via email. The email notifications can be configured to send to one or more recipients, and can be customized to include the alert severity, category, description, and resolution steps. The email notifications help to inform the database administrator and other stakeholders about the status and issues of the NDB-managed databases and operations.
NDB does not send notifications via SNMP, APIs, or Pulse. SNMP is a protocol for collecting and organizing information about managed devices on a network. APIs are interfaces for communicating and exchanging data between different applications or systems. Pulse is a feature of the Nutanix cluster that collects and sends diagnostic and usage data to Nutanix for analysis and support.
Reference:
Nutanix Database Management & Automation Training Course, Module 3: Nutanix Era Deployment, Lesson 3.2: Nutanix Era Deployment, slide 11.
Nutanix Database Management & Automation Training Course, Module 5: Nutanix Era Operations, Lesson 5.1: Nutanix Era Operations, slide 6.
Nutanix Database Management & Automation Training Course, Module 5: Nutanix Era Operations, Lesson 5.2: Nutanix Era Alerts and Notifications, slides 5-7.
Question #75
An administrator has been tasked to deploy Microsoft SQL servers in an Active Directory environment, selecting a specific service account to start up the database.
Which configuration should be set?
- A . Compute profile
- B . Sysprep Windows image
- C . Windows domain profile
- D . Database parameters
Correct Answer: C
C
Explanation:
To deploy Microsoft SQL Servers in an Active Directory (AD) environment and select a specific service account to start up the database, the administrator must configure a Windows domain profile in NDB. A Windows domain profile defines the AD integration settings, including the service account credentials (e.g., username and password) that NDB uses to authenticate and manage the SQL Server instances. This configuration ensures the database starts and runs under the specified AD service account, aligning with enterprise security policies.
Option A (Compute profile) is incorrect because a compute profile defines VM resources (CPU, memory), not AD or service account settings.
Option B (Sysprep Windows image) is incorrect because Sysprep is for generalizing Windows images, not configuring AD service accounts.
Option C (Windows domain profile) is correct as it is the specific NDB feature for AD integration and service account management.
Option D (Database parameters) is incorrect because database parameters tune database settings, not AD authentication.
This configuration ensures secure and compliant SQL Server deployment.
Reference: Nutanix Database Service (NDB) User Guide, Chapter 2: Deploying and Configuring an NDB Solution,
Section: Configuring Windows Domain Profiles
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5 Blueprint, Section 2: Deploy and Configure an NDB Solution
C
Explanation:
To deploy Microsoft SQL Servers in an Active Directory (AD) environment and select a specific service account to start up the database, the administrator must configure a Windows domain profile in NDB. A Windows domain profile defines the AD integration settings, including the service account credentials (e.g., username and password) that NDB uses to authenticate and manage the SQL Server instances. This configuration ensures the database starts and runs under the specified AD service account, aligning with enterprise security policies.
Option A (Compute profile) is incorrect because a compute profile defines VM resources (CPU, memory), not AD or service account settings.
Option B (Sysprep Windows image) is incorrect because Sysprep is for generalizing Windows images, not configuring AD service accounts.
Option C (Windows domain profile) is correct as it is the specific NDB feature for AD integration and service account management.
Option D (Database parameters) is incorrect because database parameters tune database settings, not AD authentication.
This configuration ensures secure and compliant SQL Server deployment.
Reference: Nutanix Database Service (NDB) User Guide, Chapter 2: Deploying and Configuring an NDB Solution,
Section: Configuring Windows Domain Profiles
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5 Blueprint, Section 2: Deploy and Configure an NDB Solution
Question #75
An administrator has been tasked to deploy Microsoft SQL servers in an Active Directory environment, selecting a specific service account to start up the database.
Which configuration should be set?
- A . Compute profile
- B . Sysprep Windows image
- C . Windows domain profile
- D . Database parameters
Correct Answer: C
C
Explanation:
To deploy Microsoft SQL Servers in an Active Directory (AD) environment and select a specific service account to start up the database, the administrator must configure a Windows domain profile in NDB. A Windows domain profile defines the AD integration settings, including the service account credentials (e.g., username and password) that NDB uses to authenticate and manage the SQL Server instances. This configuration ensures the database starts and runs under the specified AD service account, aligning with enterprise security policies.
Option A (Compute profile) is incorrect because a compute profile defines VM resources (CPU, memory), not AD or service account settings.
Option B (Sysprep Windows image) is incorrect because Sysprep is for generalizing Windows images, not configuring AD service accounts.
Option C (Windows domain profile) is correct as it is the specific NDB feature for AD integration and service account management.
Option D (Database parameters) is incorrect because database parameters tune database settings, not AD authentication.
This configuration ensures secure and compliant SQL Server deployment.
Reference: Nutanix Database Service (NDB) User Guide, Chapter 2: Deploying and Configuring an NDB Solution,
Section: Configuring Windows Domain Profiles
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5 Blueprint, Section 2: Deploy and Configure an NDB Solution
C
Explanation:
To deploy Microsoft SQL Servers in an Active Directory (AD) environment and select a specific service account to start up the database, the administrator must configure a Windows domain profile in NDB. A Windows domain profile defines the AD integration settings, including the service account credentials (e.g., username and password) that NDB uses to authenticate and manage the SQL Server instances. This configuration ensures the database starts and runs under the specified AD service account, aligning with enterprise security policies.
Option A (Compute profile) is incorrect because a compute profile defines VM resources (CPU, memory), not AD or service account settings.
Option B (Sysprep Windows image) is incorrect because Sysprep is for generalizing Windows images, not configuring AD service accounts.
Option C (Windows domain profile) is correct as it is the specific NDB feature for AD integration and service account management.
Option D (Database parameters) is incorrect because database parameters tune database settings, not AD authentication.
This configuration ensures secure and compliant SQL Server deployment.
Reference: Nutanix Database Service (NDB) User Guide, Chapter 2: Deploying and Configuring an NDB Solution,
Section: Configuring Windows Domain Profiles
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5 Blueprint, Section 2: Deploy and Configure an NDB Solution
Question #77
Nutanix NDB gives an administrator the ability to create highly-available database pairs with which two databases? (Choose two.)
- A . MySQL
- B . PostgreSQL
- C . SQL Server
- D . MariaDB
Correct Answer: BC
BC
Explanation:
Nutanix NDB provides the ability to create highly-available (HA) database pairs, leveraging replication and failover across clusters. The two databases explicitly supported for HA pairs in NDB are PostgreSQL and SQL Server. NDB orchestrates HA for PostgreSQL using streaming replication and for SQL Server using Always On Availability Groups or Failover Cluster Instances, ensuring data redundancy and failover capabilities across Nutanix clusters.
Other options are not supported for HA pairs:
BC
Explanation:
Nutanix NDB provides the ability to create highly-available (HA) database pairs, leveraging replication and failover across clusters. The two databases explicitly supported for HA pairs in NDB are PostgreSQL and SQL Server. NDB orchestrates HA for PostgreSQL using streaming replication and for SQL Server using Always On Availability Groups or Failover Cluster Instances, ensuring data redundancy and failover capabilities across Nutanix clusters.
Other options are not supported for HA pairs:
Question #78
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 . Provision an HA instance with the services enabled.
- B . Disable the services, create a software profile version, and provision an HA instance.
- C . Provision an HA instance with the services disabled.
- D . Enable the services, create a software profile version, and provision an HA instance.
Correct Answer: C
C
Explanation:
To provision a PostgreSQL HA instance from a software profile created from a VM with services like etcd, HAProxy, Patroni, and keepalived installed, the administrator must ensure the instance aligns with NDB’s HA framework. These services (e.g., Patroni for PostgreSQL HA management, HAProxy for load balancing) may conflict with NDB’s built-in HA mechanisms. Provisioning an HA instance with these services disabled allows NDB to manage HA using its native replication and failover capabilities (e.g., streaming replication), avoiding duplication or interference from the VM’s pre-installed services.
Option A (Provision an HA instance with the services enabled) is incorrect because enabling these services may cause conflicts with NDB’s HA management.
Option B (Disable the services, create a software profile version, and provision an HA instance) is incorrect because disabling services and recreating a profile is unnecessary; the provisioning step can handle service configuration.
Option C (Provision an HA instance with the services disabled) is correct as it ensures NDB’s HA features take precedence without interference.
Option D (Enable the services, create a software profile version, and provision an HA instance) is incorrect due to potential conflicts with NDB’s HA implementation.
Note: The typo "PostqreSQL" is assumed to mean "PostgreSQL."
Reference: Nutanix Database Service (NDB) User Guide, Chapter 4: Managing Database Engines, Section:
Provisioning HA Instances
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5 Blueprint, Section 4: Manage Database Engines
C
Explanation:
To provision a PostgreSQL HA instance from a software profile created from a VM with services like etcd, HAProxy, Patroni, and keepalived installed, the administrator must ensure the instance aligns with NDB’s HA framework. These services (e.g., Patroni for PostgreSQL HA management, HAProxy for load balancing) may conflict with NDB’s built-in HA mechanisms. Provisioning an HA instance with these services disabled allows NDB to manage HA using its native replication and failover capabilities (e.g., streaming replication), avoiding duplication or interference from the VM’s pre-installed services.
Option A (Provision an HA instance with the services enabled) is incorrect because enabling these services may cause conflicts with NDB’s HA management.
Option B (Disable the services, create a software profile version, and provision an HA instance) is incorrect because disabling services and recreating a profile is unnecessary; the provisioning step can handle service configuration.
Option C (Provision an HA instance with the services disabled) is correct as it ensures NDB’s HA features take precedence without interference.
Option D (Enable the services, create a software profile version, and provision an HA instance) is incorrect due to potential conflicts with NDB’s HA implementation.
Note: The typo "PostqreSQL" is assumed to mean "PostgreSQL."
Reference: Nutanix Database Service (NDB) User Guide, Chapter 4: Managing Database Engines, Section:
Provisioning HA Instances
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5 Blueprint, Section 4: Manage Database Engines
Question #79
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 . 20 GB
Correct Answer: B
B
Explanation:
When patching an Oracle Database Server VM, it’s important to ensure that there is sufficient storage space allocated for the Grid home. A minimum of 10GB space is required for this purpose to accommodate the patching process without storage constraints.
Reference: Nutanix Database Automation documentation, particularly in the sections discussing Oracle database server VM management and patching requirements.
B
Explanation:
When patching an Oracle Database Server VM, it’s important to ensure that there is sufficient storage space allocated for the Grid home. A minimum of 10GB space is required for this purpose to accommodate the patching process without storage constraints.
Reference: Nutanix Database Automation documentation, particularly in the sections discussing Oracle database server VM management and patching requirements.
Question #80
When performing a SQL Server Restore Source Database operation, what is a valid reason an
administrator would choose the Restore
Location as New Location?
- A . The log files are needed to petform the point in time restore.
- B . The administrator wants to restore to a new location and have Era apply Nutanix best practices.
- C . The administrator wants to keep the original schema in place.
- D . The database files are on a disk with other database files and the administrator wants to get the database restored as quickly as possible.
Correct Answer: B
B
Explanation:
When performing a SQL Server Restore Source Database operation in Nutanix Database Automation (NCP-DB), an administrator might choose the Restore Location as New Location if they want to restore to a new location and have Era apply Nutanix best practices1. This is because Nutanix Era automates and simplifies database management, allowing the administrator to manage databases at scale, and it applies Nutanix best practices during the restore process1. This ensures optimal performance and reliability of the restored database1.
B
Explanation:
When performing a SQL Server Restore Source Database operation in Nutanix Database Automation (NCP-DB), an administrator might choose the Restore Location as New Location if they want to restore to a new location and have Era apply Nutanix best practices1. This is because Nutanix Era automates and simplifies database management, allowing the administrator to manage databases at scale, and it applies Nutanix best practices during the restore process1. This ensures optimal performance and reliability of the restored database1.