BrainStation AI Data Analyst Certification (DAC™) — Questions and Answers

Question 1: What is the difference between a population and a sample in statistics?

There is no meaningful difference between the two terms
A population includes all members of a group; a sample is a subset selected for study (Correct answer)
A population is always smaller than a sample
A sample is the entire group of interest; a population is a subset used for testing

Correct answer: A population includes all members of a group; a sample is a subset selected for study

A population is the complete set of all individuals or items of interest, while a sample is a smaller subset drawn from the population for analysis.

Question 2: In stream processing, what does 'windowing' primarily allow you to do?

Convert streams into images
Encrypt the data stream
Permanently store all events on disk
Group events into finite time-based buckets for aggregation (Correct answer)

Correct answer: Group events into finite time-based buckets for aggregation

Windowing groups continuous stream events into bounded intervals so aggregations can be computed.

Question 3: Which chart type best displays the proportion of a whole across a few categories?

Histogram
Scatter plot
Pie chart (Correct answer)
Line chart

Correct answer: Pie chart

A pie chart shows each category's share of a total.

Question 4: Which type of correlation coefficient is used to measure the linear relationship between two continuous variables?

Chi-square
Pearson's r (Correct answer)
Cramer's V
Spearman's rho

Correct answer: Pearson's r

Pearson's r measures the strength and direction of the linear relationship between two continuous, normally distributed variables.

Question 5: In hypothesis testing, what does a p-value less than 0.05 typically indicate?

The sample size is too small
There is statistically significant evidence to reject the null hypothesis (Correct answer)
The null hypothesis is definitely true
The data is normally distributed

Correct answer: There is statistically significant evidence to reject the null hypothesis

A p-value below the significance threshold (commonly 0.05) indicates the observed results are unlikely under the null hypothesis, supporting its rejection.

Question 6: In BI reporting, what is an ad-hoc report?

A report created on-demand by a user to answer a specific, unplanned business question (Correct answer)
A permanent dashboard displayed on a screen for real-time monitoring
A regulatory compliance report submitted to government agencies
A scheduled report that runs automatically at defined intervals

Correct answer: A report created on-demand by a user to answer a specific, unplanned business question

An ad-hoc report is created dynamically by a user to answer a specific question not covered by pre-built standard reports, enabling flexible data exploration.

Question 7: Which SQL aggregate function returns the number of non-NULL values in a column?

MAX()
COUNT() (Correct answer)
AVG()
SUM()

Correct answer: COUNT()

COUNT() counts non-NULL values when given a column name, or all rows (including NULLs) when used as COUNT(*).

Question 8: What is ETL in data analytics?

Encrypt, Transfer, Log — a data security protocol
Evaluate, Test, Launch — a software deployment process
Extract, Transform, Load — the process of moving data from sources into a target data store (Correct answer)
Estimate, Track, Learn — a project management methodology

Correct answer: Extract, Transform, Load — the process of moving data from sources into a target data store

ETL stands for Extract, Transform, Load — the pipeline process of pulling data from source systems, transforming it for analysis, and loading it into a target data warehouse.

Question 9: Which practice improves the storytelling quality of a report?

Removing all context and comparisons
Guiding the reader with annotations and a logical flow (Correct answer)
Presenting charts without any titles or labels
Using random chart orderings

Correct answer: Guiding the reader with annotations and a logical flow

Annotations and a logical narrative flow help readers interpret and act on the data.

Question 10: What is a Key Performance Indicator (KPI) in business analytics?

A type of database schema used in data warehouses
A measurable value that demonstrates how effectively an organization is achieving key business objectives (Correct answer)
A visualization technique for comparing multiple datasets
An algorithm used in predictive analytics

Correct answer: A measurable value that demonstrates how effectively an organization is achieving key business objectives

KPIs are quantifiable metrics tied to strategic business objectives that help organizations track performance and measure progress toward goals.

Question 11: Which statistical test is appropriate for comparing the means of two independent groups?

Pearson correlation
Chi-square test
Independent samples t-test (Correct answer)
ANOVA

Correct answer: Independent samples t-test

The independent samples t-test compares the means of two unrelated groups to determine if there is a statistically significant difference.

Question 12: Which metric summarizes model performance across all classification thresholds?

Accuracy
Mean squared error
AUC-ROC (Correct answer)
R-squared

Correct answer: AUC-ROC

The AUC-ROC measures a classifier's ability to rank positives above negatives across every threshold.

Question 13: What is the purpose of a histogram?

To show the frequency distribution of a continuous variable (Correct answer)
To compare categories side by side
To track a single KPI over time
To show proportions of a whole

Correct answer: To show the frequency distribution of a continuous variable

A histogram groups continuous data into bins to show its frequency distribution.

Question 14: Which statement best describes the difference between correlation and causation?

Causation is weaker than correlation
Correlation shows association, causation shows one variable drives another (Correct answer)
They are always the same
Correlation only applies to categorical data

Correct answer: Correlation shows association, causation shows one variable drives another

Correlation measures association, but causation requires that one variable actually produces the change in another.

Question 15: What does data 'validity' mean as a data quality dimension?

Data conforms to defined formats, ranges, and business rules (Correct answer)
Data is stored without encryption
Data is replicated to a secondary server
Data has been approved by a data steward

Correct answer: Data conforms to defined formats, ranges, and business rules

Validity means that data values conform to specified formats, allowable ranges, and business rules (e.g., a date field must contain a valid date).

Question 16: Which principle suggests placing the most important dashboard metric in the top-left area?

Golden ratio only
Z-pattern / F-pattern reading flow (Correct answer)
Random placement
Center-only focus

Correct answer: Z-pattern / F-pattern reading flow

Western readers scan in Z/F patterns, so key metrics belong top-left.

Question 17: What is the primary function of a data lakehouse architecture?

To replace relational databases with NoSQL storage
To store only unstructured data like images and videos
To enable real-time transactional processing at massive scale
To combine the flexibility of a data lake with the management and performance features of a data warehouse (Correct answer)

Correct answer: To combine the flexibility of a data lake with the management and performance features of a data warehouse

A data lakehouse merges data lake storage flexibility with data warehouse management features (schema enforcement, ACID transactions, BI query performance) in a single architecture.

Question 18: Which characteristic distinguishes a 'lakehouse' architecture?

Replaces the need for any SQL
Combines data lake storage with warehouse-style management and ACID transactions (Correct answer)
Stores only unstructured images
Runs exclusively on-premises

Correct answer: Combines data lake storage with warehouse-style management and ACID transactions

A lakehouse merges low-cost lake storage with warehouse features like ACID transactions and governance.

Question 19: What does the term 'mean' refer to in descriptive statistics?

The most frequently occurring value
The middle value when data is sorted
The difference between the highest and lowest values
The arithmetic average of all values (Correct answer)

Correct answer: The arithmetic average of all values

The mean is calculated by summing all data values and dividing by the count of values, giving the arithmetic average.

Question 20: In a modern 'ELT' pattern, where does the transformation typically happen compared to ETL?

Only on the client browser
Never — data stays untransformed
Inside the target warehouse after loading raw data (Correct answer)
Before extraction from the source

Correct answer: Inside the target warehouse after loading raw data

In ELT, raw data is loaded first and transformed inside the powerful target warehouse.

Question 21: What does the acronym KPI stand for in analytics?

Known Priority Item
Key Performance Indicator (Correct answer)
Key Product Index
Key Process Indicator

Correct answer: Key Performance Indicator

A KPI is a Key Performance Indicator used to measure progress toward goals.

Question 22: What does standard deviation measure in a dataset?

The correlation between two variables
The most common value in the data
The average distance of data points from the mean (Correct answer)
The total range of values

Correct answer: The average distance of data points from the mean

Standard deviation quantifies how spread out the data values are around the mean — a larger value indicates more variability.

Question 23: What is a slowly changing dimension (SCD) in data warehousing?

A technique for managing and tracking changes to dimension data over time (Correct answer)
A dimension table that is updated in real time
A type of fact table that updates slowly
A dimension table with fewer than 100 rows

Correct answer: A technique for managing and tracking changes to dimension data over time

Slowly Changing Dimensions (SCDs) are methods (Type 1, 2, 3, etc.) for managing how changes to dimension attributes are tracked and stored in a data warehouse over time.

Question 24: Which practice reduces misleading interpretation in bar charts?

Truncating the axis to exaggerate differences
Using 3D perspective
Starting the value axis at zero (Correct answer)
Removing axis labels

Correct answer: Starting the value axis at zero

Starting the bar axis at zero prevents exaggerating differences between bars.

Question 25: What is data deduplication in the context of data quality?

Identifying and removing duplicate records from a dataset (Correct answer)
Compressing data files to save storage space
Removing columns from a table
Splitting large tables into smaller partitions

Correct answer: Identifying and removing duplicate records from a dataset

Data deduplication is the process of detecting and eliminating redundant records to ensure each entity is represented only once in a dataset.

Question 26: Which of the following is a primary characteristic of Big Data?

Small Volume
Fixed Data Structure
Low Latency
Volume, Velocity, and Variety (Correct answer)

Correct answer: Volume, Velocity, and Variety

Big Data is primarily characterized by the '3 Vs': Volume, Velocity, and Variety. Volume refers to the immense amount of data generated; Velocity describes the high speed at which data is created, collected, and processed; and Variety encompasses the diverse types of data, from structured to unstructured. These characteristics define the challenges and opportunities in managing and analyzing large, complex datasets.

Question 27: Which Apache project is a distributed publish-subscribe messaging system commonly used for real-time data pipelines?

Apache Tomcat
Apache Maven
Apache Kafka (Correct answer)
Apache Ant

Correct answer: Apache Kafka

Apache Kafka is a distributed publish-subscribe streaming platform for real-time pipelines.

Question 28: In regression analysis, what does the R-squared value represent?

The slope of the regression line
The proportion of variance in the dependent variable explained by the independent variables (Correct answer)
The significance of individual predictors
The number of variables in the model

Correct answer: The proportion of variance in the dependent variable explained by the independent variables

R-squared (coefficient of determination) measures the proportion of variance in the outcome variable that is explained by the predictor variables in the model.

Question 29: Which BI concept refers to the ability to drill down into data for more granular detail?

OLAP drill-down (Correct answer)
ETL chunking
Data aggregation
Data normalization

Correct answer: OLAP drill-down

Drill-down is an OLAP operation that allows users to navigate from summary-level data to increasingly detailed levels, such as from annual to quarterly to monthly sales.

Question 30: Which measure of central tendency is most resistant to the influence of extreme outliers?

Mean
Standard deviation
Variance
Median (Correct answer)

Correct answer: Median

The median, being the middle value of a sorted dataset, is not affected by extreme outliers the way the mean is.

Question 31: What is a dashboard in data analytics?

A social media profile page
An interactive visual display of key metrics and KPIs, providing at-a-glance monitoring of business performance (Correct answer)
A project management timeline
A car's instrument panel

Correct answer: An interactive visual display of key metrics and KPIs, providing at-a-glance monitoring of business performance

Analytics dashboards consolidate key metrics, KPIs, and visualizations into a single interactive interface, enabling stakeholders to monitor performance, identify trends, and make data-driven decisions quickly.

Question 32: What is an advantage of using serverless computing in cloud analytics?

Fixed Resource Allocation
Automatic Scaling (Correct answer)
Higher Maintenance Costs
Requires Dedicated Servers

Correct answer: Automatic Scaling

An advantage of using serverless computing in cloud analytics is automatic scaling. Serverless platforms automatically provision and scale compute resources in response to demand, meaning users don't have to manage servers or infrastructure. This 'pay-as-you-go' model, combined with automatic scaling, significantly reduces operational overhead and costs for analytical workloads.

Question 33: Which sampling method gives every member of a population an equal chance of selection?

Convenience sampling
Quota sampling
Snowball sampling
Random sampling (Correct answer)

Correct answer: Random sampling

Random sampling ensures each member has an equal probability of being chosen.

Question 34: Which is the best reason to use white space effectively in a dashboard?

To reduce the data-ink ratio
To fill unused pixels
To hide missing data
To separate content and improve readability (Correct answer)

Correct answer: To separate content and improve readability

White space separates elements and reduces clutter, improving overall readability.

Question 35: In Power BI, what is the purpose of a slicer?

To create measures
To provide an on-canvas visual filter for viewers (Correct answer)
To publish reports
To join tables

Correct answer: To provide an on-canvas visual filter for viewers

A slicer is an on-canvas control that lets viewers filter visuals interactively.

Question 36: In gradient descent, what role does the learning rate play?

It sets the number of features
It defines the number of classes
It measures accuracy
It controls the step size of each parameter update (Correct answer)

Correct answer: It controls the step size of each parameter update

The learning rate determines how large a step the algorithm takes toward minimizing the loss each iteration.

Question 37: What does a positively skewed distribution indicate about the data?

The data has no outliers
The mean equals the median
Most values are concentrated on the right side with a long left tail
Most values are concentrated on the left side with a long right tail (Correct answer)

Correct answer: Most values are concentrated on the left side with a long right tail

In a positively skewed distribution, the tail extends to the right, meaning most data values are lower but a few extreme high values pull the mean upward.

Question 38: Which of the following best defines data governance in the context of data analytics?

A tool used for data visualization
A method for compressing large datasets
A framework of policies and processes ensuring data is accurate, available, and secure (Correct answer)
A set of rules for formatting reports

Correct answer: A framework of policies and processes ensuring data is accurate, available, and secure

Data governance is a framework of policies, processes, and roles that ensures data is managed as a valuable organizational asset.

Question 39: Which chart type best displays the correlation between two continuous numeric variables?

Scatter plot (Correct answer)
Gauge
Pie chart
Word cloud

Correct answer: Scatter plot

A scatter plot maps two numeric variables on the X and Y axes to reveal correlation.

Question 40: What is a p-value in statistical hypothesis testing?

The precision of a measurement
The percentage of data that is correct
The probability of obtaining results at least as extreme as observed, assuming the null hypothesis is true (Correct answer)
The power of a statistical test

Correct answer: The probability of obtaining results at least as extreme as observed, assuming the null hypothesis is true

A p-value represents the probability of observing results as extreme as or more extreme than the data, given that the null hypothesis is true. A p-value below a chosen threshold (typically 0.05) leads to rejecting the null hypothesis.

Question 41: In data analytics, what is the interquartile range (IQR) used for?

Calculating the correlation between variables
Measuring the average of a dataset
Identifying the middle 50% of data and detecting outliers (Correct answer)
Determining the statistical significance of results

Correct answer: Identifying the middle 50% of data and detecting outliers

The IQR is the difference between the 75th and 25th percentiles, representing the spread of the middle 50% of data and commonly used in outlier detection.

Question 42: In Google Cloud, which serverless service is designed for running SQL analytics over massive datasets?

Pub/Sub
BigQuery (Correct answer)
Cloud Storage
Compute Engine

Correct answer: BigQuery

BigQuery is Google Cloud's serverless, highly scalable data warehouse for SQL analytics.

Question 43: What is the main risk of using a biased sample?

More colorful charts
Conclusions that don't represent the population (Correct answer)
Lower storage cost
Faster processing

Correct answer: Conclusions that don't represent the population

A biased sample leads to conclusions that fail to generalize to the whole population.

Question 44: Which chart type is best for showing the composition of a whole at a single point in time?

Line chart
Scatter plot
Histogram
Pie chart (Correct answer)

Correct answer: Pie chart

A pie chart displays parts of a whole as proportional slices.

Question 45: Which metric type is best visualized with a gauge or bullet chart?

Correlation between variables
Geographic clustering
Progress toward a target or goal (Correct answer)
Text frequency

Correct answer: Progress toward a target or goal

Gauge and bullet charts show a value relative to a target or threshold.

Question 46: What is multicollinearity in multiple regression analysis?

Having more observations than predictors
High correlation among two or more independent variables in the model (Correct answer)
The presence of heteroscedasticity in residuals
A violation of the normality assumption

Correct answer: High correlation among two or more independent variables in the model

Multicollinearity occurs when predictor variables in a regression model are highly correlated with each other, making it difficult to isolate their individual effects.

Question 47: What is the difference between structured and unstructured data?

Structured data is organized in rows/columns (databases); unstructured lacks predefined format (text, images, video) (Correct answer)
Unstructured data cannot be analyzed
All data is structured
They are the same thing

Correct answer: Structured data is organized in rows/columns (databases); unstructured lacks predefined format (text, images, video)

Structured data fits neatly into relational databases with defined schemas (spreadsheets, SQL databases). Unstructured data lacks a predefined format (emails, social media posts, images, videos) and requires different processing approaches.

Question 48: L1 regularization (Lasso) is especially useful because it can do what?

Guarantee 100% accuracy
Drive some coefficients exactly to zero for feature selection (Correct answer)
Increase variance
Eliminate the need for training data

Correct answer: Drive some coefficients exactly to zero for feature selection

Lasso can shrink some coefficients to exactly zero, effectively performing automatic feature selection.

Question 49: What is 'data granularity'?

The number of users
The encryption strength
The color scheme of a chart
The level of detail in the data (Correct answer)

Correct answer: The level of detail in the data

Granularity describes how detailed or summarized the data records are.

Question 50: Which SQL clause is used to filter rows after aggregation has been performed?

ORDER BY
GROUP BY
WHERE
HAVING (Correct answer)

Correct answer: HAVING

The HAVING clause filters groups after aggregation (e.g., after GROUP BY), while WHERE filters individual rows before aggregation.

Question 51: What is the purpose of a data mart in a BI architecture?

To provide a department-specific subset of a data warehouse focused on a particular subject area (Correct answer)
To serve as a real-time operational database
To store raw unprocessed data before ETL
To replace the data warehouse for smaller organizations

Correct answer: To provide a department-specific subset of a data warehouse focused on a particular subject area

A data mart is a focused subset of a data warehouse designed to serve the analytical needs of a specific business department or subject area (e.g., sales, finance).

Question 52: What does the Central Limit Theorem state?

All datasets are normally distributed
As sample size increases, the sampling distribution of the mean approaches a normal distribution (Correct answer)
The sample mean will equal the population mean exactly
Larger samples always produce smaller standard deviations

Correct answer: As sample size increases, the sampling distribution of the mean approaches a normal distribution

The Central Limit Theorem states that with a sufficiently large sample size, the distribution of sample means will approximate a normal distribution regardless of the population's shape.

Question 53: What does a boxplot primarily communicate about a dataset?

Geographic location
Time-series trend
Categorical proportions
Distribution, median, and outliers (Correct answer)

Correct answer: Distribution, median, and outliers

A boxplot shows the median, quartiles, spread, and outliers of a distribution.

Question 54: What is a data warehouse in a business intelligence context?

A physical server room where databases are stored
A tool for creating interactive dashboards
A real-time streaming data pipeline
A subject-oriented, integrated repository of historical data optimized for analytical queries (Correct answer)

Correct answer: A subject-oriented, integrated repository of historical data optimized for analytical queries

A data warehouse is a centralized repository of integrated, historical data from multiple sources, designed and optimized for analytical reporting and decision-making.

Question 55: What does 'small multiples' refer to in data visualization?

Rounding numbers down
Using tiny fonts
A single very small chart
A series of similar charts using the same scale for easy comparison (Correct answer)

Correct answer: A series of similar charts using the same scale for easy comparison

Small multiples are a grid of similar charts with shared scales, enabling quick comparison across categories.

Question 56: Which of the following is an example of prescriptive analytics?

A dashboard displaying current website traffic
A report showing last quarter's sales by region
An optimization model recommending the best pricing strategy to maximize revenue (Correct answer)
A forecast predicting next month's customer churn rate

Correct answer: An optimization model recommending the best pricing strategy to maximize revenue

Prescriptive analytics goes beyond prediction to recommend specific actions, often using optimization algorithms to identify the best course of action.

Question 57: In Power BI or Tableau, what is the main benefit of drill-down functionality?

Letting users navigate from summary to detailed levels (Correct answer)
Reducing file size
Removing the need for filters
Encrypting data

Correct answer: Letting users navigate from summary to detailed levels

Drill-down lets users move from aggregated summaries into finer detail.

Question 58: Which measure of central tendency is LEAST affected by extreme outliers?

Standard deviation
Range
Mean
Median (Correct answer)

Correct answer: Median

The median depends only on the middle position, so extreme values barely shift it.

Question 59: Which type of analysis answers the question 'What happened?'

Prescriptive analysis
Predictive analysis
Diagnostic analysis
Descriptive analysis (Correct answer)

Correct answer: Descriptive analysis

Descriptive analysis summarizes past data to explain what has already occurred.

Question 60: A KPI card on a dashboard should primarily display what?

Every dimension in the dataset
A single key metric with context like a trend or target (Correct answer)
A full narrative paragraph
A detailed table of raw records

Correct answer: A single key metric with context like a trend or target

KPI cards highlight one important metric, often with a comparison or trend for context.

Question 61: What is a 'null value' in a dataset?

A value equal to zero
A duplicate entry
A missing or unknown value (Correct answer)
A negative number

Correct answer: A missing or unknown value

A null represents missing or unknown data, which is distinct from zero.

Question 62: In statistics, the standard deviation measures:

The most frequent value
The middle value
The spread of data around the mean (Correct answer)
The total count

Correct answer: The spread of data around the mean

Standard deviation quantifies how much values deviate from the mean.

Question 63: What is self-service BI?

An approach allowing business users to access, analyze, and visualize data without relying on IT or data teams (Correct answer)
A single-user license for BI software
A BI system that requires no human oversight
Automated report delivery via email

Correct answer: An approach allowing business users to access, analyze, and visualize data without relying on IT or data teams

Self-service BI empowers non-technical business users to independently explore data, create reports, and derive insights using intuitive tools without IT dependency.

Question 64: A healthcare analytics firm in the US transfers patient data to a research partner in Europe. Which framework primarily governs the European partner's handling of this data?

GDPR (Correct answer)
SOX
CCPA
HIPAA

Correct answer: GDPR

GDPR (General Data Protection Regulation) applies to organizations that process personal data of EU residents, regardless of where the organization is located.

Question 65: What is the purpose of ANOVA (Analysis of Variance)?

To measure the correlation between two variables
To compare the means of three or more groups simultaneously (Correct answer)
To calculate the standard deviation of a sample
To test the normality of a dataset

Correct answer: To compare the means of three or more groups simultaneously

ANOVA tests whether the means of three or more independent groups are statistically different from each other, using variance within and between groups.

BrainStation AI Data Analyst Certification (DAC™)

The BrainStation DAC™ certifies proficiency in the full data analytics workflow — including SQL, Excel, Tableau, statistical analysis, data visualization, and business intelligence strategy — for aspiring data analysts.

Questions

35 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds