NEW QUESTION 1
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 2
When running OS Watcher, which two data outputs are valid for Exadata storage cell performance analysis? Select the two correct choices that apply?

• A. lostat
• B. mpstat
• C. netstat
• D. pkginfo
• E. label

Answer: AC

Explanation:
Example:
# A few find examples
# ( -name "*.*" )
# ( -name "*vmstat*.*" -o -name "*iostat*.*" )
# ( -name "*vmstat*.*" -o -name "*iostat*.*" ) -mmin -60
# ( -name "*vmstat*.*" -o -name "*iostat*.*" -o -name "*netstat*.*" ) -mtime -8

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

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.

NEW QUESTION 4
Identify three Exadata Storage Server software processes and their purpose?

• A. CELLSRV: The Cell Server is responsible for servicing disk I/O and predicate processing offload.
• B. CELLSRV: The Cell Server is responsible for balancing workload to other storage servers.
• C. MS: The Management Server is responsible for storage cell management and configuration.
• D. MS: The Management Server is responsible for starting a local Enterprise Manager agent.
• E. RS: The Restart Server is responsible for Automatic Storage Management (ASM) instance restart.
• F. RS: The Restart Server is responsible for CELLSRV and MS monitoring and restart.

Answer: ACF

Explanation:
A: CELLSRV (Cell Services) is the primary component of the Exadata software running in the cell
and provides the majority of Exadata storage services. CELLSRV is multi-threaded software that
communicates with the database instance on the database server, and serves blocks to databases
based on the iDB protocol. It provides the advanced SQL offload capabilities, serves Oracle
blocks when SQL offload processing is not possible, and implements the DBRM I/O resource
management functionality to meter out I/O bandwidth to the various databases and consumer groups issuing I/O.
C: The MS is the primary interface to administer, manage and query the status of the Exadata cell. It works in cooperation with the Exadata cell command line interface (CLI) and EM Exadata plug-in, and provides standalone Exadata cell management and configuration. For example, from the cell, CLI commands are issued to configure storage, query I/O statistics and restart the cell. Also supplied is a distributed CLI so commands can be sent to multiple cells to ease management across cells.
F: Restart Server (RS) ensures the ongoing
functioning of the Exadata software and services. It is used to update the Exadata software. It also ensures storage services are started and running, and services are restarted when required.

NEW QUESTION 5
Which three statements accurately describe update of software on Exadata Database Machine?

• A. The Oracle Database patchset software (for example, 11.2.0.3) requires the Exadata- specific version.
• B. Rolling patching is faster than non-rolling patching, but database down time is longer.
• C. The Oracle Database software on Exadata is updated using standard OPatch and the Oracle Universal Installer.
• D. Running Exadata with different storage server software versions is supported, but should be minimized to rolling patching scenarios.
• E. The database server operating system software (other than kernel and OFED) may be installed or updated from non-Exadata sources
• F. Storage server updates require access to an Unbreakable Linux Network (ULN) based repository.

Answer: CDF

Explanation:
C:
* Oracle offers two utilities for software deployment: Oracle Universal Installer to install Oracle products OPatch to apply interim patches
F: When storage cells are patched, there is almost always a set of storage server patches that need to be applied to the Exadata Compute Nodes as well. Historically, these were called “minimal packs,” but recent improvements to the compute node patching process deliver these updates using yum channels on Oracle’s Unbreakable Linux Network (ULN).
Incorrect:
Not B: Rolling patching has no downtime.

NEW QUESTION 6
Which two actions are permitted with Exadata Database Machine?

• A. replacing the Ethernet switch with an equivalent 1U 48-port Gigabit Ethernet switch
• B. installing a second Ethernet switch in the Exadata rack for client access network connectivity
• C. replacing the Sun Data Center InfiniBand Switch 36-spine switch with an InfiniBand Gateway Switch
• D. configuring a Linux active-active channel bonding on the database servers by using two 10-Gigabit Ethernet port
• E. configuring a Fibre Channel over Ethernet (FCoE) protocol on database servers

Answer: AC

Explanation:
There are total two category of network switches used to prepare computing environment inside the rack.
* InfiniBand Switches - two models used depending on requirements Sun Oracle 36-port InfiniBand Switch
Sun Oracle InfiniBand Gateway Switch
* Ethernet Switch - primarily for management purposes Cisco Catalyst 4948

Common information that applies to both of these InfiniBand switches Form Factor: One rack unit (1U) height
Power Supplies: Two Cooling Fans: Five
IB Subnet Management: Yes Firmware Upgradeable: Yes
Command Line Access: Yes. Via ssh and usb-serial access Web Based Management: Yes
SNMP Access: Yes
As you might have figured out by now that the IB Gateway switch is almost like a super set of 36-port switch in terms of features and capabilities.
Incorrect:
Not E: Since the Exadata hardware cannot be modified, it is not supported to add HBA cards to any of the Exadata servers. It is supported to present storage via the network ports on the database servers via NFS or iSCSI, although Fibre Channel over Ethernet (FCoE) is not supported.

NEW QUESTION 7
Which three migration options are available when you migrate a database from the Big Endian format system to Exadata?

• A. Data Pump Export and Import
• B. transportable database
• C. transportable tablespaces
• D. Data Guard
• E. Insert as Select

Answer: BCD

Explanation:
Methods at a Glance:
* Data Guard Physical Standby
* Transportable Database (Note:732053.1)
* Transportable Tablespace (TTS)

NEW QUESTION 8
Identify the correct steps required to upgrade a 1/8th rack of Exadata to a 1/4th rack.

• A. Remove the doors of the 1/8th rack.Add the new servers.Cable the Database Servers in the rack.Cable the Exadata Storage Servers in the rack.Close the rack.
• B. Activate all cores by using a software command.Activate all hard drives and flash drives.Create the grid disks.Expand the Oracle ASM diskgroups.Review the new configuration.
• C. Remove the doors of the 1/8th rack.Add an additional Sun Datacenter InfiniBand Switch.Add the new servers.Cable the Database Servers in the rack.Cable the Exadata Storage Servers in the rack.Close the rack.Configure the new hardware.
• D. Activate all cores by using a software command.Activate all hard drives and flash drives.

Answer: B

Explanation:
Not A: no need to remove doors. Not C: No additional Infiband Switch needed. Note:
* Database Machine Upgrades

* Database Machine Components and Upgradeability

NEW QUESTION 9
What are three ways to be informed of an Exadata Storage Server disk failure?

• A. review of the output of list alerthistory
• B. review of the output of select status from vSdatafile
• C. review of the ILOM log
• D. alert notifications through email when SMTP notification is configured
• E. alert notifications in the Enterprise Manager Exadata Plug-In
• F. review of database server iostat output

Answer: ADE

Explanation:
A: A disk status change would be associated with an entry in the storage cell alerthistory.
D: The Cell Alert Delivery Configuration Worksheet allows you to provide SMTP details to allow for e-mail communication of various cell alerts and failures.
Incorrect:
Not F: Use the iostat command to report statistics about disk input and output, and to produce measures of throughput, utilization, queue lengths, transaction rates, and service time.

NEW QUESTION 10
Which two migration will result in the least down time for a physical or logical migration of a database with active users during the migration?

• A. using GoldenGate
• B. using SQL Developer migration tools
• C. using Data Guard Physical Standby
• D. using cross-platform transportable tablespaces
• E. using incremental cross-platform RMAN restore

Answer: AE

Explanation:
A: Zero Downtime Migration to Oracle Exadata using Oracle GoldenGate
– Reduce downtime for any method
– Zero data loss fallback
– Phased migration
E: Cross Platform Incremental Backups
– Reduce downtime for Transportable Tablespaces

NEW QUESTION 11
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 dro
• F. It is therefore recommended that you use VNC or the screen utility.
• G. 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.

Answer: DEF

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

Answer: D

Explanation:
3. The database is started.
5. A query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=1500.
The Exadata cell services software conducts I/O requests on I MO storage regions.
7. MYOBJ_STATE’S region index is populated with high and low values for the OBJECT_ID column during the I/O request.
6. A subsequent query is Issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.
2. cellsrv checks the high and low values, and determines the storage region does not contain any values meeting the predicate.
4. Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage.
Note: Example:
Step 1 (step 5 in answer): The first time that each cell’s cell services software issued an I/O request to access extents
from the D14.MYOBJ_UNCOMP table, Exadata populated a region index for each storage index with the high and low values found for the OBJECT_ID column, based on the WHERE
OBJECT_ID BETWEEN 100 AND 200 query predicate.
Step 2 (step 6 in answer) : Subsequent queries against this table generated an iDB message instructing Exadata’s
cell services software to read the same sets of extents as the first query, but in this case the
region indexes would have been populated based on the I/Os read from the first query. Step 3: (step 2 in answer) Prior to issuing a physical disk read, cellsrv checks the high and low values stored in the
region index and if it determines that a storage region does not contain any values meeting the query predicate, bypasses the physical I/O to the region.

NEW QUESTION 13
Which two statements are true about Exadata memory capabilities?

• A. X3-8 can be purchased in a Half Rack configuration with 2 TB of memory.
• B. X3-2 memory can be expanded to 512 GB per node from 256 GB.
• C. X3-2 memory can be upgraded to use Flash in the compute nodes.
• D. X3-8 memory is fixed at 4 TB per a Rack.
• E. X3-2 can be purchased in a Half Rack configuration with 256 GB per node.

Answer: DE

Explanation:
D: ORACLE EXADATA DATABASE MACHINE X3-8 features include: 160 CPU cores and 4 TB of memory for database processing
E: Database servers X3-2
A third generation was announced in 2012. Each Database Server with 2 x Eight-Core Intel Xeon E5-2690 Processors (2.9 GHz)
128 GB Memory (expandable to 256GB)

NEW QUESTION 14
Which statement is true about the patching features provided in Platinum Services?

• A. Patching services are available for the full software stack up to twice per year.
• B. Patching support includes Exadata, Exalogic, and Database Appliance.
• C. Rolling window and complete down time approaches are two options to patching.
• D. Platinum covers Exadata storage software and firmware patching, but the customer must perform database patching.

Answer: D

Explanation:
* Patch Deployment: Oracle Platinum Services also includes patching services in which Oracle
applies patches to covered systems four times (not A) per year via the Oracle Advanced Support
Gateway. We work collaboratively with customers to assess, analyze, plan and deploy updates
and patches to mitigate risks and complications. Through this continuous improvement, customers can experience greater system performance, availability, and security.
* not B: Oracle Platinum Services provides enhanced support for high availability and performance to Oracle Premier Support customers
running certified configurations of Oracle Exadata Database Machine, Oracle Exalogic Elastic Cloud, or Oracle SuperCluster—at no additional cost.

NEW QUESTION 15
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 16
Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?

• A. INSERT
• B. insert with an append hint
• C. UPDATE
• D. CREATE TABLE AS SELECT

Answer: BD

Explanation:
To maximize storage savings with Hybrid Columnar Compression, data must be loaded using data warehouse bulk loading techniques. Examples of bulk load operations commonly used in data warehouse environments are:
* Insert statements with the APPEND hint
* Parallel DML
* Direct Path SQL*LDR
* Create Table as Select (CTAS)
Incorrect:
Not A, Not C: DML operations (INSERT/UPDATE) against a Hybrid Columnar Compressed table/partition can reduce the overall compression savings over time since data INSERTED/UPDATED via DML operations will not be compressed to the same ratio as data that is bulk loaded.

NEW QUESTION 17
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;

Answer: A

Explanation:
ASMDeactivationOutcome – recall that grid disks can be deactivated, which is effectively taking them offline. Since ASM mirroring ensures that the data is located on another disk, making this disk offline does not lose data. However, if the mirror is offline, or is not present, then making this grid disk offline will result in loss of data. This attribute shows whether the grid disk can be deactivated without loss of data. A value of “Yes” indicates you can deactivate this grid disk without data loss.
CellCLI> list griddisk attributes name, ASMDeactivationOutcome, ASMModeStatus DBFS_DG_CD_02_cell01 Yes ONLINE
DBFS_DG_CD_03_cell01 Yes ONLINE DBFS_DG_CD_04_cell01 Yes ONLINE
… output truncated …

NEW QUESTION 18
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 19
Your customer would like to use DBFS in their Exadata environment. They are asking you for the key characteristic of DBFS on Exadata.

• A. DBFS in an Exadata environment is faster than an NFS mount system because of the Smart Scan performance gains.
• B. Tens of thousands of files are the perfect use case for DBFS on Exadata.
• C. DBFS offers tremendous I/O bandwidth.

Answer: B

NEW QUESTION 20
Identify a recommended configuration to set up Auto Service Request (ASR) for Exadata.

• A. Install ASR Manager on Exadata Database Server.
• B. Install ASR Manager on Exadata Storage Server.
• C. ASR is not recommended for Exadata; the Oracle Configuration Manager is preferred.
• D. Install ASR Manager on a Standalone Server.

Answer: D

Explanation:
The recommended configuration is to install the ASR Manager, which receives fault telemetry information from the servers in Oracle Exadata Database Machine, on an external standalone server. This server must run Solaris or Linux as the operating system.

NEW QUESTION 21
......