Free 1z0-070 Exam Dumps

Question 21

Examine this IORM plan:
1Z0-070 dumps exhibit
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.

Correct Answer:BE
The IORM plan can be configured using the ALTER IORMPLAN command on command-line interface (CellCLI) utility on each Exadata storage cell. It consists of two parameters - dbplan and catplan. While the "dbplan" is used to create the I/O resource directives for the databases, the "catplan" is used to allocate resources by workload category consolidated on the target system.
allocation/share - Specify the resource allocation to a specific database in terms of percentage or shares. limit - Specify maximum limit of disk utilization for a database.

Question 22

Because of a motherboard failure on an X6 high-capacity Exadata storage server, you must replace the server chassis with a replacement unit.
Which are three of the components must you move from the original Exadata storage server to the new Exadata storage server?

A. Redundant power supplies
B. The host bus channel adaptor
C. The USB flash drive
D. The four Sun Flash Accelerator PCIe cards
E. The 12 physical disks

Correct Answer:ADE
Remove the following reusable components:
References: https://docs.oracle.com/cd/E62172_01/html/E63689/goiqw.html#scrolltoc

Question 23

You plan to consolidate your company’s INVENTORY and SALES databases onto your new Exadata X6 Database Machine.
You are considering consolidation of all schemas into one RAC database. Which three factors would you need to consider before choosing this approach?

A. the number of database users
B. Security Policies
C. the number of database roles
D. the number of simultaneous sessions
E. the maintenance schedule

Correct Answer:ABD

Question 24

Which three statements are true concerning the configuration of SNMP on an Exadata x5 or x6 Database Machine?

A. All SNMP notifications from the storage server ILOMs are sent directly to the Automatic Service Request (ASR) manager.
B. Some SNMP notifications may be configured using the alter cell command on the storage servers.
C. The Database Machine internal Cisco Switch communicates directly with the Enterprise Manager agent via SNMP.
D. Some SNMP notifications from a storage server ILOM are sent directly to the management server (MS) process on the same storage servers.
E. All SNMP notifications from a database server ILOM are sent directly to the Automatic Service Request (ASR) manager.
F. All SNMP notifications from a database server ILOM are sent directly to the management server (MS) process on the same database server.

Correct Answer:BDE
B: You can configure SNMP Trap Destinations for the Exadata Storage Servers with the following command:
# cellcli -e “alter cell snmpSubscriber=(host
='ASR-Manager-name-or-IP-address',port=162,community=public,type=asr)”
D: Exadata Storage Server plug-in
This extends the monitoring of exadata cells in addition to providing a GUI interface. The plug-in uses an SSH connection to the cellmonitor user on the cells and uses list commands only. This is for interactive monitoring. One may also set thresholds using the plug-in which are distinct from any thresholds set using cellcli utility as the celladmin user. For alerts to be sent to the plug-in, SNMP traps are used as follows:
Cell ILOM alerts are sent to the cell Management Server (MS) via an SNMP trap. The MS then send SNMP notifications onward to the plug-in.
Cell alerts flagged by MS itself, such as cell thresholds being exceeded, or ADR software alerts, are sent to the plug-in using SNMP.
E: Database Server ILOM plug-in
Monitoring databases and their instances, ASM environments, the Grid Infrastructure, and the host software environment are done by Enterprise Manager in the usual way as these are standard targets. But monitoring the hardware for the database servers requires the ILOM plug-in, as there is no Management Server (MS) on the database servers to receive SNMP traps from the ILOM. The plug-in will receive sensor state and availability data from the ILOM including alerts based on pre-set ILOM thresholds.
References:
https://dbatrain.wordpress.com/2011/06/
http://docs.oracle.com/cd/E21659_01/html/E21660/z40015671004046509.html

Question 25

Identify two supported modifications to an X5 Database Machine.

A. installing a Host Bus Adapter (HBA) in the compute nodes
B. installing additional Operating System (O/S) packages on the compute nodes
C. installing additional Operating System (O/S) packages on the Exadata storage servers
D. installing a Host Bus Adapter (HBA) in the storage servers
E. replacing the Cisco Ethernet switch with another make or model
F. replacing the Infiniband switches with another make or model

Correct Answer:BD
B: Updating Exadata Database Servers (compute nodes).
The software and firmware components that are updated for a specific release depend on the current Exadata software release the database server is running and the release you are updating to. Linux operating system packages and Exadata software are always updated while firmware may be updated for only a small selection of the components or not at all.
D: The storage cells (storage servers/nodes) contain HBAs, and spare PCI I/O slots.
References: https://docs.oracle.com/cd/E41033_01/html/E55032/bbgiabie.html
http://docs.oracle.com/cd/E80920_01/DBMMN/updating-exadata-software.htm#DBMMN-GUID-AB25ED9A-7