1z0-485 Exam - Oracle Exadata Database Machine 2014 Implementation Essentials

NEW QUESTION 1
How would you execute CellCLI commands and scripts?

• A. using SQL*Plus on database nodes
• B. by CellCLI commands executed on the database nodes
• C. using third party tools after installing the CellCLI RPM plug-in
• D. directly executing the commands and scripts on the Exadata storage cell
• E. remotely by connecting to Port 1521 using SSL

Answer: D

Explanation:
The storage cells in Exadata Database Machine are managed via two tools called CellCLI and DCLI.

NEW QUESTION 2
What are two impacts of selecting high redundancy over normal redundancy for your diskgroups?

• A. High redundancy provides more usable storage.
• B. Normal redundancy provides more usable storage.
• C. High redundancy gives you better I/O performance.
• D. High redundancy provides High Availability (HA) during disk failure and rolling Storage Server patching
• E. Normal redundancy provides HA during rolling Storage Server patching.

Answer: BD

NEW QUESTION 3
Consider the following setup:
User A1 belongs to resource group High on Database A. User B2 belongs to resource group Low on Database B. User C3 is a user on Database C without any DBRM setup.
DBRM setup:
Database A: Resource group High gets 80% and Low gets 20%. Database B: Resource group High gets 60% and Low gets 40%.
IORM setup:
Database A: Share=20, limit=5 Database B: Share=30, limit=10 Database C: 5 shares
Total number of shares in the IORM setup = 100
What percent of I/O will each database user theoretically be using when the Exadata storage unit I/O throughout is used 100% and no other databases but A, B, and C are running?

• A. Al = 36%, B2=18%, and C3=9%
• B. Al = 33%, B2=33%, and C3=33%
• C. AI = 10%, B2=5%, and C3=20%
• D. Al = 8%, B2=12%, and C3=5%
• E. Al = 5%, B2=10%, and C3=85%

Answer: E

Explanation:
IORM setup limits Database A to 5%, and Database B is limited to 10%, while Database C has not IORM limit.
Not that the resource groups are for CPU allocation.

NEW QUESTION 4
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 5
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).

Answer: BCE

Explanation:
C: Exadata provides a way for you to create your own CELLBOOT USB. All you have to is plug-in a USB disk which should be at least 1 GB and run the tool:
$ /opt/oracle.SupportTools/make_cellboot_usb
Exadata turns your USB disk into a bootable disk of active image of your system.

NEW QUESTION 6
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 7
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 8
Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?

• A. database views
• B. InfiniBand networking
• C. Flash Cache
• D. high performance SAS2 disk drives
• E. cell offloading

Answer: C

Explanation:
The Exadata Smart Flash Cache feature of the Exadata Storage Server Software intelligently caches database objects in flash memory, replacing slow, mechanical I/O operations to disk with very rapid flash memory operations. .

NEW QUESTION 9
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 10
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 11
Which two statements describe correct network configuration for Exadata Database Machine?

• A. The InfiniBand network subnet manager runs on all database servers to achieve High Availability.
• B. Oracle Clusterware communication is configured to use the management network.
• C. The InfiniBand network interfaces on Linux servers are configured using active-passive bonding.
• D. Database connections to the SCAN listener route through the Ethernet switch in the Exadata rack.
• E. Database servers are deployed with three logical network interfaces configured: management, client access, and private.

Answer: CD

Explanation:
Incorrect:
Not A: The InfiniBand switches use an OpenSMInfiniBand subnet manager to manage the switch configuration.

NEW QUESTION 12
You are conceh is the best location to point your customer to, for finding the latest Exadata prned 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.

Answer: AC

Explanation:
A (not B, not E): Oracle automatically performs backups of the operating system and cell software on each Exadata Storage Server. The contents of the system volumes are automatically backed up and require no Oracle DMA intervention or operational processes. Oracle assumes responsibility for backing up the critical files of the storage cells to an internal USB drive called the CELLBOOT USB Flash Drive.
C:
Note: The ipconf utility is installed in /opt/oracle.cellos on both the Exadata Storage Servers and Compute Nodes and is symbolically linked to /usr/local/bin/ipconf. ipconf is called at system startup time to set and validate your Exadata server network information.

NEW QUESTION 13
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 (•cell physical IO bytes eligible for predicate offload',
•cell physical IO interconnect bytes',
•cell physical IO bytes saved by storage index',
•cell 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.

Answer: BC

Explanation:
* cell physical I/O bytes eligible for predicate offload Number of bytes eligible for predicate offload, an indication of smart scan
* (not D) cell physical I/O bytes saved by storage index Here 0.
Number of bytes saved by a storage index; this is a reflection of how many physical disk I/O bytes (and by proxy, requests) were saved due to a storage index eliminating candidate blocks

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

Answer: C

Explanation:
Steps for Enabling Write back flash cache:
First of all,you don’t need the stop CRS or database (This is ROLLING method) ,you can do it cell by cell.
* (C) drop flashcache
CellCLI> drop flashcache
Flash cache owtcel03_FLASHCACHE successfully dropped
* (G) Be sure asmdeactivationoutcome is YES is before disabling grid disk
</pre>
CellCLI> list griddisk attributes name,asmmodestatus,asmdeactivationoutcome
* (B)
CellCLI> alter griddisk all inactive

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

Answer: B

Explanation:
In earlier releases, database administrators had to mark an object as KEEP to have it cached in flash cache for large scan workloads. This feature primarily benefits table scan intensive workloads such as Data Warehouses and Data Marts. Random I/Os such as those performed for Online Transactional Processing (OLTP)
continue to be cached in the flash cache the same way as in earlier releases.
Note: With the Exadata Storage Server Software 11.2.3.3.0 and above, the Exadata Smart Flash Cache
software automatically caches objects read, in large table scans, in the flash cache based on how
frequently the objects are read. Previously, the default behavior was to bypass the flash cache for
such large sequential scans.

NEW QUESTION 16
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 17
When would be the best time to run an Exadata health check (exachk)?

• 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

Answer: D

Explanation:
#1: Check for updates frequently.
#2: Execute before & after system changes.
#3: Make part of regular planned maintenance

NEW QUESTION 18
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 19
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 20
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 21
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.

Answer: C

Explanation:
Parallelizing loads with external tables enables a more efficient space management
compared to SQL*Loader, where each individual parallel loader is an independent database sessions with its own transaction.

NEW QUESTION 22
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 23
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 24
Which table compression technique will not work on Exadata without licensing the Oracle Advanced Compression Option?

• A. COMPRESS
• B. COMPRESS BASIC
• C. COMPRESS FOR OLTP
• D. COMPRESS FOR QUERY
• E. COMPRESS FOR ARCHIVE

Answer: C

Explanation:
OLTP Table Compression is a part of the Oracle Advanced Compression option, which requires a license in addition to the Enterprise Edition.

NEW QUESTION 25
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 26
......