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

Here are some possible questions and answers that align with the Nutanix Certified Professional - Database Automation (NCP-DB) 6.5 exam topics:

1. Exam Question: Auditing NDB SLAs

  • Question: An administrator is tasked with auditing NDB SLAs. What data will the administrator be reviewing?
    • A. Snapshot schedules
    • B. Clone Management
    • C. Data retention policies
    • D. Recovery Time Objective
  • Correct Answer: C. Data retention policies
    • Explanation: When auditing SLAs in NDB, the primary focus will be on data retention policies, which dictate how long snapshots and backups are kept, ensuring compliance and efficient data management.

2. Exam Question: Time Machine Recovery Option

  • Question: When trying to restore a database via Time Machine (TM), the option to restore data to a Point in Time is not available. What should the administrator do to enable Point in Time Recovery?
    • A. Use an SLA that supports Continuous Log retention.
    • B. Update the TM schedule to perform DB Log catch up.
    • C. Take a Manual snapshot and use it for DB recovery.
    • D. Use Brass SLA & update the Log catch up frequency.
  • Correct Answer: A. Use an SLA that supports Continuous Log retention
    • Explanation: Point in Time recovery requires an SLA with Continuous Log retention enabled to capture and store database transaction logs for fine-grained recovery.

3. Exam Question: Database Restore Handling

  • Question: An administrator needs to restore a source database from a snapshot. The database shares the source volume with multiple other databases. How does NDB handle this database restore operation?
    • A. Copies the specific database files to the source volume
    • B. Replaces source volume with specific DB disks
    • C. Replaces the source volume with the snapshot volume
    • D. Copies all database files to the source volume
  • Correct Answer: C. Replaces the source volume with the snapshot volume
    • Explanation: NDB replaces the entire source volume with the snapshot volume when restoring from a snapshot, ensuring all data is consistent with the time the snapshot was taken.

4. Exam Question: Patching PostgreSQL in NDB

  • Question: 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 new Software Profile with PostgreSQL 13.8.
    • B. Create a maintenance window and add this PostgreSQL server 13.8 to the queue.
    • C. Create a new Database Parameters profile for PostgreSQL server 13.8.
    • D. Create a Software Profile Version with PostgreSQL 13.8.
  • Correct Answer: A. Create a new Software Profile with PostgreSQL 13.8
    • Explanation: The first step is to create a new software profile containing the target PostgreSQL version (13.8) so that the patch can be applied using the appropriate profile.

5. Exam Question: Data Access Management in NDB Multi-Cluster

  • Question: What is the purpose of Data Access Management policies in NDB Multi-Cluster?
    • A. To register multiple Nutanix clusters in NDB
    • B. To perform snapshot operations on a single Nutanix cluster
    • 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
  • Correct Answer: C. To manage time machine data availability across all registered Nutanix clusters in NDB
    • Explanation: Data Access Management (DAM) policies are used to manage the availability and access of time machine data across multiple Nutanix clusters registered in NDB.

Additional Notes:

  • Exam Details:
    • Format: 75 multiple choice questions
    • Time Limit: 120 minutes
    • Languages: English and Japanese
    • Pricing: $199 USD

Here is a comprehensive set of practice questions that cover all the key topics for the Nutanix Certified Professional - Database Automation (NCP-DB) 6.5 exam. These questions are designed to test your understanding across the exam sections, including NDB concepts, deployment, configuration, monitoring, operations, protection, administration, and optimization.

Section 1: Describe NDB Concepts

  1. What is the purpose of the Nutanix Database Service (NDB)?

    • A. To automate and simplify database administration.
    • B. To provide infrastructure management for virtual machines.
    • C. To serve as a backup service for database environments.
    • D. To manage network configurations across clusters.

    Correct Answer: A. To automate and simplify database administration.

  2. What does the NDB Time Machine (TM) feature provide?

    • A. Continuous database protection and backup
    • B. Database scaling capabilities
    • C. Automated provisioning of new databases
    • D. Real-time monitoring of database performance

    Correct Answer: A. Continuous database protection and backup

  3. Which of the following is NOT a capability provided by Nutanix Database Service?

    • A. Database registration and provisioning
    • B. Database backup and restoration
    • C. Operating system-level network management
    • D. Copy Data Management (CDM)

    Correct Answer: C. Operating system-level network management

Section 2: Deploy and Configure an NDB Solution

  1. What is the first step in deploying a PostgreSQL database using NDB?

    • A. Register the database server VM with NDB.
    • B. Create a Software Profile.
    • C. Create a Database Parameter Profile.
    • D. Schedule a maintenance window.

    Correct Answer: B. Create a Software Profile.

  2. How can an administrator enable High Availability (HA) for a database in NDB?

    • A. Use an SLA with a high replication frequency.
    • B. Configure IP addresses for HAProxy.
    • C. Update the database software profile.
    • D. Deploy the database in a single cluster environment.

    Correct Answer: B. Configure IP addresses for HAProxy.

  3. What must be configured before adding a database server VM to an NDB environment?

    • A. A backup policy
    • B. Network and Compute Profiles
    • C. Log retention settings
    • D. Advanced Security Policy

    Correct Answer: B. Network and Compute Profiles

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

  1. Which of the following statements is true about NDB alert retention?

    • A. NDB supports alert retention at the global level only.
    • B. NDB supports retention at individual policy levels.
    • C. NDB does not support alert retention.
    • D. NDB retains alerts indefinitely.

    Correct Answer: B. NDB supports retention at individual policy levels.

  2. How can an administrator monitor storage usage for databases in NDB?

    • A. Use the Nutanix Prism Central dashboard.
    • B. Configure alerts for storage threshold breaches.
    • C. Enable storage analytics on each database.
    • D. Use the NDB User Interface or API.

    Correct Answer: D. Use the NDB User Interface or API.

Section 4: Operate and Maintain an NDB Environment

  1. Which feature allows an administrator to perform a point-in-time restore for a database?

    • A. Snapshot Scheduling
    • B. Continuous Log Retention
    • C. Automated Clone Management
    • D. Incremental Backup

    Correct Answer: B. Continuous Log Retention

  2. What is the recommended method to apply a critical OS patch for a Linux database server in NDB?

    • A. Apply the patch immediately using NDB patch management.
    • B. Schedule a downtime window for patching.
    • C. Use external tools to apply the patch.
    • D. Recreate the server with an updated image.

    Correct Answer: A. Apply the patch immediately using NDB patch management.

  3. What steps must be taken before deleting a database in NDB?

    • A. Disable monitoring for the database.
    • B. Detach the database from the SLA policy.
    • C. Create a final backup or snapshot.
    • D. Remove all associated profiles.

    Correct Answer: C. Create a final backup or snapshot.

Section 5: Protect NDB-Managed Databases Using Time Machine

  1. Which of the following is required to configure Time Machine for a database?

    • A. Assign a Network Profile.
    • B. Configure an SLA with snapshot retention policies.
    • C. Set a database scaling policy.
    • D. Enable automatic log backups.

    Correct Answer: B. Configure an SLA with snapshot retention policies.

  2. What happens if a Time Machine SLA is violated due to insufficient storage space?

    • A. NDB will automatically delete older snapshots.
    • B. NDB will alert the administrator and pause backups.
    • C. NDB will attempt to compress existing snapshots.
    • D. NDB will automatically increase the storage quota.

    Correct Answer: B. NDB will alert the administrator and pause backups.

Section 6: Administer an NDB Environment

  1. How does an administrator manage database access across multiple clusters in NDB?

    • A. By configuring a Data Access Management (DAM) policy
    • B. By creating individual SLAs for each cluster
    • C. By registering all clusters under a single network profile
    • D. By using a cross-cluster replication tool

    Correct Answer: A. By configuring a Data Access Management (DAM) policy

  2. Which of the following best describes a Compute Profile in NDB?

    • A. A template for managing database patching schedules.
    • B. A predefined set of vCPUs, memory, and storage for VMs.
    • C. A network configuration policy for database servers.
    • D. A set of parameters defining database backup policies.

    Correct Answer: B. A predefined set of vCPUs, memory, and storage for VMs.

Section 7: Optimize Database Performance

  1. Which feature does NDB provide to optimize the performance of a database?

    • A. Automatic disk defragmentation
    • B. Dynamic resource allocation through Compute Profiles
    • C. Continuous database patching
    • D. Manual performance tuning of database queries

    Correct Answer: B. Dynamic resource allocation through Compute Profiles

  2. How can an administrator reduce the storage footprint of database snapshots in NDB?

    • A. Enable log compression in the SLA policy.
    • B. Use thin provisioning for database volumes.
    • C. Manually delete older snapshots.
    • D. Adjust the snapshot frequency in the Time Machine configuration.

    Correct Answer: D. Adjust the snapshot frequency in the Time Machine configuration.

Here are more questions that continue to cover all the key topics for the Nutanix Certified Professional - Database Automation (NCP-DB) 6.5 exam.

Section 8: Scaling and Cloning NDB-Managed Databases

  1. Which method is used to scale a database server in NDB?
  • A. Modify the Database Parameters Profile.
  • B. Adjust the Compute Profile assigned to the database server.
  • C. Increase the log retention period.
  • D. Use the Time Machine feature to create additional instances.

Correct Answer: B. Adjust the Compute Profile assigned to the database server.

  1. An administrator wants to create a clone of an existing database. Which step is required before cloning in NDB?
  • A. Create a separate backup for the database.
  • B. Register the source database with NDB.
  • C. Deactivate all running instances of the database.
  • D. Enable continuous log retention.

Correct Answer: B. Register the source database with NDB.

  1. Which cloning strategy is recommended for databases that require minimal downtime during cloning?
  • A. Snapshot-based cloning
  • B. Full database backup cloning
  • C. Transaction log-based cloning
  • D. Thin provisioning cloning

Correct Answer: A. Snapshot-based cloning

Section 9: Patching and Upgrading Database Servers in NDB

  1. What is the primary purpose of creating a new Software Profile Version in NDB?
  • A. To apply minor database patches.
  • B. To facilitate cross-cluster database migrations.
  • C. To manage different database software versions.
  • D. To enable continuous log retention.

Correct Answer: C. To manage different database software versions.

  1. Which action should an administrator take to patch a database managed by NDB?
  • A. Directly modify the database parameters.
  • B. Create a maintenance window and apply the patch during that time.
  • C. Delete the database and recreate it with the patched version.
  • D. Use the Nutanix Prism interface to manually apply patches.

Correct Answer: B. Create a maintenance window and apply the patch during that time.

  1. When should a new database server be created instead of patching the existing server?
  • A. When the current server has a high availability configuration.
  • B. When the new software version is not backward compatible.
  • C. When the server has multiple databases running on it.
  • D. When there are no backup SLAs configured.

Correct Answer: B. When the new software version is not backward compatible.

Section 10: Security and Access Management in NDB

  1. Which feature in NDB is used to restrict access to specific database servers?
  • A. Network Profiles
  • B. Role-Based Access Control (RBAC)
  • C. Snapshot Retention Policies
  • D. High Availability Configuration

Correct Answer: B. Role-Based Access Control (RBAC)

  1. What is the purpose of a Data Access Management (DAM) policy in an NDB multi-cluster environment?
  • A. To provide network segmentation across clusters.
  • B. To manage data replication between clusters.
  • C. To control time machine data accessibility across clusters.
  • D. To define backup schedules for databases.

Correct Answer: C. To control time machine data accessibility across clusters.

  1. How can an administrator enforce data security for backups in NDB?
  • A. By using encrypted snapshots and log backups.
  • B. By setting short retention periods for snapshots.
  • C. By disabling backup replication across clusters.
  • D. By limiting the number of snapshots stored.

Correct Answer: A. By using encrypted snapshots and log backups.

Section 11: Database Protection and Recovery in NDB

  1. Which of the following best describes the function of Time Machine in NDB?
  • A. To schedule database cloning at regular intervals.
  • B. To retain database backups according to defined SLAs.
  • C. To dynamically allocate resources to database servers.
  • D. To manage database users and permissions.

Correct Answer: B. To retain database backups according to defined SLAs.

  1. An administrator needs to recover a database from a failure. What is the first step to perform a database restore in NDB?
  • A. Select the appropriate snapshot or backup from Time Machine.
  • B. Create a new compute profile for the database.
  • C. Adjust the SLA to include recovery options.
  • D. Shut down the existing database instance.

Correct Answer: A. Select the appropriate snapshot or backup from Time Machine.

  1. What should an administrator do to ensure the recovery of a database to the most recent state possible?
  • A. Enable Continuous Log Retention in the SLA.
  • B. Perform a manual snapshot before each critical operation.
  • C. Increase the frequency of daily snapshots.
  • D. Use a multi-cluster replication strategy.

Correct Answer: A. Enable Continuous Log Retention in the SLA.

Section 12: Troubleshooting and Performance Optimization

  1. What is the first step in troubleshooting a failed database patch in NDB?
  • A. Review the NDB patch logs for errors.
  • B. Restart the database server.
  • C. Delete and recreate the database instance.
  • D. Change the software profile version.

Correct Answer: A. Review the NDB patch logs for errors.

  1. How can an administrator improve database performance in an NDB-managed environment?
  • A. Increase the storage quota for the database server VM.
  • B. Adjust the Compute Profile to allocate more resources.
  • C. Disable backup and snapshot operations.
  • D. Use thick provisioning for database storage.

Correct Answer: B. Adjust the Compute Profile to allocate more resources.

  1. What is a common method to resolve network latency issues affecting database performance in NDB?
  • A. Upgrade to the latest NDB version.
  • B. Use a Network Profile with a higher VLAN priority.
  • C. Increase the snapshot retention period.
  • D. Adjust the database backup frequency.

Correct Answer: B. Use a Network Profile with a higher VLAN priority.

Section 13: Exam Preparation and Strategy

  1. How much time is allocated for completing the NCP-DB 6.5 exam?
  • A. 90 minutes
  • B. 120 minutes
  • C. 150 minutes
  • D. 180 minutes

Correct Answer: B. 120 minutes

  1. What is the format of the NCP-DB 6.5 exam?
  • A. True/False questions only
  • B. Multiple-choice questions only
  • C. Multiple-choice and short answer questions
  • D. Essay and case study questions

Correct Answer: B. Multiple-choice questions only

  1. Which topic area is most heavily weighted on the NCP-DB 6.5 exam?
  • A. Monitoring Alerts and Storage Usage
  • B. Operating and Maintaining an NDB Environment
  • C. Security and Access Management
  • D. Database Protection and Recovery

Correct Answer: B. Operating and Maintaining an NDB Environment

Here are more questions to further cover the topics for the Nutanix Certified Professional - Database Automation (NCP-DB) 6.5 exam.

Section 14: Database Management with Nutanix Database Service (NDB)

  1. What is the first step in registering a new database server VM with NDB?
  • A. Create a Software Profile.
  • B. Install the NDB agent on the server VM.
  • C. Enable multi-cluster management in NDB.
  • D. Set up SSH access between NDB and the server VM.

Correct Answer: D. Set up SSH access between NDB and the server VM.

  1. Which component must be installed on a database server VM for NDB management?
  • A. Nutanix AHV Hypervisor
  • B. NDB Database Agent
  • C. Nutanix Calm
  • D. Nutanix Files

Correct Answer: B. NDB Database Agent

  1. Which profile defines the compute resources for a database server in NDB?
  • A. Software Profile
  • B. Network Profile
  • C. Database Parameter Profile
  • D. Compute Profile

Correct Answer: D. Compute Profile

Section 15: Creating and Managing Profiles in NDB

  1. Which of the following is a primary use of the Database Parameter Profile in NDB?
  • A. To define backup schedules for databases.
  • B. To specify the hardware requirements for database servers.
  • C. To set initialization parameters for different database engines.
  • D. To manage network segmentation across clusters.

Correct Answer: C. To set initialization parameters for different database engines.

  1. What is required to create a new Software Profile for a MariaDB instance in NDB?
  • A. Select a Nutanix cluster and specify network parameters.
  • B. Register an existing MariaDB database server VM.
  • C. Define retention policies for database snapshots.
  • D. Create a Network Profile with VLAN information.

Correct Answer: B. Register an existing MariaDB database server VM.

  1. What does the term “Greenfield” refer to in the context of NDB profiles?
  • A. A new environment without existing databases.
  • B. A high-availability configuration for existing databases.
  • C. A policy to manage database backups.
  • D. A replication strategy for cross-cluster deployments.

Correct Answer: A. A new environment without existing databases.

Section 16: Database Patching and Upgrade Strategies

  1. When applying a patch to a SQL Server instance managed by NDB, what must be done first?
  • A. Backup all existing data.
  • B. Create a new Compute Profile.
  • C. Create a maintenance window and select the instance.
  • D. Change the server's network configuration.

Correct Answer: C. Create a maintenance window and select the instance.

  1. How does NDB handle database upgrades that involve schema changes?
  • A. By automatically adjusting the schema using built-in tools.
  • B. By requiring manual schema adjustments before upgrade.
  • C. By using a rolling upgrade to avoid downtime.
  • D. By cloning the database and applying changes to the clone.

Correct Answer: B. By requiring manual schema adjustments before upgrade.

  1. Which statement is true about the patching of PostgreSQL databases in NDB?
  • A. Patching can be done using any Linux package manager.
  • B. NDB requires a new Software Profile with the target version.
  • C. Patching must be done manually outside of NDB.
  • D. Only major version upgrades are supported in NDB.

Correct Answer: B. NDB requires a new Software Profile with the target version.

Section 17: Database Scaling and Resource Management

  1. What should an administrator do to scale a database in NDB dynamically?
  • A. Increase the size of snapshots in the Time Machine.
  • B. Adjust the Compute Profile for the database server VM.
  • C. Modify the Network Profile to support higher bandwidth.
  • D. Create additional database replicas across clusters.

Correct Answer: B. Adjust the Compute Profile for the database server VM.

  1. How does NDB handle storage scaling for a database?
  • A. Automatically increases storage based on usage.
  • B. Uses a predefined Compute Profile to allocate more disk space.
  • C. Allows manual adjustment of storage size through the NDB interface.
  • D. Schedules storage scaling during maintenance windows.

Correct Answer: C. Allows manual adjustment of storage size through the NDB interface.

  1. Which feature does NDB provide to support the scaling of a multi-instance database server?
  • A. Compute Profiles with dynamic resource allocation
  • B. Time Machine-based automated cloning
  • C. Cross-cluster replication policies
  • D. Role-Based Access Control (RBAC)

Correct Answer: A. Compute Profiles with dynamic resource allocation

Section 18: Configuring and Managing Multi-Cluster Environments

  1. What must be enabled to manage databases across multiple Nutanix clusters using NDB?
  • A. Network Profile Segmentation
  • B. Multi-Cluster Management
  • C. Cross-Cluster Replication
  • D. High Availability Clustering

Correct Answer: B. Multi-Cluster Management

  1. How can an administrator replicate a database snapshot to a remote cluster in NDB?
  • A. By creating a remote replication policy within the Time Machine SLA.
  • B. By enabling the Data Access Management (DAM) policy.
  • C. By using a third-party replication tool.
  • D. By setting up cross-cluster network profiles.

Correct Answer: A. By creating a remote replication policy within the Time Machine SLA.

  1. Which action is required to ensure data consistency across clusters in an NDB multi-cluster setup?
  • A. Increase the snapshot frequency in the SLA.
  • B. Set up synchronous replication between clusters.
  • C. Enable alert retention at the policy level.
  • D. Create identical Compute Profiles across clusters.

Correct Answer: B. Set up synchronous replication between clusters.

Section 19: Best Practices for Database Operations in NDB

  1. What is a recommended best practice for creating snapshots in NDB?
  • A. Use thick provisioning for all databases.
  • B. Schedule snapshots during off-peak hours.
  • C. Increase the frequency of daily snapshots.
  • D. Manually create snapshots before and after critical operations.

Correct Answer: B. Schedule snapshots during off-peak hours.

  1. Which method is best for maintaining optimal performance of NDB-managed databases?
  • A. Regularly update Compute Profiles to allocate resources based on usage patterns.
  • B. Disable logging to improve write performance.
  • C. Use manual performance tuning scripts.
  • D. Increase backup frequencies to ensure data integrity.

Correct Answer: A. Regularly update Compute Profiles to allocate resources based on usage patterns.

  1. How should an administrator handle a database server that frequently exceeds its resource limits in NDB?
  • A. Increase the snapshot retention period.
  • B. Clone the server and distribute the load.
  • C. Adjust the Compute Profile to allocate more resources.
  • D. Create a new Database Parameter Profile with optimized settings.

Correct Answer: C. Adjust the Compute Profile to allocate more resources.

Section 20: Exam Logistics and Tips

  1. What should a candidate do if they are unsure about an answer during the NCP-DB 6.5 exam?
  • A. Skip the question and return to it later.
  • B. Select the longest answer option.
  • C. Choose the answer that is first on the list.
  • D. Leave it unanswered to avoid a penalty.

Correct Answer: A. Skip the question and return to it later.

  1. Which study material is most recommended for preparing for the NCP-DB 6.5 exam?
  • A. The Nutanix Database Service User Guide
  • B. Third-party database management books
  • C. Online forums and discussion groups
  • D. NDB Release Notes and Patch Notes

Correct Answer: A. The Nutanix Database Service User Guide

  1. How can a candidate best utilize practice exams for the NCP-DB 6.5 certification?
  • A. Use them to memorize all possible questions.
  • B. Identify weak areas and focus on those topics.
  • C. Use them to test speed only.
  • D. Avoid them and focus solely on official documentation.

Correct Answer: B. Identify weak areas and focus on those topics.

Here are more questions to continue covering the Nutanix Certified Professional - Database Automation (NCP-DB) 6.5 exam topics.

Section 21: Advanced Database Operations and Management

  1. Which command can be used to add multiple databases to an existing MariaDB instance using the NDB CLI?
  • A. ndb add-database
  • B. ndb-cli db add --multiple
  • C. ndb-cli database add
  • D. ndb-cli db add --batch

Correct Answer: C. ndb-cli database add

  1. What should an administrator do if the option to restore data to a specific Point in Time is not available in Time Machine?
  • A. Increase the snapshot frequency in the SLA.
  • B. Enable Continuous Log Retention in the SLA policy.
  • C. Upgrade the database server to a higher version.
  • D. Manually create a full database backup.

Correct Answer: B. Enable Continuous Log Retention in the SLA policy.

  1. Which of the following can be a cause for a failed database registration in NDB?
  • A. Insufficient network bandwidth
  • B. Database running on a non-supported OS version
  • C. Database instance size exceeding 1TB
  • D. Use of dynamic disks on the database server VM

Correct Answer: B. Database running on a non-supported OS version

Section 22: Database Provisioning and Cloning in NDB

  1. An administrator wants to provision a new PostgreSQL instance using a Time Machine. What must be done first?
  • A. Create a new Network Profile.
  • B. Select the snapshot to be used from the Time Machine.
  • C. Update the Compute Profile to match the PostgreSQL requirements.
  • D. Register the database instance manually.

Correct Answer: B. Select the snapshot to be used from the Time Machine.

  1. Which of the following is a benefit of using snapshot-based cloning for databases in NDB?
  • A. Reduced CPU utilization during the cloning process.
  • B. Increased availability of network resources.
  • C. Minimal storage impact compared to full clones.
  • D. Enhanced security with snapshot encryption.

Correct Answer: C. Minimal storage impact compared to full clones.

  1. What step should be performed to create a clone of an Oracle database managed by NDB?
  • A. Manually copy the database files to the target server.
  • B. Use the "Create Clone" option from the NDB User Interface.
  • C. Enable snapshot replication to the target server.
  • D. Set up a new Database Parameter Profile for the clone.

Correct Answer: B. Use the "Create Clone" option from the NDB User Interface.

Section 23: SLA Management and Time Machine Configuration

  1. Which element is NOT typically defined in an NDB SLA policy?
  • A. Snapshot frequency
  • B. Log catch-up intervals
  • C. IP address ranges
  • D. Snapshot retention periods

Correct Answer: C. IP address ranges

  1. How does NDB handle snapshot retention if the storage capacity is full?
  • A. Automatically increases the storage quota.
  • B. Stops taking new snapshots until space is freed.
  • C. Deletes the oldest snapshots based on SLA policies.
  • D. Compresses existing snapshots to save space.

Correct Answer: C. Deletes the oldest snapshots based on SLA policies.

  1. What is the purpose of defining log catch-up intervals in an SLA for NDB?
  • A. To schedule backups more frequently.
  • B. To capture database transaction logs for point-in-time recovery.
  • C. To manage the replication speed across clusters.
  • D. To control the CPU usage during backups.

Correct Answer: B. To capture database transaction logs for point-in-time recovery.

Section 24: Managing and Optimizing Database Performance

  1. Which of the following practices is recommended to optimize read-heavy workloads in NDB?
  • A. Use a dedicated Compute Profile with high IOPS storage.
  • B. Disable snapshots to reduce overhead.
  • C. Configure multiple network interfaces on the database server.
  • D. Increase the log catch-up interval.

Correct Answer: A. Use a dedicated Compute Profile with high IOPS storage.

  1. What is a common method for optimizing backup performance in NDB?
  • A. Use incremental backups instead of full backups.
  • B. Increase the memory allocation in the Compute Profile.
  • C. Set the database to read-only mode during backups.
  • D. Disable Time Machine features temporarily.

Correct Answer: A. Use incremental backups instead of full backups.

  1. Which parameter should be adjusted to improve the performance of a database with high write activity?
  • A. Increase the snapshot frequency in the SLA.
  • B. Allocate more vCPUs in the Compute Profile.
  • C. Enable continuous log backups.
  • D. Decrease the log catch-up interval.

Correct Answer: B. Allocate more vCPUs in the Compute Profile.

Section 25: Database Protection and Recovery

  1. An administrator wants to ensure maximum protection for a critical database. What is the best strategy in NDB?
  • A. Enable Continuous Log Retention and daily snapshots in the SLA.
  • B. Perform manual backups after every major transaction.
  • C. Use cross-cluster replication and weekly snapshots.
  • D. Configure the database to run in read-only mode.

Correct Answer: A. Enable Continuous Log Retention and daily snapshots in the SLA.

  1. Which action should an administrator take to restore a database to a specific point in time?
  • A. Select the corresponding snapshot from Time Machine.
  • B. Use the database engine's built-in restore function.
  • C. Adjust the SLA to include the desired recovery point.
  • D. Perform a manual recovery using external tools.

Correct Answer: A. Select the corresponding snapshot from Time Machine.

  1. What is required to perform a cross-cluster database recovery in NDB?
  • A. Data Access Management (DAM) policy configuration.
  • B. An established high-availability cluster.
  • C. An active replication link between clusters.
  • D. Increased snapshot frequency in the SLA.

Correct Answer: C. An active replication link between clusters.

Section 26: Role-Based Access Control (RBAC) and Security

  1. Which of the following roles in NDB can create and manage SLAs?
  • A. Database Viewer
  • B. Database Administrator
  • C. Infrastructure Operator
  • D. Security Administrator

Correct Answer: B. Database Administrator

  1. How does Role-Based Access Control (RBAC) enhance security in NDB?
  • A. By restricting user access to only authorized actions and data.
  • B. By automatically encrypting all data at rest.
  • C. By enabling two-factor authentication for all users.
  • D. By creating backup schedules with limited access.

Correct Answer: A. By restricting user access to only authorized actions and data.

  1. What must be configured to limit access to database snapshots in a multi-cluster NDB environment?
  • A. A Data Access Management (DAM) policy
  • B. A separate SLA for each cluster
  • C. A dedicated Compute Profile
  • D. A Network Profile with VLAN restrictions

Correct Answer: A. A Data Access Management (DAM) policy

Section 27: Troubleshooting and Exam Preparation

  1. Which is the first step in troubleshooting a database server that is not visible in the NDB console?
  • A. Check the network connectivity between the NDB server and the database server VM.
  • B. Restart the NDB service.
  • C. Upgrade the NDB software to the latest version.
  • D. Reinstall the NDB database agent on the server.

Correct Answer: A. Check the network connectivity between the NDB server and the database server VM.

  1. How should a candidate best prepare for scenario-based questions in the NCP-DB 6.5 exam?
  • A. Focus on memorizing answers to multiple-choice questions.
  • B. Study real-world use cases and practice applying concepts.
  • C. Only review the Nutanix product release notes.
  • D. Use flashcards to remember technical terms.

Correct Answer: B. Study real-world use cases and practice applying concepts.

  1. What is the most effective way to manage time during the NCP-DB 6.5 exam?
  • A. Answer the easiest questions first to save time for more difficult ones.
  • B. Start with the most challenging questions to get them out of the way.
  • C. Answer questions in order, regardless of difficulty.
  • D. Skip all questions initially and come back to them later.

Correct Answer: A. Answer the easiest questions first to save time for more difficult ones.