NiC IT Academy

ETL Testing Quiz – 01

By Mr.Chandra

Loading

1) What is the full form of ETL?

2) Getting information from a database is called ____ (reading).

3) To fetch data from one database and place it in another, ETL combines all ____ database functions into one tool.

4) The process of ____ data involves converting it from one form to another.

5) In addition to using ____, the data can be combined with other data to undergo transformation.

6) Using an ____ tool, data is extracted from multiple data sources, transformed, and loaded into a data warehouse after joining fields, calculating, and removing incorrect data fields.

7) After business ____, ETL testing ensures that the data has been loaded accurately from a source to a destination.

8) During ETL, various stages of data are verified and used at ____.

9) Writing data into a database is called ____.

10) Using ETL, you can ____ the data from multiple sources and blend them together according to your needs.

11) ETL is often used to build a –

12) As part of the ETL process, data from a source system is ____ into a format suitable for storing in a data warehouse or another system.

13) A ____ is loaded with data through the ETL process.

14) To facilitate business analysis, our data warehouse needs to be ____ regularly

15) To avoid affecting the source system’s performance, the ____ occurs on the ETL server or staging area.

16) Before data is moved to the warehouse, the extracted data can be validated in the ____ area.

17) How many methods are there to extract the data?

18) Which of the following is/are the method(s) to extract the data?

19) Whatever extraction method we use, the source system should not be affected in terms of ____ time.

20) It is not possible to use the extracted data as originally formatted from the ____ server.

Login with your email & password

Sign up with your email & password

Signup/Registration Form