The NCP-DB-6.10 PDF Dumps Greatest for the Nutanix Exam Study Guide!
Read Online NCP-DB-6.10 Test Practice Test Questions Exam Dumps
NEW QUESTION # 112
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. Remove Nutanix Cluster
- B. Update Nutanix Cluster
- C. Set VM-Host Affinity
- D. Unset VM-Host Affinity
Answer: C
Explanation:
The correct answer is B because setting VM-Host affinity ensures that the DB Server VMs are not migrated to another host during the LCM upgrade process. This way, the DB Server VMs can continue to serve the database requests without interruption. Option A is incorrect because updating the Nutanix cluster does not prevent the DB Server VMs from being moved to another host. Option C is incorrect because removing the Nutanix cluster from NDB will make the DB Server VMs unmanaged by NDB and lose the benefits of NDB features. Option D is incorrect because unsetting VM-Host affinity will allow the DB Server VMs to be migrated to another host during the LCM upgrade process, which may cause downtime or performance degradation.
NEW QUESTION # 113
While registering an Always on Availability Group database, an administrator selects the following option:
Multiple Databases as a Group with One Time Machine
Which statement is true regarding this chosen option?
- A. PITR-based SLAs are not supported for database groups.
- B. Point in Time Clones are not supported by Database Groups.
- C. PITR-based SLAs are supported for database groups containing mixed Recovery Model.
- D. PITR-based SLAs are not supported for database groups containing mixed Recovery Model
Answer: D
Explanation:
Nutanix Database Automation (NCP-DB) introduces the concept of MS SQL Server database groups, which allows multiple databases running in the same database instance to be grouped as one Time Machine entity. This applies to both single DB Server VM setups, standalone databases, as well as to Availability Group databases. However, it does not support Point In Time Recovery (PITR)-based Service Level Agreements (SLAs) for database groups containing mixed Recovery Models. This means that if the databases within the group have different recovery models, PITR-based SLAs cannot be applied to the group as a whole.
NEW QUESTION # 114
A database administrator is working with a cloned database and creates a clone removal schedule.
Which two default actions are taken on the cloned database? (Choose two.]
- A. NDB marks the cloned database as offline.
- B. NDB deletes the cloned database.
- C. NDB de-registers the cloned database.
- D. NDB deletes the cloned database VM.
Answer: B,C
Explanation:
When a database administrator creates a clone removal schedule in NDB, the system automates the cleanup of cloned databases based on the defined schedule (e.g., after a set retention period). The two default actions taken on the cloned database are:
NDB deletes the cloned database: The clone's data is removed from storage to free up space.
NDB de-registers the cloned database: The clone is removed from NDB's management inventory, ensuring it no longer appears in the GUI or is tracked.
NEW QUESTION # 115
A database admin logs into Era to manage an Oracle Database VM and sees a message Update Available on the Status of the Software Profile Version.
What should the database admin do?
- A. Schedule Ere to update the software profile to the latest version
- B. Create and update to the latest software profile version
- C. Era autocratically updates the software profile to the latest version
- D. Manually update the software profile to the latest version
Answer: D
Explanation:
In Nutanix Database Automation (NCP-DB), when an administrator logs into Era and sees a message "Update Available" on the Status of the Software Profile Version, it indicates that a newer version of the software profile is available. The administrator should manually update the software profile to the latest version. This process ensures that the database VM is running the most recent and compatible version of the software.
NEW QUESTION # 116
Refer to the exhibit. An administrator has configured unencrypted Active Directoiy access as shown in the exhibit. Which port should be allowed through the firewall to ensure NDB can communicate with Active Directoiy?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
The exhibit shows the configuration of unencrypted Active Directory (AD) access in NDB, with the
"Primary URL" set to ldap:// (indicating LDAP rather than LDAPS). Unencrypted LDAP communication uses port 389 by default. For NDB to communicate with Active Directory, this port must be allowed through the firewall to enable the NDB server to perform authentication and directory lookups using the specified service account (e.g., administrator).
NEW QUESTION # 117
An administrator needs to deploy a cumulative update (CU) for SQL Server. What steps would the administrator take to prepare this deployment with NDB?
- A. Apply the patch to the profile VM, then create a new Software Profile version using the profile VM as the source.
- B. Create a new Software Profile using the CU executable and publish that profile.
- C. Apply the patch to the profile VM, delete the existing Software Profile and create a new Software Profile using the profile VM as the source.
- D. Create a new Software Profile version using the CU executable and publish that version.
Answer: A
Explanation:
The correct answer is C because it follows the recommended procedure for applying a CU to a SQL Server Software Profile in NDB. By applying the patch to the profile VM, the administrator ensures that the CU is compatible with the existing Software Profile settings and configuration. By creating a new Software Profile version, the administrator preserves the previous version of the Software Profile for rollback purposes and allows the new version to be tested and published.
Option A is incorrect because it deletes the existing Software Profile, which may cause data loss and prevent rollback. Option B is incorrect because it does not apply the patch to the profile VM, which may result in errors or inconsistencies in the Software Profile. Option D is incorrect because it creates a new Software Profile instead of a new version, which may cause confusion and duplication.
NEW QUESTION # 118
When running the Linux prerequisites script, an administrator discovers that the only required argument is -t.
What does the -t argument specify?
- A. Operating System type
- B. NDB server IP
- C. Timeout interval
- D. Database engine
Answer: C
Explanation:
When running the Linux prerequisites script for NDB, the -t argument is a required parameter that specifies the timeout interval. This argument defines the maximum time (in seconds) the script will wait for certain operations (e.g., connectivity checks, package installations) to complete before timing out. This is critical during the preinstallation phase to ensure the environment is properly configured and responsive, avoiding indefinite hangs.
NEW QUESTION # 119
Which statement about NDB's unified patching capability is correct?
- A. Patching is supported only for SQL Server on Windows
- B. The patching workflow automatically snapshots and allows rollback if needed
- C. Patches must be manually uploaded; automatic discovery is not supported
- D. Patches can only be applied to newly deployed databases
Answer: B
Explanation:
Before applying a patch, NDB creates a Time Machine snapshot, allowing rollback in case of patch failure.
NEW QUESTION # 120
Which disk is omitted from a Software Profile?
- A. User Database
- B. System Database
- C. System Page File
- D. SQL Installation
Answer: C
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 # 121
An administrator needs the ability to clone a source database to a point in time. What is the lowest log frequency in minutes that can be configured in the Era IJI for log catchup operation?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
The log frequency in the Era IJI for log catchup operation can be configured to as low as 5 minutes. This allows the system to capture changes to the database at a high frequency, enabling more precise point-in-time recovery options. However, it's important to note that a higher frequency of log catchup operations can lead to increased system load. Therefore, the optimal frequency may vary depending on the specific requirements and capabilities of your system.
Please refer to the Nutanix Database Automation (NCP-DB) Learning documents for more detailed information.
NEW QUESTION # 122
A clone needs to be created on an existing database server, but there are no Authorized database servers defined to support the cloned database.
In which two ways can Database Server VMs be authorized during a Clone Create operation?
(Choose two.)
- A. During the database server provisioning process, flag the database server to be authorized for supporting cloned databases.
- B. During the Clone creation process, click the plus icon to authorize one or more database server VMs.
- C. Within the Database Server VM Summary window, update the database sever to be authorized for supporting cloned databases.
- D. Within Time Machine, use the Actions menu and Authorize Database Server VMs to identify which database server VMs to authorize for clones.
Answer: B,D
Explanation:
When creating a clone on an existing database server but no Authorized database servers are defined to support the cloned database, the administrator must authorize the necessary Database Server VMs. Two valid methods exist within NDB: (1) Using the Time Machine interface, the administrator can navigate to the Actions menu and select "Authorize Database Server VMs" to designate specific VMs for clone support, providing a proactive authorization step. (2) During the Clone creation process, the wizard includes an option (e.g., a plus icon) to authorize one or more database server VMs on the fly, streamlining the process if authorization is needed mid- operation.
NEW QUESTION # 123
An administrator created a database clone that is scheduled for removal on the last day of the month.
A request has been received to keep the clone for an additional 14 days. After selecting the desired clone, how should the administrator satisfy this task?
- A. Select Update and modify the Removal schedule.
- B. Update the Removal schedule to the end of the month.
- C. Update the Removal schedule to the desired date.
- D. Remove the Removal schedule, then add the desired removal schedule.
Answer: A
Explanation:
The Removal schedule is a feature of Nutanix Era that allows you to specify when a database clone will be automatically deleted. You can modify the Removal schedule of an existing clone by selecting the clone from the Clones page, clicking on the Update button, and changing the Removal schedule option to the desired date. This way, you can extend or shorten the lifespan of a clone as per your requirements. You do not need to remove the existing Removal schedule and add a new one, as this would be an unnecessary step. You also do not need to update the Removal schedule to the end of the month, as this would not meet the request of keeping the clone for an additional 14 days.
NEW QUESTION # 124
A DBA executed a script which corrupted an Oracle DB managed by NDB. After few minutes, the NDB administrator has been asked to create a copy of the DB using the latest available snapshot.
Which actions should be taken?
- A. Select the snapshot from Time Machine and create a new clone.
- B. Fail the Oracle cluster over to a surviving RAC node.
- C. Use Time Machine to create a clone from file-level database backup.
- D. Provision a new Oracle DB and perform log catch-up.
Answer: A
Explanation:
After a DBA's script corrupts an Oracle DB managed by NDB, the administrator needs to restore a clean copy using the latest available snapshot. The most straightforward action is to use the NDB Time Machine feature to select the most recent uncorrupted snapshot and create a new clone. This clone can serve as a restored version of the database, bypassing the corrupted data while leveraging existing snapshots for efficiency.
NEW QUESTION # 125
An administrator wants to migrate an existing MSSQL Server database to NDB.
How should the administrator complete this migration?
- A. Provision a new database server VM and database then migrate the data.
- B. Create a new database server VM and database then register it with NDB.
- C. Use Nutanix Move to migrate the database server VM.
- D. Backup your database VM and import it into Nutanix.
Answer: A
Explanation:
To migrate an existing Microsoft SQL Server (MSSQL) database to NDB, the recommended approach is to:
Provision a new database server VM and database: Use the NDB interface to provision a new VM and configure an MSSQL database instance on the Nutanix platform. This leverages NDB's automated provisioning capabilities to ensure compatibility with Nutanix infrastructure.
Migrate the data: Transfer the data from the existing MSSQL database to the newly provisioned database. This can be achieved using native MSSQL tools (e.g., backup/restore, log shipping, or replication) or NDB's data migration features, such as cloning or restoring from a backup, depending on the source environment.
NEW QUESTION # 126
A development team has requested that an administrator provide them a copy of the production Finance database. The business requires that any financial data is masked before going into development.
How should the administrator create a clone with masked data for the development environment?
- A. From the Time Machine, create a clone and paste the masking commands in the pre-clone field of the Pre-Post Commands section.
- B. 1. Create a masking script on the source DB VM, Dev VM or SW Profile VM.
2. Create the clone from the Time Machine and define the post-clone option with the full path\name of the masking script. - C. 1. Create a script to mask the data.
2. Create the clone from the Time Machine and define the post-clone option with the full path\name of the masking script. - D. From the Time Machine, create a clone and paste the masking commands in the post-clone field of the Pre-Post Commands section.
Answer: B
Explanation:
According to the Nutanix Database Automation (NCP-DB) course, the Pre-Post Commands section allows the administrator to specify custom scripts that can be executed before or after the clone operation. The masking script can be created on any of the VMs that have access to the source database, such as the source DB VM, the Dev VM, or the SW Profile VM. The script should contain the commands to mask the sensitive data in the Finance database, such as replacing the real values with dummy values or encrypting the data. The administrator can then create the clone from the Time Machine and define the post-clone option with the full path and name of the masking script. This will ensure that the script is executed after the clone is created, and the data is masked before it is available for the development team. The other options are not correct, as they either use the wrong field (pre-clone instead of post-clone), or do not specify where to create or store the masking script.
NEW QUESTION # 127
What must be configured in Prism Element to allow the NDB server and CVMs to facilitate iSCSI connections?
- A. Data Services IP
- B. Backplane IP
- C. Virtual IP
- D. Secondary DNS IP
Answer: A
Explanation:
To enable iSCSI connections between the Nutanix Database Service (NDB) server, Controller VMs (CVMs), and Prism Element, a Data Services IP must be configured in Prism Element. The Data Services IP acts as a cluster-wide address that facilitates iSCSI target discovery and connectivity. It is used by Nutanix Volumes (a block storage service) to present storage to external clients or services, such as the NDB server, via the iSCSI protocol. This IP ensures that iSCSI traffic is routed correctly and remains available even if a CVM fails, as ownership of the Data Services IP can move to another CVM in the cluster.
NEW QUESTION # 128
An administrator needs to provision a 3-node MSSQL Server AG with the following configuration:
- Two database server VMS including the primary replica on a local site
- A third database server VM on a remote site
How many IP addresses will the network at each site require?
- A. 1 Cluster VIP and 1 listener IP on the remote site
2 IPs in the local site and 1 on the remote site for the database server nodes
1 Cluster VIP on the local site
1 Cluster VIP and 1 Listener IP on the remote site
2 IPs in the local site and 1 on the remote site for the database server nodes - B. 1 Cluster VIP end I Listener IP on the local site
1 Cluster VIP and 1 Listener IP on the remote site
2 IPs in the local site and 1 on the remote site for the database server nodes - C. 2 Cluster VIP and 1 listener IP on the local site
- D. 1 Cluster VIP end I Listener IP on the local site
1 Listener IP on the local site
2 IPs in the local site and I on the remote site for the database server nodes
Answer: B
Explanation:
When setting up a 3-node MSSQL Server AG with two database server VMs on a local site and a third database server VM on a remote site, the network at each site will require the following IP addresses:
1 Cluster VIP and 1 Listener IP on the local site.
1 Cluster VIP and 1 Listener IP on the remote site.
2 IPs in the local site and 1 on the remote site for the database server nodes.
This configuration ensures that each node in the cluster has a unique IP address, and each cluster and listener also has a unique IP address. This is necessary for the proper functioning of the cluster and to ensure that all nodes can communicate with each other and with clients.
NEW QUESTION # 129
An NDB administrator would like to configure a database with a Time Machine protection mode that includes the Log Catchup operation.
What would be the most essential component to make such a configuration possible?
- A. A protection SLA with the Continuous Log Retention option must be selected.
- B. At least one snapshot must be taken daily on the database.
- C. The Log Catchup frequency must be selected and conform to RPO requirements.
- D. An SLA retention schedule must be identified for daily snapshots.
Answer: A
Explanation:
To configure a database with a Time Machine protection mode that includes the Log Catchup operation in NDB, the most essential component is a Service Level Agreement (SLA) that supports continuous log retention. The Log Catchup operation enables point-in-time recovery (PITR) by replaying transaction logs from a specified point, ensuring minimal data loss and meeting Recovery Point Objective (RPO) requirements. This functionality depends on the Time Machine being configured with an SLA that includes the "Continuous Log Retention" option, which ensures transaction logs are captured and retained continuously alongside snapshots.
NEW QUESTION # 130
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. Sysprep Windows image
- B. Compute profile
- C. Database parameters
- D. Windows domain profile
Answer: D
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.
NEW QUESTION # 131
......
NCP-DB-6.10 Certification All-in-One Exam Guide Jun-2026: https://actualtests.vceengine.com/NCP-DB-6.10-vce-test-engine.html
