Informatica Certification Exams General Practice Test

120 Questions | Total Attempts: 7322

SettingsSettingsSettings
Please wait...
Organization Quizzes & Trivia

.


Questions and Answers
  • 1. 
    In a short description, the data warehouse is a collection of data that is primarily used for
    • A. 

      Organizational Decision Making

    • B. 

      Transaction Processing

    • C. 

      Temporary Data Storage

    • D. 

      Query Optimization

    • E. 

      Application Testing

  • 2. 
    Data Marts have specific business related purposes.
    • A. 

      True

    • B. 

      False

  • 3. 
    The database designed for queries on transactional data is known as 
    • A. 

      ODS

    • B. 

      OLTP

    • C. 

      OLAP

    • D. 

      OLCP

    • E. 

      DSS

  • 4. 
    This is a quantifiable value such amount of sales, budget or revenue.
    • A. 

      Dimension

    • B. 

      Database

    • C. 

      Datamart

    • D. 

      Fact

    • E. 

      Datawarehouse

  • 5. 
    The center of Star schema consists of one or more 
    • A. 

      Fact tables

    • B. 

      Dimension tables

    • C. 

      Indexes

    • D. 

      Views

    • E. 

      Synonyms

  • 6. 
    The process of pulling data from various hetrogeneous source systems is known as
    • A. 

      Loading

    • B. 

      Transforming

    • C. 

      Cleansing

    • D. 

      Refreshing

    • E. 

      Extraction

  • 7. 
    Change data capture is a part of 
    • A. 

      Incremental Extraction

    • B. 

      Full Extraction

    • C. 

      Online Extraction

    • D. 

      Offline Extraction

    • E. 

      None

  • 8. 
    Which is used to store data and perform data cleansing, merging before loading into Data warehousing?
    • A. 

      ODS

    • B. 

      OLTP

    • C. 

      Staging

    • D. 

      ODS&OLTP

    • E. 

      None

  • 9. 
    The two types of loading available in DWH are 
    • A. 

      Full Load

    • B. 

      Direct Load

    • C. 

      Incremental Load

    • D. 

      Option 1 & Option 3

    • E. 

      All of the above

  • 10. 
    The process of converting and summarizing operational data into a consistent, business-oriented format:
    • A. 

      Transformation

    • B. 

      Extraction

    • C. 

      Loading

    • D. 

      All of the above

    • E. 

      None

  • 11. 
    The latest informatica suite is compatible of
    • A. 

      8 Bit

    • B. 

      16 Bit

    • C. 

      32 Bit

    • D. 

      64 Bit

    • E. 

      128 Bit

  • 12. 
    Is both Informatica PowerCenter and PowerMart are same
    • A. 

      Depends upon the User

    • B. 

      NO

    • C. 

      YES

    • D. 

      Only at some times

    • E. 

      I don't know

  • 13. 
    Flat file lookup is one newly added feature in Informatica PowerCenter 7.1version
    • A. 

      Depends upon the User

    • B. 

      NO

    • C. 

      I don't know

    • D. 

      Only at some times

    • E. 

      YES

  • 14. 
    How many important client components available in Informatica
    • A. 

      5

    • B. 

      3

    • C. 

      0

    • D. 

      No client tools

    • E. 

      I don't know

  • 15. 
    Which component is used for New server registration in informatica
    • A. 

      Designer

    • B. 

      Workflow Manager

    • C. 

      2&3

    • D. 

      Repository Manager

    • E. 

      Repository administration console

  • 16. 
    Which Component of informatica is used to configure connection details
    • A. 

      Workflow Monitor

    • B. 

      Mapping Designer

    • C. 

      Workflow Manager

    • D. 

      Repository Manager

    • E. 

      Worklet Designer

  • 17. 
    Which  tool is used for users,user groups and priviledges
    • A. 

      Designer

    • B. 

      Workflow Manager

    • C. 

      Repository Manager

    • D. 

      2&3

    • E. 

      None

  • 18. 
    Where is the actual business rules will be implemented
    • A. 

      Source qualifier

    • B. 

      Transformation Developer

    • C. 

      Workflow Designer

    • D. 

      Mapping Designer

    • E. 

      Warehouse Designer

  • 19. 
    Is it possible to generate a table in relational database using informatica
    • A. 

      Yes

    • B. 

      No

    • C. 

      Sometimes

    • D. 

      May be possible

    • E. 

      None

  • 20. 
    Which Component of informatica is used to see the performance of the workflow while running
    • A. 

      Workflow Monitor

    • B. 

      Mapping Designer

    • C. 

      Workflow Manager

    • D. 

      Repository Manager

    • E. 

      Worklet Designer

  • 21. 
    The Repository Manager connects to the repository database through the Repository Server.
    • A. 

      Depends upon the User

    • B. 

      FALSE

    • C. 

      TRUE

    • D. 

      Only at some times

    • E. 

      I don't know

  • 22. 
    In the Informatica Repository, where is the meta data getting stored?
    • A. 

      Synonyms

    • B. 

      Dimension tables

    • C. 

      Indexes

    • D. 

      Database tables

    • E. 

      I don't know

  • 23. 
    How the repository server communicates with the repository database
    • A. 

      Through native drivers

    • B. 

      Third party softwares

    • C. 

      LAN Drivers

    • D. 

      Logical Paths

    • E. 

      I don't know

  • 24. 
    The Repository Server can manage a repository residing on a database on a different machine on the network
    • A. 

      Depends upon the User

    • B. 

      FALSE

    • C. 

      TRUE

    • D. 

      Only at some times

    • E. 

      I don't know

  • 25. 
    Using the repository manager, the entire repository can be backed up in the format of 
    • A. 

      Text file

    • B. 

      Zip File

    • C. 

      XML File

    • D. 

      Binary File

    • E. 

      I don't know