Oracle 1z0-448 Practice Exam Questions

Oracle 1z0-448 Sample Question Answers

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. 

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. 

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.

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  

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  

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

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. 

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.

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.

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 

Show Answer