1Z1-070 - Download free Oracle Exadata Exam Dumps


Download Free Oracle Exam Dumps for 1Z1-070

Exam Code - 1Z1-070 (Beta)

Exam Name - Oracle Exadata X5 Administration

File Format - pdf

Exam Study Guide:

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

No comments:

Post a Comment