Pass! Certificação 1Z0-338

Após algum tempo de estudo fiz a prova 1Z0-338 Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials e consegui passar com o score de 86% dos 63% requeridos. =)

Aos que tiverem interesse:

Link da certificação na Oracle University: https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-338


Tópicos do exame:

Oracle Database Software

• Configure and administer a basic database using Oracle features and functions
• Tune the Oracle database for performance in common use case scenarios

Oracle Exadata Architecture

• Describe offloading processing
• Describe the architecture used by Oracle Exadata software
• Use Smart Flash Cache
• Enable Flash Cache Write Back
• Enable Advanced Compression and Hybrid Columnar Compression on Exadata tables
• Describe storage indexes
• Describe Oracle recommended configurations for High Availability configurations
• Enable parallelism for Data Warehouse workloads
• Describe database and Automatic Storage Management-Scoped Security Cconcepts
• Describe the Power Distribution Unit
• Describe memory capabilities of different models
• Describe the importance and use of In-Memory Fault Tolerance in the Exadata Database Machine
• Explain the differences between the types of storage servers available on the Exadata Database Machine

Administration and Configuration 

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

Backup and Recovery

• Create a backup plan for Exadata
• Implement recovery procedures on different failure scenarios
• Describe troubleshooting tasks for backup and recovery processes
• Describe how the Exadata Storage Servers are backed up internally

High Availability

• Describe Oracle's recommended 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 an Enterprise Manager Exadata Monitoring plug-in
• Set up an 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 the purpose and uses for Simple Network Management Protocol (SNMP), Intelligent Platform Management Interface (IPMI) and Integrated Lights Out Management for a DB machine
• Use osWatcher and iostat to monitor the Database Machine operating system
• Use exacli and dbcli to monitor storage cells

Software Maintenance

• Describe software components
• Locate patches for Exadata
• Apply Oracle recommendations to the patching process for Exadata
• Describe the Oracle Configuration Manager
• Explain how to perform planned maintenance of the Exadata machine
• Describe how to use the Oracle Exadata Deployment Assistant to create virtual machines on Exadata

Bulk Loading and Migration

• Use Database File System (DBFS) to perform bulk loading operations
• Use the ASM Cluster File System (ACFS) to perform bulk data loading operations
• Configure a Database for staging input data files
• Use external tables for data loads
• Describe migration strategies for Exadata
• Explain Oracle recommendations on how to choose a migration strategy

Resource Management

• Set up instance caging
• Manage I/O on Exadata

Support

• Set up an Automatic Service Request (ASR) on the Database Machine
• Explain the ASR configuration process
• Describe implementation requirements for Platinum Support

Exadata in the Cloud

• Describe the Oracle Exadata Cloud Service provisioning process
• Configure backup and recovery on the Exadata Cloud Service
• Administer the Oracle Database on the Exadata Cloud Service
• Administer the Oracle Database on the Exadata Cloud Machine