1z0-070 Free Practice Test

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?

1. A. 0, because the new griddisks will be added to the existing failgroups
2. B. 12, consisting of seven griddisks each
3. C. 96, consisting of seven griddisk each
4. D. 7, consisting of 12 griddisks each
5. E. 1, consisting of all 96 griddisks

Correct Answer: D
The number of failure groups equals the number of Exadata Cells. Each failure group is composed of a subset of grid disks in the Oracle ASM disk group that belong to a single storage cell.
References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-administering-asm.htm

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.

1. A. Virtualized Computer Node configuration
2. B. OS users that own the Grid Infrastructure installation
3. C. Cluster configuration for up to 32 clusters
4. D. The size for the system area on the first two disks in each cell
5. E. Virtualized Storage node configuration

Correct Answer: ACD
Oracle Exadata Deployment Assistant has two main phases
Oracle Exadata Deployment Assistant can configure Oracle Exadata Database Machine, Recovery Appliance, or Oracle SuperCluster.
References: https://docs.oracle.com/cd/E55822_01/AMOGD/configurator.htm#AMOGD22056 https://www.toadworld.com/platforms/oracle/w/wiki/11469.oracle-exadata-deployment- assistance-oeda

Which components of an Exadata storage server image, if updated, may require that a patch also be applied to the database servers in an Exadata X6 Database Machine?

1. A. Linux operating system on the storage server
2. B. InfiniBand HCA firmware on the storage server
3. C. Storage server hard disk device drivers
4. D. Storage server flash device drivers

Correct Answer: D
Exadata patches are intended for and include fixes for both the storage servers and Compute servers, and optionally InfiniBand switches.
Patching order
You should patch the Exadata Database Machines in the following sequence
References: https://www.toadworld.com/platforms/oracle/w/wiki/11640.oracle-exadata- patching

Which two are true about the allocation of I/O resources by IORM within the CELLSRV process?

1. A. Database Writer I/O always prioritized over all user I/O.
2. B. If two consumer groups P and Q in the PROD database get 20% and 10% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 10% and 5% respectively, and the interdatabase plan has changed, provided that the category plan is unchanged, and consumer groups P and Q are still mapped to the same categories.
3. C. If two consumer groups C and D in the PROD database get 10% and 15% respectively, of resource allocation, then the percentage of I/O resource would be the same if they still got 10% and 15% respectively, and were remapped to a different category by the DBA, provided that the category plans and the interdatabase plans are unchanged.
4. D. If two consumer groups A and B in the PROD database get 10% and 15% respectively, of resource allocation, then the percentage of I/O resource would be the same if they got 20% and 30% respectively, provided that the category plans and interdatabase plans are unchanged, and consumer groups A and B are still mapped to the same category.
5. E. Log Writer I/O and Control File I/O are always prioritized over all user I/O.

Correct Answer: BE
B: Rules in an interdatabase resource plan specify allocations to databases, not consumer groups.
E: Redo and control file writes always take precedence. References:

Which three are sources for alerts from storage servers in an X5 Database Machine?

1. A. Software errors reported by the MS process on the storage servers
2. B. Hardware sensor alerts reported by the CELLSRV process on the storage servers
3. C. Software errors reported by the RS process on the storage servers
4. D. Hardware sensor alerts detected by the ILOM on the storage servers
5. E. Metrics that have administrator-defined thresholds on the storage servers

Correct Answer: ABE
AB: The Management Server (MS) process receives the metrics data from CELLSRV, keeps a subset of metrics in memory, and writes to an internal disk-based repository hourly. In addition, the MS process can generate alerts for important storage cell hardware or software events.