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

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/

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

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

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

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

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

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.

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

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

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