1094 Set1

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). Target and source have same Endianness. Source and target need to be container database (CDB). Source must be Little-endian. Target must be an Autonomous 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 (ADW)? (Choose all correct answers). Object Storage. BI Cloud Connector. File. In-Memory Engine. Oracle (ADW).

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). Logical online. Physical Online. Physical Offline. Logical offline.

Which TWO options are valid when using the unplug/plug a PDB method to migrate? (Choose all correct answers). Non-CDB databases can be consolidated and migrated. Source database versions are 12c or later. Use this technique to do a cross-endian conversion. Target database versions must be 18c or later.

Which process does Oracle Data Integrator Enterprise Edition use to process and transform data for disparate relational database management systems or Big Data Engines?. DML. ELT. ETL. SOA.

Which TWO statements are true about online pluggable database (PDB) relocation? (Choose all correct answers). Online PDB relocation can achieve a zero downtime upgrade. PDB relocation with no version change can be performed with near-zero downtime. Database version downgrade can be achieved with PDB relocation. A PDB with the ASCII character set can be relocated to a container database (CDB) with the AL32UTF8 character set.

Which type of checks is NOT supported by Oracle Data Integrator (ODI)?. mandatory attributes. conditions. references. business rule. keys.

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 raue 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?. Primary key was not defined on the target table. The integration type was not set in the logical design. The Check Knowledge Module was not set in the physical design. There were no rows compliant with imposed constraint.

Which TWO statements are true about cross-endian migration using Transportable Tablespaces? (Choose all correct answers). Tablespaces must be compressed. Tablespaces must be converted by either RMAN CONVERT Or DBMS_FILE_TRANSFER. Tablespaces may not be encrypted. system and sysaux can be migrated cross-endian.

What TWO ways does Data Pump use to move data to the cloud? (Choose all correct answers). import dump file from OCI Object Storage. pdb unplug/plug. RMAN Backup and Restore. import over Oracle 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). version=10 (for compatibility). exclude=statistics (for performance). parameter=1 (for performance). logtime=all (for Diagnostics). metrics=yes (for Diagnostics). FLASHBACK_TIME=SYSTIMESTAMP (for consistent Export).

Which view is used to measure the replication latency between source and target when using the automatic heartbeat table feature, in GoldenGate?. Lag_view. ogg_latency. goldengate_lag. gg_lag.

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?. Application Base. Complex. Simple. 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 )? (Choose all correct answers). J$ table. JW$ view. JV$D view. JV$ view.

Which four Oracle database version are supported for source databases when migrating with Oracle Zero Downtime Migration? (Choose all correct answers). Oracle Database 11g Release 2 ( 11.2.0.4 ). Oracle Database 12c Release 2 ( 12.2.0.1 ). Oracle Database 19. Oracle Database 12c Release 1 ( 12.1.0.2). Oracle Database 11g Release 2 ( 11.2.0.3 ). Oracle Database 10 g Release 2.

Which three backup mediums are supported when migrating a database with oracle zero downtime migration?. (Choose all correct answers). Oracle Zero data loss recovery appliance. Oracle Cloud Infrastructure Object Storage. Tape Storage. NFS Storage. Third-Party Cloud Storage.

Which FOUR Oracle Database Cloud Services are supported as a target database using Oracle Zero Downtime Migration? (Choose all correct answers). Exadata Cloud Service. Oracle MySQL Database Cloud Service. Oracle Database Cloud Service. Exadata Cloud at Customer. oracle NOSQL Database Cloud Service. Autonomous Database.

Which three Oracle technologies are leveraged by Oracle Zero Downtime Migration Physical Online Workflow? (Choose all correct answers). Oracle Real Application Testing. Streams. Recovery Manager. SQL*Net. Oracle Data Guard.

You have decided to use Oracle Data Integrator (ODI) on Marketplace to load data from an onpremises 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). Fast connect. Terminal service. VPN Connect. Oracle directory.

Which three tasks can be executed when you submit a data integration job to an Oracle Data Integrator (ODI) agent? (Choose all correct answers). 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. 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. setting up an FTP server as a staging location for extracted data. an operation on a model, sub model, or a data store, such as a customized reverse-engineering or a journalizing operation.

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 ? (Choose 3 all correct answers). list of all schemas. listing port of the oracle listener. database link. name of the Oracle Instance (SID) or service. network name or IP address of the machine hosting the Oracle Database.

What can you use to quickly load data into a cloud database by dragging and dropping a file in a web browser?. Remote cloning a pluggable database (PDB). RMAN Transportable Tablespace. Data Load tab of the SQL worksheet in Database Actions. Data Pump Transportable Tablespaces.

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?. Flat file data has to have a header row in order to join with Oracle database table in a single mapping. Heterogeneous sources and targets are possible in a single mapping only if there is no incremental data load. It is possible to mix heterogeneous source connection type and load into any supported target connection type in a single mapping. It is possible to join data from different source connection types in mapping, but the result must be loaded to Oracle. It is not possible to join data from different source connection types 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?. You are required to do outer join between table A and table B in order to load target C. A mapping can have only one source and one target. You need to create 2 mappings to load target C. You are required to do inner join between table A and table B in order to load target C. 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?. The Database Cloud Service target version must be 11.2.0.4. FOR TRANSPORT and TO PLATFORM clauses are not supported in RMAN on version 11.2.0.4. The Database Cloud Service target version must be 12.1 or later. The Database Cloud service target is a container database (CDB).

Which TWO methods should you use when migrating a target database with different endianness than the source database? (Choose all correct answers). RMAN CONVERT. RMAN Transportable Tablespaces with Data Pump. RMAN DUPLICATE. RMAN RESTORE from target.

Which TWO methods support a difference in endian format when migrating a database from onpremises to Oracle Cloud? (Choose all correct answers). PDB Unplugging/Plugging. PDB Remote Cloning. RMAN cross-Platform Transportable PDB. Data Pump Conventional Export/lmport.

Which THREE methods can be used to migrate an on-premises Oracle Database to Oracle Autonomous Database? (Choose all correct answers). Data Guard. Enterprise Manager. PDB Unplugging/Plugging. Data Pump Export/lmport. 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). Exadata Cloud Service. Autonomous Database. Infrastructure as a service. Database Cloud service Bare Metal.

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?. if you are using unplug/plug. if your target is Exadata Cloud Service. if you are using Recovery Manager (RMAN). if you are using virtual machines.

When selecting a migration method for moving your database to the cloud, what would you NOT take into consideration?. High Availability. Database Size. Database Version. Schema Name.

Which TWO methods are supported by Oracle Zero Downtime Migration (ZDM) for migrating onpremises databases to Autonomous Database? (Choose all correct answers). Logical online or offline migration using a database link. Logical online or offline migration using OCI Object Storage. Physical online or offline migration using OCI Object Storage. Physical online or offline migration using a database link.

Which TWO products/utilities does Oracle Zero Downtime Migration use as part of its migration workflows to Autonomous Database? (Choose all correct answers). GoldenGate. Data Pump. Data Guard. Recovery Manager.

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)? (Choose all correct answers). The database must have Transparent Data Encryption (TDE) enabled. Port 22 on the source database server must allow incoming connections from the ZDM service host. The database must be stored in an Automatic Storage Management Cluster File System (ACFS). The database must have a configured TDE wallet if the version is Oracle Database 11g Release 2 or 12c Release 1. Archivelog must be enabled.

Which are THREE target database prerequisites for database cloud migration with Oracle Zero Downtime Migration? (Choose all correct answers). The TDE wallet status must be closed. The TDE wallet status must be open. The database can be created only after migration has begun. The database db_name should be the same as the source database. Transparent Data Encryption (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)? (Choose all correct answers). Oracle ZDM supports cross-edition migration, allowing Standard Edition Databases to be migrated to Enterprise Edition Databases. 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. Source Oracle Single Instance Databases can be migrated to Oracle RAC Databases with Oracle ZDM. Source Oracle Real Application Clusters (RAC) Databases can be migrated to Single Instance Databases with Oracle ZDM.

Which Autonomous Data Warehouse (ADW) package is leveraged by the Business Intelligence Cloud Connector (BICC) Loading Knowledge Modules, when using Oracle Data Integrator (ODI)?. Dbms_cloud_admin. Dbms_cloud. sa_audit_admin. Dbms_cloud_macadm.

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)? (Choose all correct answers). REST API. Enterprise Scheduler Service (ESS) SOAP API. BI Cloud Connector. Universal Content Management. BI Application Configuration Manager.

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?. oracle Exadata Cloud Service. oracle Data Safe. oracle Autonomous Database. oracle MySQL 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?. Create a new OCI DB Service instance, delete the existing database, and use the DBaa$ tooling to configure the DB Cloud Backup Module to point to the existing bucket, and then restore the backup by using the console. Create a new OCI DB Service Instance, copy the backup data from the bucket to the FRA, and then use the console to perform a DB restore. Create a new OCI DB Service instance and use the instantiate from backup option in the console. This will automatically take care of the encryption. Create a new DB Service instance, delete the existing database, manually install the DB Cloud Backup Module pointing it to the backed where the on-premises backups are located, and perform a complted RMAN RESTORE AS encryption operation.

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 mastor key not yet set What are the TWO causes of this error? (Choose all correct answers). The OCT Object Storage eye on at rest key is missing. The set DECRYPTION IDENTIFIED BY RMAN command was not executed. The Set ENCRYPTION IDENTIFIED BY command was executed. The Set ENCRYPTION IDENTIFIED BY only command was executed. SET ENCRYPTION ON.

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?. 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. 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 Infrastructure (OCI) Object Storage bucket. Restore the backup from the OCI bucket to an OCT DB Service Instance. 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. 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) Object Storage bucket, Restore the backup from the OCI bucket to an OCI DB Service Instance.

Which are TWO benefits of Extract-Load-Transform (ELT) over traditional Extract-Transform-Load (ETL) architectures? (Choose all correct answers). ELT architecture does not require dedicated hardware and leverages native data management engines, such as Big Data and RDBMs. ELT architecture can easily become a bottleneck by placing excessive loads on the target servers. Traditional ETL tools use a dedicated server, which provides better performance as it can be sized to any workload. ELT architecture reduces the amount of network traffic over traditional ETL tools, which use a dedicated server.

Which supported platform can the source Oracle Database be running on when migrating with Oracle Zero Downtime Migration?. Aix. Windows. Solaris. Linux x86-64.

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?. Request a valid port number. Exit the installation with an error message. Assign a random port number. Increase the default port number by one and retry five times.

Which migration method gives you the least down time?. RMAN point-in-time recovery. Data Guard. Transportable Tablespaces. Data pump.

Planning a database migration to Oracle Cloud Infrastructure (OCI) requires understanding the source?. on-premises host operating system. users and groups to be migrated. number of tables. character set of databases.

What is the managed chatbot service of Oracle Cloud called?. Digital Assistant. Digital Integration. Digital Support. Digital Bot.

Which file types can be imported using SQL Developer Web?. All of the options. JSPN. Excel. AVRO. CSV Delimited.

You need to migrate your on-premises 12c Non CDB to Cloud 12c. Which migration methods can you use? (Choose two.). Transportable Tablespaces. Transportable Databases. Conventional RMAN Backup and Recovery. Conventional Data Pump Export and Import.

Which of these provide Active Replication?(Choose two.). Sharding. GoldenGate. Flashback. Active Data Guard.

Which Autonomous Data Warehouse (ADW) package is leveraged by the Business Intelligence Cloud Connector (BICC) Loading Knowledge Modules, when using Oracle Data Integrator (ODI)?. Dbms_cloud. Dbms_cloud_admin. Dbms_cloud_macadm. sa_audit_admin.

Which developer tool is web-based, function-rich, and resides in a low code development environment?. RMAN. IMPEXPDP. DATAPUMP. APEX.

Which entry in a Data Pump parameter file ensures consistent export using Data Pump migration to Autonomous Database?. FLASHBACK_TIME. METRIC. LOGTIME. PARALLEL.

How much network latency is tolerated by the Remote Apply process of Oracle GoldenGate?. 8ms. 16ms. 4ms. 6ms.

In Zero Downtime Migration, which port number is used by the source and target system to access Object Storage?. 443. 118. 1521. 22.

In order to migrate an active database using RMAN DUPLICATE, what information do you need for the source database? (Choose two.). Listener port. Value of the UNDO_RETENTION parameter. Database unique name. Location of audit files. Password for HR schema.

Which knowledge modules are supported by Oracle Data Integrator (ODI)?. All of the options. Spark. ADW. IBM DB2. Hive.

Which tools can be used to perform Oracle Zero Downtime logical migration? (Choose two.). RMAN. GoldenGate. Data Pump. Data Guard.

In case of migration using the RMAN DUPLICATE command, which file do you use to specify the location of the Database Wallet?. WALLET.ORA. LISTENER.ORA. TNSNAMES.ORA. SQLNET.ORA.

In which database edition does Data Pump support parallelism?. Data Pump does not support parallelism. Standard Edition only. Both Standard Edition and Enterprise Edition. Enterprise Edition only.

You are using Data Pump to migrate your database to Autonomous Database (ADB). To which tablespace must you remap your source database tablespaces?. USERS. SYSTEM. DATA. UNDO.

Which parameter can be used to export a subset of data using Data Pump?. TABLES_AS_VIEWS. MATERIALIZED_VIEWS. SUBSET_AS_TABLES. VIEWS_AS_TABLES.

What are the constraints of using transportable tablespaces? (Choose two.). The source and target character sets must match. The source and target platforms must match. The source and target time zone versions must match. The source and target database versions must match.

Which port number do all the OCI GoldenGate Microservices environments use for port forwarding through NGINX?. 1680. 1521. 22. 443.

Which database version introduced Zero Downtime online logical migration?. Oracle Database 12c. Oracle Database 19c. Oracle Database 21c. Oracle Database 18c.

When was SQL Developer Web released?. 2006. 2018. 2009. 2011. 2016.

In which mode must the auxiliary instance be started while using the RMAN DUPLICATE command for database migration?. MOUNT. OPEN. FORCE. NOMOUNT.

Which statements are true about Data Pump? (Choose two.). It supports cross-endian formats. A best practice is to invoke Data Pump using SYS as SYSDBA. It supports cross-platform migration. Both the source and target database must be of the same version.

Which autonomous database types are available on Oracle Cloud? (Choose three.). Autonomous Transaction Processing. Autonomous JSON Database. Autonomous Data Warehouse. Autonomous Streams. Autonomous Relation Database System.

Which developer tool can be used to load JSON documents to an Oracle database on the cloud?. REST Data Services. Modeler. SQL Developer. SQL Developer Web.

Which Oracle product provides high performance bulk data movement, massively parallel data transformation using database or BI data technologies, and block-level data loading that leverages native data utilities?. Oracle Analytics Server. Oracle Big Data. Oracle Data Guard. Oracle Data Integrator.

Which statements are true for Zero Downtime Migration? (Choose two.). It does not leverage Oracle MAA best practices. It is a complex process that requires you to raise an SR with Oracle Support. It is free. It ensures zero data loss.

What does ETL stand for?. Export Translate and Load. Extract Translate and Load. Extract Transform and Load. Export Transform and Load.

Which of these can be used to unload and load data via Data Pump? (Choose two.). Network mode (with database links). Dumpfile. Streamfile. Backupset.

Which technologies can you use for Zero Downtime physical migration? (Choose two.). Data Guard. RMAN. Data Pump. GoldenGate.

Which type of autonomous database will you create for decision support systems that run fast queries over large volumes of data?. Autonomous APEX Service. Autonomous JSON Database. Autonomous Transaction Processing. Autonomous Data Warehouse.

Which statement is true?. One PDB consists of only one CDB. One CDB can have one or more PDBs. One PDB consists of multiple CDBs. One CDB can have only one PDB.

You encounter error ORA-00245 while performing Zero Downtime Migration of an Oracle RAC database. What might be the reason for this?. Port 1521 is open. TDE Wallet is configured. The RAC instances are running in Archivelog mode. SNAPSHOT CONTROL is not pointing to a shared location on all Oracle RAC instances.

Which type of Zero Downtime Migration (ZDM) can you use for Inflight Upgrade?. Physical Migration only. Both Physical and Logical Migration is supported. Logical Migration only. ZDM does not support Inflight Upgrade.

Which source database versions are supported for OCI Database Migration? (Choose two.) (Choose all correct answers). Oracle Database 11g. Oracle Database 10g R2. Oracle Database 10g R1. Oracle Database 19c.

Which statements are true for OCI GoldenGate Service? (Choose two.). It requires any source environment to run Oracle GoldenGate Microservices. It is customer-managed. It supports the usage of Universal Credits. It requires an on-premises license for the Oracle GoldenGate software.

Which FOUR Oracle Data Pump impdp parameters should you use when migrating to Autonomous Database? (Choose all correct answers). TRANSFORN PORTABLE=ALWAYS. TRANSFORM=CONSTRAINT_USE_DEFAULT_INDEX:Y. REMAP_SCHEMA=SYSTEM. REMAP_TABLESPACE=DATA. TRANSFORN=SEGMENT_ATTRIBUTES:N. TRANSFORN=DWCS_CVT_IOTS:Y.

Which TWO object types should be excluded from an Autonomous Transaction Processing database? (Choose all correct answers). constraint. cluster. DB -LINK. SCHEMA.

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?. Compartments and Policies. Key Management. Tagging. Federation.

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?. Private host. Baston host. Isolation host. Encrypted 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? (Choose all correct answers). "-dbpatchlevel". "-tdemasterkey". "-sourcedb". "-sourceid". "-tgtroot". "-dbversion".

Which TWO statements are true about the Oracle Zero Downtime command line? (Choose all correct answers). 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. 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. 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. he -sourcedb option is the only valid option to indicate the source database name.

Which TWO provisions are required for Oracle Zero Downtime Migration (ZDM) to perform a database migration successfully with the physical workflow? (Choose all correct answers). Root user or SSH key-based access to source database server. Jmx connections to be accepted from multiple hosts. ZDM_BASE group access enabled. Root user or SSH key-based access to target database 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). Target and source have same Endianness. Source and target need to be container database (CDB). Source must be Little-endian. Target must be an Autonomous database.

Which TWO target database environments provide both high availability (HA) and disaster recovery (DR) options in the cloud? (Choose all correct answers). Autonomous Database. Infrastructure as a service. Database Cloud service Bare Metal. Exadata Cloud Service.

Which connectors are supported by the Oracle Data Integrator (ODI) web edition? (Choose three). Cloudera. MySQL . Amazon S3. Oracle Fusion Application. IBM DB2.

Which architecture is followed by Oracle Data Integrator (ODI)?. EPM. EBS. ELT. ETL.

Which is false about the Cloud Pre-Migration Advisor Tool (CPAT)?. It will assess your source database instance, checking for potentially problematic content and other factors that could impede a successful migration. It helps determine the suitability of migrating an Oracle database instance to one of Oracle’s cloud offerings. It is not integrated in DMS. It validates the source database for compatibility as part of the migration.

Which is not a benefit of Database Migrations?. Fully managed. Applications can stay online during migration. Improve performance in Oracle Cloud. Increase cost.

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 (BYOL). ODI Web Edition (free). ODI Classic (free). Enterprise Edition (BYOL).

 For which three cloud services does DBMS_CLOUD provide support for loading data from files to tables in Autonomous Database?. Dell EMC Elastic Cloud Storage. IBM Spectrum Storage. OCI Object Storage. Amazon AWS S3. OCI Object Storage Classic.

Which procedure do you use to load data directly into existing Autonomous Database tables?. DBMS_CLOUD.CREATE_EXTERNAL_TABLE. DBMS_CLOUD.PUT_OBJECT. DBMS_CLOUD.LIST_FILES. DBMS_CLOUD.COPY_DATA .

What does the database migration service use for migration?. RMAN Backup. Backup Cloud Module. Data Guard. GoldenGate.

What is the second step for Zero Downtime Migration - Logical Migration?. ZDM Connects to Source and Target. ZDM Configures an OGG Extract Microservice. Download & Configure ZDM. ZDM Connects to Backup Location.

What adds GoldenGate into its architecture to ensure source database and target database synchronization and high availability?. Direct connection. Physical migration. Logical online migration. Logical offline migration.

What is the second step for Zero Downtime Migration - Physical Migration?. ZDM Starts Database Migration. Download & Configure ZDM. ZDM Connects Source Database to Backup Location. ZDM Orchestrates Transfer of DB Backup Files.

Which three can Oracle Zero Downtime Migration migrate on-premises databases to?. Exadata Enterprise Service. Exadata Cloud Service. Database Cloud Service Bare Metal and Virtual Machine . Exadata Cloud at Customer.

ZDM supports databases on three platforms; which of the following is not one of those supported platforms?. Linux. AIX. Azure. Solaris.

Which two migration methods are recommended for small data sets for migrating to Exadata Cloud Service or Database Cloud Service instance?. RMAN Cross-Platform Transportable PDB. RMAN DUPLICATE from an Active Database. SQL Developer . Data Pump.

What are the five migration steps?. Validation . Deploy. Migration . Analysis . Discovery . Analytics. Planning .

 When selecting a migration method for moving your database to the cloud, which three should you take into consideration?. The database version. The migration cost. High Availability. The database size.

Which statement is false about Data Pump?. Provides fast unload and load via a dump file. Does not support encryption and compression. Platform and architecture independent. Can export and import the full database or a portion.

Which is false about Oracle Multitenant?. Applications run unchanged in self-contained pluggable databases or PDBs. Isolation and agility with economies of scale. Container database or CDB consolidates many PDBs. PDBs are difficult to clone and to move to around the cloud .

Which is false about application containers?. Allows application administrators to manage many tenants as one. Setup of tenants not very quick. Many tenants supported on small server footprint. Great isolation between tenants.

Which component produces a subset of the data coming from an upstream component using a filter condition?. Distinct Component. Sort Component. Filter Component . Join Component.

Which component removes duplicates in records coming from an upstream component?. Sort Component. Distinct Component. Filter Component. Join Component.

There are two kinds of mapping components: projector components and selector components. Which THREE are examples of a projector component?. Define their own attributes; attributes from preceding components are mapped through expressions to the projector’s attributes. . Hide attributes originating from preceding components; all succeeding components can only use attributes from the projector. Combine attributes from the preceding components (in the case of Join and Lookup selectors). Reuse attributes from preceding components. Influence the attributes present in the data that flows through a mapping.

Which Oracle Database Cloud Service takes care of all routine database tasks ensuring higher performance, reliability, security, and operational efficiency?. Oracle Autonomous Database. Oracle Exadata. Oracle MySQL Cloud Service. Oracle 19c.

Which two methods support a difference in database versions when migrating a database from on-premises to Oracle Cloud?. Clone from Backup. PDB Unplugging/Plugging. Data Pump Export/Import. Data Guard.

You are asked to isolate all the erroneous rows into error tables before they get into the target tables, in order to have a list of corrections that need to be addressed before the next run. At the next run, the demand is to check whether there are some rows that have been fixed and automatically include them in the integration file. Which two conditions need to be met to accomplish this demand in Oracle Data Integrator (ODI)?. The Check Knowledge Module must have the RECYCLE_ERRORS option set to TRUE. You must have an update key on the target table. You must have a primary key on the target table. The flow control has to be enabled and the RECYCLE_ERRORS option set to TRUE. The static control has to be enabled and the RECYCLE_ERRORS option set to TRUE.

When preparing for a migration using RMAN_DUPLICATE from an active database, which two actions do you need to take if the on-premises database (DB) is Transparent Data Encryption (TDE) encrypted?. Copy the encryption wallet from the on-premises DB to the Cloud DB system. Perform an RMAN backup of the on-premises DB to OCI Cloud Storage. Use the dbcli dbstorage command to identify the DATA, RECO and REDO locations. Make sure that the SYS user password is identical on both systems.

How can you properly pause a Zero Downtime Migration (ZDM) job?. By executing the zdmcli -pausejob command at any time. By executing the zdmcli migrate database command with the -pauseafter option, alongside specifying the relevant migration phase where ZDM should pause the process or by executing the zdmcli suspend job -jobid command at anytime during the migration. By querying the ZDM service host with the relevant job ID and executing the zdmcli -pausejob command. By executing the zdmcli migrate database command using the -pause option.

Before submitting the database migration job for the production database, you should perform a test migration to determine how the process will work with your configuration and settings. Which option should you use to run an evaluation of the migration process using the Oracle Zero Downtime command line?. -assess. -check. -evaluate. -eval. -pre-check.

Projector components in a mapping hides attributes from preceding components. All succeeding components can only use the attributes from projector component. Which three components below are NOT a projector component in Oracle Data Integrator (ODI)?. Join. Sort. Distinct. Filter. Aggregate.

When migrating to a database with Oracle Zero Downtime Migration, what is the first version of the Oracle database that is required to configure a Transparent Data Encryption (TDE) wallet if the source database does not have TDE enabled?. Oracle Database 12c Release 1 (12.1.0.2). Oracle Database 11g Release 2 (11.2.0.4). Oracle Database 18 Release 3 (18.3) and later releases. Oracle Database 12c Release 2 (12.2.0.1).

Your source database version is 12c and your target database is ATP-D. Which utility should you use to instantiate the target database?. Oracle Data Pump. SQL Developer Migration Wizard. Oracle RMAN Duplicate Database. Datafile Copy to Object Storage.

Your source tables are in an on-premises Oracle Database. You have created the data server and logical schema in an Oracle Data Integrator (ODI) topology. Now you are ready to start reverse engineering and create mappings. Which two Knowledge Modules (KM) need to be imported to your project for the Oracle Database source?. LKM SQL to MSSQL. LKM SQL to Oracle. RKM Oracle. IKM XML Control Append. CKM HSQL.

What are three methods to detect changed data in the source in Oracle Data Integrator (ODI)?. Golden Gate. Database Triggers. Database constraints. Last update data column. Primary Key.

You want to replicate data real time between two Oracle Databases. Which integration product should you use?. Oracle GoldenGate. Oracle Data Integrator. Oracle Enterprise Data Quality. Oracle Enterprise Manager.

In which TWO ways can you use SQLcl to load data or migrate a database into an Oracle Cloud Database?. Object Storage and SQLcl Data Pump Export/Import. Streaming Service and Alert Logs. Log Analytics and Functions. Object Storage and the SQLcl LOAD command.

You want to migrate only selected objects to a cloud database using SQL Developer. Which are the two main steps that you need to perform?. Transfer the SQL*Loader files for each object to the Database Service node and invoke the SQL*Loader to load the data. Connect to the cloud database and hand copy the code from SQL Developer. Generate the DDL for every object by viewing them one at a time. Using SQLDeveloper, drag and drop database objects from an on-premises database into the Cart for loading into a cloud database and export them using the loader in the format menu.

In which three cases should you use Data Pump to load data into Cloud Database?. When you want to migrate from Oracle Database 9i or earlier. When you want to migrate from a non-Oracle database. When you need to transform metadata. When you want to load all or some of the data. When you need fast unload and load.

Which two statements are true about pluggable database (PDB) relocation as a method of migration to Oracle Cloud Infrastructure (OCI). PDB relocation into a .pdb file result in a single file to be migrated. Migration between container databases (CDBs) with the same endianness is supported. No down time is needed. Target databases can be non-CDB.

Which statement is NOT true about the multitenant (container database) architecture of Oracle Database?. The SGA is shared between PDBs. The redo log files are shared between PDBs. The data files are shared between PDBs. The background processes are shared between PDBs.

Which two tasks are considered most time-consuming for migrating databases to Oracle Cloud?. Test source data performance. Copy existing data from source. Resynchronize by applying changes to target. Gather source database statistics.

You took a backup to DISK on the on-premises database and copied it to an Object Storage bucket to be used to instantiate a new Database Cloud Service. Which RMAN operation is required before the backup can be restored?. Export backup. Encrypt backup. Decrypt backup. Uncompress backup.

Which three supported platforms can the source Oracle Database be running on when migrating with Oracle Zero Downtime Migration (ZDM)?. AIX. Solaris. Windows. HP-UX. Linux X86-64.

You have decided to use Oracle Data Integrator (ODI) on Oracle Cloud Infrastructure (OCI) Marketplace to load data from an on-premises Oracle Database to an Autonomous Database on OCI. In which two locations can you create the ODI repository, while provisioning ODI through Marketplace?. On-premises Oracle Databases. Oracle Object Store. Embedded repository (MySQL database on OCI compute). Oracle Big Data Service. Autonomous Database.

Which object types should be excluded when migrating to Autonomous Data Warehouse?. TABLE. USER. INDEX, INDEXTYPE. CLUSTER. DB_LINK. MATERIALIZED_VIEW, MATERIALIZED_VIEW_LOG, MATERIALIZED_ZONEMAP.

You are ready to use the data store in the mapping but the Change Data Capture (CDC) icon for your data store is not green. What action do you need to take in order to make sure the CDC process starts tracking changes in Oracle Data Integrator (ODI)?. Reverse Engineer. Add to CDC. Start Journal. Add Primary Key. Configure simple/consistent journalizing option.

Which platform and version supports the deployment of Oracle Zero Downtime Migration Service host?. Red Hat Enterprise Linux 8.2. Windows 2012 R2 and 2016 R1. Oracle Linux 7. Solaris 11 Update 3 or later. IBM AIX 7.1 and later.

Which source database configuration does NOT influence your database migration options to Oracle Cloud Infrastructure (OCI)?. Database Size. Tablespaces. Endian format. Character set. Database version.

Which two tasks are NOT included in the automated steps of Oracle Zero Downtime Migration (ZDM) Physical Migration Workflow?. ZDM synchronizes Primary and Standby databases. ZDM encrypts data on the source database. ZDM starts database migration. ZDM connects the source database to the backup location. ZDM instantiates a Standby database. ZDM performs performance tests in the target database.

An entire container database (CDB) needs to be migrated to OCI (Oracle Cloud Infrastructure) while the database is still active and available. Which RMAN method can be executed for the migration?. RMAN RESTORE from target. RMAN CONVERT. RMAN Transportable Tablespaces with Data Pump. RMAN DUPLICATE.

Journalizing Knowledge Module (JKM) has the code to physically implement CDC process. At what object level is JKM applied to, in Oracle Data Integrator (ODI)?. Model Folder. Project. Data Store. Model.

What four best practices should you follow with Oracle Data Pump when migrating an Oracle Database to the Oracle Cloud?. Use a parameter file for export and import commands. Use SYS as SYSDBA. Do not use SYS as SYSDBA. Use a single dump file for all data and metadata. Perform a schema-level export. Export to multiple dump files with wildcards.