ETL MCQ Questions And Answers - Software Quality

ETL MCQs : This section focuses on "basics" of ETL. These Multiple Choice Questions (MCQ) should be practiced to improve the ETL skills required for various interviews (campus interviews, walk-in interviews, company interviews), placements, entrance exams and other competitive examinations.

1. ETL stands for?

A. Extract, Transfer and Load
B. Extract, Transform and Load
C. Extract, Time and Load
D. Extract, Transform and Loss

View Answer


2. ETL testing includes?

A. Verify whether the data is transforming correctly according to business requirements
B. Make sure that ETL application reports invalid data and replaces with default values
C. Make sure that data loads at expected time frame to improve scalability and performance
D. All of the above

View Answer


3. In ETL, Facts are related to dimensions.

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say

View Answer


4. How many types of facts there?

A. 1
B. 2
C. 3
D. 4

View Answer


5. _________ are data processing units comprised of fact tables and dimensions from the data warehouse.

A. OLAP
B. Cubes
C. OLTP
D. None of the above

View Answer


6. In ETL, Transformation are of ________ types.

A. 2
B. 3
C. 4
D. 5

View Answer


7. The Lookup Transformation is useful for?

A. Getting a related value from a table using a column value
B. Update slowly changing dimension table
C. Verify whether records already exist in the table
D. All of the above

View Answer


8. Which of the following arranges or creates sets of transformation?

A. Worklet
B. Workflow
C. MappletĀ 
D. Session

View Answer


9. Data purging is a process of deleting data from data warehouse.

A. Yes
B. No
C. Can be yes or no
D. Can not say

View Answer


10. __________ is an area where you hold the data temporary on data warehouse server.

A. Bus Schema
B. Data Staging
C. Schema Objects
D. Workflow

View Answer




Discussion


* You must be logged in to add comment.