You plan to monitor the status of the motherboard, memory, power, fans, and network cards on the database nodes in your Exadata X6 Database Machine using Enterprise Manager.

Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in Enterprise Manager?

A. No thresholds need to be set because they are present in the ILOM and in Enterprise Manager.

B. Set thresholds in ILOM and in Enterprise Manager because they are not present anywhere and must be set in both places.

C. Set thresholds only in ILOM because they are not preset anywhere but need to be set only in ILOM.

D. No thresholds need to be set because they are preset in the ILOM and these are sufficient for monitoring.

Examine this list of software components:

1.

Oracle Virtual Machine (OVM)

2.

Oracle Enterprise Manager Agent (OMA)

3.

ASM instance

4.

RDBMS instance

5.

Automatic Diagnostic Repository Command Interpreter (ADRCI)

6.

CELLCLI

7.

Cell Server (CELLSRV)

8.

diskmon

Identify the location where these software components can run in the standard Exadata Database Machine deployment.

A. 1, 2, 3 and 4 run on the database servers; 5, 6, 7, and 8 run on the Exadata storage servers.

B. 1, 2, 3, 4, 5, and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.

C. 1, 2, 3, 4 and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.

D. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata storage servers.

E. 2, 3, 4 and 8 run on the database servers; 1, 5, 6 and 7 run on the Exadata storage servers.

An Exadata storage server physical disk on an X5 high-capacity full rack entered the predictive failure state.

Identify the two steps that you must perform to replace this failed physical disk.

A. Add the griddisks back into the ASM diskgroup they used to be a member of.

B. Create a new celldiskand new griddiskson the replaced physical disk.

C. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.

D. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.

E. Replace the failed physical disk.

Which two are true about Smart Scan?

A. A query rewrite may occur to a materialized view stored in Exadata, and it will always benefit from Smart Scan.

B. Column projection does not contribute to the performance benefit of Smart Scan.

C. A query rewrite may occur to a materialized view stored in Exadata but will never benefit from Smart Scan.

D. It is possible to offload single row functions to the Exadata Storage Servers.

E. Join processing can be partly offloaded to Exadata Storage Servers.

F. Join processing can be fully offloaded to Exadata Storage Servers.

You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 Exadata Database Machine.

You decide to examine the relevant metrics on all the cells, to see whether the I/O rate has improved for this category compared to last week, and whether waits and wait time have been reduced.

You issue this command on the first cell:

You examine the output from the first cell which contains:

Which two sets of metrics would you use to determine whether the I/O performance has improved for the OLTP category for the duration of the one-hour measurement period?

A. CT_IO_RQ_SM, CT_IO_RQ_LG, CT_IO_RQ_SM_SEC, and CT_IO_RQ_LG_SEC

B. CT_IO_UTIL_SM and CT_IO_UTIL_LG

C. CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC D. CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ

You are designing the monitoring architecture and procedures for an X5 Database Machine fabric consisting of two full racks, to provide for the monitoring for all components on the critical path of the admin network.

Which two components need to be monitored?

A. the Infiniband leaf switches

B. the power distribution units

C. the Cisco 48 port Catalyst Ethernet Switch

D. the InfiniBand spine switches

Which four statements are true about the configuration of Auto Service Request (ASR) for use with an X5 Database Machine?

A. ASR Manager software may be installed on one of the database servers in the Database Machine.

B. ASR can connect to the Internet using Simple Network Management Protocol (SNMP), using a proxy server.

C. ASR Manager can connect to the Internet directly with HTTPS.

D. ASR Manager can connect to the Internet with HTTPS using a proxy server.

E. ASR can connect to the Internet directly using Simple Network Management Protocol (SNMP).

F. ASR Manager software may be installed on a server that is not part of the Database Machine.

Which three factors should you consider when choosing a method for migrating a database to the X5 Database Machine?

A. The down time allowed for the migration

B. Endian format of the source database

C. Number of tablespaces in the source database

D. The type of database workloads

E. Size of the source database

You are planning the migration of a large data warehouse to a Little Endian X6 Database Machine using

which is running database version 12.2.0.1.

The current database version is Oracle Database 11.2.0.4.0 hosted on a Big Endian platform.

The current database characterset is WE8ISO8859P15.

Which two migration methods are supported?

A. Data Pump

B. cross-platform Transportable Database

C. Physical Standby database

D. Logical Standby database

Which two statements are true about Database Server Metrics and Alerts on an X5 Database Machine?

A. Database Server Metrics are collected my MMON.

B. Database Server Metrics are collected by the MS process and stored in an internal disk-based repository.

C. Database Server hardware sensor alerts are detected by the MS process on the database server.

D. Database Server Metrics are collected by the RS process.

E. Database Server Threshold Alerts may be forwarded by the MS process as SNMP traps.