1Z0-070 Online Practice Questions and Answers

Batch and DSS workloads on your Exadata X6 Database Machine are causing performance problems for OLTP workloads at certain times of the day.

There are five RAC databases performing OLTP I/O. Two of them also perform batch I/O. There is another RAC database that performs only DSS I/O.

You are asked to resolve this problem so that the OLTP workload will not suffer when competing with the batch or DSS workloads.

You decide to use the I/O resource manager.

Which is the best way to solve this problem?

A. Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to create the OLTP category and map all OLTP-oriented consumer groups in all databases to it.

B. Use the Database Resource Manager to give the OLTP category the highest priority and use EXADCLI calling EXACLI to create the OLTP category on all the cells.

C. Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to give the OLTP consumer group the highest priority on all databases.

D. Create a database plan using EXADCLI calling EXACLI to give OLTP I/O the highest priority from all six databases.

Identify three valid reasons for creating multiple griddisks on a single harddisk-based celldisk.

A. to implement storage realms so that storage that can be reserved for specific resource consumer groups in the same database

B. to enable the creation of normal or high redundancy ASM diskgroups

C. to segregate storage into multiple pools with different performance characteristics

D. to enable disk mirroring for the system area

E. to implement storage realms so that storage can be reserved for specific databases

F. to implement storage realms so that storage that can be reserved for specific Grid Infrastructure clusters

You are evaluating the performance of a SQL statement that accesses a very large table. You run this query:

Identify two reasons why the “cell physical IO interconnect bytes” statistic is greater than the “cell physical IO interconnect bytes returned by smart scan” statistic.

A. There is a transaction, which committed after the query began, that has modified some of the table blocks, causing some “cell single block physical reads”to be requested by the database instance, resulting in additional I/O.

B. There are chained rowsin the table, causing some “cell single block physical reads”to be requested by the database instance, resulting in additional I/O.

C. The table is a hash clustered table, causing “cell multiblock physical reads”to be requested by the database instance, resulting in additional I/O.

D. The table is list partitioned, causing “cell list of blocks physical reads”to be requested by the database instance, resulting in additional I/O.

E. There is a local index ona list partitioned tableon the column used in the WHERE clause, causing “cell list of blocks physical reads”to be requested by the database instance, resulting in additional I/O.

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.1.

C. The source database must be at least 11.2.

D. The source database must use only bigfile tablespaces.

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

F. The source database must not use bigfile tablespaces.

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 Compute Node configuration

B. OS users that own the Grid Infrastructure installation

C. Cluster configuration for up to 32 clusters

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

E. Virtualized Storage node configuration

You are examining your Exadata storage servers for routine maintenance requirements and run the imageinfo command as shown:

[root@excel04 ~] # imageinfo

Kernel version: 2.6.18-194.3.1.0.4.el5 #1 SMP Sat Feb 19 03:38:37 EST 2011 x86_64 Cell version: OSS_11.2.0.3.0_LINUX.X64_110429.1 Cell rpm version: cell-11.2.2.3.1_LINUX.X64_110429.1-1

Active image version: 11.2.2.3.1.110429.1Active image activated: 2011-05-09 16:26:36 -0400Active image status: successActive image partition on device: /dev/md6Active software partition on device: /dev/md8

In partition rollback: Impossible

Cell boot usb partition: /dev/sdm1Cell boot usb version: 11.2.2.3.1.110429.1

Inactive image version: 11.2.1.2.6Inactive image activated: 2010-10-04 23:59:16 -0400Inactive image status: successInactive system partition on device: /dev/md5Inactive software partition on device: /dev/md7

Boot area has rollback archive for the version: 11.2.1.2.6 Rollback to the inactive partitions: Possible

Which two statements are true about the software and system partitions?

A. /dev/md6 and /dev/md8 have one of their mirror copies on physicaldisk 1

B. /dev/md6 and /dev/md8 are located only on physicaldisk 1

C. /dev/md5 and /dev/md7 have one of their mirror copies on physicaldisk 0

D. /dev/md5 and /dev/md7 are located only on physicaldisk 0

A file contains a script with several EXACLI commands that must be executed on each cell in an X5 full rack.

The script must run on each cell simultaneously.

How would you achieve this?

A. Copy the script to all cells using the DCLI command and manually execute it on each cell using the DCLI command.

B. Copy the script to the cells using the EXACLI command and execute the script on all cells using the EXACLI command.

C. Execute it on all cells using the EXADCLI command specifying the file name containing the EXACLI script.

D. Copy the script to all cells using the CELLCLI command and execute it on all cells in parallel using the CELLCLI command.

E. Execute it on all cells using the DBMCLI command specifying the file name containing the EXACLI script.

Which three factors should you consider when choosing a method for migrating a database to the X5 Database Machine?

A. The down time allowed for the migration

B. Endian format of the source database

C. Number of tablespaces in the source database

D. The type of database workloads

E. Size of the source database

You want to use Enterprise Manager to monitor the power distribution units (PDUs) in your Database Machine.

On which three factors do the appropriate alarm thresholds for the plug-in depend?

A. voltage and phase type of the PDUs

B. disk types within the storage servers

C. Database Machine server models for both the storage servers and database servers in the rack

D. Database Machine rack size and variants

E. disk types within the expansion racks

F. distance between racks for multirack configurations

Identify three facilities that can use X5 Extreme Flash Exadata Storage Server flashdisk space.

A. Cell System Area

B. Exadata Smart Flash Cache

C. Database Smart Flash Cache

D. cell boot flash image

E. Exadata Smart Flash Log