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.
- 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
Back to top