Question 1 of 15 Data Concepts and Environments
Customer records stored in rows and columns inside a relational database are an example of which kind of data?
A Unstructured data B Semi-structured data C Streaming data D Structured data
Question 2 of 15 Data Concepts and Environments
Which data type is appropriate for a field that can only hold the values TRUE or FALSE?
A Boolean B Integer C String D Float
Question 3 of 15 Data Concepts and Environments
What distinguishes a data warehouse from a transactional database?
A It stores only unstructured data B It cannot hold more than one data source C It updates records faster than a transactional system D It is optimized for analytical queries over historical data rather than day-to-day transactions
Question 4 of 15 Data Acquisition and Preparation
Removing duplicate rows, fixing inconsistent spellings, and handling missing values before analysis is called what?
A Data cleansing B Data mining C Data modeling D Data masking
Question 5 of 15 Data Acquisition and Preparation
Two tables must be combined so that only customers appearing in both tables are returned. Which join accomplishes this?
A Left join B Full outer join C Cross join D Inner join
Question 6 of 15 Data Acquisition and Preparation
In an ETL pipeline, what happens during the transform stage?
A Data is copied from source systems B Data is written into the destination warehouse C Data is converted, standardized, and reshaped to fit the target model D Data is archived to cold storage
Question 7 of 15 Data Analysis
A salary dataset contains a few extremely large executive salaries. Which measure of central tendency best represents the typical salary?
A Mean B Median C Mode D Range
Question 8 of 15 Data Analysis
Which statistic describes how widely values in a dataset are spread around the mean?
A Median B Percent change C Standard deviation D Frequency
Question 9 of 15 Data Analysis
Ice cream sales and drowning incidents rise together every summer. What is the correct interpretation?
A Ice cream consumption causes drowning B The two variables are correlated, likely driven by a third factor such as hot weather C The data must be wrong D Drowning causes ice cream sales
Question 10 of 15 Visualization and Reporting
Which chart type best shows how monthly revenue has changed over the past three years?
A Pie chart B Scatter plot C Line chart D Treemap
Question 11 of 15 Visualization and Reporting
Which chart type best shows how each product category contributes to total sales for a single quarter?
A Line chart B Pie chart C Histogram D Box plot
Question 12 of 15 Data Governance
Which principle most improves an executive dashboard?
A Displaying every available metric on one screen B Using a different chart style for every tile C Placing the most important KPIs prominently and removing decorative clutter D Rotating colors randomly to keep attention
Question 13 of 15 Data Governance
Which of the following is an example of personally identifiable information?
A A customer name paired with a home address B A regional sales total C An anonymized survey score D A product SKU
Question 14 of 15 Data Governance
Who is typically responsible for defining data quality rules and approved definitions for a business domain such as customer data?
A The data steward B The database administrator C The network engineer D Any report consumer
Question 15 of 15 Data Governance
What does a data retention policy define?
A Which chart colors are permitted in reports B How long each type of data is kept before secure disposal C Which employees may build dashboards D How quickly queries must run
