Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-902 - Oracle Exadata Database Machine X9M Implementation Essentials

Page: 1 / 3
Total 85 questions

Which two Exadata security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

A.

Exadata storage realms using ASM-scoped security mode

B.

File permissions on the griddisks in each database server

C.

Using EXADCLI instead of CELLCLI to create the griddisks

D.

File permissions on the griddisks in each storage server

E.

Exadata storage realms using database-scoped security mode

What are the two benefits of using Oracle Exadata Deployment Assistant (OEDA)?

A.

OEDA facilitates abstracting hardware.

B.

OEDA gathers configuration details and creates the Oracle Exadata Rack configuration file.

C.

OEDA is used for Oracle Exadata Database Machine, Zero Data Loss Recovery Appliance, Private Cloud Appliance, and SuperCluster.

D.

OEDA Web-based user interface cannot import OEDA XML configuration files created with the Java-based version of OEDA without conversion

E.

OEDA provides a CL1 which supports life cycle management tasks for Exadata systems only.

You have been notified by your Network Administrator that an upstream switch has been replaced due to a hardware fault. Which command verifies that the client network on your Exadata X9M-2 Database Server is available via both client switches?

A.

ifconfig -a legrep "re0| re1"

B.

/opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 —all

C.

netstat -rn

D.

cat /proc/net/bonding/bondeth0

I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.

Which two monitoring tools might be useful in examining I/O performance for the prod database?

A.

OS I/O metrics using Enterprise Manager host pages for the storage servers

B.

OS I/O metrics using OS tools such as iostat on the database servers

C.

I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod

database instances using SQL *p1us

D.

cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

E.

OS I/O metrics using OS tools such as iostat on the storage servers

What are two recommended configuration best practices for backup and recovery on Exadata?

A.

Placing the backup network on dedicated switches installed in the top of the rack (ToR) has the benefits of isolating the backup network from other workloads and providing a greater level of control.

B.

Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

C.

The internal Recovery Appliance backup and restore processing is optimized when the RMAN FILESPERSET parameter is set to 1 for the level 1 incremental backup set.

D.

When off-site long-term backup retention is needed, use Oracle Database Backup Cloud Service as a low-cost, offsite scalable storage for a disaster recovery solution.

You have been asked to investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend.

Which command would help investigate this?

A.

$ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 —from _17:00:00 —to _23:59:00

B.

# /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm —from _17:00:00 —to _23:59:00

C.

# /opt/oracle.ExaWatcher/GetExaWatcherResults.sh —from _17:00:00 —to _23:59:00

D.

# /opt/oracle.SupportTools/exachk/exachk —from _17:00:00 —to _23:59:00

Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

A.

SQL Plan Quarantine

B.

Manually created Quarantine

C.

Database Quarantine

D.

Disk Region Quarantine

E.

Cell Offload Quarantine

You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands:

What steps and in which order should they be executed?

A.

6, 2, 1, 8, 4, 5

B.

6, 8, 3, 4, 2, 1

C.

6, 3, 1, 9, 7, 8

D.

6, 1, 2, 7, 5, 8

What is the minimum Exadata System Software version required for Exadata X9M?

A.

20.1.1.0.0

B.

19.2.1 0.0

C.

21.2.0.0.0

D.

19.3.0.0.0

E.

18.1.3.0.0

F.

21.3.0.0.0

Which three of the following options are available for database consolidation on Exadata?

A.

Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster

B.

Bare Metal deployment with one database per database server

C.

A single database with one or more schema per application

D.

Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently

E.

Multiple Databases on a cluster

F.

Multiple Virtual Machine clusters supporting a single database for greatest resource isolation