Oracle 1z0-448 問題集

質問 1：
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.)
A. Drag the package to the last step in the package, run it asynchronously, and then save.
B. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save.
C. Link the last step of the package to its first step to create an infinite loop.
D. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save and regenerate this scenario.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
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.)
A. It is only possible to see code at the Session level.
B. Depending on the audit level declared when running the execution, some of the generated code at the step level can be viewed.
C. All generated code can be viewed together at the step level, with a complete list of executed code.
D. It is only possible to view code at the Task level.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which statement is correct about choosing the join order in an ODI Mapping when defining a join? (Choose the best answer.)
A. This option is always available.
B. This option may be available only if the underlying technology supports it.
C. This option is inherited from reverse engineering.
D. You can never make this choice.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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. Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.
B. Create two distinct subscribers for each Mapping.
C. Duplicate the source data store for each Mapping.
D. 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.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two objects can be dragged to a Mapping? (Choose two.)
A. Reusable Mappings
B. Datastores
C. Knowledge Modules
D. Variables
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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. Drag the variable into the load plan and define a case step.
B. Add a case step and drag the variable into the case step.
C. Add a case step in the load plan and select a variable in the wizard.
D. Create a scenario from the variable and add the scenario to the load plan to create a case step.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
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 answer.)
A. extract and load
B. load and transform
C. extract and transform
D. transform only
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You have been tasked with designing a Mapping that must perform an initial load and incremental updates using the same transformation logic. How should you proceed? (Choose the best answer.)
A. Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic.
B. Create a single Mapping with a single Physical Design and modify it appropriately when an initial load is required or when an incremental update is required.
C. Create a single Mapping with two Physical Designs: one for theinitialload and one for the incremental updates.
D. Create a single Mapping and use variables in the Logical Design to do an initial load when required or an incremental update otherwise.
正解：D
解説: (Topexam メンバーにのみ表示されます)