Oracle Cloud Database Migration and Integration 2021 Specialist for Qs’ preparation
1Z0-1094-21 Oracle Cloud Database Migration and Integration
Oracle Cloud Database Migration and Integration
1Z0-1094-21 Oracle Cloud Database Migration and Integration
OCDMI
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
- Describe when to use Data Pump to migrate to Autonomous Database (ADB)
- Use ZDM to migrate on-premises databases to ADB
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 Sounce 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