nutanix‐database‐automation‐ncp‐db‐ncp‐db‐65‐exam‐questions_4 - 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 5: Protect NDB-Managed Databases Using Time Machine

Question 41:
What should an administrator do if the option to restore data to a Point in Time is not available when using Time Machine?

  • A. Take a Manual snapshot and use it for DB recovery.
  • B. Update the TM schedule to perform DB Log catch-up.
  • C. Use an SLA that supports Continuous Log retention.
  • D. Use a Brass SLA and update the Log catch-up frequency.

Correct Answer: C. Use an SLA that supports Continuous Log retention.
Explanation: To enable Point in Time Recovery (PITR), the SLA must support Continuous Log retention, which ensures that NDB captures and stores the database logs continuously, allowing recovery to any point within the retention period.


Question 42:
An administrator needs to maintain five days of time-travel capability to any second, plus an additional seven days of discrete recovery at a daily interval. How should the administrator define the Frequency and Retention on the SLA?

  • A. Continuous log retention (days): 7, Daily snapshot retention (days): 5
  • B. Continuous log retention (days): 5, Weekly snapshot retention (weeks): 1
  • C. Weekly snapshot retention (weeks): 1, Continuous log retention (days): 7
  • D. Daily snapshot retention (days): 7, Continuous log retention (days): 5

Correct Answer: D. Daily snapshot retention (days): 7, Continuous log retention (days): 5
Explanation: The administrator should set continuous log retention for 5 days to provide time-travel capability and daily snapshots for 7 days to provide discrete recovery.


Question 43:
What does a "Frozen" status indicate for an NDB Time Machine?

  • 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 "Frozen" status indicates that the database associated with the Time Machine has been de-registered from NDB, but the Time Machine itself has not been deleted.


Question 44:
Which policy defines Time Machine data availability across multiple registered clusters in NDB?

  • A. Recovery Plans
  • B. Service Level Agreements
  • C. Data Access Management
  • D. Data Protection

Correct Answer: A. Recovery Plans
Explanation: Recovery Plans define how Time Machine data is managed and made available across multiple registered clusters in NDB, specifying the source and target clusters, snapshot frequency, and retention.


Question 45:
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 all database files to the source volume
  • B. Replaces the source volume with specific DB disks
  • C. Copies the specific database files to the source volume
  • D. Replaces the source volume with the snapshot volume

Correct Answer: C. Copies the specific database files to the source volume
Explanation: NDB handles the restore operation by copying only the specific database files needed from the snapshot to the source volume, ensuring that other databases sharing the volume are not affected.


Question 46:
Which two status values can be set within the Alerts Dashboard? (Choose two.)

  • A. Acknowledged
  • B. Data Resiliency
  • C. Resolved
  • D. Auto

Correct Answer: A. Acknowledged, C. Resolved
Explanation: Alerts in NDB can be marked as "Acknowledged" when they are being addressed and "Resolved" when they have been fixed or no longer require attention. "Data Resiliency" and "Auto" are not alert status values.


Question 47:
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 the 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: D. Create a Software Profile Version with PostgreSQL 13.8
Explanation: The first step in the NDB patching workflow is to create a new Software Profile Version that includes the desired PostgreSQL version (13.8 in this case) to be applied to the database server VM.


Question 48:
An administrator is tasked with providing a Jr DBA with access to NDB with limited capabilities. This user should only be able to:

  • Provision Databases
  • Provision Database Servers
  • Create Clones
  • Refresh Clones
  • Patch Database Servers

How can the administrator complete this task?

  • A. Clone the Database Admin role, and remove all but the desired privileges.
  • B. Create a role with only those privileges, assign the role to the Jr DBA user.
  • C. Clone the Database Admin role, and add the desired privileges.
  • D. Create a user for the Jr DBA, and assign only those privileges.

Correct Answer: B. Create a role with only those privileges, assign the role to the Jr DBA user.
Explanation: Creating a custom role with the specific privileges required and then assigning that role to the Jr DBA user is the most efficient and secure way to limit access.


Question 49:
Which two options can NDB leverage to refresh a database clone? (Choose two.)

  • A. Snapshots
  • B. Transaction logs
  • C. Templates
  • D. Cerebro logs

Correct Answer: A. Snapshots, B. Transaction logs
Explanation: NDB can use snapshots and transaction logs to refresh a database clone, ensuring that the clone reflects the latest state of the source database. "Templates" and "Cerebro logs" are not used for refreshing clones.


Question 50:
An administrator wants to set the shortest possible interval for database log catch-up in NDB. What is the minimum frequency, in minutes, that can be configured?

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

Correct Answer: C. 15 minutes
Explanation: The minimum interval for log catch-up operations in NDB is 15 minutes, which ensures that transaction logs are collected frequently to minimize data loss.


Section Summary:

This set of questions covers the protection and recovery features of NDB, focusing on Time Machine SLAs, database restoration, alert management, and patching workflows.

Would you like to proceed with the next set of questions or focus on a specific topic? 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 6: Administer an NDB Environment

Question 51:
What step should be taken to make a profile available to all users?

  • A. Create an Access Control role with the "Create Profile" right and assign it to all users.
  • B. Create an Access Control group with the desired users and grant it the Database Admin role.
  • C. Update the profile and set the status to "Published."
  • D. Update the profile and set the available state to "All."

Correct Answer: C. Update the profile and set the status to "Published."
Explanation: To make a profile available to all users, the administrator must change the profile status to "Published," allowing it to be visible and accessible to all users.


Question 52:
Which type of profile contains information related to the SQL service startup account and the NDB worker service account?

  • A. Windows Domain
  • B. Network
  • C. Software
  • D. Database Parameter

Correct Answer: A. Windows Domain
Explanation: The Windows Domain profile includes details such as the domain name, credentials for joining VMs to the domain, and information related to the SQL service startup account and the NDB worker service account.


Question 53:
An administrator needs to register a SQL Server Single Node Database Server VM with NDB. Which condition must exist prior to completing this task?

  • A. Database files must exist in the Windows OS boot drive.
  • B. The login account provided must be a member of the sysadmin role.
  • C. The SQL service account should not have read privileges on the mount points.
  • D. SQL Server instance must be in single-user mode.

Correct Answer: B. The login account provided must be a member of the sysadmin role.
Explanation: To register a SQL Server Single Node Database Server VM with NDB, the login account provided must be a member of the sysadmin role to ensure sufficient privileges for managing the server.


Question 54:
What is the first step to installing NDB?

  • A. Download the image file from the Support Portal.
  • B. Create a new VM in Prism Element.
  • C. Configure network settings in Prism Central.
  • D. Apply the latest software patches from Nutanix.

Correct Answer: A. Download the image file from the Support Portal.
Explanation: The first step in installing NDB is to download the appropriate image file (QCOW2 or OVA) from the Nutanix Support Portal to start the installation process.


Question 55:
What is the minimum frequency in minutes configurable for the NDB Log Catch-up operation?

  • A. 10
  • B. 15
  • C. 60
  • D. 120

Correct Answer: B. 15
Explanation: The minimum frequency for the NDB Log Catch-up operation is 15 minutes, allowing for frequent log updates to maintain up-to-date data recovery points.


Question 56:
How does NDB send notifications when alerts are generated?

  • A. SNMP
  • B. Email
  • C. APIs
  • D. Pulse

Correct Answer: B. Email
Explanation: NDB sends alert notifications via email, allowing administrators and stakeholders to stay informed about the status and issues of NDB-managed databases.


Question 57:
When applying procedural concepts to provision databases, which programming paradigm is commonly used?

  • A. Object-oriented programming
  • B. Procedural programming
  • C. Functional programming
  • D. Event-driven programming

Correct Answer: B. Procedural programming
Explanation: Procedural programming is often used to implement the steps and processes involved in provisioning databases, where a series of commands and functions are executed in a specific order.


Question 58:
Which database system uses NDB concepts as its underlying storage engine?

  • A. MySQL
  • B. PostgreSQL
  • C. Microsoft SQL
  • D. Oracle

Correct Answer: A. MySQL
Explanation: NDB (Nutanix Database Service) concepts are utilized by MySQL for certain database operations and clustering, such as the use of storage engines like InnoDB and replication features.


Question 59:
An administrator is adding a stretched VLAN in NDB. Which VLAN type(s) will satisfy this task?

  • A. Only dynamic VLANs
  • B. Only static VLANs that are managed in NDB
  • C. Both static and dynamic VLANs
  • D. Only VLANs that are not managed in NDB

Correct Answer: B. Only static VLANs that are managed in NDB
Explanation: A stretched VLAN can be added in NDB using only static VLANs that are managed within NDB. Dynamic VLANs or VLANs not managed in NDB are not supported for this purpose.


Question 60:
What does NDB use to temporarily store the transaction logs of the source database before they are copied to the log?

  • A. Database Agent
  • B. NDB Drive
  • C. Time Machine
  • D. NDB Profiles

Correct Answer: C. Time Machine
Explanation: The Time Machine feature in NDB temporarily stores transaction logs of the source database, which are then used for backup, restore, and refresh operations.


Section Summary:

This set of questions covers the administration of an NDB environment, focusing on profile management, alert notifications, database registration, log management, and network configurations.

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

Let's continue with the final set of 15 questions to complete the Nutanix Certified Professional - Database Automation (NCP-DB) exam simulation.

Section 7: Perform Database Operations, Patching, and Upgrades

Question 61:
An administrator needs to roll back an Oracle patch on a database server VM using NDB. What is required for this action to be successful?

  • A. The patch must have been applied using NDB.
  • B. The database must be shut down.
  • C. The patch must have been applied on Grid home only using NDB.
  • D. The database must be in read-only mode.

Correct Answer: A. The patch must have been applied using NDB.
Explanation: NDB can only roll back patches that were applied using its own tools and processes. If the patch was applied manually or outside of NDB, the rollback process would not be supported by NDB.


Question 62:
Which ports are used by the NDB database agent for API calls?

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

Correct Answer: A. 443 and 9440
Explanation: Ports 443 (HTTPS) and 9440 (Prism Central management) are used for secure API calls between NDB components, enabling communication for managing database operations.


Question 63:
What is the first step to apply Linux OS patches within NDB?

  • A. Apply patches immediately using the NDB UI
  • B. Schedule a user patch implementation
  • C. Create and associate a maintenance window
  • D. Validate the patch repository configuration

Correct Answer: D. Validate the patch repository configuration
Explanation: Before applying any patches, the repository configuration must be validated to ensure the correct patches are available and accessible to NDB.


Question 64:
An administrator needs to distribute NDB management plane components. Which NDB HA VM needs to be deployed on the same L2 network?

  • A. NDB Agent
  • B. API Server
  • C. Repository VMs
  • D. HA Proxy VMs

Correct Answer: B. API Server
Explanation: The API Server must be on the same Layer 2 (L2) network as other NDB management components to ensure smooth communication and coordination of tasks.


Question 65:
Which action should be completed before updating Oracle Database software?

  • A. Verify CVMs have the required memory allocated.
  • B. Download the PSU from Oracle support.
  • C. Perform rolling reboots of the Oracle Database VMs.
  • D. Verify the Oracle OS version is supported on AHV.

Correct Answer: B. Download the PSU from Oracle support.
Explanation: Before updating Oracle Database software, the Patch Set Update (PSU) must be downloaded from Oracle support to ensure the update process has the necessary files.


Question 66:
An administrator needs to configure Time Machine data availability across multiple registered clusters in NDB. What should they do?

  • A. Add Data Access to each Nutanix cluster and assign a DAM policy.
  • B. Update the cluster's Data Access & select the remote cluster.
  • C. Update the SLA on the Time Machine & schedule the remote replication.
  • D. Select the snapshots & replicate them to each Nutanix cluster.

Correct Answer: A. Add Data Access to each Nutanix cluster and assign a DAM policy.
Explanation: To manage Time Machine data availability across multiple clusters, the administrator must configure Data Access Management (DAM) policies for each cluster.


Question 67:
An administrator wants to replicate database snapshots to remote Nutanix clusters. What is required to achieve this?

  • A. Use an SLA with cross-cluster replication enabled.
  • B. Schedule daily snapshot replication in the Time Machine settings.
  • C. Set up a multi-cluster configuration in NDB.
  • D. Enable asynchronous replication between the clusters.

Correct Answer: A. Use an SLA with cross-cluster replication enabled.
Explanation: To replicate database snapshots across clusters, an SLA with cross-cluster replication enabled must be used to ensure that snapshots are replicated according to the defined policies.


Question 68:
What happens to the primary member in a MongoDB Server Cluster during the NDB patching process?

  • A. It becomes a read-only member during the patching process.
  • B. It is patched first and then becomes a secondary member.
  • C. It is skipped during the patching process to ensure no downtime.
  • D. It is patched last and is restored to its original state.

Correct Answer: B. It is patched first and then becomes a secondary member.
Explanation: During the patching process, NDB patches the primary member first, which triggers a failover to a secondary member. The patched primary becomes a secondary member to ensure minimal downtime.


Question 69:
What is required to create an NDB Software Profile?

  • A. Installer package for database software
  • B. Database server VM registered with NDB
  • C. Patch file for the installed databases
  • D. OS image registered with Prism Element

Correct Answer: A. Installer package for database software
Explanation: The installer package is necessary for creating a software profile in NDB, which includes all the required files and configurations for the database software.


Question 70:
What does the NDB Compute Profile define?

  • A. The size of the database server VM
  • B. The VLAN that the new database server VM will use
  • C. The Windows domain name (FQDN), domain user, and password
  • D. An image of the database and operating system

Correct Answer: A. The size of the database server VM
Explanation: The NDB Compute Profile defines the vCPUs, memory, and other compute resources allocated to a database server VM.


Question 71:
What is the purpose of a maintenance window in NDB?

  • A. To automate repeated maintenance tasks like OS patching
  • B. To monitor database health metrics in real-time
  • C. To configure backup and recovery operations
  • D. To set up user roles and permissions

Correct Answer: A. To automate repeated maintenance tasks like OS patching
Explanation: A maintenance window is used to schedule and automate regular maintenance tasks such as operating system and database patching to minimize disruptions.


Question 72:
Which language options are currently supported in the NDB user interface for the database server VM operating system and database software?

  • A. English, Korean, and Japanese
  • B. English, German, and Japanese
  • C. English and French only
  • D. English and German only

Correct Answer: B. English, German, and Japanese
Explanation: NDB supports English, German, and Japanese for the user interface options of database server VM operating systems and database software.


Question 73:
What does NDB use to manage log retention policies?

  • A. Data Access Management
  • B. Service Level Agreements
  • C. Time Machine Settings
  • D. Database Profiles

Correct Answer: B. Service Level Agreements
Explanation: NDB uses SLAs to define log retention policies, which determine how long transaction logs are retained before they are purged.


Question 74:
Which of the following is a benefit of using Time Machine to protect NDB-managed databases?

  • A. Provides real-time data analytics
  • B. Reduces the need for database indexing
  • C. Simplifies and automates backup and recovery processes
  • D. Enhances network security

Correct Answer: C. Simplifies and automates backup and recovery processes
Explanation: Time Machine is designed to simplify and automate backup and recovery processes, providing administrators with a straightforward way to protect their databases.


Question 75:
What is the purpose of configuring a Repository Profile in NDB?

  • A. To manage user access and permissions
  • B. To store database backup files
  • C. To define where the OS patches are downloaded from
  • D. To control network traffic for database communication

Correct Answer: C. To define where the OS patches are downloaded from
Explanation: A Repository Profile in NDB specifies the repository location from which OS patches are fetched, ensuring that patches are applied from a trusted source.


Conclusion:

This final set of questions completes the full 75-question deck for the Nutanix Certified Professional - Database Automation (NCP-DB) exam simulation. These questions covered various aspects of NDB, including installation, patching, database operations, log management, SLAs, and more.

Feel free to ask if you'd like more practice questions, further explanations on specific topics, or other study materials!