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?

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

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

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

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

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

An administrator has received a request to clone a source production database to an existing development server.Which two actions must be taken to complete this task?

The development server must be registered by Era in order to receive the clone.

The development server must have the IP and credentials provided during cloning.

The development server must be registered by Era in order to receive the clone.

The development server must be registered by Era and authorized to host clones from the Time Machine.

The development server must be authorized for the database Time Machine.

The development server must have the IP and credentials provided during cloning.

Which default roles are available within Era for Role-Based Access Control?

prism Admin * Era Super Admin * Era Database Admin Era Infrastructure Admin

Super Admin Database Admin Database Infrastructure Admin * Infrastructure Admin

Era Oracle Admin Era SQLServer Admin * Era PostgreSQL Admin Era Mariadb Admin

Super Admin Database Admin Database Infrastructure Admin prism Infrastructure Admin

A developer with RBAC privileges in Era needs to refresh an existing DB Clone.What steps must the developer take to perform the refresh?

Navigate to Databases > Clones, Select the appropriate clone from the table, click Refresh, select the desired Point In Time or Snapshot and click Refresh

Navigate to Databases > Sources, Select the appropriate Database from the table and Refresh Clone from the Database Actions menu.

Navigate to Databases > Clones, Select the appropriate clone from the table, click Refresh, select the desired Point In Time or Snapshot and click Refresh

Navigate to Time Machines Select the appropriate Database Time Machine from the table end Refresh Clone from the Actions menu.

Navigate to Databases > Clones, Select the appropriate clone from the table, choose

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

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

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

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

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

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

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

In an Oracle upgrade scenario using Era. if the source database is on a nor-Nutanix platform, is it possible to upgrade it with an Era workflow?

No, the database instaru:e must be Era managed to Be upgraded

Yes, it is possible to upgrade database instance on a non-Nutanix platform.

Yes, only if the nan-Nutanix platform is big-endian platform,

No, the database instaru:e must be Era managed to Be upgraded

Yes, only if the nori-Nutanix platform is little-endian platform.

How is a software profile created?

In the Ere IJI select Profiles Software, and then a database engine, OS version, and database version,

In the Ere IJI select Profiles Software, and then a template VM.

In the Ere IJI select Profiles Software, and then a database engine, OS version, and database version,

Create a software profile from a registered Database Server VM.

Clone e software profile provided by Era and modify as needed.

An administrator needs to apply a minor version upgrade of the PostgreSQL software to an Era provisioned instance.Which step should the administrator take before applying the patch?

Put the database instance into maintenance mode.

Go to the Software Profile Version widget and click update.

Migrate a new software profile.

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?

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

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

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

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

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

Which command can be used to assign a static IP address to the Era VM on ESXi?setera-server > eraera-server >An administrator is trying to register an Oracle Database Server VM to Era.Which dependency must be met?

Enable reQUIREetty setting on the source database

/TEMP folder must have read-only permissions

set path = /sbin:/bin:/usr/sbin:/usr/bin

What does the Era I-Click Provisioning service do?

Create space-efficient clones and zero-byte database clones

Cloning with security inserting pre and post masking scripts

Customizable recovery SLAs for continuous RPOs

Create space-efficient database snapshots

Create space-efficient clones and zero-byte database clones

While registering an Always on Availability Group database, an administrator selects the following option:Multiple Databases as a Group with One Time MachineWhich statement is true regarding this chosen option?

PITR-based SLAs are not supported for database groups containing mixed Recovery Model

PITR-based SLAs are supported for database groups containing mixed Recovery Model.

PITR-based SLAs are not supported for database groups containing mixed Recovery Model

Point in Time Clones are not supported by Database Groups.

PITR-based SLAs are not supported for database groups.

An administrator is asked to refresh a database everyday at 9:30PM with data from as close to the refresh time as possible.What is the best way achieve this requirement?

Schedule an SLA policy to perform snapshot everyday at 9.30PM.

Schedule an SLA policy to perform snapshot everyday at 9PM.

Schedule an SLA policy that performs a snapshot at 99M and log catchup for every 15 min.

Schedule e log catchup everyday at 9:30PM.

Schedule an SLA policy to perform snapshot everyday at 9.30PM.

What behavior is observed when applying patch profiles as a Super Admin?

Published patches cannot be applied if currently deprecated.

Unpublished patches can be applied.

Published patches cannot be applied if currently deprecated.

Deprecated patches can be applied.

What is the most efficient way to get information on REST APIs for a task in Era?

use API equivalent button in a workflow.

Log into Ere VM end run to list ell the REST APIs.

Navigate to Swagger REST in Era GI-II.

Navigate to and look for the desired

use API equivalent button in a workflow.

An administrator needs to provision a 3-node MSSQL Server AG with the following configuration:* Two database server VMS including the primary replica on a local site* A third database server VM on a remote siteHow many IP addresses will the network at each site require?

Cluster VIP end I Listener IP on the local site 1 Cluster VIP and 1 Listener IP on the remote site 2 IPs in the local site and 1 on the remote site for the database server nodes

2 Cluster VIP and 1 listener IP on the local site

1 Cluster VIP and 1 listener IP on the remote site 2 IPs in the local site and 1 on the remote site for the database server nodes 1 Cluster VIP on the local site 1 Cluster VIP and 1 Listener IP on the remote site 2 IPs in the local site and 1 on the remote site for the database server nodes

I Cluster VIP end I Listener IP on the local site 1 Listener IP on the local site 2 IPs in the local site and I on the remote site for the database server nodes

Cluster VIP end I Listener IP on the local site 1 Cluster VIP and 1 Listener IP on the remote site 2 IPs in the local site and 1 on the remote site for the database server nodes

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?

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

Disable the SLA for this database during provisioning.

Create a SLA that only leverages zero-byte snapshots.

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

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

An Era-managed production MSSQL database crashed during a busy holiday weekend and the administrator has to restore the database to the most recent timestamp with an objective to reduce the restore time and minimize data loss.What option should the administrator do to achieve this objective?

Perform Restore Source Database by selecting most recent and include Tail log Backup

Perform Restore Source Database by selecting Restore time just before the database crash.

Perform Restore Source Database by selecting most recent and include Tail log Backup

Perform Restore Source Database by selecting the available snapshot.

Perform Restore Source Database by selecting the current time.

Which two processes should an administrator take to create a software profile version for a newly-released Oracle ISc patch? (Choose two.)

1. Download the required patch from MyOracle Support 2. Apply the patch to the Oracle HomGrid Home on a cloned VM of the gold image using O PatchAuto 3. Ensure success of patch application

1. Create new software profile version from the original software profile using the cloned VM where OPatchAuto was run successfully using Era Gul. 2. Mark the original patch profile as hidden.

1. Download the required patch from Microsoft Support. 2. Apply the patch to the Oracle Home/Grid Home on e cloned VM of the gold image using OPatchAuto utiliv. 3. Ensure success of patch application.

1. Create new software profile version from the original software profile using the cloned VM where OPatchAuto was run successfully using Era Gul. 2. Mark the original patch profile as deprecated.

1. Download the required patch from MyOracle Support 2. Apply the patch to the Oracle HomGrid Home on a cloned VM of the gold image using O PatchAuto 3. Ensure success of patch application

1. Create new software profile version from the original software profile using the cloned VM where OPatchAuto was run successfully using Era Gul. 2. Mark the original patch profile as hidden.

An administrator needs to reset the NDB GUI password.What should the administrator perform from the SSH session?

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

1.Enter the era CLl 2.Execute: security password reset

An administrator is managing a high availability (HA) NDB environment and has been tasked to configure custom SSL certificates. Which server instances must be updated?

The API and Repository VMs running on the primary cluster

The primary API, Repository and HA Proxy servers

When the NDB upgrade includes updates to the out-of-the-box (OOB) software profiles, what happens to older OOB software profile versions when upgrading NDB?

If the software profiles are not in use, NDB deletes all versions of the profiles from the metadata and protection domains.

If the database VMs using the software profiles are using Time Machines and have had a successful snapshot in the last 24 hours before the patch.

If the software profiles are not in use, NDB deletes all versions of the profiles from the metadata and protection domains.

If the database VM using the software profiles are shutdown, NDB deletes all versions of the profiles from the metadata and protection domains.

If the database VMs are not using the base version of the software profile NDB deletes all versions of the profiles from the metadata and protection domains.

Why would an administrator want to publish a software profile update for Microsoft SQL Server that is created in NDB?

When published, all NDB users will be able to use that updated software profile to patch the database software on their VMs.

Publishing the software profile update allows you to use that updated software profile to patch the database on the software profile.

When published, the software profile will deprecate older software profiles.

Publishing the profile stalls the database software patching process.

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?

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

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

An SLA retention schedule must be identified for daily snapshots.

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

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

An administrator needs to patch Oracle DB engines, but the Update button is not present in the database server VMs. What could explain the current situation?

Database parameters are missing.

Oracle DB engines cannot be patched.

Software profile is not published.

A database administrator logged into their NDB dashboard notices the Savings over traditional cloning metric in the Data Usage widget.What does this number represent?

The amount of disk space saved with near-zero byte clones

The amount of disk space saver from compression

The amount of disk space saved with shadow clones

The amount of disk space saved from deduplication

An administrator configures VM Host Affinity for database server VMs on a Nutanix AHV-powered cluster, intending to optimize HA by ensuring that VMs are placed on separate hosts. After a host failure, the administrator notices that database VMs are clustered on a single remaining host, risking another outage.How could the administrator avoid this scenario in future host failures?

Set anti-affinity rules to spread VMs across multiple nodes dynamically.

Assign additional backup VMs within the same host to maintain service.

Increase the number of affinity zones within the cluster

Configure automatic host failover in Prism Central.

Set anti-affinity rules to spread VMs across multiple nodes dynamically.

When an administrator no longer wants to use a software profile version, what happens when it is deprecated?

It can no longer be used for provisioning.

It can be used in provisioning.

Any database server using that profile will by updated to the latest software profile.

Any database server using that software profile can no longer be patched.

Refer to the exhibit. An administrator wants to register a database using a SQL Server UserWhere can this user be specified?

In the Login field after selecting SQL Server User

In the Windows Administrator Name field

In the Login field after selecting SQL Server User

Only via the command line registration option

By modifying the code in the API Equivalent section

Nutanix NCP-DB Practice Test 4 - Free Online Exam Prep & Questions

An administrator needs to replace the default Nutanix self-signed certificates in Era.

Which SSL Certificate file format is supported?

Become a Premium Member for full access

Unlock Premium Member

Nutanix NCP-DB Practice Test 4

Question

Nutanix NCP-DB Practice Tests

Practice Tests