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
Ans : B
Explanation: ETL stands for Extract, Transform and Load. Extract does the process of reading data from a database. Transform does the converting of data into a format that could be appropriate for reporting and analysis. While, load does the process of writing the data into the target database.
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
Ans : D
Explanation: ETL testing operations includes all of the above statement
3. In ETL, Facts are related to dimensions.
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: True, In ETL Facts are related to dimensions.
4. How many types of facts there?
A. 1
B. 2
C. 3
D. 4
View Answer
Ans : C
Explanation: Types of facts are : Additive Facts, Semi-additive Facts and Non-additive Facts
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
Ans : B
Explanation: Cubes are data processing units comprised of fact tables and dimensions from the data warehouse. It provides multi-dimensional analysis.
6. In ETL, Transformation are of ________ types.
A. 2
B. 3
C. 4
D. 5
View Answer
Ans : A
Explanation: A transformation is a repository object which generates, modifies or passes data. Transformation are of two types Active and Passive.
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
Ans : D
Explanation: The Lookup Transformation is useful for All of the above statement.
8. Which of the following arranges or creates sets of transformation?
A. Worklet
B. Workflow
C. Mapplet
D. Session
View Answer
Ans : C
Explanation: Mapplet : It arranges or creates sets of transformation
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
Ans : A
Explanation: Yes, Data purging is a process of deleting data from data warehouse.
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
Ans : B
Explanation: Data staging is an area where you hold the data temporary on data warehouse server.
Discussion