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? - ProProfs]( "Why do data managers make use of a data warehouse?")
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? - ProProfs]( "What are the two types of dimensional tables?")
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? - ProProfs]( "Data warehousing comprises ______ fundamental stages?")
Data warehousing comprises ______ fundamental stages?- A.
5
- B.
7
- C.
4
- D.
2
- 4.
![Which of these is true of a mapplet? - ProProfs]( "Which of these is true of a mapplet?")
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... - ProProfs]( "All of these methods can be used to migrate from one Informatica environment to another except...")
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? - ProProfs]( "What are the two core concepts of Hadoop?")
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? - ProProfs]( "Which of these file formats is best suited for long term storage schema with Hadoop?")
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? - ProProfs]( "Which of these allows systems admin to monitor events in SQL server?")
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... - ProProfs]( "All of these are different types of orders in collation except...")
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... - ProProfs]( "By default, NOCOUNT is set to...")
By default, NOCOUNT is set to...- A.
On
- B.
Off
- C.
True
- D.
False
Questions: 10 | Attempts: 14763 | Last updated: Oct 21, 2019
-
Sample QuestionMicrobial fuel cells are considered a source of sustainable energy. Why? 1. They use living organisms as catalysts to generate electricity from certain substrates. 2. They use a variety of inorganic materials as substrates. 3. They can be installed in wastewater treatment plants to cleanse water and produce electricity. Which of the statements given above is/are correct?
Questions: 31 | Attempts: 8284 | Last updated: Oct 14, 2020
-
Sample QuestionWhat are the multiple levels or layers to analyzing a message?
Questions: 8 | Attempts: 6592 | Last updated: Dec 14, 2012
-
Sample QuestionWhich of the following would you NOT inspect while observing gait?
Back to top