1z1-482 Exam Training Practice Tests (Oracle Data Integrator 11g Certified Implementation Essentials)]

Question 1

Is it possible to define more than one physical schema associated with the same data server?

A. Yes, but it is mandatory to specify a different user to log in. B. No, ODI Topology does not allow defining more than one physical schema for a data server because the associated logical schema would be ambiguous. C. Yes, but you have to flag which one is the default physical schema. D. It is possible,but it is better to avoid doing so because it is more difficult to define a logical schema this way.

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 2

In an ODI interface, can source tables be declared as not joined?

A. No, by default, every added data store in the source declaration of an interface is joined with an inner join. B. No, in ODI, it is mandatory that all the source data stores are joined directly or indirectly. C. Yes, ODI generates the code calculating a sample of the data, profiling it, and deciding automatically if a join exists. D. Yes, it is possible to create an ODI procedure to declare joins for the source tables.

Correct Answer: B

Question 3

When profiling data with EDQ, how can you ensure that the latest data is being used?

A. By refreshing a snapshot by running it B. By creating a data store C. By creating a snapshot D. New data is automatically loaded by EDQ, no action is required.

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 4

In an ODI interface, if a business rule is declared to calculate a sum aggregation, does a knowledge module need to be customized in order to create the correct code?

A. No, it is not needed but, a variable must be declared in the source mapping in order to generate the correct sum. B. Yes, business rules and the physical implementation are strictly interlayed in ODI. C. Yes, a customization is needed only for aggregation functions. D. No, aggregation code is generated automatically by ODI according to the mapping logic rules.

Correct Answer: D

Question 5

Identify two operations that can be achieved using the ODI SDK.

A. Create interfaces B. Create Master and Work repositories C. Create security profiles D. Create users

Correct Answer: A,B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 6

Which one of the following attributes should always be provided to EDQ AV as a separate attribute if available?

A. Country B. City C. Name D. Zip or Postal code E. State or Province

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 7

Which property file parameter stores the location of the OBBIE web catalog folder?

A. OBXEE WEBCAT B. OBIEE_WEBCAT__FILE C. OBIEE_WEBCAT_EXPORT_FILE D. OBIEE_WEBCAT_FOLDER_TO_EXPORT

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 8

In ODI Operator, is it possible to view code in the second level (the step) represented?

A. Yes, depending on the auditlevel declared when running the execution, some of the generated code at the step-level can be viewed. B. Yes, all generated code can be viewed together in the step-level, with a complete list of executed code. C. No, it is only possible to see code in the first higher level (the session) represented. D. No, it is possible to view code in the thud level(the tasklevel)represented.

Correct Answer: D

Oracle Data Integrator 11g Certified Implementation Essentials - 1z1-482 Exam Practice Test