1Z0-027 Exam - Oracle Exadata Database Machine Administration, Software Release 11.x

NEW QUESTION 1
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 2
Identify three valid configuration options that can be implemented during the initial configuration process of a new Database Machine by using the Exadata Deployment Assistant

• A. database character set
• B. size of the RECO ASM diskgroup
• C. size of the DBFS diskgroup
• D. O/S owner mode (standard O/S authentication or role-separated O/S authentication)
• E. RDBMS DBA group name

Answer: BDE

Explanation:
D: Determine which OS owner mode to use

NEW QUESTION 3
You plan to monitor storage servers after configuring an I/O resource manager plan with directives for inter-database plans and intra-database plans.
Which two types if metrics would help assess the impact of the intra-database plans on I/O to the storage servers?

• A. Category I/O
• B. Database I/O
• C. Resource Consumer Group I/O
• D. Smart Flash Log I/O
• E. Smart Flash Cache I/O

Answer: BC

Explanation:
B: Database metrics provide information about the size of the I/O load from each database specified in the interdatabase plan.
C: Consumer group metrics provide information about the size of the I/O load from each consumer group specified in a database resource plan. Each database in the interdatabase plan has metrics for each of its consumer groups.
Note:
* I/O Resource Manager (IROM) Settings
* Incorrect:
Not A: Category metrics provide information about the size of the I/O load from each category specified in the current IORM category plan.

NEW QUESTION 4
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 5
Your Database Machine has a large database with some very large tables supporting OLTP workloads.
High volume Insert applications and high volume update workloads access the same tables.
You decide to compress these tables without causing unacceptable performance overheads to the OLTP application.
Which three are true regarding this requirement?

• A. Using 'compress for oltp' will compress the data less than if using Hybrid Columnar Compression when specified with compress for query low.
• B. The compression is performed on the storage servers when using compress for oltp in an Exadata environment.
• C. The compression method compress for archive high is the worst fit for this requirement.
• D. Using 'compress for oltp' will compress the data more than if using Hybrid Columnar Compression when specified with compress for archive low.
• E. The compression is performed on the database servers when using 'compress for oltp' in an Exadata environment.

Answer: ACE

Explanation:
Note:
(E not B):
* Types of compression
Basic compression OLTP compression Warehouse compression
Online archival compressio
*
/ OLTP compression allows compression during DML operations.
/ Basic compression works at the data block level.
* When you enable table compression by specifying COMPRESS FOR OLTP, you enable OLTP table compression. Oracle Database compresses data during all DML operations on the table. This form of compression is recommended for OLTP environments.
* When you specify COMPRESS FOR QUERY or COMPRESS FOR ARCHIVE, you enable hybrid columnar compression. With hybrid columnar compression, data can be compressed during bulk load operations. During the load process, data is transformed into a column-oriented format and then compressed. Oracle Database uses a compression algorithm appropriate for the level you specify. In general, the higher the level, the greater the compression ratio.
Hybrid columnar compression can result in higher compression ratios, at a greater CPU cost. Therefore, this form of compression is recommended for data that is not frequently updated.

NEW QUESTION 6
You plan to migrate your Oracle Version 11.1.0.2 database to your Exadata Database Machine.
The database supports an online transaction processing (OLTP) workload and is currently hosted on a Little Endian platform
Which two are the supported and appropriate migration methods to minimize downtime?

• A. Upgrade source database to 11.2.0 and migrate using a physical standby database.
• B. Migrate using Data Pump.
• C. Migrate using GoldenGate.
• D. Migrate using cross platform Transportable Database.
• E. Migrate using ASM online migration.

Answer: AB

Explanation:
Reference: Migrating the Oracle E-Business Suite Database to Oracle Exadata Database Machine Using Transportable Tablespaces
Reference: Migrating Oracle E-Business Suite to Oracle Exadata Database Machine Using Oracle Data Pump

NEW QUESTION 7
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 8
Which two are regarding the case of storage indexes?

• A. To increase the chance of using the a storage index, you can make table indexes invisible.
• B. To maximize the benefit of storage Indexes, load your data stored on the filtered columns.
• C. The cell physical 10 bytes saved by storage index statistic returns multiple rows, one for each storage server.
• D. Storage indexes are retained after a cell is rebooted.
• E. Avoid the use of bind variables because Storage Indexes do not work with bind variables.

Answer: AB

Explanation:
To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes.
* 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.

NEW QUESTION 9
You have altered an index supporting a constraint to be invisible on a large read only data warehouse table, to determine it Smart Scan operations will be fast enough to satisfy your performance requirements.
Given the results of your testing, you consider dropping the index.
Which two statements are true?

• A. You must retain the index and set the constraint to DISABLE NOVALIDATE RELY to enforce the constraint
• B. You may drop the index and use a constraint with the DISABLE NOVALIDATE RELY flags
• C. You must retain the index and make it visible again for the constraint to be enforced.
• D. You may drop the index and make the constraint invisible, because this is enough for the constraint to be enforced.
• E. You may retain the index, and leave it as invisible, because this is enough for the constraint to be recognized.

Answer: AC

Explanation:
Note:
* You may have noticed that we introduced Invisible Indexes as an 11g New Feature. Their main benefit is that we can test whether performance differs if we would drop an index without actually dropping it. This is particular useful after an Exadata Migration because we expect that some conventional indexes migrated are now obsolete and may be substituted by Storage Indexes.
* With making indexes invisible, we can easily check whether indexes are useful without having to drop (and in case recreate) them actually. While this may be of interest for “ordinary” Oracle Databases already, it is particular a useful feature for Exadata where we expect some conventional indexes to become obsolete after a migration.
* DISABLE NOVALIDATE RELY means: "I don't want an index and constaraint checking to slow down my batch data loading into datawarehouse, but the optimizer can RELY on my data loading routine and assume this constraint is enforced by other mechanism". This information can greatly help optimizer to use correct materialized view when rewriting queries. So if you don't use materialized views for query rewrite then you can put RELY for all your constraints (or NORELY for all your constraits) and forget about it.

NEW QUESTION 10
Which three are true abort Enterprise Manager plug- in configuration for the Database Machine?

• A. There are several separate plug-ins for Grid Control.
• B. There is one plug-in for Cloud Control.
• C. There are several separate plug-ins for Cloud Control.
• D. Some plug-ins require SNMP trap forwarders.
• E. All plug-ins require SNMP trap forwarders.
• F. There is one plug-in for Grid Control.

Answer: ACD

NEW QUESTION 11
You have a partitioned database grid on an X3-2 full rack with two four-node RAC clusters called CLUSA and CLUSB. The storage grid, however, has not been partitioned.
Which files on which servers must be modified after connecting an Exadata storage full expansion rack to your X3-2 Exadata Database Machine on the InfiniBand network so that the cells on the expansion rack are added to the storage grid?

• A. The CELLINIT.ORA files on database servers in CLUSA
• B. The CELLIP.ORA files on the database servers in CLUSA
• C. The CELLINIT.ORA files on the database servers in CLUSB
• D. The CELLIP.ORA files on all existing and newly added Exadata storage servers.
• E. The CELLIP.ORA files on the database servers in CLUSB

Answer: BE

Explanation:
Note:
* cellinit.ora, cellip.ora
-- on database server
cellinit.ora - identifies the storage network interface on the database server cat /etc/oracle/cell/network-config/cellinit.ora
cellip.ora - identifies the Exadata cells that are accessible to the database server cat /etc/oracle/cell/network-config/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"

NEW QUESTION 12
You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) for your Database machine and its assets.
Which three statements are true about this configuration?

• A. When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).
• B. Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to ASR Manager.
• C. When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS.
• D. Simple network Management Protocol (SNMP) traps are used to send notification from Enterprise manager to ASR Manager.
• E. Simple Network Management Protocol (SNMP) traps are used to send notifications from database servers to ASR Manager.
• F. Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to Enterprise Manager.

Answer: ABE

Explanation:
To configure fault telemetry, choose one of the following three options:
Add SNMP Trap Destinations Using OneCommand (recommended for new installations) Add SNMP Trap Destinations for Multiple Servers Using the dcli Utility
Add SNMP Trap Destinations for a Single Server

NEW QUESTION 13
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 14
Which two may act as building blocks for the creation of two or more griddisks residing on the same physical device and which have more balanced performance characteristics?

• A. griddisk on hard drive-based intervleaved celldisks.
• B. griddisk on hard drive-based celldisks consumed by ASM when creating diskgroups using ASM-based intelligent Data Placement (IDP)
• C. griddisk on hard drive-based non-interleaved celldisks.
• D. griddisk on Flash-base celldisks.

Answer: AD

Explanation:
Interleaved Griddisks mean equally fast Griddisks, whereas with non Interleaved Griddisks (the default) the Griddisks created first are being taken from the outer tracks of the underlying physical disk.

NEW QUESTION 15
Last weekend, an Exadata storage server flashdisk entered the predictive failure state.
The flashdisk is used by the flashcache and has a griddisk which is a member of a normal redundancy diskgroup.
Identify the four steps you must perform to replace this flashdisk.

• A. Identify the griddisk on the predictive failure flashdisk and drop it from the associated ASM diskgroup
• B. Verify that the griddisk located on the predictive failure flashdisk has been successfully dropped from the associated ASM diskgroup.
• C. Drop the flashcache on the cell and re-create it using all but the predictive failure flashdisk.
• D. Safely power off the cell containing the predictive failure flashdlsk.
• E. Replace the predictive failure flashdisk.
• F. Power up the cell containing the replaced flashdlsk and activate all grlddlsks.
• G. Drop the flashcache on the cell and re-create it using all flashdlsks.
• H. Create a new griddisk on the replaced flashdisk.
• I. Add the griddisk back into the ASM diskgroup to which it belonged.

Answer: ADEF

NEW QUESTION 16
You are examining the existing IORM configuration on the cells of Database Machine, to see if they require my modifications based on recent changes to various workloads.
All seven cells in your X3-2 half-rack shown the following:

Which two are true about I/O to the cells using this plan?

• A. I/O requests in the batch category may use flashcache if the I/O is from the sales finance database, and these I/O requests are guaranteed to get 80% of the I/O if the interactive category I/Os use no more than 20%.
• B. I/O requests made by sessions in the marketing database may use flashing and flashcache if no other categories or database or database are using flashing and flashcache at the same time.
• C. I/O requested in the interactive category may use flashdns if the I/O is from the sales or finance databases, and these I/O requests are guaranteed to get 90% of the I/O if the enough I/Os are issued in this category.
• D. I/O requests from the sales database may use flashing regardless of the I/O category.
• E. No I/Os in any category or from any database may use flashing or flashcache because the objective is off.

Answer: AD

NEW QUESTION 17
You must apply patches and patch bundles in a rolling fashion, if possible, on the components of your Database Machine.
You use RAC for your database and also use Data Guard, having standby database on another Database Machine.
You wish to have scripts that contain the appropriate command to patch your environment. Your patch bundle is on the first database server and is located at /u01/stage.
You have downloaded the oplan utility to the first database server and run the following:
$ORACLE_HOME/oplan/oplangenerateApplySteps /u01/stage Which two are true concerning oplan?

• A. It will generate instructions for patching only storage servers.
• B. It will generate instructions for patching all the components on the Database Machine.
• C. It will generate instructions for patching the RAC Oracle Home on the primary location.
• D. It will generate instructions for patching the Data Guard environment on the standby location.
• E. It will generate instructions for patching the Grid Infrastructure home on the primary location.

Answer: CE

Explanation:
Oplan generates instructions for all of the nodes in the cluster.
Note:
* Oplan is a utility that facilitates you with the application of bundle patches on Exadata compute nodes via Opatch. This new utility helps you with the patch process by generating step-by-step instructions telling you how to apply a bundle patch in your environment.
* Exadata is much more than a "database-in-a-box." It is a set of compute nodes (think RAC node servers) combined with ultra-fast infiniband (...and 10GB ethernet, and multiple
* 1GB ethernet) and storage nodes.
Incorrect:
Not D: There is no support for Oracle DataGuard

NEW QUESTION 18
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 19
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 20
To troubleshoot a possible hardware problem, you consider moving all disk drives from one Exadata storage server to a replacement chassis.
You must contain storage availability while performing task.
The Exadata storage server is an X3-8 Database Machine and storage grid is not
partitioned.
Which two factors would prevent you from moving the disks from one Exadata storage server to another one?

• A. The existence of an external redundancy ASM diskgroup
• B. The existence of a normal redundancy ASM diskgroup
• C. The existence of an ASM diskgroup with the repair_time attribute set to 0.
• D. The existence of an ASM diskgroup with its compatible.asm attribute set to 10.2.0.0.0
• E. Offline or inactive celldisks in another Exadata server

Answer: AD

Explanation:
A: If you want Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files). You specify EXTERNAL REDUNDANCY if you do not want mirroring by Oracle ASM. For example, you might choose EXTERNAL REDUNDANCY if you want to use storage array protection features.
D: Restoring the redundancy of an Oracle ASM disk group after a transient disk path failure can be time consuming. This is especially true if the recovery process requires rebuilding an entire Oracle ASM failure group. Oracle ASM fast mirror resync significantly reduces the time to resynchronize a failed disk in such situations. When you replace the failed disk, Oracle ASM can quickly resynchronize the Oracle ASM disk extents.
To use this feature, the disk group compatibility attributes must be set to 11.1 or higher.
Incorrect:
Not C: You can set the DISK_REPAIR_TIME disk group attribute to delay the drop operation by specifying a time interval to repair the disk and bring it back online.
Note:
* The redundancy levels are:
/ External redundancy
Oracle ASM does not provide mirroring redundancy and relies on the storage system to provide RAID functionality. Any write error cause a forced dismount of the disk group. All disks must be located to successfully mount the disk group.
/ Normal redundancy
Oracle ASM provides two-way mirroring by default, which means that all files are mirrored so that there are two copies of every extent. A loss of one Oracle ASM disk is tolerated. You can optionally choose three-way or unprotected mirroring.
/ High redundancy
Oracle ASM provides triple mirroring by default. A loss of two Oracle ASM disks in different failure groups is tolerated.
Reference: Administering Oracle ASM Disk Groups

NEW QUESTION 21
......