Top Tips Of Updated 1Z0-027 Testing Bible

NEW QUESTION 1
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 2
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 3
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 4
Which two activities are supported on the storage servers in the Database Machine?

• A. Installing an alternative package manager
• B. configuring secure shell user equivalency for the callmonitor user
• C. changing root password
• D. upgrading the Storage Server software package using RPN
• E. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure

Answer: BC

NEW QUESTION 5
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 6
You must drop all celldisks on all the cells in a quarter rack as part of a reconfiguration project, to support normal redundancy interleaving.
Select two actions that describe the operating system (O/S) account on the cells to which you should log in, and the tool that may be used to drop the celldisks.

• A. To the CELLMONITOR account using CELLCLI interactively on each cell.
• B. To CELLADMIN account calling CELLCLI on all cells using DCLI
• C. To either the CELIMONITOR or the CELLADMIN account calling CELLCLI on all cells using DCLI
• D. To the CELLMONITOR account calling CELLCLI on all cells using DCLI
• E. To the CELLADMIN account using CELLCLI interactively on each cell
• F. To either the CELLMONITOR or CELLADMIN account calling interactively on each cell

Answer: BE

Explanation:
Note:
* Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface. To invoke the CLI, simply login to the Exadata cell as cellmonitor, celladmin, or root, and type "cellcli". Within cellcli, a wide range of commands can be invoked to monitor the cell.
* While connected to cellcli as the Linux account celladmin, you can perform all cellcli commands except calibrate.
While logged into the cell server as cellmonitor, you can do any "read-only" commands; you cannot change any configuration or attributes.

NEW QUESTION 7
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 8
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 9
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 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
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 12
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 13
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 14
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 15
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 16
You recently upgraded your Exadata image to the latest release; previously you were using 11.2.0.3.
At the same time, you decide to address some performance problems as follows:
You noticed increased latency for the database log writer, especially during the quarterly battery learn cycle on the cells.
You have complaints of erratic performance from certain write-intensive applications. Which two actions could improve performance in these areas?

• A. Enable write-back flashcache by setting lunWriteCacheMode to Write Back Mode.
• B. Use ALTER TABLE in the database to set CELL_FLASH_CACHE = KEEP for the tables belonging to the affected application.
• C. Configure Smart Flash Log on the cells to use some of these of the space on the cell flash devices.
• D. Configure the table belonging to the affected application using CELLCLI, to the set CELL_FLASH_CACHE = KEEP.
• E. Configure Smart Flash Log on the database server to use server flash memory.

Answer: BC

Explanation:
B: The following command could be used to pin the table CUSTOMERS in Exadata
Smart Flash Cache
ALTER TABLE customers STORAGE (CELL_FLASH_CACHE KEEP)
C: Creating Flash Disks Out Of The Flash Cache
When an Exadata cell is installed, by default, all the flash is assigned to be used as flash cache and
user data is automatically cached using the default caching behavior. Optionally, a portion of the
cache can be reserved and used as logical flash disks. These flash disks are treated like any
Exadata cell disk in the Exadata cell except they actually reside and are stored as non- volatile
disks in the cache.
Note:
* Pinning Objects In The Flash Cache
Preferential treatment over which database objects are cached is also provided with the Exadata
Smart Flash Cache. For example, objects can be pinned in the cache and always be cached, or an
object can be identified as one which should never be cached. This control is provided by the
new storage clause attribute, CELL_FLASH_CACHE, which can be assigned to a database table, index, partition and LOB column
* There are two techniques provided to manually use and manage the cache. The first enables the
pinning of objects in the flash cache. The second supports the creation of logical disks out of the
flash for the permanent placement of objects on flash disks.

NEW QUESTION 17
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 18
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 19
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 20
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 21
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 22
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 23
Which is true regarding Enterprise Manager monitoring and configuration?

• A. Agents must be deployed on the- storage servers, in case all the database servers are down.
• B. Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents, but additional ethernet cables are required to connect the PDUs to the internal network switch in the Database Machine
• C. Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents without, any additional network configuration.
• D. Agents may be deployed on the storage servers, in case all the database servers are down.
• E. Monitoring the power distribution units (PDUS) is done by Enterprise Manager agents but additional ethernet cables are required to connect the PDUs to the corporate network switch.

Answer: C

Explanation:
Note:
* The following prerequisites must be met before you can deploy the plug-in:
* Set and validate the preferred credentials on all Agents where you want to deploy the plug- in. This is essential in order to deploy the plug-in.
The PDU firmware version must be 1.02 or later.
* This plug-in will be used to monitor PDU's actual current value of Phase1, Phase2, and Phase3 and raises appropriate events if they have crossed the different threshold values. Each PDU will have a plug-in instance added to its own OEM Grid Control agent.
By deploying the plug-in to your Grid Control environment, you gain the following management features:
Monitor PDU targets.
Raise alerts and violations based on thresholds set on monitoring and configuration data. Provide rich out-of-box metrics and reports based on the gather
Reference: Oracle Enterprise Manager System Monitoring Plug-In Installation Guide for
Exadata Power Distribution Unit

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

• A. Control File I/O is managed automatically at high priority by IORM.
• B. Control File I/O is considered part of the SYSTEM resource Consume group by IORM.
• C. Log Writer I/O to the Smart Flash Log is considered part of the SYSTEM resource consumer group by IORM.
• D. Log Writer I/O to the Smart Flash Log is managed automatically at high priority by IORM.
• E. Database Writer I/O is managed automatically at normal priority by IORM.
• F. Database Writer I/O is considered part of the SYSTEM resource consumer group by IORM.

Answer: AE

Explanation:
Note:
* IORM Rules
IORM is only "engaged" when needed.
/ (A) Redo and control file writes always take precedence.
/ (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.
/ Background IO queues are mapped to "high", "medium", and "low" priority requests with different IO types mapped to each queue.
/ If no intradatabase plan is set, all non-background IO requests are grouped into a single consumer group called OTHER_GROUPS.
Reference: Using IORM with Exadata

NEW QUESTION 25
......