Applied Data Science Quiz

What is the primary goal of Business Intelligence (BI)?

• To create data warehouses

• To manage customer relationships

• To support better business decision-making

• To analyze social media data

Which of the following is NOT a component of a data warehouse?

• Data Mining Tools

• Data Visualization Tools

• Data Extraction, Transformation, and Loading (ETL)

• Data Access Tools

What does ETL stand for in the context of data warehousing?

• Evaluate, Transform, Load

• Extract, Transform, Load

• Evaluate, Test, Launch

• Extract, Transfer, Load

Which layer of a data warehouse architecture contains the original, raw data?

• The Staging Layer

• The Modeling Layer

• The Source Layer

• The Presentation Layer

What is a key benefit of using a data warehouse?

• Increased data silos

• Higher-quality data for analysis

• Slower data processing

• Reduced data security

Which of the following tools is used for data visualization?

• SAS

• Tableau

• IBM SPSS

• RapidMiner

What is the role of data warehousing in business intelligence?

• To focus solely on transaction processing

• To eliminate data integration

• To provide a reliable source of data for BI

• To create data silos

Which characteristic of a data warehouse allows for long-term analysis?

• Integrated

• Subject-Oriented

• Non-Volatile

• Time-Variant

What is a challenge associated with data warehousing?

• Increased data security

• Integration with existing systems

• Simplified data loading

• High data quality

Which of the following is a cloud data warehousing solution?

• Microsoft Access

• Amazon Redshift

• MySQL

• Oracle Database