Online Access Free 1z0-485 Exam Questions

What would be the best way to ensure that batch Jobs do not impact performance of online queries that use the same database?

• A.Build a Database Resource Management Plan, giving priority to query workload.
• B.Configure IORM to disable Flash Cache usage for batch workload.
• C.Configure and enable Parallel Query.
• D.Deploy Instance Caging to control batch jobs.
• E.Configure resource plans by using the I/O Resource Manager on the storage cells, giving priority to query workload.

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, 4, I, 3, and 5
• B.5, 4, 2, 1, and 3
• C.5, 2, 4, 1, and 3
• D.2, 5, 1, 3, and 4

Your customer would like to use DBFS in their Exadata environment. They are asking you for the key characteristic of DBFS on Exadata.

• A.DBFS in an Exadata environment is faster than an NFS mount system because of the Smart Scan performance gains.
• B.Tens of thousands of files are the perfect use case for DBFS on Exadata.
• C.DBFS offers tremendous I/O bandwidth.

Which two statements are true about Exadata memory capabilities?

• A.X3-2 memory can be expanded to 512 GB per node from 256 G
• B.X3-2 memory can be upgraded to use Flash in the compute nodes.
• C.X3-8 can be purchased in a Half Rack configuration with 2 TB of memory.
• D.X3-2 can be purchased in a Half Rack configuration with 256 GB per node.
• E.X3-8 memory is fixed at 4 TB per a Rack.

When should you use Hybrid Columnar Compression?

• A.on large active tables where deeper compression is desired
• B.on every table where Advanced Compression is not used
• C.always
• D.on tables or partitions that have fairly static data