PassLeader now are offering 100% pass ensure 1Z0-485 dumps! All 1Z0-485 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-485 VCE dumps and PDF dumps: https://www.passleader.com/1z0-485.html (82 Q&As)
BTW: Download PassLeader 1Z0-485 dumps from Google Drive for free: https://drive.google.com/open?id=12x1C2TDaXj894HTQfKIN10fpXS2y2JeW
QUESTION 11
Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?
A. database views
B. InfiniBand networking
C. Flash Cache
D. high performance SAS2 disk drives
E. cell offloading
Answer: C
Explanation:
The Exadata Smart Flash Cache feature of the Exadata Storage Server Software intelligently caches database objects in flash memory, replacing slow, mechanical I/O operations to disk with very rapid flash memory operations.
QUESTION 12
In looking to improve query performance for your Data Warehouse, select the best way that Exadata’s Flash Cache feature can be leveraged?
A. Enable Smart Flash Log.
B. Execute alter table … cell_flash_cache=keep on heavily scanned tables.
C. Enable Write Back Flash Cache.
D. Create an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.
Answer: B
Explanation:
In earlier releases, database administrators had to mark an object as KEEP to have it cached in flash cache for large scan workloads. This feature primarily benefits table scan intensive workloads such as Data Warehouses and Data Marts. Random I/Os such as those performed for Online Transactional Processing (OLTP) continue to be cached in the flash cache the same way as in earlier releases.
Note:
With the Exadata Storage Server Software 11.2.3.3.0 and above, the Exadata Smart Flash Cache software automatically caches objects read, in large table scans, in the flash cache based on how frequently the objects are read. Previously, the default behavior was to bypass the flash cache for such large sequential scans.
QUESTION 13
Identify the three values to which the cell_flash_cache attribute can be set.
A. READ
B. WRITE
C. KEEP
D. DEFAULT
E. NONE
Answer: CDE
Explanation:
There are three values the CELL_FLASH_CACHE attribute can be set to:
* DEFAULT — specifies the cache used for a DEFAULT object is automatically managed as described in the previous section.
* NONE — specifies that the object will never be cached.
* KEEP — specifies the object should be kept in cache.
Note:
The CELL_FLASH_CACHE can be assigned to a database table, index, partition and LOB column.
QUESTION 14
High-disk IOPS (I/Os per second) rates are leading to longer execution times. Which three approaches would you use to improve this scenario?
A. Enable Write-Back Flash Cache due to heavy DBWR usage.
B. Enable Write-Back Flash Cache due to heavy LGWR usage.
C. Swap hard disks to High Capacity disks.
D. Tune the application to reduce I/O requests.
E. Leverage IORM to give priority to critical workloads.
Answer: BDE
Explanation:
B (not A): Smart Flash Logging is a recent Exadata enhancement that provides physical disk redo write relief in times of high LGWR activity; alone, probably not a driver for Exadata.
QUESTION 15
When should you use Hybrid Columnar Compression?
A. always
B. on large active tables where deeper compression is desired
C. on tables or partitions that have fairly static data
D. on every table where Advanced Compression is not used
Answer: C
Explanation:
It is recommended that HCC be enabled on tables or partitions with no or infrequent DML operations.
PassLeader now are offering 100% pass ensure 1Z0-485 dumps! All 1Z0-485 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-485 VCE dumps and PDF dumps: https://www.passleader.com/1z0-485.html (82 Q&As)
BTW: Download PassLeader 1Z0-485 dumps from Google Drive for free: https://drive.google.com/open?id=12x1C2TDaXj894HTQfKIN10fpXS2y2JeW