Oracle Database 11g Data Warehousing Essentials
Exam Number: 1Z0-515
Associated Certifications: Oracle Data Warehousing 11g Certified Implementation Specialist , OPN Certified Specialist

Overview of Data Warehousing

Describe the benefits of a data warehouse
Describe the technical characteristics of a data warehouse
Describe the Oracle Database structures used primarily by a data warehouse
Explain the use of materialized views
Implement Database Resource Manager to control resource usage
Identify and explain the benefits provided by standard Oracle Database 11g enhancements for a data warehouse

Parallelism

Explain how the Oracle optimizer determines the degree of parallelism
Configure parallelism
Explain how parallelism and partitioning work together

Partitioning

Describe types of partitioning
Describe the benefits of partitioning
Implement partition-wise joins

Result Cache

Describe how the SQL Result Cache operates
Identify the scenarios which benefit the most from Result Set Caching

OLAP

Explain how Oracle OLAP delivers high performance
Describe how applications can access data stored in Oracle OLAP cubes

Advanced Compression

Explain the benefits provided by Advanced Compression
Explain how Advanced Compression operates
Describe how Advanced Compression interacts with other Oracle options and utilities

Data integration

Explain Oracle's overall approach to data integration
Describe the benefits provided by ODI
Differentiate the components of ODI
Create integration data flows with ODI
Ensure data quality with OWB
Explain the concept and use of real-time data integration
Describe the architecture of Oracle's data integration solutions

Data mining and analysis

Describe the components of Oracle's Data Mining option
Describe the analytical functions provided by Oracle Data Mining
Identify use cases that can benefit from Oracle Data Mining
Identify which Oracle products use Oracle Data Mining

Sizing

Properly size all resources to be used in a data warehouse configuration

Exadata

Describe the architecture of the Sun Oracle Database Machine
Describe configuration options for an Exadata Storage Server
Explain the advantages provided by the Exadata Storage Server

Best practices for performance

Employ best practices to load incremental data into a data warehouse
Employ best practices for using Oracle features to implement high performance data warehouses