Thursday, 31 December 2020

CS614-Data Warehousing Quiz MCQs Lecture 1-22 Midterm Objective Questions | SUPERSTARWEBTECH



CS614-Data Warehousing Quiz MCQS #Objective #Questions #MidTerm

1. Data warehouse stores ___
2. The ___ dimension represents data correctness
3. Which of the following is not a Data Quality Validation Technique?
  • Referential Integrity
  • Using Data Quality Rules
  • Data Histograming
  • Indexes
4. Which of the following is an example of Non-Additive Facts?
5. Which is the most complex type of transformation in the following?
6. Serious ___ involves decomposing and reassembling the data
7. ___ is the degree of utility and value the data has to support the enterprise processes that enable accomplishing enterprise objectives
8. In a decision support system ease of use is achieved by:
9. Assume a company with a multi-million row customer table i.e. n rows. Checking for Referential Integrity (RI), using a smart technique with some kind of tree data structure would require ___ time
10. Which of the following is NOT an example of a typical grain?
11. Most DWH implementations today do not use ___ enforced by the database, but as TQM methods improve overall data quality and database optimizers
12. Suppose in system A, the possible values of "Gender" attribute were "Male" & "Female", however in data warehouse, the values stored were "M" for male and "F" for female. The above scenario is an example of:
13. Development of data warehouse is hard because data sources are usually ___
14. A/an ___ is a collection of random transactional codes, flags and/or text attributes that are unrelated to any particular dimension
  • Junk dimension
  • Slowly changing dimension
  • Multi-valued dimension
  • Simple dimensions
15. ROLAP provides access to information via a relational database using
16. The typical availability of OLTP system is 24/7, while that of data warehouse is ___
  • 6/12
  • 7/12
  • 1/24
  • Twice a week
17. In ___ nested-loop join of quadratic time complexity does not hurt the performance
18. If actual data structure does not conform to documented formats then it is called:
19. Which of the following is not a CUBE operation?
20. The data has to be checked, cleansed and transformed into a ___ format to allow easy and fast access
  • unified
  • predicted
  • qualified
  • proactive
21. Which is not a/an characteristics of data quality?
22. The extent to which data is in appropriate languages, symbols, and units, and the definitions are clear is known as ___
23. In case of multiple sources for the same data element, we need to prioritize the source systems per element bases, the process is called
  • Ranking
  • Prioritization
  • Element Selection
  • Measurement Selection
24. In OLTP environments, the size of tables is relatively ___
  • Large
  • Fixed
  • Moderate
  • Small
25. Change Data Capture (CDC) can be challenging task because
26. ___ is the extent to which data is regarded as true and credible
27. The relation R will be in 2nd Normal Form if 
28. ___ is the degree to which data accurately reflects the real-world object that the data represents
29. Web scrapping is a process of applying ___ techniques to the web
30. In which class of aggregates AVERAGE function can be placed?
31. Which of the following is not an "Orr's Law of Data Quality"?
32. The ___ operator proves useful in more complex metrics applicable to the dimensions of timeliness and accessibility
  • Max
  • Min
  • Min or Max
  • None
33. Which is not a/an Data Quality Validation Technique?
34. Assume a company with a multi-million row customer table i.e. n rows. Checking for Referential Integrity (RI) using a naïve approach would take ___ time.
  • O(n)
  • O(1)
  • O(log n)
  • None