NEW QUESTION 1
Which three must be true for Smart Scans to be done?

• A. Executing a query in parallel
• B. Setting _serial_direct_read=true in the session issuing the SQL statements
• C. Having direct path reads used at run time
• D. Having a 4 meg AU size for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored
• E. Cell_offload_process = true for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored.
• F. cell.smart_scan_capable=true for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored.

Answer: BCF

NEW QUESTION 2
In which two locations should files be staged, to be loaded using external tables into a database on a Database Machine?

• A. On a dbfs file system stored in a staging database on the Database Machine
• B. On an Exadata-based ACFS file system on the Database Machine
• C. On an nfs file system mounted on a database server where the external table will be accessed.
• D. On local storage on one or more cells that are accessible to the database server where the load will be performed.

Answer: AC

Explanation:
Reference: Installing Oracle E-Business Suite Release 12 with the Oracle Exadata Database Machine

NEW QUESTION 3
Which four statements are true about Exadata Smart Flash Cache?

• A. Smart Scan will always be done for I/Os to flash based griddisks.
• B. Flash based ASM diskgroups may share space with the Flash Cache on the flashdisks.
• C. Single block reads can benefit from Smart Flash Cache.
• D. Smart Scan will never be done for I/Os to flash based griddisks.
• E. Multiblock reads can benefit from Smart Flash Cache.
• F. Smart Flash Logs reduce the size of Smart Flash Cache.

Answer: BCEF

Explanation:
B: * Grid disks (the logical disks
that reside on physical cell disks) are created on these flash-based cell disks and the grid disks are assigned to an Automatic Storage Management (ASM) diskgroup. The best practice would be to reserve the same amount of flash on each Exadata cell for flash disks and have the ASM
diskgroup spread evenly across the Exadata cells in the configuration just as you would do for
regular Exadata grid disks. This will evenly distribute the flash I/O load across the Exadata cells
and flash.
Note:
* The Exadata
Storage Server comes with a substantial amount of flash storage. A small amount is allocated for
database logging and the remainder will be used for caching user data

NEW QUESTION 4
Yesterday, an Exadata storage server flashdisk entered the poor performance state.
This flashdisk os used by flashcache and has a griddisk which is a member of a normal redundancy diskgroup.
Identify the six steps you must perform to replace flashdisk.

• A. Identify the griddisk located on the poorly performing flashdisk and drop it from the associated ASm diskgroup.
• B. Verify that the griddisk located on the poorly performing flashdisk has been successfully dropped from the associated ASM diskgroup.
• C. Drop the flashcache on all cell.
• D. Safely power off the cell containing the poorly-performing flashdisk.
• E. Replace the poorly performing flashdisk.
• F. Power up the cell containing the replaced flashdisk and activate all griddisks.
• G. Recreate the flashcache on the cell using all flashdisks.
• H. Create a new griddisk on the replaced flashdisk.
• I. Add the griddisk back into the ASM diskgroup to which it belonged.

Answer: ADEFHI

Explanation:
Note:
* The default way to deal with the Flash Storage is to use it completely as Flash Cache. You may think of Flash Cache as a prolongation of the Database Buffer Cache. It is populated automatically by the system with objects deemed useful to cache them.
* The second possibility to deal with the Flash Storage is to take a part of it for building ASM diskgroups upon. All files on these ASM diskgroups will then reside permanently on Flash Storage:
CellCLI> drop flashcache
Flash cache exa5cel01_FLASHCACHE successfully dropped
CellCLI> create flashcache all size=100g
Flash cache exa5cel01_FLASHCACHE successfully created CellCLI> create griddisk all flashdisk prefix=flashdrive

NEW QUESTION 5
Which type of network traffic is transported over the internal InfiniBand network in a Database Machine?

• A. IDB protocol traffic only
• B. Both Clustered ASM and RAC database instance traffic
• C. Clustered ASM Instance traffic only
• D. RAC database instance traffic only
• E. IDB protocol traffic, Clustered ASM traffic, and RAC database instance traffic

Answer: E

NEW QUESTION 6
Which three factors should you consider when choosing a method for migrating a database to the Database Machine?

• A. Type of database workload
• B. Number of tablespaces in the source database
• C. Size of the source database
• D. Endian format of the source database
• E. ASM attributes and allocation unit (AU) size of the diskgroups used by the source database

Answer: ACD

Explanation:
A: Use Real Production Workload
– Real Application Testing (RAT)
• Database Workload Replay
• SQL Performance Analyzer (SPA)
D:
* Endian format: Non-Exadata format
Reference: Exadata MAA Best Practices, Migrating Oracle Databases

NEW QUESTION 7
Which three are true about Exadata storage server alerts?

• A. A threshold based alert gets cleared automatically when the measured value no longer violates the threshold.
• B. A storage server alert is only ever issued as a warning or at a critical situation.
• C. Storage server alerts are all stateless alerts.
• D. Storage server alerts notifications may be sent using SNMP.
• E. Storage server alerts are all stateful alerts.
• F. Storage server alerts notifications may be sent using SMTP.

Answer: ABD

Explanation:
Incorrect:
Not C, Not E: there are both stateful and stateless alerts

NEW QUESTION 8
Which two are true about Smart Scan?

• A. a query rewrite may occur to a container table stored in Exadata but will never benefit From Smart scan.
• B. Column projection does not contribute to the performance benefit of Smart Scan
• C. It is possible to offload single row functions to the storage servers.
• D. Some joins can be offloaded to the storage servers.
• E. A query rewrite may occur to a container table stored Exadata, and it will always benefit from Smart Scan.
• F. All joins can be offloaded to the storage servers.

Answer: CD

Explanation:
C: With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.
D (not F):
* Exadata performs joins between large tables and small lookup tables, a very common scenario for data warehouses with star schemas. Joining large tables and small lookup tables is implemented using Bloom Filters, which are a very efficient probabilistic method to determine whether a row is a member of the desired result set.
* If storage indexes are so great, why doesn’t Oracle Exadata use them all the time? The short answer is that they are created and used only when they will be beneficial.
* To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes. Applications with queries that include predicates and perform a lot of full table scans or fast full scans of indexes—typically those used in data warehousing environments—will benefit greatly from storage indexes. Online
* transaction processing (OLTP) applications, on the other hand, typically access a small number of rows through standard indexes and do not perform full table scans, so they may not benefit from storage indexes.
Note:
* Storage indexes reside in the memory of the storage servers—also called storage cells—and significantly reduce unnecessary I/O by excluding irrelevant database blocks in the storage cells.
* To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes.
Incorrect:
Not B: Exadata provides column filtering, also called column projection, for table scans. Only the columns requested are returned to the database server rather than all columns in a table. For example, when the following SQL is issued, only the employee_name and employee_number columns are returned from Exadata to the database kernel.
SELECT employee_name, employee_number FROM employee_table.
For tables with many columns, or columns containing LOBs (Large Objects), the I/O bandwidth saved can be very large. Using both predicate and column filtering dramatically improves performance and reduces I/O bandwidth consumption. In addition, column filtering also applies to indexes, allowing for even faster query performance.
Reference: Oracle Communications Data Model Implementation and Operations Guide, Exadata Smart Scan Processing and Storage Index

NEW QUESTION 9
Which two statements are true about the IPTables firewall configuration on a Database Machine- Machine after the default Initial deployment?

• A. IPTables is configured with Oracle supplied rules on the cells.
• B. IPTables is configured with Oracle supplied rules on the database servers.
• C. IPTables is installed and available but not configured on any servers.
• D. IPTables is installed and available but not configured on the database servers.
• E. IPTables is installed and available but not configured on the cells.

Answer: AD

NEW QUESTION 10
Which three are true about Smart Flash log?

• A. I/O Resource Manager database plans can be used to enable or disable Smart Flash Log for different databases.
• B. LGWR will not wait for writes to Smart Flash log if the write to a disk based log file completes first.
• C. Smart Flash Log is enabled by default, using 1024 MB of Rash storage on each storage server.
• D. You can remove Smart Flash Log from a single storage server with the drop flashing command.
• E. I/O Manager category plans can be used to enable or disable Smart Flash Log For different I/O categories.

Answer: ABD

Explanation:
A: the Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine.
B: Smart Flash Logging works as follows. When receiving a redo log write request, Exadata will do
parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash
hardware. When either of these writes has successfully completed the database will be immediately notified of completion. If the disk drives hosting the logs experience slow response
times, then the Exadata Smart Flash Cache will provide a faster log write response time. Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times
(e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time.
This algorithm will significantly smooth out redo write response times and provide overall better
database performance.
D: Category plans are configured and enabled using the CellCLI utility on the cell. Only one category plan can be enabled at a time
Incorrect:
Not C: By default, 512 MB of the Exadata flash is allocated to Smart Flash Logging

NEW QUESTION 11
Which three storage components are available after the standard initial Database machine deployment?

• A. The DATA_<DBM_Name> ASM diskgroup
• B. The RECO_<DBM_Name> ASM diskgroup
• C. Mirrored system partitions on hard disk 0 and hard disk 1
• D. The DBFS_DG diskgroup with external redundancy
• E. Exadata Smart Flash Cache using all of the flashdisk space

Answer: ABC

NEW QUESTION 12
Which three are among the software components that constitute the QoS Management framework?

• A. Cluster Health Monitor (CHM)
• B. Cluster Verification Utility (CLUVFY)
• C. O/S Resource Manager
• D. Grid Infrastructure for a standalone server
• E. Grid Infrastructure for a cluster
• F. OC4J cluster resource

Answer: AEF

Explanation:
A: In conjunction with Cluster Health Monitor, QoS Management’s Memory Guard detects nodes that are at risk of failure due to
memory over-commitment. It responds by automatically preventing new connections thus preserving existing workloads and restores connectivity once the sufficient memory is again available.
F: The ora.oc4j is for the QoS (Quality of Service Management), which is only available on
Exadata.
Incorrect:
Not B: The Cluster Verification Utility (CVU) performs system checks in preparation for installation, patch updates, or other system changes. Using CVU ensures that you have completed the required system configuration and preinstallation steps so that your Oracle grid infrastructure or Oracle Real Application Clusters (Oracle RAC) installation, update, or patch operation completes successfully.

NEW QUESTION 13
Your customer wants you to partition the database and storage grids in his X3-2 full rack, creating database clusters and two storage grids.
One cluster will be used for production and should consist of 6 databases servers and 11 cells from the first storage grid.
The other cluster will be used for test and development, and should consist of 2 database servers and 3 cells from the second storage grid.
The storage must be partitioned so that the cells are visible only to the appropriate database servers based on the description above.
What must be done to achieve this?

• A. Configure Exadata realms using Oracle ASM scoped security mode.
• B. Configure Exadata realms using Database scoped security mode.
• C. Edit the CELLIP.ORA file on each database server to contain IP addresses of cells in the storage grid associated with cluster to which that database server belongs.
• D. Edit the CELLINIT.ORA file on each database server to contain IP addresses of cells in the storage grid associated with the cluster to which that database server belongs.
• E. Edit the CELLIP.ORA file on each database server to contain IP addresses of database servers which are allowed access to specific cells in the same storage grid.
• F. Edit the CELLIP.ORA file on each cell to contain IP addresses of database servers in the database server grid that are associated with the storage grid to which that cell belongs.

Answer: C

Explanation:
cellip.ora
The cellip.ora is the configuration file, on every compute node, that tells ASM instances which cells are available to this cluster.
Here is a content of a typical cellip.ora file for a quarter rack system:
$ cat /etc/oracle/cell/network-config/cellip.ora cell="192.168.10.3"
cell="192.168.10.4" cell="192.168.10.5"
Now that we see what is in the cellip.ora, the grid disk path, in the examples above, should make more sense.
Note:
* cellinit.ora decides which network takes storage traffic.
* cellip.ora - list of cells, new cells can be added dynamically without shutdown

NEW QUESTION 14
Identify the correct sequence of commands to completely power off a Database Machine in an Orderly fashion:
1. Execute “crsctl stop cluster –all” as the grid user from one database server.
2. Execute “crsctl stop cluster –all” as the root user from one database server.
3. Power off all network switches using their power switch.
4. Execute “crsctl stop cluster –all” as the root user from one database server.
5. Execute “crsctl stop cluster –all” as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute “shutdown –h now” on all database servers.
8. Execute “shutdown –h now” on all Exadata storage servers.
1. 9. Execute “shutdown –h now” on all servers.

• A. 1, 9, 3 and 6
• B. 2, 9 and 6
• C. 4, 7, 8, 3 and 6
• D. 5, 8, 7, 3 and 6
• E. 2, 8, 7, 3 and 6
• F. 1, 8, 7, 3 and 6
• G. 2, 7, 8 and 6
• H. 2, 8, 7 and 6

Answer: G

NEW QUESTION 15
Which three are true regarding the use of Storage Indexes?

• A. Different storage regions may have different columns indexed for the same table.
• B. A Storage index is automatically maintained by CELLSRV based on the filter columns of the offload SQL.
• C. The use of Storage indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan.
• D. Storage Indexes occupy space in the Smart Flash Cache.
• E. The use of Storage Indexes for particular categories of I/O can be disabled by using an I/O Resource Manager Category Plan.
• F. A maximum of eight table columns for any table are Indexed per storage region.

Answer: ABF

Explanation:
Note:
* Storage indexes are used during smart scans. All the limitations to smart scans apply to storage indexes. They do not work with joins. Bind variables are supported, however it’s slightly more restrictive than regular indexes/queries.
* The storage index is stored in the memory on each of the Exadata storage cells and is created and maintained transparently. However, if a storage cell is shutdown or rebooted the storage index will be lost from memory and will be recreated on subsequent accesses to the data after the cell has been brought back online.
* Storage Indexes are a very powerful capability provided in Exadata storage that helps avoid I/O operations. The Exadata Storage Server Software creates and maintains a Storage Index (that is, metadata about the database objects) in the Exadata cell. The Storage Index keeps track of minimum and maximum values of columns for tables stored on that cell. When a query specifies a WHERE clause, but before any I/O is done, the Exadata software examines the Storage Index to determine if rows with the specified column value exist in the cell by comparing the column value to the minimum and maximum values maintained in the Storage Index. If the column value is outside the minimum and maximum range, scan I/O for that query is avoided. Many SQL Operations run dramatically faster because large numbers of I/O operations are automatically replaced by a few lookups. To minimize operational overhead, Storage Indexes are created and maintained transparently and automatically by the Exadata Storage Server Software.

NEW QUESTION 16
You have two very large databases supporting OLTP workloads which run on multiple small-blade style servers in a cluster and which require optimal latency for I/O.
You plan to migrate them to a Database Machine once a capacity planning exercise is finished.
The database backup strategy requires that backups are written directly to media.
High availability requirements state that you must be able to survive node failures at any time.
Which three Database Machine components or features would you recommend to support these requirements?

• A. Use of write back flash cache
• B. Use of smart flash logs
• C. High capacity disks in the Database Machine
• D. High performance disks in the Database Machine
• E. A high capacity expansion full rack
• F. A high performance expansion full rack

Answer: ABC

NEW QUESTION 17
Consider the following list of software components:
1. DCLI
2. Management Server (MS)
3. ASM Instance
4. RDBMS instance
5. Restart Server (RS)
6. Cellcli
7. Cell Server (CELLSRV)
8. Diskmon
Identify the location where these software components may run in the standard Database machine deployment.

• A. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 9 run on the Exadata Storage servers.
• B. 4 and 8 run on the database servers; 1, 2, 3, 5, 6 and 7 run on the Exadata Storage servers.
• C. 1, 3 and 4 run on the database servers; 2, 5, 6, 7 and 8 run on the Exadata Storage servers.
• D. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata Storage servers.
• E. 3, 4 and 8 run on the database servers; 1, 2, 5, 7 and 8 run on the Exadata Storage servers.
• F. 1, 3, 4 and 8 run on the database servers; 1, 2, 5, 7 and 8 run on the Exadata Storage servers.

Answer: D

NEW QUESTION 18
Which three statements are true about the initial storage configuration after the standard deployment of a new database Machine?

• A. The Data_<DBM_Name> and RECO_<DBM_Name> ASM diskgroups are built on part of the interleaved griddisks.
• B. The Data_<DBM_Name> and RECO_<DBM_Name> ASM diskgroups are built on top of the non-interleaved griddisks.
• C. There is a free space available on the hard disks inside the database servers for possible extension of the /u01 file system.
• D. There is no free disk space available on the hard disk inside the database servers for possible extensions of the /u01 file system.
• E. There is free space available on the flashdisk inside the Exadata storage servers for possible use as flash-based griddisks.
• F. There is no free disk available on the flashdisk inside the Exadata storage servers for possible use as flash-based griddisks.

Answer: BCF

Explanation:
B( not A): Griddisks are the fourth layer of abstraction, and they will be the Candidate Disks to build your ASM diskgroups from. By default (interleaving=none on the Celldisk layer), the first Griddisk that is created upon a Celldisk is placed on the outer sectors of the underlying Harddisk. It will have the best performance therefore. If we follow the recommendations, we will create 3 Diskgroups upon our Griddisks: DATA, RECO and SYSTEMDG.
Note:
* non-root partition (/u01).
* Oracle Database files: DATA disk group.
* Flashback log files, archived redo files, and backup files: RECO disk group.

NEW QUESTION 19
Which two statements are true about the use of direct path loads when selecting from external tables in a database on a Database Machine?

• A. INSERT INTO . . . SELECT FROM statements, executed serially, which select from external tables, require the APPEND hint to use direct path loading.
• B. CREATE TABLE . . . AS SELECT statements, which select from external tables, attempt to use in direct path loading automatically.
• C. CREATE TABLE . . . AS SELECT statements, which select from external tables, require the APPEND hint to use direct path loading.
• D. INSERT INTO . . . SELECT FROM statements, executed serially, which select from external tables, are unable to use direct path loading.

Answer: AB

Explanation:
A CTAS (Create table as select) will always use direct path (B, not C) load but IAS (Insert as select) statement will not. In order to achieve direct path load with an IAS statement you must add the APPEND hint to the command (A, not D).
Direct path loads can also run in parallel. You can set the parallel degree for a direct path load
either by adding the PARALLEL hint to the CTAS or IAS statement or by setting the
PARALLEL clause on both the external table and the table into which the data will be loaded.
Once the parallel degree has been set at CTAS will automatically do direct path load in parallel
but an IAS will not. In order to enable an IAS to do direct path load in parallel you must alter the session to enable parallel DML.
Note:
* Parallel Direct Path Load
The key to good load performance is to use direct path loads wherever possible. A direct path
load parses the input data according to the description given in the external table definition,
converts the data for each input field to its corresponding Oracle data type, then builds a column
array structure for the data. These column array structures are used to format Oracle data blocks
and build index keys. The newly formatted database blocks are then written directly to the database, bypassing the standard SQL processing engine and the database buffer cache.
Reference: Best Practices for Implementing a Data Warehouse on the Oracle Exadata Database Machine; Using CTAS & Exchange Partition Replace IAS for Copying Partition on Exadata

NEW QUESTION 20
You plan to migrate a database supporting an an OLTP workload to your Database Machine
This is part of a consolidation project and several other databases already exist on the Database Machine.
Which three Exadata features may help to improve the performance of this OLTP workload?

• A. Hybrid Columnar Compression
• B. I/O Resource Manager
• C. Smart Flash Cache
• D. Smart Flash Log
• E. Smart Scan
• F. Storage Index

Answer: BCD

Explanation:
C:
OLTP performance benefits with Exadata
/ (D) Smart flash log for low latency commits
/ (C) Smart flash cache for low latency reads. KEEP in Flash for critical objects

NEW QUESTION 21
......