Explore topic-wise MCQs in Technical MCQs.

This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Technical MCQs knowledge and support exam preparation. Choose a topic below to get started.

1.

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

A. Bus Schema
B. Data Staging
C. Schema Objects
D. Workflow
E.
Answer» C. Schema Objects
Discussion
2.

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
Answer» B. No
Discussion
3.

Which of the following arranges or creates sets of transformation?

A. Worklet
B. Workflow
C. Mapplet
D. Session
Answer» D. Session
Discussion
4.

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
Answer» E.
Discussion
5.

In ETL, Transformation are of ________ types.

A. 2
B. 3
C. 4
D. 5
Answer» B. 3
Discussion
6.

_________ 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
Answer» C. OLTP
Discussion
7.

How many types of facts there?

A. 1
B. 2
C. 3
D. 4
Answer» D. 4
Discussion
8.

In ETL, Facts are related to dimensions.

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
Answer» B. FALSE
Discussion
9.

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
Answer» E.
Discussion
10.

ETL stands for?

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