EMT Practice Test

1. Question Content...

---

Question1: 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?

Question2: 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?

Question3: A user accidentally drops a table in the database at 10:42pm and the NDB administrator is tasked with restoring the table.
The snapshot schedule is set for every 30 minutes and the log catchup is set for every 15 minutes. The last available snapshot is at 10:30pm.
What is the optimal path to restore the table back with minimum data loss?

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

Question5: What does a Time Machine frozen status indicate?

Question6: Which Era component collects logs and snapshots from the database?

Question7: An administrator is tasked with auditing NDB SLAs. What data will the administrator be reviewing?

Question8: What must be completed within NDB before patching a Linux OS?

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

Question10: An administrator selected Bronze SLA for Era Time Machine during database registration.
Which two capabilities are supported by the Time Machine for this database? (Choose two,)

Question11: 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?

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

Question13: Which two Oracle software components does Era patch? (Choose two.)

Question14: What are two supported entities that metadata tags can be applied to? (Choose two.)

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

Question16: What is the first step to install NDB on a Nutanix AHV cluster?

Question17: What step should be taken to make the profile available to all users:

Question18: 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?

Question19: How is a software profile created?

Question20: 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?

Question21: An administrator wants to enable Multi-Cluster management on an Era installation.
Which prerequisites must be satisfied to complete this task?

Question22: Where can an administrator configure a custom SSL certificate for Era?

Question23: 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?

Question24: An administrator would like to replicate database snapshots to remote Nutanix clusters.
What should the administrator do to manage Time Machine data availability across all registered Nutanix clusters in NDB?

Question25: An administrator needs to work with databases and time machines, but not database parameter profiles. Which role satisfies this requirement?

Question26: While adding Time Machine data access to a Nutanix cluster, when is a storage container mapping needed

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

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

Question29: What is purpose of the NDB Database Agent service?

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

Question31: What is required to cre110ate a network profile in Era?

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

Question33: 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?

Question34: When performing a SQL Server Restore Source Database operation, what is a valid reason an administrator would choose the Restore Location as New Location?

Question35: Which two encryption methods can be used when configuring an SMTP server? (Choose two.)

Question36: What is the purpose of Data Access Management policies in NDBMulti-Cluster?

Question37: In NDB, which two Time Machine options are available when creating a database clone? {Choose two.)

Question38: An administrator needs to perform patching on a MongoDB server cluster within an NDB environment.
How should the administrator accomplish this task?

Question39: Which action must an administrator take in Era Networks before using Era to provision a MSSQL AG cluster?

Question40: When registering a new Nutanix Cluster with Era, what component is installed on the target Nutanix cluster via the Register Nutanix Cluster workflow?

Question41: Why are ports 3205 and 3260 important when working with Era?

Question42: 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?

Question43: An administrator needs to take multiple snapshots per day and retain them for one week. How should the administrator define and schedule the SLA?

Question44: 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?

Question45: A database admin logs into Era to manage an Oracle Database VM and sees a message Update Available on the Status of the Software Profile Version.
What should the database admin do?

Question46: 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?

Question47: What is causing this issue?

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

Question49: An administrator needs to make new VLANs available when provisioning a Oracle cluster database, which have been added to NDB via the Administration menu.
What needs to be done to expose the new VLANs for provisioning?

Question50: An administrator has been tasked with restoring an Oracle database that has recently failed. The administrator must restore the database to the prior day's state.
Which two restore options could be used? (Choose two.)

Question51: What is used to temporarily store the transaction logs of the source database before they are copied to the log?

Question52: How can HA drivers for a Database VM be upgraded?

Question53: Which NDB feature collects logs and snapshots from databases?

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

Question55: 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?

Question56: An administrator needs to change the maximum number of database connections during the cloning workflow.
Which Era profile should the administrator choose?

Question57: 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?

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

Question59: 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?