Format: Multiple Choice
Duration: 90 Minutes
Exam Price: $
Number of Questions: 55
Passing Score: 70%
Validation: This exam has been validated against Oracle Cloud Infrastructure 2023
Policy: Cloud Recertification
Earn associated certifications:
Passing this exam is required to earn these certifications. Select each certification title below to view full requirements.
Oracle Cloud Database 2023 Migration and Integration Certified Professional
Prepare to pass exam: 1Z0-1094-23
An Oracle Cloud Database 2023 Migration and Integration Certified Professional has the skills to migrate database instances to Oracle Cloud, Autonomous Database, and Oracle Cloud Database Services, and implement data integration. They understand the requirements and architecture of Oracle Cloud Database and the use of multiple migration methods, such as RMAN, Data Pump, Cloning, SQL Developer, GoldenGate, and Oracle Zero Downtime Migration (ZDM), depending on source and target database options.
Up-to-date training and hands-on experience are strongly recommended.
Take recommended training
Complete one of the courses below to prepare for your exam (optional):
Become an Oracle Cloud Database Migration and Integration Professional (2023)
Examkingdom Oracle 1Z0-1094-23 Exam pdf,
Best Oracle 1Z0-1094-23 Free downloads , Oracle 1Z0-1094-23 Dumps at Certkingdom.com
Practice Exam
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience), in the learning subscription, provides the best preparation for passing the exam.
Review exam topics
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 Cloud Database Services using RMAN, Data Pump, and Cloning
Describe when to use Data Pump to migrate to Oracle Database to Oracle Cloud Infrastructure (OCI)
Describe when to use Unplug/Plug, Remote Cloning, and Relocation of PDBs to migrate to OCI
Use Recovery Manager (RMAN) to migrate to OCI
Migrating to Cloud Database Services using SQL Developer, Cloud Backup, and GoldenGate
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 the Sounce database and Target Options in OCI
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 the data flow
Implement data integration mapping where data is joined from a hybrid data source (ex: Database and files) before loading into the target
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
QUESTION 1
What is the managed chatbot service of Oracle Cloud called?
A. Digital Bot
B. Digital Integration
C. Digital Support
D. Digital Assistant
Answer: D
QUESTION 2
Which TWO methods should you use when migrating a target database with different endianness than the source database? (Choose all correct answers)
A. RMAN DUPLICATE
B. RMAN Transportable Tablespaces with Data Pump
C. RMAN CONVERT
D. RMAN RESTORE from target
Answer: B, D
QUESTION 3
Which statements are true about Data Pump? (Choose two.)
A. It supports cross-endian formats
B. Both the source and target database must be of the same version
C. It supports cross-platform migration
D. A best practice is to invoke Data Pump using SYS as SYSDBA
Answer: A, C
QUESTION 4
If unplug and plug was decided to be used as the tool for the migration to Oracle Cloud Infrastructure (OCD),
which two constraints are part of this migration to process for using unplug and plug? (Choose all correct answers)
A. Target must be an Autonomous database.
B. Target and source have same Endianness.
C. Source must be Little-endian.
D. Source and target need to be container database (CDB).
Answer: B, D
QUESTION 5
Which TWO statements are true about the Oracle Zero Downtime command line? (Choose all correct answers)
A. The zdmeli migrate database command can be run with no options as long as all the information is
correctly specified in Zero Downtime Migration’s (ZDM) response file.
B. When the source database is a single instance database deployed on a non-Grid Infrastructure
environment, the sourcesid option should be used to specify the database name.
C. Upon executing the zdmcli, migrate database command, the only way to track the status of the
migration is by querying the ZDM service using the provided job ID.
D. The -sourcedb option is the only valid option to indicate the source database name.
Answer: B, C
QUESTION 6
Which source database versions are supported for OCI Database Migration? (Choose two.) (Choose all correct answers)
A. Oracle Database 10g R1
B. Oracle Database 10g R2
C. Oracle Database 19c
D. Oracle Database 11g
Answer: C, D
QUESTION 7
What can you use to quickly load data into a cloud database by dragging and dropping a file in a web browser?
A. Remote cloning a pluggable database (PDB)
B. RMAN Transportable Tablespace
C. Data Pump Transportable Tablespaces
D. Data Load tab of the SQL worksheet in Database Actions
Answer: D
