NCP-DB-6.5 Actual Questions 100% Same Braindumps with Actual Exam!
NCP-DB-6.5 Study Material, Preparation Guide and PDF Download
NEW QUESTION # 26
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 using point in time till 10:42pm.
- B. Restore using point in time till 10:41pm.
- C. Restore the 10:30pm snapshot.
- D. Restore the 10:42pm snapshot.
Answer: A
Explanation:
The optimal path to restore the table back with minimum data loss is to use the point in time restore feature of NDB, which allows the administrator to restore the database to a specific point in time based on the available snapshots and logs1. By restoring using point in time till 10:42pm, the administrator can recover the table just before it was dropped by the user, and minimize the data loss to the least possible amount1. The other options are not optimal, as they either involve restoring an older snapshot, which may result in more data loss, or restoring a non-existent snapshot, which is not possible.
Reference: 1: Nutanix Database Automation (NCP-DB) course, Module 6: Database Recovery, Lesson
6.2: Point in Time Restore, slide 5
NEW QUESTION # 27
What does an NDB compute profile contain?
- A. Windows domain name (FQDN), domain user, and password.
- B. An image of the database and operating system generated from the registered database server VM.
- C. VLAN that the new database server VM will use.
- D. vCPUs, cores per vCPU, and the amount of memory for the database server VM.
Answer: D
NEW QUESTION # 28
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: C
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 system12. Please refer to the Nutanix Database Automation (NCP-DB) Learning documents for more detailed information.
NEW QUESTION # 29
A customer has NDB configured to create snapshots of their production databases every 4 hours.
A developer requires a copy of the current production data at 7:00am of each day.
What is the most efficient way to meet this requirement?
- A. Configure a done with a daily Data Refresh Schedule at 7:00am.
- B. Run a script which creates a clone from the latest snapshot at 7:00am.
- C. Configure Time Machine to create a clone from a daily snapshot at 7:00am.
- D. Authorize the developer in RBAC to create clones as required.
Answer: D
NEW QUESTION # 30
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. Database
- B. Backup
- C. System
- D. Page
Answer: D
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.
Reference: Nutanix Database Management & Automation Training Course, Module 2: Deploying and Configuring an NDB Solution, Lesson 2: Configuring an NDB Instance, Slide 13: Registering Database Server VMs Nutanix Certified Professional - Database Automation (NCP-DB) 5 Exam, Section 4: Operate and Maintain an NDB Environment, Objective 4.1: Apply procedural concepts to register database server VMs and databases
NEW QUESTION # 31
Which two processes should an administrator take to create a software profile version for a newly- released Oracle ISc patch? (Choose two.)
- A. 1. Create new software profile version from the original software profile using the cloned VM where OPatchAuto was run successfully using Era Gul.
2. Mark the original patch profile as deprecated. - B. 1. Download the required patch from Microsoft Support.
2. Apply the patch to the Oracle Home/Grid Home one cloned VM of the gold image using OPatchAuto utiliv.
3. Ensure success of patch application. - C. 1. Download the required patch from MyOracle Support
2. Apply the patch to the Oracle Home Grid Home on a cloned VM of the gold image using O PatchAuto
3. Ensure success of patch application - D. 1. Create new software profile version from the original software profile using the cloned VM where OPatchAuto was run successfully using Era Gul.
2. Mark the original patch profile as hidden.
Answer: C,D
Explanation:
To create a software profile version for a newly-released Oracle ISc patch, an administrator should follow these steps:
Download the required patch from MyOracle Support1. This is because Oracle patches are typically available from MyOracle Support, not Microsoft Support.
Apply the patch to the Oracle Home/Grid Home on a cloned VM of the gold image using OPatchAuto1.
OPatchAuto is a utility provided by Oracle that automates the process of applying patches to a database.
Ensure success of patch application1. It's important to verify that the patch has been applied successfully to avoid any issues down the line.
Create a new software profile version from the original software profile using the cloned VM where OPatchAuto was run successfully using Era GUI1. This step is necessary to ensure that the new patch is included in the software profile.
Mark the original patch profile as hidden1. This step is optional but can be useful for keeping the software profile clean and organized.
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.
NEW QUESTION # 32
Refer to the exhibit.
A request is received to provision a new Oracle SIHA DB & VM to test ASMLIB on OEL79 and Oracle 19c. When walking through the provisioning workflow, only ASMFD is available in the ASM Driver drop down.
What is necessary to provision the requested SIHA DB and DB VM with ASMLIB?
- A. Update the software profile to include the ASMLIB driver.
- B. Update the NDB driver config to enable ASMLIB for Oracle.
- C. Install ASMLIB on the NDB server.
- D. Install ASMLIB on the database server.
Answer: C
NEW QUESTION # 33
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
Explanation:
The correct answer is C because a stretched VLAN is a VLAN that spans across multiple Nutanix clusters, which may cause network conflicts or latency issues when starting the database server. Option A is incorrect because a DHCP VLAN is a VLAN that uses dynamic IP address allocation, which does not affect the database server startup. Option B is incorrect because a static VLAN is a VLAN that uses fixed IP address allocation, which also does not affect the database server startup. Option D is incorrect because IPAM is not a type of VLAN, but a feature of NDB that allows managing IP addresses for database servers and databases.
Reference: The following sources provide more information about the VLAN and IPAM concepts and configuration in NDB:
Nutanix Database Management & Automation (NDMA) course, Module 2: Deploying and Configuring an NDB Solution, Lesson 2.4: Configuring NDB High Availability Nutanix Certified Professional - Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section 2 - Deploy and Configure an NDB Solution Nutanix Database Service (NDB) User Guide, Chapter 2: Deploying and Configuring an NDB Solution, Section 2.4: Configuring NDB High Availability Nutanix Database Service (NDB) User Guide, Chapter 8:
Administering an NDB Environment, Section 8.5: Managing Networks in NDB Nutanix Database Service (NDB) User Guide, Chapter 8: Administering an NDB Environment, Section 8.6: Managing IP Addresses in NDB
NEW QUESTION # 34
How can HA drivers for a Database VM be upgraded?
- A. One-click software upgrade
- B. Database software patching
- C. LCM driver upgrade
- D. Database VM OS patching
Answer: B
NEW QUESTION # 35
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. Update the Removal schedule to the end of the month.
- B. Select Update and modify the Removal schedule.
- C. Update the Removal schedule to the desired date.
- D. Remove the Removal schedule, then add the desired removal schedule.
Answer: D
NEW QUESTION # 36
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. Backup
- C. Database
- D. System
Answer: C
NEW QUESTION # 37
An online retail application requires data to be synchronized between multiple SQL Server databases.
This provides clearer reporting from multiple databases at the Same time for consistency at the end of each business day.
What is the best way to fulfill this requirement?
- A. Have all the databases in the same Availability Group and register databases in Era.
- B. Have all the databases present in the same DBVM and register databases in Era with Multiple Databases as a Group with one Time Machine.
- C. Have all the databases present in the same DBVM and register databases in Era.
- D. Have all the databases present in the same DBVM and register databases in Era with One Database with One Time Machine.
Answer: B
Explanation:
Nutanix Era enables you to clone your source databases and refresh the database clones by using snapshots or transaction logs1. For an online retail application that requires data to be synchronized between multiple SQL Server databases, having all the databases present in the same Database Virtual Machine (DBVM) and registering them in Era with Multiple Databases as a Group with one Time Machine would be the most efficient way to fulfill this requirement1. This approach allows for clearer reporting from multiple databases at the same time for consistency at the end of each business day1.
NEW QUESTION # 38
Which NDB feature collects logs and snapshots from databases?
- A. One-click Patching
- B. Database Restore
- C. Time Machine
- D. SLA
Answer: C
NEW QUESTION # 39
How should an administrator create a database clone using the Era IJI?
- A. Select Databases, Clones, Create Clone.
- B. Select Databases, Sources, select a source database and then choose Create Clone.
- C. Select Database Server VMs, select a database server VM and then choose Create Clone.
- D. Select Time Machines, select e source database end then choose Create Clone.
Answer: D
Explanation:
In Nutanix Database Automation (NCP-DB), the Time Machine feature is used for protecting databases and creating database clones. To create a database clone using the Era Interface, an administrator should select Time Machines, select a source database, and then choose Create Clone12. This process allows the administrator to create a copy of the source database at a specific point in time1.
NEW QUESTION # 40
Which two profiles are required to provision a new Oracle database through Era? (Choose two.)
- A. Compute
- B. Storage
- C. Memory
- D. Network
Answer: A,B
Explanation:
In the Nutanix Database Automation (NCP-DB) framework, provisioning a new Oracle database through Era requires the configuration of both a Compute and a Storage profile1. The Compute profile is used to define the resources allocated to the database, such as CPU and memory, while the Storage profile is used to specify the storage configuration for the database. These profiles are essential in ensuring that the database is provisioned with the necessary resources and storage configurations for optimal performance23.
NEW QUESTION # 41
What are two status values that can be set within the Alerts Dashboard? (Choose two.)
- A. Auto
- B. Data Resiliency
- C. Resolved
- D. Acknowledged
Answer: C,D
Explanation:
The correct answer is B and D because these are the two status values that can be set within the Alerts Dashboard in NDB. Resolved means that the alert has been fixed and no longer requires attention.
Acknowledged means that the alert has been seen and is being worked on. Option A is incorrect because Auto is not a status value, but a mode that automatically resolves alerts based on predefined rules. Option C is incorrect because Data Resiliency is not a status value, but a feature that ensures the availability and integrity of the data in NDB.
Reference: The following sources provide more information about the Alerts Dashboard and its status values in NDB:
Nutanix Database Management & Automation (NDMA) course, Module 3: Monitoring Alerts and Storage Usage Within an NDB Implementation, Lesson 3.1: Monitoring Alerts Nutanix Certified Professional - Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section 3 - Monitor Alerts and Storage Usage Within an NDB Implementation Nutanix Database Service (NDB) User Guide, Chapter 3: Monitoring Alerts and Storage Usage Within an NDB Implementation, Section 3.1: Monitoring Alerts
[Nutanix Support & Insights], Resolving All Alerts Related to a Database or Database Server VM in NDB
NEW QUESTION # 42
An administrator needs to provision a database for test purposes with a data protection policy that minimizes storage usage.
How should the administrator best complete this task?
- A. Select the built-in NONE SLA that is configured for no snapshot or log backup.
- B. Disable the SLA for this database during provisioning.
- C. Create a SLA that only leverages zero-byte snapshots.
- D. Create a custom SLA for this database that only retains 1 day of snapshots and bogs.
Answer: A
Explanation:
Nutanix Database Automation (NCP-DB) allows administrators to manage Service Level Agreements (SLAs) for databases. These SLAs define the data protection policies for databases. In this case, to minimize storage usage for a test database, the administrator should select the built-in NONE SLA. This SLA is configured for no snapshot or log backup, thus minimizing storage usage1.
NEW QUESTION # 43
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 2, Max 6
- B. Min 2, Max 4
- C. Min 3, Max 5
- D. Min 1. Max 3
Answer: B
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 # 44
What is the first step to add Time Machine (TM) data access to a Nutanix cluster?
- A. Register the required Nutanix clusters in ND8.
- B. Enable multi-cluster in NDB.
- C. Disable multi-cluster in ND8.
- D. Delete the TM data from the source database.
Answer: A
NEW QUESTION # 45
......
Nutanix NCP-DB-6.5 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
NCP-DB-6.5 Certification Study Guide Pass NCP-DB-6.5 Fast: https://www.passreview.com/NCP-DB-6.5_exam-braindumps.html
Free NCP-DB-6.5 Certification Sample Questions with Online Practice Test: https://drive.google.com/open?id=1p0c4ReuSniGR-Emfnq2H4_UqeO-_0o6n