CS614 Grand Quiz Combined

CS-614 (DATA Warehousing)

Grand Quiz Dec 2020

If you found any error in the file, Please correct it accordingly.

Q1. If one or more records in a relational table do not satisfy one or more integrity constraint, then the data:

1. Is syntactically dirty
2. Is semantically dirty
3. Has Coverage anomaly
4. Has extraction issue

Correct answer: Is semantically dirty

Q2. If actual data structure does not conform to documented formats then it is called:

1. Syntactically dirty data
2. Semantically dirty data
3. Coverage anomaly
4. Extraction issue

Correct answer: Semantically dirty data

Q3. Change Data Capture (CDC) can be challenging task because:

1. Aggregates don’t change in real time
2. Transformation of extracted data is difficult
3. Identifying the recently modified data may be difficult
4. Source systems may not support extraction of changed aggregates

Correct answer: Identifying the recently modified data may be difficult

Q4. One feature of Change Data Capture (CDC) is that:

1. It pre-calculates changed aggregates
2. It loads the transformed data in real time
3. It only processes the data that has been changed
4. It can automate the transformation of extracted data

Correct answer: It can automate the transformation of extracted data

Q5. In context of data warehouse, normally it becomes difficult to extract data from different sources because these sources are normally:

1. Heterogeneous
2. Homogeneous
3. Centralized
4. Base lined

Correct answer: Heterogeneous

Q6. Which Logical Data Extraction has significant performance impacts on the data warehouse server?

1. Incremental Extraction
2. Full Extraction
3. Partial Extraction
4. Offline Extraction

Correct answer: Incremental Extraction

Q7. Suppose in system A, the possible values of “marital status” 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:

1. One-to-One scalar transformation ok
2. One-to-many element transformation
3. Many-to-one element transformation
4. Many-to-Many element transformation

Correct answer: One-to-One scalar transformation ok

Q8. In Extract, Load, Transformation (ELT) process, you don’t need to purchase extra devices to achieve parallelism because:

1. ELT does not support parallelism
2. You already have parallel data warehouse servers
3. You have already performed transformation
4. You have already performed Loading

Correct answer: You already have parallel data warehouse servers

Q9. The Kimball s iterative data warehouse development approach drew on decades of experience to develop the _____________.

1. Business Dimensional Lifecycle
2. Data Warehouse Dimension
3. Business Definition Lifecycle
4. OLAP Dimension

Correct answer: Business Dimensional Lifecycle

Q10. Which of the following is NOT one of the advantages of changed data capture (CDC) technique.

1. Flat Files are not required.
2. Limited Query interface is required for data extraction. Page -152
3. No incremental online I/O required for log tape
4. Extraction of Change Data occurs immediately

Correct answer: Limited Query interface is required for data extraction. Page -152

Q11. The most common use of range partitioning is on______

1. Color
2. Date

Correct answer: Date

Page - 211

c. PhoneNo d. Name

Q12. Flat files are one of the prevalent structures used in______ data extraction.

1. Online
2. Offline

Correct answer: Offline

Page - 134

c. Incremental d. Full

Q13. A relation is said to be in first normal for (1NF) if it does not contain______.

1. Single value column
2. Multivalve column

google c. Derived Column d. Composite Column

Q14. In a fully normalized database, too many_______ are required.

1. Values
2. Joins

Correct answer: Joins

Page - 49

c. Queries d. Conditions

Q15. Identify data warehouse query from the following

1. List of students belong to Lahore City
2. Total number of students that have 3.5 CGPA
3. Number of students studding CS614 Course
4. Factors which can affect student performance

Q16. Which is not an issue of ROLAP in the following?

1. Slandered hierarchy of dimensions

Page-92

b. Non slandered conventions c. Maintenance d. Aggregations pitfalls

Q17. OLTP implementations are fully _______.

1. Normalized

Page-30

b. Demoralized c. Predictive d. Additive

Q18. For large record spaces and large number of records, the run time of the clustering algorithms is_________

1. Prohibitive

Page -164

b. Static c. Exponential d. Numerical