1Z0-338 Oracle Exadata Database Machine and Cloud Service 2017 Certified Implementation Specialist

Download Free Oracle Exam Dumps for 1Z0-338

Exam Code - 1Z0-338

Exam Name - Oracle Exadata Database Machine and Cloud Service 2017 Certified Implementation Specialist

File Format - pdf

1Z0-338 Exam Study Guide:

Oracle Database Software

• Use the 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
• Describe migration strategies for Exadata
• Explain Oracle recommended methods for choosing a migration strategy

Oracle Exadata Architecture

• Describe offloading processing
• Describe Oracle Exadata software architecture
• 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 the Power Distribution Unit
• Describe database and Automatic Storage Management-Scoped Security concepts
• Describe the importance and use of In-Memory Fault Tolerance in the Exadata
• 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
• Administer physical disks on Exadata
• Describe various tasks that can be done with the Integrated Lights Out Management (ILOM) console
• Identify failure scenarios and implement recovery procedures
• Install high availability software onto the Exadata Database Machine
• Set up an Automatic Service Request (ASR) on the Database Machine
• 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 for 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

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 the Cell Command Line Interface and the 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
• Apply Oracle recommendations to the patching process for Exadata
• Describe the Oracle Configuration Manager
• Explain and troubleshoot planned maintenance of the Exadata machine
• Describe how to use the Oracle Exadata Deployment Assistant to create virtual machines on Exadata

Resource Management

• Set up Database Resource Management
• Configure I/O Resource Management
• Set up instance caging
• Manage I/O on Exadata

Exadata in the Cloud

• Describe the Oracle Exadata Cloud Service provisioning process
• Configure backup and recovery on the Exadata Cloud Service
• Set up service roles and user accounts in the Oracle cloud
• Administer the Oracle Database on the Exadata Cloud Service
• Administer the Oracle Database on the Exadata Cloud Machine