Free Oracle 1z0-482 Exam Dumps Questions & Answers

Which two ODI knowledge modules are included in the Application Adapter for Hadoop?

• A.IKM Hive Transform
• B.IKM SQL to File Append
• C.IKM File to Hive
• D.IKM Oracle Incremental Update

When using a customized reverse knowledge module, can the execution be done only on the development environment?

• A.Yes, as long as the other environment is a mirrored copy.
• B.No, all environments linked to a logical schema can be used to reverse-engineer table structure,
• C.No, only the production environment can be used.
• D.No, only a Java engine intermediate environment can be processed.

You are loading a file into a database but the file name is unknown at design time and will have to be passed dynamically to a Package at run time; how do you achieve this?

• A.Create a variable, use it as the Resource Name of the File datastore, and add it to a package as a Set Variable step
• B.Create a variable, use it in Topology at the File dataserver-level, and add it to a package as a Set Variable step
• C.Create a variable, use it in Topology at the File dataserver-level, and add it to a package as a Declare Variable step
• D.Create a variable, use it as the Resource Name of the File datastore, and add it to a package as a Declare Variable step

When defining a data store in ODI metadata, is it possible to add a primary key even if it does not physically exist on the related database catalog?

• A.Yes, by adding constraints to the datastore diagram.
• B.Yes,by adding constraints on the datastore.
• C.No, you can only flag non-null conditions to be checked.
• D.No, you can only reverse-engineer existing constraints.

Which property file parameter stores the location of the OBBIE web catalog folder?

• A.OBIEE_WEBCAT__FILE
• B.OBIEE_WEBCAT_EXPORT_FILE
• C.OBIEE_WEBCAT_FOLDER_TO_EXPORT
• D.OBXEE WEBCAT