Oracle 1z0-448 Exam Dumps

Oracle 1z0-448 Sample Question Answers

Oracle 1z0-448 Sample Questions

Question # 1

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

A. Consistent set journalizing runs faster than simple journalizing.  
B. Consistent set journalizing always uses Oracle GoldenGate.  
C. Consistent set journalizing treats each data store individually.  
D. Consistent set journalizing provides a guarantee of consistency of the captured changes. 

Answer: D

Show Answer

Question # 2

You are a project developer using ODI and want to consolidate your own local metadata repositories. Identify the true statement.(Choose the best answer.)

A. You must consolidate your own local metadata repositories. The local metadata must betransmitted via ftp and synchronized with a dedicated proprietary engine, creating acommon metadata model for all the developers. 
B. You must consolidate your own local metadata repositories. You have to invoke adedicated web service to synchronize the metadata by using Oracle Service Bus. 
C. You need not consolidate your own local metadata repositories, because the ODIproprietary metadata server allows all developers to share the common metadata of aspecific project.
D. You need not consolidate yourown local metadata repositories, because ODI uses acentralized relational metadata repository that all the developers share. 

Answer: D

Show Answer

Question # 3

You are defining a data store in ODI metadata and want toadd a primary key even if it doesnot 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 databasecatalog, by adding constraintson the data store.
B. You can add a primary key even if it does not physically exist on the related databasecatalog, by adding constraints to the data store diagram. 
C. You cannot add a primary key if it does not physically exist on the related databasecatalog. You can flag only non-null conditions to be checked.
D. You cannot add a primary key if it does not physically exist on therelated databasecatalog. You can reverse engineer only the existing constraints.

Answer: D

Show Answer

Question # 4

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

A. Run Exception and Restart  
B. Run Exception and Continue  
C. Run Exception and Ignore  
D. Run Exception and Fail  
E. Run Exception and Raise  

Answer: C,E

Show Answer

Question # 5

You must monitor and managea co-located stand-alone agent,OracleDIAgent1, by usingthe ODI plug-in for Enterprise Manager CloudControl. Which is the correct command tostart this agent on Linux?(Choose the best answer.)

A. ./agent.sh –NAME=OracleDIAgent1 –PORT=20910  
B. ./agent.sh –NAME=OracleDIAgent1  
C. ./startComponent.sh OracleDIAgent1  
D. ./startComponent.sh OracleDIAgent1 –PORT=20910  

Answer: A

Show Answer

Question # 6

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. It is only possible to view code at the Task level.
C. Depending on the audit level declared when running the execution, some of the generated code at the step level can be viewed.
D. All generated code can be viewed together at the step level, with a complete list of executed code

Answer: A

Show Answer

Question # 7

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

A. Create a Data Server by using the File technology and specify the various recordformats while reverse engineering the file. 
B. Create a Data Server by using the XML technology, create annXSDfile by using theNative Format Builder, and then reverse engineer it in a Model. 
C. Create a Data Server by using theFile technology, create annXSDfile by using theNative Format Builder, and then reverse engineer it in a Model.
D. Create a Data Server by using the Complex File technology, create annXSDfile by usingthe NativeFormat Builder, and then reverse engineer it in aModel. 

Answer: D

Show Answer

Question # 8

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

A. Start a Mapping in Debug mode and use breakpoints and the Get Data featureto query the data contained in the Staging tables.
B. Modifya Knowledge Module to dump the Staging tables’ data into log files for review.
C. Use variables in a Package to query the Staging tablesand evaluate the variable values.
D. Reverse engineer the Staging tables in a Modeland review the data contained in it.

Answer: D

Show Answer

Question # 9

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

A. Data transformation must be distributed across several scalable nodes.  
B. It is mandatory to have an intermediate server.  
C. It is better to load data directly from sources into a data warehouse server.  
D. It is mandatory to collect data directly from sources to a data warehouse server by usingreal time replication processes.

Answer: C

Show Answer

Question # 10

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

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

Answer: A

Show Answer

Question # 11

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 happens at run time when a Mapping gets executed?(Choose the best answer.)

A. All distinct entries are processed.  
B. Only the latest entry is processed based on theJRN_DATEfield.  
C. Only the first entry is processed based on theJRN_DATEfield.  
D. A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table.

Answer: B

Show Answer

Question # 12

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

A. Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a green OK arrow.
B. Add anOdiSendMailstep to My Package and link the My Last Package step to it by using a red KO arrow.
C. Add anOdiReadMailstep to My Package and link the My Third Package step to it by using a red KO arrow.
D. Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a red KO arrow. 

Answer: B

Show Answer

Question # 13

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. Add a case step and drag the variable into the case step.
B. Create a scenario from the variable and add the scenario to the load plan to create a case step.
C. Add a case step in the load plan and select a variable in the wizard.
D. Drag the variable into the load plan and define a case step. 

Answer: A

Show Answer

Question # 14

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

A. conditions  
B. foreign keys  
C. primary keys  
D. alternate keys  
E. not null  

Answer: B,E

Show Answer

Question # 15

Your customer wants a project in ODI, which contains a user function, to translate commands with different syntax for different technologies but with the same functionality.How can you achieve this?(Choose the best answer.)  

A. The project must be explicitly mapped within an ODI mapping.
B. A customize knowledge module is needed.
C. An ODI procedure must be associated with it.
D. It can be defined for every technology listed in the topology. 

Answer: D

Show Answer