Oracle Oracle Certifications 1Z0-070 Questions & Answers

• Question 71:

  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

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

• Question 72:

  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

  Correct Answer: CD

  Explanation:

  The Cisco Catalyst 4948 Ethernet switch is supplied with the Oracle Exadata Rack.

  D: Figure: Running the Subnet Manager in Different Rack Configurations

  

  References:

  https://docs.oracle.com/cd/E18476_01/doc.220/e18478/GUID-9FF8B5B0-3481-4B73-89D3108CBD7EB989.htm#ELMOG76346 http://docs.oracle.com/cd/E80920_01/DBMIN/configuring-exadata.htm#DBMIN21274

• Question 73:

  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.

  Correct 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-em122291964.html

• Question 74:

  You are in the process of upgrading your X5 Database Machine half rack to a full rack.

  The new storage servers are called DM01CEL08 through DM01CEL14.

  After creating 96 new griddisks, you issued this SQL statement: How many failgroups if any, will be added to the DATA diskgroup by executing this SQL statement?

  

  A. 0, because the new griddisks will be added to the existing failgroups

  B. 12, consisting of seven griddisks each

  C. 96, consisting of seven griddisk each

  D. 7, consisting of 12 griddisks each

  E. 1, consisting of all 96 griddisks

  Correct Answer: D

  Explanation:

  The number of failure groups equals the number of Exadata Cells. Each failure group is composed of a

  subset of grid disks in the Oracle ASM disk group that belong to a single storage cell.

  References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-administering-asm.htm

• Question 75:

  You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your X6 Database Machine. The Database Machine database version is 11.2.

  You plan to perform a physical database migration using Transportable Database.

  Which two are requirements for this method?

  A. The source database must be deployed on a Little Endian platform,

  B. The source database must be at least 11.1.

  C. The source database must be at least 11.2.

  D. The source database must use only bigfile tablespaces.

  E. The source database must be deployed on a Big Endian platform.

  F. The source database must not use bigfile tablespaces.

  Correct Answer: AC

  Explanation:

  Transportable database approach (TDB). If the source system is running Oracle 11.2 or above with Little

  Endian format, this method can be used to migrate the database to Exadata.

  References: https://www.toadworld.com/platforms/oracle/w/wiki/11551.managing-troubleshooting-exadatapart-3-migrating-databases-to-exadata-database-machine-best-practices

• Question 76:

  Which two statements are true about backup performance when using Recovery Manager (RMAN) on an X5 Database Machine?

  A. Backups are fast because the Infiniband network is faster than fiber channel storage, so RMAN read I/ O operations are faster than in traditional storage networks.

  B. Backups are fast, because physical I/Os operations are reduced by the use of the Storage Index by cellsrv.

  C. Backups are fast, because data blocks are read from the Database Flash Cache.

  D. Backups are fast, because all data blocks are read from the Exadata Smart Flash Cache.

  E. For incremental backups using Block Change Tracking, cellsrv filters blocks and returns only those that have changed since the last backup.

  Correct Answer: DE

  Explanation:

  D: The storage server software manages the flash cache and can recognize different types of I/O requests so that non-repeatable data access like RMAN backup I/O does not flush database blocks from the cache. It also prioritizes frequently accessed block types such as redo logs, control files, and index root blocks.

  E: RMAN block change tracking allows incremental backups to run very quickly and efficiently. With block change tracking, only the areas of the database that have been modified since the last incremental backup or full backup are read from disk.

  Incorrect Answers:

  C: Database Flash Cache is separate from Exadata Smart Flash Cache. The Database Smart Flash Cache feature and increase the buffercache of your database from like 100G or 200G to 300-700G on that same server.

  References: https://logicalread.com/using-oracle-exadata-flash-cache-mc05/#.Wd80zmiCyUk http://www.oracle.com/technetwork/database/availability/maa-tech-wp-sundbm-backup-11202-183503.pdf

• Question 77:

  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

  Correct Answer: B

  Explanation:

  Intelligent Data Placement enables you to specify disk regions on Oracle ASM disks for best performance.

  Using the disk region settings, you can ensure that frequently accessed data is placed on the outermost

  (hot) tracks which have greater speed and higher bandwidth. In addition, files with similar access patterns

  are located physically close, reducing latency. Intelligent Data Placement also enables the placement of

  primary and mirror extents into different hot or cold regions.

  References: https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG10072

• Question 78:

  Which three statements are true about Exadata storage server alerts in an X5 Database Machine?

  A. Storage server alerts notifications may be sent using SNMP.

  B. A threshold- based alert gets cleared automatically when the measured value no longer violates the threshold.

  C. A storage server alert is only ever issued as a warning or at a critical situation.

  D. Storage server alerts are all stateless alerts.

  E. Storage server alerts are all stateful alerts.

  F. Storage server alerts notifications may be sent using SMTP.

  Correct Answer: ACF

  Explanation:

  Exadata cell (storage server) alerts can be delivered using SMTP or SNMP or both.

  Although there are three types of storage alerts: informational, warning and critical, they are issued when

  threshold metrics reached either to warning or critical.

  Incorrect Answers:

  B: Stateful alerts are automatically cleared on transition to normal.

  Stateless alerts are never cleared unless you change the alert by setting the examine by attribute.

  D, E: Alerts can be stateless or stateful.

• Question 79:

  Which two statements are true about the X5 Exadata storage server rescue procedure?

  A. The rescue procedure can be executed from the CELLBOOT USB flash drive.

  B. An Exadata storage server automatically enters the rescue environment when it cannot boot from the system area.

  C. The rescue procedure can be used to repair corruption in an ASM diskgroup.

  D. The rescue procedure can be used to restore a corrupt system area.

  E. The rescue procedure must be used to recover from a failed Exadata storage server software upgrade.

  Correct Answer: AD

  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.

  References: http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storageservers.htm#GUID-710814E7-4691-49EE-95AD-726D2D6C5BFE

• Question 80:

  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.

  Correct Answer: BCF

  Explanation:

  B: Oracle ASR Manager only processes SNMP traps that are sent from IP addresses that Oracle ASR Manager recognizes. Example of Exadata Storage Server SNMP Trap This example shows the SNMP trap for an Exadata Storage Server disk failure. The corresponding hardware alert code has been highlighted.

  2011-09-07 10:59:54 server1.example.com [UDP: [192.85.884.156]:61945]: RFC1213-MIB::sysUpTime.0 = Timeticks: (52455631) 6 days, 1:42:36.31 SNMPv2-SMI::snmpModules.1.1.4.1.0 = OID: SUN-HW-TRAP-MIB::sunHwTrapHardDriveFault SUN-HW-TRAP-MIB::sunHwTrapSystemIdentifier = STRING: Sun Oracle Database Machine Etc.

  C (not D): The ASR Manager uses the SNMP GET protocol to query ASR assets for additional fault

  information.

  To configure fault telemetry, choose one of the following three options:

  Add SNMP Trap Destinations Using OneCommand (recommended for new installations)

  Add SNMP Trap Destinations for Multiple Servers Using the dcli Utility

  Add SNMP Trap Destinations for a Single Server

  References:

  http://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm

  https://docs.oracle.com/cd/E37710_01/install.41/e18475/ch5_troubleshooting.htm#ASRUD331