For an NDB offline upgrade, which NDB CLI command should be used to upload the upgrade bundle?
- A . upgrade upload_bundle path=path_to_upgrade_bundle upload bundle
- B . path=path_to_upgrade_bundle upgrade bundle
- C . path=path_to_upgrade_bundle
- D . upload upgrade_bundle path=path_to_upgrade_bundle
D
Explanation:
For an offline upgrade of the Nutanix Database Automation (NDB), the correct command is ‘upload upgrade_bundle’ followed by the path where the upgrade bundle is located. This command initiates the process of uploading the upgrade bundle to the NDB system.
Reference: Nutanix Database Automation documentation, specifically the section on system upgrade procedures.
What is used 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
An administrator needs to patch an Oracle Database Server VM and must ensure Grid home is allocated sufficient storage space.
At a minimum, how much space must be available for Grid home prior to completing this task?
- A . 5GB
- B . 10GB
- C . 15GB
- D . 20 GB
An administrator needs to register a SQL Server Single Node Database Server VM with NDB.
Which condition must exist prior to the administrator 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.
An administrator needs to restore a database provisioned on Storage Spaces. The virtual disks are shared with multiple databases.
Which restore method is supported?
- A . Disk-based restore via NDB GUI
- B . Disk-based restore via NDB CLI
- C . Copy-based restore via NDB GUI
- D . Copy-based restore via NDB CLI
What is required to create an NDB Software Profile Version for PostgreSQL?
- A . Database server VM registered with NDB
- B . Patch file for the installed databases
- C . Installer package for database software
- D . Preconfigured OS image from Prism Element
What is the minimum frequency in minutes configurable for NDB Log Catch-up operation?
- A . 10
- B . 15
- C . 60
- D . 120
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
How would an administrator enter the NDB command line to change the static IP address on the NDB VM?
- A . era-server
- B . era
- C . cerebro_cli
- D . arithmos cli
Within the NDB GUI, an administrator needs to set the shortest schedule interval possible for a database log catch up.
Which value, in minutes, will satisfy this requirement?
- A . 5
- B . 10
- C . 15
- D . 30
While adding Time Machine data access to a Nutanix cluster, when is a storage container mapping needed
- A . When the source database and NDB Server containers are different.
- B . When the source database and NDB VM are on the same container.
- C . When the source and destination database containers are different.
- D . When the source database and NDB provisioning container are the same.
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
What does an NDB compute profile contain?
- A . vCPUs, cores per vCPU, and the amount of memory for the database server VM.
- B . Windows domain name (FQDN), domain user, and password.
- C . VLAN that the new database server VM will use.
- D . An image of the database and operating system generated from the registered database server VM.
What does an NDB compute profile contain?
- A . vCPUs, cores per vCPU, and the amount of memory for the database server VM.
- B . Windows domain name (FQDN), domain user, and password.
- C . VLAN that the new database server VM will use.
- D . An image of the database and operating system generated from the registered database server VM.
What is the first step to install NDB on a Nutanix AHV cluster?
- A . NDB is offered as a SaaS service and doesn’t require any installations.
- B . Download the QCOW2 image file of NDB and upload it to Prism Element.
- C . Run LCM update to get the latest version of NDB.
- D . Open Prism Central and enable the NDB VM in the settings menu.
An administrator needs to take multiple snapshots per day and retain them for one week.
How should the administrator define and schedule the SLA?
- A . • Daily snapshot retention: 7 days
• Daily snapshot at: 2 - B . • Weekly snapshot retention: 1 week
• Daily Snapshot at: 2 - C . • Weekly snapshot retention: 1 week
• Snapshots per Day: 2 - D . • Daily snapshot retention: 7 days
• Snapshots per Day: 2
A customer has NDB configured to create snapshots of their production databases every 4 hours.
A developer requires a copy of the current production data at 7:00am of each day.
What is the most efficient way to meet this requirement?
- A . Authorize the developer in RBAC to create clones as required.
- B . Run a script which creates a clone from the latest snapshot at 7:00am.
- C . Configure Time Machine to create a clone from a daily snapshot at 7:00am.
- D . Configure a done with a daily Data Refresh Schedule at 7:00am.
An administrator needs to perform LCM upgrades on an AHV cluster registered with NDB. The cluster hosts NDB-provisioned database server VMs that are part of a database server cluster.
What should the administrator do to allow the DB Server VMs to stay available while the cluster is being upgraded?
- A . Update Nutanix Cluster
- B . Set VM-Host Affinity
- C . Remove Nutanix Cluster
- D . Unset VM-Host Affinity
The NDB user interface can display which language option?
- A . Korean
- B . Japanese
- C . French
- D . German
A database administrator wants to define initialization variables for different types of database engines and workloads, like OLTP and DW.
What type of profile would be used?
- A . Software Profile Version
- B . Network
- C . Compute
- D . Database Parameters
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.
Which ports must be open between the NDB server and Controller VMs to facilitate iSCSI connections?
- A . 22 and 9440
- B . 80 and 443
- C . 3205 and 3260
- D . 5985 and 5986
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
What step should be taken to make the profile available to all users:
- A . Create an Access Control role with the Create Profile right and assign 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 available state to All.
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
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 this 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.
When preparing to provision multiple database server VMs, an administrator is tasked with configuring this set of VMs with the same number of cores per vCPU.
What is the easiest way for the administrator to accomplish this task?
- A . Create a Compute Profile and apply it to the VMs during provisioning.
- B . Update the VMs after provisioning and enter the changes to the vCPU cores.
- C . After provisioning the VMs. update the DEFAULT_OOB_COMPUTE Profile.
- D . Create a Windows Domain Profile that will synchronize the configurations.
An administrator needs to deploy a cumulative update (CU) for SQL Server.
What steps would the administrator take to prepare this deployment with NDB?
- A . Apply the patch to the profile VM, delete the existing Software Profile and create a new Software Profile using the profile VM as the source.
- B . Create a new Software Profile version using the CU executable and publish that version.
- C . Apply the patch to the profile VM, then create a new Software Profile version using the profile VM as the source.
- D . Create a new Software Profile using the CU executable and publish that profile.
An administrator created a database clone that is scheduled for removal on the last day of the month.
A request has been received to keep the clone for an additional 14 days.
After selecting the desired clone, how should the administrator satisfy this task?
- A . Update the Removal schedule to the desired date.
- B . Update the Removal schedule to the end of the month.
- C . Remove the Removal schedule, then add the desired removal schedule.
- D . Select Update and modify the Removal schedule.
Which policies define Time Machine data availability across multiple registered clusters in NDB?
- A . Recovery Plans
- B . Data Access Management
- C . Data Protection
- D . Service Level Agreements
An administrator has configured NDB HA across multiple Nutanix clusters.
Which failure scenario will require manual interaction for the recovery?
- A . More than one API Server VM is down.
- B . One repository VM is down.
- C . More than one HA proxy VM is down.
- D . NDB Server process is down.
Which disk is omitted from a Software Profile?
- A . System Page File
- B . SQL Installation
- C . User Database
- D . System Database
Which response shows two ways to upgrade an NDB Server?
- A . Out-of-Place Upgrade and In-place Upgrade
- B . One-click Upgrade and In-place Upgrade Auto
- C . Upgrade and Manual Upgrade
- D . One-click Upgrade and Offline Upgrade
What is purpose of the NDB Database Agent service?
- A . Temporarily stores the transaction logs.
- B . Hosts one or more source databases for the same time machine.
- C . Schedules and monitors the NDB-related operations.
- D . Contains an instance of the database engine software.
An administrator needs to provide the least-privilege access to a newly-hired engineer whose task is to add new VLANs or IP Pools in NDB.
Which role should the administrator select to complete this task?
- A . Database Administrator
- B . Super Administrator
- C . Database Infrastructure Administrator
- D . Infrastructure Administrator
How can an administrator exclude Kernel patches for the Linux OS using the most efficient means?
- A . Define a pre-script to disable the repositories in the Patch Now advanced options
- B . Exclude the appropriate repositories on the VM prior to patching.
- C . Exclude the appropriate repositories on the VM and reboot prior to patching.
- D . Define a pre-script to disable the repositories in the Maintenance Window advanced options.
Within NDB, an administrator needs to register a PostgreSQL database server VM with a database.
Where should the database data and log files be located in order to successfully complete this task?
- A . On a separate mount point
- B . On the same mount point
- C . On the same disk as the binary installation
- D . On the same disk as the operating system
What is causing this issue?
- A . The VLAN is DHCP
- B . The VLAN is static
- C . The VLAN is stretched
- D . The VLAN is IPAM
An administrator is trying to register a database server VM with NDB.
Which file types will prevent the registration from being successful if located in the C: drive?
- A . Page
- B . System
- C . Database
- D . Backup
Which statement is true regarding the NDB alert retention feature?
- A . NDB supports alert retention globally.
- B . NDB supports retention at the individual policy.
- C . NDB supports retention at the grouped policy.
- D . NDB supports retention at the registered cluster.
A request is received to refresh a database clone from a new manual snapshot. When the administrator attempts to create the new snapshot from the Time Machine, it is in a Frozen state.
What causes a Time Machine to enter the Frozen state and what are the administrator’s options to complete the request?
- A . Cause: The Time Machine enters a Frozen state when the database is de-registered without removing the Time Machine.
Resolution: The Time Machine must be paused, then the database re-registered with a new Time Machine and a new clone created. - B . Cause: The Time Machine enters a Frozen state when the database is de-registered without removing the Time Machine.
Resolution: To complete the request the database must be re-registered in NDB, create a new Time Machine and create a new clone. - C . Cause: The Time Machine enters a Frozen state when the database is de-registered without removing the Time Machine.
Resolution: To complete the request the database must be re-registered in NDB, this thaws the Time Machine and it resumes operation so the clone can be refreshed. - D . Cause: The Time Machine enters a Frozen state after too many snapshot or log catchup failures.
Resolution: Remediate the snapshot or log catchup failures, this thaws the Time Machine, allowing normal operations to continue and the request can be completed.
Refer to the exhibit.
An administrator attempts to provision their first clustered database environment with NDB. The operation fails with the Operation Error shown in the exhibit.
Which database engine was being deployed during this operation?
- A . Oracle
- B . MySQL
- C . Microsoft SQL
- D . PostgreSQL
Which two options can NDB leverage to refresh a database clone? (Choose two.)
- A . Cerebro logs
- B . Snapshots
- C . Transaction logs
- D . Templates
Which NDB feature collects logs and snapshots from databases?
- A . Database Restore
- B . Time Machine
- C . SLA
- D . One-click Patching
What happens to the primary member in a MongoDB Server Cluster during the NDB patching process?
- A . It is patched last and is restored to its original state.
- B . It becomes a read-only member during the patching process.
- C . It is skipped during the patching process to ensure no downtime.
- D . It is patched first and then becomes a secondary member.
Refer to the exhibit.
A request is received to provision a new Oracle SIHA DB & VM to test ASMLIB on OEL79 and Oracle 19c. When walking through the provisioning workflow, only ASMFD is available in the ASM Driver drop down.
What is necessary to provision the requested SIHA DB and DB VM with ASMLIB?
- A . Update the software profile to include the ASMLIB driver.
- B . Install ASMLIB on the NDB server.
- C . Update the NDB driver config to enable ASMLIB for Oracle.
- D . Install ASMLIB on the database server.
Refer to the exhibit.
An administrator, whose accounts are shown in the exhibit, is trying to add a new database admin as a local user to NDB, but is unable to complete the task.
What is most likely the cause of the issue?
- A . The administrator is logged in with the Super Admin account.
- B . An email address is required for the Super Admin account.
- C . The administrator is logged in with the Database Admin account.
- D . Only users in the domain admins group can create local users.
What are two status values that can be set within the Alerts Dashboard? (Choose two.)
- A . Auto
- B . Resolved
- C . Data Resiliency
- D . Acknowledged
What is the purpose of Data Access Management policies in NDB Multi-Cluster?
- A . To register multiple Nutanix clusters in NDB
- B . To perform snapshot operations on a single Nutanix cluster
- C . To manage time machine data availability across all registered Nutanix clusters in NDB
- D . To remove data accessibility of a time machine across all registered Nutanix clusters in NDB
How does NDB send notifications when alerts are generated?
- A . SNMP
- B . APIs
- C . Pulse
- D . Email