NiC IT Academy

INFORMATICA QUIZ – 8

By Mr.Chandra

Loading

1) What does data integration refer to?

2) Which of the following is a common data source for ETL?

3) What is a source system in the context of ETL?

4) Which of the following best describes ETL mapping?

5) What is a data lake?

6) Which of the following is an ETL tool?

7) What is the primary function of an ETL tool?

8) Which of the following is a feature of modern ETL tools?

9) What is an example of an open-source ETL tool?

10) Which of the following is NOT a function of an ETL tool?

11) What is data warehousing as a service (DWaaS)?

12) Which of the following concepts refers to storing data in a columnar format?

13) What is the main benefit of using a dimensional model in data warehousing?

14) What does the term "star schema" refer to?

15) What is the role of metadata in a data warehouse?

16) Which of the following techniques is used for performance tuning in data warehouses?

17) What is the purpose of data partitioning?

18) Which of the following is a benefit of using materialized views?

19) What is the main advantage of using an indexing strategy in a data warehouse?

20) What is the purpose of query optimization?

Login with your email & password

Sign up with your email & password

Signup/Registration Form