1Z0-482 - DBExam

1Z0-482Oracle Data Integrator 11g Certified ImplementationEssentialsExam Summary – Syllabus – Questions

1Z0-482 Sample Questions and Exam SummaryTable of ContentsIntroduction to 1Z0-482 Exam on Oracle Data Integrator 11g CertifiedImplementation Essentials. 2Oracle 1Z0-482 Certification Details: . 2Oracle 1Z0-482 Exam Syllabus: . 31Z0-482 Sample Questions: . 4Answers to 1Z0-482 Exam Questions: . 61Z0-482- Oracle Data Integrator 11g Certified Implementation Essentialspg. 1

1Z0-482 Sample Questions and Exam SummaryIntroduction to 1Z0-482 Exam on Oracle DataIntegrator 11g Certified ImplementationEssentialsYou can use this exam guide to collect all the information about Oracle Data Integrator11g Certified Implementation Essentials (1Z0-482) certification. The Oracle 1Z0-482certification is mainly targeted to those candidates who has some experience or exposureof Data Integration and want to flourish their career with Oracle Data Integrator 11gCertified Implementation Specialist (OCS) credential. The Oracle Data Integrator 11gCertified Implementation Essentials certification exam validates your understanding ofthe Data Integration technology and sets the stage for your future progression. Yourpreparation plan for Oracle 1Z0-482 Certification exam should include hands-on practiceor on-the-job experience performing the tasks described in following Certification ExamTopics table.Oracle 1Z0-482 Certification Details:Exam NameOracle Data Integrator 11g Certified ImplementationEssentialsExam Code1Z0-482Exam Product VersionData Integrator (ODI)Exam PriceUSD 245 (Pricing may vary by country or by localizedcurrency)Duration120 minutesNumber of Questions71Passing Score70%Validated AgainstThis exam is validated against 11g.FormatMultiple ChoiceOracle Data Integrator 11g: Integration andAdministrationRecommended TrainingOracle Data Integrator 11g: Advanced Integration andDevelopmentOracle Enterprise Data Quality: Match and ParseOracle Enterprise Data Quality: Profile, Audit andOperate1Z0-482- Oracle Data Integrator 11g Certified Implementation Essentialspg. 2

1Z0-482 Sample Questions and Exam SummarySchedule ExamPearson VUE - OracleRecommended Practice1Z0-482 Online Practice ExamOracle 1Z0-482 Exam Syllabus:Introduction to Oracle DataIntegrator (ODI)Architecture OverviewODI Models and DatastoresProject Development- Describe the benefits of ODI (including ODIarchitecture - Extract Load Transform) and it's typicaluse cases- Describe the ODI components and their uses- Describe ODI Architecture- Install and Configure the physical and logicalarchitecture- Explain the Fusion Middleware Components - UpgradeAssistant, Repository Creation Utility and Java EnterpriseEdition (JEE) Components and High Availability- Create ODI datastores- Create and organize ODI Models- Reverse engineer the metadata- Explain ODI constraints- Configure auditing- Install and configure Data validation- Create a project within ODI- Explain ODI interface- Describe the concepts of mapping, join, and filter andthe process of implementing business rules as well asthe concepts of staging area and execution location- Create and execute a basic ODI Interface- Create lookups- Design ODI interfaces with multiple-source datastores- Create joins and lookups, and filter data- Configure the flow in the ODI Interface, specify the ODIInterface, staging area and execution location- Modify and develop knowledge modules- Describe what happens at run time- Monitor the execution of interfaces- Troubleshoot run-time errors in interfaces, preventerrors by following the best practices when designinginterfaces- Configure the use of business rules, variables and setbased operators and use data sets and sequences- Use partitioning, temporary indexes, and temporaryinterfaces- Use user functions and substitution methods1Z0-482- Oracle Data Integrator 11g Certified Implementation Essentialspg. 3

1Z0-482 Sample Questions and Exam Summary- Use ODI packages to create a complete workflow- Use variables in packages (refresh, startupparameters).- Create package steps of different types- Execute and monitor a package- Define complex workflows in ODI packages involvingbranches and loopsManaging Execution- Generate and regenerate an ODI scenario- Use the load plan editor to define a load plan- Design a sequence of hierarchical steps for the loadplan- Create Packages and Load Plans- Manage exceptions with Load Plans- Configure Load Plans to restart child sessions- Describe the purpose of Changed Data Capture (CDC)with ODI and the types of CDC implementations possiblewith ODIIntegrating OGG with ODI- Deploy Goldengate CDC with ODI- Perform journalizing- Interpret and troubleshoot the results of CDC- Describe the ODI Software Development Kit (SDK)- Describe ODI Web-Based ComponentsDoing more with ODI- Explain the role of ODI in Big Data- Describe the role of ODI in BI integration- Describe the ways where ODI and EDQ can sharearchitecture components (infrastructure, sources andtargets, etc)- Configure EDQ to work with Data Stores, Snapshots,Enterprise Data QualityStaged Data, Exports(EDQ) Profiling- Explain basic statistics from data- Describe the tracking of changing data from same datastores (trends)- Describe profiling results and the use of Resultbooksand Publish features- Explain the parsing process and referencing reviewresults- Perform a matching process, identify duplicatedrecords, balance performance and duplicate detectionEDQ Batch Processingaccuracy- Explain address verification and Address Verificationstatistics- Create the main job that includes all processes thatwere created and invoke it from ODI1Z0-482 Sample Questions:01. Can a check constraint can be added to metadata in ODI?a) Nob) Yesc) Yes, but only after first executing additional scripts on the database1Z0-482- Oracle Data Integrator 11g Certified Implementation Essentialspg. 4

1Z0-482 Sample Questions and Exam Summaryd) No, they must be declared when customizing knowledge modules02. Which capabilities support data quality management.a) Data synchronizationb) Data profilingc) Data cleansingd) Data match and data merge03. Is Oracle Web Logic Server required for an ODI agent to execute jobs?a) Yes, the ODI agent requires Oracle Web Logic Serverb) No, the ODI agent does not require Oracle Web Logic Serverc) Yes, if not the ODI agent is not able to connect to source and target systemsd) Yes, if not the ODI Agent is not able to start it’s own proprietary engine04.What is a Package in ODI?a) A workflowb) A dataflowc) A compiled version of an Interfaced) A PL/SQL package05. When profiling data with EDQ, how can you ensure that the latest data isbeing used?a) By creating a snapshotb) By refreshing a snapshot by running itc) New data is automatically loaded by EDQ, no action is required.d) By creating a data store06. Which operation that can be achieved using the ODI SDK?a) Create usersb) Create a processc) Create an interface07. Select three key concepts that Oracle Data Integrator supports.a) High Performance E-LTb) Bulk Data Processingc) Data Transformationd) Bidirectional Replication08. 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 ODIprocesses.d) The ODI SDK allows developers to execute most ODI operations through a Javaprogram.09. What ODI Staging tables are populated by the Oracle GoldenGate (OGG)Journalization Knowledge Modules?a) JKM tablesb) KM tablesc) J tables1Z0-482- Oracle Data Integrator 11g Certified Implementation Essentialspg. 5

1Z0-482 Sample Questions and Exam Summaryd) OGGJKM tables10. Can an ODI interface implement filters and all relational business logic toload a target table?a) No, an ODI procedure must be added to set filters needed for loadingb) No, parameters are needed for loading a configuration filec) YesAnswers to 1Z0-482 Exam Questions:QUESTION: 01 QUESTION: 02Answer: bAnswer: b, c, dQUESTION: 03Answer: bQUESTION: 04Answer: aQUESTION: 05Answer: bQUESTION: 06 QUESTION: 07Answer: cAnswer: a, b, cQUESTION: 08Answer: b, dQUESTION: 09Answer: cQUESTION: 10Answer: cNote: If you find any typo or data entry error in these sample questions, we requestyou to update us by commenting on this page or write an email onfeedback@oraclestudy.com1Z0-482- Oracle Data Integrator 11g Certified Implementation Essentialspg. 6

1Z0-482- Oracle Data Integrator 11g Certified Implementation Essentials pg. 3 Schedule Exam Pearson VUE - Oracle Recommended Practice 1Z0-482 Online Practice Exam Oracle 1Z0-482 Exam Syllabus: Introduction to Oracle Data Integrator (ODI) - Describe the benefits of ODI (including ODI architec