1z0-070 Exam Training Practice Tests (Oracle Exadata X5 Administration)]

Question 1

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

Correct Answer: A,B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 2

Which three are true concerning Storage Indexes?

A. The use of Storage Indexes for particular categories of I/O can be displayed by using an I/O Resource Manager Category Plan. B. Storage Indexes persist across any Exadata storage server reboots. C. A maximum of eight table columns for any table are indexed per storage region. D. The use of Storage Indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan. E. A Storage Index is automatically maintained by CELLSRV based on the filter columns of the offloaded SQL. F. Different storage regions may have different columns indexed for the same table.

Correct Answer: C,D,E

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 3

Which two statements are true about the Enterprise Manager plug-in configuration for the X5 Database Machine?

A. All components of the Database Machine require SNMP trap forwarders. B. There are several separate plug-ins for Cloud Control. C. Some components of the Database Machine require SNMP trap forwarders. D. There is one plug-in for Cloud Control.

Correct Answer: C,D

Question 4

You are planning the monitoring configuration for your X5 Database Machine.
Which two components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?

A. the database server Clusterware B. ASM instances C. the Infiniband switches D. the storage server ILOM E. the database server O/S

Correct Answer: C,D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 5

Which three are true concerning Hybrid Columnar Compression (HCC) deployed on Exadata storage?

A. Rows residing in HCC compressed segments, are always self- contained in a single compression unit. B. By default, decompression is performed by Exadata Storage Servers. C. Row-level locks are supported on HCC compressed data. D. HCC can be used only when the Exadata Smart Flash Cache is configured in Write-Through mode. E. Rows residing in HCC compressed segments, are always self- contained in a single database block. F. HCC data is never cached in the Exadata Smart Flash Cache.

Correct Answer: A,B,C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 6

You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your X6 Database Machine. The Database Machine database version is 11.2.
You plan to perform a physical database migration using Transportable Database.
Which two are requirements for this method?

A. The source database must be deployed on a Little Endian platform, B. The source database must be at least 11.2. C. The source database must be deployed on a Big Endian platform. D. The source database must use only bigfile tablespaces. E. The source database must not use bigfile tablespaces. F. The source database must be at least 11.1.

Correct Answer: A,B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 7

You plan to migrate a very large database supporting a DSS workload to your new X5 Database Machine.
It will be the only database on this full rack.
Which three statements are true about Database Machine features that improve performance for the DSS workload?

A. Full table scan operations can improve due to the default Smart Flash Cache implementation. B. Smart Storage operations can improve the performance of joins. C. Hybrid Columnar Compression can reduce the amount of physical I/O required to scan large tables. D. Hybrid Columnar Decompression overheads can be offloaded from the database servers for index full scans. E. Smart Storage operations can improve the performance of scans.

Correct Answer: A,D,E

Question 8

You plan to consolidate your company's INVENTORY and SALES databases onto your new Exadata X6 Database Machine.
You are considering consolidation of all schemas into one RAC database.
Which three factors would you need to consider before choosing this approach?

A. the number of simultaneous sessions B. the number of database roles C. Security Policies D. the number of database users E. the maintenance schedule

Correct Answer: A,C,D

Question 9

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

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Oracle Exadata X5 Administration - 1z0-070 Exam Practice Test