2018 Jan Oracle Official New Released 1z0-485
100% Free Download! 100% Pass Guaranteed!

Oracle Exadata Database Machine 2014 Implementation Essentials

Question No: 21

Which statement is true about Exadata Storage Servers?

  1. The Exadata Storage Server automatically deletes old diagnostic and metric files.

  2. Exadata requires a running database instance on all storage servers and database servers.

  3. Redundancy for user data stored in a database that is running on Exadata is achieved with RAID5.

  4. Communication between a database and an Exadata storage flows over low latency 10 Gigabit Ethernet.

  5. 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).

  1. Host information can be gathered and sent to Oracle for license compliance.

  2. Potential issues can be addressed before they impact operations.

  3. Priority handling can be extended for SRs, with attached configuration.

  4. Exadata patching cannot be done successfully without the Oracle Configuration Manager.

  5. Root cause analysis can be accelerated.

Answer: B,C,E

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?

  1. database views

  2. InfiniBand networking

  3. Flash Cache

  4. high performance SAS2 disk drives

  5. 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 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?

  1. Enable Smart Flash Log.

  2. Execute alter table … cell_flash_cache=keep on heavily scanned tables.

  3. Enable Write Back Flash Cache.

  4. 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 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.

  1. read

  2. WRITE

  3. KEEP


  5. NONE

Answer: C,D,E

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 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?

  1. Enable Write-Back Flash Cache due to heavy DBWR usage.

  2. Enable Write-Back Flash Cache due to heavy LGWR usage.

  3. Swap hard disks to High Capacity disks.

  4. Tune the application to reduce I/O requests.

  5. Leverage IORM to give priority to critical workloads.

Answer: B,D,E

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?

  1. always

  2. on large active tables where deeper compression is desired

  3. on tables or partitions that have fairly static data

  4. 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

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?

  1. Replace the disk and run MegaCLI to rebuild the degenerate mirror.

  2. No manual action is required because Automatic Storage Management (ASM) fast mirror resync is automatic

  3. No manual action is required because ASM rebalancing is automatic.

  4. Replace the disk and manually copy the mirror extents to the new drive.


Answer: C

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?

  1. Database Machine Administrators should be prepared by creating a backup using

  2. Database Machine Administrators should be prepared by creating a backup to an NFS file location as described in the owners guide.

  3. Any USB can be plugged in to create a backup.

  4. Be sure that you have a backup by running in /opt/oracle.cellos.

  5. Use the Exadata Storage Server rescue functionality that Is provided on the CELLBOOT USB flash drive.

  6. Re-imaging the cell is the only option.

Answer: E

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;


    ——————– 103000

    Elapsed: 00:00:00.08

    SQLgt; select, 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

    1. The storage indexes were disabled using the disable_storage_INDEX Parameter.

    2. Storage Index data is not on the Cell Server#39;s region index memory structures yet because this predicate has not been used.

    3. Since the database was started, no quires were run against this table with the same predicate.

    4. The storage indexes reduced the amount of physical I/O bytes significantly for this query.

    Answer: B,C

    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

    2018 Latesttests IT Certification PDF and VCE

Comments are closed.