Number of Questions: 90
Passing Score: 60%
View passing score policy
This exam has been validated against Oracle Exadata Database Machine version X5-2.
Format: Multiple Choice
Take Recommended Training Courses
Complete one of the courses below to prepare for your exam (optional):
Exadata Database Machine: 12c Administration Workshop Ed 2
Additional Preparation and Information
Exadata Database Machine Overview
Identify the benefits of using Database Machine for different application classes
Describe the key capacity and performance specifications for Database Machine
Exadata Database Machine Architecture
Describe the Database Machine network architecture and requirements
Describe the Database Machine software architecture
Describe the Exadata Storage Server storage entities and their relationships
Describe how multiple Database Machines can be interconnected and scaled up
Key Capabilities of Exadata Database Machine
Describe the key capabilities of Exadata Database Machine
Describe the Exadata Smart Scan capabilities
Describe the capabilities of hybrid columnar compression
Describe the capabilities and uses of the Smart Flash Cache
Describe t he capabilities of Columnar Flash Caching
Describe the capabilities of the Smart Flash Log
Describe the purpose and benefits of Storage Indexes
Describe the capabilities and uses of Exadata Snapshot databases
Describe Cell to Cell Data Transfer and Exadata Network Resource Management
Exadata Database Machine Initial Configuration
Describe site planning requirements for Database Machine
Describe the installation and configuration process with the Exadata Deployment Assistant
Describe the default configuration for Database Machine
Describe supported and unsupported customizations for Database Machine
Configure Exadata Storage Server
Configure Exadata software and resources using Cellcli or other tools
Create and configure ASM disk groups using Exadata
Use the CellCLI, ExaCLI, DCLI and ExaDCLI Exadata administration tools
Configure Exadata Storage Server security
I/O Resource Management
Use Exadata Storage Server I/O Resource Management to manage workloads within a database and across multiple databases
Configure database resource management plans and profiles
Configure category plans
Configure inter-database plans
Describe and configure the I/O resource manager objectives
Monitor I/O using I/O Metrics
Recommendations for Optimizing Database Performance
Optimize database performance in conjunction with Exadata Database Machine
Optimize Cell performance for Flash Cache and latency capping
Using Smart Scan
Describe Smart Scan and the query processing that can be offloaded to Exadata Storage Server
Describe the requirements for Smart Scan
Describe the circumstances that prevent using Smart Scan
Identify Smart Scan in SQL execution plans including smart joins
Use database statistics and wait events to confirm how queries are processed
Consolidation Options and Recommendations
Describe the options for consolidating multiple databases on Database Machine
Describe the benefits and costs associated with different options
Identify the most appropriate approach for consolidation in different circumstances
Migrating Databases to Exadata Database Machine
Describe the steps to migrate your database to Database Machine
Explain the main approaches for migrating your database to Database Machine
Identify the most appropriate approach for migration in different circumstances
Bulk Data Loading
Configure the Database File System (DBFS) feature for staging input data files
Use external tables based on input data files stored in DBFS to perform high-performance data loads
Exadata Database Machine Platform Monitoring
Describe the purpose and uses of SNMP for the Database Machine
Describe the purpose and uses of IPMI for the Database Machine
Describe the purpose and uses of ILOM for the Database Machine
Configuring Enterprise Manager Cloud Control 12c to Monitor Exadata Database Machine
Describe the Enterprise Manager cloud Control architecture as it specifically applies to Exadata Database Machine
Describe the discovery process and post discovery configurations
Monitoring Exadata Storage Servers
Describe Exadata Storage Server metrics, alerts, Thresholds and active requests
Describe and use Exedata Storage Server Quarantines, Disk Scrubbing and repair
Monitor Exadata Storage Server using Command line or Cloud control
Monitoring Exadata Database Machine Database Servers
Describe the monitoring recommendations for Exadata Database Machine database servers
Use Cloud Control or DBMCLI to monitor Exadata Database Machine Database Servers
Monitoring the InfiniBand Network
Monitor InfiniBand switches With Cloud Control or CLI
Monitor InfiniBand switch ports
Monitor InfiniBand ports on the database servers ajd Cells with LIST IBPORT command
Monitoring other Exadata Database Machine Components
Monitor Exadata Database Machine components: Cisco Switch, Power Distribution Units
Use monitoring tools: Exachk, ExaWatcher, TFA Collector DiagTools, ADRCI, Imageinfo and Imagehistory, OSWatcher
Backup and Recovery for Exadata Database Machines
Describe how RMAN backups are optimized using Exadata Storage Server
Describe the recommended approaches for disk-based and tape-based backups of databases on Database Machine
Perform backup and recovery
Connect a media server to the Database Machine InfiniBand network
Database Machine Maintenance tasks
Power Database Machine on and off
Safely shut down a single Exadata Storage Server
Replace a damaged physical disk on a cell
Replace a damaged flash card on a cell
Move all disks from one cell to another
Use the Exadata Cell Software Rescure Procedure
Patching Exadata Database Machine
Describe how software is maintained on different Database Machine components
Database Machine Automated Support Ecosystem
Describe the Auto Service Request (ASR) function and how it relates to Exadata Database Machine
Describe the implementation requirements for ASR
Describe the ASR configuration process
Describe Oracle Configuration Manager (OCM) and how it relates to Exadata Database Machine
Within 30 minutes of completing your Oracle Certification exam, you will receive an email from Oracle notifying you that your exam results are available in CertView. If you have previously authenticated your CertView account, simply login and select the option to “See My New Exam Result Now.”
If you have not authenticated your CertView account yet at this point, you will need to proceed with your account authentication.
Authentication requires an Oracle Single Sign On username and password and the following information from your Pearson VUE profile: email address and Oracle Testing ID. You will be taken to CertView to log in once your account has been authenticated.
Which statement is true about operating systems in an X5 Database Machine multirack configuration consisting of two full racks and one Exadata storage expansion rack?
A. All Exadata storage servers used by the same virtual cluster nodes must run the same O/S but Exadata Storage Servers in different clusters may run different operating systems.
B. All Exadata storage servers must run the Oracle Solaris O/S and all database servers within the same cluster must run Oracle Linux.
C. All Exadata storage servers may run Oracle Virtual Machine (OVM).
D. All Exadata storage servers must run Oracle Linux.
E. All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run the same version of Oracle Virtual Machine (OVM).
On both physical and virtual deployments, Exadata systems use minimal Linux distributions to ensure that just the RPMs needed to run Oracle database, are installed and enabled.
You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) for your X5 Database Machine and its assets.
Which three statements are true about this configuration?
A. Simple Network Management Protocol (SNMP) traps are used to send notifications from
database servers to the ASR Manager.
B. Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to the ASR Manager.
C. When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).
D. When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS.
E. Simple Network Management Protocol (SNMP) traps are used to send notifications from the Enterprise Manager to the ASR Manager.
F. Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to the Enterprise Manager.
B: Oracle ASR Manager only processes SNMP traps that are sent from IP addresses that Oracle ASR Manager recognizes.
Example of Exadata Storage Server SNMP Trap
This example shows the SNMP trap for an Exadata Storage Server disk failure. The corresponding hardware alert code has been highlighted.
2011-09-07 10:59:54 server1.example.com [UDP: [192.85.884.156]:61945]: RFC1213-MIB::sysUpTime.0 = Timeticks: (52455631) 6 days, 1:42:36.31 SNMPv2-SMI::snmpModules.188.8.131.52.0 = OID: SUN-HW-TRAP-MIB::sunHwTrapHardDriveFault
SUN-HW-TRAP-MIB::sunHwTrapSystemIdentifier = STRING: Sun Oracle Database Machine Etc.
C (not D): The ASR Manager uses the SNMP GET protocol to query ASR assets for additional fault information.
To configure fault telemetry, choose one of the following three options:
Add SNMP Trap Destinations Using OneCommand (recommended for new installations) Add SNMP Trap Destinations for Multiple Servers Using the dcli Utility
Add SNMP Trap Destinations for a Single Server
Which three are true concerning Smart Scans?
A. The decision to perform a Smart Scan is made by the Optimizer.
B. Smart Scans are only possible during full table scans or fast full index scans.
C. Smart Scans are possible on Index Organized Tables (IOTs).
D. Smart Scans always outperform scans that are not offloaded.
E. Smart Scans are possible on heap organized tables.
F. Smart Scans are possible on uncompressed B*Tree indexes.
B: In order for queries to take advantage of Exadata’s Offloading capabilities, the optimizer must decide to execute a statement with a Full Table Scan or a Fast Full Index Scan.
F: Smart Scans can be used for full scanning through B*Tree index segments.
Expert Oracle Exadata – K. Osborne, et al., (Apress, 2011) BBS, page 346