Oracle Exadata Database Machine 2014 Implementation Essentials
Question No: 21
Which statement is true about Exadata Storage Servers?
The Exadata Storage Server automatically deletes old diagnostic and metric files.
Exadata requires a running database instance on all storage servers and database servers.
Redundancy for user data stored in a database that is running on Exadata is achieved with RAID5.
Communication between a database and an Exadata storage flows over low latency 10 Gigabit Ethernet.
Exadata uses network affinity to determine which storage server data is written.
Answer: C Explanation: Incorrect:
Not B: Only on database servers.
not D: Exadata Storage Servers have dual 40 Gigabit InfiniBand links that provide connectivity
many times faster than traditional storage or server networks.
Question No: 22
Your customer is hesitant to install the Oracle Configuration Manager in their environment. Give them three ways in which it will benefit their Exsdata Database Machine support experience and potentially resolve some of the issues they are having with the length of time it is taking Oracle to process their Exadata Service Requests (SRs).
Host information can be gathered and sent to Oracle for license compliance.
Potential issues can be addressed before they impact operations.
Priority handling can be extended for SRs, with attached configuration.
Exadata patching cannot be done successfully without the Oracle Configuration Manager.
Root cause analysis can be accelerated.
Explanation: Oracle Configuration Manager is used to personalize the support experience by collecting configuration information and uploading it to the Oracle repository.
When customer configuration data is uploaded on a regular basis, customer support representatives can analyze this data and provide better service to the customers. For
example, when a customer logs a service request, he can associate the configuration data directly with that service request (C). The customer support representative can then view the list of systems associated with the customer and solve problems accordingly.
Some of the benefits of using Oracle Configuration Manager are as follows:
/ Reduces time for resolution of support issues (E)
/ Provides pro-active problem avoidance (B)
/ Improves access to best practices and the Oracle knowledge base
/ Improves understanding of customer#39;s business needs and provides consistent responses and services
Question No: 23
Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?
high performance SAS2 disk drives
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 No: 24
In looking to improve query performance for your Data Warehouse, select the best way that Exadata#39;s Flash Cache feature can be leveraged?
Enable Smart Flash Log.
Execute alter table … cell_flash_cache=keep on heavily scanned tables.
Enable Write Back Flash Cache.
Create an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.
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 18.104.22.168.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 No: 25
Identify the three values to which the cell_flash_cache attribute can be set.
Explanation: There are three values the CELL_FLASH_CACHE attribute can be set to.
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 No: 26
High-disk IOPS (I/Os per second) rates are leading to longer execution times. Which three approaches would you use to improve this scenario?
Enable Write-Back Flash Cache due to heavy DBWR usage.
Enable Write-Back Flash Cache due to heavy LGWR usage.
Swap hard disks to High Capacity disks.
Tune the application to reduce I/O requests.
Leverage IORM to give priority to critical workloads.
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 No: 27
When should you use Hybrid Columnar Compression?
on large active tables where deeper compression is desired
on tables or partitions that have fairly static data
on every table where Advanced Compression is not used
Explanation: It is recommended that HCC be enabled on tables or partitions with no or infrequent DML operations
Question No: 28
When an Exadata Storage Server hard disk failure alert is received, what manual action must you take to restore the system to full redundancy?
Replace the disk and run MegaCLI to rebuild the degenerate mirror.
No manual action is required because Automatic Storage Management (ASM) fast mirror resync is automatic
No manual action is required because ASM rebalancing is automatic.
Replace the disk and manually copy the mirror extents to the new drive.
Run RMAN REPAIR FAILURE.
Explanation: As soon as the Hard Disk failure is noticed by the MS (Management Server) background process on the Cell, it will raise an alert that will also be published to Grid Control, if configured. Immediately, due to Pro-Active Disk Quarantine, the ASM-, Grid- and Celldisks get dropped. ASM rebalancing is triggered. You as the responsible Admin notice the alert and order a replacement Disk resp. use a Spare Disk to plug it into the Cell after you plugged out the damaged one. The Cell can stay online, because the Hard Disks are hot-pluggable.
No further administrative work to be done, typically.
Question No: 29
You are concerned about how to recover from a failed Exadata Storage Server. What is the best way to recover from a storage cell failure when content in both system disks is lost?
Database Machine Administrators should be prepared by creating a backup using dbserver_backup.sh.
Database Machine Administrators should be prepared by creating a backup to an NFS file location as described in the owners guide.
Any USB can be plugged in to create a backup.
Be sure that you have a backup by running make_cellboot_usb.sh in /opt/oracle.cellos.
Use the Exadata Storage Server rescue functionality that Is provided on the CELLBOOT USB flash drive.
Re-imaging the cell is the only option.
Explanation: Recovering Storage Cells from Loss of a System Volume Using CELLBOOT Rescue
You have either corrupted your system volume images or suffered from simultaneous loss of the first two disk drives in your Exadata storage cell, and you wish to use the internal
CELLBOOT USB drive to recover from failure. Solution
At a high level, these are the steps you should take:
Understand the scope of the failure
Contact Oracle Support and open a Service Request
Boot your system from the internal CELLBOOT USB image
Recover your storage cell using the cell rescue procedure
Perform post-recovery steps and validation
Question No: 30
You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O savings as a result of the storage indexes. Which two statements are true?
SQLgt; select count (*) from transmap.mymap_comp 2 where map_id between 400 and 500;
SQLgt; select b.name, a.value/1024/1024 value from vSmystat a, vSstatname b,
where b.statistic# = a.statistic#
and b.nafne in (鈥ell physical IO bytes eligible for predicate offload#39;,
鈥ell physical IO interconnect bytes#39;,
鈥ell physical IO bytes saved by storage index#39;,
鈥ell physical IO interconnect bytes returned by smart scan#39;) order by 1; Statistic Value (MB)
cell physical IO bytes eligible for predicate offload 2,255 .09 cell physical IO bytes saved by storage index .00
cell physical IO interconnect bytes 1.72
cell physical IO interconnect bytes returned by smart scan 1.68
The storage indexes were disabled using the disable_storage_INDEX Parameter.
Storage Index data is not on the Cell Server#39;s region index memory structures yet because this predicate has not been used.
Since the database was started, no quires were run against this table with the same predicate.
The storage indexes reduced the amount of physical I/O bytes significantly for this query.
Explanation: * cell physical I/O bytes eligible for predicate offload Number of bytes eligible for predicate offload, an indication of smart scan
(not D) cell physical I/O bytes saved by storage index Here 0.
Number of bytes saved by a storage index; this is a reflection of how many physical disk I/O bytes (and by proxy, requests) were saved due to a storage index eliminating candidate blocks
100% Free Download!
–Download Free Demo:1z0-485 Demo PDF
100% Pass Guaranteed!
–Download 2018 Latesttests 1z0-485 Full Exam PDF and VCE
Latesttests ExamCollection Testking Lowest Price Guarantee Yes No No Up-to-Dated Yes No No Real Questions Yes No No Explanation Yes No No PDF VCE Yes No No Free VCE Simulator Yes No No Instant Download Yes No No