NiC IT Academy

ETL Testing Quiz – 02

By Mr.Chandra

Loading

1) ____ refers to data that does not need to be transformed.

2) Which of the following is the last step of the ETL process?

3) Loads need to be __ according to server performance by the admin of the data warehouse.

4) With a ____, all tables are erased and reloaded with new information.

5) During ____, the main goal is to capture data as quickly as possible from a system while minimizing the inconvenience to the system.

6) Compared to traditional ETL, ETL ____ the time it takes for sources and targets to develop.

7) ____ consists of a process between stages that is defined according to the needs, and it can verify the quality of the product

8) In ____, analysis and validation of the data pattern and formats will be performed, as well as identification and validation of redundant data across data sources to determine the actual content, structure, and quality of the data.

9) It is important to focus on the surroundings of the sources in ____ analysis, so that the documentation of the sources can be obtained.

10) Based on the Metadata of a set of predefined rules, errors found can be fixed in ____.

11) ETL testing is also known as –

12) An ETL test ensures the data loaded after transformation is accurate after it has been ____ from a source to a destination.

13) ETL testing is performed in ____ stages.

14) Which of the following is/are the stage(s) the ETL testing?

15) Which of the following is/are the type(s) of ETL testing?

16) Customer requirements and different sources of data are taken into account in ____.

17) Which of the following is/are the group that plays the responsibility in testing New Data Warehouses –

18) The ____ develops test plans and scripts and executes these plans and scripts.

19) Performance and stress tests are conducted by ____.

20) What is the full form of UAT?

Login with your email & password

Sign up with your email & password

Signup/Registration Form