Brief Introduction
Pass Oracle Exadata X5 Administration | 1Z0-070 on the first attempt. 2 Practice test.Description
Course in Pre-Launch Mode, a total number of questions will be around 85+.
Oracle Exadata X5 Administration | 1Z0-070 Test series
1Z0-070 practice test
It covers 100% of the Oracle exam 1Z0-070 certification syllabus.
Exam Topics:
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
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
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
Recommendations for Optimizing Database Performance
Optimize database performance in conjunction with Exadata Database Machine
Optimize Cell performance for Flash Cache and latency capping
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
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
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 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 other Exadata Database Machine Components
Monitor Exadata Database Machine components: Cisco Switch, Power Distribution Units
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
Patching Exadata Database Machine
Describe how software is maintained on different Database Machine components
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
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
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
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
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
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
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 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 Tools
Use monitoring tools: Exachk, ExaWatcher, TFA Collector DiagTools, ADRCI, Imageinfo and Imagehistory, OSWatcher
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
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