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
Which knowledge modules are supported by Oracle Data Integrator (ODI)?
A. IDB DB2
B. All of the options
C. Spark
D. Hive
E. ADW
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)
A. JV$D view
B. J$ table
C. JV$ view
D. JW$ view
When integrating data from multiple sourcesinto 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?
A. Primary key was not defined on the target table.
B. The Check Knowledge Module was not set in the physical design.
C. The integration type was not set in the logical design.
D. There were no rows compliant with imposed constraint.
Which developer tool is web-based, function-rich, and resides in a low code development environment?
A. APEX
B. RMAN
C. IMPEXPDP
D. DATAPUMP
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. EnterpriseManager
C. Oracle Zero Downtime Migration
D. Data Guard
E. PDB Unplugging/Plugging
Which are TWObenefits of Extract-Load-Transform (ELT) over traditional Extract- Transform-Load (ETL) architectures? (Choose all correct answers)
A. ELT architecture reduces the amount of network traffic over traditional ETL tools, which use a dedicated server.
B. ELT architecture can easily become a bottleneck by placing excessive loads on the target servers.
C. ELT architecture does not require dedicated hardware and leverages native data management engines, such as Big Data and RDBMs.
D. Traditional ETL tools use a dedicated server, which provides better performance as it can be sized to any workload.
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?
A. oracle ExadataCloud Service
B. oracle Data Safe
C. oracle MySQL Cloud Service
D. oracle Autonomous Database
In which mode must the auxiliary instance be started while using the RMAN DUPLICATE command for database migration?
A. NOMOUNT
B. OPEN
C. FORCE
D. MOUNT
Which of these provide Active Replication? (Choose two.)
A. Flashback
B. Active Data Guard
C. Sharding
D. GoldenGate
