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?

• A.The integration type was not set in the logical design.
• B.There were no rows compliant with imposed constraint.
• C.The Check Knowledge Module was not set in the physical design.
• D.Primary key was not defined on the target table.

Comment: *

Name: *

Email: *

Verification: *

Which TWO target database environments provide both high availability (HA) and disaster recovery (DR) options in the cloud? (Choose all correct answers)

• A.Exadata Cloud Service
• B.Infrastructure as a service
• C.Autonomous Database
• D.Database Cloud service Bare Metal

Comment: *

Name: *

Email: *

Verification: *

What does ETL stand for?

• A.Export Translate and Load
• B.Extract Translate and Load
• C.Export Transform and Load
• D.Extract Transform and Load

Comment: *

Name: *

Email: *

Verification: *

In case of migration using the RMAN DUPLICATE command, which file do you use to specify the location of the Database Wallet?

• A.WALLET.ORA
• B.LISTENER.ORA
• C.SQLNET.ORA
• D.TNSNAMES.ORA

Comment: *

Name: *

Email: *

Verification: *

Which TWO object types should be excluded from an Autonomous Transaction Processing database? (Choose all correct answers)

• A.cluster
• B.SCHEMA
• C.constraint
• D.DB -LINK

Comment: *

Name: *

Email: *

Verification: *