Home > Data Mining > Quizzes > Data warehouse and Data mining: ETL Process and OLAP
Data warehouse and Data mining: ETL Process and OLAP
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 23% • Most missed: “The operation of moving from finer-granularity data to a coarser granularity (by…”
Data warehouse and Data mining: ETL Process and OLAP
Time left 00:00
25 Questions

1. OLTP
2. Wheel is already invented, documented, good support.
3. OLAP stands for
4. The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ________
5. Shows the path to the file to be imported.
6. This can be computationally expensive excluding SSD.
7. Two methods to ensure data integrity.
8. Flat files
9. A value of delimited shou;d be selected for delimited files.
10. Which one of the following is the right syntax for DECODE?
11. SELECT item name, color, clothes SIZE, SUM(quantity) FROM sales GROUP BY rollup(item name, color, clothes SIZE); How many grouping is possible in this rollup?
12. It is used to push data into a relation database table. This control will be the destination for most fact table data flows.
13. The source system initiates the data transfer for the ETL process. This method is uncommon in practice, as each system would have to move the data to the ETL process individually.
14. Checkpoints
15. The generalization of cross-tab which is represented visually is ____________ which is also called as data cube.
16. Logical Data Maps
17. What ETL Stands for
18. This is used to create multiple streams within a data flow from a single stream. All records in the stream are sent down all paths. Typically uses a merge-join to recombine the streams later in the data flow.
19. Ultimate flexibility, unit testing is available, usually poor documentation.
20. Load in Parallel
21. Sentinel Files
22. Transformation
23. Data that can be modeled as dimension attributes and measure attributes are called _______ data.
24. What do data warehouses support?
25. Data access methods.

⚡ Recently practiced quizzes in this topic
Live quiz activity
Data warehouse and Data mining: Mining Frequent Patterns and Association Rules Data Mining Practice Test Data Mining MCQs Data Mining and Business Intelligence Practice Test Data Mining and Business Intelligence: Clustering Data warehouse and Data mining: Introduction to Data Mining, Data Exploration and Preprocessing Data Mining and Business Intelligence: Frequent Patterns Data Mining Fundamentals Test Data warehouse and Data mining: Classification, Prediction and Clustering Data Mining and Business Intelligence: Classification
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.