Advanced Data Utilization Quiz

Which process involves moving data from sources into a data warehouse after cleaning and formatting?

• Extract, Transform, Load — moving data from sources into a data warehouse after cleaning and formatting

• Encrypt, Transmit, Log — securing data during transfer

• Evaluate, Test, Launch — software development cycle

• Extract, Translate, Link — joining data tables

What is the main purpose of data normalisation in databases?

• To remove redundant data and improve data integrity

• To speed up query processing by denormalising tables

• To encrypt sensitive data fields

• To create backup copies of data

Rosie and Mia want to know how many lemons they'll need next week. How can predictive analytics help?

• By describing past trends only

• By forecasting future outcomes using historical data and statistical models

• By storing raw data in big data lakes

• By replacing all human decisions automatically

What is a common mistake when presenting data to business users?

• Providing too much raw data without summarisation

• Using visualisations such as bar charts and line graphs

• Limiting access to key decision makers

• Refreshing data regularly

Anaya and Jacob run a subscription business and want to measure customer retention. Which metric should they use?

• Churn rate

• Conversion rate

• Bounce rate

• Click-through rate

Why is data governance important when using business data?

• It focuses only on data storage cost savings

• It defines policies, standards, and responsibilities to ensure data quality and security

• It automates report generation

• It manages employee access to social media

In data-driven decision making, what is a “data silo”?

• A centralised database accessible to all departments

• Isolated data repositories that are not easily accessible across the organisation

• A backup storage location

• A type of data visualisation

What superpower does data storytelling give Chloe and Aarav to impress Sophie and drive business success?

• Making complex data understandable and actionable through narrative and visuals

• Increasing the size of data storage

• Encrypting data for security

• Automating data collection

Which technique should be used to handle missing data in a dataset?

• Delete entire columns

• Ignore missing values

• Impute missing values using mean or median

• Encrypt missing values

How can machine learning help improve customer segmentation at a lemonade stand?

• By manually grouping customers based on intuition

• By automatically identifying patterns and clusters in customer data without explicit programming

• By increasing email marketing frequency

• By eliminating the need for customer feedback