Which four statements are true concerning the configuration or use of Enterprise Manager Cloud Control to monitor and manage Exadata Database Machine components?

Computer nodes forward their SNMP traps to the Management Server process on the same computer node.

Storage nodes forward their SNMP traps to the Management Server process on the same storage node.

Cloud control can monitor and manage a Database Machine compute node expansion rack.

Cloud Control can monitor and manage a Database Machine storage Expansion rack

Oracle management agents must only be installed on one compute node in a Database Machine to enable monitoring and management of all compute nodes and storage nodes.

Oracle management agents must only be installed on one storage node in a Database Machine to enable monitoring and management of all storage nodes.

Cloud Control cannot monitor partitioned Exadata Database Machine systems.

Which two communication methods are used by which components in the Enterprise Manager architecture for a Database Machine?

SNMP traps for alerts are sent by the storage server ILOM to the storage server MS proces

SNMP traps for alerts are sent by the storage server MS process to the Enterprise Manager agen

SNMP traps for alerts are sent by the storage server ILOM directly to the Enterprise Manager agent.

SNMP traps for alerts are sent by the storage server MS process to the storage server ILOM.

SNMP traps for alerts are sent by the storage server ILOM to the storage server RS process

Which three are true about Exadata Smart Flash Log?

Databases on the Database Machine use Exadata Smart Flash Log by default

I/O Resource Manager database plans can be used to enable or disable Exadata Smart Flash Log for individual databases.

C LGWR will not wait for writes to Exadata Smart Flash Log if the write to a disk-based logfile completes first.

|/o Resource Manager category plans can be used to enable or disable Exadata Smart Flash Log for different I/O categories.

The use of Exadata Smart Flash Logs is mandatory for support of production databases.

A file contains a script with several EXACLI commands that must be executed on each cell in an X5 full rack. The script must run on each cell simultaneously. How would you achieve this?

Execute it on all cells using the EXADCLI command specifying the file name containing the EXACLI script.

Copy the script to all cells using the DCLI command and manually execute it on each cell using the DCLI command.

Copy the script to the cells using the EXACLI command and execute the script on all cells using the EXACLI command.

Copy the script to all cells using the CELLCLI command and execute it on all cells in parallel using the CELLCLI command.

Execute it on all cells using the DBMCLI command specifying the file name containing the EXACLI script.

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

ASR Manager must be installed and configured on a dedicated server external to the Database Machine.

ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.

Configuring ASR is mandatory for all Database Machine assets.

ASR Manager must be installed and configured on one of the database servers.

E ASR can upload configuration metadata to support problem resolution.

ASR communicates with Oracle support services using HTTPS.

Which two are true concerning Columnar Flash Caching?

E It automatically transforms Hybrid Columnar Compressed (HCC) data into a pure columnar format during Exadata Smart Flash Cache population.

|t can be enabled or disabled for individual databases by using I/O Resource Manager database plans.

|t automatically transforms ROW STORE COMPRESS compressed data into a pure columnar format during Exadata Smart Flash Cache population.

Data is either cached in Hybrid Columnar Compressed format or in pure compressed format, but never in both formats at the same time.

f it improves single-row lookup performance.

1z0-070 Oracle Exadata X5 Administration Practice Questions

Prepare for 1z0-070 with more than an answer.

98 questions in the full set12 sample questionsUpdated Jan 23, 2026

Unlock the full exam and previous versions

v1Version 1 251 questions Locked
1z0-070Legacy Oracle Exadata X5 Administration 98 questions Current
1z0-338Legacy Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials 80 questions Locked

Study as flashcards

Exam fee: $245 USD
Time limit: 120 minutes
Questions on the exam: 90
Passing score: 60% (scale 0-100%)
Level: Implementation Specialist
Valid for: Lifetime (does not expire)

Domains covered on the exam 8

Exadata Database Machine Architecture and Key Capabilities15%
Exadata Database Machine Initial Configuration12%
Exadata Administration Tools and Commands18%
Exadata Storage Server Configuration and Management20%
Exadata Smart Scan and Offload Processing15%
I/O Resource Management (IORM)10%
Exadata Monitoring and Management12%
Exadata Patching and Updates8%

1
Which four statements are true concerning the configuration or use of Enterprise Manager Cloud Control to monitor and manage Exadata Database Machine components?
Show answer details
Correct answer: A, B, C, F, G
B, C, F, G -- Explanation:
B (not A): Oracle Exadata components—including database and storage servers, switches, and power distribution units (PDUs)—use SNMP to raise alerts and report monitoring information.
Oracle’s CellCLI interface is a Java-based framework delivered by the storage cell’s management server process (MS) that provides administrative capabilities to your storage server entities.
C: Cloud control can monitor the Exadata Database Machine.
Figure: Oracle Enterprise Manager Cloud Control 12c monitoring architecture. Note the Management Server process (MS) on the Storage servers. G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units. -- G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units. -- References: www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em12-2291964.html">http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata- em12-2291964.html

B, C, F, G -- Explanation:
B (not A): Oracle Exadata components—including database and storage servers, switches, and power distribution units (PDUs)—use SNMP to raise alerts and report monitoring information.
Oracle’s CellCLI interface is a Java-based framework delivered by the storage cell’s management server process (MS) that provides administrative capabilities to your storage server entities.
C: Cloud control can monitor the Exadata Database Machine.
Figure: Oracle Enterprise Manager Cloud Control 12c monitoring architecture. Note the Management Server process (MS) on the Storage servers. G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units. -- G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units. -- References: www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em12-2291964.html">http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata- em12-2291964.html

B, C, F, G -- Explanation:
B (not A): Oracle Exadata components—including database and storage servers, switches, and power distribution units (PDUs)—use SNMP to raise alerts and report monitoring information.
Oracle’s CellCLI interface is a Java-based framework delivered by the storage cell’s management server process (MS) that provides administrative capabilities to your storage server entities.
C: Cloud control can monitor the Exadata Database Machine.
Figure: Oracle Enterprise Manager Cloud Control 12c monitoring architecture. Note the Management Server process (MS) on the Storage servers. G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units. -- G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units. -- References: www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em12-2291964.html">http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata- em12-2291964.html

B, C, F, G -- Explanation:
B (not A): Oracle Exadata components—including database and storage servers, switches, and power distribution units (PDUs)—use SNMP to raise alerts and report monitoring information.
Oracle’s CellCLI interface is a Java-based framework delivered by the storage cell’s management server process (MS) that provides administrative capabilities to your storage server entities.
C: Cloud control can monitor the Exadata Database Machine.
Figure: Oracle Enterprise Manager Cloud Control 12c monitoring architecture. Note the Management Server process (MS) on the Storage servers. G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units. -- G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units. -- References: www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em12-2291964.html">http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata- em12-2291964.html

B, C, F, G -- Explanation:
B (not A): Oracle Exadata components—including database and storage servers, switches, and power distribution units (PDUs)—use SNMP to raise alerts and report monitoring information.
Oracle’s CellCLI interface is a Java-based framework delivered by the storage cell’s management server process (MS) that provides administrative capabilities to your storage server entities.
C: Cloud control can monitor the Exadata Database Machine.
Figure: Oracle Enterprise Manager Cloud Control 12c monitoring architecture. Note the Management Server process (MS) on the Storage servers. G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units. -- G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units. -- References: www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em12-2291964.html">http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata- em12-2291964.html
2
Which two communication methods are used by which components in the Enterprise Manager architecture for a Database Machine?
Show answer details
Correct answer: B, C
B, C -- Reference: https://docs.oracle.eom/cd/E91266 01/EMXIG/GUID-FB58204F-2D97-41BC-9AA7-10BFF920B5B4.htm#EMXIG145

B, C -- Reference: https://docs.oracle.eom/cd/E91266 01/EMXIG/GUID-FB58204F-2D97-41BC-9AA7-10BFF920B5B4.htm#EMXIG145
3
Which three are true about Exadata Smart Flash Log?
Show answer details
Correct answer: A, B, C
A, B, C -- Explanation:
A: Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine, reserving flash for the most performance critical databases.
B: The Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine.
C: Smart Flash Logging works as follows. When receiving a redo log write request, Exadata will do parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash hardware. When either of these writes has successfully completed the database will be immediately notified of completion. If the disk drives hosting the logs experience slow response times, then the Exadata Smart Flash Cache will provide a faster log write response time.
Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times (e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time.
This algorithm will significantly smooth out redo write response times and provide overall better database performance.
Incorrect answers:
D: Category plans are configured and enabled using the CellCLI utility on the cell. Only one category plan can be enabled at a time. -- References: http://structureddata.org/2011/10/12/exadata-smart-flash-logging-explained/

A, B, C -- Explanation:
A: Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine, reserving flash for the most performance critical databases.
B: The Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine.
C: Smart Flash Logging works as follows. When receiving a redo log write request, Exadata will do parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash hardware. When either of these writes has successfully completed the database will be immediately notified of completion. If the disk drives hosting the logs experience slow response times, then the Exadata Smart Flash Cache will provide a faster log write response time.
Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times (e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time.
This algorithm will significantly smooth out redo write response times and provide overall better database performance.
Incorrect answers:
D: Category plans are configured and enabled using the CellCLI utility on the cell. Only one category plan can be enabled at a time. -- References: http://structureddata.org/2011/10/12/exadata-smart-flash-logging-explained/

A, B, C -- Explanation:
A: Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine, reserving flash for the most performance critical databases.
B: The Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine.
C: Smart Flash Logging works as follows. When receiving a redo log write request, Exadata will do parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash hardware. When either of these writes has successfully completed the database will be immediately notified of completion. If the disk drives hosting the logs experience slow response times, then the Exadata Smart Flash Cache will provide a faster log write response time.
Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times (e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time.
This algorithm will significantly smooth out redo write response times and provide overall better database performance.
Incorrect answers:
D: Category plans are configured and enabled using the CellCLI utility on the cell. Only one category plan can be enabled at a time. -- References: http://structureddata.org/2011/10/12/exadata-smart-flash-logging-explained/
4
A file contains a script with several EXACLI commands that must be executed on each cell in an X5 full rack.

The script must run on each cell simultaneously.

How would you achieve this?
Show answer details
Correct answer: C
C
5
Which two statements are true about Auto Service Request (ASR) with an X5 Database Machine?
Show answer details
Correct answer: A, C
A, C -- Explanation:
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.
Incorrect answers:
D: Oracle recommends that you install Oracle ASR Manager on an external, standalone server. -- References: http://docs.oracle.eom/cd/E80920 01/ASXQI/toc.htm#GUID-490B2837-C608-4626-B4FF-59F679C36302

A, C -- Explanation:
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.
Incorrect answers:
D: Oracle recommends that you install Oracle ASR Manager on an external, standalone server. -- References: http://docs.oracle.eom/cd/E80920 01/ASXQI/toc.htm#GUID-490B2837-C608-4626-B4FF-59F679C36302
6
Which two are true concerning Columnar Flash Caching?
Show answer details
Correct answer: D, E
D, E -- Explanation:
D: In-Memory Columnar Caching on cells is enabled by default when the INMEMORYJSIZE 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.
Incorrect answers:
F: Columnar Flash Caching accelerates reporting and analytic queries while maintaining excellent performance for OLTP style single row lookups. -- References:
http://docs.oracle.eom/cd/E80920 01/SAGUG/exadata-storage-server-monitoring.htm#SAGUG20883 http://www.oracle.com/technetwork/database/exadata/exadata-x5-8-ds-2745934.pdf

D, E -- Explanation:
D: In-Memory Columnar Caching on cells is enabled by default when the INMEMORYJSIZE 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.
Incorrect answers:
F: Columnar Flash Caching accelerates reporting and analytic queries while maintaining excellent performance for OLTP style single row lookups. -- References:
http://docs.oracle.eom/cd/E80920 01/SAGUG/exadata-storage-server-monitoring.htm#SAGUG20883 http://www.oracle.com/technetwork/database/exadata/exadata-x5-8-ds-2745934.pdf

Create an account to continue.

Create account Sign in

Create an account to continue.

Related exams