All About Download 1Z0-448 Preparation

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

• A. by using Upgrade Assistant
• B. by using ODI Studio
• C. by using Domain Creation Assistant
• D. by using Configuration Wizard

Answer: D

Explanation:

(https://docs.oracle.com/middleware/1213/core/ODING/configure_jee.htm#ODING291)

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

• A. Restart from new sessio
• B. Restart from failur
• C. Restart from failed childre
• D. Restart all childre

Answer: CD

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1409)

NEW QUESTION 3
You want to draw directly in the data flow all the details about how the different servers involved are connected, in order to load a specific table by using ODI.
What must you do to accomplish this?(Choose the best answer.)

• A. In the ODI Interface palette, choose the more convenient graphic objects to link the involved server
• B. You need not draw directly in the data flow all the details about how the different servers involved are connecte
• C. ODI automatically designs the flow and how servers are connecte
• D. You need not draw directly in the data flow all the details about how the different servers involved are connecte
• E. The code will be the black box generated directly by OD
• F. You must draw directly in the data flow all the details about how the different servers involved are connected, and also specify with variables the passwords for connecting to the data contained in the server

Answer: B

NEW QUESTION 4
In a Mapping, you want to load the data by using a specific partition that is declared for a target table. Which statement is correct in this situation?(Choose the best answer)

• A. It is not possible to use a specific partitio
• B. Only ODI variables can be used to filter the target table loadin
• C. An option in the Mapping can be used to declare partitions but an ODI variable must be used to evaluate the correct partition valu
• D. An option in the Mapping can be used to declare the partition that has to be used for the loadin

Answer: D

Explanation:

(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/interfaces.htm#ODIDG1044)

NEW QUESTION 5
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 answer.)

• A. The execution should be done only on the development data environment, as long as the other environment is a mirrored cop
• B. Only the production environment can be use
• C. All environments linked to a logical schema can be used to reverse-engineer table structure
• D. Only a Java engine intermediate environment can be processe

Answer: C

Explanation:

(http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/create_rev_model.htm#ODID G227)

NEW QUESTION 6
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

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/app_tools.htm#ODIDG875)

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

• A. ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguou
• B. It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log i
• C. It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schem
• D. It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this wa

Answer: C

Explanation:
(http://odiexperts.com/context-logical-and-physical-schema-how-does-it-work/)

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

• A. Oracle BPEL Process Manager
• B. Oracle GoldenGate
• C. ODI Console
• D. Oracle WebLogic Server

Answer: C

Explanation:
(http://www.oracle.com/technetwork/middleware/data-integrator/overview/oracledi-architecture-1-129425.pdf)

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

• A. Create a procedure and add two task
• B. The first one must have a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and the second must have a Command on Target that usesOdiSendMailto send the email by using the bind variable defined in the first tas
• C. Createa Knowledge Modul
• D. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Command on Target that usesOdiSendMailto send the email using the bind variable defined in the Command on Sourc
• E. Create a counter variable that gets the total number of email addresses stored in the database tabl
• F. Next, create another variable that selects the email addresses from the database tabl
• G. Then, create a loop in the packages by using the variables and anOdiSendMailste
• H. Create a procedur
• I. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Commandon Targetthat usesOdiSendMailto send the email using the bind variable defined in the Command on Sourc

Answer: B

Explanation:

(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/procedures.htm#ODIDG408)

NEW QUESTION 10
You must run the samemappingconcurrently while avoiding clashes of ODI temporaryobjects. How must you implement this?(Choose the best answer.)

• A. Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object name
• B. Use variables in the Logical Design of the Mapping to create unique temporary object name
• C. Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object name
• D. Select the Use Unique Temporary Object Names check box at the Physical Design leve

Answer: D

Explanation:
(https://blogs.oracle.com/dataintegration/entry/odi_12c_parallel_target_table)

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

• A. It is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) querie
• B. It is not possible to enforce constraints on any technolog
• C. It is only possible to forward-engineer it to the flat file definitio
• D. It is possible to enforce a primary key on a flat file by using a CKM; however, you have to save it as a fixed fil

Answer: D

Explanation:
(http://www.oracle.com/technetwork/middleware/data-integrator/learnmore/odi-best-practice-data-warehouse-168255.pdf)

NEW QUESTION 12
How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code? (Choose the best answer.)

• A. The Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in OD
• B. The Knowledge Module must be customized only for aggregation function
• C. The Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logi
• D. The Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct su

Answer: D

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1625)

NEW QUESTION 13
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 repositorie
• B. The local metadata must be transmitted via ftp and synchronized with a dedicated proprietary engine, creating a common metadata model for all the developer
• C. You must consolidate your own local metadata repositorie
• D. You have to invoke a dedicated web service to synchronize the metadata by using Oracle Service Bu
• E. You need not consolidate your own local metadata repositories, because the ODI proprietary metadata server allows all developers to share the common metadata of a specific projec
• F. You need not consolidate yourown local metadata repositories, because ODI uses a centralized relational metadata repository that all the developers shar

Answer: D

NEW QUESTION 14
You want to ensure that thePhysical Mapping Design cannot be modifiedeven if the Logical Design of the Mapping is changed. What sequence of steps must you follow to achieve this?(Choosethe best answer)

• A. Go to the Physical tab, select theFixedDesign check boxof the Physical Mapping Desig
• B. Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Desig
• C. Go to the Physical tab, select the Read-only check box of the Physical Mapping Desig
• D. Go to the Physical tab, deselect theModify check boxof the Physical Mapping Desig

Answer: C

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1560)

NEW QUESTION 15
You need toimplement security mechanismsthat allow only user “A” to view all the Mappings contained in a specific projectnamed “P1.” How must you proceed?(Choose the best answer.)

• A. Go to Security, assign the NG DESIGNER profile to user “A.” Next, drag project “P1” to user “A” and finally setView privilegesto Active for the Mapping object
• B. Go to Security, assign the DESIGNER profile to user “A.” Next, drag project “P1” to user “A” and finally set View privileges to Active for the Mapping object
• C. Go to Security, assign the NG DESIGNER profile to user “A.” Next, drag project “P1” to user “A” and finally set View privileges to Active for the Project, Folder, and Mapping object
• D. Go to Security, assign the DESIGNER profile to user “A.” Next, drag project “P1” to user “A” and finally set View privileges to Active for the Project, Folder, and Mapping object

Answer: D

Explanation:

(https://docs.oracle.com/cd/B12037_01/network.101/b10777/protdata.htm#1006312)

NEW QUESTION 16
......