IT 221 Data warehouse

Given scenario below which type of Data Warehouse Architecture it belongs:

A large online store uses different systems for storing customer data, analyzing sales, and displaying reports on a dashboard

Why do you think big companies prefer Three-Tier Architecture over Single-Tier?

• fast

• secure

• handles large data better

• all of the above

A small clinic uses one computer to store patient data and print reports directly from it.

This is n example of which data warehouse architecture?

• Single-tier Architecture

• Two-tier Architecture

• Three-tier Architecture

• ALL of the above

A ________________ is a large storage system that gathers, stores, and manages data from different sources to support business analysis and decision-making.

• Data lake

• Data mart

• Database

• Data Warehouse

• A data warehouse component where the data comes from (databases, applications).

• • Data Sources

• • Data Staging

• • Data Storage

• • Data Presentation

• A data warehouse component which is referred to the temporary storage for cleaning and processing data.

• Data Source

• Data Staging

• Data STorage

• Data Presentation

• A data warehouse components which is considered as the tools used for reports, dashboards, and analysis.

• Data Source

• Data Staging

• Data Storage

• Data Presentation

• Central Repository for storing data.

• Data Source

• Data Staging

• Data Storage

• Data Presentation

ATM withdrawal is a type of which processing __________?

• Online Transaction Processing (OLTP)

• Online Analytical Processing (OLAP)

• None of the above

• ALL of the above

Analyzing customer buying patterns is a type of which processing_________?

• OLTP (Online Transaction Processing)

• OLAP (Online Analytical Processing)

• None of the above

• All of the above