Updated Aug 20, 2024 Verified NCP-DB dumps Q&As - 100% Pass [Q67-Q88]

Updated Aug 20, 2024 Verified NCP-DB dumps Q&As - 100% Pass

New 2024 Latest Questions NCP-DB Dumps - Use Updated Nutanix Exam

NEW QUESTION # 67
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. Disable the SLA for this database during provisioning.
• B. Select the built-in NONE SLA that is configured for no snapshot or log backup.
• C. Create a custom SLA for this database that only retains 1 day of snapshots and bogs.
• D. Create a SLA that only leverages zero-byte snapshots.

Answer: B

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 # 68
An administrator is asked to refresh a database everyday at 9:30PM with data from as close to the refresh time as possible.
What is the best way achieve this requirement?

• A. Schedule an SLA policy to perform snapshot everyday at 9.30PM.
• B. Schedule e log catchup everyday at 9:30PM.
• C. Schedule an SLA policy that performs a snapshot at 99M and log catchup for every 15 min.
• D. Schedule an SLA policy to perform snapshot everyday at 9PM.

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 # 69
How should an administrator modify the Alert Severity level within Era?

• A. From the dropdown menu choose Alerts > Policies. Then choose Update next to Alert Retention,
• B. From the dropdown menu choose Alerts > List. Select the message to be changed end choose Set Status to Resolved or Set Status to Acknowledged.
• C. From the dropdown menu choose Alerts Policies. Chose the Poliq to be modified and chose either Set Enabled or Set Disabled,
• D. From the dropdown menu choose Alerts Policies. Choose the Policy to be modified and set the desired severity level.

Answer: D

Explanation:
In Nutanix Era, an administrator can modify the Alert Severity level by navigating to the Alerts Policies from the dropdown menu. Once there, they can select the Policy that needs to be modified and set the desired severity level1. This allows the administrator to customize the alerts according to their requirements, ensuring that they are notified of the most critical events in their environment21.

NEW QUESTION # 70
For an NDB offline upgrade, which NDB CLI command should be used to upload the upgrade bundle?

• A. upload upgrade_bundle path=path_to_upgrade_bundle
• B. upgrade upload_bundle path=path_to_upgrade_bundle upload bundle
• C. path=path_to_upgrade_bundle
• D. path=path_to_upgrade_bundle upgrade bundle

Answer: A

Explanation:
For an NDB offline upgrade, you need to download the upgrade bundle from the Nutanix Support Portal and copy it to the NDB server. Then, you need to use the NDB CLI command upload upgrade_bundle with the path parameter to specify the location of the upgrade bundle file. This command will upload the upgrade bundle to the NDB server and verify its integrity. After uploading the upgrade bundle, you can use the upgrade command to perform the upgrade. References: Nutanix Support & Insights, Cisco Nexus Data Broker Deployment Guide, Release 3.10.x

NEW QUESTION # 71
Which ports are used by the NDB database agent for API calls?

• A. 3205 and 3260
• B. 443 and 9440
• C. 443 and 8080
• D. 5985 and 9389

Answer: B

Explanation:
The NDB database agent is a service that runs on each database server VM and communicates with the NDB instance. It uses port 443 for HTTPS API calls and port 9440 for Nutanix cluster API calls. These ports are required to be open on the database server VMs for NDB to function properly. References: Nutanix Database Management & Automation (NDMA), page 9; Ports and Protocols Reference Chart | Nutanix Community, section "Nutanix Database Service (NDB)"

NEW QUESTION # 72
How can Era be config90ured to send alert notifications to email recipients?

• A. From Administration, select Ere Service then go to configure notification widget and then click update to update SMTP server configuration
• B. From Administration select Era Service then go to Era service name and setup email notification,
• C. From Administration, select access control then add a user end setup email notification.
• D. From Administration select access control, select SMTP and then click update to update SMTP sewer configuration.

Answer: A

Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, to configure Era to send alert notifications to email recipients, you need to go to the Administration section, select Era Service, then go to the configure notification widget. From there, you can update the SMTP server configuration1. This allows Era to use the SMTP server to send alert notifications to the specified email recipients1.

NEW QUESTION # 73
A database administrator is tasked with creating a new clone of a running SQL database. During the clone process, there are no authorized servers are available.
What should the administrator do next?

• A. Register or provision a new database VIVI
• B. Click the Action icon to authorize one or more database server VMs.
• C. Click the Skip icon and choose to authorize later.
• D. Register or provision a new authorized server VIVI.

Answer: B

Explanation:
In the Nutanix Database Automation (NCP-DB) process, when a database administrator is tasked with creating a new clone of a running SQL database and there are no authorized servers available, the administrator should click the Action icon to authorize one or more database server VMs1. This is because the Nutanix Database Service (NDB) requires authorized servers to perform operations such as cloning1. The authorization process allows the NDB to manage and perform operations on the database server VMs1.

NEW QUESTION # 74
In NDB, which two Time Machine options are available when creating a database clone? {Choose two.)

• A. Restore point
• B. Snapshot
• C. Backup
• D. Point in time

Answer: B,D

Explanation:
The correct answer is A and D because these are the two Time Machine options that are available when creating a database clone in NDB. Point in time allows the user to specify a date and time to create a clone from a specific point in the database history. Snapshot allows the user to select a previously taken snapshot to create a clone from a consistent state of the database. Option B is incorrect because Restore point is not a Time Machine option, but a feature that allows the user to restore a source database to a previous point in time.
Option C is incorrect because Backup is not a Time Machine option, but a feature that allows the user to backup a database to a remote location.
References: The following sources provide more information about the Time Machine options and cloning features in NDB:
* Nutanix Database Management & Automation (NDMA) course, Module 4: Protecting Databases Using Time Machine, Lesson 4.2: Cloning Databases
* Nutanix Certified Professional - Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section
5 - Protect NDB-managed Databases Using Time Machine
* Nutanix Database Service (NDB) User Guide, Chapter 6: Protecting Databases Using Time Machine, Section 6.2: Cloning Databases
* [Nutanix Support & Insights], NDB Time Machine Under the Hood

NEW QUESTION # 75
An administrator needs to patch a PostgreSQL database server VM from version 13.4 to 13.8.
What is the first step within the NDB patching workflow to accomplish this task?

• A. Create a Software Profile Version with PostgreSQL 13.8.
• B. Create a new Database Parameters profile for PostgreSQL server 13.8.
• C. Create a new Software Profile with PostgreSQL 13.8.
• D. Create a maintenance window and add this PostgreSQL server 13.8 to the queue.

Answer: A

Explanation:
NDB supports patching for PostgreSQL database instances. Patching for PostgreSQL is validated on VMs provisioned by NDB (greenfield deployments). To patch PostgreSQL database server VMs, you must create a software profile version by uploading the PostgreSQL update file in NDB. You can then use the PostgreSQL update to patch other database server VMs or provision a new database server VM with the updated software profile. The first step in the NDB patching workflow is to create a software profile version with the desired PostgreSQL version.
References:
* Nutanix Database Automation (NCP-DB) Course Details, Section 4.1: NDB Patching Overview
* Nutanix Database Automation (NCP-DB) Certification Details, Objective 4.1: Perform Database Patching
* Nutanix Database Automation (NCP-DB) YouTube Playlist, Video 4.1: NDB Patching Overview
* Nutanix Database Automation (NCP-DB) User Guide, Section 4.4: Patch PostgreSQL Database Software

NEW QUESTION # 76
Which statement best describes what happens when a 3rd-party backup tool is chosen to manage log backups for Microsoft SQL in NDB?

• A. If exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will be supported, but snapshot-based recovery of the databases is not supported.
• B. Third-party backups vendors can continue to backup the archived logs from the database log destination.
  NDB will still be able to capture the logs, considering the log catch-up begins before the logs get backed up
• C. Third-party backups vendors can continue to backup the binary logs from the binary log location. NDB will still be able to capture the logs, considering the log catch-up begins before the logs get purged.
• D. If exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will not be supported, but snapshot-based recovery of the databases is supported.

Answer: B

Explanation:
NDB supports two modes of log backup management for Microsoft SQL databases: NDB-managed and
3rd-party managed. In the NDB-managed mode, NDB takes full control of the log backups and stores them in the Cerebro log location. In the 3rd-party managed mode, NDB allows the use of external backup tools to backup the logs from the database log destination. However, NDB still needs to capture the logs for its own operations, such as point-in-time recovery, clone refresh, and log catch-up. Therefore,NDB will periodically scan the database log destination and copy the logs to the Cerebro log location. This process requires that the log catch-up begins before the logs get backed up by the 3rd-party tool, otherwise NDB will miss some logs and the operations will fail. If the 3rd-party tool grants exclusive access to the logs, then NDB will not be able to capture them at all, and the operations will not be supported. References:
* Nutanix Database Management & Automation (NDMA) course, Module 5, Lesson 5.2 - Log Backup Management
* Nutanix Support & Insights, Nutanix NDB User Guide v2.5, Log Backup Management

NEW QUESTION # 77
How long is the default continuous recovery for the Gold SLA in Era Time Machine?

• A. 90 days
• B. 15 days
• C. 30 days
• D. 60 days

Answer: C

Explanation:
The default continuous recovery for the Gold SLA in Era Time Machine is 30 days1. This means that the system keeps a continuous recovery point for the last 30 days, allowing you to restore your database to any point within this period1.

NEW QUESTION # 78
An administrator is interested in using profiles to simplify the database provisioning process. The profile needs to include information related to the SQL service startup account, and the NDB worker service account.
Which profile would help the administrator accomplish this task?

• A. Database Parameter
• B. Windows Domain
• C. Software
• D. Network

Answer: B

Explanation:
The correct answer is A because the Windows Domain profile is the profile that includes information related to the SQL service startup account and the NDB worker service account. A Windows Domain profile is a collection of settings that define how NDB manages Windows-based database servers and databases. It contains the following information:
* The domain name and credentials to join the database server VMs to the domain
* The SQL service startup account and password to run the SQL Server service on the database server VMs
* The NDB worker service account and password to run the NDB Database Agent service on the database server VMs
* The SQL Server authentication mode to use for the databases
By using a Windows Domain profile, the administrator can simplify the database provisioning process by applying the same settings to multiple database server VMs and databases, without having to manually enter them each time. The other options are not correct because they describe different types of profiles that do not include information related to the SQL service startup account and the NDB worker service account. Option B is not correct because the Network profile is a profile that defines the network settings for the database server VMs, such as the IP address, subnet mask, gateway, DNS, and VLAN. Option C is not correct because the Database Parameter profile is a profile that defines the database parameters for the databases, such as the memory, CPU, storage, and performance settings. Option D is not correct because the Software profile is a profile that defines the software settings for the database server VMs and databases, such as the database engine version, edition, and features. References: Nutanix Database Management & Automation (NDMA) course, Nutanix Certified Professional - Database Automation (NCP-DB) certification, Nutanix NCP-DBCertification Exam Syllabus and Study Guide, Nutanix Database Services: Database modernization with Era - Now available

NEW QUESTION # 79
A request is received to refresh a database clone from a new manual snapshot. When the administrator attempts to create the new snapshot from the Time Machine, it is in a Frozen state.
What causes a Time Machine to enter the Frozen state and what are the administrator's options to complete the request?

• A. Cause: The Time Machine enters a Frozen state when the database is de-registered without removing the Time Machine.
  Resolution: To complete the request the database must be re-registered in NDB, create a new Time Machine and create a new clone.
• B. Cause: The Time Machine enters a Frozen state when the database is de-registered without removing the Time Machine.
  Resolution: To complete the request the database must be re-registered in NDB, this thaws the Time Machine and it resumes operation so the clone can be refreshed.
• C. Cause: The Time Machine enters a Frozen state when the database is de-registered without removing the Time Machine.
  Resolution: The Time Machine must be paused, then the database re-registered with a new Time Machine and a new clone created.
• D. Cause: The Time Machine enters a Frozen state after too many snapshot or log catchup failures.Resolution: Remediate the snapshot or log catchup failures, this thaws the Time Machine, allowing normal operations to continue and the request can be completed.

Answer: B

Explanation:
A Time Machine is a core construct of the copy data management service in NDB that captures and manages the data of a database to deliver a recovery point objective (RPO) SLA. A Time Machine can enter a Frozen state for various reasons, such as database de-registration, snapshot or log catchup failures, or manual intervention. When a Time Machine is in a Frozen state, it stops taking new snapshots and log backups, and cannot perform any clone, refresh, or restore operations. To resume the normal operation of a Time Machine, it must be thawed by resolving the root cause of the freeze. One of the common causes of a Time Machine freeze is when the database is de-registered from NDB without removing the Time Machine. This can happen when the administrator wants to move the database to a different NDB instance or cluster, or when the database is accidentally de-registered. In this case, the Time Machine becomes orphaned and frozen, and cannot be used for any operations. To complete the request to refresh a database clone from a new manual snapshot, the administrator must first re-register the database in NDB using the same database name and ID as before. This will automatically thaw the Time Machine and resume its operation. The administrator can then create a new manual snapshot from the Time Machine and use it to refresh the database clone. The other options are not correct, as they either require unnecessary steps or do not address the root cause of the freeze. References:
* Nutanix Certified Professional - Database Automation (NCP-DB) v6.5, Section 5 - Protect
* NDB-managed Databases Using Time Machine, Objective 5.1: Create, delete, and modify SLA retention policies
* Nutanix Database Management & Automation (NDMA) Course, Module 4: Nutanix Database Service (NDB) Data Protection, Lesson 4.1: Data Protection Overview, Topic: Time Machine Concepts
* Nutanix Support & Insights, TN-2101: Nutanix Database Service Time Machine Under the Hood, Section: Time Machine States and Transitions

NEW QUESTION # 80
Which two statements best describe the features and functionality of Era Oracle patching? (Choose two.)

• A. Era patching can be automated using REST API/CLI for scheduled patching many Oracle servers in a fleet patching scenario,
• B. Era does not require native Oracle Utility OpatchAuto to create the patch profile,
• C. Era Oracle fleet patching can be rolled back if issues ere encountered after successful patching.
• D. Era patching for Oracle databases has automatic rollback if any of the steps in the patching workflow fails.

Answer: A,D

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 # 81
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. Register the VM as a have' database server VM and then create a software profile using this newly registered VIVI.
• B. Merge the changes into an existing software profile.
• 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 # 82
Within NDB, an administrator needs to register a PostgreSQL database server VM with a database.
Where should the database data and log files be located in order to successfully complete this task?

• A. On the same disk as the operating system
• B. On the same mount point
• C. On the same disk as the binary installation
• D. On a separate mount point

Answer: D

Explanation:
To register a PostgreSQL database server VM with a database on NDB, the database data and log files must be located on a separate mount point from the operating system and the binary installation. This is because NDB uses the mount point as the identifier for the database server VM and the database. If the data and log files are on the same mount point as the operating system or the binary installation, NDB will not be able to recognize them as a valid database server VM or database. Therefore, the administrator should create a separate mount point for the data and log files and specify it during the registration process. References: Nutanix Database Automation (NCP-DB) Course Details, Nutanix Database Automation (NCP-DB) Certification Details, Nutanix Database Automation (NCP-DB) YouTube Playlist, [How to Allow Remote Access to PostgreSQL database], [5 Ways to Host PostgreSQL Databases], [Starting the Database Server].

NEW QUESTION # 83
What are two of the required steps to provision a new network in Clusters and extend it to Era? (Choose two.)

• A. Add a new.' subnet to the correct VPC.
• B. Add the new subnet end VLAN in Network Configuration in PE.
• C. Add the new VLAN in Ere Networks.
• D. Add the new network in Era Multi-Clu5ter Management

Answer: B,C

Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, to provision a new network in Clusters and extend it to Era, you need to:
B; Add the new subnet and VLAN in Network Configuration in PE1. C. Add the new VLAN in Era Networks1.
These steps ensure that the new network is properly configured in both the Nutanix environment and Era, allowing for seamless communication and operation. Please refer to the official Nutanix documentation and training materials for more detailed information1.

NEW QUESTION # 84
What is required to create an NDB Software Profile Version for PostgreSQL?

• A. Patch file for the installed databases
• B. Database server VM registered with NDB
• C. Installer package for database software
• D. Preconfigured OS image from Prism Element

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.References:Nutanix Database Automation documentation, particularly in the area of software profile creation and management for PostgreSQL.

NEW QUESTION # 85
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, only if the nori-Nutanix platform is little-endian platform.
• B. Yes, it is possible to upgrade database instance on a non-Nutanix platform.
• C. Yes, only if the nan-Nutanix platform is big-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 # 86
The NDB user interface can display which language option?

• A. Japanese
• B. German
• C. French
• D. Korean

Answer: A

Explanation:
The NDB user interface supports multiple languages, including English, Chinese, and Japanese. You can change the language preference in the NDB settings page. The NDB user interface does not support Korean, French, or German languages at this time. References:
* Nutanix Database Management & Automation Training Course, Module 1: Introduction to Nutanix Era, Lesson 1: Nutanix Era Overview, Slide 7: NDB User Interface
* Nutanix Certified Professional - Database Automation (NCP-DB) 5 Exam, Section 1: Describe NDB Concepts, Objective 1.6: Languages

NEW QUESTION # 87
An administrator was asked to change the snapshot schedule for a given database. The administrator discovered that the time machine is in a paused state.
How should the administrator change the schedule?

• A. Select the Time Machine; under Action select Update end define an appropriate schedule.
• B. Clone the Time Machine and define an appropriate schedule for the clone.
• C. Clone the database and define an appropriate schedule for the clone.
• D. Select Time Machine: Under actions Resume the Time Machine and then Update to define an appropriate schedule.

Answer: A

Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, an administrator can change the snapshot schedule for a given database by selecting the Time Machine, then under Action, select Update and define an appropriate schedule1. This is because the Time Machine in Nutanix Era allows you to specify the number of backups or snapshots the time machine should take, the time of day it takes those snapshots, and the day of the week it takes weekly or monthly backups1. These options help you build a complete schedule of time machine capture operations1. Even if the Time Machine is in a paused state, the administrator can still update the schedule1. Cloning the Time Machine or the database is not necessary for changing the snapshot schedule1.

NEW QUESTION # 88
......

Latest NCP-DB Exam Dumps Nutanix Exam from Training: https://www.trainingquiz.com/NCP-DB-practice-quiz.html

Pass Nutanix NCP-DB PDF Dumps Recently Updated 148 Questions: https://drive.google.com/open?id=1DNpOc00HT2AItoHYwATTtQX6ZpubBQbs