CS614 Quiz 1 Solution Updated by MCS

CS614 Quiz No. 1 Solution (Jan 2021)

If found any wrong, correct it accordingly.

Q1. _________ incorporates the concept of product quality, process control, quality assurance, and quality improvement.

1. Total Quality Management page 182
2. Intrinsic Data Quality Management
3. Realistic Data Quality Management
4. Strong Data Quality Management

Correct answer: Total Quality Management page 182

Q2. The extent to which data is in appropriate languages, symbols and units, and the definitions are clear is known as __________.

1. Interpretability page 185
2. Uniqueness
3. Accessibility
4. Consistency

Correct answer: Interpretability page 185

Q3. The degree to which values are present in the attributes that require them is known as __________.

1. Completeness page 185
2. Uniqueness
3. Accessibility
4. Consistency

Correct answer: Completeness page 185

Q4. The ________ dimension represents data correctness.

1. Free-of-error page 187
2. Completeness
3. Consistency
4. Correctness

Correct answer: Free-of-error page 187

Q5. In B-tree index, the lowest level index blocks are called leaf blocks, and these blocks contain:

1. NULL value to make the leaf terminal node
2. Every indexed data value and a corresponding ROWID page 225
3. Every indexed data value and pointer to next level block
4. Every indexed data value and pointer to root block

Correct answer: Every indexed data value and a corresponding ROWID page 225

Q6. Data is the __________ on which a Data Warehouse (DWH) runs.

1. Fuel page 179
2. Element
3. Component
4. Entity

Correct answer: Fuel page 179

Q7. In context of data parallelism to get a speed-up of N with N partitions, it must be ensured that:

1. There are enough computing resources
2. Query-coordinator is very fast as compared to query servers
3. Work done in each partition almost same
4. All of the given options page 213

Correct answer: All of the given options page 213

Q8. Which of the following is not an activity of Data Quality Analysis Project?

1. "Define"
2. "Measure"
3. "Analyze"
4. "Compression" page 194

Correct answer: "Compression" page 194

Q9. Which of the following is not a Data Quality Validation Technique?

1. Referential Integrity
2. Using Data Quality Rules
3. Data Histograming
4. Indexes page 189

Correct answer: Indexes page 189

Q10. One of the preconditions to decide about operations to be parallelized is that

1. Operation can be implemented independent of each other
2. Output of one operation becomes input of other
3. Operations share same memory location
4. Operations share same namespace

Correct answer: Operation can be implemented independent of each other

Q11. ___________do not (typically) keep the index values in sorted order

1. Dense index
2. Sparse index
3. B-Tree Index
4. Hash Based index page 227

Correct answer: Hash Based index page 227

Q12. Parallelism can be exploited, if there is :

1. Symmetric multi processors (SMP)
2. Sufficient I/O bandwidth
3. Underutilized or intermittently used CPUs
4. All of the given options page 202

Correct answer: All of the given options page 202

Q13. Which of the following is NOT one of the parallel hardware architectures?

1. Symmetric Multi-Processing
2. Massively Parallel Processing
3. Non-uniform Memory Access
4. Shared Memory page 206

Correct answer: Shared Memory page 206

Q14. Two interesting examples of quality dimensions that can make use of the min operator are ____________.

1. Believability and appropriate amount of data page 188
2. Believability and Consistency
3. Believability and Redundancy
4. Reliability and appropriate amount of data

Correct answer: Believability and appropriate amount of data page 188

Q15. As the number of processors increase the speedup should also increase. Thus we should have linear speedup. Which of the following is NOT one of the barriers to achieve this linear speed-up?

1. Amdahl Law
2. Startup
3. No Interference page 219
4. Skew

Correct answer: No Interference page 219

Q16. In ________index, the ith bit is set to “1” if the ith row of the base table has the value for the indexed column

1. Inverted index
2. Bitmap index page 233
3. Cluster index
4. Join index

Correct answer: Bitmap index page 233

Q17. ________ lists each term in the collection only once and then shows a list of all the documents that contain the given term.

1. Inverted index page 232
2. Bitmap index
3. Cluster index
4. Join index

Correct answer: Inverted index page 232

Q18. The exact formula for Speed-up is:

1. (Time on Serial Processor) / (Time on parallel processors)
2. (Time on Serial Processor) * (Time on parallel processors)
3. (Time on Serial Processor) + (Time on parallel processors)
4. (Time on Serial Processor) - (Time on parallel processors)

Correct answer: (Time on Serial Processor) / (Time on parallel processors)

Q19. ___________is the degree to which data accurately reflects the real world object that the data represents

1. Intrinsic data quality page 181
2. Realistic data quality
3. Strong data quality
4. Weak data quality

Correct answer: Intrinsic data quality page 181