1Z0-485 Online Practice Questions and Answers

Your customer wants to increase the size of the DATA diskgroup on the Exadata systems. The customer is currently using 600 GB disks. Which two are the best options that you would recommend?

A. adding a High Capacity Storage expansion rack

B. expanding the Exadata rack from a Half Rack to a Full Rack

C. moving underutilized grid disks from the RECO diskgroup to DATA

D. adding a ZFS storage appliance

E. adding a High Performance Storage expansion rack

What are two choices that a customer must make that impact diskgroup creation?

A. What is the level of redundancy required?

B. What OS will be run?

C. Where will disk backups be written?

D. How many databases will run on the cluster?

When would be the best time to run an Exadata health check (exachk)?

100% Real QandAs | 100% Real Pass

A. before patching, before upgrades, before backups, and on a regular basis

B. after patching, after upgrades, and after backups

C. only when advised by Oracle Support

D. before and after patching, when advised by Oracle Support, and on a regular basis

E. only after a hardware failure

F. monthly and after a hardware failure

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.

How does partition pruning, a 11gR2 database feature, help to improve performance on an Exadata Database Machine?

A. Partition pruning allows you to reduce a 5 TB I/O operation to a much smaller I/O operation and therefore, enables a much faster return of information.

B. Using partition pruning can force the optimizer to use that method instead of Smart Scan. Partitioning in Exadata should be used wisely,

C. Partition pruning is not a supported option in the 11gR2 database code that runs on an Exadata Machine, due to issues with Cost Based Optimizer plans.

D. Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.

E. Partition pruning allows you to reduce a 5 TB I/O operation to a larger I/O operation and therefore, forces the use of the Smart Scan technology.

The Exadata compute node, exadbs04, has been having issues for some time. The server had to be repaired and you just received a new server. Your LVM snapshot was corrupt and now the compute node must be re-image with an Oracle Support installation image. Which three tasks would you need to perform to re-image the compute node?

A. Mount the LVM backup image across the network and recover the system.

B. Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.

C. Create a CELLBOOT USB Flash Drive using an external USB drive.

D. Reboot the new server using a bootable recovery image from the external USB drive.

E. Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).

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.

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;