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

Here's a new set of 75 mock exam questions for the Nutanix Certified Professional - Database Automation (NCP-DB) certification. This set covers various topics related to Nutanix Database Service (NDB) and is designed to provide a comprehensive understanding of the subject matter.

Section 1: Core NDB Concepts (15 Questions)

Which Nutanix product integrates with NDB to provide infrastructure management?
- A) Calm
- B) Karbon
- C) Prism
- D) Xi Beam
What is the primary benefit of using a Compute Profile in NDB?
- A) Defines user roles
- B) Configures the network settings
- C) Sets CPU and memory allocation for database VMs
- D) Manages backups
True or False: NDB can only manage databases that are created within the NDB environment.
- A) True
- B) False
Which feature in NDB helps to reduce storage consumption by maintaining only incremental changes?
- A) Full Backup
- B) Time Machine
- C) Incremental Backup
- D) Differential Backup
Fill in the blank: The ________ profile in NDB is used to specify the database version, patches, and OS configuration details.
- A) Compute
- B) Software
- C) Network
- D) Security
Which type of database operation does NDB automate for supported engines?
- A) Schema migration
- B) Index creation
- C) Backup and restore
- D) Data transformation
True or False: NDB allows you to manage both production and non-production databases using the same interface.
- A) True
- B) False
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?
- A) SSL Certificates and RBAC
- B) Data Encryption and SSL Certificates
- C) Time Machine and Data Deduplication
- D) High Availability and Encryption
What is the purpose of a Database Parameter Profile in NDB?
- A) Configures backup frequency
- B) Sets database-specific parameters like buffer size
- C) Defines network policies
- D) Manages user access and permissions
Which database engine is NOT supported by NDB?
- A) Oracle
- B) MongoDB
- C) SQLite
- D) PostgreSQL
True or False: Nutanix NDB can be integrated with third-party monitoring tools through its API.
- A) True
- B) False
Fill in the blank: NDB uses the ________ feature to create point-in-time copies of databases for development and testing purposes.
- A) Cloning
- B) High Availability
- C) Monitoring
- D) RBAC
Which Nutanix feature allows you to set user permissions for database management?
- A) RBAC
- B) API Explorer
- C) Time Machine
- D) Network Profile
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?
- A) Software Profile
- B) Compute Profile
- C) Database Parameter Profile
- D) Network Profile
Which protocol does NDB primarily use for secure communication between components?
- A) FTP
- B) HTTP
- C) HTTPS
- D) TCP

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

True or False: High Availability in NDB is achieved through synchronous replication across clusters.
- A) True
- B) False
What is a prerequisite for setting up Multi-Cluster HA in NDB?
- A) Single-node deployment
- B) Identical hardware specifications
- C) Enabling multi-cluster mode
- D) Manual data synchronization
Which NDB feature is used to failover databases automatically during an outage?
- A) Role-Based Access Control (RBAC)
- B) Time Machine
- C) High Availability (HA)
- D) Data Deduplication
Fill in the blank: The ________ feature in NDB enables recovery to a specific point in time to minimize data loss.
- A) Time Machine
- B) High Availability
- C) Snapshot Management
- D) RBAC
Scenario-Based Question: You are configuring HA for a PostgreSQL instance that must support geographic redundancy. Which HA configuration should you use?
- A) Single-Cluster HA
- B) Multi-Cluster HA
- C) Active-Active HA
- D) Asynchronous HA
Which NDB component must be enabled to use Multi-Cluster HA?
- A) RBAC
- B) Network Profile
- C) API Gateway
- D) Multi-Cluster Mode
True or False: In NDB, failover scenarios must always be tested manually.
- A) True
- 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
  - 1. Provides redundancy across different geographical locations
Which action is required to maintain continuous database access during an HA failover?
- A) Database Encryption
- B) Automatic Reconfiguration
- C) Manual Restart
- D) Data Replication
True or False: NDB supports automatic HA configuration for all supported database engines.
- A) True
- B) False
Fill in the blank: To monitor the status of HA components in NDB, use the ________ interface.
- A) Alerts Dashboard
- B) Network Monitor
- C) Cluster Manager
- D) Performance Analyzer
Which type of redundancy does Multi-Cluster HA provide in an NDB environment?
- A) Hardware
- B) Data
- C) Network
- D) Software
True or False: All clusters in a Multi-Cluster HA configuration must be in the same physical location.
- A) True
- B) False
Scenario-Based Question: If a Multi-Cluster HA environment experiences a network partition, what is the likely outcome?
- A) No impact
- B) Failover to a different cluster
- C) Complete data loss
- D) Service degradation
What is the function of the HA Proxy in an NDB environment?
- A) Manages API requests
- B) Provides load balancing for the database services
- C) Encrypts data
- D) Automates backups

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
- B) False
Which tool is used to configure performance thresholds in NDB?
- A) Diagnostics Bundle
- B) Alerts Dashboard
- C) API Explorer
- D) Performance Analyzer
Fill in the blank: To diagnose performance issues, NDB provides a ________ tool to collect logs and system information.
- A) Resource Dashboard
- B) Diagnostics Bundle
- C) Alert Manager
- D) Cluster Manager
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
- B) Administration > Users > Roles
- C) Administration > Network Settings
- D) Administration > Database Profiles
What type of alert requires immediate attention to prevent database failure?
- A) Informational Alert
- B) Critical Alert
- C) Warning Alert
- D) System Alert
True or False: NDB provides native integration with third-party alerting tools.
- A) True
- B) False
Fill in the blank: The ________ tool in NDB helps visualize real-time and historical trends of database resource usage.
- A) Performance Analyzer
- B) Diagnostics Bundle
- C) Time Machine
- D) Alerts Dashboard
Which of the following metrics is NOT tracked by the NDB monitoring tools?
- A) Network latency
- B) Disk I/O
- C) Memory utilization
- D) Application code performance
Scenario-Based Question: An alert has been triggered for high memory utilization. What is the first step to take?
- A) Increase database memory allocation
- B) Reboot the database VM
- C) Review and optimize database queries
- D) Ignore the alert
True or False: NDB can automatically optimize the database engine based on usage patterns.
- A) True
- B) False
What is the primary function of the Diagnostics Bundle in NDB?
- A) Provides real-time alerts
- B) Collects logs and diagnostics data
- C) Manages user roles
- D) Configures backup policies
Fill in the blank: To view the CPU and memory usage of all database VMs, use the ________ in NDB.
- A) Cluster Manager
- B) Performance Analyzer
- C) Diagnostics Bundle
- D) Network Monitor
Scenario-Based Question: A database is reported to be running slower than usual. Which NDB tool should you use first?
- A) Performance Analyzer
- B) API Explorer
- C) Time Machine
- D) Diagnostics Bundle
True or False: Custom alert thresholds can be created for different database instances in NDB.
- A) True
- B) False
What type of alert informs you of potential issues that may require future attention?
- A) Critical Alert
- B) Informational Alert
- C) Warning Alert
- D) Maintenance 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
- B) False
What is the primary function of a snapshot in NDB?
- A) To encrypt data
- B) To capture the state of a database at a specific point in time
- C) To manage user permissions
- D) To automate schema updates
Fill in the blank: To create a non-production environment that mirrors a production database, use the ________ feature in NDB.
- A) Backup
- B) Clone
- C) Restore
- D) Snapshot
Which option best describes the use of SLAs in NDB?
- A) To define network parameters
- B) To set backup frequency and retention policies
- C) To manage software licenses
- D) To configure security settings
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?
- A) Cloning
- B) Time Machine
- C) API Explorer
- D) Role-Based Access Control (RBAC)
True or False: All database backups in NDB are encrypted by default.
- A) True
- B) False
Fill in the blank: ________ in NDB allows for easy replication of database environments across different clusters.
- A) Multi-Cluster HA
- B) Cloning
- C) API Integration
- D) Data Deduplication
Which database management task can be automated using NDB?
- A) Disk defragmentation
- B) Database patching
- C) User interface design
- D) Data entry
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?
- A) Backup
- B) Cloning
- C) Incremental Backup
- D) Performance Analyzer
True or False: NDB allows for manual and automatic creation of snapshots for database protection.
- A) True
- B) False
Fill in the blank: ________ are templates in NDB used to define specific configurations for different database engines.
- A) Compute Profiles
- B) Network Profiles
- C) Software Profiles
- D) Database Parameter Profiles
Which type of backup is most efficient for saving storage space over time?
- A) Full Backup
- B) Incremental Backup
- C) Differential Backup
- D) Snapshot
True or False: Data cloning in NDB always requires downtime of the source database.
- A) True
- B) False
Which feature in NDB provides the ability to set retention policies for backups?
- A) SLA Management
- B) Diagnostics Bundle
- C) Network Configuration
- D) Performance Analyzer
Fill in the blank: To protect a database from unauthorized access, use the ________ feature in NDB.
- A) RBAC
- B) Snapshot
- C) Time Machine
- D) Diagnostics Tool

Section 5: Administering an NDB Environment (15 Questions)

True or False: NDB can be managed exclusively via the CLI without any graphical interface.
- A) True
- B) False
Which NDB role is primarily responsible for database provisioning and management?
- A) Super Administrator
- B) Database Administrator (DBA)
- C) Network Administrator
- D) Infrastructure Administrator
Fill in the blank: The ________ profile in NDB is used to configure VLANs and other network settings for database VMs.
- A) Compute
- B) Network
- C) Software
- D) Security
Which API protocol does NDB primarily use for automation and integration with other tools?
- A) SOAP
- B) REST
- C) FTP
- D) SMTP
Scenario-Based Question: A user needs access to monitor but not manage database resources. Which role should they be assigned in NDB?
- A) Super Administrator
- B) Database Administrator (DBA)
- C) Viewer
- D) Custom Role
True or False: One-Click Patching in NDB can be applied to databases across multiple clusters.
- A) True
- B) False
Fill in the blank: To create a new compute profile, navigate to ________ in the NDB interface.
- A) Administration > Compute Profiles
- B) Administration > Network Settings
- C) Administration > Software Profiles
- D) Administration > Alerts
Which CLI command is used to update a database software profile in NDB?
- A) ndbcli update profile
- B) ndbcli modify software
- C) ndbcli update software
- D) ndbcli manage database
True or False: NDB supports role-based management for both individual users and user groups.
- A) True
- B) False
Which feature in NDB allows for seamless integration with external cloud platforms?
- A) REST API
- B) CLI API
- C) RBAC
- D) High Availability
Scenario-Based Question: An administrator needs to increase the storage allocated to a PostgreSQL database. What is the recommended approach?
- A) Use the Diagnostics Bundle
- B) Adjust the Compute Profile
- C) Modify the Database Parameter Profile
- 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.
- A) True
- B) False
Fill in the blank: The command to list all available clusters in NDB via CLI is ________.
- A) ndbcli list clusters
- B) ndbcli show clusters
- C) ndbcli display clusters
- D) ndbcli clusters view
Which NDB feature allows administrators to view and manage alerts and notifications?
- A) Alerts Dashboard
- B) Diagnostics Tool
- C) Network Monitor
- D) SLA Manager
True or False: All nodes in an NDB cluster must have identical configurations for successful deployment.
- A) True
- B) False

This mock exam provides a fresh set of questions, covering different aspects of Nutanix Database Service and its functionalities, including core concepts, high availability, monitoring, database protection, and administration. Use these questions to assess your understanding and readiness for the NCP-DB certification.