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.

You are in the process of upgrading your X5 Database Machine half rack to a full rack.

The new storage servers are called DM01CEL08 through DM01CEL14.

After creating 96 new griddisks, you issued this SQL statement: How many failgroups if any, will be added to the DATA diskgroup by executing this SQL statement?

A. 0, because the new griddisks will be added to the existing failgroups

B. 12, consisting of seven griddisks each

C. 96, consisting of seven griddisk each

D. 7, consisting of 12 griddisks each

E. 1, consisting of all 96 griddisks

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.

You are designing the monitoring architecture and procedures for an X5 Database Machine fabric consisting of two full racks, to provide for the monitoring for all components on the critical path of the admin network.

Which two components need to be monitored?

A. the Infiniband leaf switches

B. the power distribution units

C. the Cisco 48 port Catalyst Ethernet Switch

D. the InfiniBand spine switches

Because of a motherboard failure on an X6 high-capacity Exadata storage server, you must replace the server chassis with a replacement unit.

Which are three of the components must you move from the original Exadata storage server to the new Exadata storage server?

A. Redundant power supplies

B. The host bus channel adaptor

C. The USB flash drive

D. The four Sun Flash Accelerator PCIe cards

E. The 12 physical disks

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

A. HCC can be used only when the Exadata Smart Flash Cache is configured in Write-Through mode.

B. HCC data is never cached in the Exadata Smart Flash Cache.

C. By default, decompression is performed by Exadata Storage Servers.

D. Rows residing in HCC compressed segments, are always self- contained in a single database block.

E. Rows residing in HCC compressed segments, are always self- contained in a single compression unit.

F. Row-level locks are supported on HCC compressed data.

You plan to partition the database and storage grids in an X5-2 full rack, creating two clusters and two storage grids without using virtualization.

One cluster will be used for production and should consist of six database servers and nine storage servers.

The other cluster will be used for test and development, and should consist of two database servers and five storage servers.

The storage must be partitioned so that the storage servers are visible only to the appropriate database servers that are meant to access them.

What must be done to achieve this?

A. Configure Exadata realms using Oracle ASM-scoped security mode.

B. Configure Exadata realms using Database–scoped security mode.

C. Edit the CELLIP.ORA file on each database server to contain IP addresses of storage servers in the storage grid associated with the cluster to which that database server belongs.

D. Edit the CELLINIT.ORA file on each database server to contain IP addresses of storage servers in the

storage grid associated with the cluster to which that database server belongs.

E. Edit the CELLIP.ORA file on each database server to contain IP addresses of database servers which are allowed access to specific storage servers in the same storage grid.

F. Edit the CELLIP.ORA file on each storage server to contain IP addresses of database servers in the database server grid that are associated with the storage grid to which that storage server belongs.

Which two statements are true about the Integrated Lights Out Manager (ILOM) on an Exadata X5 or X6 Database Machine?

A. ILOM on database servers can use IPMI to send sensor alerts to an Enterprise Manager Agent.

B. ILOM on a storage server uses SNMP to send sensor alerts to the cellsrv process on the same storage server.

C. ILOM on a storage server uses IPMI to send sensor alerts to the MS process on the same storage server.

D. ILOM on a storage server uses SNMP to send sensor alerts to the MS process on the same storage server.

E. ILOM on database servers can use SNMP to send sensor alerts to an Enterprise Manager Agent.

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.

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