NEW QUESTION 1
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 2
What are the three customer options for hosting the Platinum Services Advanced Support Gateway?

• A. Install on Exadata Engineered System.
• B. Provide individual x86 64-Bit gateway hardware.
• C. Install in Oracle Virtual Machine with required hardware.
• D. Install on Oracle Database Appliance.
• E. Purchase the recommended x86 64-Bit gateway hardware from Oracle.

Answer: ACE

Explanation:
Oracle provides a flexible model for deployment of the Oracle Advanced Support Gateway via no charge software that can be
installed in three configurations:
1. On x86 customer provided servers;
2. On x86 servers purchased from Oracle;
3. Installed on Oracle Exalogic Elastic Cloud or Oracle SuperCluster systems.
Note:
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 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 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 5
You are calculating the storage capacity that your customer will require on their ZFS Backup Appliance. Identify the set of factors that will affect this calculation.

• A. database size, full/incremental cycle, RPO (Recovery Point Objective), and RTO (Recovery Time Objective)
• B. database size, retention period, RPO (Recovery Point Objective), and compression
• C. database size, full/incremental cycle, compression, and retention period
• D. database size, compression, and backup window
• E. full/incremental cycle, retention period, and ZFS Backup Appliance model

Answer: C

Explanation:
Note: The Sun ZFS Backup
Appliance has extremely fast backup and restore throughputs, ensuring that backup windows
and recovery time objectives (RTOs) are met by providing timely recovery in the event of a disaster
Incorrect:
Not A, Not E: compression is a factor

NEW QUESTION 6
Exadata Database Machine offers an Intelligent Platform Management Interface for the various components in the Exadata product. Which option is true?

• A. IPMI can be used to remotely start and stop servers.
• B. IPMI can be used to remotely log in to the operating system.
• C. IPMI commands can be executed by using SNMP traps.
• D. IPMI settings can be secured by backing up the Oracle Linux installation on the storage system.

Answer: A

Explanation:
IPMI – short for Intelligent Platform Management Interface - is an interface standard that allows remote management of a server from another using standardized interface. The servers in the Exadata Database Machine follow that. It’s not an Exadata command but rather a general Linux one.
To power on a cell or database server, issue this from another server:
# ipmitool -H prolcel01-ilom -U root chassis power on
To stop a server, use the shutdown command. To stop immediately and keep it down, i.e. not reboot, execute:# shutdown -h -y now

NEW QUESTION 7
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 8
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 9
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 10
Which two statements are true about troubleshooting failed patching activities?

• A. Dependency issues found during yum updates require rolling back to a previous release before retrying.
• B. Bundle patches applied using opatch auto cannot roll back only the database or the grid infrastructure home.
• C. Failed OS patches on database servers can be rolled back.
• D. Failed storage cell patches are rolled back to the previous release automatically.
• E. Database server OS updates can be rolled back using opatch auto -rollback.
• F. Dependency issues found during yum updates should be ignored using the force option.

Answer: AE

Explanation:
* Oracle has shifted the strategy to patching the exadata in 11.2.3.2.0 onwards to using Yum as the method of patching.
* Database servers are patched using yum; there is a yum channel for each Exadata image version. Recently, this functionality replaced the “minimal pack.”
* In the README for each storage server patch, Oracle provides detailed rollback instructions that are to be followed in the event of a patch failure.

NEW QUESTION 11
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 12
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 13
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 14
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 15
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 16
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 17
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 18
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 19
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 20
Which statement is true about instance caging setup?

• A. Instance caging is the right approach to make sure that database instances are not stealing memory from each other.
• B. The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.
• C. Database instances need to be restarted to make changes to cpu_count effective.
• D. For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to prevent oversubscribing
• E. The init.org parameter resource_manager_plan should be set.

Answer: D

Explanation:
* In 11.2G there is new option called “Instance Caging” which enables to limit number of CPUs which can be seen/used by a database.
* Enabling Instance Caging
1. Manually set dynamic parameter cpu_count on instance level. As default this parameter is set to maximum number of cpu available on a hosts.
alter system set cpu_count=2;
2. Enable any resource manager plan that manages CPU. Most easy is to turn on default Oracle plan DEFAULT_PLAN.
alter system set resource_manager_plan=DEFAULT_PLAN;
* Provisioning CPU
There are generally 2 ways to distribute your CPU between databases
Partitioning – sum of all CPUs assigned to all your databases equals number of CPUs on a host. Databases don’t interfere with each other.
Over-provisioning – sum of all CPUs assigned to all your databases is higher that number of CPUs on a host. Databases can impact on each other performance.

NEW QUESTION 21
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 22
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?

Answer: AB

Explanation:
B: There are a number of ASM disk group attributes that you can set when creating your disk groups, but the following
are the most important:
* (B) compatible.rdms: Set this to the software version of your RDBMS home.
* au_size: Set this to 4 MB.
* compatible.asm: Set this to the software version of your Grid Infrastructure home.
* cell.smart_scan_capable: Set this to TRUE. If this attribute is set to FALSE, Smart Scan will be
disabled to segments that reside in the disk group.
* disk_repair_time: Leave this defaulted to 3.6 hours unless you’re performing maintenance on a call and know that your outage window will be greater than 3.6 hours.
A:
Once you identify candidate grid disks, use the CREATE DISKGROUP command to create your ASM disk groups.
Here are some of the more important considerations to think about when creating ASM disk groups on Exadata:
* (A) When capacity planning, take your redundancy specification into consideration.
Normal
redundancy will have the effect of reducing your usable storage to half the raw capacity, and
high redundancy will shrink it to a third of your raw disk capacity.
* Simplicity is best on Exadata. Using wild-carded CREATE DISKGROUP syntax not only offers the most terse command syntax, but also ensures your ASM disk groups are spread evenly across your Exadata Storage Server disks.
* Take the time to plan grid disk prefix names and overall grid disk configuration in the context
of your desired ASM disk group design.
* Make sure to set the appropriate compatible.asm and compatible.rdbms attributes when creating ASM disk groups.
* Whenever possible, use a 4 MB extent size when creating disk groups on ASM storage.

NEW QUESTION 23
......