Valid Exam Questions For Oracle 1Z0-070 Exam

ExamLeader
We are facilitating our users with valued study material in both versions like PDF and exam practice software to present real exam environment. Dumps4it will help you out in your exam preparation with much real and valid study material in a way that you will not need any other book or source to pass your Oracle 1Z0-070 Exam. Now it is too easy to complete your certification in Oracle Exadata X5 Administration. You can visit us right now!


Try it Latest Dumps4it 1Z0-070 Braindumps. Get Full File: https://www.dumps4it.com/1z0-070-dumps.html (103 As Dumps)

Download the Dumps4it 1Z0-070 Dumps from Google Drive: https://drive.google.com/file/d/1RWz9FfZriePc6qocfTXj1RW5U6iJfTyP/view (FREE VERSION!!!)

Question No. 1

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?

Answer: D

Question No. 2

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

Answer: A, B, E

Question No. 3

As part of planning for database consolidation, you grouped your databases into two categories based on different technical and business objectives.

Which three statements are true about possible configurations for your Exadata X6 Database Machine fabric?

Answer: B, C, D

Question No. 4

Identify three facilities that can use X5 Extreme Flash Exadata Storage Server flashdisk space.

Answer: B, D, E

Question No. 5

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?

Answer: B, C, F

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


Question No. 6

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.

Answer: C, E

You may need to replace a physical disk because the disk is in warning - predictive failure status. The predictive failure status indicates that the physical disk will soon fail, and should be replaced at the earliest opportunity. The Oracle ASM disks associated with the grid disks on the physical drive are automatically dropped, and an Oracle ASM rebalance relocates the data from the predictively failed disk to other disks.

Note: After the physical disk is replaced, the grid disks and cell disks that existed on the previous disk in that slot are re-created on the new physical disk. If those grid disks were part of an Oracle ASM group, then they are added back to the disk group, and the data is rebalanced on them, based on the disk group redundancy and ASM_POWER_LIMIT parameter.

References:

http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage-servers.htm#DBMMN21047


Question No. 7

You are examining your Exadata storage servers for routine maintenance requirements and run the imageinfo command as shown:

[[email protected] ~] # 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?

Answer: B, C

Question No. 8

Which three are sources for alerts from storage servers in an X5 Database Machine?

Answer: A, B, E

AB: The Management Server (MS) process receives the metrics data from CELLSRV, keeps a subset of metrics in memory, and writes to an internal disk-based repository hourly. In addition, the MS process can generate alerts for important storage cell hardware or software events.


Click Here For More Information: Oracle 1Z0-070 Dumps