1z0-482 | Simulation Oracle 1z0-482 exam question
Q1. Which two ODI knowledge modules are included in the Application Adapter for Hadoop?
A. IKM Oracle Incremental Update
B. IKM Hive Transform
C. IKM SQL to File Append
D. IKM File to Hive
Answer: BD
Q2. In an ODI package, is it possible to use a tool to purge logs based on the name of the agent that executed the session?
A. No, it is only possible to purge the logs of the sessions that run in a specific period of time.
B. No, it is only possible to purge the logs of the properly ended sessions.
C. Yes, it is possible but you also need to indicate the ODI user that ran the session.
D. Yes, it is one of the parameters available to purge the log.
Answer: D
Q3. Identify two Change Data Capture implementation strategies provided through the ODI knowledge modules.
A. Triggers
B. Oracle GoldenGate
C. Extract source data to flat files
D. Before and after database image comparison
Answer: AB
Q4. Identify three objects from which scenarios can be generated.
A. Interface
B. Variable
C. Package
D. Knowledge modules
E. Trail
F. Extract
Answer: ABC
Q5. Identify two operations that can be achieved using the ODI SDK.
A. Create users
B. Create interfaces
C. Create Master and Work repositories
D. Create security profiles
Answer: BC
Q6. Identify the right variable step type to use when assigning a value to a variable with a SQL query.
A. Refresh Variable
B. Declare Variable
C. Set Variable
D. Evaluate Variable
Answer: C
Q7. To load a specific table using ODI, do you need to draw directly in the flow all details about how the different servers involved are connected?
A. Yes, and also specify with variables the passwords for connecting to the data contained in the servers.
B. No, the code will be black box-generated directly by ODI.
C. No, ODI automatically designs the flow and how servers are connected.
D. In the ODI interface palette, choose the more convenient graphic objects to link the involved servers.
Answer: C
Q8. Identify two true statements regarding the ODI SDK.
A. The ODI SDK is used to load data between Teradata and Oracle.
B. The ODI SDK can be used to embed ODI processes into another product.
C. The ODI SDK is required to be used by ETL developers in order to develop ODI processes,
D. The ODI SDK allows developers to execute most ODI operations through a Java program.
Answer: AD
Q9. Can a project in ODI contain a user function to translate commands with different syntax for different technologies but with the same functionality?
A. No, a customized knowledge modules is needed.
B. No, this must be explicitly mapped to an ODI interface.
C. Yes, but an ODI procedure must be associated for it to be implemented.
D. Yes, it can be defined for every technology that is listed in Topology.
Answer: D
Q10. You are running a Scenario in a Load Plan using a Run Scenario step. This scenario contains the Interfaces. In case of failure in this Scenario, you would like to restart the Interface that failed beginning. Which Restart Type option do you need to pick for the Run Scenario step?
A. Restart from new session
B. Restart from failed step
C. Restart from failed task
D. Restart from failure
Answer: B