Online Access Free 1z0-448 Practice Test

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.Add a case step in the load plan and select a variable in the wizard.
• C.Add a case step and drag the variable into the case step.
• D.Drag the variable into the load plan and define a case step.

Your package logic requires you to retrieve the status of the previous package step into a variable.
How must you implement this? (Choose the best answer.)

• A.Create a variable, useodiRef.getPrevInfo ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.
• B.Create a variable, useodiRef.getPrevStepLog ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.
• C.Create a variable, useodiRef.getPrevStepStatus ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.
• D.Create a variable, useodiRef.getStep ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

You must ensure that your Mappings do not run into connectivity issues when moving data from server A to server B by using an AGT agent that is running on server B.
How must you test this by using ODI Studio running on machine C? (Choose the best answer.)

• A.In Topology, test the connections to servers A and B by using the AGT agent.
• B.In Topology, test the connections to the AGT agent.
• C.UseOdiPingAgentin a package to ping AGT agent.
• D.In Topology, test the connections to servers A and B by using Local (No Agent).

You are defining a data store in ODI metadata and want to add a primary key even if it does not physically exist on the related database catalog.
How can you accomplish this? (Choose the best answer.)

• A.You can add a primary key even if it does not physically exist on the related database catalog, by adding constraintson the data store.
• B.You cannot add a primary key if it does not physically exist on the related database catalog. You can flag only non-null conditions to be checked.
• C.You cannot add a primary key if it does not physically exist on therelated database catalog. You
  can reverse engineer only the existing constraints.
• D.You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints to the data store diagram.

You create two mappings that both use the same changed data and run at different times. One runs every 15 minutes and the other runs once every day.
What must you do to ensure that the Mapping that gets executed more often does not consume the changed data required by the other Mapping? (Choose the best answer.)

• A.Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change theJRN_SUBSCRIBERcolumn in the correspondingJ$table to keep the changed data present for the second Mapping.
• B.Create two distinct subscribers for each Mapping.
• C.Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.
• D.Duplicate the source data store for each Mapping.