Free Oracle 1z0-448 Exam Dumps Questions & Answers

You are designing a load plan in which you must create multiple branches based on the value of a variable. How do you accomplish this by using Load Plan Editor? (Choose the best answer.)

• A.  Create a scenario from the variable and add the scenario to the load plan to create a case step.
• B.  Drag the variable into the load plan and define a case step.
• C.  Add a case step and drag the variable into the case step.
• D.  Add a case step in the load plan and select a variable in the wizard.

Identify the ODI tool used to write content into a file in a package. (Choose the best answer.)

• A.  OdiFileCopy
• B.  OdiInFile
• C.  OdiFileMove
• D.  OdiOutFile

You are setting up the topology for an infrastructure with three different environments: Dev, QA, and Prod. How must you create Logical Schemas? (Choose the best answer.)

• A.  Create one Logical Schema per Context.
• B.  Create one Logical Schema per Physical Schema.
• C.  Create one Logical Schema per Physical Schema that stores the same type of data.
• D.  Create one Logical Schema per Data Server.

Which statement is true about the IKM SQL Control Append that creates an intermediate integration table prefixed with I$? (Choose the best answer.)

• A.  Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.
• B.  Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load.
• C.  Theintermediate integration table prefixed with I$is required to determine which records must be inserted.
• D.  IfFlow Control is not necessary, an I$ table is not created.

You need to implement security mechanisms that allow only user "A" to view all the Mappings contained in a specific project named "P1." How must you proceed? (Choose the best answer.)

• A.  Go to Security, assign the NG DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally set View privileges to Active for the Project, Folder, and Mapping objects.
• B.  Go to Security, assign the DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally set View privileges to Active for the Project, Folder, and Mapping objects.
• C.  Go to Security, assign the NG DESIGNER profile to user "" Next, drag project "P1" to user "A" and finally setView privilegesto Active for the Mapping objects.
• D.  Go to Security, assign the DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally set View privileges to Active for the Mapping objects.