[Free] 2018(Jan) EnsurePass Testinsides Oracle 1z0-027 Dumps with VCE and PDF 11-20

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-027
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-027.html

Oracle Exadata Database Machine X3 Administration

Question No: 11

Identify the three components that serve a purpose only in the Database Machine.

  1. ASM intelligent Data Placement (IDP)

  2. Intelligent Database Protocol (IDB)

  3. Database Resource Manager (DBRM)

  4. I/O Resource Manager (IORM)

  5. Database Filesystem (DBFS)

  6. The DISKMON process

Answer: A,B,D Explanation:

Intelligent Data Placement, a feature of ASM that allows placing data in such a way that more frequently accessed data is located close to the periphery of the disk where the access is faster.

The Exadata software is optimally divided between the database servers and Exadata cells. The database servers and Exadata Storage Server Software communicate using the iDB –

the Intelligent Database protocol. iDB is implemented in the database kernel and

transparently

maps database operations to Exadata-enhanced operations. iDB implements a function shipping

architecture in addition to the traditional data block shipping provided by the database. iDB is

used to ship SQL operations down to the Exadata cells for execution and to return query result

sets to the database kernel. Instead of returning database blocks, Exadata cells return only the

The inter-database I/O allocations are defined within the software in the Exadata cell and managed by the I/O Resource Manager (IORM). The Exadata cell software ensures that inter-database I/O resources are managed and properly allocated within, and between, databases.

Question No: 12

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

  1. INSERT INTO . . . SELECT FROM statements, executed serially, which select from external tables, require the APPEND hint to use direct path loading.

  2. CREATE TABLE . . . AS SELECT statements, which select from external tables, attempt to use in direct path loading automatically.

  3. CREATE TABLE . . . AS SELECT statements, which select from external tables, require the APPEND hint to use direct path loading.

  4. INSERT INTO . . . SELECT FROM statements, executed serially, which select from external tables, are unable to use direct path loading.

Answer: A,B

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 amp; Exchange Partition Replace IAS for Copying Partition on Exadata

Question No: 13

You are evaluating the performance of a SQL statement that accesses a very large table, and have run the following query producing the output shown:

Ensurepass 2018 PDF and VCE

For which two reasons would the; “physical read total bytes” statistic be greater than the “cell physical IO bytes eligible for predicate offload” statistic?

  1. There is an index on the column used in the where clause, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O for blocks in the cells.

  2. The table is an IOT and has an overflow segment, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O for block in the cells.

  3. There is an uncommitted transaction that has modified some of the table blocks, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O for block in the cells.

  4. The table is an indexed clustered table, causing “cell single block physical reads” to be requested by the database instance, resulting in additional I/O for blocks in the cells.

  5. There are migrated rows in the table, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O for blocks in the cells.

Answer: B,D

Question No: 14

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?

  1. Category I/O

  2. Database I/O

  3. Resource Consumer Group I/O

  4. Smart Flash Log I/O

  5. Smart Flash Cache I/O

Answer: B,C

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.

    Question No: 15

    A table in one of your database schemas contains only varchar, number, and date data types for the columns.

    Which three operations can be offloaded to the Exadata storage servers when doing a smart scan against this table, if no other situations arise that prevent Smart Scan from occurring?

    1. Column filtering

    2. Sort merge join filtering

    3. Predicate filtering

    4. Nested loop Join filtering

    5. Hash join filtering

    6. Virtual column filtering

    Answer: A,C,E Explanation:

    A: Smart Scan Column Filtering

    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.

    C: Smart Scan Predicate Filtering

    Exadata enables predicate filtering for table scans. Only the rows requested are returned to the database server rather than all rows in a table. For example, when the following SQL is issued only rows where the employees#39; hire date is after the specified date are sent from Exadata to the database instance.

    SELECT * FROM employee_table WHERE hire_date gt; #39;1-Jan-2003#39;.

    This ability to return only relevant rows to the server greatly improves database performance. This performance enhancement also applies as queries become more complicated, so the same benefits also apply to complex queries, including those with subqueries.

    Question No: 16

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

    1. On a dbfs file system stored in a staging database on the Database Machine

    2. On an Exadata-based ACFS file system on the Database Machine

    3. On an nfs file system mounted on a database server where the external table will be accessed.

    4. On local storage on one or more cells that are accessible to the database server where the load will be performed.

    Answer: A,C

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

    Question No: 17

    Which two are regarding the case of storage indexes?

    1. To increase the chance of using the a storage index, you can make table indexes invisible.

    2. To maximize the benefit of storage Indexes, load your data stored on the filtered columns.

    3. The cell physical 10 bytes saved by storage index statistic returns multiple rows, one for each storage server.

    4. Storage indexes are retained after a cell is rebooted.

    5. Avoid the use of bind variables because Storage Indexes do not work with bind variables.

    Answer: A,B

    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.

    Question No: 18

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

    1. Type of database workload

    2. Number of tablespaces in the source database

    3. Size of the source database

    4. Endian format of the source database

    5. ASM attributes and allocation unit (AU) size of the diskgroups used by the source database

    Answer: A,C,D

    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

Question No: 19

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.

  1. Identify the griddisk located on the poorly performing flashdisk and drop it from the associated ASm diskgroup.

  2. Verify that the griddisk located on the poorly performing flashdisk has been successfully dropped from the associated ASM diskgroup.

  3. Drop the flashcache on all cell.

  4. Safely power off the cell containing the poorly-performing flashdisk.

  5. Replace the poorly performing flashdisk.

  6. Power up the cell containing the replaced flashdisk and activate all griddisks.

  7. Recreate the flashcache on the cell using all flashdisks.

  8. Create a new griddisk on the replaced flashdisk.

  9. Add the griddisk back into the ASM diskgroup to which it belonged.

Answer: A,D,E,F,H,I

Explanation:

Note:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.