nutanix‐database‐automation‐ncp‐db‐ncp‐db‐65‐exam‐questions_3 - itnett/FTD02H-N GitHub Wiki

Let's continue with the next set of 10 questions to further simulate the Nutanix Certified Professional - Database Automation (NCP-DB) exam.

Section 3: Monitor Alerts and Storage Usage Within an NDB Implementation

Question 21:
An administrator needs to monitor the storage usage of the NDB-managed databases. Which NDB dashboard widget provides this information?

  • A. Storage Capacity
  • B. Data Usage
  • C. Clone Data Age
  • D. Database Health

Correct Answer: B. Data Usage
Explanation: The "Data Usage" widget on the NDB dashboard provides insights into the amount of data utilized and saved, including storage usage for NDB-managed databases. Options A, C, and D do not provide specific information about storage usage.

Question 22:
If an NDB server process is down, what actions must be taken to recover?

  • A. Reboot the NDB server manually
  • B. Perform a full system restore
  • C. The process is auto-recoverable; wait for auto recovery
  • D. Call Nutanix support immediately

Correct Answer: C. The process is auto-recoverable; wait for auto recovery
Explanation: NDB is designed to automatically recover from a process failure. The system will attempt to restart the process without manual intervention. Options A, B, and D are not the initial steps needed.

Question 23:
Which ports must be open between the NDB server and Controller VMs to facilitate iSCSI connections?

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

Correct Answer: C. 3205 and 3260
Explanation: Ports 3205 and 3260 are used for iSCSI connections between the NDB server and Controller VMs. Port 3205 is used for the NDB iSCSI initiator service, while port 3260 is the standard iSCSI target port.

Question 24:
What is the shortest schedule interval possible for a database log catch-up in the NDB GUI?

  • A. 5 minutes
  • B. 10 minutes
  • C. 15 minutes
  • D. 30 minutes

Correct Answer: C. 15 minutes
Explanation: The shortest schedule interval for a log catch-up operation in NDB is 15 minutes, allowing for frequent updates and minimal data loss during recovery.

Question 25:
How can an administrator disable an alert policy in NDB?

  • A. Delete the alert policy from the system
  • B. Set the alert policy to "Resolved"
  • C. Navigate to Alerts > Policies > Set to Disabled
  • D. Change the alert policy severity to "Info"

Correct Answer: C. Navigate to Alerts > Policies > Set to Disabled
Explanation: To disable an alert policy, the administrator must navigate to the Alerts section, find the specific policy, and set it to "Disabled." Options A, B, and D do not correctly disable an alert policy.

Question 26:
By default, how long are resolved alerts retained in NDB before they are deleted?

  • A. 30 days
  • B. 90 days
  • C. 180 days
  • D. Indefinitely

Correct Answer: C. 180 days
Explanation: Resolved alerts in NDB are retained for 180 days by default, after which they are automatically deleted. This retention period ensures that alert history is available for a sufficient duration for analysis and reporting.

Question 27:
An administrator wants to configure email notifications for alerts in NDB. Where can this configuration be made?

  • A. Administration > Access Control > Email
  • B. Administration > NDB Service > Configure Notifications
  • C. Alerts > Notification Settings
  • D. Dashboard > Alerts > Configure Email

Correct Answer: B. Administration > NDB Service > Configure Notifications
Explanation: To configure email notifications for alerts, the administrator must navigate to the "Administration" section, then to "NDB Service," and select the "Configure Notifications" widget.

Question 28:
What does a Time Machine in a "FROZEN" state indicate?

  • A. The NDB agent is stopped on the database VM.
  • B. The database was de-registered from NDB without removing the associated Time Machine.
  • C. The database is paused on the database VM.
  • D. The Time Machine is paused, and all automatic snapshot and log catch-up activities are halted.

Correct Answer: B. The database was de-registered from NDB without removing the associated Time Machine.
Explanation: A Time Machine enters a "FROZEN" state when a database is de-registered from NDB, but its associated Time Machine is not removed, preventing further operations.

Question 29:
Which feature of the NDB Time Machine should be used when a developer needs an application-consistent copy of the data?

  • A. Log Catch-Up
  • B. Snapshot
  • C. Point-in-Time Recovery
  • D. Database Cloning

Correct Answer: B. Snapshot
Explanation: Snapshots provide application-consistent copies of data, ensuring that all data is captured in a state that is safe for recovery or cloning.

Question 30:
What is the default behavior of NDB when the log drive space usage reaches 80%?

  • A. Automatically expands the log drive size by 10%
  • B. Automatically deletes old logs to free up space
  • C. Automatically expands the log drive size by 20%
  • D. Stops the log catch-up operation until space is cleared

Correct Answer: C. Automatically expands the log drive size by 20%
Explanation: By default, NDB automatically expands the log drive size by 20% when the usage reaches 80%, ensuring that there is sufficient space to continue operations without interruption.

Section Summary:

This set of questions covers topics related to monitoring alerts, managing storage, and understanding the behavior of various NDB features such as Time Machine, log catch-up, and alert policies.

Would you like to proceed with the next set of questions, or focus on a different area of the exam? Let me know how you'd like to continue!

Let's continue with the next set of 10 questions to further simulate the Nutanix Certified Professional - Database Automation (NCP-DB) exam.

Section 4: Operate and Maintain an NDB Environment

Question 31:
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. 5GB
  • B. 10GB
  • C. 15GB
  • D. 20GB

Correct Answer: C. 15GB
Explanation: A minimum of 15GB of free space is recommended for the Grid home directory to accommodate Oracle patches and updates. This space is necessary to ensure that there is enough room for the patch files, temporary files, and any other data required during the patching process.

Question 32:
An administrator needs to restore a database provisioned on Storage Spaces. The virtual disks are shared with multiple databases. Which restore method is supported?

  • A. Disk-based restore via NDB GUI
  • B. Disk-based restore via NDB CLI
  • C. Copy-based restore via NDB GUI
  • D. Copy-based restore via NDB CLI

Correct Answer: C. Copy-based restore via NDB GUI
Explanation: A copy-based restore via the NDB GUI is the supported method for restoring a database provisioned on Storage Spaces, especially when virtual disks are shared among multiple databases. This approach allows for a precise restoration without affecting other databases.

Question 33:
Which ports must be open between the NDB server and Controller VMs to facilitate iSCSI connections?

  • A. 22 and 9440
  • B. 80 and 443
  • C. 3205 and 3260
  • D. 5985 and 5986

Correct Answer: C. 3205 and 3260
Explanation: Ports 3205 and 3260 are required for iSCSI connections between the NDB server and Controller VMs. Port 3205 is used for the NDB iSCSI initiator service, while port 3260 is used for the iSCSI target service.

Question 34:
An administrator needs to make new VLANs available when provisioning an 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 VLAN in Prism Element and discover it in NDB.
  • B. Update Prism Element with the new VLAN and discover it in NDB.
  • C. Update the Network Profile to include the new VLANs.
  • D. Create a new Network Profile with the new VLANs.

Correct Answer: C. Update the Network Profile to include the new VLANs.
Explanation: A Network Profile is a collection of network settings that are used to provision database server VMs in NDB. To make new VLANs available for provisioning, the administrator must update the existing Network Profile to include the new VLANs.

Question 35:
A customer requires high availability and fault tolerance for their PostgreSQL databases managed by NDB. Which feature should be used to meet this requirement?

  • A. Database Cloning
  • B. Log Catch-Up
  • C. Patroni
  • D. Replica Set

Correct Answer: C. Patroni
Explanation: Patroni is a template for PostgreSQL high availability and manages the state of the cluster and handles failover, ensuring that the PostgreSQL databases are always available and fault-tolerant.

Question 36:
What is the default behavior of NDB if a database server VM loses connectivity to the NDB server?

  • A. Automatic rollback to the last backup
  • B. Retry connection every 5 minutes
  • C. Generate an alert and retry connection
  • D. Perform a forced failover to a secondary server

Correct Answer: C. Generate an alert and retry connection
Explanation: If a database server VM loses connectivity to the NDB server, NDB generates an alert to notify the administrator and retries the connection periodically.

Question 37:
What is the primary benefit of using the NDB Time Machine for NDB-managed databases?

  • A. Reduces storage costs by compressing data
  • B. Provides application-consistent backup and recovery
  • C. Optimizes database query performance
  • D. Enables automatic data encryption

Correct Answer: B. Provides application-consistent backup and recovery
Explanation: The primary benefit of using the NDB Time Machine is to provide application-consistent backups and recovery options, ensuring data is captured in a state safe for restoration.

Question 38:
Which NDB role provides full control over the NDB environment, including creating users, upgrading, patching, and managing all entities?

  • A. Database Administrator
  • B. Infrastructure Administrator
  • C. Super Administrator
  • D. Database Infrastructure Administrator

Correct Answer: C. Super Administrator
Explanation: The Super Administrator role provides full control over all NDB operations, including setup, user management, patching, disaster recovery, and more.

Question 39:
An administrator wants to define a maintenance window in NDB. What are the three states of a maintenance window?

  • A. Active, Paused, Terminated
  • B. Scheduled, Running, Completed
  • C. Active, Scheduled, Running
  • D. Pending, In-Progress, Finished

Correct Answer: C. Active, Scheduled, Running
Explanation: A maintenance window in NDB can have three states: Active (currently in use), Scheduled (planned for a future time), and Running (in progress).

Question 40:
An administrator needs to apply OS patches to multiple NDB-managed database VMs. What is the first step?

  • A. Schedule a maintenance window
  • B. Download patches from the vendor website
  • C. Disable high availability for the affected VMs
  • D. Create a Software Profile Version for the patched OS

Correct Answer: D. Create a Software Profile Version for the patched OS
Explanation: Before applying OS patches, the administrator must create a new Software Profile Version that includes the patches, allowing NDB to manage the patching process correctly.

Section Summary:

This set of questions covers the operations and maintenance aspects of managing NDB environments, such as patching, network configurations, high availability setups, and monitoring connectivity and recovery options.

Would you like to proceed with the next set of questions, or focus on a specific area of the exam? Let me know how you'd like to continue!