1z0-070 Free Practice Test

Identify two supported modifications to an X5 Database Machine.

1. A. installing a Host Bus Adapter (HBA) in the compute nodes
2. B. installing additional Operating System (O/S) packages on the computer nodes
3. C. installing additional Operating System (O/S) packages on the Exadata storage servers
4. D. installing a Host Bus Adapter (HBA) in the storage servers
5. E. replacing the Cisco Ethernet switch with another make or model
6. F. replacing the Infiniband switches with another make or model

Correct Answer: BD
B: Updating Exadata Database Servers (compute nodes).
The software and firmware components that are updated for a specific release depend on the current Exadata software release the database server is running and the release you are updating to. Linux operating system packages and Exadata software are always updated while firmware may be updated for only a small selection of the components or not at all.
D: The storage cells (storage servers/nodes) contain HBAs, and spare PCI I/O slots. References:https://docs.oracle.com/cd/E41033_01/html/E55032/bbgiabie.html
http://docs.oracle.com/cd/E80920_01/DBMMN/updating-exadata-software.htm#DBMMN-
GUID-AB25ED9A-7920-441A-9A60-14ED2753B01C

You plan to consolidate your company’s INVENTORY and SALES databases onto your new Exadata X6 Database Machine.
You are considering consolidation of all schemas into one RAC database. Which three factors would you need to consider before choosing this approach?

1. A. the number of database users
2. B. Security Policies
3. C. the number of database roles
4. D. the number of simultaneous sessions
5. E. the maintenance schedule

Correct Answer: ABD

Which three are recommended options on an X5 Exadata Database machine, for staging files that will be loaded as external tables?

1. A. on an ACFS file system stored in a staging database on the Database Machine
2. B. a ZFS over NFS file system mounted on a database server where the external table will be accessed
3. C. an Exadata-based ACFS file system on the Database Machine
4. D. a DBFS file system stored in a staging database on the Database Machine
5. E. on local storage on one or more storage servers that are accessible to the database server where the load will be performed

Correct Answer: ABE

Which two statements are true about Exadata X5 cell metrics and alerts?

1. A. Cell alerts on each storage server are accumulated in memory by the CELLSRV process and stored on a filesystem-based repository.
2. B. Cell metrics are written to disk every hour by default.
3. C. Cell metrics on each storage server are accumulated in memory by the CELLSRV process and written to a filesystem-based repository.
4. D. Cell alerts on each server are accumulated in memory by the MS process and stored on a filesystem-based repository.
5. E. Cell alerts are written to disk every hour by default.

Correct Answer: BD
Metrics are a series of measurements that are computed and retained in memory for an interval of time, and stored on a disk for a more permanent history.
On the storage servers, the CELLSRV process provides the majority of Oracle Exadata storage services and is the primary storage software component. One of its functions is to process, collect, and store metrics. 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.
References:http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em12-2291964.html

Which two are true about Smart Scan?

1. A. A query rewrite may occur to a materialized view stored in Exadata, and it will always benefit from Smart Scan.
2. B. Column projection does not contribute to the performance benefit of Smart Scan.
3. C. A query rewrite may occur to a materialized view stored in Exadata but will never benefit from Smart Scan.
4. D. It is possible to offload single row functions to the Exadata Storage Servers.
5. E. Join processing can be partly offloaded to Exadata Storage Servers.
6. F. Join processing can be fully offloaded to Exadata Storage Servers.

Correct Answer: DE
D: With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.
E: With Smart Scan processing, row filtering, column filtering, some join processing, and other functions are performed in the Exadata cells.
References:http://www.centroid.com/blog/exadata-smart-scan-processing