1Z0-448 Exam Questions

Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.)

If multiple changes occur on the source system but have not yet been processed by ODI, the J$ table contains entries for each change for the records sharing the same PK. What happe...

You want to ensure that the Physical Mapping Design cannot be modified even if the Logical Design of the Mapping is changed. What sequence of steps must you follow to achieve this?...

Which two statements are true about the Oracle Data Integrator Software Development Kit (ODI SDK)? (Choose two.)

How do you reuse a configuration of OdiSendMail across multiple packages? (Choose the best answer.)

When Oracle Data Integrator (ODI) and Oracle GoldenGate are used together, which option represents the phases of an ELT process that Oracle GoldenGate performs? (Choose the best an...

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...

You need to create a package that automatically sends an alert to users in case the third step fails. Which option represents the steps to accomplish this? (Choose the best answer....

Identify two correct exception behavior values for Run Scenario steps in load plans. (Choose two.)

Which statement is true about defining more than one physical schema associated to the same data server? (Choose the best answer.)

You are working with delimited flat files and want to enforce a primary key on a flat file by using a Check Knowledge Modules (CKM). However, you encounter an error. Why did this h...

Which statement is correct about the tasks that Standalone Agents perform? (Choose the best answer.)

As part of your QA process you want to view code at the Step level in Operator. How must you proceed? (Choose the best answer.)

You are using a customized reverse knowledge module. You want the execution to be performed in only the development data environment. Which statement is true? (Choose the best answ...

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.)

Which product is included in ODI web-based components? (Choose the best answer.)

Which two statements are true about using ODI and Oracle GoldenGate together? (Choose two.)

You are working on notifications in a package and you must send an email containing an error message in case a Package step fails. Which odiRef method do you use to access the erro...

Which is the correct statement about the contents of Master repositories? (Choose the best answer.)

Which two statements are true about big data support in ODI? (Choose two.)

You want to add a new CDC subscriber in ODI after you have started the journal process. Which option represents the steps to use this new subscriber? (Choose the best answer.)

Identify two correct statements about reusable Mappings. (Choose two.)

Identify the name of the default WebLogic data source created for the Master Repository when setting up a JEE domain. (Choose the best answer.)

Which are the two correct statements about Work repositories? (Choose two.)

You need to reverse engineer a flat file that contains multiple record formats. How must you proceed? (Choose the best answer.)

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 an...

You must monitor and manage a co-located stand-alone agent, OracleDIAgent1, by using the ODI plug-in for Enterprise Manager Cloud Control. Which is the correct command to start thi...

You want to modify the code generated by a failed Task and restart the session. How must you proceed? (Choose the best answer.)

The source and target data stores are located on the same data server. Which statement is correct about the need for a Loading Knowledge Module to load the data on the target? (Cho...

Identify three capabilities of load plans. (Choose three.)

You must split a model with many database tables into multiple sub-models based on their names. How must you proceed? (Choose the best answer)

Which two objects can be dragged to a Mapping? (Choose two.)

Identify two correct Restart values for parallel steps in load plans. (Choose two.)

Which two statements are true about ODI web-based components? (Choose two.)

You are designing a load plan in which you must run Mappings A and B one after the other while running Mapping C at the same time. Which option represents the steps to accomplish t...

Which statement is correct about choosing the join order in an ODI Mapping when defining a join? (Choose the best answer.)

Identify two constraints that can be used to ensure uniqueness in ODI. (Choose two.)

You need to deploy ODI JEE Components on WebLogic Server. Where should you deploy them? (Choose the best answer.)

You must send the same message in multiple packages to several email addresses stored in the same database table. How do you accomplish this by using a reusable package step? (Choo...

You are designing a Mapping. How are target and source tables defined? (Choose the best answer.)

Updates have been made to Mappings in a package. What must you do to ensure that the Production team runs a scenario that contains those updates while preserving the existing scena...

What is the main benefit of using consistent set journalizing compared to simple journalizing? (Choose the best answer.)

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.)

Your project requires a loop through the same package logic 24/7. You must be able to purge those executions when required. How do you accomplish this? (Choose the best answer.)

How are the domains of ODI Agents configured? (Choose the best answer.)

You want to deploy the generated code manually in a source or target server, before executing a mapping in ODI. How can you accomplish this? (Choose the best answer.)

What must you set on the Definition tab of a variable to protect the variable value from being displayed in the Operator logs? (Choose the best answer.)

A Mapping that uses CDC does not load any source data and you want to check the SNP_CDC_SET table to find out the current window ID. In which database schema must you look to find...

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 te...

You design a package with mappings that consume data from journalized data stores in Consistent Set CDC mode. Which option represents the steps that must be performed at the beginn...