Oracle Migration and Integration
Oracle Migration and Integration
Question
Q1
What are the five migration steps?
- Discovery
- Analysis
- Validation
- Analytics
- Planning
- Deploy
- Migration
Question
Q2
Which two migration methods are recommended for small data sets for migrating to Exadata Cloud Service or Database Cloud Service instance?
- Data Pump
- RMAN DUPLICATE from an Active Database
- SQL Developer
- RMAN Cross-Platform Transportable PDB
Question
Q3
When selecting a migration method for moving your database to the cloud, which three should you take into consideration?
- The database size
- The migration cost
- High Availability
- The database version
Question
Q4
Which is false about application containers?
- Allows application administrators to manage many tenants as one
- Great isolation between tenants
- Setup of tenants not very quick
- Many tenants supported on small server footprint
Question
Q5
Which statement is false about Data Pump?
- Platform and architecture independent
- Can export and import the full database or a portion
- Provides fast unload and load via a dump file
- Does not support encryption and compression
Question
Q6
Which is false about Oracle Multitenant?
- Container database or CDB consolidates many PDBs
- Isolation and agility with economies of scale
- PDBs are difficult to clone and to move to around the cloud
- Applications run unchanged in self-contained pluggable databases or PDBs
Question
Q7
Which is not a benefit of Database Migrations?
- Fully managed
- Applications can stay online during migration
- Improve performance in Oracle Cloud
- Increase cost
Question
Q8
Which is false about the Cloud Pre-Migration Advisor Tool (CPAT)?
- It is not integrated in DMS
- It helps determine the suitability of migrating an Oracle database instance to one of Oracle’s cloud offerings.
- It will assess your source database instance, checking for potentially problematic content and other factors that could impede a successful migration.
- It validates the source database for compatibility as part of the migration.
. Question
Q9
Oracle Data Integrator has been split into three listings on OCI Marketplace. Which is not one of the three listings available in OCI Marketplace?
- ODI Classic (free)
- ODI Classic (BYOL)
- Enterprise Edition (BYOL)
- ODI Web Edition (free)
Question
Q10
There are two kinds of mapping components: projector components and selector components. Which three are examples of a projector component?
- Hide attributes originating from preceding components; all succeeding components can only use attributes from the projector.
- Reuse attributes from preceding components
- Combine attributes from the preceding components (in the case of Join and Lookup selectors)
- Influence the attributes present in the data that flows through a mapping
- Define their own attributes; attributes from preceding components are mapped through expressions to the projector’s attributes.
Question
Q11
Which component produces a subset of the data coming from an upstream component using a filter condition?
- Filter Component
- Sort Component
- Join Component
- Distinct Component
Question
Q12
Which component removes duplicates in records coming from an upstream component?
- Filter Component
- Sort Component
- Distinct Component
- Join Component
Question
Q13
ZDM supports databases on three platforms; which of the following is not one of those supported platforms?
- Azure
- AIX
- Linux
- Solaris
Note : ZDM stands for Zero Downtime Migration
Question
Q14
Which three can Oracle Zero Downtime Migration migrate on-premises databases to?
- Database Cloud Service Bare Metal and Virtual Machine
- Exadata Enterprise Service
- Exadata Cloud Service
- Exadata Cloud at Customer
Question
Q15
For which three cloud services does DBMS_CLOUD provide support for loading data from files to tables in Autonomous Database?
- OCI Object Storage
- IBM Spectrum Storage
- OCI Object Storage Classic
- Dell EMC Elastic Cloud Storage
- Amazon AWS S3
Question
Q16
Which procedure do you use to load data directly into existing Autonomous Database tables?
- DBMS_CLOUD.PUT_OBJECT
- DBMS_CLOUD.COPY_DATA
- DBMS_CLOUD.CREATE_EXTERNAL_TABLE
- DBMS_CLOUD.LIST_FILES
Question
Q17
Which two methods can you use to migrate an on-premises database to Oracle Autonomous Database?
- Data Guard
- Data Pump
- GoldenGate
- RMAN
Question
Q18
What does the database migration service use for migration?
- Data Guard
- Backup Cloud Module
- GoldenGate
- RMAN Backup
Question
Q19
What is the second step for Zero Downtime Migration – Logical Migration?
- ZDM Connects to Source and Target
- Download & Configure ZDM
- ZDM Configures an OGG Extract Microservice
- ZDM Connects to Backup Location
Question
Q20
What adds GoldenGate into its architecture to ensure source database and target database synchronization and high availability?
- Direct connection
- Logical offline migration
- Physical migration
- Logical online migration