CS614 Quiz 2 24 Nov 2025

Question:

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

A. DM modeling B. ER modeling C. OLAP D. Multi-dimensional Modeling Copied: 11/24/2025, 11:06:01 AM

Question:

_____ allows download of “cube” structures to a desktop platform without the need for shared relational or cube server.

A. HOLAP B. DOLAP C. ROLAP D. MOLAP Copied: 11/24/2025, 11:06:39 AM

Question:

Data cleansing requires involvement of domain expert because:

A. Domain expert has deep knowledge of data aggregation

B. Domain expert has deep knowledge of data summarization C. Change Data capture requires involvement of domain expert D. Domain knowledge is required to correct anomalies Copied: 11/24/2025, 11:06:53 AM

Question:

In ________ SQL generation is vastly simplified for front-end tools when the data is highly structured.

A. Star Schema B. Object oriented schema C. Hybrid schema D. MOLAP Copied: 11/24/2025, 11:07:07 AM

Question:

MDX by Microsoft is an example of _______

A. ROLAP B. DOLAP C. None of the given options D. HOLAP Copied: 11/24/2025, 11:07:21 AM

Question:

Which of the following is an example of slowly changing dimensions?

1. Asset disposal
2. Association
3. Aggregation
4. Inheritance

Copied: 11/24/2025, 11:07:49 AM

Question:

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

A. It can automate the transformation of extracted data B. It loads the transformed data in real time C. It only processes the data that has been changed D. It pre-calculates changed aggregates Copied: 11/24/2025, 11:08:17 AM

Question:

Normally ROLAP is implemented using _______

A. Hybrid Schema