Font size
S
M
L
XL
WorksheetsDATABASE MIGRATION 1
Total questions: 31
Worksheet time: 1hrs 2mins
Name
Class
Date
1.
Which migration method gives you the least down time
a)
Data Guard
b)
RMAN point-in-time recovery
c)
Transportable Tablespaces
d)
Data pump
2.
You have a requirement to join data from an Oracle database table and a flat file and load into target DB2 table, using Oracle Data Integrator (ODI). Which statement is correct about this?
a)
Heterogeneous sources and targets are possible in a single mapping only if there is no incremental data load
b)
Flat file data has to have a header row in order to join with Oracle database table in a single mapping
c)
It is not possible to join data from different source connection types in a Single mapping
d)
It is possible to mix heterogeneous source connection type and load into any supported target connection type in a single mapping.
e)
It is possible to join data from different source connection types in mapping, but the result must be loaded to Oracle
3.
Which entry in a Data Pump parameter file ensures consistent export using Data Pump migration to Autonomous Database?
a)
PARALLEL
b)
LOGTIME
c)
METRIC
d)
FLASHBACK_TIME
4.
Which two migration methodologies can you use for migrating on-premises databases to Autonomous Database with Oracle Zero Downtime Migration (ZDM)? (Choose all correct answers)
a)
Physical Online
b)
Logical online
c)
Physical Offline
d)
Logical offline
5.
When migrating an Oracle database, you must be aware of source and target requirements. Which TWO statements are true about using Oracle Zero Downtime Migration (ZDM)? (Choose all correct answers)
a)
Source Oracle Single Instance Databases can be migrated to Oracle RAC Databases with Oracle ZDM-
b)
Oracle ZDM supports cross-edition migration, allowing Standard Edition Databases to be migrated to Enterprise Edition Databases
c)
When migrating with Oracle ZDM and the target database is at a higher patch level than the source database, the data patch utility runs on the target database as a post-migration task.
d)
Source Oracle Real Application Clusters (RAC) Databases can be migrated to Single Instance Databases with Oracle ZDM
6.
Planning a database migration to Oracle Cloud Infrastructure (OCI) requires understanding the source?
a)
users and groups to be migrated
b)
on-premises host operating system
c)
character set of databases
d)
number of tables
7.
Which TWO target database environments provide both high availability (HA) and disaster recovery (DR) options in the cloud? (Choose all correct answers)
a)
Autonomous Database
b)
Database Cloud service Bare Metal
c)
Infrastructure as a service
d)
Exadata Cloud Service
8.
You are planning the migration of a 19c Oracle Database from Amazon Web Services Relational Database Service (AWS RDS) using RMAN backups. What is the correct sequence of operations?
a)
Install the 0B Cloud Backup Module on the AWS ROS instance and perform a backup directly to an Oracle Cloud Intrastructure (OCI) Object storage bucket. Restore the backup from the OCI bucktt to an OCT DB Service instance
b)
Using the AWS tooling, take an RMAN backup of the RDS DB local file system and move it to an AWS S3 bucket. Copy the content of the S3 bucket to an Oracle Cloud Infrastructure (OCT) C. Object Storage bucket, Restore the backup from the OCI bucket to an OCI DB Service Instance.
c)
Install the Oracle Secure Backup Cloud Module on the AWS RDS Instance and take an RMAN backup directly to an AWS 53 bucket. Copy the content of the S3 bucket to an Oracle Cloud E. Infrastructure (OCI) Object Storage bucket. Restore the backup from the OCI bucket to an OCT DB Service Instance
d)
Using the AWS tooling, take an RMAN backup of the RDS DB local file system and copy sctly to. an Oracle Cloud Infrastructure (OCI) Object Storage bucket. Restore the backup from the OCI bucket to an OCI DB Service Instance.
9.
Which supported platform can the source Oracle Database be running on when migrating with Oracle Zero Downtime Migration?
a)
aix
b)
windows
c)
Linux x86-64
d)
Solaris
10.
You are migrating an on-premises Linux 11.2.0.4 Database to a Database Cloud Service by using the Cross-Platform Transportable Tablespace Backup Set. Which statement is true?
a)
The Database Cloud Service target version must be 12.1 or later.
b)
The Database Cloud Service target version must be 11.2.0.4.
c)
The Database Cloud service target iS a container database (CDB).
d)
FOR TRANSPORT and TO PLATFORM clauses are not supported in RMAN on version 11.2.0.4
11.
Which file types can be imported using SQL Developer Web?
a)
All of the options
b)
Excel
c)
AVRO
d)
CSV Delimited
e)
JSPN
12.
Which view is used to measure the replication latency between source and target when using the automatic heartbeat table feature, in GoldenGate?
a)
gg_lag
b)
goldengate_lag
c)
ogg_latency
d)
Lag_view
13.
You are trying to load a denormalized target table C and the source attributes come from table A and Table B in Oracle Data Integrator (ODI). Which statement is true?
a)
A mapping can have only one source and one target. You need to create 2 mappings to load target C
b)
You can join table A and table B, as required by the data model and load target C in a Single mapping
c)
You are required to do inner join between table A and table B in order to load target C.
d)
You are required to do outer join between table A and table B in order to load target C.
14.
You need to migrate your on-premises 12c Non CDB to Cloud 12c. Which migration methods can you use? (Choose two.)
a)
Conventional Data Pump Export and Import
b)
Transportable Databases
c)
Transportable Tablespaces
d)
. Conventional RMAN Backup and Recovery
15.
Your data warehouse load consists of extracting data from order header and order line items table. what kind of journalizing type should you use in Oracle Data Integration ( ODI ) to make sure referential integrity is maintained in the target?
a)
Consistent
b)
Application Base
c)
Complex
d)
Simple
16.
Which parameter can be used to export a subset of data using Data Pump?
a)
TABLES_AS_VIEWS
b)
SUBSET_AS_TABLES
c)
VIEWS_AS_TABLES
d)
MATERIALIZED_VIEWS
17.
Which four Oracle database version are supported for source databases when migrating with Oracle Zero Downtime Migration? (Choose all correct answers)
a)
Oracle Database 11g Release 2 ( 11.2.0.3 )
b)
Oracle Database 12c Release 1 ( 12.1.0.2)
c)
Oracle Database 12c Release 2 ( 12.2.0.1 )
d)
Oracle Database 11g Release 2 ( 11.2.0.4 )
e)
Oracle Database 19
18.
Which process does Oracle Data Integrator Enterprise Edition use to process and transform data for disparate relational database management systems or Big Data Engines?
a)
DML
b)
ELT
c)
SOA
d)
ETL
19.
Which database version introduced Zero Downtime online logical migration?
a)
Oracle Database 18c
b)
Oracle Database 21c
c)
Oracle Database 19c
d)
Oracle Database 12c
20.
Which FOUR key parameters should you include in your export command when migrating an Oracle Database to the Oracle Cloud? (Choose all correct answers)
a)
FLASHBACK_TIME=SYSTIMESTAMP (for consistent Export)
b)
parameter=1 (for performance) logtime=all (for Diagnostics)
c)
versron=10 (for compatibility) exclude=statistics (for performance
d)
metrics=yes (for Diagnostics)
21.
Which tools can be used to perform Oracle Zero Downtime logical migration? (Choose two.
a)
Oracle GoldenGate
b)
RMAN
c)
Data Guard
d)
Data Pump
22.
Which TWO object types should be excluded from an Autonomous Transaction Processing database? (Choose all correct answers)
a)
SCHEMA
b)
INDEXTYPE
c)
constraint
d)
CLUSTER
23.
Which three tasks can be executed when you submit a data integration job to an Oracle Data Integrator (ODI) agent? (Choose all correct answers)
a)
an operation on a model, sub model, or a data store, such as a customized reverse-engineering or a journalizing operation
b)
the execution of a runtime scenario or a Load plan that was launched from the Oracle Data Integrator Studio, from a command line, via a schedule or a web service interface
c)
setting up an FTP server as a staging location for extracted data
d)
the execution of a design-time object, such as a mapping, a package or a procedure backing up data warehouse destination objects before loading the transformed data
24.
What TWO ways does Data Pump use to move data to the cloud? (Choose all correct answers
a)
RMAN Backup and Restore
b)
pdb unplug/plug
c)
import over Oracle Database database link
d)
import dump file from OCI Object Storage
25.
Which Autonomous Data Warehouse (ADW) package is leveraged by the Business Intelligence Cloud Connector (BICC) Loading Knowledge Modules, when using Oracle Data Integrator (ODI)?
a)
Dbms_cloud_admin
b)
Dbms_cloud
c)
sa_audit_admin
d)
Dbms_cloud_macadm
26.
Which type of autonomous database will you create for decision support systems that run fast queries over large volumes of data?
a)
Autonomous Transaction Processing
b)
Autonomous JSON Database
c)
Autonomous Data Warehouse
d)
Autonomous APEX Service
27.
Which THREE methods can be used to migrate an on-premises Oracle Database to Oracle Autonomous Database? (Choose all correct answers)
a)
Data Pump Export/lmport
b)
Enterprise Manager
c)
Oracle Zero Downtime Migration
d)
Data Guard
e)
PDB Unplugging/Plugging
28.
You have a security requirement within your organization to separate your resources. There is a team that supports each resource and they are not allowed access to the other resources. Which security control with Oracle Cloud Infrastructure meets this requirement?
a)
Tagging
b)
Compartments and Policies
c)
Key Management
d)
Federation
29.
Which are THREE target database prerequisites for database cloud migration with Oracle Zero Downtime Migration? (Choose all correct answers
a)
Transparent Data Encryption (TDE) must be enabled.
b)
The database can be created only after migration has begun
c)
The database db_name should be the same as the source database.
d)
The TDE wallet status must be open.
e)
The TDE wallet status must be closed.
30.
In case of migration using the RMAN DUPLICATE command, which file do you use to specify the location of the Database Wallet?
a)
TNSNAMES.ORA
b)
SQLNET.ORA
c)
WALLET.ORA
d)
LISTENER.ORA
31.
Which three Oracle technologies are leveraged by Oracle Zero Downtime Migration Physical Online Workflow? (Choose all correct answers)
a)
. Oracle Data Guard
b)
Recovery Manager
c)
SQL*Net
d)
Oracle Real Application Testing
e)
Streams
Reset
