The Rebirth Guide To 1Z0-027 Testing Bible

NEW QUESTION 1
You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to the Exadata Database Machine. The database currently supports an application requiring fast response times, which satisfies stringent requirements, and most of the application queries use index access to the tables in the application schema.
For which case would you consider dropping indexes to allow Smart Scans to occur?

• A. Drop non-constraint indexes if Smart Scan occurs instead of an index access path on the corresponding table.
• B. Drop non-constraint indexes if Smart Scan performs better than index unique scans on the corresponding table.
• C. Drop non-constraint indexes if Smart Scan performs better than index range scans on the corresponding table.
• D. Drop non-constraint Indexes if Smart Scan performs better than any index scans on the corresponding table.

Answer: D

NEW QUESTION 2
Identify two valid reasons for creating multiple griddisks on a Single celldisk.

• A. To segregate storage into multiple pools with different performance characteristics
• B. To facilitate normal or high redundancy ASM diskgroups
• C. To enable disk mirroring for the system area
• D. To segregate storage into multiple pools that can be assigned to different databases
• E. To segregate storage into multiple pools that can be assigned to different resource consumer groups in the same database.

Answer: AD

NEW QUESTION 3
You configuring has two half racks, one with high capacity disks and other with high performance disks and high capacity expansion half rack.
There are two RAC clusters, one on each half rack, which have separate storage grids, each consisting of some of the storage servers in the configuration.
You are planning your deployment of Enterprise Manager to monitor all the components of this multi-rack Database Machine, and must provide for high availability of the monitoring
infrastructure.
If the host running the agent which has database machine targets bound to it fails, the monitoring of these targets must be another agent.
Which two are true regarding the configuration used to support this?

• A. Enterprise manager support must be deployed to only one Enterprise Manager Agent in each cluster.
• B. A secondary agent must be deployed on a database server in the same cluster as the server hosting the primary agent.
• C. Enterprise Manager support must be deployed to all Enterprise Manager Agents in each cluster.
• D. A secondary agent may be deployed on a database server in a different cluster than the server hosting the primary agent.
• E. A secondary agent must be deployed on a database server in a different cluster than the server hosting the primary agent.
• F. Enterprise Manager support must be deployed to at least two Enterprise Manager Agents in each of the two RAC clusters.

Answer: AD

Explanation:
Note:
* Instructions for configuring a high availability solution for the Exadata Storage cell or any other Exadata plug-in are documented in the Oracle Database Machine Monitoring Best Practices (Doc ID 1110675.1) document located in My Oracle Support
* High Availability for Plug-Ins
Normally a plug-in target is bound to a specific agent If the agent is down the target cannot be monitored
A procedure exists to facilitate target failover to a secondary agent
* The Enterprise Manager agent must be deployed to all compute nodes of the Exadata Database Machine.
* The Oracle ILOM plug-in monitors the Oracle ILOM service processor in a compute node for hardware events and records sensor data to the Oracle Enterprise Manager Repository.
The ILOM plug-in is deployed to the Enterprise Manager (EM) Agent on the first compute node in an Oracle Database Machine, and only that EM agent communicates with the EM Management Server and Repository for all ILOM database server service processors in the Oracle Database Machine.
* OEM Agent and Exadata Plug-ins
1. OEM Agent and Plug-Ins are deployed under Oracle Home
2. Agent incorporates additional functionality in Plug-In
3. Agent and Plug-in
DB Server on Exadata DBM
3. Agent and Plug-in communicates with Storage Server
4. Plug-Ins are available for monitoring all Exadata hardware components
5. OEM Agent communicates with the OEM

NEW QUESTION 4
Which tool will provide you with diagnostic information for all the software log, trace files,
and OS information on Database Machine?

• A. dbmcheck.sh
• B. diagget.sh
• C. oswatcher
• D. adrci
• E. Enterprise Manager

Answer: B

Explanation:
Gather all diagnostics information
/opt/oracle.SupportTools/onecommand/diagget.sh

NEW QUESTION 5
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 6
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 7
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 8
Which two are true about Exadata storage server alerts?

• A. Metric alerts are never stateful.
• B. Metrics have no thresholds set on them by default.
• C. SNMP alert notifications can be sent to only one destination.
• D. Metric threshold; if set, will persist across storage server reboots.
• E. SMTP alert notifications must be sent to both ASR manager and Enterprise Manager Agents

Answer: DEExplanation:Incorrect:

Explanation:
Not A: there are both stateful and stateless alerts. Not B: Metrics have defaults.
Not C: An SNMP alert can have multiple destinations.

NEW QUESTION 9
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 10
Which two are true about the use of DBFS in a Database Machine environment?

• A. DBFS must be used to bulk load data into a database on the Database Machine if the staging area requires Exadata based shared storage.
• B. DBFS must be used to have a POSIX compliant shared storage solution that is accessible from the database servers on a Database Machine.
• C. DBFS must be used to bulk load data into a production database on the Database Machine.
• D. DBFS must use the DBFS_DG diskgroup for any DBFS store.
• E. DBFS must be used to have a POSIX-compliant Exadata-based shared storage solution.

Answer: CD

NEW QUESTION 11
Which two are true concerning the allocation of I/O resources by the IORM within the CELLSRV process?

• A. If two consumer groups A and B in the PROD database get 10% and 15% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 20% and 30% respectively, provided that the category plans and inter database plans are unchanged, and consumer groups A and B are still mapped to the same category.
• B. If two consumer groups C and D In the PROD database get 10% and 15% respectively of resource allocation, then the percentage of I/O resource would be the same if they still got 10% and 15% respectively and were remapped to a different category by the DBA, provided that the category plans and Interdatabase plans are unchanged.
• C. If two consumer groups P and Q In the PROD database get 20% and 10% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 10% and 5% respectively, and the Interdatabase plan has changed, provided that the category plan is unchanged, and consumer groups A and B are still mapped to the same categories.
• D. Log Writer I/O and Control File I/O are high priority I/O managed automatically by IORM.
• E. Database Writer I/O is considered to be the highest priority I/O and is managed based on attributes of the IORM plan.

Answer: CD

Explanation:
*(not A, Not B) Rules in an interdatabase resource plan specify allocations to databases, not consumer groups.
* IORM Rules
IORM is only "engaged" when needed.
/ (D) Redo and control file writes always take precedence.
/ (Not E) DBWR (database writer) writes are scheduled at the same priority as user IO.
/ IORM does not intervene if there is only one active consumer group on one database.
/ Any disk allocation that is not fully utilized is made available to other workloads in relation to the configured resource plans.
/ Background IO is scheduled based on their priority relative to user IO.
/ For each cell disk, each database accessing the cell has one IO queue per consumer group and three background queues
Note:
* Use IORM metrics to track
/ I/O load per Consumer Group (IOPS, MBPS, disk utilization %)
/ I/O throttling per Consumer Group Reference: Using IORM with Exadata

NEW QUESTION 12
Which two are true about the use of the Integrated Lights Out Manager (ILOM) on the Database Machine?

• A. ILOM can be used to power-on the Cisco switch.
• B. ILOM can be used to power on the InfiniBand switches.
• C. ILOM can be used to power-on the database servers.
• D. ILOM generates hardware alerts for the power distribution units.
• E. ILOM provides a remote console for the storage servers.

Answer: CE

Explanation:
* The Oracle ILOM Remote Console is supported on all Oracle Sun x86 processor-based servers. It is also supported on some SPARC processor-based servers. The Oracle ILOM Remote Console is a Java application that you can launch from the Oracle ILOM web interface
* Remote Management: Integrated Lights Out Manager (ILOM) Ethernet port

NEW QUESTION 13
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 14
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 15
You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your Database Machine.
Following are details for the source database: Database version: 10.2.0
Byte order: Big Endian HP-UX (64-bit) Database size: 24 TB
Storage: ASM with 1 MB allocation unit size Which two are supported migration methods?

• A. Physical migration using ASM online Migration
• B. Physical migration using Transportable Database
• C. Logical migration using Oracle Streams
• D. Local migration using Oracle Streams
• E. Logical migration using logical standby

Answer: CE

Explanation:
There are several techniques for migrating data to a Database Machine. Migration can be done
using Oracle Recovery Manager (RMAN) to backup from traditional storage and restore the data
onto Exadata. Oracle Data Guard can also be used to facilitate a migration. This is done by first
creating a standby database based on Exadata storage. The standby can be using Exadata storage
and the production database can be on traditional storage. By executing a fast switchover, taking
just seconds, you can transform the standby database into the production database. This provides
a built-in safety net as you can undo the migration very gracefully if unforeseen issues arise.
Transportable Tablespaces (B) and Data Pump may also be used to migrate to Exadata.
Any
technique used to move data between Oracle Databases can be used with Exadata.

NEW QUESTION 16
Identify two permitted uses of external InfiniBand connections to a Database Machine.

• A. To connect an ExaLogic Elastic Cloud Machine
• B. To monitor the InfiniBand network using Enterprise Manager
• C. To connect an external tape library
• D. To use a bonded client access network
• E. To use a bonded management network

Answer: AC

Explanation:
A: Combining the Oracle Exalogic Elastic Cloud with the Oracle Exadata Database Machine for SAP NetWeaver
The InfiniBand fabric that spans Exalogic and Exadata components provides the following key ways of
simplifying and accelerating SAP NetWeaver installations running on Exalogic
Note: A high specialized database networking protocols connects all the components inside an Exadata Database Machine. External connectivity to the Exadata Database Machine is provided through standard 1 Gigabit and 10 Gigab Multiple X3 even larger configurations.

NEW QUESTION 17
You are about to run the oplan utility to patch the servers on your test Database Machine before patching the production environment.
The following task might be performed:
A) Test the failback procedure
B) Run the exachk utility
C) Read the README file.
D) Automate the patch application process as appropriate.
E) Verify that the patch provides the functionality it is meant to.
F) Apply the patch.
G) Evaluate the system performance.
In which order should the tasks be performed to patch in the recommended fashion?

• A. C, B, D, F, B, E, A
• B. C, D, F, B, E, G, A, B
• C. C, B, D, F, E, G, A
• D. C, B, D, F, E, A, G
• E. C, B, D, F, B, E, G, A

Answer: E

NEW QUESTION 18
You are using Hybrid Columnar Compression for a table stored in a tablespace that is contained in an Exadata-based ASM diskgroup. Identify three statements that correctly explain where the compression and decompression can be done.

• A. Decompression can be done on the database servers.
• B. Compression can be done on the Exadata storage servers.
• C. Compression can be done on the database servers.
• D. Decompression can be done on the Exadata storage servers.

Answer: ACD

Explanation:
* decompression
/ Queries run directly on Hybrid Columnar Compressed data does not require the data to be decompressed
/ Data that is required to satisfy a query predicate does not need to be decompressed; only the columns and rows being returned to the client are decompressed in memory
/ The decompression process typically takes place on the Oracle Exadata Storage Server in order to maximize performance and
offload processing from the database server.

NEW QUESTION 19
A read-only application is in development and is using a test database on a Database Machine. You are examining SQL statements from this application in an attempt to determine which ones will benefit from the Exadata Smart scan capability.
The following is true about the tables used by the application:
1. The data for the tables has just been loaded.
2. There are no applications accessing the tables currently.
3. None of the indexes are compressed or reverse key indexes.
4. The tables use the default organization type data.
5. The only data types for the table are varchar (2), number, or date.
6. The largest number of columns for any table is 29.
7. No access is based on ROWID, or virtual columns.
Which two access paths will always generate either a set of “cell smart table scan” or a set of “cell smart index scan” requested?

• A. Full scans on sorted hash clustered tables executed in parallel
• B. Full table scans on index organized tables executed in parallel.
• C. Full table scans on heap tables executed in parallel
• D. Full scans on index clustered tables executed in parallel
• E. full scans on hash clustered tables executed in serially
• F. fast full scans on B*Tree indexes executed in parallel
• G. full index scans on B*Tree indexes executed in parallel

Answer: CF

NEW QUESTION 20
Which three statements are true regarding the configuration of Auto Service Request (ASR) on your Database Machine?

• A. HTTPS connectivity must be enabled from the ASK Manager host to the internet.
• B. ASR Manager must be installed on one of the database servers.
• C. Oracle Solaris must be used on the server where ASK Manager is installed.
• D. SMTP must be enabled on at least one database server.
• E. Oracle Linux must be used on the server where ASR Manager is installed
• F. ASR Manager may be installed on any type of server running Oracle Linux.
• G. ASR Manager may be installed on any type of server running Oracle Solaris.

Answer: AFG

Explanation:
A: Before installing ASR, please ensure the following conditions are met:
/ (A) Ensure connectivity to the Internet using HTTPS.
/ Make sure you have access to My Oracle Support and that your contact information is
correct and current.
/ Make sure all of your assets have a Contact assigned and that the contact is correct and current.
/ Identify and designate a system to serve as ASR Manager.
/ Identify and verify ASR assets.
F, G (not C, not E, not B): 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.
Reference: Oracle Auto Service Request Exadata Database Machine Quick Installation Guide

NEW QUESTION 21
You are in the planning stage of the network configuration for your Database Machine. The requirements are:
1. A fault-tolerant network, providing higher availability for connections to database instances
2. Fault tolerance providing higher availability for connections to perform management functions on the database and storage servers.
3. Full monitoring of all Database Machine components using Enterprise Manager
Which three components require external Ethernet network cables to connect your existing network infrastructure to your database machine to satisfy this requirement?

• A. Database servers
• B. Exadata storage servers
• C. InfiniBand storage servers.
• D. Power distribution units (PDUs)
• E. Cisco Ethernet switch

Answer: ADE

NEW QUESTION 22
You have configured a multi-rack Database Machine with two X3-8 full racks all in a single cluster and storage grid.
Which two are true regarding the servers on which Enterprise manager agents must be deployed in order to monitor all components of the multi-rack Database Machine?

• A. On only one database server in the first rack
• B. On all storage servers in all racks
• C. On at least two storage servers in the first rack
• D. On all database servers in the first rack
• E. On only one database server in second rack
• F. On all database servers in second rack
• G. On at least two storage servers in the second rack

Answer: DF

Explanation:
Note:
* The Enterprise Manager agent must be deployed to all compute nodes of the Database Machine.
* Oracle's documentation uses the term compute node when referring to the database server tier of the platform.
* The Exadata Database Machine runs Oracle Database 11g Real Application Cluster. The cluster and the database run on the servers known as database nodes or compute nodes (or simply “nodes”).
* Cells and compute nodes are not shared between partitions.
* Compute nodes in same partition share the same Cluster.

NEW QUESTION 23
......