Consider this CellCLI command:

CellCLI> CREATE GRIDDISK ALL HARDDISK PREFIX=data, size=423G;

Which two statements describe what happens when you execute this command?

A. It creates one 423 GB grid disk on the first available cell hard disk.

B. It creates one 423 GB grid disk on each available cell hard disk.

C. It creates grid disks on the outermost 423 GB that is available on each hard disk.

D. It creates grid disks on the innermost 423 GB that is available on each hard disk.

E. It creates an Exadata Smart Flash Cache on all flash drives.

Identify three best practices for applying asmdeactivationoutcome es on Exadata Database Servers and Exadata Storage Servers?

A. Backing up database servers and storage cells is not recommended before performing planned maintenance.

B. Database server updates can be rolled back using the the "yum downgrade" procedure.

C. Bundle patches do not require testing before being installed on a production system.

D. It is recommended that Exadata systems with Data Guard configured use the "Standby First" patching approach.

E. Patching should never be interrupted due to a connection drop. It is therefore recommended that you use VNC or the screen utility.

F. Before patching cells in a rolling manner, you must check asmdeactivationoutcome amModestatus and make sure that cells on all disks are online and that disks can be deactivated.

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

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.

Identify four significant changes when a backup of Exadata compute nodes must be performed.

A. application of operating system patches

B. before shutdown to preserve storage indexes

C. application of Oracle patches

D. reconfiguration of significant operating system parameters

E. installation or reconfiguration of significant non-Oracle software

F. storage server rebalancing

G. addition of an Exadata storage expansion rack

You are concerned about how recovery from a failed Exadata Storage Server would work. Which statement is true about the Exadata CELLBOOT USB?

A. Exadata automatically copies OS binaries and configuration files from another cell during patching to sync the internal USB.

B. Regular Exadata Storage Server patches make sure that the internal USB is updated so that it can be used for recovery.

C. Changes to network configuration files are possible without using ipconf.pl as long as all relevant files are updated.

D. Some space from the CELLBOOT USB is used for cache metadata when write back flash cache is enabled.

E. Each patch that is performed on Exadata storage servers requires manual resync of the CELLBOOT USB.

Identify two reasons why using external tables for high performance data loads on Exadata is more advantageous than SQL*Loader.

A. Transformations can be applied directly on the file data using SQL or PL/SQL constructions.

B. External tables allow transparent parallelization inside the database.

C. Parallelizing loads with external tables enables more efficient space management.

D. External tables can take advantage of storage indexes to speed up data loads.

Which two statements appropriately describe the backup and recovery procedures on Exadata?

A. Cell software backup is automatic and cell recovery is accomplished by using a rescue procedure.

B. Data stored in a database is backed up and restored by using CellCLI commands.

C. Database server software backup is automatic and recovery is accomplished by using a rescue procedure.

D. Data stored in a database is backed up and restored by using RMAN commands.

E. Cell software backup is performed through CellCLI and cell recovery is accomplished by using a rescue procedure.

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

What would be the best way to ensure that batch Jobs do not impact performance of online queries that use the same database?

A. Configure IORM to disable Flash Cache usage for batch workload.

B. Build a Database Resource Management Plan, giving priority to query workload.

C. Deploy Instance Caging to control batch jobs.

D. Configure and enable Parallel Query.

E. Configure resource plans by using the I/O Resource Manager on the storage cells, giving priority to query workload.