NEW QUESTION 1
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 2
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 3
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

Answer: ACDG

NEW QUESTION 4
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 5
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 6
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 7
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 8
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 9
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 10
When should you use Hybrid Columnar Compression?

• A. always
• B. on large active tables where deeper compression is desired
• C. on tables or partitions that have fairly static data
• D. on every table where Advanced Compression is not used

Answer: C

Explanation: It is recommended that HCC be enabled on tables or partitions with no or infrequent DML operations

NEW QUESTION 11
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 12
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 13
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 14
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 15
High-disk IOPS (I/Os per second) rates are leading to longer execution times. Which three approaches would you use to improve this scenario?

• A. Enable Write-Back Flash Cache due to heavy DBWR usage.
• B. Enable Write-Back Flash Cache due to heavy LGWR usage.
• C. Swap hard disks to High Capacity disks.
• D. Tune the application to reduce I/O requests.
• E. Leverage IORM to give priority to critical workloads.

Answer: BDE

Explanation: B (not A): Smart Flash Logging is a recent Exadata enhancement that provides physical disk redo write relief in times of high LGWR activity; alone, probably not a driver for Exadata.

NEW QUESTION 16
Consider the following software changes that are performed manually on a Linux server:
1. Changes for Linux kernel firewall configuration
2. Changes for custom performance monitoring tools
3. Changes for security scan tools
4. Changes for Linux system performance optimization
Which of the software changes listed are permitted on Exadata Storage Servers?

• A. 1, 2, 3, and 4
• B. only 3 '
• C. none
• D. only 2
• E. only 1 and 2
• F. only 2 and 3

Answer: E

Explanation: 1: The Storage Server Patch is responsible for keeping our cell nodes always up-to-date, fixing possible problems, and this patch includes different component patches, like kernel patches, firmware, operation system, etc… for the Storage Server.
Incorrect:
3,4: security scan tools changes and Linux system performance optimization changes would be on the database server.

NEW QUESTION 17
Which two statements are true about enabling write-back flash cache?

• A. When enabling write-back flash cache in a non rolling manner, it is important to ensure that asmdeactivatonoutcome is set to YES and asmModestatus is set to ONLINE for all grid disks.
• B. Before using write-back flash cache, you need to verify the minimum required versions.
• C. Before write back-flash cache is enabled, you need to drop the Flash Cache first.
• D. The setting flashCacheMode should be set to writeback by updating cellinit.ora and restarting cellsrv.
• E. When enabling write-back flash cache in a rolling manner, dcli should be used to inactivate the grid disks on all cells first.

Answer: BC

Explanation: B: Exadata storage version 11.2.3.2.1 is the minimum version required to use this write back flash cache option.
C: 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.
* drop flashcache
* Be sure asmdeactivationoutcome is YES is before disabling grid disk