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?
Answer
Consistent
You have executed the mappings with Change Data Capture (
CDC ) on the source data store and you are now going through the code in the
operator log for debugging. Which two tables or view do you need to inspect in
the database to see whether the CDC process is writing changed data or not in
Oracle Data Integration ( ODI )?
Answer
JV$D
JV$
Which four Oracle database version are supported for source
databases when migrating with Oracle Zero Downtime Migration?
Answer
11gR2 and above
Which Three backup mediums are supported when migrating a
database with oracle zero downtime migration?
Answer
Oracle Zero data loss recovery appliance
Object Storage
NFS Storage
Which FOUR Oracle Database Cloud Services are supported as a
target database using Oracle Zero Downtime Migration ?
Answer
Exadata cloud service
Oracle database cloud service
Exadata cloud @customer
Autonomous database
Which three Oracle technologies are leveraged by Oracle Zero
Downtime Migration Physical Online Workflow?
Answer
Recovery Manager
Oracle Data Guard
SQL*Net
You have decided to use Oracle Data Integrator (ODI) on
Marketplace to load data from an on-premises Oracle Database to Autonomous
Database on Oracle Cloud Infrastructure (OCI). Which TWO methods can be used to
connect to the on- premises Oracle Database from OCI? (Choose all correct
answers)
Answer
Fast Connect
VPN Connect
Your source tables are in an on-premises Oracle Database.
You are creating a data server in Oracle Data Integrator (ODI) topology. Which
THREE configuration items are needed to successfully test an on-premises Oracle
Database connection ?
Answer
Network name or IP address
Oracle SID
Listener port
Which TWO methods should you use when migrating a target
database with different endianness than the source database?
Answer
RMAN CONVERT
RMAN Transportable Tablespaces with Data Pump
What can you use to quickly load data into a cloud database
by dragging and dropping a file in a web browser?
Answer
Data Load tab of the SQL worksheet in Database actions
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?
Answer
It is possible to mix heterogeneous source
connection type and load into any supported target connection type in a single
mapping.
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?
Answer
You can join table
A and table B, as required by the data model and load target C in a single mapping
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?
Answer
The database could
service target version must be 11.2.0.4
Which TWO methods support a difference in endian format when
migrating a database from onpremises to Oracle Cloud? (Choose all correct
answers)
Answer
RMAN cross-Platform Transportable PDB
Datapump
Conventional export/import
Which THREE methods can be used to migrate an on-premises
Oracle Database to Oracle Autonomous Database? (Choose all correct answers)
Answer
Enterprise manager
Datapump export and import
Oracle zero downtime migration
Which TWO target database environments provide both high
availability (HA) and disaster recovery (DR) options in the cloud? (Choose all
correct answers)
Answer
Exadata Cloud service
Autonomous database.
You run a database instance on Oracle Database 11.2 and you
want to migrate to Oracle Cloud. In which case is it required to upgrade your
source database before migrating to the cloud?
Answer
( ****I am not sure about the answer****)
If your target is Exadata Cloud Service
OR
If you are using unplug/plug
When selecting a migration method for moving your database to the cloud, what would you NOT take into consideration?
Answer
High Availability
Database Size
Database version
Schema name
Which TWO methods are supported by Oracle Zero Downtime
Migration (ZDM) for migrating on-premises databases to Autonomous Database?
(Choose all correct answers)
Answer
Logical online or
offline migration using database link
Logical online or offline migration using OCI Object
storage
Which TWO products/utilities does Oracle Zero Downtime
Migration use as part of its migration workflows to Autonomous Database?
(Choose all correct answers)
Answer
Golden gate
Data pump
For a source database to be successfully migrated, you must
view and apply the prerequisites. Which TWO prerequisites must pass before the
source database can be migrated using Oracle Zero Downtime Migration (ZDM)
Answer
Port 22 on source
database server must allow incoming connections from ZDM
Archivelog must be
enabled
Which are THREE target database prerequisites for database
cloud migration with Oracle Zero Downtime Migration?
Answer
The TDE wallet must
be open
The database
db_name must be same as source
TDE must be enabled
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)?
Answer
Source Oracle
single instance can be migrated to Oracle RAC
Oracle RAC can be
migrated to single instance database
Which Autonomous Data Warehouse (ADW) package is leveraged
by the Business Intelligence Cloud Connector (BICC) Loading Knowledge Modules,
when using Oracle Data Integrator (ODI)?
Answer
Dbms_cloud_admin
Which THREE Fusion SaaS components from the Oracle Data
Integrator (ODI) Loading Knowledge Modules can be used to extract data out of
Fusion Saas applications and load it into Autonomous Data Warehouse (ADW)?
Answer
REST API
Enterprise
Scheduler Service SOAP API
BI Cloud connector
You are looking at migrating a large data centre to the
Oracle Cloud while trying to consolidate many Oracle Databases at the same
time. Which Oracle Data Management Service helps you achieve this?
Answer
Oracle Exadata
cloud service
You have an on-premises non-TDE-encrypted Linux 19c container
database (CDB) that is already being regularly backed up to Oracle Cloud
Infrastructure (OCI) Object Storage via the Database Backup Cloud Service. You
plan on using Recovery Manager (RMAN) to migrate it to Database Cloud Service.
What is the valid strategy to migrate?
Answer
Create New DB
instance, delete the existing database, manually install the DB cloud backup
service, perform a complete RMAN restore as encryption enabled.
You are migrating a non TDE encrypted on-premises Database
to an OCT Database Service Instance ising RMAN.
You set up the DB Cloud Backup Module, but when executing
the RMAN
command to create your Cloud Backup you see the following
error: AANA
RMAN-03009:
failure of backup command on ORA_SBT_TAPE 1 channel at:
08/18/2014 11: ORA~19914: unable to encrypt backup ORA~29361
master key not yet set
What are the TWO causes of this error?
Answer
Set encryption is
on
set encryption
identified by command was executed.
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?
Answer
Using the AWS
tooling, take an RMAN backup of the RDS DB local file storage and move it AWS s3 bucket, copy contents of S3
bucket to OCI object storage, restore the backup from OCI bucket to OCI DB service
instance
Which are TWO benefits of Extract-Load-Transform (E-LT) over
traditional Extract- Transform-Load (ETL) architectures?
Answer
ELT doesn't require
dedicated hardware and leverages native data management engines, such as Big data and RDBMS
ELT architecture
reduces the amount of network traffic over the other ETL tools, which use a dedicated server.
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)
Answer
Target and Source
have same Endianness.
Source and target
needs to be container database.
You are using Oracle Data Integrator (ODI). Which three
topology elements are required to extract data out of Fusion SaaS applications
and load it into Autonomous Data Warehouse?
Answer
Object storage
Bl cloud connector
File
Which two migration methodologies can you use for migrating
on-premises databases to Autonomous Database with Oracle Zero Downtime
Migration (ZDM)?
Answer
Logical online
Logical offline
Which Oracle Database Cloud Service takes care of all
routine database tasks ensuring higher performance, reliability, security, and
operational efficiency?
Answer
Oracle autonomous database
Which type of checks is NOT supported by Oracle Data Integrator
(ODI)?
Answer
Business rules
Which supported platform can the source Oracle Database be
running on when migrating with Oracle Zero Downtime Migration?
Answer
Linux x86-64
Which TWO options are valid when using the unplug/plug a PDB
method to migrate?
Answer
Non-CDB databases
can be consolidated and migrated
Source database
versions are 12c and higher
Which TWO statements are true about online pluggable
database (PDB) relocation?
Answer
Online PDB
relocation can achieve a zero-downtime upgrade
PDB relocation with
no version change can be performed with near-zero downtime
When integrating data from multiple sources into a Data
Warehouse schema, you want to check a length constraint that you have imposed
on one of the target columns before the rows arrive in the target table. All
the rows that do not pass this quality check will have to be isolated in error tables.
For this, you have chosen an Integration Knowledge Module
(IKM) that supports flow control.
You have also chosen the value true for this parameter to
enable this check.
At compile time, you see that Oracle Data Integrator (ODI)
throws an error and the execution cannot start. What is the reason?
Answer
The check knowledge module was not set in physical design
Which TWO statements are true about cross-endian migration
using Transportable Tablespaces?
Answer
Tablespaces must be converted by either RMAN CONVERT or DBMS_FILE_TRANSFER
Tablespaces may not be encrypted
What TWO ways does Data Pump use to move data to the cloud
Answer
Import dump file from OCI object storage
Import over database link
Which FOUR key parameters should you include in your export
command when migrating an Oracle Database to the Oracle Cloud? (Choose all
correct answers)
Answer
Exclude=statistics
Metrics=yes
LOGTIME=all
FLASHBACK_ TIME=SYSTIMESTAMP
Which process does Oracle Data Integrator Enterprise Edition
use to process and transform data for disparate relational database management
systems or Big Data Engines?
Answer
ELT
Which view is used to measure the replication latency
between source and target when using the automatic heartbeat table feature, in
GoldenGate?
Answer
GG_LAG
Which FOUR Oracle Data Pump impdp parameters should you use
when migrating to Autonomous Database?
Answer
Remap_tablespace%-DATA
Transform-CONSTRAINT_USE_DEFAULT_INDEX:Y
Transform-segment_attributes:N
Transform-DwCS_CVT_IOTS:Y
Which TWO object types should be excluded from an Autonomous
Transaction Processing database? (Choose all correct answers)
Answer
Cluster
DB-LINK
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?
Answer
Compartments and
Policies
When building out your private subnet, you realize you need
a host within your network in order to get access to the rest of your Oracle
Cloud Infrastructure instances. Which type of host should you set up to get
around this constraint?
Answer
Baston Host
In Oracle Zero Downtime Migration, the migrate database
command provides several options to ensure a successful Oracle source and
target data migration. Which FOUR are valid parameters to use with migrate
database?
Answer
-tdemasterkey
-sourcedb
-sourcesid
tgrroot
Which TWO statements are true about the Oracle Zero Downtime
command line?
Answer
Upon execution of
zdmcli , the only way to track the status of migration is querying the ZDM service using the provided
job ID
When the source is
single instance deployed on non-grid, the sourceid option should be used to specify the database name.
Which TWO statements are true about the Oracle Zero Downtime
command line?
Answer
Root user or ssh
key-based access to source and target.
Oracle Zero Downtime Migration (ZDM) uses MYSQL internally,
configuring on a default port number. What will ZDM proceed to, if a port
number is not specified and the default is not available?
Answer
Increase the default port number by one and retry five
times.
Which migration method gives you the least down time?
Answer
Data guard
Planning a database migration to Oracle Cloud Infrastructure
(OCI) requires understanding the source
Answer
On-premise host
operating system version
Character set of
database.
I hope it's helpful for you. If you have any queries, don't hesitate to contact me.
Thanks, brother. I have passed the exam.
ReplyDeleteYour welcome bro :)
Delete