[Free] Download Latest (March 2016) Oracle 1Z0-485 Real Exam 41-50

Ensurepass

QUESTION 41

Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?

 

A.

database views

B.

InfiniBand networking

C.

Flash Cache

D.

high performance SAS2 disk drives

E.

cell offloading

 

Correct Answer: C

Explanation:

The Exadata Smart Flash Cache feature of the Exadata Storage Server Software intelligently caches database objects in flash memory, replacing slow, mechanical I/O operations to disk with very rapid flash memory operations. .

 

 

QUESTION 42

The mpstat output from OS Watcher shows a database node as being 90% idle on an average. What would you do to get a full picture of CPU utilization on the entire Exadata RAC cluster?

 

A.

Average the mpstat id1 output from all the nodes.

B.

Ask application users if they have noticed a slowdown in screen response.

C.

Look for an increase in batch job servicing times.

D.

A & B above

 

Correct Answer: A

 

 

QUESTION 43

What would be the best way to ensure that batch Jobs do not impact performance of online queries that use the same database?

 

A.

Configure IORM to disable Flash Cache usage for batch workload.

B.

Build a Database Resource Management Plan, giving priority to query workload.

C.

Deploy Instance Caging to control batch jobs.

D.

Configure and enable Parallel Query.

E.

Configure resource plans by using the I/O Resource Manager on the storag
e cells, giving priority to query workload.

 

Correct Answer: B

Explanation:

Using the Database Resource Manager, you can distribute available processing resources by allocating percentages of CPU time to different users and applications. In a data warehouse, a higher percentage may be given to ROLAP (relational on-line analytical processing) applications than to batch jobs.

Incorrect:

Not C:

In addition to controlling I/O utilization on the Exadata storage cells, Oracle also allows you to limit CPU resource utilization on the compute nodes using a technique called instance caging.

QUESTION 44

Which is a best practice for High Availability (HA) in an Exadata environment?

 

A.

Checksums performed on the Exadata Storage Server ensure logical consistency of block content.

B.

When a standby database is in place, DB_BLOCK_CHECKING is not required and thus not recommended.

C.

Oracle Exadata Storage Server Software HARD checks operate transparently after enabling DB_BLOCK_CHECKSUM on a database.

D.

Due to the different architecture that Exadata has with storage servers, compared to regular Storage Area Network, DB_LOST_WRITE_PROTECT need not be set.

E.

Stretched RAC is the best alternative for Exadata that combines both HA and DR into one.

 

Correct Answer: C

Explanation:

Exadata storage cells include Oracle Hardware Assisted Resilient Data (HARD) to provide a unique level of validation for Oracle block data structures such as data block address, checksum. and magic numbers prior to allowing a write to physical disks. HARD validation with Exadata is automatic (setting DB_BLOCK_CHECKSUM is required to enable checksum validation).

The HARD checks transparently handle all cases including Oracle ASM disk rebalance operations and disk failures.

Incorrect:

Not A: The checksum is used to validate that a block is not physically corrupt, detecting corruptions caused by underlying disks, storage systems, or I/O systems. Checksums do not ensure logical consistency of the block contents.

Not B: MAA recommends that you set DB_BLOCK_CHECKING=MEDIUM or FULL on the physical standby as a minimum practice to prevent the standby from various logical block corruptions.

Not D: The recommendation is:

On the primary database: DB_LOST_WRITE_PROTECT=TYPICAL (default TYPICAL on Exadata) On the Data Guard Physical Standby Database:

DB_LOST_WRITE_PROTECT=TYPICAL Not E: Protection from a broad range of, but not all disasters

While not a full disaster recovery (DR) solution, an Extended Distance Oracle RAC or Oracle RAC One Node deployment will provide protection from a broad range of disasters. For a full DR protection Oracle recommends deploying an Oracle RAC together with a local and a remote Oracle Data Guard setup as described in the Maxim
um Availability Architecture (MAA).

 

 

QUESTION 45

High-disk IOPS (I/Os per second) rates are leading to longer execution times.Which three approaches would you use to improve this scenario?

 

A.

Enable Write-Back Flash Cache due to heavy DBWR usage.

B.

Enable Write-Back Flash Cache due to heavy LGWR usage.

C.

Swap hard disks to High Capacity disks.

D.

Tune the application to reduce I/O requests.

E.

Leverage IORM to give priority to critical workloads.

 

Correct Answer: BDE

Explanation:

B (not A): Smart Flash Logging is a recent Exadata enhancement that provides physical disk redo write relief in times of high LGWR activity; alone, probably not a driver for Exadata.

 

QUESTION 46

What are two impacts of selecting high redundancy over normal redundancy for your diskgroups?

 

A.

High redundancy provides more usable storage.

B.

Normal redundancy provides more usable storage.

C.

High redundancy gives you better I/O performance.

D.

High redundancy provides High Availability (HA) during disk failure and rolling Storage Server patching

E.

Normal redundancy provides HA during rolling Storage Server patching.

 

Correct Answer: BD

 

 

QUESTION 47

Exadata Database Machine offers an Intelligent Platform Management Interface for the various components in the Exadata product. Which option is true?

 

A.

IPMI can be used to remotely start and stop servers.

B.

IPMI can be used to remotely log in to the operating system.

C.

IPMI commands can be executed by using SNMP traps.

D.

IPMI settings can be secured by backing up the Oracle Linux installation on the storage system.

 

Correct Answer: A

Explanation:

IPMI – short for Intelligent Platform Management Interface – is an interface standard that allows remote management of a server from another using standardized interface. The servers in the Exadata Database Machine follow that. It’s not an Exadata command but rather a general Linux one.

To power on a cell or database server, issue this from another server:

# ipmitool -H prolcel01-ilom -U root chassis power on

To stop a server, use the shutdown command. To stop immediately and keep it down, i.e.

not reboot, execute:# shutdown -h -y now

 

 

QUESTION 48

Identify four significant changes when a backup of Exadata compute nodes must be performed.

 

A.

application of operating system patches

B.

before shutdown to preserve storage indexes

C.

application of Oracle patches

D.

reconfiguration of significant operating system parameters

E.

installation or reconfiguration of significant non-Oracle software

F.

storage server rebalancing

G.

addition of an Exadata storage expansion rack

 

Correct Answer: ACDG

 

 

QUESTION 49

Which two statements are t
rue about troubleshooting failed patching activities?

 

A.

Dependency issues found during yum updates require rolling back to a previous release before retrying.

B.

Bundle patches applied using opatch auto cannot roll back only the database or the grid infrastructure home.

C.

Failed OS patches on database servers can be rolled back.

D.

Failed storage cell patches are rolled back to the previous release automatically.

E.

Database server OS updates can be rolled back using opatch auto -rollback.

F.

Dependency issues found during yum updates should be ignored using the force option.

 

Correct Answer: AE

Explanation:

Oracle has shifted the strategy to patching the exadata in 11.2.3.2.0 onwards to using Yum as the method of patching.

Database servers are patched using yum; there is a yum channel for each Exadata image version. Recently, this functionality replaced the “minimal pack.”

In the README for each storage server patch, Oracle provides detailed rollback instructions that are to be followed in the event of a patch failure.

 

 

QUESTION 50

Your customer is hesitant to install the Oracle Configuration Manager in their environment. Give them three ways in which it will benefit their Exsdata Database Machine support experience and potentially resolve some of the issues they are having with the length of time it is taking Oracle to process their Exadata Service Requests (SRs).

 

A.

Host information can be gathered and sent to Oracle for license compliance.

B.

Potential issues can be addressed before they impact operations.

C.

Priority handling can be extended for SRs, with attached configuration.

D.

Exadata patching cannot be done successfully without the Oracle Configuration Manager.

E.

Root cause analysis can be accelerated.

 

Correct Answer: BCE

Explanation:

Oracle Configuration Manager is used to personalize the support experience by collecting configuration information and uploading it to the Oracle repository. When customer configuration data is uploaded on a regular basis, customer support representatives can analyze this data and provide better service to the customers. For example, when a customer logs a service request, he can associate the configuration data directly with that service request (C). The customer support representative can then view the list of systems associated with the customer and solve problems accordingly.

Some of the benefits of using Oracle Configuration Manager are as follows:

Reduces time for resolution of support issues (E)

Provides pro-active problem avoidance (B)

Improves access to best practices and the Oracle knowledge base

Improves understanding of customer’s business needs and provides consistent responses and services

 

Free VCE & PDF File for Oracle 1Z0-485 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

This entry was posted in 1Z0-485 Real Exam (March 2016) and tagged , , , , , , , . Bookmark the permalink.