Batch and DSS workloads on your Exadata X6 Database Machine are causing performance problems for OLTP workloads at certain times of the day.

There are five RAC databases performing OLTP I/O. Two of them also perform batch I/O. There is another RAC database that performs only DSS I/O.

You are asked to resolve this problem so that the OLTP workload will not suffer when competing with the batch or DSS workloads.

You decide to use the I/O resource manager.

Which is the best way to solve this problem?

A. Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to create the OLTP category and map all OLTP-oriented consumer groups in all databases to it.

B. Use the Database Resource Manager to give the OLTP category the highest priority and use EXADCLI calling EXACLI to create the OLTP category on all the cells.

C. Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to give the OLTP consumer group the highest priority on all databases.

D. Create a database plan using EXADCLI calling EXACLI to give OLTP I/O the highest priority from all six databases.

You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) for your X5 Database Machine and its assets.

Which three statements are true about this configuration?

A. Simple Network Management Protocol (SNMP) traps are used to send notifications from database servers to the ASR Manager.

B. Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to the ASR Manager.

C. When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).

D. When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS.

E. Simple Network Management Protocol (SNMP) traps are used to send notifications from the Enterprise Manager to the ASR Manager.

F. Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to the Enterprise Manager.

In which scenario will griddisks residing on the same celldisk have balanced performance characteristics in an X5 High Capacity Exadata Storage Server?

A. griddisks on memory based celldisks

B. griddisks on hard disk-based celldisk consumed by ASM when creating diskgroups using ASM-based Intelligent Data Placement (IDP)

C. griddisks on hard disk-based celldisks consumed by the Database Smart Flash Cache

D. griddisks on Flash-based celldisks

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

Identify two valid reasons for executing an X5 Exadata storage server rescue procedure.

A. Accidental loss of all data from all griddisks in a storage server

B. Corruption in the /(root) filesystem

C. Corruption in a normal or high redundancy ASM diskgroup

D. The failure of both physical disks 0 and 1

E. Only the failure of physical disk 1

F. Only the failure of physical disk 0

Your Exadata X6-2 Database Machine has the exachk utility preinstalled. You decide to use it periodically to validate the installation against Oracle's recommended best practices.

Which three actions could you take to do this?

A. Use a cron job on a database node to run it at regular intervals.

B. Use a cron job on each cell to run it at regular intervals.

C. Run it once each cell and it will then perform periodic monitoring automatically.

D. Create a OS job in Enterprise Manager to run the exachk utility at regular intervals.

E. Use exachk to schedule itself to run at regular intervals.

Examine this IORM plan: Which two are true concerning this plan?

A. The Finance database can use at least 45%, but never more than 60%, of the total Flash Cache capacity.

B. I/Os from the finance database are guaranteed to get a minimum of 45% of the I/O bandwidth if the demand exists, and a maximum of 60% of the I/O bandwidth even if no other databases are doing I/O to the cell, and the demand from the finance database exceeds 60% of the maximum I/O rate of the cell.

C. If I/Os come from the HR database only, then they may get up to 100% of the I/O bandwidth on the cell.

D. I/Os from the finance database are guaranteed to get 45% of the I/O bandwidth if the demand is at least 60% of the maximum I/O rate of the cell, but may get 100% of the I/O bandwidth if no other databases are performing I/O to the cell.

E. If I/Os come from the HR database only, then they may get up to 10% of the I/O bandwidth on the cell.

Which three statements are true about Automatic Hard Disk Scrubbing and repair on high-capacity storage servers in an X5 Database Machine?

A. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is clean in the Smart Flash Cache.

B. Hard disks are scanned every two weeks by default but only when disks are idle.

C. Hard disks are scanned every two weeks by default in all situations.

D. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is dirty in the Smart Flash Cache.

E. Disk repair may be made from another mirror copy if the corrupt area is part of a Normal or High Redundancy Disk Group.

Which two must be true for a Smart Scan to occur on a table?

A. Sessions querying the table must set cell_offload_processing = true.

B. It must be stored in an ASM diskgroup with a 4 MByte AU size.

C. It must be heap organized.

D. It must be accessed using direct path reads.

E. The table must not be compressed.

Which two communication methods are used by which components in the Enterprise Manager architecture for a Database Machine?

A. SNMP traps for alerts are sent by the storage server ILOM directly to the Enterprise Manager agent.

B. SNMP traps for alerts are sent by the storage server ILOM to the storage server MS process.

C. SNMP traps for alerts are sent by the storage server MS process to the Enterprise Manager agent.

D. SNMP traps for alerts are sent by the storage server MS process to the storage server ILOM.

E. SNMP traps for alerts are sent by the storage server ILOM to the storage server RS process.