Updated Feb 08, 2025 Test Engine to Practice Test for NCP-DB-6.5 Valid and Updated Dumps
Exam Questions for NCP-DB-6.5 Updated Versions With Test Engine
Nutanix NCP-DB-6.5 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
NEW QUESTION # 50
Which two statements best describe the features and functionality of Era Oracle patching? (Choose two.)
- A. Era patching for Oracle databases has automatic rollback if any of the steps in the patching workflow fails.
- B. Era Oracle fleet patching can be rolled back if issues ere encountered after successful patching.
- C. Era patching can be automated using REST API/CLI for scheduled patching many Oracle servers in a fleet patching scenario,
- D. Era does not require native Oracle Utility OpatchAuto to create the patch profile,
Answer: A,C
Explanation:
Nutanix Era provides a unified database operating model that delivers simplicity, performance, availability, and security across private and public clouds1. It standardizes your Oracle database ecosystem by mass patching the databases with one-click simplicity2. This includes the following features:
Automated Patching: Era patching can be automated using REST API/CLI for scheduled patching many Oracle servers in a fleet patching scenario1. This allows for the standardization of your Oracle database ecosystem by mass patching the databases with one-click simplicity2.
Automatic Rollback: Era patching for Oracle databases has automatic rollback if any of the steps in the patching workflow fails1. This ensures that your databases remain secure and functional even if an issue arises during the patching process1.
NEW QUESTION # 51
An administrator needs to restore a source database from a snapshot. The database shares the source volume with multiple other databases.
How does NDB handle this database restore operation?
- A. Replaces source volume with specific db disks
- B. Replaces the source volume with the snapshot volume
- C. Copies all database files to the source volume
- D. Copies the specific database files to the source volume
Answer: D
Explanation:
The correct answer is A because NDB handles the database restore operation by copying the specific database files from the snapshot volume to the source volume, without affecting the other databases that share the same source volume. NDB uses a copy-on-write mechanism to create snapshots and clones, which means that only the changes made to the database files are stored in the snapshot or clone volume, while the original files are kept in the source volume. Therefore, when restoring a source database from a snapshot, NDB only needs to copy the specific database files that have been modified since the snapshot was taken, and overwrite them on the source volume. The other options are not correct because they either cause data loss or unnecessary data transfer. Option B is not correct because replacing the source volume with specific db disks would erase the other databases that share the same source volume, which is not desirable. Option C is not correct because replacing the source volume with the snapshot volume would also erase the other databases that share the same source volume, as well as any changes made to the source database after the snapshot was taken, which is not desirable. Option D is not correct because copying all database files to the source volume would be inefficient and unnecessary, as only the modified files need to be copied, and the other files are already present on the source volume.
Reference: Nutanix Database Management & Automation (NDMA) course, Nutanix Certified Professional
- Database Automation (NCP-DB) certification, Nutanix NCP-DB Certification Exam Syllabus and Study Guide, [Nutanix Support & Insights]
NEW QUESTION # 52
Refer to the exhibit.
An administrator attempts to provision their first clustered database environment with NDB. The operation fails with the Operation Error shown in the exhibit.
Which database engine was being deployed during this operation?
- A. MySQL
- B. Microsoft SQL
- C. Oracle
- D. PostgreSQL
Answer: C
NEW QUESTION # 53
An administrator needs to make new VLANs available when provisioning a Oracle cluster database, which have been added to NDB via the Administration menu.
What needs to be done to expose the new VLANs for provisioning?
- A. Create a new Network Profile with the new VLANs.
- B. Update Prism Element with the new VLAN and discover it in NDB.
- C. Create a new VLAN in Prism Element and discover it in NDB.
- D. Update the Network Profile to include the new VLANs.
Answer: B
NEW QUESTION # 54
An administrator needs to restore a source database from a snapshot. The database shares the source volume with multiple other databases.
How does NDB handle this database restore operation?
- A. Replaces source volume with specific db disks
- B. Replaces the source volume with the snapshot volume
- C. Copies all database files to the source volume
- D. Copies the specific database files to the source volume
Answer: D
NEW QUESTION # 55
How can an administrator exclude Kernel patches for the Linux OS using the most efficient means?
- A. Define a pre-script to disable the repositories in the Patch Now advanced options
- B. Define a pre-script to disable the repositories in the Maintenance Window advanced options.
- C. Exclude the appropriate repositories on the VM and reboot prior to patching.
- D. Exclude the appropriate repositories on the VM prior to patching.
Answer: A
NEW QUESTION # 56
What behavior is observed when applying patch profiles as a Super Admin?
- A. Unpublished patches can be applied.
- B. Hidden patches can be applied.
- C. Deprecated patches can be applied.
- D. Published patches cannot be applied if currently deprecated.
Answer: D
Explanation:
In the context of Nutanix Database Automation (NCP-DB), a Super Admin has the authority to apply patch profiles. However, if a patch is marked as deprecated, even if it's published, it cannot be applied.
This is because deprecation is a status that indicates the patch is outdated or has been superseded by a newer version, and thus should not be used1. This behavior ensures that only the most up-to-date and secure patches are applied to the system, maintaining the integrity and security of the database environment1.
NEW QUESTION # 57
Which statement is true regarding the NDB alert retention feature?
- A. NDB supports retention at the grouped policy.
- B. NDB supports alert retention globally.
- C. NDB supports retention at the registered cluster.
- D. NDB supports retention at the individual policy.
Answer: B
Explanation:
The NDB alert retention feature allows the database administrator to configure the duration for which the NDB alerts are stored and displayed in the NDB instance. The NDB alert retention feature supports alert retention globally, meaning that the same retention period applies to all the alerts generated by the NDB instance, regardless of the source cluster, policy, or operation. The database administrator can set the alert retention period from 1 day to 365 days, or choose to retain the alerts indefinitely. The NDB alert retention feature helps to manage the storage space and the visibility of the NDB alerts.
The NDB alert retention feature does not support retention at the individual policy, grouped policy, or registered cluster level. The NDB alert retention feature applies to all the alerts uniformly, and does not allow the database administrator to specify different retention periods for different policies or clusters.
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.
NEW QUESTION # 58
Which two network prerequisites are required to deploy an Era instance in production? (Choose two.)
- A. NTP, DNS servers, gateway, and subnet mask must be available and visible to Ere,
- B. An SMTP server and details must be provided for notifications.
- C. One static IP address must be available and changed using CLI after VM deployment.
- D. A storage container must be available es a prerequisite.
Answer: A,C
Explanation:
Option A: Nutanix Era requires network prerequisites like NTP, DNS servers, gateway, and subnet mask to be available and visible. These are essential for the proper functioning of the Era instance1. Option B:
One static IP address must be available and can be changed using CLI after VM deployment. This is necessary for the Era VM to communicate with other components in the network1.
Option C: While a storage container is necessary for Nutanix infrastructure, it is not a network prerequisite specifically for deploying an Era instance.
Option D: An SMTP server and details are typically used for sending notifications, but they are not a network prerequisite for deploying an Era instance. They are more related to the operational aspect post- deployment.
NEW QUESTION # 59
What is the purpose of Data Access Management policies in NDB Multi-Cluster?
- A. To remove data accessibility of a time machine across all registered Nutanix clusters in NDB
- B. To perform snapshot operations on a single Nutanix cluster
- C. To register multiple Nutanix clusters in NDB
- D. To manage time machine data availability across all registered Nutanix clusters in NDB
Answer: D
Explanation:
Data Access Management (DAM) policies are a feature of NDB Multi-Cluster that allows you to control the access and availability of time machine data across different Nutanix clusters. You can use DAM policies to specify which clusters can access the time machine data of a source database, and which clusters can replicate the time machine data for backup or disaster recovery purposes. DAM policies help you to optimize the storage and network resources, as well as ensure the security and compliance of your database workloads. The purpose of DAM policies is not to register multiple Nutanix clusters in NDB, as this is done by using the Add Cluster option in the NDB settings page. The purpose of DAM policies is also not to perform snapshot operations on a single Nutanix cluster, as this is done by using the Time Machine feature in the NDB dashboard. The purpose of DAM policies is also not to remove data accessibility of a time machine across all registered Nutanix clusters in NDB, as this is done by using the Delete option in the Time Machine page.
Reference: Nutanix Database Management & Automation Training Course, Module 6: Managing NDB Multi-Cluster, Lesson 2: Data Access Management Policies, Slide 3: Data Access Management Policies Nutanix Certified Professional - Database Automation (NCP-DB) 5 Exam, Section 6: Administer an NDB Environment, Objective 6.5: Apply procedural concepts to create Data Access Management (DAM) policies
NEW QUESTION # 60
Which two options can NDB leverage to refresh a database clone? (Choose two.)
- A. Transaction logs
- B. Templates
- C. Snapshots
- D. Cerebro logs
Answer: A,C
NEW QUESTION # 61
When registering a new Nutanix Cluster with Era, what component is installed on the target Nutanix cluster via the Register Nutanix Cluster workflow?
- A. Repository Server
- B. Era Agent
- C. Era Sewer
- D. API Server
Answer: B
Explanation:
When registering a new Nutanix Cluster with Era, the Era Agent is installed on the target Nutanix cluster via the Register Nutanix Cluster workflow1. This agent is crucial for the functioning of the Nutanix Database Service (NDB) as it helps in managing and optimizing database workloads2. It also enables the application of procedural concepts to add Nutanix clusters to NDB2.
NEW QUESTION # 62
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. 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. - B. 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. - C. From the Time Machine, create a clone and paste the masking commands in the pre-clone field of the Pre-Post Commands section.
- 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: A
NEW QUESTION # 63
A user accidentally drops a table in the database at 10:42pm and the NDB administrator is tasked with restoring the table.
The snapshot schedule is set for every 30 minutes and the log catchup is set for every 15 minutes. The last available snapshot is at 10:30pm.
What is the optimal path to restore the table back with minimum data loss?
- A. Restore the 10:30pm snapshot.
- B. Restore the 10:42pm snapshot.
- C. Restore using point in time till 10:41pm.
- D. Restore using point in time till 10:42pm.
Answer: C
NEW QUESTION # 64
What must be completed within NDB before patching a Linux OS?
- A. Configure the repository.
- B. Update the database.
- C. Update the software profile version.
- D. Configure database high availability.
Answer: A
NEW QUESTION # 65
Which ports must be open between the NDB server and Controller VMs to facilitate iSCSI connections?
- A. 22 and 9440
- B. 5985 and 5986
- C. 3205 and 3260
- D. 80 and 443
Answer: C
NEW QUESTION # 66
Which disk is omitted from a Software Profile?
- A. SQL Installation
- B. System Database
- C. User Database
- D. System Page File
Answer: D
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 parameters1. It also specifies the disk layout for the database installation, such as the size, type, and mount point of each disk1. 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 VM1. The other options are included in the Software Profile, as they are essential for the database operation and performance1.
Reference: 1: Nutanix Database Automation (NCP-DB) course, Module 2: Database Provisioning, Lesson 2.3:
Software Profiles, slide 5
NEW QUESTION # 67
What is required to create an NDB Software Profile?
- A. Patch file for the installed databases
- B. OS image registered with Prism Element
- C. Installer package for database software
- D. Database server VM registered with NDB
Answer: C
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.
Reference: Nutanix Benefit 8: Integrated Self-service Database Management, Nutanix Support & Insights, section "NDB Software"
NEW QUESTION # 68
What is causing this issue?
- A. The VLAN is stretched
- B. The VLAN is DHCP
- C. The VLAN is IPAM
- D. The VLAN is static
Answer: A
NEW QUESTION # 69
When provisioning an PostgreSQL HA Instance, what are the minimum and maximum number of DB server VMs that can be deployed in a cluster?
- A. Min 1. Max 3
- B. Min 2, Max 6
- C. Min 2, Max 4
- D. Min 3, Max 5
Answer: C
Explanation:
When provisioning a PostgreSQL HA Instance using NDB, the minimum and maximum number of DB server VMs that can be deployed in a cluster are 2 and 4, respectively. A PostgreSQL HA Instance is a database instance that provides high availability and fault tolerance for PostgreSQL databases using the Patroni framework. Patroni is a Python-based tool that manages PostgreSQL configuration and performs automatic failover and switchover operations. Patroni relies on a distributed consensus store, such as etcd, Consul, or ZooKeeper, to store and synchronize the cluster state and leader information. NDB supports etcd as the consensus store for PostgreSQL HA Instances. NDB allows the administrator to provision PostgreSQL HA Instances with different sizes and configurations, such as small, medium, large, or custom. The size of the PostgreSQL HA Instance determines the number of DB server VMs, the number of etcd nodes, the CPU, memory, and disk resources, and the replication factor of the database.
The minimum number of DB server VMs for a PostgreSQL HA Instance is 2, which corresponds to a small size instance. This configuration provides one leader and one follower DB server VM, and one etcd node. The maximum number of DB server VMs for a PostgreSQL HA Instance is 4, which corresponds to a large size instance. This configuration provides one leader and three follower DB server VMs, and three etcd nodes. The other options are not valid for a PostgreSQL HA Instance, as they either do not provide enough redundancy or exceed the supported limit of DB server VMs.
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: Provisioning PostgreSQL HA Instances Nutanix Database Service (NDB) User Guide, Chapter 4: Provisioning Databases, Section: Provisioning PostgreSQL HA Instances [PostgreSQL High Availability: Under the Hood - Nutanix.dev], Section:
PostgreSQL HAArchitecture and Components
NEW QUESTION # 70
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. data_percent
- B. database
- C. update
- D. extend_storage
Answer: D
NEW QUESTION # 71
What is required to create an NDB Software Profile Version for PostgreSQL?
- A. Preconfigured OS image from Prism Element
- B. Patch file for the installed databases
- C. Installer package for database software
- D. Database server VM registered with NDB
Answer: C
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.
Reference: Nutanix Database Automation documentation, particularly in the area of software profile creation and management for PostgreSQL.
NEW QUESTION # 72
......
NCP-DB-6.5 Exam Dumps - Free Demo & 365 Day Updates: https://www.torrentvce.com/NCP-DB-6.5-valid-vce-collection.html
Pass NCP-DB-6.5 Exam with Updated NCP-DB-6.5 Exam Dumps PDF: https://drive.google.com/open?id=168xbAaf2NONwBZcAcPz5T6E64rgeOOnG