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

Here are the answers to the new mock exam questions for the Nutanix Certified Professional - Database Automation (NCP-DB) certification:

Section 1: Core NDB Concepts (15 Questions)

Which Nutanix product integrates with NDB to provide infrastructure management?
- C) Prism
What is the primary benefit of using a Compute Profile in NDB?
- C) Sets CPU and memory allocation for database VMs
True or False: NDB can only manage databases that are created within the NDB environment.
- B) False
Which feature in NDB helps to reduce storage consumption by maintaining only incremental changes?
- C) Incremental Backup
Fill in the blank: The ________ profile in NDB is used to specify the database version, patches, and OS configuration details.
- B) Software
Which type of database operation does NDB automate for supported engines?
- C) Backup and restore
True or False: NDB allows you to manage both production and non-production databases using the same interface.
- A) True
Scenario-Based Question: You need to ensure that a database is encrypted both at rest and in transit. Which two features should be enabled in NDB?
- B) Data Encryption and SSL Certificates
What is the purpose of a Database Parameter Profile in NDB?
- B) Sets database-specific parameters like buffer size
Which database engine is NOT supported by NDB?
- C) SQLite
True or False: Nutanix NDB can be integrated with third-party monitoring tools through its API.
- A) True
Fill in the blank: NDB uses the ________ feature to create point-in-time copies of databases for development and testing purposes.
- A) Cloning
Which Nutanix feature allows you to set user permissions for database management?
- A) RBAC
Scenario-Based Question: You are deploying a new MariaDB instance that requires specific performance tuning. Which NDB feature should you use to apply these settings?
- C) Database Parameter Profile
Which protocol does NDB primarily use for secure communication between components?
- C) HTTPS

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

True or False: High Availability in NDB is achieved through synchronous replication across clusters.
- B) False
What is a prerequisite for setting up Multi-Cluster HA in NDB?
- C) Enabling multi-cluster mode
Which NDB feature is used to failover databases automatically during an outage?
- C) High Availability (HA)
Fill in the blank: The ________ feature in NDB enables recovery to a specific point in time to minimize data loss.
- A) Time Machine
Scenario-Based Question: You are configuring HA for a PostgreSQL instance that must support geographic redundancy. Which HA configuration should you use?
- B) Multi-Cluster HA
Which NDB component must be enabled to use Multi-Cluster HA?
- D) Multi-Cluster Mode
True or False: In NDB, failover scenarios must always be tested manually.
- B) False
Match the following HA types to their respective functions:
- A) Single-Cluster HA - 1. Provides redundancy within a single data center
- B) Multi-Cluster HA - 2. Provides redundancy across different geographical locations
Which action is required to maintain continuous database access during an HA failover?
- B) Automatic Reconfiguration
True or False: NDB supports automatic HA configuration for all supported database engines.
- A) True
Fill in the blank: To monitor the status of HA components in NDB, use the ________ interface.
- A) Alerts Dashboard
Which type of redundancy does Multi-Cluster HA provide in an NDB environment?
- B) Data
True or False: All clusters in a Multi-Cluster HA configuration must be in the same physical location.
- B) False
Scenario-Based Question: If a Multi-Cluster HA environment experiences a network partition, what is the likely outcome?
- B) Failover to a different cluster
What is the function of the HA Proxy in an NDB environment?
- B) Provides load balancing for the database services

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

True or False: NDB automatically collects performance data and stores it for historical analysis.
- A) True
Which tool is used to configure performance thresholds in NDB?
- B) Alerts Dashboard
Fill in the blank: To diagnose performance issues, NDB provides a ________ tool to collect logs and system information.
- B) Diagnostics Bundle
Scenario-Based Question: You need to set up alerts for high CPU usage on all database VMs. Where should you configure this in NDB?
- A) Administration > Alerts > Alert Policies
What type of alert requires immediate attention to prevent database failure?
- B) Critical Alert
True or False: NDB provides native integration with third-party alerting tools.
- A) True
Fill in the blank: The ________ tool in NDB helps visualize real-time and historical trends of database resource usage.
- A) Performance Analyzer
Which of the following metrics is NOT tracked by the NDB monitoring tools?
- D) Application code performance
Scenario-Based Question: An alert has been triggered for high memory utilization. What is the first step to take?
- C) Review and optimize database queries
True or False: NDB can automatically optimize the database engine based on usage patterns.
- B) False
What is the primary function of the Diagnostics Bundle in NDB?
- B) Collects logs and diagnostics data
Fill in the blank: To view the CPU and memory usage of all database VMs, use the ________ in NDB.
- B) Performance Analyzer
Scenario-Based Question: A database is reported to be running slower than usual. Which NDB tool should you use first?
- D) Diagnostics Bundle
True or False: Custom alert thresholds can be created for different database instances in NDB.
- A) True
What type of alert informs you of potential issues that may require future attention?
- C) Warning Alert

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

True or False: Time Machine in NDB can perform both snapshots and continuous backups.
- A) True
What is the primary function of a snapshot in NDB?
- B) To capture the state of a database at a specific point in time
Fill in the blank: To create a non-production environment that mirrors a production database, use the ________ feature in NDB.
- B) Clone
Which option best describes the use of SLAs in NDB?
- B) To set backup frequency and retention policies
Scenario-Based Question: A database needs to be restored to a specific point in time due to data corruption. Which NDB feature should be used?
- B) Time Machine
True or False: All database backups in NDB are encrypted by default.
- B) False
Fill in the blank: ________ in NDB allows for easy replication of database environments across different clusters.
- B) Cloning
Which database management task can be automated using NDB?
- B) Database patching
Scenario-Based Question: You want to create a test environment for an Oracle database that mirrors production. Which NDB feature is best suited for this?
- B) Cloning
True or False: NDB allows for manual and automatic creation of snapshots for database protection.
- A) True
Fill in the blank: ________ are templates in NDB used to define specific configurations for different database engines.
- C) Software Profiles
Which type of backup is most efficient for saving storage space over time?
- B) Incremental Backup
**True or False: Data cloning in NDB

always requires downtime of the source database.**
- B) False

Which feature in NDB provides the ability to set retention policies for backups?
- A) SLA Management
Fill in the blank: To protect a database from unauthorized access, use the ________ feature in NDB.
- A) RBAC

Section 5: Administering an NDB Environment (15 Questions)

True or False: NDB can be managed exclusively via the CLI without any graphical interface.
- B) False
Which NDB role is primarily responsible for database provisioning and management?
- B) Database Administrator (DBA)
Fill in the blank: The ________ profile in NDB is used to configure VLANs and other network settings for database VMs.
- B) Network
Which API protocol does NDB primarily use for automation and integration with other tools?
- B) REST
Scenario-Based Question: A user needs access to monitor but not manage database resources. Which role should they be assigned in NDB?
- C) Viewer
True or False: One-Click Patching in NDB can be applied to databases across multiple clusters.
- A) True
Fill in the blank: To create a new compute profile, navigate to ________ in the NDB interface.
- A) Administration > Compute Profiles
Which CLI command is used to update a database software profile in NDB?
- A) ndbcli update profile
True or False: NDB supports role-based management for both individual users and user groups.
- A) True
Which feature in NDB allows for seamless integration with external cloud platforms?
- A) REST API
Scenario-Based Question: An administrator needs to increase the storage allocated to a PostgreSQL database. What is the recommended approach?
- D) Expand the storage through the database VM settings
True or False: NDB requires a restart of all related services after updating the SSL certificates.
- B) False
Fill in the blank: The command to list all available clusters in NDB via CLI is ________.
- B) ndbcli show clusters
Which NDB feature allows administrators to view and manage alerts and notifications?
- A) Alerts Dashboard
True or False: All nodes in an NDB cluster must have identical configurations for successful deployment.
- B) False

These answers provide a comprehensive understanding of Nutanix Database Service (NDB) concepts, including core features, high availability, monitoring, database protection, and administration. Use these questions and answers to assess your knowledge and readiness for the NCP-DB certification. If you need further details or clarifications, feel free to ask!