Summer Sale Discount Flat 70% Offer - Ends in 0d 00h 00m 00s - Coupon code: 70diswrap

Nutanix NCP-DB Dumps

Page: 1 / 31
Total 308 questions

Nutanix Certified Professional - Database Automation (NCP-DB v7.5) Questions and Answers

Question 1

An administrator has been asked to provision a new Oracle single instance database, but cannot proceed with the first step of the wizard. Which statement best describes the current situation?

Options:

A.

Time Machine is not configured.

B.

Software profile is missing.

C.

No remote clusters are configured.

D.

A snapshot must be taken on the original DB.

Question 2

For an NDB offline upgrade, which NDB CLI command should be used to upload the upgrade bundle?

Options:

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

Question 3

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?

Options:

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.

Question 4

An administrator needs to deploy a database resilient cluster engine across three clusters. Which database engine can be used for this scenario?

Options:

A.

MariaDB

B.

MysQL

C.

PostgreSQL

D.

Oracle

Question 5

An administrator needs to restore a database provisioned on Storage Spaces. The virtual disks are shared with multiple databases.

Which restore method is supported?

Options:

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

Question 6

How can Era be config90ured to send alert notifications to email recipients?

Options:

A.

From Administration select Era Service then go to Era service name and setup email notification,

B.

From Administration, select access control then add a user end setup email notification.

C.

From Administration, select Ere Service then go to configure notification widget and then click update to update SMTP server configuration

D.

From Administration select access control, select SMTP and then click update to update SMTP sewer configuration.

Question 7

An administrator needs to protect a database with a Point In Time Recovery (PITR) SLA that provides a minimum of seven days of log

recovery.

What is the minimum Default SLA that meets this requirement?

Options:

A.

DEFAULT_008 GOLD SLA

B.

DEFAULT_008 BRONZE SLA

C.

DEFAULT_008 SILVER SLA

D.

DEFAULT_008 BRASS SLA

Question 8

An administrator begins an SQL database clone deletion, but notices it fails almost immediately.

What could be the cause of this failure?

Options:

A.

A refresh operation is in progress.

B.

The clone has been marked as Immutable.

C.

The database was not marked as Offline before the operation.

D.

The database data drives are shared with other applications.

Question 9

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?

Options:

A.

Database Administrator

B.

Super Administrator

C.

Database Infrastructure Administrator

D.

Infrastructure Administrator

Question 10

At 2:15 PM, an application developer accidentally executes a destructive DROP TABLE command on a production Oracle database managed by NDB. The last scheduled daily snapshot occurred at midnight, but log catch-up is enabled and healthy. The developer requires a copy of the data exactly as it appeared at 2:10 PM to recover the lost table without interrupting the live production instance.

How should the NDB administrator proceed?

Options:

A.

Access the NDB Time Machine and run a Restore operation, choosing the point-in-time recovery option for 2:10 PM.

B.

Access the NDB Profiles menu and provision a new database instance, selecting the 2:10 PM transaction-log sequence as the software baseline.

C.

Access the NDB Time Machine and perform a Refresh operation, choosing the log catch-up option for 2:10 PM.

D.

Access the NDB Time Machine and create a Clone, choosing the point-in-time recovery option for 2:10 PM.

Question 11

An administrator is setting up an NDB VM in a highly segmented environment in which only specific ports are allowed.

Before deploying the NDB VM, which two options identify ports that must be open to the Controller VMs (CVMs)? (Choose two.)

Options:

A.

443

B.

9440

C.

1433 and 5432

D.

3205 and 3260

Question 12

An administrator has been tasked with cloning a production HR database but needs to anonymize the database during the cloning process.

Which command should the administrator execute using the NDB CLI to anonymize the database?

Options:

A.

clone snapshot id= < clone_id > snapshot_name= < snapshot_name > sanitised=true delete_sanitised_snapshot_in_days= < no_of_days >

B.

clone snapshot id= < clone_id > snapshot_name= < snapshot_name > sanitised=no delete_sanitised_snapshot_in_days= < no_of_days >

C.

clone snapshot id= < clone_id > snapshot_name= < snapshot_name > sanitised=yes delete_sanitised_snapshot_in_days= < no_of_days >

D.

clone snapshot id= < clone_id > snapshot_name= < snapshot_name > sanitised=false delete_sanitised_snapshot_in_days= < no_of_days >

Question 13

An administrator enables NDB Multi-cluster.

Which NDB Service component is deployed on a dedicated VM?

Options:

A.

Agent VM

B.

HAProxy

C.

Repository DB

D.

APIVM

Question 14

An administrator needs to migrate a large 1/0-intensive database that doesn't support multi-disk layout.

How should the storage be provisioned with Era to support the database while optimizing performance?

Options:

A.

Volume Group

B.

Volume Group with Load Balancing

C.

Storage Spaces

D.

vDisk based provisioning

Question 15

An administrator has run into an error when provisioning a new Oracle database VM.

What is the best action that the administrator should perform in the NDB GUI to provide the most complete picture to send to Nutanix support on that specific operation?

Options:

A.

From the Administration section of NDB. go to the Diagnostics section and chose Generate Bundle.

B.

Copy the error message from the Operations menu.

C.

In the operations menu, select the job the failed and choose Generate Bundle from the lower right.

D.

Take a screen shot of the error in the Operations menu.

Question 16

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?

Options:

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.

Question 17

What is the terminology used for registering an existing database with Era?

Options:

A.

Greenfield Database

B.

Brownfield Database

C.

Cloned Database

D.

Source Database

Question 18

Which statement describes a user in Era with the Database Infrastructure Admin role?

Options:

A.

The user is able to manage software profiles, Network Profiles. database Instance parameter profiles and time machine SLA

B.

The user is able to manage software profiles, Network Profiles. database parameter profiles end Time Machine SLAs,

C.

The user is able to manage database profiles, Network Profiles, database Instance parameter profiles and time machine SLA

D.

The user is able to manage software profiles, database parameter profiles and SLAs

Question 19

How can an administrator exclude Kernel patches for the Linux OS using the most efficient means?

Options:

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.

Question 20

Nutanix NDB gives an administrator the ability to create highly-available database pairs with which two databases? (Choose two.)

Options:

A.

MySQL

B.

PostgreSQL

C.

SQL Server

D.

MariaDB

Question 21

An administrator is attempting to enable high availability (HA) for NDB across three Nutanix clusters located in separate data centers. If the network latency between two clusters exceeds 25ms RTT, what impact might this have on the NDB HA setup?

Options:

A.

HA will operate with increased delay.

B.

HA cannot be enabled due to the latency.

C.

The clusters will not synchronize.

D.

There will be no impact on HA functionality.

Question 22

An administrator needs to create a software profile.

What should the administrator do first with the VM that will be used as the template for this task?

Options:

A.

Register the database server VM with NDB.

B.

Configure SELinux on the database server VM.

C.

Upload the VM’s QCOW2 disk to the image service in Prism Central.

D.

Download and run the prerequisites script.

Question 23

An administrator is creating a Windows Domain profile in Era.

Which optional field can be skipped and provided during the provisioning process?

Options:

A.

Domain to join

B.

Domain Account

C.

Organizational Units

D.

SQL Service Startup Account

Question 24

Which action should be completed before updating Oracle Database software?

Options:

A.

Verify CVMs have the required memory allocated.

B.

Perform rolling reboots of the Oracle Database VMs.

C.

Verify the Oracle OS version is supported on AHV.

D.

Download the PSU from Oracle support.

Question 25

Where should an administrator perform an upgrade within the Era management interface?

Options:

A.

Operations > Current Recent

B.

Profiles Software

C.

Alerts

D.

Administration > Maintenance

Question 26

An organization has NDB HA enabled across multiple Nutanix clusters.

If two clusters are using ESXi and one cluster is using AHV, which additional component is necessary to support cross-hypervisor compatibility?

Options:

A.

Stretched VLANs for all nodes

B.

NGT

C.

Nutanix Prism Central

D.

VirtlO

Question 27

An NDB administrator wants to configure object storage for database log backups.

What step must be completed first to enable Nutanix Objects for use in NDB?

Options:

A.

Register an S3-compatible Object Store.

B.

Register the NC2 cluster in the desired cloud.

C.

Register a Prism Central instance in NDB.

D.

Register the Prism Element instance hosting Nutanix Objects.

Question 28

How should an administrator modify the Alert Severity level within Era?

Options:

A.

From the dropdown menu choose Alerts Policies. Choose the Policy to be modified and set the desired severity level.

B.

From the dropdown menu choose Alerts > List. Select the message to be changed end choose Set Status to Resolved or Set Status to Acknowledged.

C.

From the dropdown menu choose Alerts Policies. Chose the Poliq to be modified and chose either Set Enabled or Set Disabled,

D.

From the dropdown menu choose Alerts > Policies. Then choose Update next to Alert Retention,

Question 29

An administrator needs to deploy a cumulative update (CU) for SQL Server.

What steps would the administrator take to prepare this deployment with NDB?

Options:

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.

Question 30

Which two network prerequisites are required to deploy an Era instance in production? (Choose two.)

Options:

A.

NTP, DNS servers, gateway, and subnet mask must be available and visible to Ere,

B.

One static IP address must be available and changed using CLI after VM deployment.

C.

A storage container must be available es a prerequisite.

D.

An SMTP server and details must be provided for notifications.

Question 31

An administrator is looking to provision a relational database management system (RDBMS) in an HA instance. Which two database engines are supported with NDB? (Choose two.)

Options:

A.

MongoDB

B.

MariaDB

C.

Oracle

D.

PostgreSGL

Question 32

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?

Options:

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.

Question 33

An administrator wants to view the information for all the roles and the number of users assigned to each of them What role must a user belong to in order to view this information?

Options:

A.

Database infrastructure administrator

B.

Database administrator

C.

Infrastructure administrator

D.

Super Administrator

Question 34

What severity level are alert policies set to for ND8?

Options:

A.

Error

B.

Info

C.

Critical

D.

Warning

Question 35

When doing an Era software upgrade for a Multi-Cluster enabled installation, which component is upgraded first?

Options:

A.

Era Cluster Agent

B.

Database Server Agent

C.

Era Date Warehouse

D.

Era Sewer

Question 36

An administrator manages an multi-cluster NDB instance with HA enabled. After failure, more than one API server VM is down. How should the administrator restore full functionality?

Options:

A.

Restart all database server VMs as NDB HA only tolerates single API server failure.

B.

Manually distribute connections across remaining clusters.

C.

Call Nutanix support to reset all API server connections.

D.

Ensure at least one API server VM is online; the rest will recover automatically.

Question 37

An administrator is preparing to deploy NDB in a High Availability configuration so that the NDB control plane is distributed across different sites and protected against a failure at the primary data center.

Which prerequisite must be met before enabling NDB High Availability?

Options:

A.

Round-trip time of less than 25 ms

B.

A minimum two-cluster topology

C.

A minimum of three AHV clusters

D.

Round-trip time of less than 5 ms

Question 38

An administrator needs to patch multiple Microsoft SQL Server databases managed by NDB.

Which NDB capability simplifies this operation?

Options:

A.

Database Grouping

B.

Software Profile versions

C.

Database Cloning

D.

Maintenance Windows

Question 39

How can NDB updates be downloaded for a dark site?

Options:

A.

Download the upgrade bundle from the Nutanix Support portal and manually upload it to the NDB server.

B.

Go into the Administrator > Maintenance section in NDB and download the most recent version.

C.

Change the network that NDB is hosted on so it has access to https://download.nutanix.com.

D.

Download the upgrade bundle from the Nutanix support Portal and upload it to Prism Element > Images

Question 40

An administrator has created a new SQL Server software profile version to apply the latest cumulative update.

What should the administrator do to make it available to all users?

Options:

A.

Set the status of the existing software profile version to Unpublished.

B.

Update the software profile version and set the status to Published.

C.

Deprecate the existing software profile version and use the new one.

D.

Select the software profile version with the update and optimization,

Question 41

An administrator has deployed an NDB HA setup. An electrical maintenance window needs to be planned and the clusters where NDB is deployed must be powered off.

After shutting down the load balancer server, what should the administrator do next?

Options:

A.

In the sudo systemctl stop patroni command.

B.

Shutdown the API standby node.

C.

Run the high-availability list command.

D.

Shutdown the API leader node.

Question 42

When registering SAP HANA Database and Database Server VM there are several (Linux) OS configuration requirements that must be set before registering a database Or a database server VM.

Which system file should the entry, secure_pazh be configured in?

Options:

A.

/ezc/sudores

B.

'etc/ profile

Question 43

What are two status values that can be set within the Alerts Dashboard? (Choose two.)

Options:

A.

Auto

B.

Resolved

C.

Data Resiliency

D.

Acknowledged

Question 44

Which two statements best describe the features and functionality of Era Oracle patching? (Choose two.)

Options:

A.

Era does not require native Oracle Utility OpatchAuto to create the patch profile,

B.

Era patching can be automated using REST API/CLI for scheduled patching many Oracle servers in a fleet patching scenario,

C.

Era patching for Oracle databases has automatic rollback if any of the steps in the patching workflow fails.

D.

Era Oracle fleet patching can be rolled back if issues ere encountered after successful patching.

Question 45

An administrator needs to provision PostgreSQL instance from a software profile. The software profile was created from a VM with services such as etcd, HAProxy, Patroni and keepalived installed.

What should the administrator perform to successfully provision an HA instance?

Options:

A.

Provision an HA instance with the services enabled.

B.

Disable the services, create a software profile version, and provision an HA instance.

C.

Provision an HA instance with the services disabled.

D.

Enable the services, create a software profile version, and provision an HA instance.

Question 46

A database administrator is working with a cloned database and creates a clone removal schedule.

Which two default actions are taken on the cloned database? (Choose two.]

Options:

A.

NDB deletes the cloned database.

B.

NDB de-registers the cloned database.

C.

NDB marks the cloned database as offline.

D.

NDB deletes the cloned database VM.

Question 47

Which statement describes what the Time Machine Heal function can be used for?

Options:

A.

Patches a Time Machine to the latest NDB levels.

B.

Removes gaps in the Time Machine's restore capability.

C.

Refreshes a database clone in Time Machine.

D.

Restores a Time Machine from snapshot in the event of malware.

Question 48

An administrator tried to provision Nutanix Database Service (NDB) from Prism Central Marketplace and is getting the error shown in the exhibit.

Which action would have prevented this issue?

Options:

A.

Configure an IP address when deploying the application.

B.

Import the proper image in the Prism Central.

C.

Provide a subnet with IP Address Management

D.

Register NDB using the correct IP address.

Question 49

An administrator has applied an Oracle security patch to a database server VM registered in Era.

How do you make this change available to other existing database instances?

Options:

A.

Register the VM as a have' database server VM and then create a software profile using this newly registered VIVI.

B.

Create a n.. software profile version from the patched VM.

C.

Merge the changes into an existing software profile.

D.

Create a new software profile in Era from the patched VM.

Question 50

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?

Options:

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 catchupfailures.Resolution: Remediate the snapshot or log catchup failures, this thaws the Time Machine,allowing normal operations to continue and the request can be completed.

Question 51

as

An administrator wants to register a database using a SQL Server User

Where can this user be specified?

Options:

A.

In the Windows Administrator Name field

B.

In the Login field after selecting SQL Server User

C.

Only via the command line registration option

D.

By modifying the code in the API Equivalent section

Question 52

While registering a database, the Group Database with One Time Machine option is selected.

What is the key architectural benefit of this option?

Options:

A.

Optimized RPO and performance

B.

Faster provisioning

C.

Independent recovery for each database

D.

Reduced storage consumption

Question 53

An administrator wants to provision a MySQL high-availability instance.

Which option must be enabled in NDB to allow automated routing and failover of application traffic to the database replicas?

Options:

A.

Configure External Load Balancer

B.

HAProxy

C.

Create MySQL Router

D.

Enable Multi-Host Connection String

Question 54

When executing an automated database restore or point-in-time log replay on a Linux target host with SELinux configured in Enforcing Mode, how does NDB ensure that the operating-system kernel does not block the attachment of newly restored storage volumes?

Options:

A.

NDB dynamically adjusts SELinux policies as needed while recording the security changes in the audit log.

B.

NDB switches the operating system to permissive mode while the storage layer copies the files.

C.

NDB provisions predefined SELinux security contexts and file policies tailored to the database paths.

D.

NDB injects temporary kernel-bypass modules that disable the local audit system until the disks are mounted.

Question 55

Era allows custom metadata to be assigned to entities (clones, time machines, databases, and database servers) by using which component?

Options:

A.

Tags

B.

Notes

C.

Text

D.

Index

Question 56

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

Options:

A.

10

B.

15

C.

60

D.

120

Question 57

An administrator changed NDB language settings from English to Spanish, but when accessing NDB from a different workstation the language reverts to English.

Which statement describe the matter?

Options:

A.

The language settings are local to the web browser.

B.

The language settings match workstation regional settings.

C.

The language settings revert to English after logoff.

D.

The language settings are bound to NDB users.

Question 58

A legal team wants to audit a quarter end (July 31st) banking transaction event and asks the administrator to create a SQL database from the timeframe.

What action should the administrator perform within Era?

Options:

A.

Provision a database and attach the July 31st backup from Time Machine.

B.

Restore a backup from July 31st, Recover the database to bring the database up.

C.

Provision a database, restore the backup from Ju)' 31st, and Recover the database to bring the database up.

D.

Create a clone from July 31st snapshot in Time Machine.

Question 59

An administrator would like to use Era for Copy Data Management operations on an Availability Group (AG) database. The AG database is hosted on replicas with different named instances, as shown below:

• SQLAGNI\EMR

• SQLAGN2\EMR

• SQLAGN3\DW

SQLAGN3\DW is running the Analytics service that needs real-time data.

How should the administrator register the database in Era?

Options:

A.

Register the database as an Availability database.

B.

Register the database as a Standalone database,

C.

Register the SQLAGN3 from AG cluster and register the database as Availability database,

Question 60

An administrator has been asked to clone a 2 TB Microsoft SQL Server database within the same Nutanix cluster as the source database and leave the clone in a read-only state.

After the operation completes, how much storage would the Microsoft SQL Server database clone consume without any new writes?

Options:

A.

The same amount of storage as the source database

B.

Fifty percent of the source database size because of inline compression

C.

Twenty percent of the source database size because of post-process compression

D.

Near-zero additional bytes, with only subsequent writes contributing to its storage consumption

Question 61

An administrator needs to assign a VLAN to provide IP address to a database VM. What is the procedure to create the Network Profile?

Options:

A.

Create Network Profile, Define IP Range. Add the VLAN.

B.

Create Network Profile, Select the VLAN, Define IP Range.

C.

Add VLAN, Create Network Profile. Define IP range.

D.

Add VLAN, Define IP range, Create Network Profile.

Question 62

What are two of the required steps to provision a new network in Clusters and extend it to Era? (Choose two.)

Options:

A.

Add a new.' subnet to the correct VPC.

B.

Add the new subnet end VLAN in Network Configuration in PE.

C.

Add the new VLAN in Ere Networks.

D.

Add the new network in Era Multi-Clu5ter Management

Question 63

An administrator needs to provision multiple database clones from the same source database for different purposes, such as QA and Test/Development. To avoid resource starving, the administrator wants to differentiate VM resources for each department.

What is the most efficient way to accomplish this task?

Options:

A.

Create multiple Compute profiles.

B.

Leverage NCM Self Service to deploy database clones.

C.

Use a VM Template for each department.

D.

Generate a playbook to resize database VMs when released.

Question 64

An administrator needs to quickly restore a database to a previous point in time following an accidental data modification. The recovery must minimize downtime and avoid completely reinstalling the database.

Which NDB capability should be used?

Options:

A.

Software Profile

B.

Time Machine

C.

Database Parameters Profile

D.

Database Cloning

Question 65

For which database engine does Era support rolling back a patch using CLI?

Options:

A.

PostgreSQL

B.

Oracle

C.

Microsoft SQL Server

D.

MongoDB

Question 66

An administrator needs to deploy a new PostgreSQL instance but limit the maximum number of database connections after the instance enters production.

as

Which profile should the administrator configure to meet this requirement?

Options:

A.

Windows Domain Profile

B.

Network Profile

C.

Software Profile

D.

Database Parameters Profile

Question 67

An administrator changed the NDB language setting from English to Spanish. However, when the administrator accesses NDB from a different workstation, the language reverts to English.

Which statement describes the cause of the language change?

Options:

A.

The language settings are local to the web browser.

B.

The language settings match the workstation’s regional settings.

C.

The language settings are bound to individual NDB users.

D.

The language settings revert to English after the user signs out.

Question 68

For supported Linux based database VM's managed by NDB, how would an administrator keep software profiles updated for provisioning new database VMs?

Options:

A.

Create a Maintenance window under the policy menu, then under Database VM, add the database VMs to that maintenance window and check both Database and Operating system updates.

B.

Apply patches to a database VM for each supported database engine, then create a new software profile version for each supported database VM for each one using the updated database VM as the source.

C.

Associate the newly provisioned database VMs with a maintenance window so they are keep updated.

D.

In the Administrator menu drop down, go the Maintenance tab and choose Download Upgrade

Question 69

An administrator wants to provision a Microsoft SQL Server Always On availability group with a specific IP address for the availability-group listener.

What prerequisite is needed to support this configuration with NDB?

Options:

A.

Enable the option in the Windows Domain Profile.

B.

Configure IP address management on the Nutanix cluster.

C.

Enable IP selection in the Network Profile.

D.

Provide a valid CIDR range during provisioning.

Question 70

When provisioning a new database, which two options are available for the target? (Choose two.)

Options:

A.

Provision database to an existing registered

B.

Provision database to an existing container.

C.

Provision databases to e new container.

D.

Provision database to a new database sender\cluster.

Question 71

An administrator enables NDB High Availability.

What happens if the active NDB API service becomes unavailable?

Options:

A.

Existing databases stop accepting client connections.

B.

Database patch operations are automatically canceled.

C.

Database backup schedules are suspended until manual recovery is performed.

D.

A standby NDB service assumes management responsibilities.

Question 72

A database administrator wants to clone an SQL database that has Transparent Data Encryption (TDE) enabled.

Which two steps must be taken on the target server for this clone to be successful? (Choose two.)

Options:

A.

Backup the .cer and .pvk files from the source database server VM.

B.

Backup the keystore bundle file from the source database server VM.

C.

Run the pre-clone command script.

D.

Run the post-clone command script.

Question 73

A database administrator is tasked with creating a new clone of a running SQL database. During the clone process, there are no authorized servers are available.

What should the administrator do next?

Options:

A.

Register or provision a new authorized server VIVI.

B.

Click the Action icon to authorize one or more database server VMs.

C.

Register or provision a new database VIVI

D.

Click the Skip icon and choose to authorize later.

Question 74

A NDB non-administrative user wants to provision an Oracle database leveraging a Software Profile that the administrator created. What must the administrator do to ensure that this user has access to the Oracle Software Profile?

Options:

A.

Ensure that specified users have access to the Software Profile using Access Control.

B.

Replicate the Software Profile to other Nutanix clusters for all users to access.

C.

Ensure that the Software Profile has been properly versioned to the latest release of Oracle.

D.

Promote the Software Profile to Published to be available by other NDB users.

Question 75

Where would an administrator find the total space being used by all Era clones for a specific database?

Options:

A.

Under the Cloning widget on the Databases > Clones database summary page.

B.

Under the Capacity widget on the Database Server VMS > List database summary page.

C.

On the Era Dashboard Database Summary Table under Clones.

D.

On the Database > Overview dashboard.

Question 76

What is required to create an NDB Software Profile Version for PostgreSQL?

Options:

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

Question 77

Before registering a database server VM to NDB, what should an administrator use to verify all required software and configuration dependencies?

Options:

A.

LCM

B.

Upgrade Software

C.

Prerequisites script

D.

NCC

Question 78

Which site needs to be reachable to ensure an NDB server can send periodic telemetry data to the central Nutanix repository over port 443?

Options:

A.

download.nutanix.com

B.

developers.nutanix.com

C.

portal.nutanix.com

D.

insights.nutanix.com

Question 79

An administrator needs to provision a database for test purposes with a data protection policy that minimizes storage usage.

How should the administrator best complete this task?

Options:

A.

Disable the SLA for this database during provisioning.

B.

Create a SLA that only leverages zero-byte snapshots.

C.

Select the built-in NONE SLA that is configured for no snapshot or log backup.

D.

Create a custom SLA for this database that only retains 1 day of snapshots and bogs.

Question 80

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?

Options:

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.

Question 81

An administrator needs to restore databases provisioned with a shared disk configuration on Windows Storage Spaces What happens when NDB runs the restore operation?

Options:

A.

NDB restores the disk that are associated with the database.

B.

NDB copies the DB files to be restored to the source volume.

C.

NDB replaces the source volume with the snapshot volume.

D.

NDB performs Tail Log backup to backup any remaining logs.

Question 82

An administrator enables NDB Multi-Cluster on Cluster A. Cluster B is then registered with NDB.

What are the different NDB Service VMs present in each Nutanix cluster?

Options:

A.

Cluster A: 1 NDB ServerCluster B: 1 NDB Agent

B.

Cluster A: 1 NDB AgentCluster B: 1 NDB Server, 1 NDB Agent

C.

Cluster A: 1 NDB Server, 1 NDB AgentCluster B: 1 NDB Agent

D.

Cluster A: 1 NDB AgentCluster B: 1 NDB Server

Question 83

An online retail application requires data to be synchronized between multiple SQL Server databases. This provides clearer reporting from

multiple databases at the Same time for consistency at the end of each business day.

What is the best way to fulfill this requirement?

Options:

A.

Have all the databases present in the same DBVM and register databases in Era.

B.

Have all the databases present in the same DBVM and register databases in Era with Multiple Databases as a Group with one Time Machine.

C.

Have all the databases present in the same DBVM and register databases in Era with One Database with One Time Machine.

D.

Have all the databases in the same Availability Group and register databases in Era.

Question 84

An NDB environment has been deployed with three Nutanix clusters. An administrator has been asked to create a Microsoft SQL Server software profile for each of these clusters.

Which is a requirement to create the above-mentioned profiles?

Options:

A.

Compute profile must be created first on every cluster.

B.

Enable Multi-cluster capabilities for NDB.

C.

Enable High Availability for the current NDB Service.

D.

Each cluster must host a VM with the DB engine.

Question 85

Which two profiles are required to provision a new Oracle database through Era? (Choose two.)

Options:

A.

Memory

B.

Compute

C.

Network

D.

Storage

Question 86

An NDB administrator would like to configure a database with a Time Machine protection mode that includes the Log Catchup operation.

What would be the most essential component to make such a configuration possible?

Options:

A.

At least one snapshot must be taken daily on the database.

B.

An SLA retention schedule must be identified for daily snapshots.

C.

A protection SLA with the Continuous Log Retention option must be selected.

D.

The Log Catchup frequency must be selected and conform to RPO requirements.

Question 87

An administrator has been tasked with deploying Microsoft SQL Server database servers in an Active Directory environment. The administrator must use a group Managed Service Account (gMSA) for the SQL Server services.

Which configuration should be created in NDB?

Options:

A.

Software Profile

B.

Database Parameters Profile

C.

Windows Domain Profile

D.

Network Profile

Question 88

Which file type must be downloaded from the Nutanix Portal for NDB deployment?

Options:

A.

ZIP

B.

QCOW2

C.

OVA

D.

TAR

Question 89

An administrator needs to reset the NDB GUI password.

What should the administrator perform from the SSH session?

Options:

A.

1. Enter the era-server CLl2. Execute: security password reset

B.

sudo passwd era

C.

sudo passwd admin

D.

1.Enter the era CLl2.Execute: security password reset

Question 90

An administrator is initially setting up Time Machine for a newly-provisioned database. What is the maximum number of snapshots per day that can be configured in the GUI?

Options:

A.

4

B.

6

C.

8

D.

12

Question 91

When configuring Disaster Recovery (DR) for an Oracle database using Nutanix Database Service (NDB), how does NDB natively automate and orchestrate high-availability data replication between a primary data center and a remote DR site?

Options:

A.

NDB forces the primary instance to write transactions to local and remote storage arrays concurrently using cross-site synchronous iSCSI multipath links.

B.

NDB uses external replication agents inside the guest operating system to capture and replicate block changes continuously between the data centers.

C.

NDB creates scheduled storage snapshots at the primary site and uses Nutanix replication to copy them to the DR site.

D.

NDB deploys an Oracle instance on the remote cluster and configures native Oracle Data Guard to automate redo log transport.

Question 92

An administrator configured a new Active Directory server but is unable to save the configuration.

What must be done before the configuration can be saved?

Options:

A.

SMTP alerts must be configured.

B.

The configuration must be verified.

C.

The domain IP address must be provided.

D.

A secondary URL must be configured.

Page: 1 / 31
Total 308 questions