NEW QUESTION 1
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 Sca
• C. Partitioning in Exadata should be used wisely,
• D. 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.
• E. Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.
• F. 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.

Answer: A

Explanation: Partition pruning allows you to reduce a 5TB I/O operation to a much smaller I/O operation and therefore much faster return of the information.

NEW QUESTION 2
Which two attributes describe key benefits of the InfiniBand network?

• A. All Exadata database servers have a direct path link to each Exadata Storage Server.
• B. Cell-to-cell communication uses Reliable Datagram Sockets (RDS) over InfiniBand to achieve low latency.
• C. Expanding from two Full racks to four only requires adding an external InfiniBand switch to be at the top of the fat-tree topology.
• D. Each InfiniBand link provides 10 Gigabits of bandwidth.
• E. Oracle's interconnect protocol uses direct memory access (DMA) to eliminate buffer copies and reduce CPU use.

Answer: CE

Explanation: C: Oracle Exadata is architected to scale-out to any level of performance. To achieve higher performance and greater storage capacity, additional database servers and Exadata cells are added to the configuration – e.g., Half Rack to Full Rack upgrade. As more Exadata cells are added to the configuration, storage capacity and I/O performance increases near linearly.
E: Oracle's interconnect protocol uses direct data placement (DMA – direct memory access) to ensure very low CPU overhead by directly moving data from the wire to database buffers with no extra data copies being made. The InfiniBand network has the flexibility of a LAN network, with the efficiency of a SAN.
Incorrect:
Not A: The architecture of the Exadata solution includes components on the database server and in the Exadata cell. The software architecture for a Quarter Rack configuration is shown below.


Not B: No cell-to-cell communication is ever done or required in an Exadata configuration. Not D: Each InfiniBand link provides 40 Gigabits of bandwidth –

NEW QUESTION 3
A control file tracks the physical components of a database. It is the root file that the database uses to find all the other files used by the database. Because of the importance of the control file, Oracle recommends that the control file be ?

• A. size constrained, to prevent size overruns
• B. multiplexed, or have multiple identical copies
• C. stored on an HA USB Drive, to ensure that it does not get overwritten
• D. managed by EM12c, to ensure proper maintenance

Answer: D

NEW QUESTION 4
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

Answer: AB

Explanation: A: Oracle Exadata Storage Expansion Rack X4-2 enables you to grow the Oracle Exadata storage capacity and bandwidth of Oracle Exadata Database Machine X4- 2 and X3-8 and Oracle SuperCluster. It is designed for database deployments that require very large amounts of data, including historical or archive data; backups and archives of Oracle Exadata Database Machine data; documents; images; file and XML data; LOB's; and other large unstructured data.

NEW QUESTION 5
Which statement is true about Exadata Storage Servers?

• A. The Exadata Storage Server automatically deletes old diagnostic and metric files.
• B. Exadata requires a running database instance on all storage servers and database servers.
• C. Redundancy for user data stored in a database that is running on Exadata is achieved with RAID5.
• D. Communication between a database and an Exadata storage flows over low latency 10 Gigabit Ethernet.
• E. 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.

NEW QUESTION 6
CORRECT TEXT
Which two statements are true about migrating your database to Exadata?

• A. Because Exadata uses InfiniBand, in order to migrate your database to Exadata, you must have InfiniBand on the system that you are migrating from.
• B. Using Data Guard Physical Standby to migrate from an 11.1 database to Exadata is beneficial because it allows you to adopt HCC during migration.
• C. ASM and database best practice configuration supplied during Exadata deployment should be retained during and after migration,
• D. Logical migration methods allow more flexibility than physical methods to change the database structure for best performance.
• E. All indexes should be dropped when migrating to Exadata.

Answer: CD

Explanation: Databases on Exadata use ASM. Incorrect:
Not A: 3 network choices: 10 Gb/s Ethernet
40 Gb/s InfiniBand
1 Gb/s Ethernet (No fibre channel)

NEW QUESTION 7
Your customer has purchased their brand new Exadata Database Machine X3-2 Full rack to achieve 20-TB-per-hour backups on their 300 TB database. You have been called to determine why they are not able to achieve even half that rate. Use the information in the image below to identify two reasons their backups are still slow.

• A. The Media Server to Tape Library transfer is causing a bottleneck.
• B. The number of tape drives is causing a bottleneck.
• C. Exadata backups are being performed using RMAN over the 10 Gigabit Ethernet network.
• D. The number of database servers is causing a bottleneck.

Answer: BC

Explanation: The following bottlenecks will be reached first if using InfiniBand fabric to media server:
1. Media server to tape library SAN transfer rate
2. Number of tape drives

NEW QUESTION 8
A customer has three databases named CC. FIN, and DW. The CC database is for their CallCenter. Even a slight decrease in the response time of the database would mean more people "on hold" in their data center. The orders received through the CallCenter are stored in the Finance (FIN) database. Both databases, CC and FIN, serve as sources for the Data Warehouse (DW) database. All databases use the same Automatic Storage Management (ASM) diskgroup and therefore, the same physical disks on Exadata storage. The customer wants to dynamically control the resources that are available for the CallCenter database because this has direct impact on their operations?
Which option should be implemented?

• A. DBRM on the CC database
• B. DBRM on all the databases
• C. IORM, because DBRM cannot be changed for an existing session
• D. IORM and DBRM

Answer: B

Explanation: Using the Database Resource Manager, you can:
Distribute available processing resources by allocating percentages of CPU time to different users and applications. In a data warehouse, a higher percentage may be given to ROLAP (relational on-line analytical processing) applications than to batch jobs.

NEW QUESTION 9
Which two statements are true about CellCLI?

• A. Using a CellCLI command, you can change the SNMP subscribers or add multiple SNMP subscribers.
• B. Using CellCLI, you can stop and start the ASM instances that are using the grid disks on the Exadata storage cell.
• C. With a simple CellCLI command, you can synchronize changes to all the storage cells in the Exadata realm.
• D. Using a CellCLI command, you can see whether grid disks are being used by ASM or not.
• E. You cannot use CellCLI to gather the serial numbers of physical disks.

Answer: BD

Explanation: B:
* Making a grid disk inactive effectively offlines its associated ASM disk.
CellCLI> alter griddisk PRORECO_CD_11_cell01 inactive GridDisk PRORECO_CD_11_cell01 successfully altered
* The command will wait until the ASM disk becomes offline. If you want the prompt to come back immediately without waiting, you can use nowait clause.
CellCLI> alter griddisk PRORECO_CD_11_cell01 inactive nowait You can make it active again:
CellCLI> alter griddisk PRORECO_CD_11_cell01 active GridDisk PRORECO_CD_11_cell01 successfully altered Incorrect:
not E: CellCLI> list physicaldisk detail output include:
physicalSerial: XXXXXX

NEW QUESTION 10
Identify the three values to which the cell_flash_cache attribute can be set.

• A. read
• B. WRITE
• C. KEEP
• D. DEFAULT
• E. NONE

Answer: CDE

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.

NEW QUESTION 11
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.

Answer: B

Explanation: Using the Database Resource Manager, you can distribute available processing resources by allocating percentages of CPU time to different users and applications. In a data warehouse, a higher percentage may be given to ROLAP (relational on-line analytical processing) applications than to batch jobs.
Incorrect: not C:
In addition to controlling I/O utilization on the Exadata storage cells, Oracle also allows you to limit CPU resource utilization on the compute nodes using a technique called instance caging.

NEW QUESTION 12
Identify two ways to reduce the risks associated with the software updates that are performed on a production Exadata system.

• A. Patch all systems at once instead of one at a time.
• B. Test on an Exadata system that is identical to the production system first.
• C. Updating an engineered system has no risk.
• D. Patch on the standby system first by using Data Guard Standby First Patch Apply.
• E. Create a system-wide firmware and software snapshot first.

Answer: BD

Explanation: Patch Installation and Testing Guidelines
1. Review patch documentation
• README and referenced Support Notes
2. (B) Validate in test environment
• Verify patch installation (HealthCheck Note 1070954.1)
• Verify functionality and performance
• Automate
• Define and test fallback plans
3. Apply in production environment
• (D) Data Guard Standby-First Patch Apply
• Monitor for regressions Support Note 1262380.1

NEW QUESTION 13
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.

Answer: AD

Explanation: A: Your Exadata Storage Servers do not need to be backed up; Exadata automatically backs these up using a self-maintained internal USB drive.
D: Backup your Oracle databases using Oracle RMAN

NEW QUESTION 14
Whicr the following software changes that are performed manually on a Linuatches?

• A. owner's guide
• B. Patch database in MyOracle Support
• C. MyOracle Support note 888828.1
• D. MyOracle Support for database patches, ULN for OS patches, and Sun Support for Server and InfiniBand patches.

Answer: B

Explanation: Before starting, we would like to share and note here two documents from My Oracle Support, aka metalink. These notes must be the first place that you need to go to review before patching the Exadata environment.
* (B) Database Machine and Exadata Storage Server 11g Release 2 (11.2) Supported Versions (Doc ID. 888828.1)
- This is for the second and third generation (V2 and X2) for Oracle Exadata, using Sun hardware.
* Database Machine and Exadata Storage Server 11g Release 1 (11.1) Supported Versions (Doc ID. 835032.1)
* - This is for the first generation (V1) for Oracle Exadata, using HP hardware.

NEW QUESTION 15
Which statement is true about Enterprise Manager 12c for Exadata?

• A. EM Agents are installed on each database and storage node.
• B. EM Agents should not be installed on Exadat
• C. Remote monitoring is the best practice.
• D. EM Agents can communicate to storage cells via SSH.
• E. The Exadata Plug-In for monitoring switches is installed in each EM Agent.
• F. Storage cells communicate directly to the EM Management Server via SNMP and/or SMTP.

Answer: D

Explanation: All the code required for monitoring the various Oracle Exadata hardware components has been bundled into the Oracle Exadata plug-in that is pushed to the agents running on the Oracle Exadata Compute (or Database) nodes. Once the plug-in is deployed on the compute nodes, the database machine is ready for discovery with Oracle Enterprise Manager.
Incorrect:
Not A: Since agents only run on the compute nodes it is important to assign specific agents to different Oracle Exadata components. Not B: Oracle Exadata Discovery in Oracle Enterprise Manager 12c

NEW QUESTION 16
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.

Answer: E

Explanation: Recovering Storage Cells from Loss of a System Volume Using CELLBOOT Rescue
Problem
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

NEW QUESTION 17
Identify the relevant steps in the correct order for activating an Auto Service Request (ASR) configuration.
1. Add SNMP traps manually or using OneCommand.
2. Install ASR Manager.
3. Activate a node on ASR Manager.
4. Validate the configuration.
5. Register ASR Manager with Oracle.

• A. 2, 5, 1, 3, and 4
• B. 2, 4, I, 3, and 5
• C. 5, 2, 4, 1, and 3
• D. 5, 4, 2, 1, and 3

Answer: A

Explanation: 2.Install Oracle Auto Service Request (ASR) Packag 5.Register the ASR Manager
1.Add SNMP Trap Destinations for Multiple Servers Using the dcli Utility
3. Activate Node on the ASR Manager