Oracle 1Z0-448 Quiz 1 Topic 4 Questions 1-5

Question: 1

Which statement is true about the need to have a topology with an intermediate server, in order to use ODI correctly in a data warehouse project? (Choose the best answer.)

AData transformation must be distributed across several scalable nodes.

BIt is mandatory to have an intermediate server.

CIt is better to load data directly from sources into a data warehouse server.

DIt is mandatory to collect data directly from sources to a data warehouse server by using real time replication processes.

Show Answer

Question: 2

You need to troubleshoot the execution of a Mapping and visualize the data contained in the ODI Staging tables while the Mapping is being executed. How must you proceed? (Choose the best answer.)

AStart a Mapping in Debug mode and use breakpoints and the Get Data featureto query the data contained in the Staging tables.

BModifya Knowledge Module to dump the Staging tables' data into log files for review.

CUse variables in a Package to query the Staging tablesand evaluate the variable values.

DReverse engineer the Staging tables in a Modeland review the data contained in it.

Show Answer

Question: 3

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

AThey contain data model and security information.

BThey contain security and topology information.

CThey contain project and topology information.

DThey contain project and security information.

Show Answer

Question: 4

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

AVariables

BDatastores

CKnowledge Modules

DReusable Mappings

Show Answer

Question: 5

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? (Choose the best answer.)

AOnly an Integration KnowledgeModule single-technology is required.

BOnly an Integration Knowledge Module multitechnology is required.

CAloading Knowledge Module multitechnology and an IntegrationKnowledgeModule single-technology are required.

DBoth a Loading Knowledge Module multitechnology and an Integration Knowledge Module multitechnology are required.

Show Answer

Oracle 1Z0-448 Quiz:1 Topic:4 Questions:1-5