1z0-485 exam questions and answers

Oracle

Exam 1Z0-485

Oracle Exadata Database Machine 2014 Implementation

Essentials

Oracle Exadata 1Z0-485

www.exadata-certification.com

QUESTION NO: 1

You get a Host Unreachable error when you attempt to connect to a server through a

network terminal command line. What are two other ways in which you can connect?

A. Use the ILOM Web GUI. B. Use the dcli command at the root prompt on a database node. C. Attach a terminal device to the back panel of the server with a serial cable. D. Connect by using SQL *Plus. E. Log in as root on the database node using the Net1 IP address.

Answer: A,C Explanation Buy Full Product

QUESTION NO: 2

Identify three Exadata Storage Server software processes and their purpose? A. CELLSRV: The Cell Server is responsible for servicing disk I/O and predicate processing

offload. B. CELLSRV: The Cell Server is responsible for balancing workload to other storage servers. C. MS: The Management Server is responsible for storage cell management and configuration. D. MS: The Management Server is responsible for starting a local Enterprise Manager agent. E. RS: The Restart Server is responsible for Automatic Storage Management (ASM) instance

restart. F. RS: The Restart Server is responsible for CELLSRV and MS monitoring and restart.

Answer: A,C,F

Explanation Buy Full Product

QUESTION NO: 3

Your customer wants to increase the size of the DATA disk group on the Exadata systems.

The customer is currently using 600 GB disks. Which two are the best options that you

would recommend?

A. adding a High Capacity Storage expansion rack



B. expanding the Exadata rack from a Half Rack to a Full Rack C. moving underutilized grid disks from the RECO disk group to DATA D. adding a ZFS storage appliance E. adding a High Performance Storage expansion rack

Answer: B,E

Explanation Buy Full Product QUESTION NO: 4

When would be the best time to run an Exadata health check (exachk)?

A. before patching, before upgrades, before backups, and on a regular basis B. after patching, after upgrades, and after backups C. only when advised by Oracle Support D. before and after patching, when advised by Oracle Support, and on a regular basis E. only after a hardware failure F. monthly and after a hardware failure

Answer: D


QUESTION NO: 5

Which two statements describe correct network configuration for Exadata Database Machine? A. The InfiniBand network subnet manager runs on all database servers to achieve

High Availability. B. Oracle Clusterware communication is configured to use the management network. C. The InfiniBand network interfaces on Linux servers are configured using active-

passive bonding. D. Database connections to the SCAN listener route through the Ethernet switch in the

Exadata rack. E. Database servers are deployed with three logical network interfaces configured:

management, client access, and private.



Answer: C,E


QUESTION NO: 6

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

Answer: E Explanation Buy Full Product

QUESTION NO: 7

Identify the correct steps required to upgrade a 1/8th rack of Exadata to a 1/4th rack.

A.

Activate all cores by using a software command.

Activate all hard drives and flash drives. Create the grid disks. Expand the Oracle ASM diskgroups. Review the new configuration.

B.

Remove the doors of the 1/8th rack. Add an additional Sun Datacenter InfiniBand Switch. Add the new servers. Cable the Database Servers in the rack. Cable the Exadata Storage Servers in the rack. Close the rack. Configure the new hardware.



C.

Activate all cores by using a software command. Activate all hard drives and flash drives.

Answer: A


QUESTION NO: 8

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 flash Cache mode to writeback.

B) Inactivate all grid disks and shut down cellsrv.

C) Drop the Flash Cache.

D) Verify that cell for flash cache mode is writeback.

E) Create the Flash Cache.

F) Startup cellsrv and activate all grid disks.

G) Check griddisk 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

Answer: C


QUESTION NO: 9

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 32 to prevent oversubscribing E. The init.org parameter resource_manager_plan should be set.

Answer: C


QUESTION NO: 10

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.

Answer: D,E


QUESTION NO: 11

Identify the relevant steps in the correct order for activating an Auto Service Request

(ASR) configuration.

1. Add SNMP traps manually or using OneCommand.

2. Install ASR Manager.

3. Activate a node on ASR Manager.

4. Validate the configuration.

5. Register ASR Manager with Oracle. A. 2, 5, 1, 3, and 4 B. 2, 4, I, 3, and 5 C. 5, 2, 4, 1, and 3



D. 5, 4, 2, 1, and 3

Answer: A


QUESTION NO: 12

You are going to set up grid disks for your customer. Which is the best practice to use when

defining grid disks for a Storage Server?

A. Create a grid disk for every table space.

B. Create two grid disks, one for data and one for recovery.

C. Create two grid disks, one for tables and one for Indexes.

D. Create a grid disk for each table.

Answer: B


QUESTION NO: 13

Striping data across disk is performed with what software?

A. CELLSRV

B. IORM

C. OEL

D. ASM Answer: D


QUESTION NO: 14

Which three types of classification can you use to prioritize I/O requests with IORM?

A. Based on Database Manager consumer_group

B. Based on an Intradatabase Plan

C. Based on a Category Plan



D. Based on the priority of the background process Answer: A,B,C


QUESTION NO: 15

Which three statements are true with regard to I/O Resource plans?

A. You define inter-database resource plans with Database Resource Manager.

B. You define Intra-database resource plans with Database Resource Manager.

C. You define categories with Database Resource Manager.

D. You enable a category plan with CellCLI. Answer: B,C,D


QUESTION NO: 16

Why is performing an incremental backup of data from an Exadata Storage Server likely faster

than backing up data from normal storage?

A. All data on the Exadata Storage Server is compressed.

B. All backups from the Exadata Storage Server are compressed.

C. Recovery Manager always uses more threads to perform backups from an Exadata Storage

Server.

D. Offload processing finds only the changed blocks.

Answer: D


QUESTION NO: 17 You are asked to install EM 12c agent. Put the following steps in right order. 1. Select operating system

2. Add host target



3. Select add target from setup menu

4. Add target manually

5. Review Provided Information

6. Provide user credentials

7. Deploy Agent

A. 3,4,2,1,6,5,7

B. 1,3,2,4,6,5,7

C. 4,3,2,1,6,5,7

D. 3,2,4,1,6,5,7

E. 3,1,3,2,6,5,7

Answer: A


QUESTION NO: 18

You are asked to integrate Exadata with EM 12c. Put below steps in right order.

1. Discover Exadata component

2. Launch auto discovery

3. Specify component credentials

4. Deploy the management agents (OEM 12c Agent) on compute nodes

5. Review configurations and complete setup

A. 1,4,2,3,5

B. 2,4,2,3,5

C. 4,2,3,5,1

D. 1,3,4,2,5

Answer: C




QUESTION NO: 19

What are three unique benefits of Exadata Storage Server compared to traditional storage

servers?

A. Larger disk sizes

B. Smart storage capabilities

C. Higher storage network bandwidth

D. Higher RAM capacity

E. Integrated database I/O resource management

Answer: B,C,E


QUESTION NO: 20

List three activities which will use exadata storage server features.

A. Tablespace Creation

B. SQL Predicate with where clause

C. Data mining scoring

D. Storage Index

Answer: B,C,D


QUESTION NO: 21

Put below steps in right order to create DBFS file system

1. Mount File System

2. Create Directory

3. Create DBFS file system

4. Grant privileges to user

5. Tablespace Creation

6. User creation

7. Connect to database with created user



A. 5,6,4,7,3,2,1

B. 1,5,6,4,7,3,2

C. 2,5,4,6,3,7,1

D. 2,5,6,4,3,7,1

E. 2,5,6,4,7,3,1

Answer: E


1z0-485 exam questions and answers

Documents