1Z0-485 Online Practice Questions and Answers

Consider this CellCLI command:

CellCLI> CREATE GRIDDISK ALL HARDDISK PREFIX=data, size=423G;

Which two statements describe what happens when you execute this command?

A. It creates one 423 GB grid disk on the first available cell hard disk.

B. It creates one 423 GB grid disk on each available cell hard disk.

C. It creates grid disks on the outermost 423 GB that is available on each hard disk.

D. It creates grid disks on the innermost 423 GB that is available on each hard disk.

E. It creates an Exadata Smart Flash Cache on all flash drives.

Which two statements are true 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.

What are two choices that a customer must make that impact diskgroup creation?

A. What is the level of redundancy required?

B. What OS will be run?

C. Where will disk backups be written?

D. How many databases will run on the cluster?

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

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.

When an Exadata Storage Server hard disk failure alert is received, what manual action must you take to restore the system to full redundancy?

A. Replace the disk and run MegaCLI to rebuild the degenerate mirror.

B. No manual action is required because Automatic Storage Management (ASM) fast mirror resync is automatic

C. No manual action is required because ASM rebalancing is automatic.

D. Replace the disk and manually copy the mirror extents to the new drive.

E. Run RMAN REPAIR FAILURE.

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.

You are concerned about how recovery from a failed Exadata Storage Server would work. Which statement is true about the Exadata CELLBOOT USB?

A. Exadata automatically copies OS binaries and configuration files from another cell during patching to sync the internal USB.

B. Regular Exadata Storage Server patches make sure that the internal USB is updated so that it can be used for recovery.

C. Changes to network configuration files are possible without using ipconf.pl as long as all relevant files are updated.

D. Some space from the CELLBOOT USB is used for cache metadata when write back flash cache is enabled.

E. Each patch that is performed on Exadata storage servers requires manual resync of the CELLBOOT USB.

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 two statements are true about Exadata memory capabilities?

100% Real QandAs | 100% Real Pass

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.