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

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

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

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 2: What does a boxplot primarily communicate about a dataset?

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

Correct answer: Distribution, median, and outliers

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

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

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

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 4: What is the difference between OLTP and OLAP systems?

There is no meaningful difference between OLTP and OLAP
OLTP is used for complex analytical queries; OLAP is used for day-to-day transactions
OLTP uses star schemas; OLAP uses normalized schemas
OLTP supports high-volume transactional operations; OLAP is optimized for complex analytical and historical queries (Correct answer)

Correct answer: OLTP supports high-volume transactional operations; OLAP is optimized for complex analytical and historical queries

OLTP (Online Transaction Processing) handles frequent, short operational transactions, while OLAP (Online Analytical Processing) is designed for complex queries over large historical datasets.

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

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

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 6: What is multicollinearity in multiple regression analysis?

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

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 7: What is the purpose of a confidence interval in statistical analysis?

To determine the exact population parameter
To test whether two groups are significantly different
To measure the spread of a single variable
To provide a range of values likely to contain the true population parameter (Correct answer)

Correct answer: To provide a range of values likely to contain the true population parameter

A confidence interval gives a range of plausible values for a population parameter, with a specified level of confidence (e.g., 95%).

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

A scheduled report that runs automatically at defined intervals
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

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 9: Which type of correlation coefficient is used to measure the linear relationship between two continuous variables?

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

Correct answer: Pearson's r

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

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

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
A dashboard displaying current website traffic

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 11: Which term describes the practice of using data collected for one purpose to make decisions about individuals in an unrelated context?

Data deduplication
Function creep (Correct answer)
Schema migration
Data warehousing

Correct answer: Function creep

Function creep (also called 'scope creep') occurs when data collected for one stated purpose is later used for a different, often unintended purpose, raising serious privacy and ethical concerns.

Question 12: A heatmap is most effective for what purpose?

Comparing two exact values
Displaying a single KPI
Showing hierarchical flow
Showing intensity across a two-dimensional matrix (Correct answer)

Correct answer: Showing intensity across a two-dimensional matrix

A heatmap uses color intensity to show values across a 2D matrix of categories.

Question 13: What is Python's role in data analytics?

A spreadsheet formula language
A data storage format
A versatile programming language with libraries (pandas, NumPy, matplotlib) for data manipulation, analysis, and visualization (Correct answer)
A type of database

Correct answer: A versatile programming language with libraries (pandas, NumPy, matplotlib) for data manipulation, analysis, and visualization

Python is widely used for data analytics through libraries like pandas (data manipulation), NumPy (numerical computing), matplotlib/seaborn (visualization), and scikit-learn (machine learning), offering flexibility beyond spreadsheet tools.

Question 14: Which normal form eliminates transitive dependencies in a relational database?

Third Normal Form (3NF) (Correct answer)
Second Normal Form (2NF)
Boyce-Codd Normal Form (BCNF)
First Normal Form (1NF)

Correct answer: Third Normal Form (3NF)

Third Normal Form (3NF) requires that all non-key attributes depend only on the primary key and not on other non-key attributes (no transitive dependencies).

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

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

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.

Question 16: Which tool is commonly used for data visualization?

Hadoop
Python
MySQL
Tableau (Correct answer)

Correct answer: Tableau

Tableau is a leading business intelligence and data visualization tool specifically designed for creating interactive and shareable dashboards and reports. It allows users to connect to various data sources and build complex visualizations with a drag-and-drop interface, often without requiring extensive programming knowledge. While Python has visualization libraries, Tableau is a dedicated, user-friendly application.

Question 17: What does a regression coefficient (slope) represent in a simple linear regression model?

The value of the dependent variable when the independent variable is zero
The percentage of variance explained by the model
The expected change in the dependent variable for a one-unit increase in the independent variable (Correct answer)
The correlation between the two variables

Correct answer: The expected change in the dependent variable for a one-unit increase in the independent variable

The regression slope coefficient quantifies how much the predicted outcome changes for each one-unit increase in the predictor variable, holding other factors constant.

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

Variance
Median (Correct answer)
Standard deviation
Mean

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 19: Which of the following best describes structured data?

Data that lacks a defined format.
Data stored only in cloud systems.
Data exclusively generated from sensors.
Data organized in rows and columns. (Correct answer)

Correct answer: Data organized in rows and columns.

Structured data refers to information that is highly organized and follows a predefined format, making it easily searchable and analyzable. It typically resides in relational databases or spreadsheets, where data elements are arranged in tables with rows and columns, each having a specific type and meaning, ensuring consistency and clarity.

Question 20: What is the difference between correlation and causation?

Correlation measures the statistical relationship between variables; causation means one variable directly causes changes in another (Correct answer)
They always mean the same thing
Correlation always implies causation
Causation is weaker than correlation

Correct answer: Correlation measures the statistical relationship between variables; causation means one variable directly causes changes in another

Correlation indicates two variables move together (positive or negative relationship), but causation requires proof that one variable directly influences the other. Confounding variables can create spurious correlations.

Question 21: In Tableau, what is the difference between a live connection and an extract?

Live is slower always
Live queries the source directly; extract is a static in-memory snapshot (Correct answer)
They are identical
Extract requires internet at all times

Correct answer: Live queries the source directly; extract is a static in-memory snapshot

A live connection queries the source in real time, while an extract is a saved snapshot.

Question 22: Which of the following is an example of a data governance policy?

Using pandas for data analysis
Only authorized personnel may access personally identifiable information (PII) (Correct answer)
Setting up a Hadoop cluster
Using bar charts for sales reports

Correct answer: Only authorized personnel may access personally identifiable information (PII)

Data governance policies are formal rules that regulate how data is accessed, used, and protected — restricting PII access to authorized users is a classic example.

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

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

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 24: In regression analysis, what does the R-squared value represent?

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

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 25: What is a dashboard in data visualization?

A tool used for data encryption.
A type of relational database.
A visual representation of key data insights. (Correct answer)
A collection of physical charts.

Correct answer: A visual representation of key data insights.

A dashboard in data visualization is a centralized, interactive display that presents key data insights and performance indicators. It consolidates multiple charts, graphs, and metrics into a single, easy-to-understand view. This allows users to monitor, analyze, and track the performance of a business or specific processes at a glance.

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

To replace the data warehouse for smaller organizations
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

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 27: In Power BI, which language is used to create calculated columns and measures?

R
SQL
M
DAX (Correct answer)

Correct answer: DAX

DAX (Data Analysis Expressions) creates calculated columns and measures in Power BI.

Question 28: What is data cleaning and why is it important?

Deleting all data and starting over
Only removing duplicate records
Identifying and correcting errors, inconsistencies, and missing values in datasets; critical because analysis quality depends on data quality (Correct answer)
A cosmetic process that doesn't affect analysis

Correct answer: Identifying and correcting errors, inconsistencies, and missing values in datasets; critical because analysis quality depends on data quality

Data cleaning (data wrangling) involves handling missing values, correcting errors, standardizing formats, removing duplicates, and resolving inconsistencies — typically consuming 60-80% of an analyst's time but essential for reliable results.

Question 29: What is a Type I error in hypothesis testing?

Failing to reject a false null hypothesis
Having a sample size that is too small
Using the wrong statistical test
Rejecting a true null hypothesis (Correct answer)

Correct answer: Rejecting a true null hypothesis

A Type I error (false positive) occurs when the null hypothesis is actually true but the test incorrectly rejects it, with probability equal to the significance level alpha.

Question 30: In dashboard design, what does the term 'data-ink ratio' encourage?

Maximizing decorative elements
Removing non-essential visual clutter (Correct answer)
Increasing font sizes
Using 3D effects
Adding more colors

Correct answer: Removing non-essential visual clutter

A high data-ink ratio means removing clutter so ink represents actual data.

Question 31: When should you use a bar chart versus a line chart?

They are interchangeable for all data types
Bar charts for comparing categories; line charts for showing trends over time (Correct answer)
Line charts only for scientific data
Bar charts only for financial data

Correct answer: Bar charts for comparing categories; line charts for showing trends over time

Bar charts effectively compare discrete categories or groups, while line charts show continuous data trends over time. Choosing the wrong chart type can misrepresent the data and mislead the audience.

Question 32: Which type of analytics predicts future trends based on historical data?

Diagnostic analytics.
Predictive analytics. (Correct answer)
Descriptive analytics.
Prescriptive analytics.

Correct answer: Predictive analytics.

Predictive analytics is a type of data analytics that uses historical data, statistical algorithms, and machine learning techniques to identify the likelihood of future outcomes or trends. It aims to forecast what might happen next, enabling proactive decision-making, risk assessment, and strategic planning based on anticipated events.

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

A dimension table that is updated in real time
A type of fact table that updates slowly
A technique for managing and tracking changes to dimension data over time (Correct answer)
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 34: Which data quality dimension measures whether data correctly represents real-world values?

Accuracy (Correct answer)
Completeness
Uniqueness
Timeliness

Correct answer: Accuracy

Accuracy refers to how well data values reflect the true real-world state of the entity being described.

Question 35: In SQL, what does the DISTINCT keyword do?

Removes duplicate values from the result set (Correct answer)
Joins two tables together
Filters rows based on a condition
Sorts results in ascending order

Correct answer: Removes duplicate values from the result set

DISTINCT eliminates duplicate rows from a query result, returning only unique values for the selected columns.

Question 36: What is data storytelling?

Creating animated data presentations
Reading data reports aloud in meetings
Writing fictional stories about data
Combining data, visuals, and narrative to communicate analytical findings effectively to stakeholders (Correct answer)

Correct answer: Combining data, visuals, and narrative to communicate analytical findings effectively to stakeholders

Data storytelling weaves together accurate data, compelling visualizations, and a clear narrative structure to make analytical insights accessible, memorable, and actionable for non-technical audiences.

Question 37: What is the first step in the data analytics process?

Cleaning the dataset.
Generating machine learning models.
Performing data visualization.
Defining the problem or objective. (Correct answer)

Correct answer: Defining the problem or objective.

Before diving into data collection or analysis, the crucial first step in any data analytics project is clearly defining the business problem or objective that needs to be addressed. This ensures that all subsequent efforts—from data gathering to visualization—are focused, relevant, and aligned with achieving a specific, measurable goal.

Question 38: What is a subquery in SQL?

A stored procedure for repeated queries
A temporary table created during execution
A query nested inside another query (Correct answer)
A query that spans multiple databases

Correct answer: A query nested inside another query

A subquery (or inner query) is a SELECT statement embedded within another SQL statement, used to produce intermediate results.

Question 39: In responsible AI and data ethics, what is 'explainability'?

The ability of a model to process data faster than competing models
A regulatory requirement to publish all training data publicly
The capacity of an AI system to provide understandable reasons for its decisions or predictions (Correct answer)
The process of documenting code comments in machine learning scripts

Correct answer: The capacity of an AI system to provide understandable reasons for its decisions or predictions

Explainability refers to the degree to which an AI model's decisions can be understood and interpreted by humans, which is critical for accountability and trust.

Question 40: What is a key characteristic of big data?

Data stored in a single location.
Data that is always structured.
Data that only exists in spreadsheets.
High volume, velocity, and variety. (Correct answer)

Correct answer: High volume, velocity, and variety.

Big data is characterized by the 'Three Vs': Volume, Velocity, and Variety. Volume refers to the immense amount of data generated, Velocity to the speed at which data is generated and processed, and Variety to the diverse types and formats of data. These characteristics present unique challenges and opportunities for storage, processing, and analysis.

Question 41: Which technology is widely used for distributed processing in Big Data?

Excel Spreadsheets
SQL Databases
Blockchain
Apache Hadoop (Correct answer)

Correct answer: Apache Hadoop

Apache Hadoop is a widely used open-source framework specifically designed for distributed processing and storage of extremely large datasets across clusters of computers. Its core components, HDFS (Hadoop Distributed File System) and MapReduce, enable parallel processing of Big Data. This makes it a foundational technology for handling the volume, velocity, and variety of Big Data.

Question 42: What is the recommended maximum number of slices before a pie chart becomes hard to read?

20 slices
There is no practical limit
50 slices
Around 5-6 slices (Correct answer)

Correct answer: Around 5-6 slices

Pie charts become unreadable beyond roughly five or six slices.

Question 43: Which type of sampling ensures every member of a population has an equal chance of being selected?

Convenience sampling
Cluster sampling
Simple random sampling (Correct answer)
Purposive sampling

Correct answer: Simple random sampling

Simple random sampling gives every member of the population an equal and independent probability of selection, minimizing selection bias.

Question 44: What does ROI stand for, and how is it used in analytics strategy?

Range of Insight, used to describe the breadth of data analyzed
Rate of Inflation, used to adjust revenue figures
Reporting of Indicators, used in dashboard design
Return on Investment, used to measure the profitability of analytics initiatives relative to their cost (Correct answer)

Correct answer: Return on Investment, used to measure the profitability of analytics initiatives relative to their cost

ROI (Return on Investment) measures the net benefit of an analytics investment relative to its cost, helping justify data projects and prioritize resources.

Question 45: Which machine learning algorithm is best suited for classifying emails as spam or not spam?

K-Means Clustering
Linear Regression
Principal Component Analysis (PCA)
Naïve Bayes (Correct answer)

Correct answer: Naïve Bayes

Naïve Bayes is a probabilistic machine learning algorithm based on Bayes' theorem, commonly used for classification tasks, especially text classification. It is highly effective for classifying emails as spam or not spam because it can quickly learn from the presence or absence of specific words and features within an email. Its simplicity and efficiency make it a popular choice for this application.

Question 46: What is the purpose of a data quality scorecard?

To assign storage tiers to datasets
To measure and track data quality metrics over time against defined thresholds (Correct answer)
To rate individual employees' SQL skills
To document ETL pipeline failures

Correct answer: To measure and track data quality metrics over time against defined thresholds

A data quality scorecard provides a structured view of key quality metrics (accuracy, completeness, consistency) measured against targets over time.

Question 47: Which programming language is widely used for data analysis?

HTML
C++
Swift
Python (Correct answer)

Correct answer: Python

Python is widely recognized as a leading programming language for data analysis due to its extensive ecosystem of libraries. Libraries like Pandas, NumPy, SciPy, and Scikit-learn provide powerful tools for data manipulation, statistical analysis, machine learning, and visualization. Its readability and versatility make it a preferred choice for data professionals.

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

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

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 49: Which concept refers to an individual's right to have their personal data permanently deleted from an organization's systems?

Right to restriction
Right to erasure (Right to be forgotten) (Correct answer)
Right to rectification
Right to portability

Correct answer: Right to erasure (Right to be forgotten)

The right to erasure, also called the 'right to be forgotten,' allows individuals to request permanent deletion of their personal data when it is no longer necessary or when consent is withdrawn.

Question 50: Which SQL window function assigns a unique sequential integer to rows within a partition ordered by a specified column?

ROW_NUMBER() (Correct answer)
NTILE()
RANK()
COUNT()

Correct answer: ROW_NUMBER()

ROW_NUMBER() assigns a unique sequential number to each row within its partition, with no gaps or ties unlike RANK().

Question 51: What does 'data provenance' refer to in the context of data ethics and governance?

The documented history of where data came from, how it was transformed, and who accessed it (Correct answer)
The process of encrypting data before transmission
A legal certificate proving data ownership
The geographic location where data is physically stored

Correct answer: The documented history of where data came from, how it was transformed, and who accessed it

Data provenance tracks the origin, movement, and transformation of data over time, providing transparency and accountability that are critical for ethical data use.

Question 52: What is self-service BI?

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

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 53: What is ETL in data analytics?

A programming language for data analysis
A type of data visualization
An encryption technique for data security
Extract, Transform, Load — the process of moving data from sources, cleaning/transforming it, and loading into a data warehouse (Correct answer)

Correct answer: Extract, Transform, Load — the process of moving data from sources, cleaning/transforming it, and loading into a data warehouse

ETL is the process of extracting data from various sources, transforming it (cleaning, standardizing, aggregating), and loading it into a target data warehouse or analytics platform for analysis.

Question 54: Which of the following is an example of a data quality issue related to completeness?

A product price field contains letters
A customer record has no email address (Correct answer)
A customer's age is recorded as 250
Two records share the same customer ID

Correct answer: A customer record has no email address

Completeness refers to whether all required data attributes are present; a missing email address is a completeness issue.

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

The null hypothesis is definitely true
There is statistically significant evidence to reject the null hypothesis (Correct answer)
The sample size is too small
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 56: What is the primary purpose of data analytics?

To replace human decision-making entirely.
To randomly store large amounts of data.
To encrypt sensitive data for security purposes.
To extract insights and support decision-making. (Correct answer)

Correct answer: To extract insights and support decision-making.

Data analytics is the systematic process of examining raw data to discover meaningful patterns, correlations, and insights. Its primary purpose is to transform data into actionable information, enabling businesses and organizations to make more informed, data-driven decisions and improve various aspects of their operations and strategies.

Question 57: What are the four types of data analytics?

Only descriptive and predictive
Descriptive (what happened), diagnostic (why), predictive (what will happen), and prescriptive (what should we do) (Correct answer)
Qualitative and quantitative only
Input, process, output, and feedback

Correct answer: Descriptive (what happened), diagnostic (why), predictive (what will happen), and prescriptive (what should we do)

Analytics progresses from descriptive (summarizing past data), to diagnostic (identifying causes), to predictive (forecasting future outcomes), to prescriptive (recommending actions), each building on the previous level.

Question 58: In Power BI, what does Power Query (the M engine) primarily handle?

Data transformation and cleaning during load (Correct answer)
Row-level security
Publishing to the service
Rendering visuals

Correct answer: Data transformation and cleaning during load

Power Query transforms, cleans, and shapes data during the load/ETL step.

Question 59: What is the main purpose of data visualization?

To encrypt sensitive data.
To represent data graphically for better interpretation. (Correct answer)
To store data efficiently.
To remove duplicates from datasets.

Correct answer: To represent data graphically for better interpretation.

Data visualization's main purpose is to transform complex datasets into easily understandable graphical representations. By presenting data visually, it helps identify patterns, trends, outliers, and insights that might be difficult to discern from raw numbers. This graphical representation facilitates quicker interpretation and better decision-making.

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

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

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 61: Which BI concept refers to the ability to drill down into data for more granular detail?

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

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 62: What is ETL in data analytics?

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

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 63: What is a p-value in statistical hypothesis testing?

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

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 64: Which probability distribution is symmetric and bell-shaped, often used as a basis for statistical inference?

Poisson distribution
Exponential distribution
Binomial distribution
Normal distribution (Correct answer)

Correct answer: Normal distribution

The normal distribution is a symmetric, bell-shaped continuous probability distribution fundamental to many statistical methods and the Central Limit Theorem.

Question 65: What is 'differential privacy' as used in data analytics?

A mathematical framework that adds statistical noise to datasets to protect individual privacy while allowing aggregate analysis (Correct answer)
A method of encrypting data using different keys for different users
A technique to compare private datasets from different organizations
A privacy law that differentiates between sensitive and non-sensitive data

Correct answer: A mathematical framework that adds statistical noise to datasets to protect individual privacy while allowing aggregate analysis

Differential privacy is a mathematical technique that injects carefully calibrated noise into query results so that individual data points cannot be identified, while still allowing meaningful aggregate statistics.

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

90 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

These practice questions were written with AI tools. They are not real exam questions. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

grow.google — Eligibility · verified Oct 2026
coursera.org — Test delivery, fees, time limit · verified Oct 2026
comptia.org — Fees, retake fee, score validity, retake policy, eligibility, exam format, passing score, time limit · verified Oct 2026
pearsonvue.com — Test delivery · verified Oct 2026