Free 1z0-070 Exam Dumps

Question 11

Which two statements are true about the use of DBFS, ACFS, and external file systems and components in an X5 Database Machine environment?

A. ACFS uses storage in a database on the database machine
B. DBFS supports file system snapshots.
C. ACFS supports file system snapshots.
D. Storage Area Network (SAN) –based file systems may be accessed directly from the storage servers in a database machine.
E. Oracle Sun ZFS Storage Appliance-based files are not automatically protected by Data Guard.

Correct Answer:BC
DBFS SecureFiles Store Capabilities include support for file system snapshots. Oracle ACFS includes advanced features such as file system snapshot. References:
http://www.oracle.com/technetwork/ru/database/dbfs-sf-oow2009-v2-160969.pdf http://www.oracle.com/technetwork/database/database-technologies/cloud-storage/benefits-of-oracle-acfs-23790

Question 12

Which three must be true for a Smart Scan to occur for a table?

A. cell_offload_processing must be true in sessions issuing SQL statements that access the table.
B. The query must be executed serially.
C. The query must be executed in parallel.
D. Direct path reads must be used at run time.
E. The ASM diskgroup containing the table’s tablespace must have a 4 Mbyte AU size.
F. The ASM diskgroup containing the table’s tablespace must have cell.smart_scan_capable set to true.

Correct Answer:ADF
A: pt_param( ‘cell_offload_processing’ ’TRUE’) hint is used to enable the exadata smart scan feature in sql execution process.
D: Direct reads bypass the buffer cache and go directly into the process PGA. Cell offload operations occur for direct reads only.
F: The cell.smart_scan_capable attribute must be set to TRUE.

Question 13

Which three statements are true about Automatic Hard Disk Scrubbing and repair on high-capacity storage servers in an X5 Database Machine?

A. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is clean in the Smart Flash Cache.
B. Hard disks are scanned every two weeks by default but only when disks are idle.
C. Hard disks are scanned every two weeks by default in all situations.
D. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is dirty in the Smart Flash Cache.
E. Disk repair may be made from another mirror copy if the corrupt area is part of a Normal or High Redundancy Disk Group.

Correct Answer:ACE
The default schedule of scrubbing is every two weeks.
References:
http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage-servers.htm

Question 14

Which four are true about Exadata features?

A. Storage Indexes persist across Exadata storage server reboots.
B. Data Warehouse workloads will benefit from Smart Flash Cache configured in Write-Through mode.
C. Hybrid Columnar Compressed tables can be compressed and decompressed on Exadata storage servers.
D. Hybrid Columnar Compressed tables can be compressed and decompressed on the database servers.
E. OLTP workloads will benefit from Smart Flash Cache configured in Write-Back mode.
F. Storage Indexes persist across database server reboots.

Correct Answer:CDEF
CD: That data remains compressed not only on disk, but also remains compressed in the Exadata Smart Flash Cache, on Infiniband, in the database server buffer cache, as well as when doing back-ups or log shipping to Data Guard.
E (not B): Use the Write-Back Flash Cache feature to leverage the Exadata Flash hardware and make Exadata Database Machine a faster system for Oracle Database Deployments. Write-through cache mode is slower than write-back cache mode. However, write-back cache mode has a risk of data loss if the Exadata Storage Server loses power or fails.
F: Storage indexes are not stored on disk; they are resident in the memory of the storage cell servers.

Question 15

Which two are true concerning Columnar Flash Caching?

A. It can be enabled or disabled for individual databases by using I/O Resource Manager database plans.
B. It automatically transforms ROW STORE COMPRESS compressed data into a pure columnar format during Exadata Smart Flash Cache population.
C. Data is either cached in Hybrid Columnar Compressed format or in pure compressed format, but never in both formats at the same time.
D. It is enabled by default.
E. It automatically transforms Hybrid Columnar Compressed (HCC) data into a pure columnar format during Exadata Smart Flash Cache population.
F. It improves single-row lookup performance.

Correct Answer:DE
D: In-Memory Columnar Caching on cells is enabled by default when the INMEMORY_SIZE is configured. You do not need to do anything to get this enhancement.
E: Columnar Flash Caching implements a dual format architecture in Exadata flash by automatically transforming frequently scanned Hybrid Columnar Compressed data into a pure columnar format as it is loaded into the flash cache.