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

Ensurepass

QUESTION 11

You are concerned about how to recover from a failed Exadata Storage Server. What is the best way to recover from a storage cell failure when content in both system disks is lost?

 

A.

Database Machine Administrators should be prepared by creating a backup using dbserver_backup.sh.

B.

Database Machine Administrators should be prepared by creating a backup to an NFS file location as described in the owners guide.

C.

Any USB can be plugged in to create a backup.

D.

Be sure that you have a backup by running make_cellboot_usb.sh in /opt/oracle.cellos.

E.

Use the Exadata Storage Server rescue functionality that Is provided on the CELLBOOT USB flash drive.

F.

Re-imaging the cell is the only option.

 

Correct Answer: E

Explanation:

Recovering Storage Cells from Loss of a System Volume Using CELLBOOT Rescue

Problem

You have either corrupted your system volume images or suffered from simultaneous loss of the first two disk drives in your Exadata storage cell, and you wish to use the internal CELLBOOT USB drive to recover from failure.

Solution

At a high level, these are the steps you should take:

* Understand the scope of the failure

* Contact Oracle Support and open a Service Request

* Boot your system from the internal CELLBOOT USB image

* Recover your storage cell using the cell rescue procedure

* Perform post-recovery steps and validation

 

 

QUESTION 12

A customer has three databases named CC. FIN, and DW. The CC database is for their CallCenter. Even a slight decrease in the response time of the database would mean more people “on hold” in their data center. The orders received through the CallCenter are stored in the Finance (FIN) database. Both databases, CC and FIN, serve as sources for the Data Warehouse (DW) database. All databases use the same Automatic Storage Management (ASM) diskgroup and therefore, the same physical disks on Exadata storage. The customer wants to dynamically control the resources that are available for the CallCenter database because this has direct impact on their operations? Which option should be implemented?

 

A.

DBRM on the CC database

B.

DBRM on all the databases

C.

IORM, because DBRM cannot be changed for an existing session

D.

IORM and DBRM

 

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.

 

 

 

QUESTION 13

Which two statements are true about Exadata memory capabilities?

 

A.

X3-8 can be purchased in a Half Rack configuration with 2 TB of memory.

B.

X3-2 memory can be expanded to 512 GB per node from 256 GB.

C.

X3-2 memory can be upgraded to use Flash in the compute nodes.

D.

X3-8 memory is fixed at 4 TB per a Rack.

E.

X3-2 can be purchased in a Half Rack configuration with 256 GB per node.

 

Correct Answer: DE

Explanation:

D: ORACLE EXADATA DATABASE MACHINE X3-8 features include:

160 CPU cores and 4 TB of memory for database processing

E: Database servers X3-2

A third generation was announced in 2012. Each Database Server with 2 x Eight-Core Intel Xeon E5-2690 Processors (2.9 GHz)

128 GB Memory (expandable to 256GB)

 

 

QUESTION 14

You are asked to enable Write Back Flash Cache for one of your customers X3-2 Full Rack in a rolling fashion. Put the following steps in the right order:

 

A. Set flashCacheMode to writeback.

B. Inactivate all grid disks and shut down cellsrv.

C. Drop the Flash Cache.

D. Verify that cell for flashcacheMode is writeback.

E. Create the Flash Cache.

F. Start up cellsrv and activate all grid disks.

G. Check grdidksk asmdeactivationoutcome and asmmodestatus for all grid disks to ensure that all grid disks on all cells are set to Yes and online, respectively.

 

A.

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

B.

G, A, B, C, F, E, D, and G

C.

G, C, B, A, F, E, D, and G

D.

G, E, C, B, F, A, D, and G

 

Correct Answer: C

Explanation:

Steps for Enabling Write back flash cache:

First of all,you don’t need the stop CRS or database (This is ROLLING method) ,you can do it cell by cell.

* (C) drop flashcache

CellCLI> drop flashcache

Flash cache owtcel03_FLASHCACHE successfully dropped

* (G) Be sure asmdeactivationoutcome is YES is before disabling grid disk

</pre>

CellCLI> list griddisk attributes name,asmmodestatus,asmdeactivationoutcome

* (B)

CellCLI> alter griddisk all inactive

 

 

 

 

QUESTION 15

What are the three customer options for hosting the Platinum Services Advanced Support Gateway?

 

A.

Install on Exadata Engineered System.

B.

Provide individual x86 64-Bit gateway hardware.

C.

Install in Oracle Virtual Machine with required hardware.

D.

Install on Oracle Database Appliance.

E.

Purchase the recommended x86 64-Bit gateway hardware from Oracle.

 

Correct Answer: ACE

Explanation:

Oracle provides a flexible model for deployment of the Oracle Advanced Support Gateway via no charge software that can be installed in three configurations:

1. On x86 customer provided servers;

2. On x86 servers purchased from Oracle;

3. Installed on Oracle Exalogic Elastic Cloud or Oracle SuperCluster systems.

 

Note:

Oracle Platinum Services provides enhanced support for high availability and performance to Oracle Premier Support customers running certified configurations of Oracle Exadata Database Machine, Oracle Exalogic Elastic Cloud, or Oracle SuperCluster, at no additional cost.

 

 

QUESTION 16

Identify two tasks that the Database Resource Manager can perform, which the I/O Resource Manager cannot.

 

A.

Manage I/O based on the application that is connected to the database.

B.

Manage the number of parallel sessions for a query.

C.

Manage I/O and CPU between databases on the same cluster or physical database host.

D.

Terminate database sessions when certain limits have been reached.

E.

Manage the throughput of an I/O-bound application based on the service name used for the connection.

 

Correct Answer: BD

Explanation:

IORM is similar to Oracle Database Resource Manager (DBRM) in that it provides a means for controlling allocation of system resources. Where DBRM’s primary goals are to control CPU resources, limit the degree of parallelism, and impose resource consumption constraints for different types of sessions within an Oracle database, IORM’s goal is to govern I/O resource allocations between databases on a shared storage infrastructure. When consolidating Oracle databases on Exadata, IORM can be used to ensure that I/O is controlled between databases as well as classifications of consumes that utilize the same ASM disk infrastructure and, as such, provide resource control capabilities beyond what DBRM provides within a database.

 

Using the Database Resource Manager, you can:

* Guarantee certain users a minimum amount of processing resources regardless of the load on the system and the number of users

* 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.

* Limit the degree of parallelism of any operation performed by members of a group of users

etc

QUESTION 17

Which statement is true about instance caging setup?

 

A.

Instance caging is the right approach to make sure that database instances are not stealing memory from each other.

B.

The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.

C.

Database instances need to be restarted to make changes to cpu_count effective.

D.

For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 3
2 to prevent oversubscribing

E.

The init.org parameter resource_manager_plan should be set.

 

Correct Answer: D

Explanation:

* In 11.2G there is new option called “Instance Caging” which enables to limit number of CPUs which can be seen/used by a database.

* Enabling Instance Caging

1. Manually set dynamic parameter cpu_count on instance level. As default this parameter is set to maximum number of cpu available on a hosts.

alter system set cpu_count=2;

2. Enable any resource manager plan that manages CPU. Most easy is to turn on default Oracle plan DEFAULT_PLAN.

alter system set resource_manager_plan=DEFAULT_PLAN;

* Provisioning CPU

There are generally 2 ways to distribute your CPU between databases

Partitioning – sum of all CPUs assigned to all your databases equals number of CPUs on a host. Databases don’t interfere with each other.

Over-provisioning – sum of all CPUs assigned to all your databases is higher that number of CPUs on a host. Databases can impact on each other performance.

 

 

QUESTION 18

Which CellCLI command is used to conclude that a storage server can be taken offline without impacting database availability?

 

A.

LIST GRIDDISK ATTRIBUTES name, asmDeactivationOutcome;

B.

LIST CELLDISK ATTRIBUTES name, raidLevel;

C.

LIST CELL ATTRIBUTES cellsrvStatus, flashCacheMode;

D.

LIST CELLDISK ATTRIBUTES name, raidLevel, asmModeStatus;

E.

LIST GRIDDISK ATTRIBUTES name, status;

 

Correct Answer: A

Explanation:

ASMDeactivationOutcome – recall that grid disks can be deactivated, which is effectively taking them offline. Since ASM mirroring ensures that the data is located
on another disk, making this disk offline does not lose data. However, if the mirror is offline, or is not present, then making this grid disk offline will result in loss of data. This attribute shows whether the grid disk can be deactivated without loss of data. A value of “Yes” indicates you can deactivate this grid disk without data loss.

CellCLI> list griddisk attributes name, ASMDeactivationOutcome, ASMModeStatus

DBFS_DG_CD_02_cell01 Yes ONLINE

DBFS_DG_CD_03_cell01 Yes ONLINE

DBFS_DG_CD_04_cell01 Yes ONLINE

… output truncated …

QUESTION 19

If your customer wants to save storage space by compressing tables that are read frequently but rarely updated, which compression technique would you recommend?

 

A.

OLTP

B.

ARCHIVE HIGH

C.

QUERY HIGH

D.

ARCHIVE LOW

E.

BASIC

 

Correct Answer: B

Explanation:

Compression Comparisons

clip_image001

 

 

QUESTION 20

Your customer has purchased their brand new Exadata Database Machine X3-2 Full rack to achieve 20-TB-per-hour backups on their 300 TB database. You have been called to determine why they are not able to achieve even half that rate. Use the information in the image below to identify two reasons their backups are still slow.

 

clip_image003

 

A.

The Media Server to Tape Library transfer is causing a bottleneck.

B.

The number of tape drives is causing a bottleneck.

C.

Exadata backups are being performed using RMAN over the 10 Gigabit Ethernet network.

D.

The number of database servers is causing a bottleneck.

E.

LVM snapshots are not configured properly on the Database Server.

 

Correct Answer: BD

Explanation:

The following bottlenecks will be reached first if using InfiniBand fabric to media server:

1. Media server to tape library SAN transfer rate

2. Number of tape drives

 

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.