1Z0-485 Online Practice Questions and Answers

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.

When an Exadata Storage Server hard disk failure alert is received, what manual action must you take to restore the system to full redundancy?

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

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

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

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

E. Run RMAN REPAIR FAILURE.

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?

A. Database Machine Administrators should be prepared by creating a backup using dbserver_backup.sh.

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

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

D. Be sure that you have a backup by running make_cellboot_usb.sh in /opt/oracle.cellos.

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

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

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?

SQL> select count (*) from transmap.mymap_comp

2 where map_id between 400 and 500;

COUNT(*)

103000

Elapsed: 00:00:00.08

SQL> 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', 穋ell physical IO interconnect bytes', 穋ell physical IO bytes saved by storage index',

100% Real QandAs | 100% Real Pass

穋ell physical IO interconnect bytes returned by smart scan') 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

A. The storage indexes were disabled using the DISABLE_STORAGE_INDEX Parameter.

B. Storage Index data is not on the Cell Server's region index memory structures yet because this predicate has not been used.

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

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

Which Exadata feature uses Flash as a parallel write cache to Disk Controller Cache?

A. Exadata DRAM

B. InfiniBand network cache C. high performance SAS disks

D. Smart Flash Log

E. Hybrid Columnar Compression

You are asked to enable Write Back Flash Cache for one of your customers X3-2 Full Rack in a rolling fashion. Put the following steps in the right order:

A. Set flashCacheMode to writeback.

B. Inactivate all grid disks and shut down cellsrv.

C. Drop the Flash Cache.

D. Verify that cell for flashcacheMode is writeback.

E. Create the Flash Cache.

F. Start up cellsrv and activate all grid disks.

G. Check grdidksk asmdeactivationoutcome and asmmodestatus for all grid disks to ensure that all grid disks on all cells are set to Yes and online, respectively.

A. G. B, C, A, F, E, D, and G

B. G, A, B, C, F, E, D, and G

C. G, C, B, A, F, E, D, and G

D. G, E, C, B, F, A, D, and G

Storage indexes are unique to the Exadata Database Machine and their primary goal is to reduce the amount of I/O required to service I/O requests for Exadata Smart Scan. Put the following steps in order:

1.

The Exadata cell services software conducts I/O requests on I MO storage regions.

2.

cellsrv checks the high and low values, and determines the storage region does not contain any values meeting the predicate.

3.

The database is started.

4.

Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage.

5.

A query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=1500.

6.

A subsequent query is Issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.

7.

MYOBJ_STATE'S region index is populated with high and low values for the OBJECT_ID column during the I/O request.

A. 3. 7, 5, 2, 1, 6, and 4

B. 3, 7, 1, 5, 6, 2, and 4

C. 3, 6, 1. 7, 2, 5 and 4

D. 3, 5, 1, 7, 6, 2. and 4

100% Real QandAs | 100% Real Pass

After migrating from legacy disk-based configuration, which three approaches would you use to evaluate the efficiency of Exadata Flash Cache?

A. Review the Flash Hit rate via cellcli metrics.

B. Compare Optimized Physical Reads and Total Read Requests in Automatic Workload Repository (AWR).

C. Review the IOSTAT data that is gathered from each compute node by OS Watcher.

D. Evaluate the Smart Flash Logging efficiency metrics via CellCLI.

E. Check I/O latency on large I/O to Temp in AWR.

Why is ASM High redundancy an important configuration choice when rolling Exadata Storage Server patching is planned?

100% Real QandAs | 100% Real Pass

A. High redundancy protects from partner disk failure while a cell is offline being updated.

B. High redundancy forces ASM rebalance before allowing disks to be taken offline.

C. High redundancy speeds up ASM fast mirror resync when a cell is brought back online after patching.

D. Normal redundancy provides the same protection during rolling patching, so High redundancy is not important in this case

Which CellCLI command is used to conclude that a storage server can be taken offline without impacting database availability?

A. LIST GRIDDISK ATTRIBUTES name, asmDeactivationOutcome;

B. LIST CELLDISK ATTRIBUTES name, raidLevel;

C. LIST CELL ATTRIBUTES cellsrvStatus, flashCacheMode;

D. LIST CELLDISK ATTRIBUTES name, raidLevel, asmModeStatus;

E. LIST GRIDDISK ATTRIBUTES name, status;