Oracle 1z1-070 Value Pack (Frequently Bought Together)

You plan to migrate a database supporting both DSS and OLTP workloads to your new X5 Database Machine.
The workloads contain many complex aggregating functions and expensive joins on large partitioned tables in the DSS workload and indexed access for OLTP workloads.
Which three benefits accrue as a result of this migration?

• A. Superior compression capability designed specifically for data warehouse tables
• B. Superior compression capability designed specifically for OLTP workloads
• C. Cell offload processing for indexed-organized table access
• D. Superior flash cache compression technique
• E. Superior compression capability designed specifically for archival data
• F. Columnar storage capability for data in row major data blocks that is held in flash cache

You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli:
alter iormplan objective = off
alter iormplan active
There are no database or category plans defined.
You are suffering I/O performance problems at certain times, which vary by day and week.
DSS and batch workloads perform well, but your OLTP workloads suffer poor response times when running at the same time as these other workloads.
You must ensure that DSS and batch workloads retain relatively high throughput without causing excessive degradation of OLTP performance.
Which statement would you issue to all Exadata Storage Servers to achieve this?

• A. alter iormplan objective = auto
• B. alter iormplan objective = high_throughput
• C. alter iormplan objective = low_latency
• D. alter iormplan objective = balanced

Which two statements are true about the use of Intelligent Platform Management Interface (IPMI) on an X5 or X6 Database Machine?

• A. IPMI can be used for server configuration and management on each storage server.
• B. The Baseboard Management Controller (BMC), which supports IPMI, runs as a multithreaded process on the storage server O/S.
• C. IPMI can be used for server configuration and management on each database server.
• D. The Baseboard Management Controller (BMC), which supports IPMI, runs as a single-threaded process on the storage server O/S.

You plan to migrate a database supporting an OLTP workload to your new X5 Database Machine.
The current database instance supports a large number of short duration sessions and a very high volume of short transactions.
Which three X5 Database Machine features can improve performance for this type of workload?

• A. Reduced I/O latency for reads due to read flashcache on all Exadata X5 and later models
• B. Reduced I/O latency for writes due to writeback flashcache on all Exadata X5 and later models
• C. Faster optimization due to an Exadata-specific optimizer
• D. Ultra high I/O performance for reads and writes when using Exadata Extreme Flash in X5 and later models
• E. An improved highly efficient undo and redo architecture

Which two statements are true about Exadata X5 cell metrics and alerts?

• A. Cell alerts on each storage server are accumulated in memory by the CELLSRV process and stored on a filesystem-based repository.
• B. Cell metrics on each storage server are accumulated in memory by the CELLSRV process and written to a filesystem-based repository.
• C. Cell alerts are written to disk every hour by default.
• D. Cell metrics are written to disk every hour by default.
• E. Cell alerts on each server are accumulated in memory by the MS process and stored on a filesystem-based repository.