Intelligent Informatica Data Manager Assessment Test

10 Questions

Settings
Please wait...
Intelligent Informatica Data Manager Assessment Test

Informatica is a company founded in 1993, which produces software and cloud applications for enterprise cloud data management. Before being an Informatica data manager, take this quiz to know your responsibilities.


Questions and Answers
  • 1. 
    Why do data managers make use of a data warehouse?
    • A. 

      It does not slow down operations

    • B. 

      It is capable of given answers

    • C. 

      It is more affordable

    • D. 

      It is more accurate

  • 2. 
    What are the two types of dimensional tables?
    • A. 

      Coherent and incoherent table

    • B. 

      True and false table

    • C. 

      Convention and fact table

    • D. 

      Dimension and fact table

  • 3. 
    Data warehousing comprises ______ fundamental stages?
    • A. 

      5

    • B. 

      7

    • C. 

      4

    • D. 

      2

  • 4. 
    Which of these is true of a mapplet?
    • A. 

      It is reusable

    • B. 

      It is not reusable

    • C. 

      It consists of join transformation

    • D. 

      It has procedures

  • 5. 
    All of these methods can be used to migrate from one Informatica environment to another except...
    • A. 

      Copying files or folders

    • B. 

      Exporting or importing repository

    • C. 

      Cutting and pasting files or folders

    • D. 

      Using Informatica deployment

  • 6. 
    What are the two core concepts of Hadoop?
    • A. 

      RDBMS and HDFS

    • B. 

      HDFS and MapReduce

    • C. 

      HDFS and Mapplet

    • D. 

      MapReduce and Mapplet

  • 7. 
    Which of these file formats is best suited for long term storage schema with Hadoop?
    • A. 

      CSV

    • B. 

      JSON

    • C. 

      Avro

    • D. 

      Parquet

  • 8. 
    Which of these allows systems admin to monitor events in SQL server?
    • A. 

      SQL agent

    • B. 

      Sqoop

    • C. 

      Hive

    • D. 

      SQL profiler

  • 9. 
    All of these are different types of orders in collation except...
    • A. 

      Case sensitive

    • B. 

      Case insensitive

    • C. 

      Numerical

    • D. 

      Binary

  • 10. 
    By default, NOCOUNT is set to...
    • A. 

      On

    • B. 

      Off

    • C. 

      True

    • D. 

      False