CS614 Quiz 2 by VU Topper RM

Q1. Vu-Topper RM (1 marks)

______________technique is a discipline used to highlight the microscopic relationships among data elements or entities.

ER modelling Page 99

Q2. Vu-Topper RM (1 marks)

Relational modelling techniques are used to develop ________________ systems.

A. OLTP Page 98

B. TCL

Q3. Vu-Topper RM (1 marks)

__________________________ does not have "business rules," it has "data rules. "

A. ER modelling Page 102

B. OLAP C. DM modeling D. Multi-dimensional Modeling

Q4. Vu-Topper RM (1 marks)

De-normalization usually speeds up _____________.

A. Data retrieval Page 51

B. Data add

Q5. Vu-Topper RM (1 marks)

Which one among the following is not an advantage of horizontal splitting??

1. Fast data retrieval Page 55
2. Slow data retrieval

Correct answer: Fast data retrieval Page 55

Q6. Vu-Topper RM (1 marks)

______________ segregates data into separate partitions so that queries do not need to examine all data in the table.

A. Horizontal splitting technique Page 55

B. Vertical splitting technique

Q7. Vu-Topper RM (1 marks)

Time variant is a characteristic of data warehouse which means: A. Data cannot be loaded in data warehouse with respect to time

B. Data loaded in data warehouse will be time stamped

Q8. Vu-Topper RM (1 marks)

For good decision making, one should be able to integrate data across the organization to give the…….of organization.

A. Total view

B. Mid view C. End view

Q9. Vu-Topper RM (1 marks)

History is excellent predictor of the __________. A. Past

B. Future

C. Current

Q10. Vu-Topper RM (1 marks)

Identify data warehouse query from the following: A. Directly maps to a star schema. B. Not Directly maps to a star schema

Q11. Vu-Topper RM (1 marks)

Which is of the most time-consuming tasks in the ETL process and, indeed, in the entire data warehousing process?

1. Data Extraction Page 132
2. Data binding

Correct answer: Data Extraction Page 132

Q12. Vu-Topper RM (1 marks)

When building a fact table in dimension modeling, the most important step is to declare the ___________________ (aggregation level) of the fact table.

A. Grain Page 117

B. Fact C. Dimensions D. Cube

Q13. Vu-Topper RM (1 marks)

Pre-joining de-normalization technique is generally used when there is __ ___________ relationship between two or more tables.

A. One to many Page 57

B. Many to one C. One to one D. Many to many

Q14. Vu-Topper RM (1 marks)

__________________ is the lowest level of detail or the atomic level of data stored in the warehouse.

A. Grain 111

B. Fact C. Dimensions D. Cube

Q15. Vu-Topper RM (1 marks)

_____________________ is a logical design technique that seeks to present the data in a standard, instinctive structure that supports highperformance and ease of understanding.

A. DM Page 103

B. AM