[Dec-2024] Latest Nutanix NCP-DB-6.5 Certification Practice Test Questions
Verified NCP-DB-6.5 Dumps Q&As - 1 Year Free & Quickly Updates
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
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 system12. Please refer to the Nutanix Database Automation (NCP-DB) Learning documents for more detailed information.
NEW QUESTION # 51
An administrator needs to maintain five days of time-travel capability to any second, plus an additional seven days of discrete recovery at a daily interval.
How should the administrator define the Frequency and retention on the SLA?
- A. * Continuous log retention (days): 7
* Daily snapshot retention (days): 5 - B. * Weekly snapshot retention (weeks): 1
* Continuous log retention (days): 7 - C. * Continuous log retention (days): 5
* Weekly snapshot retention (weeks): 1 - D. * Daily snapshot retention (days): 7
* Continuous log retention (days): 5
Answer: D
Explanation:
The correct answer is D because it meets the requirements of maintaining five days of time-travel capability to any second and an additional seven days of discrete recovery at a daily interval. Continuous log retention allows the administrator to restore the database to any point in time within the specified number of days, while snapshot retention allows the administrator to restore the database to a specific point in time at a fixed interval. Therefore, by setting the daily snapshot retention to 7 days, the administrator can ensure that there is a discrete recovery point for each day of the week. By setting the continuous log retention to 5 days, the administrator can ensure that there is a time-travel capability to any second within the last five days. The other options do not meet the requirements because they either have less than five days of continuous log retention or less than seven days of snapshot retention.
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 Certified Professional - Database Automation (NCP-DB) datasheet
NEW QUESTION # 52
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 # 53
An administrator needs to provide the least-privilege access to a newly-hired engineer whose task is to add new VLANs or IP Pools in NDB.
Which role should the administrator select to complete this task?
- A. Database Infrastructure Administrator
- B. Super Administrator
- C. Database Administrator
- D. Infrastructure Administrator
Answer: D
Explanation:
An Infrastructure Administrator is a role in NDB that has the permission to manage network and storage resources, such as VLANs, IP Pools, and Storage Containers. This role is suitable for the engineer who needs to add new VLANs or IP Pools in NDB. The other roles have either more or less privileges than required for this task. A Database Administrator can manage databases and database server VMs, but not network and storage resources. A Super Administrator can manage all aspects of NDB, but this is more than the least-privilege access needed. A Database Infrastructure Administrator can manage both databases and network and storage resources, but this is also more than the least-privilege access needed.
Reference: Nutanix Support & Insights, section "NDB Roles and Permissions"
NEW QUESTION # 54
What is purpose of the NDB Database Agent service?
- A. Schedules and monitors the NDB-related operations.
- B. Hosts one or more source databases for the same time machine.
- C. Contains an instance of the database engine software.
- D. Temporarily stores the transaction logs.
Answer: A
NEW QUESTION # 55
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 database must be in read-only mode.
- B. The patch must have been applied using NDB.
- C. The patch must have been applied on Grid home only using NDB.
- D. The database must be shut down.
Answer: C
NEW QUESTION # 56
An Era-managed production MSSQL database crashed during a busy holiday weekend and the administrator has to restore the database to the most recent timestamp with an objective to reduce the restore time and minimize data loss.
What option should the administrator do to achieve this objective?
- A. Perform Restore Source Database by selecting the available snapshot.
- B. Perform Restore Source Database by selecting Restore time just before the database crash.
- C. Perform Restore Source Database by selecting most recent and include Tail log Backup
- D. Perform Restore Source Database by selecting the current time.
Answer: C
Explanation:
Nutanix Era is a database management solution that automates and simplifies database administration tasks such as provisioning, patching, cloning, and backup. In the event of a database crash, the most effective way to minimize data loss and reduce restore time is to perform a restore of the source database by selecting the most recent point in time and including the Tail log Backup12. The Tail log Backup includes all the transactions that have occurred since the last transaction log backup, which helps to minimize data loss. By selecting the most recent point in time for the restore, the administrator ensures that the database is restored to the state it was in just before the crash, thereby reducing the amount of data that needs to be reprocessed or reentered12. This approach aligns with the Nutanix Era's capabilities and best practices for database recovery12.
NEW QUESTION # 57
What is required to create an NDB Software Profile?
- A. Installer package for database software
- B. Database server VM registered with NDB
- C. OS image registered with Prism Element
- D. Patch file for the installed databases
Answer: B
NEW QUESTION # 58
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. 20 GB
- B. 10GB
- C. 15GB
- D. 5 GB
Answer: C
NEW QUESTION # 59
What is the most efficient way to get information on REST APIs for a task in Era?
- A. use API equivalent button in a workflow.
- B. Log into Ere VM end run to list ell the REST APIs.
- C. Navigate to and look for the desired
- D. Navigate to Swagger REST in Era GI-II.
Answer: A
Explanation:
. This is because it allows the database to be refreshed at the exact time specified (9:30 PM) with the most recent data. The other options either perform the snapshot before the desired time or do not specify when the snapshot would occur. Please note that the exact answer might depend on the specific database system and its capabilities. Always refer to the database's documentation for the most accurate information.
NEW QUESTION # 60
An administrator would like to provide a group of users the ability to add a new VLAN or IP Pool in Era.
What minimum role should the administrator assign to this group?
- A. Database Admin
- B. Super Admin
- C. Database Infrastructure Admin
- D. Infrastructure administrator
Answer: D
Explanation:
In Nutanix Era, the ability to add a new VLAN or IP Pool is typically associated with the role of an Infrastructure Administrator12. This role has the necessary permissions to manage network configurations, including the creation of VLANs and IP Pools12. It's important to note that the exact permissions may vary depending on the specific configuration and policies of your organization12.
NEW QUESTION # 61
An administrator needs to migrate a large 1/0-intensive database that doesn't support multi-disk layout.
How should the storage be provisioned with Era to support the database while optimizing performance?
- A. Storage Spaces
- B. Volume Group with Load Balancing
- C. vDisk based provisioning
- D. Volume Group
Answer: D
Explanation:
In Nutanix Era, a Volume Group is the recommended storage provisioning method for a large I/O- intensive database that doesn't support a multi-disk layout1. A Volume Group in Nutanix Era is a collection of disks that can be managed as a single entity, providing a way to aggregate the storage capacity of multiple disks into a larger storage unit1. This allows for better performance optimization as it enables the database to leverage the combined I/O capabilities of all the disks in the group1. It's important to note that while other options like Load Balancing, Storage Spaces, and vDisk based provisioning can also be used in certain scenarios, a Volume Group is specifically designed for situations where a single, high-performance storage unit is required1.
NEW QUESTION # 62
A database administrator wants to define initialization variables for different types of database engines and workloads, like OLTP and DW.
What type of profile would be used?
- A. Software Profile Version
- B. Compute
- C. Network
- D. Database Parameters
Answer: D
Explanation:
The database parameters profile is used to define the initialization variables for different types of database engines and workloads, such as OLTP and DW. The database parameters profile allows the database administrator to customize the configuration settings for each database engine, such as Oracle, SQL Server, PostgreSQL, and MySQL. The database parameters profile can also be applied to different database operations, such as provisioning, cloning, and patching. The database parameters profile helps to optimize the performance and functionality of the databases according to the specific requirements and best practices of each database engine and workload.
The software profile version is used to define the software version and edition for each database engine, such as Oracle 19c Enterprise Edition or SQL Server 2019 Standard Edition. The software profile version is required for provisioning new databases and patching existing databases. The software profile version helps to ensure the compatibility and compliance of the databases with the supported software versions and editions.
The network profile is used to define the network configuration and security settings for the database server VMs and the databases, such as the IP address, subnet mask, gateway, DNS, firewall rules, and SSL certificates. The network profile is required for registering new database server VMs and provisioning new databases. The network profile helps to ensure the connectivity and protection of the database server VMs and the databases within the network environment.
The compute profile is used to define the compute resources and storage policies for the database server VMs and the databases, such as the CPU, memory, disk size, disk type, compression, deduplication, and replication factor. The compute profile is required for provisioning new databases and cloning existing databases. The compute profile helps to ensure the availability and efficiency of the database server VMs and the databases within the Nutanix cluster.
Reference: Nutanix Database Management & Automation Training Course, Module 4: Nutanix Era Configuration, Lesson 4.1: Nutanix Era Configuration, slides 6-9.
Nutanix Database Management & Automation Training Course, Module 5: Nutanix Era Operations, Lesson 5.1: Nutanix Era Operations, slides 5-8, 11-12, 15-16.
NEW QUESTION # 63
What must be completed within NDB before patching a Linux OS?
- A. Update the software profile version.
- B. Configure the repository.
- C. Update the database.
- D. Configure database high availability.
Answer: B
NEW QUESTION # 64
Which ports must be open between the NDB server and Controller VMs to facilitate iSCSI connections?
- A. 5985 and 5986
- B. 80 and 443
- C. 22 and 9440
- D. 3205 and 3260
Answer: D
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 VMs1. Port 3205 is used for the NDB iSCSI initiator service, which initiates the iSCSI sessions and sends SCSI commands to the Controller VMs1. 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 VMs1. 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 HTTPS2.
Reference: 1: Nutanix Database Automation (NCP-DB) course, Module 2: Database Provisioning, Lesson 2.2: Database Engine Installation, slide 13
2: Nutanix NCP-DB Certification Exam Sample Questions, Question 18, Answer
NEW QUESTION # 65
Which disk is omitted from a Software Profile?
- A. SQL Installation
- B. System Database
- C. System Page File
- D. User Database
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 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 # 66
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. Update the Network Profile to include the new VLANs.
- B. Create a new Network Profile with the new VLANs.
- C. Update Prism Element with the new VLAN and discover it in NDB.
- D. Create a new VLAN in Prism Element and discover it in NDB.
Answer: C
NEW QUESTION # 67
An administrator has configured NDB HA across multiple Nutanix clusters.
Which failure scenario will require manual interaction for the recovery?
- A. More than one HA proxy VM is down.
- B. NDB Server process is down.
- C. More than one API Server VM is down.
- D. One repository VM is down.
Answer: C
NEW QUESTION # 68
What is the terminology used for registering an existing database with Era?
- A. Source Database
- B. Greenfield Database
- C. Brownfield Database
- D. Cloned Database
Answer: C
Explanation:
In the context of Nutanix Era, the term "Brownfield Database" is used to refer to an existing database that is registered with Era1. This process allows Era to bring Database as a Service (DBaaS) capabilities to your existing database2. It's important to note that before you register a database with Era, certain prerequisites must be met3.
NEW QUESTION # 69
......
Latest 2024 Realistic Verified NCP-DB-6.5 Dumps - 100% Free NCP-DB-6.5 Exam Dumps: https://actualtests.realvalidexam.com/NCP-DB-6.5-real-exam-dumps.html
