Red Hat Certificate Of Expertise In Data Virtualization Exam Ies (Ex450K)
Course Description
The Red Hat Certificate of Expertise in Data Virtualization exam tests candidates' skills and knowledge in the use of Red Hat Data Virtualization to integrate multiple data sources.
Someone who holds a Certificate of Expertise in Data Virtualization is able to perform the following tasks:
- Start, stop, and manage deployments on the data virtualization runtime
- Model and create federated views from divergent data sources including flat files and relational databases
- Transform data from divergent data sources to create new, business-ready data views
- Create virtual procedures to provide customized and/or optimized data views
- Use effective techniques to improve the performance of federated data views
- Expose federated data as RESTful services
This exam is a performance-based evaluation of the skills and knowledge required to effectively use Red Hat JBoss Data Virtualization to model and create a single cohesive, federated view of multiple, complex data sources. Candidates perform a number of routine data modeling and federation tasks and are evaluated on whether they have met specific objective criteria. Performance-based testing means that candidates must perform tasks similar to what they perform on the job.
About this course
Who Needs to Attend
- Developers and architects who will be responsible for modeling and creating federated views of multiple, different data sources using Red Hat JBoss Data Virtualization
- Database administrators who may be involved in a project using Red Hat JBoss Data Virtualization to model and create federated views of multiple, different data sources
Prerequisites
There are no prerequisites to take this exam but it is recommended that an individual take Red Hat JBoss Data Virtualization Administration (JB450) training course
Course Outline
- Establish and import data sources
- Import from Flat File Source locally
- Import from Flat File Source FTP
- Import from RDBMS
- Federate and transform data
- Use the Teiid Designer wizards to automatically generate data translators
- Update generated translators
- Apply simple data transformations such as type casting
- Apply complex transformations inbuilt transformation functions
- Use the various inbuilt translators
- VDB Modeling
- Aggregate different typed data stores to create a federated view including:
- ◦ Files (flat and XML)
- ◦ Multiple, different relational database
- Implement SQL logic from distinct data stores
- Implement materialized views
- Tuning
- Improve performance by using in memory cache
- Use techniques to bypass caches as needed
- Tune caching behavior for specific requirements
- Reporting/Data export
- Create READ procedure
- Expose procedure results as XML or JSON
- Expose data as RESTful services
- Identify and anticipate performance issues
- Runtime
- Package and deploy virtual databases
- Use Teiid Designer to control and manage the data virtualization runtime