Identify two reasons why using external tables for high performance data loads on Exadata is more advantageous than SQL*Loader. A. Transformations can be applied directly on the file data using SQL or PL/SQL constructions. B. External tables allow transparent parallelization…
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…
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…
What are the three customer options for hosting the Platinum Services Advanced Support Gateway? A. Install on Exadata Engineered System. B. Provide individual x86 64-Bit gateway hardware. C. Install in Oracle Virtual Machine with required hardware. D. Install on Oracle…
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…
Which statement is true about Oracle compression? A. A non-partitioned table can use Advanced Compression and Hybrid Columnar Compression concurrently. B. A partitioned table can define the use of Advanced Compression or Hybrid Columnar Compression for each partition. C. Hybrid…
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…
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 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…
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…