1Z0-485 Online Practice Questions and Answers

Which is the best location to point your customer to, for finding the latest Exadata patches?

A. owner's guide

B. Patch database in MyOracle Support

C. MyOracle Support note 888828.1

D. MyOracle Support for database patches, ULN for OS patches, and Sun Support for Server and InfiniBand patches.

Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?

A. INSERT

B. INSERT with an APPEND hint

C. UPDATE

D. CREATE TABLE AS SELECT

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

100% Real QandAs | 100% Real Pass

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

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.

In looking to improve query performance for your Data Warehouse, select the best way that Exadata's Flash Cache feature can be leveraged?

A. Enable Smart Flash Log.

B. Execute alter table ... cell_flash_cache=keep on heavily scanned tables.

C. Enable Write Back Flash Cache.

D. Create an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.

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.

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

A. Remove the doors of the 1/8th rack. Add the new servers. Cable the Database Servers in the rack. Cable the Exadata Storage Servers in the rack. Close the rack.

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

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

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

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

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.

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.