Oracle 1Z0-485

Free Questions in OTE format

About Oracle 1Z0-485 dump

The Oracle Exadata Database Machine 2014 Implementation Specialist certification is designed for individuals who possess a strong foundation and expertise in selling and implementing Oracle's Exadata Database Machine Models X4-2, X3-2 and X3-8 solutions. This certification covers topics such as: administration, configuration, patching, and monitoring of an Exadata Database Machine. This certification differentiates candidates in the marketplace by providing a competitive edge through proven expertise. Up-to-date training and field experience are recommended.
This certification is available to all candidates but is geared toward members of the Oracle PartnerNetwork. OPN members earning this certification will be recognized as OPN Certified Specialists. This certification qualifies as competency criteria for the Oracle Exadata Database Machine specialization.

Oracle Database Software

• Use common database features
  
• Leverage performance features
  

Oracle Exadata Architecture

• Describe specific uses of offloading processing
  
• Describe the software architecture used by Oracle Exadata software
  
• Use Smart Flash Cache
  
• Enable Flash Cache Write Back
  
• Describe the different types of caching, their use and benefit
  
• Enable Advanced Compression and Hybrid Columnar Compression on Exadata tables
  
• Describe how storage indexes operate
  
• Describe best practices for High Availability configurations
  
• Enable parallelism for Data Warehouse workloads
  
• Describe database and Automatic Storage Management-Scoped Security Concepts
  
• Describe the Power Distribution Unit
  
• Describe memory capabilities of the different models
  

Administration & Configuration

• Compress data using Advanced Compression and Hybrid Columnar Compression
  
• Use network configuration options
  
• Create and configure Automatic Storage Management disk groups using Exadata
  
• Discuss the impact of various diskgroup/failure group choices
  
• Install software onto the Exadata Database Machine
  
• Administer physical disks on Exadata
  
• Describe various tasks that can be done with the Integrated Lights Out Management (ILOM) console
  
• Reconfigure an 1/8th rack into a 1/4 rack
  
• Describe network components in Exadata
  
• Describe Exadata configuration best practices
  

Backup & Recovery

• Create a backup plan for Exadata
  
• Implement recovery procedures on different failure scenarios
  
• Describe troubleshooting tasks for Backup and Recovery processes
  
• Recover Storage Cells from Disk Failure
  
• Describe how the Exadata Storage Servers are backed up internally
  

High Availability

• Describe general best practices and guidelines for high availability configurations on Exadata
  
• Identify failure scenarios and implement recovery procedures
  
• Install high availability software onto the Exadata Database Machine
  

Monitoring

• Install Enterprise Manager Exadata Monitoring plug-in
  
• Setup agent, plugin and Exadata target for Enterprise Manager Cloud Control
  
• Monitor the storage cell using Cell Command Line Interface and Distributed Command Line Interface
  
• Describe purpose and uses for Simple Network Management Protocol (SNMP), Intelligent Platform Management Interface (IPMI) and Integrated Lights Out Management for the DB machine
  
• Use osWatcher and iostat to monitor the Database Machine operating system
  

Software Maintenance

• Describe how software components are maintained
  
• Locate patches for Exadata
  
• Apply best practices to the patching process for Exadata
  
• Describe Oracle Configuration Manager
  
• Explain how to perform planned maintenance of the Exadata machine
  
• Troubleshoot planned maintenance activities
  

Bulk Loading & Migration

• Use Database File System (DBFS) to perform bulk loading operations
  
• Configure Database for staging input data files
  
• Use external tables for data loads
  
• Describe migration strategies for Exadata
  
• Articulate best practices for choosing a migration strategy
  

Resource Management

• Setup Database Resource Management and I/O Resource Management
  
• Configure I/O Resource Management and Database Resource Management
  
• Setup instance caging
  
• Manage I/O on Exadata
  

Support

• Setup Automatic Service Request on the Database Machine
  
• Discuss the ASR configuration process
  
• Describe implementation requirements for Platinum Support