1z0-070 Free Practice Test

Which three storage components are available after nonvirtualized standard deployment of an X5 Database Machine using high-capacity disks?

1. A. mirrored system area on hard disk 0, hard disk 1, and hard disk 2
2. B. Exadata Smart Flash Cache using all of the flashdisk space
3. C. the DBFS_DG diskgroup with high redundancy
4. D. mirrored system area on hard disk 0 and hard disk 1
5. E. the RECO_ ASM diskgroup
6. F. the DATA_ ASM diskgroup

Correct Answer: CEF
The first two disks of Exadata Storage Server are system disks. Oracle Exadata Storage Server Software system software resides on a portion of each of the system disks. These portions on both system disks are referred to as the system area.
The default configuration on Exadata is to have 3 diskgroups - DATA, RECO, and DBFS_DG.

You plan to monitor the status of the motherboard, memory, power, fans, and network
cards on the database nodes in your Exadata X6 Database Machine using Enterprise Manager.
Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in Enterprise Manager?

1. A. No thresholds need to be set because they are present in the ILOM and in Enterprise Manager.
2. B. Set thresholds in ILOM and in Enterprise Manager because they are not present anywhere and must be set in both places.
3. C. Set thresholds only in ILOM because they are not preset anywhere but need to be set only in ILOM.
4. D. No thresholds need to be set because they are preset in the ILOM and these are sufficient for monitoring.

Correct Answer: D

Which two are true concerning Columnar Flash Caching?

1. A. It can be enabled or disabled for individual databases by using I/O Resource Manager database plans.
2. B. It automatically transforms ROW STORE COMPRESS compressed data into a purecolumnar format during Exadata Smart Flash Cache population.
3. C. Data is either cached in Hybrid Columnar Compressed format or in pure compressed format, but never in both formats at the same time.
4. D. It is enabled by default.
5. E. It automatically transforms Hybrid Columnar Compressed (HCC) data into a pure columnar format during Exadata Smart Flash Cache population.
6. F. It improves single-row lookup performance.

Correct Answer: DE
D: In-Memory Columnar Caching on cells is enabled by default when the INMEMORY_SIZE is configured. You do not need to do anything to get this enhancement.
E: Columnar Flash Caching implements a dual format architecture in Exadata flash by automatically transforming frequently scanned Hybrid Columnar Compressed data into a pure columnar format as it is loaded into the flash cache.

Which three statements are true regarding the configuration of Auto Service Request (ASR) on an X5 Database Machine?

1. A. ASR Manager may be installed on any type of server running Oracle Solaris.
2. B. ASR Manager may be installed on any type server running Oracle Linux.
3. C. Oracle Linux must be used on the server where ASR Manager is installed.
4. D. SMTP must be enabled on at least one database server.
5. E. Oracle Solaris must be used on the server where ASR Manager is installed.
6. F. ASR Manager must be installed on one of the database servers.
7. G. HTTPS connectivity must be enabled from the ASR Manager host to the Internet.

Correct Answer: ABG
AB: Oracle recommends that you install Oracle ASR Manager on an external, standalone server. This server receives fault telemetry information from Oracle Exadata Database Machine servers. This server must run an Oracle Solaris or Linux operating system.
G: Before installing Oracle Auto Service Request (Oracle ASR) you must ensure connectivity to the Internet using HTTPS.
References:Oracle Auto Service Request Exadata Database Machine Quick Installation Guide
http://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm#GUID-89192315-1B1A-4B5A-89BB-94BB5B6ABB05

Which three statements are true about Exadata storage server alerts in an X5 Database Machine?

1. A. Storage server alerts notifications may be sent using SNMP.
2. B. A threshold- based alert gets cleared automatically when the measured value no longer violates the threshold.
3. C. A storage server alert is only ever issued as a warning or at a critical situation.
4. D. Storage server alerts are all stateless alerts.
5. E. Storage server alerts are all stateful alerts.
6. F. Storage server alerts notifications may be sent using SMTP.

Correct Answer: ACF
Exadata cell (storage server) alerts can be delivered using SMTP or SNMP or both.
Although there are three types of storage alerts: informational, warning and critical, they are issued when threshold metrics reached either to warning or critical.