
Get NCP-DB-6.10 Actual Free Exam Q&As to Prepare for Your Nutanix Certification
Nutanix Actual Free Exam Questions And Answers
NEW QUESTION # 89
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?
- A. Database infrastructure administrator
- B. Super Administrator
- C. Infrastructure administrator
- D. Database administrator
Answer: B
Explanation:
To view information about all roles and the number of users assigned to each in NDB, the user must belong to the Super Administrator role. This role provides full administrative privileges, including access to the "Users and Roles" section of the NDB GUI, where role assignments and user counts are visible. Lower-tier roles (e.g., Database Infrastructure Administrator, Database Administrator, Infrastructure Administrator) have limited scopes and cannot access this comprehensive role/user overview.
NEW QUESTION # 90
When trying to restore a database via Time Machine (TM), the option to restore data to a Point in Time is not available.
What should the administrator do to enable Point in Time Recovery?
- A. Use Brass SLA & update the Log catch up frequency.
- B. Use an SLA that supports Continuous Log retention.
- C. Update the TM schedule to perform DB Log catch up.
- D. Take a Manual snapshot and use it for DB recovery.
Answer: B
Explanation:
Point in Time Recovery (PITR) is a feature of NDB that allows restoring a database to any point in time within the retention period of the SLA. To enable PITR, the SLA must support Continuous Log retention, which means that NDB captures and stores the database logs continuously. This allows NDB to replay the logs from the last snapshot to the desired point in time during the restore process. The other options do not enable PITR, but rather affect the frequency and timing of the snapshots and log catch up operations.
NEW QUESTION # 91
How can an administrator exclude Kernel patches for the Linux OS using the most efficient means?
- A. Exclude the appropriate repositories on the VM prior to patching.
- B. Exclude the appropriate repositories on the VM and reboot prior to patching.
- C. Define a pre-script to disable the repositories in the Patch Now advanced options
- D. Define a pre-script to disable the repositories in the Maintenance Window advanced options.
Answer: A
Explanation:
NDB supports Linux OS patching for database server VMs. Linux OS patching is performed by using the yum or apt package managers, depending on the Linux distribution. To exclude Kernel patches for the Linux OS, the administrator can disable or exclude the appropriate repositories on the VM prior to patching. This can be done by editing the yum.conf or apt.conf files, or by using the --disablerepo or --exclude options in the yum or apt commands. This way, the administrator can control which patches are applied to the VM without affecting other VMs or requiring additional scripts or reboots.
NEW QUESTION # 92
Which site needs to be reachable to ensure an NDB server can send periodic telemetry data to the central Nutanix repository over port 443?
- A. developers.nutanix.com
- B. insights.nutanix.com
- C. portal.nutanix.com
- D. download.nutanix.com
Answer: B
Explanation:
To ensure an NDB server can send periodic telemetry data to the central Nutanix repository, the server must be able to communicate with the Nutanix Insights platform over port 443 (HTTPS).
The insights.nutanix.com site is the designated endpoint for telemetry data, which includes usage statistics, health metrics, and other operational data sent to Nutanix for support and analytics purposes. This connectivity is a standard requirement for NDB to comply with Nutanix's telemetry and support framework, and port 443 is used for secure transmission.
NEW QUESTION # 93
Why are NDB database clones significantly faster than traditional database cloning?
- A. Distributed metadata lookup
- B. Zero-copy snapshot technology in Nutanix AOS
- C. Automatic I/O parameter tuning
- D. GPU-accelerated data duplication
Answer: B
Explanation:
Cloning uses AOS zero-copy snapshots, meaning data is not actually duplicated; only changed blocks require additional storage.
NEW QUESTION # 94
An administrator needs to patch a PostgreSQL database server VM from version 13.4 to 13.8.
What is the first step within the NDB patching workflow to accomplish this task?
- A. Create a new Software Profile with PostgreSQL 13.8.
- B. Create a maintenance window and add this PostgreSQL server 13.8 to the queue.
- C. Create a new Database Parameters profile for PostgreSQL server 13.8.
- D. Create a Software Profile Version with PostgreSQL 13.8.
Answer: D
Explanation:
NDB supports patching for PostgreSQL database instances. Patching for PostgreSQL is validated on VMs provisioned by NDB (greenfield deployments). To patch PostgreSQL database server VMs, you must create a software profile version by uploading the PostgreSQL update file in NDB. You can then use the PostgreSQL update to patch other database server VMs or provision a new database server VM with the updated software profile. The first step in the NDB patching workflow is to create a software profile version with the desired PostgreSQL version.
NEW QUESTION # 95
What is required to create an NDB Software Profile?
- A. Installer package for database software
- B. Patch file for the installed databases
- C. Database server VM registered with NDB
- D. OS image registered with Prism Element
Answer: A
Explanation:
An NDB Software Profile is a template of the OS and database engine that you can use to provision or clone database server VMs using NDB. To create a software profile, you need to upload an installer package for the database software that you want to use, such as SQL Server or Oracle. The installer package must be compatible with the OS image that you have registered with Prism Element. You do not need a database server VM registered with NDB, a patch file for the installed databases, or an OS image registered with Prism Element to create a software profile. Those are required for other tasks, such as creating a software profile version, registering a database server VM, or provisioning a database server VM.
NEW QUESTION # 96
Which action should be completed before updating Oracle Database software?
- A. Perform rolling reboots of the Oracle Database VMs.
- B. Download the PSU from Oracle support.
- C. Verify CVMs have the required memory allocated.
- D. Verify the Oracle OS version is supported on AHV.
Answer: B
Explanation:
Before updating Oracle Database software, you need to download the Patch Set Update (PSU) from Oracle support. A PSU is a collection of critical and security patches for Oracle products.
You need to have a valid Oracle account and access to the My Oracle Support portal to download the PSU. You also need to check the compatibility and prerequisites of the PSU before applying it to your Oracle Database software. NDB uses out-of-place patching for Oracle, which means you need to create a new software profile version with the patched Oracle software and use it to update your existing databases.
NEW QUESTION # 97
An administrator has noticed that the automatic snapshot and log catch-up (automatic and manual) activities for a Time Machine are halted and manual snapshots cannot be created.
What status is this Time Machine in?
- A. READY
- B. OFFLINE
- C. PAUSED
- D. FROZEN
Answer: C
Explanation:
In NDB, a Time Machine manages snapshots and log catch-up operations for database protection and recovery. The scenario describes a Time Machine where automatic snapshot and log catch-up activities (both automatic and manual) are halted, and manual snapshots cannot be created. This indicates the Time Machine is in a PAUSED state.
In NDB, the Time Machine states are:
FROZEN: A temporary state during specific operations (e.g., cloning), but it doesn't halt all activities permanently.
OFFLINE: Indicates the Time Machine is unavailable or not operational, often due to connectivity or configuration issues, but this typically prevents access rather than just halting operations.
PAUSED: Explicitly stops all scheduled and manual snapshot/log activities, often manually triggered by an administrator or due to an error condition (e.g., resource constraints). Operations resume when unpaused.
READY: The normal operational state where snapshots and log catch-ups occur as scheduled.
Given the inability to create manual snapshots alongside halted automatic operations, PAUSED is the most fitting status, as it reflects an intentional or enforced suspension of activities.
NEW QUESTION # 98
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 on Grid home only using NDB.
- B. The patch must have been applied using NDB.
- C. The database must be in read-only mode.
- D. The database must be shut down.
Answer: B
Explanation:
To roll back an Oracle patch on a database server VM using NDB, the patch must have been applied using NDB in the first place. This is because NDB maintains a patch inventory and history for each database server VM and database that it manages. NDB uses this information to determine which patches can be rolled back and how to revert the changes made by the patch. If the patch was applied outside of NDB, NDB would not have the patch information and would not be able to roll back the patch. Therefore, the patch must have been applied using NDB for the rollback action to be successful. The other options are not required for the rollback action. The database does not need to be shut down or in read-only mode, as NDB can perform the rollback operation online. The patch does not need to be applied on Grid home only, as NDB can roll back patches applied on both Grid home and Database home.
NEW QUESTION # 99
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. Click the Action icon to authorize one or more database server VMs.
- B. Click the Skip icon and choose to authorize later.
- C. Register or provision a new authorized server VIVI.
- D. Register or provision a new database VIVI
Answer: A
Explanation:
In the Nutanix Database Automation (NCP-DB) process, when a database administrator is tasked with creating a new clone of a running SQL database and there are no authorized servers available, the administrator should click the Action icon to authorize one or more database server VMs. This is because the Nutanix Database Service (NDB) requires authorized servers to perform operations such as cloning. The authorization process allows the NDB to manage and perform operations on the database server VMs.
NEW QUESTION # 100
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. Disable the services, create a software profile version, and provision an HA instance.
- B. Enable the services, create a software profile version, and provision an HA instance.
- C. Provision an HA instance with the services enabled.
- D. Provision an HA instance with the services disabled.
Answer: D
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.
NEW QUESTION # 101
What is the first step to install NDB on a Nutanix AHV cluster?
- A. Open Prism Central and enable the NDB VM in the settings menu.
- B. Download the QCOW2 image file of NDB and upload it to Prism Element.
- C. NDB is offered as a SaaS service and doesn't require any installations.
- D. Run LCM update to get the latest version of NDB.
Answer: B
Explanation:
To install NDB on a Nutanix AHV cluster, you need to download the QCOW2 image file of NDB from the Nutanix Support Portal and upload it to Prism Element. This image file contains the NDB software and the CentOS operating system. After uploading the image, you need to create a VM from the image and configure the network settings. Then, you need to register the NDB VM with Prism Central and enable the NDB service in the settings menu.
NEW QUESTION # 102
What is required to create an NDB Software Profile Version for PostgreSQL?
- A. Installer package for database software
- B. Patch file for the installed databases
- C. Database server VM registered with NDB
- D. Preconfigured OS image from Prism Element
Answer: A
Explanation:
To create an NDB Software Profile Version for PostgreSQL, it is required to have an installer package for the database software. This package forms the basis of the software profile, enabling the deployment and management of PostgreSQL instances.
NEW QUESTION # 103
Which disk is omitted from a Software Profile?
- A. System Page File
- B. System Database
- C. User Database
- D. SQL Installation
Answer: A
Explanation:
According to the Nutanix Database Automation (NCP-DB) course, a Software Profile is a template that defines the configuration of the database engine, such as the version, edition, features, and parameters. It also specifies the disk layout for the database installation, such as the size, type, and mount point of each disk. However, the System Page File disk is omitted from the Software Profile, as it is automatically created by the NDB service based on the memory size of the database server VM. The other options are included in the Software Profile, as they are essential for the database operation and performance.
NEW QUESTION # 104
Which ports must be open between the NDB server and Controller VMs to facilitate iSCSI connections?
- A. 80 and 443
- B. 3205 and 3260
- C. 5985 and 5986
- D. 22 and 9440
Answer: B
Explanation:
According to the Nutanix Database Automation (NCP-DB) course, the ports 3205 and 3260 are required for iSCSI connections between the NDB server and the Controller VMs. Port 3205 is used for the NDB iSCSI initiator service, which initiates the iSCSI sessions and sends SCSI commands to the Controller VMs. Port 3260 is used for the iSCSI target service, which listens for incoming iSCSI requests and provides access to the storage devices on the Controller VMs. The other options are not related to iSCSI connections. Port 22 is used for SSH, port 9440 is used for Prism Central, port 80 is used for HTTP, port 443 is used for HTTPS, port 5985 is used for WinRM HTTP, and port 5986 is used for WinRM HTTPS.
NEW QUESTION # 105
......
NCP-DB-6.10 Questions Truly Valid For Your Nutanix Exam: https://certkingdom.practicedump.com/NCP-DB-6.10-practice-dumps.html