1Z0-485 Online Practice Questions and Answers

Identify three best practices for applying asmdeactivationoutcome es on Exadata Database Servers and Exadata Storage Servers?

A. Backing up database servers and storage cells is not recommended before performing planned maintenance.

B. Database server updates can be rolled back using the the "yum downgrade" procedure.

C. Bundle patches do not require testing before being installed on a production system.

D. It is recommended that Exadata systems with Data Guard configured use the "Standby First" patching approach.

E. Patching should never be interrupted due to a connection drop. It is therefore recommended that you use VNC or the screen utility.

F. Before patching cells in a rolling manner, you must check asmdeactivationoutcome amModestatus and make sure that cells on all disks are online and that disks can be deactivated.

Your customer wants to increase the size of the DATA diskgroup 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 diskgroup to DATA

D. adding a ZFS storage appliance

E. adding a High Performance Storage expansion rack

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.

Which statement is true about Exadata Storage Servers?

A. The Exadata Storage Server automatically deletes old diagnostic and metric files.

B. Exadata requires a running database instance on all storage servers and database servers.

C. Redundancy for user data stored in a database that is running on Exadata is achieved with RAID5.

D. Communication between a database and an Exadata storage flows over low latency 10 Gigabit Ethernet.

E. Exadata uses network affinity to determine which storage server data is written. 100% Real QandAs | 100% Real Pass

100% Real QandAs | 100% Real Pass

Which statement is true about the patching features provided in Platinum Services?

A. Patching services are available for the full software stack up to twice per year.

B. Patching support includes Exadata, Exalogic, and Database Appliance.

C. Rolling window and complete down time approaches are two options to patching.

D. Platinum covers Exadata storage software and firmware patching, but the customer must perform database patching.

Storage indexes are unique to the Exadata Database Machine and their primary goal is to reduce the amount of I/O required to service I/O requests for Exadata Smart Scan. Put the following steps in order:

1.

The Exadata cell services software conducts I/O requests on I MO storage regions.

2.

cellsrv checks the high and low values, and determines the storage region does not contain any values meeting the predicate.

3.

The database is started.

4.

Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage.

5.

A query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=1500.

6.

A subsequent query is Issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.

7.

MYOBJ_STATE'S region index is populated with high and low values for the OBJECT_ID column during the I/O request.

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

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

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

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

Which two migration will result in the least down time for a physical or logical migration of a database with active users during the migration?

A. using GoldenGate

B. using SQL Developer migration tools

C. using Data Guard Physical Standby

D. using cross-platform transportable tablespaces

E. using incremental cross-platform RMAN restore

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.

100% Real QandAs | 100% Real Pass

A. LVM snapshots are not configured properly on the Database Server.

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

C. The number of tape drives is causing a bottleneck.

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

E. The number of database servers is causing a bottleneck.

Which statement is true about Enterprise Manager 12c for Exadata?

A. EM Agents are installed on each database and storage node.

B. EM Agents should not be installed on Exadata. Remote monitoring is the best practice.

C. EM Agents can communicate to storage cells via SSH.

D. The Exadata Plug-In for monitoring switches is installed in each EM Agent.

E. Storage cells communicate directly to the EM Management Server via SNMP and/or SMTP.

Identify a recommended configuration to set up Auto Service Request (ASR) for Exadata.

A. Install ASR Manager on Exadata Database Server.

B. Install ASR Manager on Exadata Storage Server.

C. ASR is not recommended for Exadata; the Oracle Configuration Manager is preferred.

D. Install ASR Manager on a Standalone Server.

Which three migration options are available when you migrate a database from the Big Endian format system to Exadata?

A. Data Pump Export and Import

B. transportable database

C. transportable tablespaces

D. Data Guard

E. Insert as Select

Why is ASM High redundancy an important configuration choice when rolling Exadata Storage Server patching is planned?

100% Real QandAs | 100% Real Pass

A. High redundancy protects from partner disk failure while a cell is offline being updated.

B. High redundancy forces ASM rebalance before allowing disks to be taken offline.

C. High redundancy speeds up ASM fast mirror resync when a cell is brought back online after patching.

D. Normal redundancy provides the same protection during rolling patching, so High redundancy is not important in this case

When running OS Watcher, which two data outputs are valid for Exadata storage cell performance analysis? Select the two correct choices that apply?

A. lostat

B. mpstat

C. netstat

D. pkginfo

E. label

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 storage cells, giving priority to query workload.

When using IORM, which statement accurately describes when redo log file writes take place?

A. Based on the priority of the user

B. Immediately

C. Based on the resource group of the user

D. Based on the intradatabase resource plan