Download Oracle Exadata X5 Administration.1z0-070.Pass4Sure.2017-11-24.50q.vcex

Vendor: Oracle
Exam Code: 1z0-070
Exam Name: Oracle Exadata X5 Administration
Date: Nov 24, 2017
File Size: 309 KB

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

ProfExam Discount

Demo Questions

Question 1
Which three are true about Exadata Smart Flash Log?
  1. Databases on the Database Machine use Exadata Smart Flash Log by default.
  2. I/O Resource Manager database plans can be used to enable or disable Exadata Smart Flash Log for individual databases.
  3. LGWR will not wait for writes to Exadata Smart Flash Log if the write to a disk-based logfile completes first.
  4. I/O Resource Manager category plans can be used to enable or disable Exadata Smart Flash Log for different I/O categories.
  5. The use of Exadata Smart Flash Logs is mandatory for support of production databases.
Correct answer: ABC
Explanation:
A: Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine, reserving flash for the most performance critical databases. B: The Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine. C: Smart Flash Logging works as follows. When receiving a redo log write request, Exadata will do parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash hardware. When either of these writes has successfully completed the database will be immediately notified of completion. If the disk drives hosting the logs experience slow response times, then the Exadata Smart Flash Cache will provide a faster log write response time. Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times (e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time. This algorithm will significantly smooth out redo write response times and provide overall better database performance. Incorrect Answers:D: Category plans are configured and enabled using the CellCLI utility on the cell. Only one category plan can be enabled at a time.References: http://structureddata.org/2011/10/12/exadata-smart-flash-logging-explained/
A: Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine, reserving flash for the most performance critical databases. 
B: The Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine. 
C: Smart Flash Logging works as follows. When receiving a redo log write request, Exadata will do parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash hardware. When either of these writes has successfully completed the database will be immediately notified of completion. If the disk drives hosting the logs experience slow response times, then the Exadata Smart Flash Cache will provide a faster log write response time. 
Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times (e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time. 
This algorithm will significantly smooth out redo write response times and provide overall better database performance. 
Incorrect Answers:
D: Category plans are configured and enabled using the CellCLI utility on the cell. Only one category plan can be enabled at a time.
References: http://structureddata.org/2011/10/12/exadata-smart-flash-logging-explained/
Question 2
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? 
  1. Linux operating system on the storage server
  2. InfiniBand HCA firmware on the storage server
  3. Storage server hard disk device drivers
  4. Storage server flash device drivers
Correct 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 Oracle GI/RDBMS Homes Exadata Storage Cells Compute nodes Infiniband Switches References: https://www.toadworld.com/platforms/oracle/w/wiki/11640.oracle-exadata-patching
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 
  • Oracle GI/RDBMS Homes 
  • Exadata Storage Cells 
  • Compute nodes 
  • Infiniband Switches 
References: https://www.toadworld.com/platforms/oracle/w/wiki/11640.oracle-exadata-patching
Question 3
Which two statements are true about the use of DBFS, ACFS, and external file systems and components in an X5 Database Machine environment?
  1. ACFS uses storage in a database on the database machine
  2. DBFS supports file system snapshots.
  3. ACFS supports file system snapshots.
  4. Storage Area Network (SAN) –based file systems may be accessed directly from the storage servers in a database machine.
  5. Oracle Sun ZFS Storage Appliance- based files are not automatically protected by Data Guard.
Correct answer: BC
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.pdfhttp://www.oracle.com/technetwork/database/database-technologies/cloud-storage/benefits-of-oracle-acfs-2379064.pdf
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
Question 4
Which two are true about sparse griddisks and their use in disk groups on an X5 Exadata Database Machine?
  1. Sparse diskgroups must be created using sparse griddisks.
  2. Sparse diskgroups may be created using a combination of sparse and non-sparse griddisks.
  3. Sparse diskgroups may not be used for database snapshots.
  4. Additional space for a sparse griddisk is allocated as soon as newly written data is stored in the flashcache on a cell.
  5. The virtual size of a sparse griddisk may exceed the physical size of the space occupied by the griddisk.
Correct answer: AE
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-A1201D16238Fhttp://docs.oracle.com/cd/E80920_01/DBMSO/exadata-whatsnew.htm#DBMSO22120
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
Question 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? 
  1. Simple Network Management Protocol (SNMP) traps are used to send notifications from database servers to the ASR Manager.
  2. Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to the ASR Manager.
  3. When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).
  4. When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS.
  5. Simple Network Management Protocol (SNMP) traps are used to send notifications from the Enterprise Manager to the ASR Manager.
  6. 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.31SNMPv2-SMI::snmpModules.1.1.4.1.0 = OID: SUN-HW-TRAP-MIB::sunHwTrapHardDriveFaultSUN-HW-TRAP-MIB::sunHwTrapSystemIdentifier = STRING: Sun Oracle Database MachineEtc. 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.htmhttps://docs.oracle.com/cd/E37710_01/install.41/e18475/ch5_troubleshooting.htm#ASRUD331
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 6
Which two statements are true about RMAN incremental level-1 backups for a database running on an X5 Database Machine?
  1. 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.
  2. cellsrv filters blocks and returns only those that have changed since the last backup, for databases in archivelog mode.
  3. 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. 
  4. cellsrv filters blocks and returns only those that have changed since the last backup, for databases in noarchivelog mode.
  5. Block Change Tracking (BCT) is not needed for databases in an X5 Database Machine, because change tracking is done by cellsrv.
Correct answer: DE
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
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
Question 7
Which three statements are true about Exadata storage server alerts in an X5 Database Machine? 
  1. Storage server alerts notifications may be sent using SNMP.
  2. A threshold- based alert gets cleared automatically when the measured value no longer violates the threshold.
  3. A storage server alert is only ever issued as a warning or at a critical situation.
  4. Storage server alerts are all stateless alerts.
  5. Storage server alerts are all stateful alerts.
  6. 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.
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 8
Which two statements are true about the X5 Exadata storage server rescue procedure?
  1. The rescue procedure can be executed from the CELLBOOT USB flash drive.
  2. An Exadata storage server automatically enters the rescue environment when it cannot boot from the system area.
  3. The rescue procedure can be used to repair corruption in an ASM diskgroup.
  4. The rescue procedure can be used to restore a corrupt system area.
  5. 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-storage-servers.htm#GUID-710814E7-4691-49EE-95AD-726D2D6C5BFE
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
Question 9
Which two statements are true about backup performance when using Recovery Manager (RMAN) on an X5 Database Machine?
  1. 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.
  2. Backups are fast, because physical I/Os operations are reduced by the use of the Storage Index by cellsrv.
  3. Backups are fast, because data blocks are read from the Database Flash Cache. 
  4. Backups are fast, because all data blocks are read from the Exadata Smart Flash Cache.
  5. 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/#.Wd80zmiCyUkhttp://www.oracle.com/technetwork/database/availability/maa-tech-wp-sundbm-backup-11202-183503.pdf
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 10
In which scenario will griddisks residing on the same celldisk have balanced performance characteristics in an X5 High Capacity Exadata Storage Server?
  1. griddisks on memory based celldisks
  2. griddisks on hard disk-based celldisk consumed by ASM when creating diskgroups using ASM-based Intelligent Data Placement (IDP)
  3. griddisks on hard disk-based celldisks consumed by the Database Smart Flash Cache
  4. 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
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
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!