An Oracle Cloud Database Migration and Integration 2022 Certified Specialist has the skills to migrate database instances to the Oracle Cloud, including to Autonomous Database and Oracle Cloud Database Services and to implement data integration. They understand the requirements and architecture and can use multiple migration methods, such as RMAN, Data Pump, Cloning, SQL Developer, GoldenGate and Oracle Zero Downtime Migration, depending on source and target database options. Up to date training and hands-on experience are strongly recommended.
Format: Multiple Choice
Duration: 90 Minutes
Number of Questions: 55
Passing Score: 70%
Validation: This exam has been validated against Oracle Cloud Infrastructure 2021
Policy: Cloud Recertification
Review exam topics: Exam Code: 1Z0-1094-22 Oracle Cloud Migration and Integration 2022 Specialist
Oracle Migration and Integration
Describe Oracle Data Management and Integration
Describe Oracle Data Management Services
Explain Migration Use Cases and Solutions
Describe Oracle Data Integration
Migrating to Autonomous Database
Migrating to Cloud Database Services using RMAN, Data Pump and Cloning
Analyze and choose a Migration Strategy (Source Database and Environments, Linux/non-Linux, CDB, non-CDB)
Migrate using SQL Developer
Migrate an Oracle Database to OCI by using Oracle Database Cloud Backup Service
Migrate Oracle Databases on 3rd party clouds (moving from 3rd party clouds)
Migrate an Oracle Database to OCI using GoldenGate
Source and Target Database Options
Explain Source database and Target Options in OCI
Implement prerequisites for ZDM Service Node, Source Database, Target Database, Backup, Network Considerations, and Encryption Consideration
Analyze migration evaluation considerations (Downtime, Network, Data Constraints: Database Size, Character Set, Encryption) and Database constraints (Version, Edition, Options, Release Updates Level, Block Size, Time Zone, Target DB Configuration)
Migrating to Cloud Database Services using Oracle Zero Downtime Migration (ZDM)
Describe Zero Downtime Migration (ZDM)
Prepare to use ZDM Service Node, Source Database, Target Database, Backup, Network Considerations, and Encryption Consideration
Manage the Database Migration Workflow (ZDM Commands and Options, Migration with Oracle ZDM, Troubleshooting, Common Issues)
Data Integration
Explain ETL vs ELT architecture of data integration
Analyze architecture components for transferring data from On-premises Database to Oracle Cloud DB
Implement change data capture (CDC) and leverage GoldenGate for real-time feed
Implement extraction method for Fusion SaaS applications for loading into Autonomous Database Warehouse (ADW)
Implement data integration mapping for data quality checks as part of data flow
Implement data integration mapping where data is joined from hybrid data source (ex: Database and files) before loading into the target
