UMUC DBST 665 Midterm Answers

UMUC DBST 665 Midterm Answers

BUY HERE⬊

http://mxstudent.com/umuc-dbst-665-midterm-answers/

Part 1 (2 points for each question, for a total of 20 points)

1. The following statement applies to snow flaked schemas:

2. The following statement applies to aggregation:

3. The following statement applies to data warehouses:

4. The following statement is an example of subject-oriented:

5. The following statement is an example of nonvolatile:

6. The following statement is an example of historical:

7. The following statement is an example of summarized:

8. The following is an example of integrated:

9. Which of the following is correct in related to Online transaction processing (OLTP) and online analytical processing (OLAP) systems: 

10. Which of the following statements is true in multidimensional structures:

Part 2 (3 points for each keyword, for a total of 30 points)

1. Data warehouse

2. Dimension

3. Fact

4. Star schema

5. Snowflake schema

6. Describe the time dimension.  

7. Describe the grain of the data warehouse.  

8. Define the ETL process.

9. Define Normalization/Denormalization

10. Define Business Intelligence

Part 3 (50 points) Multidimensional Model

Step 1 – Choose the Business Process, Describe the Data Warehouse.  Define the questions that the Data Warehouse will answer. -5 points

Step 2 – Declare the Grain -5 points

Step 3 – Identify the Dimensions -10 points 

Step 4 – Identify the Facts - 10 points

Step 5 - Show the Data Model and validate the model - 20 points