Latest Jul 10, 2024 NCP-DB Brain Dump: A Study Guide with Tips & Tricks for passing Exam
NCP-DB Question Bank: Free PDF Download Recently Updated Questions
NEW QUESTION # 77
While adding Time Machine data access to a Nutanix cluster, when is a storage container mapping needed
- A. When the source and destination database containers are different.
- B. When the source database and NDB provisioning container are the same.
- C. When the source database and NDB Server containers are different.
- D. When the source database and NDB VM are on the same container.
Answer: C
Explanation:
Time Machine data access is a feature of Nutanix Database Service (NDB) that allows you to access a point-in-time snapshot of a database without restoring it. To use this feature, you need to create a Data Access Management (DAM) policy that defines the access mode, the source database, the destination cluster, and the storage container mapping. The storage container mapping is needed when the source database and the NDB Server containers are different, because NDB needs to know where to store the metadata and the clone of the source database. If the source database and the NDB Server containers are the same, then NDB will use the same container for both the metadata and the clone. References:
* Nutanix Certified Professional - Database Automation (NCP-DB), Section 5 - Protect NDB-managed Databases Using Time Machine
* Database (NCP-DB) Exam Blueprint Guide - Nutanix, Page 9, Objective 5.6
* Nutanix Database Management & Automation (NDMA) course, Module 4, Lesson 4.2 - Data Access Management
NEW QUESTION # 78
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. System
- C. Backup
- 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 shouldbe 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. References:
* 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 # 79
Which disk is omitted from a Software Profile?
- A. System Page File
- B. SQL Installation
- C. User Database
- D. System Database
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 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. References:
* 1: Nutanix Database Automation (NCP-DB) course, Module 2: Database Provisioning, Lesson 2.3:
Software Profiles, slide 5
NEW QUESTION # 80
What is required to create an NDB Software Profile Version for PostgreSQL?
- A. Preconfigured OS image from Prism Element
- B. Database server VM registered with NDB
- C. Patch file for the installed databases
- D. Installer package for database software
Answer: D
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.References:Nutanix Database Automation documentation, particularly in the area of software profile creation and management for PostgreSQL.
NEW QUESTION # 81
What is the purpose of Data Access Management policies in NDBMulti-Cluster?
- A. To perform snapshot operations on a single Nutanix cluster
- B. To register multiple Nutanix clusters in NDB
- C. To manage time machine data availability across all registered Nutanix clusters in NDB
- D. To remove data accessibility of a time machine across all registered Nutanix clusters in NDB
Answer: C
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. References:
* 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 # 82
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: D
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 # 83
When preparing to provision multiple database server VMs, an administrator is tasked with configuring this set of VMs with the same number of cores per vCPU.
What is the easiest way for the administrator to accomplish this task?
- A. Create a Compute Profile and apply it to the VMs during provisioning.
- B. After provisioning the VMs. update the DEFAULT_OOB_COMPUTE Profile.
- C. Update the VMs after provisioning and enter the changes to the vCPU cores.
- D. Create a Windows Domain Profile that will synchronize the configurations.
Answer: A
Explanation:
A Compute Profile is a template that defines the CPU, memory, and disk resources for a database server VM.
By creating a Compute Profile with the desired number of cores per vCPU, the administrator can easily apply it to multiple VMs during provisioning, ensuring consistent and optimal performance. This also saves time and effort compared to updating the VMs individually or modifying the default profile after provisioning. References: Nutanix Database Automation (NCP-DB) Course Details, Nutanix Database Automation (NCP-DB) CertificationDetails, Nutanix Database Automation (NCP-DB) YouTube Playlist, How-to setup number of cores per CPU in a virtual machine.
NEW QUESTION # 84
What does the Era I-Click Provisioning service do?
- A. Customizable recovery SLAs for continuous RPOs
- B. Create space-efficient clones and zero-byte database clones
- C. Cloning with security inserting pre and post masking scripts
- D. Create space-efficient database snapshots
Answer: B
Explanation:
The Era One-Click Provisioning service in Nutanix Database Automation (NCP-DB) simplifies and automates database administration. It brings one-click simplicity to database provisioning and life-cycle management.
This service enables database administrators to provision, clone, and refresh the database clones to any point in time1. Specifically, it enables the creation of space-efficient clones and zero-byte database clones1. This is part of Era's copy data management service, which includes components like Time Machine, one-click cloning and refresh, and one-click backup21.
NEW QUESTION # 85
Which two network prerequisites are required to deploy an Era instance in production? (Choose two.)
- A. An SMTP server and details must be provided for notifications.
- B. NTP, DNS servers, gateway, and subnet mask must be available and visible to Ere,
- 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: B,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 # 86
Which NDB feature collects logs and snapshots from databases?
- A. Database Restore
- B. Time Machine
- C. One-click Patching
- D. SLA
Answer: B
Explanation:
The correct answer is B because the Time Machine feature of NDB collects logs and snapshots from databases and stores them in a distributed file system. The Time Machine enables the administrator to protect, clone, and restore databases using the SLA policies and the NDB UI or API. The Time Machine also manages the replication of database snapshots in an NDB multicluster environment. The other options are not correct because they describe different features or functions of NDB. Option A is not correct because Database Restore is an operation that uses the Time Machine to restore a source database or a clone to a previous point in time. Option C is not correct because SLA is a policy that defines the frequency and retention of database snapshots and logs. Option D is not correct because One-click Patching is a feature that allows the administrator to test, publish, and apply database patches using the NDB UI or API. References: 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 # 87
Which two options can NDB leverage to refresh a database clone? (Choose two.)
- A. Snapshots
- B. Templates
- C. Cerebro logs
- D. Transaction logs
Answer: A,D
Explanation:
NDB can leverage snapshots and transaction logs to refresh a database clone to the latest state of the source database. Snapshots are point-in-time copies of the database that are stored on the Nutanix cluster. Transaction logs are records of the changes made to the database after the snapshot was taken. NDB can use either snapshots or transaction logs, or a combination of both, to refresh a database clone. Cerebro logs and templates are not used for refreshing database clones. Cerebro logs are used for log catch-up operations, which are different from refresh operations. Templates are used for provisioning new databases, not for refreshing existing ones. References:
* Nutanix Database Management & Automation (NDMA) course, Module 4, Lesson 4.3 - Refreshing Clones
* Nutanix Support & Insights, Nutanix NDB User Guide v2.5, Clone Database Management
NEW QUESTION # 88
What is required to cre110ate a network profile in Era?
- A. The network must contain static IP addresses.
- B. The network must provide IP address management.
- C. The network must be managed by Era.
- D. The network must be added to Era.
Answer: D
Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, to create a network profile in Era, the network must be added to Era1. This is because Era needs to have control over the network in order to manage the databases effectively1. Once the network is added to Era, it can be used for various operations such as provisioning new databases, managing existing databases, and more1.
NEW QUESTION # 89
In an Oracle upgrade scenario using Era. if the source database is on a nor-Nutanix platform, is it possible to upgrade it with an Era workflow?
- A. Yes, it is possible to upgrade database instance on a non-Nutanix platform.
- B. Yes, only if the nan-Nutanix platform is big-endian platform,
- C. Yes, only if the nori-Nutanix platform is little-endian platform.
- D. No, the database instaru:e must be Era managed to Be upgraded
Answer: D
Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, Nutanix Era is a database management tool that automates and simplifies database operations, including provisioning, patching, upgrading, and more1. However, for a database to be managed by Era, it must be registered with Era1. This means that if a database is on a non-Nutanix platform, it cannot be directly upgraded using an Era workflow. It must first be migrated to a Nutanix platform and registered with Era before it can be managed and upgraded using Era1.
NEW QUESTION # 90
An administrator has been tasked with restoring an Oracle database that has recently failed. The administrator must restore the database to the prior day's state.
Which two restore options could be used? (Choose two.)
- A. Tail Logs Backup
- B. Point in Time
- C. Snapshot
- D. Most Recent Time Available
Answer: B,C
Explanation:
The correct answer is B and D because they are the two restore options that can be used to restore an Oracle database to the prior day's state using Nutanix Era. A snapshot is a point-in-time copy of a database that is stored in the Era Time Machine, which is a distributed file system that collects logs and snapshots from databases. A point in time is a specific moment in time within the retention period of the SLA policy that is applied to the database. By using either of these options, the administrator can select the snapshot or the point in time that corresponds to the prior day's state and restore the database from it. The other options are not correct because they are not restore options that are available in Nutanix Era. Option A is not correct because Most Recent Time Available is not a restore option, but a clone option that creates a clone of the database from the most recent snapshot or log backup. Option C is not correct because Tail Logs Backup is not a restore option, but a backup option that captures thetransaction logs of the database that have not been backed up by the SLA policy. References: Nutanix Database Management & Automation (NDMA) course, Nutanix Certified Professional - Database Automation (NCP-DB) certification, Nutanix NCP-DB Certification Exam Syllabus and Study Guide, [Nutanix Database Services: Database modernization with Era - Now available]
NEW QUESTION # 91
An administrator is trying to register a Nutanix cluster for Multi-Cluster provisioning.
The Era cluster is setup with following configuration:
* Era Multi-Cluster is enabled.
Era Server storage container and Era provisioning container are different on the Era cluster.
What should the administrator configure?
- A. Disks that span across Era Server storage container and Era provisioning container.
- B. Storage mapping between Era server container end remote container thet is used for provisioning DBs,
- C. Separate remote containers for provisioning Era Agent VM end database Server VMs.
- D. Storage mapping between Era container and a remote container that is not used for provisioning databases.
Answer: B
Explanation:
In a Nutanix Era setup where Multi-Cluster is enabled and the Era Server storage container and Era provisioning container are different on the Era cluster, the administrator should configure a storage mapping between the Era server container and the remote container that is used for provisioning databases1. This is because Nutanix Era uses the storage container specified during the registration of the Nutanix cluster for provisioning databases1. Therefore, a storage mapping needs to be established between the Era server container and the remote container used for provisioning to ensure that the databases are provisioned correctly1.
NEW QUESTION # 92
An administrator has applied an Oracle security patch to a database server VM registered in Era.
How do you make this change available to other existing database instances?
- A. Merge the changes into an existing software profile.
- B. Register the VM as a have' database server VM and then create a software profile using this newly registered VIVI.
- C. Create a n.. software profile version from the patched VM.
- D. Create a new software profile in Era from the patched VM.
Answer: D
Explanation:
Nutanix Database Service (NDB) uses software profiles for database patching to keep your databases secure and optimized1. When a new database is provisioned, it will be on your current environment's database version to maintain consistency and stop version sprawl1. Therefore, after an administrator has applied an Oracle security patch to a database server VM registered in Era, the change can be made available to other existing database instances by creating a new software profile in Era from the patched VM1.
NEW QUESTION # 93
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. Compute
- B. Database Parameters
- C. Software Profile Version
- D. Network
Answer: B
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.
References:
* 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 # 94
What step should be taken to make the profile available to all users:
- A. Create an Access Control role with the Create Profile right and assign to all users.
- B. Update the profile and set the status to Published.
- C. Create an Access Control group with the desired users and grant it the Database Admin role.
- D. Update the profile and set available state to All.
Answer: D
Explanation:
The correct answer is D because it allows the administrator to make the profile available to all users without requiring any additional permissions or roles. A profile is a collection of settings that define how NDB manages a database server or a database. By default, a profile is only available to the user who created it and the Database Admin role. To make a profile available to all users, the administrator can update the profile and set the available state to All. This will enable all users to view and use the profile for their database operations.
The other options are not correct because they either require additional steps or do not achieve the desired outcome. Option A is not correct because creating an Access Control role with the Create Profile right and assigning it to all users will only allow them to create their own profiles, not use the existing one. Option B is not correct because creating an Access Control group with the desired users and granting it the Database Admin role will only make the profile available to those users, not all users. Option C is not correct because updating the profile and setting the status to Published will not change the availability of the profile, only the state of the profile. A published profile is a profile that has been tested and verified by the administrator and is ready for use. Adraft profile is a profile that is still under development or testing and is not ready for use. References: 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 # 95
Which two ports can be used by external applications to make API calls to Era? (Choose two.)
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A,C
Explanation:
Nutanix Era is a database management system that provides API endpoints for automation and integration with external applications. These API calls are typically made over HTTPS for security, and the standard ports for HTTPS are 443 and 94401. Please note that the actual ports used can depend on the specific configuration of the Nutanix Era system. It's always a good idea to check the system's documentation or consult with the system administrator for the most accurate information.
NEW QUESTION # 96
An administrator is creating a Windows Domain profile in Era.
Which optional field can be skipped and provided during the provisioning process?
- A. Domain to join
- B. Domain Account
- C. SQL Service Startup Account
- D. Organizational Units
Answer: C
Explanation:
When an administrator is creating a Windows Domain profile in Era, the SQL Service Startup Account is an optional field that can be skipped and provided during the provisioning process. This account is used to start the SQL Server service when the server starts up. If this field is not provided during the creation of the Windows Domain profile, it can be provided later during the provisioning process1.
NEW QUESTION # 97
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. Authorize the developer in RBAC to create clones as required.
- B. Configure a done with a daily Data Refresh Schedule at 7:00am.
- C. Configure Time Machine to create a clone from a daily snapshot at 7:00am.
- D. Run a script which creates a clone from the latest snapshot at 7:00am.
Answer: C
Explanation:
Time Machine is a feature of Nutanix Era that allows you to create and manage snapshots of your databases.
You can use Time Machine to create clones from any snapshot, either manually or automatically. You can also configure Time Machine to create clones from snapshots based on a schedule, such as daily, weekly, or monthly. This way, you can ensure that your clones are always up to date with the latest data from your production databases. In this scenario, the most efficient way to meet the developer's requirement is to configure Time Machine to create a clone from a daily snapshot at 7:00am. This will save the developer's time and effort, as well as reduce the storage consumption by using the existing snapshots. References:
* Nutanix Database Management & Automation Training Course
* Nutanix Certified Professional - Database Automation datasheet
* Nutanix Certified Professional - Database Automation (NCP-DB) 5 Exam
NEW QUESTION # 98
Which statement describes a user in Era with the Database Infrastructure Admin role?
- A. The user is able to manage software profiles, Network Profiles. database Instance parameter profiles and time machine SLA
- B. The user is able to manage software profiles, Network Profiles. database parameter profiles end Time Machine SLAs,
- C. The user is able to manage software profiles, database parameter profiles and SLAs
- D. The user is able to manage database profiles, Network Profiles, database Instance parameter profiles and time machine SLA
Answer: B
Explanation:
The size of a database Time Machine in Nutanix Era is defined by the size of all snapshots and/or transaction logs maintained by Era1. The Time Machine leverages Nutanix's efficient snapshot technology to capture the state of the database at different points in time1. These snapshots, along with transaction logs that record changes between snapshots, constitute the data maintained by the Time Machine1. Therefore, the size of the Time Machine is determined by the total size of these snapshots and transaction logs1.
NEW QUESTION # 99
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. 5 GB
- B. 20 GB
- C. 15GB
- D. 10GB
Answer: D
Explanation:
When patching an Oracle Database Server VM, it's important to ensure that there is sufficient storage space allocated for the Grid home. A minimum of 10GB space is required for this purpose to accommodate the patching process without storage constraints.References:Nutanix Database Automation documentation, particularly in the sections discussing Oracle database server VM management and patching requirements.
NEW QUESTION # 100
......
New NCP-DB Exam Dumps with High Passing Rate: https://www.examdiscuss.com/Nutanix/exam/NCP-DB/
NCP-DB Certification Exam Dumps with 148 Practice Test Questions: https://drive.google.com/open?id=14zik_CuqDZazIIBREnpLBUrOzxvyu-vQ