Nutanix Updated NCP-DB Exam Questions and Answers by iqra

The NDB GUI allows an administrator to set the schedule interval for a database log catch up, which is the process of collecting transaction logs periodically from the source databases and storing them in the time machine. The shortest possible value for this interval is 15 minutes, as per the NDB documentation1. This means that the NDB time machine will capture the database logs every 15 minutes and use them for backup, restore, clone, and refresh operations. References: Nutanix Database Management & Automation (NDMA), page 29; Nutanix Support & Insights, section “Log Catch-up”

 Nutanix Database Automation (NCP-DB) introduces the concept of MS SQL Server database groups, which allows multiple databases running in the same database instance to be grouped as one Time Machine entity1. This applies to both single DB Server VM setups, standalone databases, as well as to Availability Group databases1. However, it does not support Point In Time Recovery (PITR)-based Service Level Agreements (SLAs) for database groups containing mixed Recovery Models. This means that if the databases within the group have different recovery models, PITR-based SLAs cannot be applied to the group as a whole.

NDB performs anonymization through a sanitized snapshot workflow. In the CLI syntax, sanitised is a Boolean flag; it must be set to true to request the creation of a sanitized snapshot. The delete_sanitised_snapshot_in_days parameter defines how long NDB retains that sanitized artifact before deleting it, while id identifies the clone and snapshot_name supplies the sanitized snapshot name. Values such as yes and no are not the documented Boolean forms for this parameter, and setting the flag to false would disable the sanitation request. Option A is therefore the valid command form. This method keeps the masking or anonymization operation inside the managed NDB lifecycle and allows retention to be controlled explicitly. Nutanix documents these parameters in its sanitized snapshot creation procedure.

Time Machine is a feature of Nutanix Era that allows you to create and manage snapshots of your databases. You can use Time Machine to create clones from any snapshot, either manually or automatically. You can also configure Time Machine to create clones from snapshots based on a schedule, such as daily, weekly, or monthly. This way, you can ensure that your clones are always up to date with the latest data from your production databases. In this scenario, the most efficient way to meet the developer’s requirement is to configure Time Machine to create a clone from a daily snapshot at 7:00am. This will save the developer’s time and effort, as well as reduce the storage consumption by using the existing snapshots. References:

Nutanix Database Management & Automation Training Course

Nutanix Certified Professional - Database Automation datasheet

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