Oracle Exadata X5 Administration 1Z0-070

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

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

• 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