MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
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 | |
| 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 | |
| 3. |
Which of the following arranges or creates sets of transformation? |
| A. | Worklet |
| B. | Workflow |
| C. | Mapplet |
| D. | Session |
| Answer» D. Session | |
| 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. | |
| 5. |
In ETL, Transformation are of ________ types. |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» B. 3 | |
| 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 | |
| 7. |
How many types of facts there? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» D. 4 | |
| 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 | |
| 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. | |
| 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 | |