Oracle Exadata X5 Administration (1z0-070) Free Practice Test

Question 1

Identify three valid configuration options that can be implemented during the initial configuration process of a new X5 Database Machine by using the Exadata Deployment Assistant.

A. Virtualized Storage node configuration

B. Virtualized Compute Node configuration

C. The size for the system area on the first two disks in each cell

D. OS users that own the Grid Infrastructure installation

E. Cluster configuration for up to 32 clusters

Correct Answer: B,C,E

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

Question 2

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. Storage Area Network (SAN) -based file systems may be accessed directly from the storage servers in a database machine.

D. ACFS supports file system snapshots.

E. Oracle Sun ZFS Storage Appliance-based files are not automatically protected by Data Guard.

Correct Answer: B,D

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

Question 3

In which scenario will griddisks residing on the same celldisk have balanced performance characteristics in an X5 High Capacity Exadata Storage Server?

A. griddisks on hard disk-based celldisks consumed by the Database Smart Flash Cache

B. griddisks on hard disk-based celldisk consumed by ASM when creating diskgroups using ASM-based Intelligent Data Placement (IDP)

C. griddisks on Flash-based celldisks

D. griddisks on memory based celldisks

Correct Answer: B

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

Question 4

Your X6 Exadata Database Machine is running Oracle Database 12c, and has a large database with some very large tables supporting OLTP workloads.
High-volume insert applications and high-volume update workloads access the same tables.
You wish to compress these tables without causing unacceptable performance overheads to the OLTP workload.
Which three are true regarding this requirement?

A. Using row store compress advanced will compress the data more than if using column store compress for archive low.

B. Compression is performed on Exadata Storage Servers when using row store compress advanced in an Exadata environment.

C. Compression is performed on database servers when using row store compress advanced in an Exadata environment.

D. Using row store compress advanced will compress the data less than if using column store compress for query low.

E. The compression method column store compress for archive high is the worst fit for this requirement.

Correct Answer: A,B,C

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

Question 5

You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 Exadata Database Machine.
You decide to examine the relevant metrics on all the cells, to see whether the I/O rate has improved for this category compared to last week, and whether waits and wait time have been reduced.
You issue this command on the first cell:

You examine the output from the first cell which contains:

Which two sets of metrics would you use to determine whether the I/O performance has improved for the OLTP category for the duration of the one-hour measurement period?

A. CT_IO_UTIL_SM and CT_IO_UTIL_LG

B. CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC

C. CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ

D. CT_IO_RQ_SM, CT_IO_RQ_LG, CT_IO_RQ_SM_SEC, and CT_IO_RQ_LG_SEC

Correct Answer: C

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 use only bigfile tablespaces.

B. The source database must be deployed on a Big Endian platform.

C. The source database must be at least 11.1.

D. The source database must be deployed on a Little Endian platform,

E. The source database must not use bigfile tablespaces.

F. The source database must be at least 11.2.

Correct Answer: D,F

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

Question 7

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 Infiniband switches

B. ASM instances

C. the database server Clusterware

D. the storage server ILOM

E. the database server O/S

Correct Answer: A,D

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

Question 8

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 writes due to writeback flashcache on all Exadata X5 and later models

B. Faster optimization due to an Exadata-specific optimizer

C. An improved highly efficient undo and redo architecture

D. Ultra high I/O performance for reads and writes when using Exadata Extreme Flash in X5 and later models

E. Reduced I/O latency for reads due to read flashcache on all Exadata X5 and later models

Correct Answer: A,C,D

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

Welcome to TestSimulate

Oracle Exadata X5 Administration (1z0-070) Free Practice Test