Oracle 1Z0-070 Exam Questions and Answers

New feedback of 1Z0-070 exam from our customer,  I passed my 1z0-070 exam, thanks for your valid 1Z0-070 exam dumps. Share some Oracle 1Z0-070 exam questions and answers below.

1.Which components of an Exadata storage server image, if updated, may require that a patch also be applied to the database servers in an Exadata X6 Database Machine?
A. Linux operating system on the storage server
B. InfiniBand HCA firmware on the storage server
C. Storage server hard disk device drivers
D. Storage server flash device drivers
Answer: D
Explanation:
Exadata patches are intended for and include fixes for both the storage servers and Compute servers, and optionally InfiniBand switches.
Patching order
You should patch the Exadata Database Machines in the following sequence
References: https://www.toadworld.com/platforms/oracle/w/wiki/11640.oracle-exadata-patching

2.Which two statements are true about the use of DBFS, ACFS, and external file systems and components in an X5 Database Machine environment?
A. ACFS uses storage in a database on the database machine
B. DBFS supports file system snapshots.
C. ACFS supports file system snapshots.
D. Storage Area Network (SAN) –based file systems may be accessed directly from the storage servers in a database machine.
E. Oracle Sun ZFS Storage Appliance- based files are not automatically protected by Data Guard.
Answer: B,C
Explanation:
DBFS SecureFiles Store Capabilities include support for file system snapshots.
Oracle ACFS includes advanced features such as file system snapshot.
References:
http://www.oracle.com/technetwork/ru/database/dbfs-sf-oow2009-v2-160969.pdf
http://www.oracle.com/technetwork/database/database-technologies/cloud-storage/benefits-of-oracle-acfs-2379064.pdf

3.Which two are true about sparse griddisks and their use in disk groups on an X5 Exadata Database Machine?
A. Sparse diskgroups must be created using sparse griddisks.
B. Sparse diskgroups may be created using a combination of sparse and non-sparse griddisks.
C. Sparse diskgroups may not be used for database snapshots.
D. Additional space for a sparse griddisk is allocated as soon as newly written data is stored in the flashcache on a cell.
E. The virtual size of a sparse griddisk may exceed the physical size of the space occupied by the griddisk.
Answer: A,E
Explanation:
A: A sparse ASM disk group is composed of sparse grid disks.
E: Sparse grid disks allocate space as new data is written to the disk, and therefore have a virtual size that can be much larger than the actual physical size. Sparse grid disks can be used to create a sparse disk group to store database files that will use a small portion of their allocated space. Sparse disk groups are especially useful for quickly and efficiently creating database snapshots on Oracle Exadata. Traditional databases can also be created using a sparse disk group.
References:
http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-snapshots.htm#SAGUG-GUID-42945059-13FD-4F6A-B7FA-A1201D16238F
http://docs.oracle.com/cd/E80920_01/DBMSO/exadata-whatsnew.htm#DBMSO22120

4.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.
Answer: B,C,F
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

5.Which two statements are true about RMAN incremental level-1 backups for a database running on an X5 Database Machine?
A. Block Change tracking (BCT) is not needed for databases in an X5 Database Machine, because ASM automatically does block change tracking when diskgroups are built from griddisks.
B. cellsrv filters blocks and returns only those that have changed since the last backup, for databases in archivelog mode.
C. cellsrv returns all blocks that have been or might have been changed since the last backup, and RMAN filters the blocks that do not require backup.
D. cellsrv filters blocks and returns only those that have changed since the last backup, for databases in noarchivelog mode.
E. Block Change Tracking (BCT) is not needed for databases in an X5 Database Machine, because change tracking is done by cellsrv.
Answer: D, E
Explanation:
D: Whenever data blocks change, the Change Tracking Writer (CTWR) background process tracks the changed blocks in a private area of memory.
When RMAN performs an incremental backup on the Exadata platform, cellsrv filters out unwanted blocks and sends back only those that have changed since the last level 0 or level 1 backup.
E: For the Exadata platform, you may choose to allow cellserv to do all the blocking filtering for incremental backups.
Note: RMAN block change tracking is used to improve the performance of incremental backup. The level 0 incremental backup scans the entire database but level 1 incremental backups use the block change tracking file to scan only the blocks that have changed since the last backup. This significantly reduces the amount of reads that are required on the database.
References: Expert Oracle Exadata (29 Aug 2015), page 319

6.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.
Answer: A,C,F
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.

7.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.
Answer: A,D
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-storage-servers.htm#GUID-710814E7-4691-49EE-95AD-726D2D6C5BFE

Get full version of Oracle 1Z0-070 questions and answers from Passtcert.

Leave a Reply

Your email address will not be published. Required fields are marked *

*