Vendor
: Oracle
Exam Code : 1Z0-482
Version: Demo
Cheat-Test, help you pass any IT exam!
Cheat-Test.com - The Worldwide Renowned IT Certification Material Provider! The safer, easier way to help you pass any IT Certification exams.
We provide high quality IT Certification exams practice questions and answers (Q&A). Especially Cisco, Microsoft, HP, IBM, Oracle, CompTIA, Adobe, Apple, Citrix, EMC, Isaca, Avaya, SAP and so on. And help you pass an IT Certification exams at the first try.
Cheat-Test product Features: •
Verified Answers Researched by Industry Experts
•
Questions updated on regular basis
•
Like actual certification exams our product is in multiple-choice questions (MCQs).
•
Our questions and answers are backed by our GUARANTEE.
7x24 online customer service: contact@cheat-test.com
Click Here to get more Free Cheat-Test Certification exams!
http://www.Cheat-Test.com
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