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

To create an effective mock exam for the Nutanix Certified Professional - Database Automation (NCP-DB) certification, let's follow the structured approach outlined in your initial plan. Here is a sample mock exam designed to cover all the core areas, balance question types, and align with the official exam objectives. This mock exam will include 75 questions and provide a variety of question types to mimic the real exam experience.

Nutanix Certified Professional - Database Automation (NCP-DB) Mock Exam

Total Questions: 75
Time Limit: 90 minutes

Section 1: Core NDB Concepts (15 Questions)

  1. Multiple Choice:
    What are the core components of Nutanix Database Service (NDB)?

    • a) Time Machine, Compute Profile, Database Parameter Profile
    • b) Database Server VM, Clones, Snapshots
    • c) Compute, Network, Software Profiles, Time Machine
    • d) Virtual Machine, Clusters, Storage Pools
      Correct Answer: c

  2. True/False:
    Nutanix NDB supports only the community version of all database engines.
    Correct Answer: True

  3. Fill-in-the-Blank:
    A _______ is a template that contains configuration settings for database provisioning, including compute resources, network settings, and database parameters.
    Correct Answer: Profile

  4. Scenario-Based:
    You have been asked to provision a new database instance on a Nutanix cluster using NDB. The database should be configured with specific compute and network settings. Which NDB profiles will you use to accomplish this?
    Correct Answer Explanation: You will use the Compute Profile to define the compute resources such as vCPUs and memory, and the Network Profile to define the network settings, such as VLANs.

  5. Matching:
    Match the following Nutanix NDB features to their functions:

    • Software Profile
    • Compute Profile
    • Network Profile
    • Database Parameter Profile
      Correct Answers:
    • Software Profile → A template for database software versions and patches.
    • Compute Profile → Defines vCPU and memory resources for a VM.
    • Network Profile → Specifies the network settings, including VLANs.
    • Database Parameter Profile → Contains custom database parameters.

Section 2: High Availability (HA) and Disaster Recovery (DR) (15 Questions)

  1. Multiple Choice:
    Which feature in NDB provides point-in-time recovery for databases?

    • a) Snapshots
    • b) Clones
    • c) Time Machine
    • d) Backups
      Correct Answer: c

  2. True/False:
    In a multi-cluster HA configuration, database failover is managed by the database software itself.
    Correct Answer: True

  3. Fill-in-the-Blank:
    For high availability, NDB supports both single-cluster and __________ configurations.
    Correct Answer: Multi-cluster

  4. Scenario-Based:
    A database failure occurs in one of your clusters. Explain the steps to failover to a secondary cluster using Nutanix NDB.
    Correct Answer Explanation: The failover steps include validating the secondary cluster’s readiness, initiating failover in the NDB console, and monitoring the database status post-failover to ensure all services are operational.

  5. Matching:
    Match the following HA/DR concepts to their descriptions:

    • Single-Cluster HA
    • Multi-Cluster HA
    • Time Machine
    • Failover
      Correct Answers:
    • Single-Cluster HA → Ensures HA within a single Nutanix cluster.
    • Multi-Cluster HA → Provides HA across multiple Nutanix clusters.
    • Time Machine → Provides snapshots and point-in-time recovery.
    • Failover → Process of switching to a backup system when the primary system fails.

Section 3: Monitoring, Alerts, and Performance Optimization (15 Questions)

  1. Multiple Choice:
    Which tool in NDB allows you to analyze performance metrics and identify bottlenecks in your database environment?

    • a) Alerts Dashboard
    • b) Performance Analyzer
    • c) Diagnostics Bundle
    • d) Database Logs
      Correct Answer: b

  2. True/False:
    NDB provides automated alerts for threshold breaches on key performance metrics.
    Correct Answer: True

  3. Fill-in-the-Blank:
    The ___________ in NDB can be used to collect logs and configuration data for troubleshooting.
    Correct Answer: Diagnostics Bundle

  4. Scenario-Based:
    Your database's CPU usage is consistently high. Describe the steps you would take using NDB tools to diagnose and resolve this performance issue.
    Correct Answer Explanation: Use the Performance Analyzer to review CPU metrics, identify the database operations causing high usage, and then adjust resource allocation or optimize queries.

  5. Matching:
    Match the following monitoring tools to their purposes:

    • Performance Analyzer
    • Alerts Dashboard
    • Diagnostics Bundle
      Correct Answers:
    • Performance Analyzer → Monitors performance metrics.
    • Alerts Dashboard → Displays alerts based on configured thresholds.
    • Diagnostics Bundle → Collects logs and configurations for troubleshooting.

Section 4: Database Protection and Data Management (15 Questions)

  1. Multiple Choice:
    Which NDB feature allows you to create clones of your databases for testing and development purposes?

    • a) Snapshots
    • b) Clones
    • c) Time Machine
    • d) Backups
      Correct Answer: b

  2. True/False:
    NDB does not support restoring multiple databases in the same database server VM.
    Correct Answer: True

  3. Fill-in-the-Blank:
    NDB allows administrators to create _______ to ensure database protection through regular backups and snapshots.
    Correct Answer: SLAs (Service Level Agreements)

  4. Scenario-Based:
    You need to restore a database to a previous state due to data corruption. Explain how you would use Nutanix NDB to perform this task.
    Correct Answer Explanation: Use the Time Machine feature to select the desired point-in-time snapshot and initiate the restore operation.

  5. Matching:
    Match the following data management tools to their descriptions:

    • Snapshots
    • Clones
    • Time Machine
    • Backup
      Correct Answers:
    • Snapshots → Captures the current state of a database at a specific time.
    • Clones → Creates a copy of a database for testing and development.
    • Time Machine → Manages point-in-time recovery.
    • Backup → Stores database copies for recovery purposes.

Section 5: Administering an NDB Environment (15 Questions)

  1. Multiple Choice:
    Which command is used to register a new database instance with NDB?

    • a) ndb-register
    • b) ndb-instance-register
    • c) register-instance
    • d) ndb-add-db
      Correct Answer: b

  2. True/False:
    You can create and update software profiles using the NDB API.
    Correct Answer: True

  3. Fill-in-the-Blank:
    NDB uses __________ to manage user roles and permissions across databases.
    Correct Answer: Role-Based Access Control (RBAC)

  4. Scenario-Based:
    Describe the steps to patch an existing database instance in NDB.
    Correct Answer Explanation: Select the database instance from the NDB console, choose the patching option, apply the desired patch, and monitor the process to ensure it completes successfully.

  5. Matching:
    Match the following administrative tasks to their descriptions:

    • Register Instance
    • Patching
    • Role-Based Access Control
    • Software Profile Update
      Correct Answers:
    • Register Instance → Adds a new database instance to NDB.
    • Patching → Applies updates to the database software.
    • Role-Based Access Control → Manages user roles and permissions.
    • Software Profile Update → Changes the database software configuration.

Feedback and Analysis

After completing the mock exam, candidates will receive a performance summary, detailed answer explanations, and recommendations for further study based on their performance in each section.

This mock exam reflects the format, content areas, and complexity levels candidates can expect in the actual Nutanix Certified Professional - Database Automation (NCP-DB) certification exam.