Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

Oracle 1Z0-482 Exam -

Free 1Z0-482 Sample Questions:

Q: 1
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 ODIto declare lookups.
Answer: C

Q: 2
Select two correct statements about Results Books.
A. A Results Book can contain tabs containing the output from several different EDQ processor steps.
B. Results Books alwayslink to the latestversion of a process.
C. Results Books can be exported to a multlsheet MS Excel Workbook.
D. A Results Book page will always look the same asthe output of the processor it is linked to,
E. Results Books can combine pages from many projects.
Answer: D, E

Q: 3
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
Answer: C

Q: 4
Identify two Change Data Capture implementation strategies provided through the ODI knowledge modules.
A. Triggers
B. Oracle GoldenGate
C. Extract source data to flat files
D. Before and after database image comparison
Answer: B, D

Q: 5
Identify two true statements regarding the ODI SDK.
A. The ODI SDK is used to load data between Teradata and Oracle.
B. The ODI SDK can be used to embed ODIprocesses into another product.
C. The ODI SDK is required to be used by ETL developers in order to develop ODI processes,
D. The ODI SDK allows developers to execute most ODI operations through a Java program.
Answer: A, D

Q: 6
To use ODI efficiently in a Data Warehouse project is it necessary to have a topology with an intermediate transformation server?
A. It is mandatory to have an intermediate server.
B. It is better to load data directly from sources into a data warehouse server.
C. Data transformation should be distributed across several scalable nodes.
D. It is mandatory to collect data directly from sources into a data warehouse server using real time replication processes.
Answer: D

Q: 7
Is it possible to manage five metadata work repositories together with ODI and a single master repository in order to have a software lifecycle generation respecting the best practices that my company uses?
A. No, every repository needs as mandatory a related separated master repository.
B. No, unless I also have live data environments because it is mandatory that the production work repository is installed on the data production server, the test work repository on the test data server and so on.
C. Yes, it is possible to create separate metadata environments with work repositories, that define for instance, a current level of development work repository, next level development, maintenance, production, and so on.
D. Yes, but also install a mandatory agent for every work repository and compile all its Java archives separately.
Answer: C

© 2014, All Rights Reserved