Intelligent Informatica Assessment Test

10 Questions

Settings
Please wait...
Intelligent Informatica Assessment Test

Founded in 1993, Informatica is a software company that deals with enterprise cloud data integration and management. Take this quiz to find out more.


Questions and Answers
  • 1. 
    MDM includes the _______ that reliably characterize and deal with the critical data of an organization to provide a single point of reference. Which one of the following is odd?
    • A. 

      Processes

    • B. 

      Policies

    • C. 

      Formatting

    • D. 

      Tools

    • E. 

      Standards

  • 2. 
    What happens to duplicated records in Informatica Project Plan?
    • A. 

      It'll be deleted

    • B. 

      It'll be merged with original

    • C. 

      It'll be cleaned

    • D. 

      It'll be changed

  • 3. 
    In how many ways can you access the Informatica Console?
    • A. 

      7

    • B. 

      3

    • C. 

      1

    • D. 

      2

  • 4. 
    At what stage is a data warehouse updated?
    • A. 

      Offline operational

    • B. 

      Real time

    • C. 

      Integrated

    • D. 

      Offline

  • 5. 
    Which of these represents the flow of data between targets and sources?
    • A. 

      Map

    • B. 

      Transformation

    • C. 

      Transaction

    • D. 

      Mining

  • 6. 
    What is the foreign key column in a dimension table?
    • A. 

      Primary keys of entity tables

    • B. 

      Surrogate keys

    • C. 

      Primary keys of dimension tables

    • D. 

      Mixed keys

  • 7. 
    In how many ways can you load a dimension table?
    • A. 

      4

    • B. 

      8

    • C. 

      1

    • D. 

      2

  • 8. 
    In direct dimension table, loading all the keys and constrains are _____ prior to loading the data.
    • A. 

      Enabled

    • B. 

      Cleaned

    • C. 

      Disabled

    • D. 

      Translated

  • 9. 
    A mapping variable is...
    • A. 

      Static

    • B. 

      Dynamic

    • C. 

      Open

    • D. 

      Close

  • 10. 
    What are the two types of data movement in Informatica? 
    • A. 

      Unicode Mode and ASCII Mode

    • B. 

      OLAP and ASCII Mode

    • C. 

      Unicode Mode and OLAP Mode

    • D. 

      OLAP and Port