1z0-070 Free Practice Test

As part of planning for database consolidation, you grouped your databases into two categories based on different technical and business objectives.
Which three statements are true about possible configurations for your Exadata X6 Database Machine fabric?

1. A. The storage grid may be partitioned when deploying a single-rack Database Machine configuration using virtualization.
2. B. The database grid may be partitioned when deploying a multirack Database Machine configuration.
3. C. A single database cluster benefits from accessing multiple storage grids.
4. D. Multiple database clusters may access the same storage grids.
5. E. Multiple database clusters never benefit from accessing a single storage grid.

Correct Answer: BCD

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

1. A. to implement storage realms so that storage that can be reserved for specific resource consumer groups in the same database
2. B. to enable the creation of normal or high redundancy ASM diskgroups
3. C. to segregate storage into multiple pools with different performance characteristics
4. D. to enable disk mirroring for the system area
5. E. to implement storage realms so that storage can be reserved for specific databases
6. F. to implement storage realms so that storage that can be reserved for specific Grid Infrastructure

Correct Answer: BCF
Creating multiple grid disks per cell disk allows you to create multiple pools of storage on the same Exadata Storage Server. The multiple grid disks can be assigned to separate ASM diskgroups, which can be provisioned to different databases.
Note: Griddisk is a logical disk that can be created on a celldisk. In a standard Exadata deployment we create griddisks on hard disk based celldisks only. While it is possible to create griddisks on flashdisks, this is not a standard practice.
F: After you complete the cell configuration, you can perform the following optional steps on the storage cell:
References:https://docs.oracle.com/cd/E80920_01/SAGUG/SAGUG.pdf

Which three are true concerning Exadata Smart Flash Cache on X6 Database Machines with High Capacity Storage Servers?

1. A. The “keep” cache is limited to a maximum of 80% of the total Smart Flash Cache capacity.
2. B. Smart Scan will always use the Smart Flash Cache for all I/Os fast full index capacity.
3. C. Smart Scan will always use the Smart Flash Cache for all I/Os for full table scans.
4. D. Single block reads can benefit from Smart Flash Cache.
5. E. Multiblock reads can benefit from Smart Flash Cache.

Correct Answer: BDE
D: By default Exadata stores only small I/Os in the Exadata Smart Flash Cache. Small I/Os in most cases are single-block reads. During a full table scan Oracle requests blocks in multiblock lumps (by default 16 blocks), and these are

Which two must be true for a Smart Scan to occur on a table?

1. A. Sessions querying the table must set cell_offload_processing = true.
2. B. It must be stored in an ASM diskgroup with a 4MByte AU size.
3. C. It must be heap organized.
4. D. It must be accessed using direct path reads.
5. E. The table must not be compressed.

Correct Answer: AD

Which two statements are true about Auto Service Request (ASR) with an X5 Database Machine?

1. A. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
2. B. Configuring ASR is mandatory for all Database Machine assets.
3. C. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
4. D. ASR Manager must be installed and configured on one of the database servers.
5. E. ASR can upload configuration metadata to support problem resolution.
6. F. ASR communicates with Oracle support services using HTTPS.

Correct Answer: AC
A: Oracle recommends that you install Oracle ASR Manager on an external, standalone server.
C: Oracle ASR is designed to generate Oracle service requests automatically when certain types of faults are detected on Oracle products that are qualified for Oracle ASR.
Oracle ASR works only for specific component faults. Most of the common components, such as disks, fans, and power supplies, are covered. However, some components are not covered. For example, Oracle ASR does not cover InfiniBand events; there are specific images and specific InfiniBand switch firmware that you must use. You cannot upgrade these components independently.