1Z0-070 - Oracle Exadata X5 Administration

Recently Oracle released beta exam for Oracle Exadata Administration based on X5 machine. It may come in production within 2-3 months.

It is right time to clear 1Z0-027 certification before releasing new exam to become an Exadata administrator.

Let's throw some light on the exam details and exam topics.

Exam Number: 1Z1-070 (Beta), 1Z0-070 (Production)

Exam Name:     Oracle Exadata X5 Administrator

Exam Topics

Exadata Database Machine Overview

• Identify the benefits of using Database Machine for different application classes
• Describe Exadata Storage Server and the different Database Machine configurations
• 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
• Describe database machine operating system options and configurations

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
• Monitor and configure table indexes, accounting for the presence of Exadata

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 

• Describe the various options for staging data to be bulk loading into Database Machine
• 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 placement of agents, plug-ins and targets
• 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
• Monitor the InfiniBand subnet master location
• Monitor the InfiniBand network topology

Monitoring other Exadata Database Machine Components

• Monitor Exadata Database Machine components: Cisco Switch, Power Distribution Units

Monitoring Tools

• 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
• Describe the recommended best practices for backup and recovery on Database Machine to  Exadata and non-Exadata storage
• 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
• Describe the recommended patching process for Database Machine with patchmgr, oplan and dbnodeupdate utilities

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

Source: www.oracle.com

1Z0-070 Oracle Exadata Exam Dumps