Avant-garde Oracle 1z0-482 exam question

Q1. In an ODI interface, is it possible to use a specific partition if it is declared for the target table to load data?

A. No, only generic loading can be declared and an IKM can declare partitions using options.

B. No, only ODI variables can be used to filter the target table loading.

C. Yes,an option in the interface can be used to declare partitions but an ODI variable must be used to evaluate the correct partition value.

D. Yes, an option in the interface can be used to declare the partition that has to be used for the loading.

View Answer

Q2. Is it possible to invoke an ODI job as a public web service to execute it?

A. No, it is only possible to run jobs internally or via command line.

B. Yes, both standalone and JEE agent support web services.

C. Yes, but you need to use as mandatory Oracle BPEL in order to process the job invocation.

D. No, there are only internal specific application program interfaces that you can use to run a job.

View Answer

Q3. Select the statement that best describes the difference between Server and Client Data Store access.

A. There is no difference between Server and Client Data Store access, both can be used conveniently.

B. Data is accessed from Server only if it is the data store.

C. Data is accessed from Client only if it is an Excel file.

D. A local file on a laptop can be accessed using Client access, or from Server If a copy of the file is on the EDQ server landing area.

View Answer

Q4. In an ODI interface, is it mandatory to use a join to describe a lookup?

A. Yes,there are not many other graphical Objects to describe a lookup.

B. Yes, it is not possible to set anything other than a join in an ODI Interface.

C. No, there is a graphical object dedicated to set a lookup in the source area of an interface.

D. No, you can use variables in ODI to declare lookups.

View Answer

Q5. One of the parameters retrieve column properties in a knowledge module is odiRef.getcolList.

What is the name of the parameter that retrieves the datatype of a mapped target column?

A. DEST_DT

B. SOURCE_DT

C. COL_DESC

D. COL_FORMAT

View Answer

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

A. Name

B. City

C. Country

D. State or Province

E. Zip or Postal code

View Answer

Q7. You want to add a new CDC subscriber in ODI after you have started the Journal process, what steps do you need to go through in order to use this new subscriber?

A. Drop Journal, remove existing subscribers, add a new subscriber, start Journal, and edit the default Journalizing filter in your Interfaces

B. Drop Journal,add anew subscriber, start Journal, and remove the default Journalizing filter in your Interfaces

C. Drop Journal, add a new subscriber, start Journal, and edit the default Journalizing filter in your Interfaces

D. Add anew subscriber and edit the default Journalizing filter in your Interfaces

View Answer

Q8. You are designing a Load Plan in which you need to run Interfaces A and B one after the other while running Interface C at the same time. Which steps do you need to follow to achieve this?

A. Add a Parallel step, add two Serial steps underneath it, and then add A and B to one serial step and C to the other one

B. Add a Parallel step, drag A and B and C into the Parallel step

C. Add aParallel step, add two Parallel steps underneath it, and then add A and B to one Parallel step and C to the other one

D. Add a Parallel step, add three serial steps underneath it, and then add A to the first Serial step, to the second one, and then C to the last one

View Answer

Q9. Select the three correct options for Token Checking in the EDQ parser.

A. Checking against a list of values.

B. Checking for duplicates.

C. Checking against a list of patterns.

D. Checking for typing errors.

E. Checking against a list of regular expressions.

View Answer

Q10. Identify the right variable step type to use when assigning a value to a variable with a SQL query.

A. Refresh Variable

B. Declare Variable

C. Set Variable

D. Evaluate Variable

View Answer