1z0-070 Exam - Oracle Exadata X5 Administration

NEW QUESTION 1
Which two statements are true about the Integrated Lights Out Manager (ILOM) on an Exadata x5 or x6 Database Machine?

• A. ILOM on database servers can use IPMI to send sensor alerts to an Enterprise Manager Agent.
• B. ILOM on a storage server uses SNMP to send sensor alerts to the cellsrv process on the same storage server.
• C. ILOM on a storage server uses IPMI to send sensor alerts to the MS process on the same storage server.
• D. ILOM on a storage server uses SNMP to send sensor alerts to the MS process on the same storage server.
• E. ILOM on database servers can use SNMP to send sensor alerts to an Enterprise Manager Agent.

Answer: CE

Explanation: C: ILOM supports the Intelligent Platform Management Interface (IPMI), which enables you to monitor and control your server platform, as well as to retrieve information about your server platform.
ILOM supports alerts in the form of IPMI Platform Event Trap (PET) alerts. Alerts provide advance warning of possible system failures.
E: Oracle ILOM supports the Simple Network Management Protocol (SNMP), which is used to exchange data about network activity.
SNMP functionality requires the following two components: References:https://docs.oracle.com/cd/E19860-01/E21452/E21452.pdf

NEW QUESTION 2
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

Answer: ABD

NEW QUESTION 3
Which three are recommended options on an X5 Exadata Database machine, for staging files that will be loaded as external tables?

• A. on an ACFS file system stored in a staging database on the Database Machine
• B. a ZFS over NFS file system mounted on a database server where the external table will be accessed
• C. an Exadata-based ACFS file system on the Database Machine
• D. a DBFS file system stored in a staging database on the Database Machine
• E. on local storage on one or more storage servers that are accessible to the database server where the load will be performed

Answer: ABE

NEW QUESTION 4
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

Answer: BDE

Explanation: B: Endian format: Non-Exadata format
D: Use Real Production Workload
– Real Application Testing (RAT) References:

NEW QUESTION 5
You are examining your Exadata storage servers for routine maintenance requirements and run the imageinfo command as shown:
[root@excel04 ~] # imageinfo
Kernel version: 2.6.18-194.3.1.0.4.el5 #1 SMP Sat Feb 19 03:38:37 EST 2011 x86_64 Cell version: OSS_11.2.0.3.0_LINUX.X64_110429.1
Cell rpm version: cell-11.2.2.3.1_LINUX.X64_110429.1-1
Active image version: 11.2.2.3.1.110429.1
Active image activated: 2011-05-09 16:26:36- 0400 Active image status: success
Active image partition on device: /dev/md6 Active software partition on device: /dev/md8
In partition rollback: Impossible
Cell boot usb partition: /dev/sdm1
Cell boot usb version: 11.2.2.3.1.110429.1
Inactive image version: 11.2.1.2.6
Inactive image activated: 2010-10-04 23:59:16 -0400 Inactive image STATUS: success
Inactive system partition on device: /dev/md5
Inactive software partition on device: /dev/md7
Boot area has rollback archive for the version: 11.2.1.2.6 Rollback to the inactive partitions: Possible
Which two statements are true about the software and system partitions?

• A. /dev/md6 and /dev/md8 have one of their mirror copies on physical disk 1
• B. /dev/md6 and /dev/md8 are located only on physicaldisk1
• C. dev/md5 and /dev/md7 have one of their mirror copies on physicaldisk 0
• D. dev/md5 and /dev/md7 are located only on physicaldisk 0

Answer: BC

NEW QUESTION 6
Which three must be true for a Smart Scan to occur for a table?

• A. cell_offload_processing must be true in sessions issuing SQL statements that access the table.
• B. The query must be executed serially.
• C. The query must be executed in parallel.
• D. Direct path reads must be used at run time.
• E. The ASM diskgroup containing the table’s tablespace must have a 4 Mbyte AU size.
• F. The ASM diskgroup containing the table’s tablespace must have cell.smart_scan_capable set to true.

Answer: ADF

Explanation: A: pt_param( ‘cell_offload_processing’ ’TRUE’) hint is used to enable the exadata smart scan feature in sql execution process.
D: Direct reads bypass the buffer cache and go directly into the process PGA. Cell offload operations occur for direct reads only.
F: The cell.smart_scan_capable attribute must be set to TRUE.

NEW QUESTION 7
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 noother 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.

Answer: BE

Explanation: 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.

NEW QUESTION 8
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 4MByte AU size.
• C. It must be heap organized.
• D. It must be accessed using direct path reads.
• E. The table must not be compressed.

Answer: AD

NEW QUESTION 9
Which four statements are true concerning the configuration or use of Enterprise Manager Cloud Control to monitor and manage Exadata Database Machine components?

• A. Computer nodes forward their SNMP traps to the Management Server process on the same computer node.
• B. Storage nodes forward their SNMP traps to the Management Server process on the same storage node.
• C. Cloud control can monitor and manage a Database Machine compute node expansion rack.
• D. Oracle management agents must only be installed on one storage node in a Database Machine to enable monitoring and management of all storage nodes.
• E. Cloud Control cannot monitor partitioned Exadata Database Machine systems.
• F. Cloud Control can monitor and manage a Database Machine storage Expansion rack.
• G. Oracle management agents must only be installed on one compute node in a Database Machine to enable monitoring and management of all compute nodes and storage nodes.

Answer: BCFG

Explanation: B (not A): Oracle Exadata components—including database and storage servers, switches, and power distribution units (PDUs)—use SNMP to raise alerts and report monitoring
information.
Oracle’s CellCLI interface is a Java-based framework delivered by the storage cell’s management server process (MS) that provides administrative capabilities to your storage server entities.
C: Cloud control can monitor the Exadata Database Machine.
Figure: Oracle Enterprise Manager Cloud Control 12c monitoring architecture. Note the Management Server process (MS) on the Storage servers.

G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units.
References:http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor- exadata-em12-2291964.html

NEW QUESTION 10
Which three statements are true concerning InfiniBand port and subnet monitoring on an X5 Database Machine?

• A. The Infiniband subnet master location can be determined by using the getmaster command run on any database server.
• B. The Infiniband subnet master location can be determined by using the getmaster command run on an IB switch.
• C. The InfiniBand port status may be displayed on the storage servers by using the LIST IBPORT command in the CELLCLI utility.
• D. The InfiniBand port status may be displayed on the Infiniband switches by using the LIST IBPORT command in the DBMCLI utility.
• E. The InfiniBand port status may be displayed on the database servers by using the LIST IBPORT command in the DBMCLI utility.
• F. The InfiniBand port monitoring is automatic on the database servers and is managed by Enterprise Manager.

Answer: BCE

Explanation: B: From any InfiniBand switch in the network (leaf switch or spine switch), log in as root and run the getmaster command to obtain the location of the master SM as follows:
# getmaster
This command displays the host name or IP address and the IP address of the switch where the master SM is running.
C: CellCLI> list ibport - Will display InfiniBand configuration details
E: The DBMCLI utility is the command-line administration tool for configuring database servers, and managing objects in the server environment.
The LIST IBPORT command displays attributes for InfiniBand ports determined by the specified attributes and filters.
References: http://docs.oracle.com/cd/E80920_01/DBMMN/exadata-dbmcli.htm
https://docs.oracle.com/cd/E18476_01/doc.220/e18478/GUID-9FF8B5B0-3481-4B73-89D3-108CBD7EB989.htm

NEW QUESTION 11
You are planning your deployment of Enterprise Manager to monitor all the components of an X5 Database Machine.
A part of the requirement is to provide for high availability of the monitoring infrastructure. If the host running the agent that has Database Machine targets bound to it fails, the
monitoring of these targets must be done by another agent.
Which three statements are true regarding the configuration used to support this requirement?

• A. Database Machine plug-ins must be deployed to at least two Enterprise Manager agents.
• B. Fail back to the original agent when the host is restarted is done automatically.
• C. Fail over to any secondary agent is done automatically.
• D. Fail over to any secondary agent must be done manually.
• E. Database machine plug-ins must be deployed to all Enterprise Manager agents.
• F. Fail back to the original agent when the host is restarted must be done manually.

Answer: BCE

NEW QUESTION 12
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 computer 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

Answer: BD

Explanation: 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-7920-441A-9A60-14ED2753B01C

NEW QUESTION 13
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

Answer: ADE

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

NEW QUESTION 14
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.

Answer: ACDF

Explanation: C: If you need to use HTTPS for security purposes, you can set up HTTPS/SSL for the ASR Manager HTTP receiver.
D: As part of the registration process for ASR Manager, you can optionally set the ASR Manager to access the internet through a proxy server.
References:https://docs.oracle.com/cd/E37710_01/install.41/e18475/ch2_asr_manager.ht m#ASRUD137

NEW QUESTION 15
Which type or types of network traffic are transported over the internal InfiniBand interconnect in Exadata Database Machine X5?

• A. IDB protocol traffic, clustered ASM traffic, and clustered database instance traffic
• B. IDB protocol traffic and clustered database instance traffic only
• C. IDB protocol traffic and clustered ASM instance traffic only
• D. Both clustered ASM and clustered database instance traffic only
• E. IDB protocol traffic only

Answer: E

Explanation: Oracle Exadata uses the Intelligent Database protocol (iDB) to transfer data between Database Node and Storage Cell Node.
iDB is used to ship SQL operations down to the Exadata cells for execution and to return query result sets to the database kernel.

NEW QUESTION 16
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

Answer: BD

Explanation: The rescue procedure is necessary when system disks fail, the operating system has a corrupt file system, or there was damage to the boot area. If only one system disk fails, then use CellCLI commands to recover. In the rare event that both system disks fail simultaneously, you must use the Exadata Storage Server rescue functionality provided on the Oracle Exadata Storage Server Software CELLBOOT USB flash drive.

NEW QUESTION 17
Which three are true concerning Exadata Smart Flash Cache on X6 Database Machines with High Capacity Storage Servers?

• A. The “keep” cache is limited to a maximum of 80% of the total Smart Flash Cache capacity.
• B. Smart Scan will always use the Smart Flash Cache for all I/Os fast full index capacity.
• C. Smart Scan will always use the Smart Flash Cache for all I/Os for full table scans.
• D. Single block reads can benefit from Smart Flash Cache.
• E. Multiblock reads can benefit from Smart Flash Cache.

Answer: BDE

Explanation: D: By default Exadata stores only small I/Os in the Exadata Smart Flash Cache. Small I/Os in most cases are single-block reads. During a full table scan Oracle requests blocks in multiblock lumps (by default 16 blocks), and these are

NEW QUESTION 18
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

Answer: D