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
35. ___ breaks a table into multiple tables based upon common column values
36. Companies collect and record their own operational data, but at the same time they also use reference data obtained from ___ sources such as codes, prices etc.
37. Ad-hoc access means to run such queries which are known already
38. Relational databases allow you to navigate the data in ____ that is appropriate using the primary, foreign key structure within the data model.
39. DSS queries do not involve a primary key
  • True ✔
  • False
40. The need to synchronize data upon update is called
41. Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as 
42. Node of a B-Tree is stored in memory block and traversing a B-tree involves ___ page faults
43. Which statement is true for De-Normalization?
44. De-normalization normally speeds up
45. In horizontal splitting, we split a relation into multiple tables on the basis of 
46. For good decision making, data should be integrated across the organization to cross the LoB (Line of Business). This is to give the total view of organization from:
47. A data warehouse may include
  • Legacy systems
  • Only internal data sources
  • Privacy restrictions
  • Small data mart
48. Multidimensional databases typically use proprietary ___ format to store pre-summarized cube structures
  • File
  • Application
  • Aggregate
  • Database
49. All data is ___ of something real
  • I An abstraction
  • II A representation
Which of the following option is true?
  • I only
  • II only
  • Both I and II
  • None