There is no elevator to success. You have to take the stairs. Take your first steps with SSWT!

CS614-Data Warehousing Quiz MCQs Lecture 23-45 Finalterm Objective Questions

CS614-Data Warehousing Quiz MCQS #Objective #Questions #FinalTerm
1. Which of the following is NOT one of the variants of Nested-loop join?
2. ___ lists each term in the collection only once and then shows a list of all the documents that contain the given term
3. The optimizer uses a hash join to join two tables if they are joined using a equijoin and
4. In nested-loop join case, if there are ‘M’ rows in outer table ‘N’ rows in inner table, time complexity is
  • O (M log N)
  • O (log MN)
  • O (MN)
  • O (M + N)
5. Goal driven approach of data warehouse development was result of ___ work
  • Bill Inmon
  • Ralph Kimball
  • Bonhnlein and Ulbrich-vom
  • Westerman
6. In ___ phase of a fundamental data warehouse life cycle model, a working model of data warehouse is deployed for a selective set of users
7. One of the drawbacks of waterfall model is that:
8. Implementation of a data warehouse requires ___ activities
  • Highly integrated
  • Loosely integrated
  • Tightly decoupled
  • None
9. The ___ phase of fundamental data warehouse life cycle model includes data warehouse daily maintenance activities
  • Deployment
  • Operation
  • Enhancement
  • Maintenance
10. As per Bill Inmon, a data warehouse, in contrast with classical application is
  • Data driven
  • Resource driven
  • Requirement driven
  • Time sensitive
11. Which of the following activity executes parallel with all other activities in Kimball’s DWH development approach?
12. Which of the following activity/activities is/are part of project planning phase in Kimball’s DWH development approach?
  • Obtain resources
  • Establish the preliminary scope and justification
  • Assess organization’s readiness for a data warehouse initiative
  • All of the given
13. Improper documentation results the problem(s) like:
  • Maintenance issue
  • New developers unable to configure already existing code
  • Lot of time required for enhancing the code
  • All of the given
14. Which of the following is NOT one of the possible pitfalls in DWH Life Cycle & Development?
  • Not having multiple servers
  • Low priority for OLAP Cube Construction
  • Improper documentation
  • None

15. The Kimball’s iterative data warehouse development approach drew on decades of experience to develop the ___

16. For a smooth DWH implementation we must be a technologist
17. During the application specification activity, we also must give consideration to the organization of the applications
18. The most recent attack is the ___ attack on the cotton crop during 2003-04, resulting in a loss of nearly 0.5 million bales
  • Boll Worm
  • Purple Worm
  • Blue Worm
  • Cotton Worm
19. We must try to find the one access tool that will handle all the needs of their users
20. As opposed to the outcome of classification, estimation deal with ___ value outcome
21. To identify the ___ required we need to perform data profiling
22. ___ in agriculture extension is that pest population beyond which the benefit of spraying outweighs its cost
23. People that design and build the data warehouse must be capable of working across the organization at all levels
24. The ___ is only a small part in realizing the true business value buried within the mountain of data collected and stored within organizations business systems and operational databases
25. Data Transformation Service (DTS) provide a set of ___ that lets you extract, transform, and consolidate data from disparate sources into single or multiple destinations supported by DTS connectivity
  • Tools
  • Documentations
  • Guidelines
  • Graphs
26. The goal of ___ is to look at as few blocks as possible to find the matching records
27. A dense index, if fits into memory, costs only ___ disk I/O access to locate a record by given key
  • One
  • Two
  • log n
  • n
28. The key idea behind ___ is to take a big task and break it into subtasks that can be processed concurrently on a stream of data inputs in multiple, overlapping stages of execution
29. Non uniform distribution, when data is distributed across the processors, is called ___
  • Skew in partition
  • Pipeline distribution
  • Distributed distribution
  • Uncontrolled distribution
30. Th goal of ideal parallel execution is to completely parallelize those parts of a computation that are not constrained by data dependencies. The smaller the portion of the program that must be executed ___ the greater the scalability of the computation
31. Data mining is a/an ___ approach, where browsing through data using data mining techniques may reveal something that might be of interest to the user as information that was unknown previously
  • Exploratory
  • Non exploratory
  • Computer science
  • None
32. Data mining evolve as a mechanism to cater the limitations of ___ systems to deal massive data sets with high dimensionality, new data types, multiple heterogeneous data resources etc.
  • OLTP
  • OLAP
  • DSS
  • DWH
33. ___ is the technique in which existing heterogeneous segments are reshuffled, relocated into homogeneous segments.

34. To measure or quantify the similarity or dissimilarity, different techniques are available. Which of the following option represent the name of available techniques?

35. For a given data set, to get a global view in un-supervised learning we use
36. In DWH project, it is assured that ___ environment is similar to the production environment
37. For a DWH project, the key requirement are ___ and product experience
38. Pipeline parallelism focuses on increasing throughput of task execution, NOT on ___ sub-task execution time
39. Many data warehouse project teams waste enormous amounts of time searching in vain for a ___
  • Silver bullet
  • Golden bullet
  • Suitable hardware
  • Compatible product
40. Focusing on data warehouse delivery only often end up ___
41. Pakistan is one of the five major ___ countries in the world
42. ___ is a process which involves gathering of information about column through execution of certain queries with intention to identify erroneous records
  • Data profiling
  • Data Anomaly Detection
  • Record Duplicate Detection
  • None
43. ___ contributes to an under-utilization of valuable and expensive historical data, and inevitably results in a limited capability to provide decision support and analysis
44. DTS allows us to connect through any data source or destination that is supported by ___
  • OLE DB
  • OLAP
  • OLTP
  • Data Warehouse
45. Execution can be completed successfully or it may be stopped due to some error. In case of successful completion of execution all the transactions will be ___
46. If some errors occurs, execution will be terminated abnormally and all transactions will be rolled back. In this case when we will access the database we will find it in the state that was before the ___
47. To judge effectiveness we perform data profiling twice
48. ___ if fits into memory, costs only one disk I/O access to locate a record by given key
49. The purpose of the House of Quality technique is to reduce ___ types of risk
  • Two
  • Three
  • Four
  • All
50. NUMA stands for ___
51. There are many variants of the traditional nested-loop join. If the index is built as part of the query plan and subsequently dropped, it is called

52. Investing years in architecture and forgetting the primary purpose of solving business problems, results in inefficient application. This is the example of ___ mistake

  • Extreme Technology Design
  • Extreme Architecture Design
  • None
53. Classification consists of examining the properties of a newly presented observation and assigning it to a predefined ___
  • Object
  • Container
  • Subject
  • Class
54. During business hours, most ___ systems should probably not use parallel execution
  • OLAP
  • DSS
  • Data Mining
  • OLTP
55. In contrast to statistics, data mining is ___ driven
56. The goal of ideal parallel execution is to completely parallelize those parts of a computation that are not constrained by data dependencies. The ___ the portion of the program that must be executed sequentially, the greater the scalability of the computation.
  • Larger
  • Smaller
  • Unambiguous
  • Superior
57. If every key in the data file is represented in the index file then index is
  • Dense index ✔
  • Sparse index
  • Inverted index
  • None
58. An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is
59. ___, if too big an does not fit into memory, will be expensive when used to find a record by given key
60. Which of the following is not an activity of Data Quality Analysis Project?
61. Data mining uses ___ algorithms to discover patterns and regularities in data
62. In contrast to data mining, statistics is ___ driven
63. There are many variants of the traditional nested-loop join. When the entire table is scanned it is called
64. Which of the following is not a technique of Data Mining?
65. There are many variants of the traditional nested-loop join, if there is an index is exploited, then it is called ___


Anam Afzal

Anam Afzal

Hi, I'm a Pakistani freelancer with a passion for helping businesses achieve their online goals through no-code solutions. I specialize in WordPress customization and ManyChat automation, and I'm always on the lookout for new ways to use technology to make businesses more efficient and successful. I'm also a big believer in the power of no-code tools to democratize technology and make it accessible to everyone. I'm passionate about sharing my knowledge and helping others learn how to use no-code tools to create their own websites, automate their workflows, and grow their businesses. If you're looking for a reliable and experienced no-code developer, I'm here to help. Please feel free to contact me to discuss your project requirements.