Your FREE CompTIA Data+ Practice Test 2026 – 200+ Q&A
Prepare with realistic, CompTIA Data+ exam-style questions — take a full DA0-002 practice test or drill one domain.
Your exam readiness — tap to see where you stand.Master questions to boost your scoreMaster questions to raise your exam readiness score
How ready are you?
CompTIA Data+ Test Prep
To find us again, just search Find us again. Search “Career Employer CompTIA Data+”
Lock each answer to reveal the explanation instantly as you go.
To find us again, just search Find us again. Search “Career Employer CompTIA Data+”
Practice by domain
More ways to study CompTIA Data+
Study GuideCompTIA Data+ Study GuideThe most essential CompTIA Data+ topics to master before exam day — with interactive chapter quizzes and flashcards built in.FlashcardsCompTIA Data+ FlashcardsHundreds of CompTIA Data+ flashcards in multiple study modes — flip, match, type, and quiz.
CompTIA Data+ Practice Questions
In data analytics, what does the term "Data Lake" primarily refer to?
A centralized database optimized for reporting and analysis
A structured set of data stored in a relational database
A storage repository that holds a vast amount of raw data in its native format
A collection of cloud-based databases used for big data analysis
Correct answer: A storage repository that holds a vast amount of raw data in its native format
Correct answer: A storage repository that holds a vast amount of raw data in its native format. Explanation: A Data Lake is a storage repository that can store a large amount of structured, semi-structured, and unstructured data in its native format. It's a scalable and flexible solution that allows for the storage of big data without the constraints of a schema-on-write.
Which concept in data management focuses on the use of data across different domains and formats for improved decision-making?
Data Mining
Data Integration
Data Warehousing
Data Normalization
Correct answer: Data Integration
Correct answer: Data Integration. Explanation: Data Integration involves combining data from different sources, which provides a unified view of the data. This concept is crucial for making data from various domains and formats accessible and usable for analysis and decision-making.
What is the primary purpose of a Data Warehouse?
Real-time data processing
Storing unstructured data
Supporting analytical reporting and structured queries
Temporary data storage for transactional databases
Correct answer: Supporting analytical reporting and structured queries
Correct answer: Supporting analytical reporting and structured queries. Explanation: A Data Warehouse is designed to support analytical reporting and structured queries. It is a system used for reporting and data analysis, and it is a central repository of integrated data from one or more disparate sources.
In the context of data analytics, what is "Big Data" characterized by?
The complexity and variability of data
The small, structured datasets used for analysis
The use of traditional database management tools
The focus on qualitative data analysis
Correct answer: The complexity and variability of data
Correct answer: The complexity and variability of data. Explanation: Big Data is characterized by the complexity and variability of data, as well as its large volume, high velocity, and diverse variety. It refers to data sets that are so large or complex that traditional data processing software is inadequate to deal with them.
Which term describes the process of dividing a data set into smaller chunks to facilitate analysis?
Data Aggregation
Data Partitioning
Data Mining
Data Concatenation
Correct answer: Data Partitioning
Correct answer: Data Partitioning. Explanation: Data Partitioning involves dividing a database or dataset into smaller, more manageable pieces. This process is essential for efficient data management and can significantly improve the performance of data processing.
What is the main objective of data normalization in a database?
To reduce data redundancy and improve data integrity
To increase data redundancy for backup purposes
To enhance real-time data processing capabilities
To aggregate data for summary reports
Correct answer: To reduce data redundancy and improve data integrity
Correct answer: To reduce data redundancy and improve data integrity. Explanation: The main objective of data normalization in a database is to reduce redundancy and improve data integrity. It involves organizing the data in the database to avoid duplication and ensure consistency.
In data environments, what is the primary purpose of ETL (Extract, Transform, Load.) processes?
Real-time data analysis
Data backup and recovery
Converting data into actionable insights
Integrating data from various sources into a data warehouse
Correct answer: Integrating data from various sources into a data warehouse
Correct answer: Integrating data from various sources into a data warehouse. Explanation: ETL (Extract, Transform, Load.) processes are primarily used for integrating data from various sources into a data warehouse. The process involves extracting data from different sources, transforming it into a suitable format, and loading it into a data warehouse for analysis.
What does the term "Data Governance" primarily refer to?
The process of storing large amounts of data
The management of the availability, usability, integrity, and security of data
The technique of analyzing large sets of data
The hardware used for data storage solutions
Correct answer: The management of the availability, usability, integrity, and security of data
Correct answer: The management of the availability, usability, integrity, and security of data. Explanation: Data Governance involves the overall management of the availability, usability, integrity, and security of data used in an organization. It ensures that data is managed and used effectively and efficiently, adhering to policies and regulations.
In a data environment, what does "Metadata" refer to?
Unstructured data in a data lake
Data that describes other data
Real-time data streams
Redundant copies of data for backup
Correct answer: Data that describes other data
Correct answer: Data that describes other data. Explanation: Metadata is data that describes other data. It provides information about a certain item's content, such as how, when, and by whom the data was collected, created, accessed, and/or formatted.
Which concept is essential for understanding the relationships between different data elements in a database?
Data Mining
Data Mapping
Data Warehousing
Data Encryption
Correct answer: Data Mapping
Correct answer: Data Mapping. Explanation: Data Mapping is a key concept for understanding the relationships between different data elements in a database. It involves defining how individual data elements within two sets of data relate to each other and is crucial for data integration processes.
What is the primary purpose of a Master Data Management (MDM) system in a data environment?
To facilitate real-time data processing
To ensure consistent, accurate, and uniform master data across the organization
To manage user access and security settings
To store large volumes of unstructured data
Correct answer: To ensure consistent, accurate, and uniform master data across the organization
Correct answer: To ensure consistent, accurate, and uniform master data across the organization. Explanation: Master Data Management (MDM) focuses on providing a consistent, accurate, and uniform set of references for the organization's critical data. It helps in maintaining a single version of truth for this data across various systems and departments.
In the context of data environments, what is the primary role of a data steward?
Technical maintenance of database systems
Managing and overseeing data quality and lifecycle
Implementing data protection and security measures
Developing algorithms for data analysis
Correct answer: Managing and overseeing data quality and lifecycle
Correct answer: Managing and overseeing data quality and lifecycle. Explanation: A data steward is responsible for managing and overseeing the quality, integrity, and lifecycle of the data. This role involves ensuring the data is accurate, accessible, consistent, and protected.
Which type of database is optimized for retrieving and organizing large amounts of unstructured data?
Relational Database
NoSQL Database
Object-Oriented Database
Network Database
Correct answer: NoSQL Database
Correct answer: NoSQL Database. Explanation: NoSQL databases are optimized for storing, retrieving, and organizing large amounts of unstructured or semi-structured data. They provide flexible schemas and are designed to scale out by distributing data across multiple servers.
What does the term "Data Lifecycle Management" (DLM) primarily involve?
The phases of development and deployment of database systems
The process of analyzing and reporting data
The management of data from its creation to its deletion
The encryption and protection of data in transit
Correct answer: The management of data from its creation to its deletion
Correct answer: The management of data from its creation to its deletion. Explanation: Data Lifecycle Management (DLM) involves the processes of managing data throughout its lifecycle, from creation and initial storage to the time when it becomes obsolete and is deleted. This includes data creation, storage, usage, archiving, and deletion.
In a data environment, what is "data deduplication" primarily used for?
Improving the speed of data queries
Reducing the storage space required for data
Encrypting sensitive data
Normalizing data across different databases
Correct answer: Reducing the storage space required for data
Correct answer: Reducing the storage space required for data. Explanation: Data deduplication is a technique used to reduce the amount of storage space needed by eliminating redundant data. Only one unique instance of the data is actually stored, and subsequent copies are replaced with pointers to the stored data.
What is an OLAP (Online Analytical Processing) system primarily used for in a data environment?
Transaction processing
Real-time operational reporting
Complex analytical and ad-hoc queries
Data encryption and security
Correct answer: Complex analytical and ad-hoc queries
Correct answer: Complex analytical and ad-hoc queries. Explanation: OLAP (Online Analytical Processing) systems are designed for complex analytical queries and ad-hoc queries. They are optimized for querying and reporting, rather than for transaction processing, and are used primarily in data warehousing scenarios.
Which technology is primarily used for distributed processing of large data sets across clusters of computers?
Data Warehousing
ETL Tools
Hadoop
Relational Database Management System (RDBMS)
Correct answer: Hadoop
Correct answer: Hadoop. Explanation: Hadoop is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage.
What is the main characteristic of "semi-structured" data?
It is organized in a tabular format with a predefined schema
It does not have a formal structure but contains tags or other markers to separate data elements
It consists entirely of numerical data
It is completely unstructured and random
Correct answer: It does not have a formal structure but contains tags or other markers to separate data elements
Correct answer: It does not have a formal structure but contains tags or other markers to separate data elements. Explanation: Semi-structured data is a form of data that does not reside in a relational database but has some organization, containing tags or other markers to separate semantic elements and enforce hierarchies of records and fields.
In the context of data environments, what does "Data Hygiene" refer to?
The process of cleaning and maintaining the physical hardware used for data storage
The practice of keeping data organized, accurate, and up-to-date
The technique of encrypting data for security purposes
The method of backing up data regularly
Correct answer: The practice of keeping data organized, accurate, and up-to-date
Correct answer: The practice of keeping data organized, accurate, and up-to-date. Explanation: Data Hygiene refers to the practice of ensuring that data is clean, accurate, and up-to-date. This involves processes like validating, correcting, or removing inaccurate records from a database.
What does the term "Data Mart" refer to in a data environment?
A tool for real-time data processing
A subset of a data warehouse focused on a particular subject or department
A database used for storing large volumes of transactional data
A type of NoSQL database for unstructured data
Correct answer: A subset of a data warehouse focused on a particular subject or department
Correct answer: A subset of a data warehouse focused on a particular subject or department. Explanation: A Data Mart is a subset of a data warehouse focused on a specific line of business, department, or subject area. It provides users in a specific area with the data they need to perform their job effectively.
In data management, what is "Schema-on-Read" primarily associated with?
Traditional relational databases
Data Warehouses
Data Lakes
OLTP systems
Correct answer: Data Lakes
Correct answer: Data Lakes. Explanation: "Schema-on-Read" is primarily associated with Data Lakes. It refers to an approach where data is applied to a schema only when it is read from a storage location, as opposed to "Schema-on-Write," which is used in traditional relational databases.
In data mining, what is the primary purpose of the Apriori algorithm?
To classify data into different categories
To predict numerical values based on patterns
To identify frequent item sets in a dataset
To reduce the number of dimensions in a dataset
Correct answer: To identify frequent item sets in a dataset
Correct answer: To identify frequent item sets in a dataset. Explanation: The Apriori algorithm is used in data mining for finding frequent item sets and relevant association rules in a dataset, typically for market basket analysis. It is well-suited for discovering items that frequently occur together in transactional databases.
What does the term 'overfitting' refer to in the context of data mining?
The process of reducing the complexity of a model
The loss of data during the mining process
A model that is too closely fitted to the training data
Insufficient training of a data model
Correct answer: A model that is too closely fitted to the training data
Correct answer: A model that is too closely fitted to the training data. Explanation: Overfitting in data mining occurs when a model is too closely fitted to the training data, capturing noise along with the underlying pattern. As a result, it may fail to perform well on new, unseen data due to its overly specific nature.
Which data mining technique is primarily used for identifying clusters of similar data points within a dataset?
Regression analysis
Decision tree analysis
Cluster analysis
Time series analysis
Correct answer: Cluster analysis
Correct answer: Cluster analysis. Explanation: Cluster analysis is a data mining technique used to identify groups or clusters of similar data points in a dataset. It groups data objects based only on information found in the data that describes the objects and their relationships.
In data mining, what is the primary function of a decision tree?
To predict a numerical value based on input variables
To categorize data into predefined classes
To reveal hidden structures in unlabeled data
To map out all possible decision paths in a process
Correct answer: To categorize data into predefined classes
Correct answer: To categorize data into predefined classes. Explanation: A decision tree in data mining is primarily used for classification purposes. It categorizes data into predefined classes based on various attributes and their values, making it an effective tool for classification problems.
What is a key characteristic of the K-Means clustering algorithm in data mining?
It requires the number of clusters to be specified in advance
It automatically determines the number of clusters
It is used for hierarchical clustering
It is primarily used for large text-based datasets
Correct answer: It requires the number of clusters to be specified in advance
Correct answer: It requires the number of clusters to be specified in advance. Explanation: The K-Means clustering algorithm in data mining is characterized by the requirement that the number of clusters (K) must be specified before the algorithm is run. It then partitions the data into K clusters based on the attributes of the data points.
Which technique in data mining is used for identifying unusual patterns that might signify fraudulent activity?
Regression analysis
Anomaly detection
Association rule learning
Principal component analysis
Correct answer: Anomaly detection
Correct answer: Anomaly detection. Explanation: Anomaly detection in data mining is used for identifying unusual patterns or outliers that deviate significantly from the majority of the data. These unusual patterns are often of interest, especially for detecting fraudulent activity.
What is the primary goal of feature selection in the data mining process?
To increase the computational speed of the mining process
To select a subset of relevant features for building a model
To transform raw data into an understandable format
To categorize continuous data into discrete bins
Correct answer: To select a subset of relevant features for building a model
Correct answer: To select a subset of relevant features for building a model. Explanation: Feature selection in data mining involves selecting a subset of relevant features (variables, predictors) for use in model construction. It helps in reducing dimensionality, improving model performance, and reducing overfitting.
Which data mining method is typically used for analyzing data with a time-based component?
Cluster analysis
Time series analysis
Association rule mining
Neural networks
Correct answer: Time series analysis
Correct answer: Time series analysis. Explanation: Time series analysis in data mining is used for analyzing data that has a time-based component. It involves methods for analyzing time series data to extract meaningful statistics and other characteristics of the data.
In data mining, what is the purpose of using the Support Vector Machine (SVM) algorithm?
To create a regression model
To classify data into two categories
To estimate missing data values
To visualize complex data distributions
Correct answer: To classify data into two categories
Correct answer: To classify data into two categories. Explanation: The Support Vector Machine (SVM) algorithm in data mining is primarily used for classification tasks. It works by finding the hyperplane that best divides a dataset into two classes.
What is the role of 'lift' in association rule mining?
To measure the performance of a regression model
To indicate the strength of a rule over random occurrence
To calculate the distance between clusters
To determine the number of clusters in K-Means
Correct answer: To indicate the strength of a rule over random occurrence
Correct answer: To indicate the strength of a rule over random occurrence. Explanation: In association rule mining, 'lift' is a measure used to evaluate the strength and relevance of a rule. It compares the rule's confidence against the baseline probability of seeing the consequent in the data, indicating the rule's strength over random chance.
Which algorithm in data mining is best suited for handling categorical data in classification problems?
Linear Regression
K-Means Clustering
Naive Bayes Classifier
Support Vector Machine
Correct answer: Naive Bayes Classifier
Correct answer: Naive Bayes Classifier. Explanation: The Naive Bayes Classifier is particularly well-suited for handling categorical data in classification problems. It applies Bayes' theorem with the assumption of independence between predictors, making it effective for categorical data.
In data mining, what is the main purpose of using Principal Component Analysis (PCA)?
A) To classify data into different categories
To predict future trends
To reduce the dimensionality of the data
To find hidden patterns in the data
Correct answer: To reduce the dimensionality of the data
Correct answer: To reduce the dimensionality of the data. Explanation: Principal Component Analysis (PCA) is used in data mining for dimensionality reduction. It transforms the data into a new coordinate system, reducing the number of variables under consideration and retaining those that contribute most to the variance in the dataset.
Which data mining technique is used for predicting future values based on historical data?
Cluster Analysis
Association Rule Mining
Regression Analysis
Decision Tree Analysis
Correct answer: Regression Analysis
Correct answer: Regression Analysis. Explanation: Regression Analysis is a data mining technique used for predicting a continuous outcome variable (dependent variable) based on one or more predictor variables. It is typically used for forecasting and finding out causal effect relationships between variables.
In data mining, what is the primary role of a confusion matrix?
To identify the most important features in a dataset
To visualize the performance of an algorithm
To calculate the correlation between two variables
To reduce the number of dimensions in a dataset
Correct answer: To visualize the performance of an algorithm
Correct answer: To visualize the performance of an algorithm. Explanation: A confusion matrix is a table used in data mining to visualize the performance of an algorithm, typically a classifier. It allows for the easy identification of confusion between classes, showing how many observations were correctly or incorrectly classified.
What is the primary benefit of using the Random Forest algorithm in data mining?
It is computationally less intensive.
It provides high accuracy through ensemble learning.
It is suitable for linear relationships.
It requires minimal data preprocessing.
Correct answer: It provides high accuracy through ensemble learning.
Correct answer: It provides high accuracy through ensemble learning. Explanation: The primary benefit of the Random Forest algorithm in data mining is its ability to provide high accuracy. It operates by constructing a multitude of decision trees during training and outputting the class that is the mode of the classes of individual trees, a method known as ensemble learning.
In data mining, which method is used to handle missing data values?
Feature elimination
Data imputation
Data normalization
Data transformation
Correct answer: Data imputation
Correct answer: Data imputation. Explanation: Data imputation is a method used in data mining to handle missing data values. It involves replacing missing data with substituted values, which could be the mean, median, mode, or a value estimated by another predictive model.
What is the purpose of 'Gini Index' in the context of decision tree classifiers?
To measure the accuracy of the model
To determine the splitting criteria for the nodes
To calculate the distance between clusters
To evaluate the overall fit of the model
Correct answer: To determine the splitting criteria for the nodes
Correct answer: To determine the splitting criteria for the nodes. Explanation: The Gini Index is used in decision tree classifiers as a measure of impurity or purity used while creating decision trees. It helps in determining the nodes' splitting criteria, aiming to divide the dataset into the purest possible subsets.
Which algorithm is best suited for identifying unusual patterns in high-dimensional datasets?
Linear Regression
K-Nearest Neighbors
Decision Trees
One-Class SVM
Correct answer: One-Class SVM
Correct answer: One-Class SVM. Explanation: The One-Class SVM (Support Vector Machine) is particularly well-suited for identifying unusual patterns or outliers, especially in high-dimensional datasets. It is often used in anomaly detection where the goal is to identify rare events or observations.
In data mining, what is the primary use of the 'Lift' measure in association rule learning?
To assess the robustness of a rule
To evaluate the strength of a relationship between two variables
To determine the computational complexity of a rule
To calculate the variance explained by a rule
Correct answer: To evaluate the strength of a relationship between two variables
Correct answer: To evaluate the strength of a relationship between two variables. Explanation: In association rule learning, 'Lift' is used to measure the strength of a relationship between two variables. It indicates how much more often the antecedent and consequent of a rule occur together than expected if they were statistically independent.
What role does 'Cross-validation' play in the data mining process?
Data normalization
Feature selection
Model evaluation
Dimensionality reduction
Correct answer: Model evaluation
Correct answer: Model evaluation. Explanation: Cross-validation is a model evaluation technique used in data mining. It assesses how the results of a statistical analysis will generalize to an independent dataset and is mainly used to prevent overfitting.
Which data mining technique is used primarily for categorizing or grouping similar data points together?
Regression Analysis
Time Series Analysis
Cluster Analysis
Association Rule Mining
Correct answer: Cluster Analysis
Correct answer: Cluster Analysis. Explanation: Cluster Analysis is a data mining technique used primarily for categorizing or grouping similar data points together based on their characteristics. It identifies inherent structures in the data and organizes data into meaningful clusters.
In data mining, what is a common use of the DBSCAN algorithm?
Predicting numerical outcomes
Classifying data into categories
Detecting anomalies in the data
Finding density-based clusters in spatial data
Correct answer: Finding density-based clusters in spatial data
Correct answer: Finding density-based clusters in spatial data. Explanation: DBSCAN (Density-Based Spatial Clustering of Applications with Noise) is used in data mining for finding high-density areas in spatial data and separating them from low-density areas. It's particularly effective in identifying clusters of varying shapes and sizes in large spatial datasets.
Which metric in data mining is crucial for evaluating the balance between sensitivity and specificity in a classification model?
Accuracy
F1 Score
Mean Squared Error
R-squared
Correct answer: F1 Score
Correct answer: F1 Score. Explanation: The F1 Score is crucial in data mining for evaluating the balance between sensitivity (true positive rate) and specificity (true negative rate) in a classification model. It is the harmonic mean of precision and recall, providing a single metric to assess a model's performance in cases where a balance between sensitivity and specificity is required.
Which statistical test is appropriate for determining if there is a significant difference between the means of two independent groups?
Chi-square test
T-test
ANOVA
Pearson correlation
Correct answer: T-test
Correct answer: T-test. Explanation: The T-test is used for comparing the means of two independent groups to determine if there is a statistically significant difference between them. It's particularly useful when dealing with small sample sizes.
In data analysis, what does the term 'heteroscedasticity' refer to?
The presence of non-constant variance in the error terms of a regression model
The correlation between rows of a dataset
The uniformity of data distribution
The similarity in variance across different datasets
Correct answer: The presence of non-constant variance in the error terms of a regression model
Correct answer: The presence of non-constant variance in the error terms of a regression model. Explanation: Heteroscedasticity refers to the presence of non-constant variance in the error terms of a regression model. It's a violation of an assumption in ordinary least squares regression and can lead to inefficient estimations.
Which method is used in data analysis to reduce the number of features in a dataset by transforming original variables into a new set of variables?
Data normalization
Principal Component Analysis (PCA)
Linear regression
Cluster analysis
Correct answer: Principal Component Analysis (PCA)
Correct answer: Principal Component Analysis (PCA). Explanation: Principal Component Analysis (PCA) is a statistical procedure that uses an orthogonal transformation to convert a set of possibly correlated variables into a set of values of linearly uncorrelated variables called principal components.
What is the primary purpose of using a box plot in data analysis?
To display the distribution of categorical data
To show the relationship between two variables
To illustrate the central tendency and variability of a dataset
To depict the hierarchical clustering of data
Correct answer: To illustrate the central tendency and variability of a dataset
Correct answer: To illustrate the central tendency and variability of a dataset. Explanation: A box plot is used in data analysis to display the distribution of quantitative data in a way that facilitates comparisons between variables or across levels of a categorical variable. It shows the central tendency and variability of the data.
In the context of data analysis, what does 'multicollinearity' refer to?
The occurrence of high correlations between predictor variables in a regression model
The distribution of multiple datasets on a linear scale
The relationship between multiple categorical variables
The convergence of multiple regression lines
Correct answer: The occurrence of high correlations between predictor variables in a regression model
Correct answer: The occurrence of high correlations between predictor variables in a regression model. Explanation: Multicollinearity refers to the situation in which two or more predictor variables in a multiple regression model are highly correlated, meaning that one can be linearly predicted from the others with a substantial degree of accuracy.
Which data analysis technique is used to categorize or group elements of a dataset based on a set of predefined criteria?
Regression analysis
Cluster analysis
Time series analysis
Factor analysis
Correct answer: Cluster analysis
Correct answer: Cluster analysis. Explanation: Cluster analysis is a technique used to group elements of a dataset into clusters that are meaningful, useful, or both. It categorizes data based on the similarity of attributes, using a set of predefined criteria.
What is the purpose of using a scatter plot in data analysis?
To show how much one variable is affected by another
To represent the distribution of data across categories
To depict the frequency of data values
To visualize hierarchical data
Correct answer: To show how much one variable is affected by another
Correct answer: To show how much one variable is affected by another. Explanation: A scatter plot is a type of data visualization that uses dots to represent the values obtained for two different variables - one plotted along the x-axis and the other plotted along the y-axis. It is used to observe relationships between variables.
In data analysis, what is the purpose of a confusion matrix?
To display the variance of a dataset
To compare the actual values with the values predicted by a model
To show the distribution of a single variable
To represent the correlation between two categorical variables
Correct answer: To compare the actual values with the values predicted by a model
Correct answer: To compare the actual values with the values predicted by a model. Explanation: A confusion matrix is a table often used in classification problems in data analysis. It allows visualization of the performance of an algorithm, typically a supervised learning one, by comparing the actual values with the values predicted by the model.
Which of the following is a key indicator of a good fit for a regression model?
High R-squared value
High p-value
Low correlation between variables
High standard deviation of residuals
Correct answer: High R-squared value
Correct answer: High R-squared value. Explanation: A high R-squared value is a key indicator of a good fit for a regression model. It represents the proportion of the variance for the dependent variable that's explained by the independent variables in the model.
In data analysis, which method is commonly used for predicting categorical outcomes?
Linear regression
Logistic regression
Principal Component Analysis (PCA)
Time-series forecasting
Correct answer: Logistic regression
Correct answer: Logistic regression. Explanation: Logistic regression is a statistical method for predicting binary outcomes from data. It estimates the probability of a binary response based on one or more predictor variables, making it suitable for predicting categorical outcomes.
What is the primary purpose of conducting a time-series analysis in data analysis?
To categorize data into different clusters
To detect patterns and trends over time
To compare the means of different groups
To assess the relationship between two categorical variables
Correct answer: To detect patterns and trends over time
Correct answer: To detect patterns and trends over time. Explanation: Time-series analysis is used in data analysis to examine datasets composed of sequential time points. It helps in detecting patterns, trends, and seasonality in data that varies over time.
In data analysis, what does a high kurtosis in a dataset indicate?
Data points are widely spread around the mean
Data points are closely clustered around the mean
The presence of extreme values or outliers
The dataset is uniformly distributed
Correct answer: The presence of extreme values or outliers
Correct answer: The presence of extreme values or outliers. Explanation: High kurtosis in a dataset indicates a higher concentration of data points in the tails or the presence of extreme values or outliers. It shows a 'peakedness' or 'flatness' of the distribution compared to a normal distribution.
Which method is most suitable for identifying underlying dimensions or factors that explain observed correlations between variables?
Factor analysis
Regression analysis
Chi-square test
Cluster analysis
Correct answer: Factor analysis
Correct answer: Factor analysis. Explanation: Factor analysis is used in data analysis to identify underlying factors or dimensions that explain observed correlations among variables. It reduces the number of observed variables into fewer, unobserved variables (factors).
In data analysis, which technique is used for dividing data into training and testing sets for model validation?
Cross-validation
Bootstrap sampling
Stratified sampling
Random sampling
Correct answer: Cross-validation
Correct answer: Cross-validation. Explanation: Cross-validation is a resampling procedure used to evaluate predictive models by partitioning the original sample into a training set to train the model, and a test set to evaluate it.
What is the primary use of a histogram in data analysis?
To show changes over time
To depict the distribution of a single continuous variable
To illustrate the relationship between two variables
To display the hierarchy in data
Correct answer: To depict the distribution of a single continuous variable
Correct answer: To depict the distribution of a single continuous variable. Explanation: A histogram is used in data analysis to depict the distribution of a single continuous variable. It shows the frequency of data points for different ranges or bins of values, giving a sense of the distribution of the data.
Which technique is used to estimate the relationship between a dependent variable and one or more independent variables in data analysis?
Chi-square test
Logistic regression
Linear regression
K-means clustering
Correct answer: Linear regression
Correct answer: Linear regression. Explanation: Linear regression is a basic and commonly used type of predictive analysis in data analysis. It estimates the relationship between a dependent variable and one or more independent variables.
What does the term 'outlier' refer to in data analysis?
A value that lies within the interquartile range of a dataset
A value that appears most frequently in a dataset
A data point significantly different from other data points in a dataset
The average value of a dataset
Correct answer: A data point significantly different from other data points in a dataset
Correct answer: A data point significantly different from other data points in a dataset. Explanation: An outlier in data analysis is a data point that differs significantly from other observations. It is an observation that lies an abnormal distance from other values in a random sample from a population.
Which method in data analysis is used to assign weights to different variables based on their importance?
Weighted average
Standard deviation
Correlation analysis
Variance analysis
Correct answer: Weighted average
Correct answer: Weighted average. Explanation: The weighted average method in data analysis is used to assign different weights to variables based on their importance or relevance. This approach helps in aggregating data while taking into account the relative significance of various elements.
In data analysis, what is the purpose of using Spearman's rank correlation coefficient?
To assess the linear relationship between two variables
To measure the strength and direction of association between two ranked variables
To compare the means of two independent samples
To determine if there is a significant difference in the variances of two groups
Correct answer: To measure the strength and direction of association between two ranked variables
Correct answer: To measure the strength and direction of association between two ranked variables. Explanation: Spearman's rank correlation coefficient is a non-parametric measure used to assess the strength and direction of association between two ranked variables. It's used when the data is not normally distributed or is ordinal.
What is the main objective of using decision trees in data analysis?
To classify data into distinct categories
To find the mean value of a dataset
To calculate the standard deviation of a dataset
To determine the median value of a dataset
Correct answer: To classify data into distinct categories
Correct answer: To classify data into distinct categories. Explanation: Decision trees are a non-parametric supervised learning method used for classification and regression. The goal is to create a model that predicts the value of a target variable by learning simple decision rules inferred from the data features.
In the context of data analysis, what is the role of a Pareto chart?
To identify the most significant factors in a dataset
To display the frequency of data values
To show changes over different time periods
To represent the hierarchical structure of data
Correct answer: To identify the most significant factors in a dataset
Correct answer: To identify the most significant factors in a dataset. Explanation: A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the cumulative total is represented by the line. It is used to identify the most significant factors in a dataset.
Which type of chart is most appropriate for displaying the relationship between two quantitative variables?
Pie chart
Line chart
Scatter plot
Bar chart
Correct answer: Scatter plot
Correct answer: Scatter plot. Explanation: A scatter plot is ideal for displaying the relationship between two quantitative variables. It allows viewers to observe potential correlations or patterns between the variables.
When visualizing time series data, which type of chart is typically the most effective?
Pie chart
Histogram
Line chart
Stacked bar chart
Correct answer: Line chart
Correct answer: Line chart. Explanation: Line charts are most effective for visualizing time series data. They clearly show how data points change over time, making trends and patterns easily identifiable.
In data visualization, what is the primary purpose of using a heat map?
To show changes over time
To compare categories
To display geographic data
To represent data density or concentration
Correct answer: To represent data density or concentration
Correct answer: To represent data density or concentration. Explanation: The primary purpose of a heat map is to represent data density or concentration. Different colors or intensities indicate the level of activity or occurrence in the data, making it easy to identify areas of high and low concentration.
What is the main advantage of using a histogram over a bar chart for data visualization?
Showing relationships between two variables
Depicting data over time
Displaying parts of a whole
Illustrating the distribution of a single continuous variable
Correct answer: Illustrating the distribution of a single continuous variable
Correct answer: Illustrating the distribution of a single continuous variable. Explanation: A histogram's main advantage over a bar chart is in illustrating the distribution of a single continuous variable. It groups data into bins, showing the frequency of data points within each bin, which is key for understanding the distribution.
Which visualization tool is best suited for displaying hierarchical data?
Line chart
Pie chart
Tree map
Scatter plot
Correct answer: Tree map
Correct answer: Tree map. Explanation: A tree map is best suited for displaying hierarchical data. It presents data in nested rectangles, allowing viewers to see the structure of data and compare sizes of different categories.
When would a box plot be most appropriate in data visualization?
Comparing distributions across different categories
Showing trends over time
Displaying geographical variations
Illustrating relationships between two variables
Correct answer: Comparing distributions across different categories
Correct answer: Comparing distributions across different categories. Explanation: A box plot is most appropriate for comparing distributions across different categories. It provides a visual summary of the central tendency, spread, and skewness of the data, as well as identifying outliers.
In data visualization, what is the primary benefit of using a radar chart?
Correct answer: Comparing multiple quantitative variables. Explanation: The primary benefit of a radar chart is in comparing multiple quantitative variables. It allows for the display of multivariate data in the form of a two-dimensional chart, where three or more quantitative variables are represented on axes starting from the same point.
What type of data visualization is most effective for comparing individual values to the whole?
Histogram
Stacked bar chart
Pie chart
Line graph
Correct answer: Pie chart
Correct answer: Pie chart. Explanation: Pie charts are most effective for comparing individual values to the whole. Each slice of the pie shows the size of a category in relation to the entire dataset.
Which chart type is best for showing the proportion of a total over time?
Line chart
Stacked area chart
Scatter plot
Histogram
Correct answer: Stacked area chart
Correct answer: Stacked area chart. Explanation: A stacked area chart is best for showing the proportion of a total over time. It layers the data, allowing viewers to understand how each part contributes to the whole over a period.
Which visualization technique is most effective for displaying data with multiple variables, where each variable contributes to the final outcome?
Parallel coordinates plot
Radar chart
Pie chart
Bar graph
Correct answer: Parallel coordinates plot
Correct answer: Parallel coordinates plot. Explanation: Parallel coordinates plots are effective for displaying data with multiple variables, as they allow each variable to be plotted on a separate axis, all parallel to each other. This makes it easier to see relationships and patterns across multiple dimensions.
In data visualization, what is the primary purpose of a bubble chart?
To show hierarchical relationships
To compare the frequency of occurrences
To display three dimensions of data
To illustrate changes over time
Correct answer: To display three dimensions of data
Correct answer: To display three dimensions of data. Explanation: A bubble chart is used to display three dimensions of data. The position of the bubble on the axis shows two dimensions, and the size of the bubble represents the third dimension.
Which type of chart is best suited for displaying frequency distributions for categorical data?
Histogram
Scatter plot
Bar chart
Line chart
Correct answer: Bar chart
Correct answer: Bar chart. Explanation: A bar chart is best suited for displaying frequency distributions for categorical data. It uses bars to show the frequency or count of each category, making it easy to compare different categories.
What is the main advantage of using a stacked bar chart in data visualization?
It displays changes over time.
It shows individual values in relation to a total.
It compares multiple categories side by side.
It highlights correlations between variables.
Correct answer: It shows individual values in relation to a total.
Correct answer: It shows individual values in relation to a total. Explanation: The main advantage of a stacked bar chart is its ability to show individual values in relation to a total. This type of chart stacks values on top of each other, allowing viewers to see both the individual and cumulative impact.
Which chart type is most effective for comparing the composition of different groups at a single point in time?
Line chart
Pie chart
Histogram
Stacked bar chart
Correct answer: Stacked bar chart
Correct answer: Stacked bar chart. Explanation: A stacked bar chart is most effective for comparing the composition of different groups at a single point in time. It allows for the comparison of parts to the whole across different categories.
What visualization tool is best for displaying data that has a geographical component?
Line graph
Pie chart
Choropleth map
Scatter plot
Correct answer: Choropleth map
Correct answer: Choropleth map. Explanation: A choropleth map is the best tool for displaying data that has a geographical component. It uses varying shades of colors to represent data values in different geographical areas, making it easier to spot regional patterns and variations.
In data visualization, what is a waterfall chart primarily used for?
Demonstrating how initial value is affected by subsequent positive or negative values
Comparing individual values of a variable
Showing the change in data over time
Representing the distribution of a dataset
Correct answer: Demonstrating how initial value is affected by subsequent positive or negative values
Correct answer: Demonstrating how initial value is affected by subsequent positive or negative values. Explanation: A waterfall chart is primarily used to demonstrate how an initial value is affected by a series of intermediate positive or negative values. It is typically used for understanding how an initial value (like net income) is influenced by a series of positive and negative changes.
Which type of chart is most effective for displaying data where the order of categories is important?
Radar chart
Bar chart
Pie chart
Ordered bar chart
Correct answer: Ordered bar chart
Correct answer: Ordered bar chart. Explanation: An ordered bar chart is most effective for displaying data where the order of categories is significant. By arranging bars in a specific order (like ascending or descending), it emphasizes the rank or sequence of categories.
What is the primary benefit of using a funnel chart in data visualization?
It shows data over time.
It represents hierarchical data.
It illustrates the progression through a process.
It compares different groups.
Correct answer: It illustrates the progression through a process.
Correct answer: It illustrates the progression through a process. Explanation: The primary benefit of a funnel chart is its ability to illustrate the progression through a process. It's often used to represent stages in a sales process or customer journey, showing the reduction of data as it passes through the stages.
In data visualization, what is the primary use of a box-and-whisker plot?
Showing the distribution of a dataset
Illustrating the change in data over time
Comparing different categories
Highlighting the average value of data
Correct answer: Showing the distribution of a dataset
Correct answer: Showing the distribution of a dataset. Explanation: A box-and-whisker plot, or box plot, is primarily used for showing the distribution of a dataset. It provides a graphical representation of the minimum, first quartile, median, third quartile, and maximum of a dataset.
Which data governance framework component primarily focuses on ensuring data availability, usability, consistency, data integrity, and data security?
Data Architecture
Data Modeling
Data Stewardship
Data Quality Management
Correct answer: Data Stewardship
Correct answer: Data Stewardship. Explanation: Data Architecture is a component of data governance that focuses on ensuring data availability, usability, consistency, data integrity, and data security. It provides a structured framework for managing data assets across the organization.
What is the primary purpose of a Data Dictionary in the context of data governance?
To catalog data transformations
To store user credentials for data access
To provide a descriptive list of all data elements
To track the performance of database queries
Correct answer: To provide a descriptive list of all data elements
Correct answer: To provide a descriptive list of all data elements. Explanation: A Data Dictionary in data governance serves to provide a descriptive list of all data elements in the system, including their meanings, relationships to other data, origin, usage, and format. It is a key tool for ensuring data consistency and clarity.
In data governance, what is the role of a Data Steward?
To design and implement database systems
To ensure compliance with data protection laws
To manage and oversee the quality of data
To perform data analysis and interpretation
Correct answer: To manage and oversee the quality of data
Correct answer: To manage and oversee the quality of data. Explanation: A Data Steward in data governance is responsible for managing and overseeing the quality of data within the organization. This includes ensuring data accuracy, accessibility, consistency, and security.
Which concept in data governance is primarily concerned with the accuracy and consistency of data over its lifecycle?
Data Quality
Data Security
Data Lineage
Data Compliance
Correct answer: Data Quality
Correct answer: Data Quality. Explanation: Data Quality in data governance is concerned with the accuracy, consistency, and reliability of data throughout its lifecycle. It encompasses the processes and technologies involved in ensuring that data is fit for its intended purpose.
What is the main objective of implementing Data Classification policies in an organization?
To enhance data visualization techniques
To categorize data based on sensitivity and importance
To increase the speed of data processing
To improve data storage efficiency
Correct answer: To categorize data based on sensitivity and importance
Correct answer: To categorize data based on sensitivity and importance. Explanation: Data Classification policies in an organization are designed to categorize data based on its sensitivity, importance, and criticality. This helps in applying appropriate security measures and managing access controls effectively.
In the context of data governance, what does 'Data Lineage' refer to?
The process of converting raw data into meaningful information
The lifecycle that data follows from its creation to retirement
The geographic distribution of data centers
The performance metrics of data processing systems
Correct answer: The lifecycle that data follows from its creation to retirement
Correct answer: The lifecycle that data follows from its creation to retirement. Explanation: Data Lineage in data governance refers to the lifecycle that data follows from its creation to retirement. It includes the origins, movements, characteristics, and quality of the data throughout its lifecycle.
Which principle of data governance ensures that data is accessible to authorized users and applications when required?
Data Availability
Data Integrity
Data Confidentiality
Data Consistency
Correct answer: Data Availability
Correct answer: Data Availability. Explanation: Data Availability is a principle of data governance that ensures data is accessible to authorized users and applications when required. It focuses on making data reliably available for business processes and decision-making.
What does the principle of 'Data Integrity' ensure in a data governance framework?
Data is protected from unauthorized access
Data remains consistent and accurate over its lifecycle
Data is kept confidential and private
Data is disposed of securely after its use
Correct answer: Data remains consistent and accurate over its lifecycle
Correct answer: Data remains consistent and accurate over its lifecycle. Explanation: Data Integrity in a data governance framework ensures that data remains consistent, accurate, and trustworthy throughout its lifecycle. It involves maintaining and assuring the accuracy and consistency of data over time.
In data governance, what is the main purpose of implementing a Master Data Management (MDM) system?
To facilitate real-time data processing
To provide a single source of truth for key business entities
To ensure data compliance with industry standards
To optimize the performance of data storage systems
Correct answer: To provide a single source of truth for key business entities
Correct answer: To provide a single source of truth for key business entities. Explanation: Master Data Management (MDM) in data governance aims to provide a single source of truth for key business entities such as customers, products, and suppliers. MDM harmonizes, links, and synchronizes master data across an organization to ensure consistency and accuracy.
Which element in data governance is primarily responsible for defining who can take what action, on what data, in what situations?
Data Architecture
Data Modeling
Data Access Controls
Data Quality Metrics
Correct answer: Data Access Controls
Correct answer: Data Access Controls. Explanation: Data Access Controls in data governance are responsible for defining who (which users or systems) can take what action (such as view, edit, delete) on what data (specific datasets or data elements), under what situations (conditions under which access is allowed). They are crucial for ensuring data security and compliance.
What is the primary goal of implementing a Data Retention Policy in an organization?
To optimize data storage costs
To determine how long data should be stored before disposal
To enhance the speed of data retrieval
To improve the accuracy of data analysis
Correct answer: To determine how long data should be stored before disposal
Correct answer: To determine how long data should be stored before disposal. Explanation: A Data Retention Policy in an organization aims to establish guidelines for how long different types of data should be retained before being disposed of. This policy helps in compliance with legal and regulatory requirements and manages data storage effectively.
In data governance, what does the term 'Data Sovereignty' refer to?
The ability to process data in real-time
The geographic location where data is stored
The performance of data processing systems
The visualization techniques used for data representation
Correct answer: The geographic location where data is stored
Correct answer: The geographic location where data is stored. Explanation: Data Sovereignty in data governance refers to the concept that data is subject to the laws and governance structures of the country in which it is physically located. It is a key consideration for organizations operating in multiple jurisdictions.
Which process in data governance is responsible for identifying, assessing, and mitigating risks related to data?
Data Risk Management
Data Quality Assurance
Data Lifecycle Management
Data Compliance Auditing
Correct answer: Data Risk Management
Correct answer: Data Risk Management. Explanation: Data Risk Management in data governance involves identifying, assessing, and mitigating risks associated with the handling and processing of data. It aims to protect the organization from data-related risks like breaches, loss, and compliance issues.
What is the primary purpose of conducting Data Audits in an organization?
To assess the performance of data processing systems
To evaluate compliance with data governance policies
To increase the speed of data retrieval
To reduce the cost of data storage
Correct answer: To evaluate compliance with data governance policies
Correct answer: To evaluate compliance with data governance policies. Explanation: Data Audits in an organization are conducted to evaluate compliance with data governance policies and regulations. These audits help ensure that data practices align with internal standards and external legal requirements.
Which component of data governance is primarily concerned with defining policies and procedures for sensitive data handling?
Data Privacy
Data Integration
Data Warehousing
Data Visualization
Correct answer: Data Privacy
Correct answer: Data Privacy. Explanation: Data Privacy in data governance focuses on defining policies and procedures for the handling of sensitive data. It ensures that personal and confidential information is managed in a secure and compliant manner.
What is the main objective of Change Management in the context of data governance?
To ensure that changes to data systems are performed smoothly and efficiently
To update data visualization tools regularly
To enhance the speed of data processing
To improve the accuracy of data models
Correct answer: To ensure that changes to data systems are performed smoothly and efficiently
Correct answer: To ensure that changes to data systems are performed smoothly and efficiently. Explanation: Change Management in data governance ensures that any changes to data systems, processes, or technologies are executed smoothly and efficiently. It focuses on minimizing disruptions and risks associated with implementing changes in data environments.
In data governance, what role does a Data Custodian play?
Designing data models
Ensuring data privacy and security
Performing data analysis and reporting
Managing database performance
Correct answer: Ensuring data privacy and security
Correct answer: Ensuring data privacy and security. Explanation: A Data Custodian in data governance is responsible for ensuring the privacy and security of data. They manage and maintain the data assets, focusing on protecting them from unauthorized access, breaches, and other security threats.
Which element of data governance ensures that external data sources are reliable and appropriate for use in decision-making?
Data Lineage
Data Source Validation
Data Architecture
Data Integration
Correct answer: Data Source Validation
Correct answer: Data Source Validation. Explanation: Data Source Validation in data governance ensures that external data sources are reliable and appropriate for organizational use. It involves assessing the credibility, accuracy, and relevance of external data before its integration into decision-making processes.
What is the purpose of implementing Data Lifecycle Management (DLM) in an organization?
To track the performance of data processing systems
To manage the flow of data through its lifecycle from creation to disposal
To improve data visualization capabilities
To increase the accuracy of predictive analytics
Correct answer: To manage the flow of data through its lifecycle from creation to disposal
Correct answer: To manage the flow of data through its lifecycle from creation to disposal. Explanation: Data Lifecycle Management (DLM) in an organization manages the flow of data through its lifecycle, from creation and initial storage to the time when it becomes obsolete and is deleted. DLM ensures efficient and compliant handling of data at each stage.
Which practice in data governance involves defining clear roles and responsibilities for data-related activities?
Data Role Definition
Data Quality Metrics
Data Policy Development
Data Security Implementation
Correct answer: Data Role Definition
Correct answer: Data Role Definition. Explanation: Data Role Definition in data governance involves defining clear roles and responsibilities for individuals and teams involved in data-related activities. This ensures clarity and accountability in managing and using data within the organization.
In the context of data governance, what is the main focus of a Data Compliance Officer?
Enhancing data processing speeds
Ensuring adherence to data-related laws and regulations
Improving the efficiency of data storage
Developing advanced data analysis techniques
Correct answer: Ensuring adherence to data-related laws and regulations
Correct answer: Ensuring adherence to data-related laws and regulations. Explanation: A Data Compliance Officer in data governance focuses on ensuring that the organization's data practices adhere to relevant data-related laws, regulations, and standards. They play a key role in maintaining legal and regulatory compliance.
A retail analyst is choosing a storage system for nightly sales reporting that aggregates several years of cleaned, integrated transaction history from many source systems. Which storage system is purpose-built for this kind of enterprise-wide analytical reporting?
A message queue
A data warehouse
A flat file export
An OLTP transactional database
Correct answer: A data warehouse
A data warehouse is the right fit because it stores cleaned, integrated, historical data from multiple sources specifically to support analytical querying and reporting across the enterprise. An OLTP transactional database is tuned for fast inserts and updates of individual current records, not large multi-year aggregations, so it is the wrong choice here.
A marketing team wants its own narrow slice of the company data warehouse containing only campaign and lead data so its analysts can query quickly without sifting through unrelated subjects. What is this subject-focused subset called?
An operational data store
A data lake
A data mart
A staging table
Correct answer: A data mart
A data mart is a subject-oriented subset of a data warehouse scoped to a single business function such as marketing, finance, or sales, giving a department focused, faster access to relevant data. A data lake, by contrast, holds large volumes of raw multi-format data for the whole organization rather than a curated departmental slice.
An analyst is asked to explain how a data warehouse differs from a data mart to a new team member. Which statement most accurately captures the relationship?
A data mart stores raw unprocessed data, while a data warehouse stores only images and video
A data warehouse is an enterprise-wide integrated store, while a data mart is a smaller subject-specific subset often serving one department
A data warehouse holds real-time transactions, while a data mart holds historical backups
A data mart spans the whole enterprise, while a data warehouse serves a single department
Correct answer: A data warehouse is an enterprise-wide integrated store, while a data mart is a smaller subject-specific subset often serving one department
A data warehouse is an enterprise-wide integrated repository, and a data mart is a smaller, subject-specific subset of that warehouse usually built for one department or function. The reversed description is wrong because the warehouse is the broad enterprise store and the mart is the narrow departmental slice, not the other way around.
A company stores massive volumes of raw clickstream logs, sensor readings, images, and JSON documents in their native formats, applying structure only when data is read for a specific analysis. Which environment is described?
A data lake
A data mart
A star schema warehouse
A normalized OLTP database
Correct answer: A data lake
A data lake stores large volumes of raw data in its native format (structured, semi-structured, and unstructured) and applies schema only at read time, which matches the scenario. A normalized OLTP database requires a defined schema before data is written, so it cannot accept arbitrary raw multi-format content the same way.
An analyst must explain the core difference between a data warehouse and a data lake. Which distinction is correct?
A data warehouse stores curated, structured data with schema applied before loading, while a data lake stores raw multi-format data with schema applied at read time
A data warehouse stores only unstructured data, while a data lake stores only relational tables
A data warehouse uses schema-on-read, while a data lake uses schema-on-write
A data lake is always smaller and more curated than a data warehouse
Correct answer: A data warehouse stores curated, structured data with schema applied before loading, while a data lake stores raw multi-format data with schema applied at read time
A data warehouse holds curated, structured data with the schema defined before loading (schema-on-write), while a data lake holds raw data of any format and applies structure when the data is read (schema-on-read). The options that swap these properties are incorrect because warehouses are the curated schema-on-write systems and lakes are the raw schema-on-read systems.
An analyst is told a system handles thousands of small, fast inserts and updates such as recording each individual customer purchase as it happens. Which type of system is this?
OLTP (online transaction processing) systems are designed for high volumes of short, fast read/write transactions such as recording individual purchases, and they are typically highly normalized to protect data integrity. OLAP is built for complex read-heavy analytical queries over aggregated historical data, not rapid individual transaction writes.
A business intelligence team runs large, complex, ad hoc queries that scan millions of historical rows to analyze sales trends but rarely modify any data. Which processing type best describes this workload?
OLAP (online analytical processing) is optimized for complex, read-heavy analytical queries over large volumes of historical data, which matches scanning millions of rows for trend analysis. OLTP is the opposite pattern, handling many small transactional writes rather than large analytical reads.
Which pairing correctly contrasts OLTP and OLAP systems?
OLTP is denormalized for fast reads; OLAP is normalized for fast writes
OLTP uses star schemas; OLAP uses single flat tables
OLTP handles frequent short transactions and is typically normalized; OLAP handles complex analytical queries and is typically denormalized
OLTP stores only historical data; OLAP stores only current data
Correct answer: OLTP handles frequent short transactions and is typically normalized; OLAP handles complex analytical queries and is typically denormalized
OLTP systems handle frequent, short transactions and are typically highly normalized to ensure integrity and reduce redundancy, while OLAP systems handle complex analytical queries and are typically denormalized so read queries avoid expensive joins. The reversed pairing is wrong because normalization belongs to OLTP and denormalization belongs to OLAP.
A data engineer designs a warehouse with a central fact table holding sales measures, connected directly to denormalized dimension tables for product, date, and region. Which schema design is this?
A snowflake schema
A graph database
A star schema
A flat file
Correct answer: A star schema
A star schema has a central fact table linked directly to denormalized dimension tables, forming a star shape, which is exactly what is described. A snowflake schema would instead break those dimension tables into further normalized sub-tables, adding more joins.
A warehouse design normalizes its dimension tables into multiple related sub-tables, so a product dimension links out to separate category and supplier tables. Which schema is being used?
A schema-on-read lake
An entity-relationship OLTP schema
A snowflake schema
A star schema
Correct answer: A snowflake schema
A snowflake schema extends the star schema by normalizing dimension tables into additional related sub-tables, creating a branching snowflake shape with more joins. A star schema keeps its dimension tables denormalized and flat, so it does not split dimensions into sub-tables like this.
A data warehouse must keep both the prior and the current value of a customer's address by adding a new row each time the address changes while preserving the old row. Which slowly changing dimension approach is this?
A primary key constraint
Type 2 (add a new row, keep history)
A flat-file append log
Type 1 (overwrite the existing value)
Correct answer: Type 2 (add a new row, keep history)
A Type 2 slowly changing dimension adds a new row for the changed value and retains the existing row, preserving full historical and current information for trend analysis. A Type 1 dimension simply overwrites the old value, so it keeps only the current state and loses history.
A dimension table is configured so that whenever an attribute changes, the new value overwrites the old one and no history is retained. Which slowly changing dimension type is in use?
A snowflake normalization
Type 2 (add new row, keep history)
Type 1 (overwrite, keep only current)
Type 0 fact table
Correct answer: Type 1 (overwrite, keep only current)
A Type 1 slowly changing dimension overwrites the existing record with the new value, retaining only the most current state and discarding history. Type 2 differs because it keeps history by inserting a new row rather than overwriting.
An organization stores customer records in tables with predefined columns, enforced data types, and relationships joined by keys. Which database category is described?
A data lake
A key-value cache
A relational database
A document (NoSQL) database
Correct answer: A relational database
A relational database stores data in tables with predefined columns, enforced data types, and relationships expressed through keys, which is exactly the described structure. A document or other NoSQL database does not require this rigid tabular schema and is generally classified as non-relational.
A startup needs to store rapidly changing, schema-flexible JSON documents that vary from record to record without a fixed table layout. Which database type best fits?
A star schema warehouse
A normalized relational database
A delimited flat file
A non-relational (NoSQL) database
Correct answer: A non-relational (NoSQL) database
A non-relational (NoSQL) database is designed for flexible, schema-light storage of varying records such as JSON documents, so it handles changing structures well. A normalized relational database requires a fixed, predefined schema and enforced relationships, making it a poor fit for highly variable document data.
An analyst classifies the field that stores values like 'pending', 'shipped', or 'delivered' for an order. Which data type best describes these labeled categories with no inherent numeric meaning?
Categorical (dimension) data
Date data
Currency data
Continuous numeric data
Correct answer: Categorical (dimension) data
Categorical (dimension) data consists of labeled values that place records into groups such as order status, with no inherent numeric magnitude. Continuous numeric data, by contrast, represents measurable quantities along a scale, which order-status labels are not.
A field records the exact temperature of a process, which can take any value such as 72.4 or 72.41 degrees within a range. How should an analyst classify this variable?
Categorical
Alphanumeric
Discrete
Continuous
Correct answer: Continuous
A continuous variable can take any value within a range, including fractional values like 72.41 degrees, which fits a measured temperature. A discrete variable can only take separate countable values (such as a count of items) and cannot represent the infinitely divisible measurements seen here.
A column stores the number of items in each shopping cart, which can only be whole counts like 0, 1, or 5. Which classification applies to this variable?
Continuous
Discrete
Date
Currency
Correct answer: Discrete
A discrete variable takes separate, countable whole-number values such as the number of items in a cart, with no values in between. A continuous variable would allow any fractional value within a range, which a count of physical items does not.
A data analyst must store product codes such as 'A12B' and 'X9Z' that mix letters and numbers and are never used in calculations. Which data type is most appropriate?
Currency
Continuous
Alphanumeric
Numeric
Correct answer: Alphanumeric
Alphanumeric data combines letters and numbers and is treated as text rather than a value used in math, which fits product codes like 'A12B'. A numeric type would be wrong because the codes contain letters and are never used in arithmetic.
An analyst needs to store monetary amounts so that values keep a fixed two-decimal precision and a currency context for financial reporting. Which data type is designed for this?
Date
Text
Discrete
Currency
Correct answer: Currency
A currency data type is purpose-built to store monetary values with fixed decimal precision and currency context, avoiding the rounding errors common to general floating-point numbers. A plain text type would store the value as characters, which prevents reliable arithmetic and aggregation.
An analyst is told a dataset contains structured data. Which example best fits the definition of structured data?
A folder of scanned PDF documents
Free-form social media post text
A collection of raw audio recordings
Rows and columns in a relational database table with defined data types
Correct answer: Rows and columns in a relational database table with defined data types
Structured data is organized into a predefined model such as rows and columns with defined data types in a relational table, making it easy to query. Scanned PDFs, audio recordings, and free-form text are unstructured because they lack a fixed, queryable schema.
Which statement correctly contrasts structured and unstructured data?
Structured data fits a predefined row-and-column model; unstructured data (like images, audio, and free text) has no fixed schema
Unstructured data is stored only in relational databases; structured data only in lakes
Structured and unstructured data are identical except for file size
Structured data has no schema; unstructured data is always tabular
Correct answer: Structured data fits a predefined row-and-column model; unstructured data (like images, audio, and free text) has no fixed schema
Structured data conforms to a predefined model such as rows and columns with defined types, while unstructured data such as images, audio, video, and free-form text lacks any fixed schema. The reversed claim is wrong because tabular organization is the hallmark of structured data, not unstructured.
An analyst describes JSON and XML as 'semi-structured' rather than fully structured. Why do these formats fall into the semi-structured category?
They must always be loaded into a relational table before any organization exists
They contain no organizing markers at all
They use tags or key-value pairs to organize data but do not require a rigid fixed table schema
They can only store numeric values in fixed columns
Correct answer: They use tags or key-value pairs to organize data but do not require a rigid fixed table schema
Semi-structured formats like JSON and XML carry organizational markers such as tags or key-value pairs that describe the data, yet they do not enforce a rigid fixed-column table schema. That self-describing-but-flexible nature places them between fully structured tables and completely unstructured content.
Which set of examples are all considered semi-structured data?
JSON documents, XML files, and email messages with headers
A raw audio clip, a photograph, and a video file
A relational sales table, a primary key, and a foreign key
A normalized 3NF schema and its constraints
Correct answer: JSON documents, XML files, and email messages with headers
JSON documents, XML files, and emails with headers are semi-structured because they include organizing markers (tags, key-value pairs, header fields) without a rigid table schema. Relational tables are fully structured, while raw audio, photos, and video are unstructured, so those groupings do not fit semi-structured.
A developer receives data in a lightweight text format that organizes information as nested key-value pairs inside braces, commonly used for web APIs. Which file format is this?
A relational database dump
JSON (JavaScript Object Notation)
CSV (comma-separated values)
A fixed-width flat file
Correct answer: JSON (JavaScript Object Notation)
JSON (JavaScript Object Notation) is a lightweight, human-readable text format that organizes data as key-value pairs and nested objects within braces, and it is widely used for web APIs. A CSV file uses flat delimited rows without nesting or key-value structure, so it does not match the description.
An analyst opens a file that uses opening and closing tags like <customer> and </customer> to define and nest data elements. Which file format is this?
A delimited CSV file
JSON
XML (Extensible Markup Language)
A fixed-width text file
Correct answer: XML (Extensible Markup Language)
XML (Extensible Markup Language) uses paired opening and closing tags to define and nest data elements, making it a self-describing semi-structured format. JSON also stores hierarchical data but uses braces and key-value pairs rather than angle-bracket tags, so the tag-based file is XML.
An analyst exports data to a text file where each field on a line is separated by a comma. What type of file format is this an example of?
A delimited file
An XML document
A fixed-width file
An image file
Correct answer: A delimited file
A delimited file separates fields using a specific character such as a comma, tab, or pipe, with a comma-separated values (CSV) file being the most common example. A fixed-width file differs because it aligns fields by character position rather than using a separator character.
What is the key difference between a flat file and a relational database for storing data?
A flat file enforces foreign-key relationships, while a relational database cannot
A flat file holds data in a single table or file with no enforced relationships, while a relational database links multiple tables through keys and enforces structure
A relational database can only store one table, while a flat file stores many linked tables
A flat file requires SQL joins, while a relational database does not support querying
Correct answer: A flat file holds data in a single table or file with no enforced relationships, while a relational database links multiple tables through keys and enforces structure
A flat file stores data in a single table or file with no enforced relationships between records, whereas a relational database organizes data across multiple tables linked by keys and enforces structure and integrity. The reversed statements are wrong because relationship enforcement and multi-table linking are properties of relational databases, not flat files.
A web analyst inspects a file built from tags such as <p>, <div>, and <a> that define how content is structured and displayed in a browser. Which format is this?
HTML (Hypertext Markup Language)
JSON
A currency-typed column
A delimited flat file
Correct answer: HTML (Hypertext Markup Language)
HTML (Hypertext Markup Language) uses predefined tags like <p>, <div>, and <a> to mark up and present content for web browsers. While it resembles XML in using tags, HTML's tag set is fixed for describing web page structure rather than arbitrarily defining custom data elements.
In a database, what does a schema primarily define?
The physical disk where backups are stored
The logical organization and structure of the data, including tables, fields, data types, and relationships
The username and password for database access
The amount of network bandwidth available
Correct answer: The logical organization and structure of the data, including tables, fields, data types, and relationships
A schema defines the logical organization and structure of a database, specifying tables, fields, data types, keys, and the relationships among them. It is a blueprint of how data is arranged, not a storage location, credential, or network setting.
An analyst stores a library of customer-uploaded photos, voice recordings, and promotional videos for a campaign analysis. How are these media files best classified?
Semi-structured data
Structured relational data
Discrete numeric data
Unstructured data (image, audio, and video types)
Correct answer: Unstructured data (image, audio, and video types)
Image, audio, and video files are unstructured data because they do not conform to a predefined row-and-column model and cannot be queried directly without additional processing. They are not structured (no table schema) and not semi-structured (no organizing tags or key-value markers), placing them firmly in the unstructured category.
A field stores values such as '2026-06-11' to represent calendar information used for filtering and time-based grouping. Which data type should the analyst assign?
Date
Currency
Alphanumeric
Text
Correct answer: Date
A date data type is the correct choice for calendar values like '2026-06-11' because it enables proper sorting, filtering, and time-based grouping or arithmetic. Storing the same value as text would treat it as plain characters and prevent reliable chronological operations.
An organization wants a single, large, centralized repository that ingests raw structured, semi-structured, and unstructured data at scale so future analytical use cases can be defined later. Which environment best meets this need?
A fixed-width flat file
A subject-specific data mart
A normalized OLTP database
A data lake
Correct answer: A data lake
A data lake is a centralized repository that ingests raw data of all types at scale and lets analysts define structure and use cases later through schema-on-read. A subject-specific data mart is narrow and curated for one function, and an OLTP database requires a fixed schema up front, so neither supports broad raw multi-format ingestion.
A data analyst needs to pull live currency exchange rates from a financial services provider directly into a reporting pipeline without manually downloading files. The provider exposes a documented set of endpoints that return structured data on request. Which data acquisition method is the analyst using?
A delta load
An application programming interface (API)
Observation
Web scraping
Correct answer: An application programming interface (API)
An application programming interface (API) is the method, because an API is a documented set of endpoints a provider exposes so that an application can request structured data programmatically and on demand. Web scraping extracts data from the rendered HTML of web pages and is used when no API exists; a delta load is an integration timing strategy, not a collection source.
A retailer wants to collect product prices from a competitor's public website that offers no data feed or programmatic access. An analyst writes a routine that downloads the pages and extracts price fields from the page markup. What is this acquisition technique called?
Data profiling
Sampling
Web scraping
API integration
Correct answer: Web scraping
Web scraping is the technique, because it automatically extracts data from the rendered content or markup of web pages when no structured feed or API is available. API integration would require the source to expose endpoints, which this site does not; sampling selects a subset of an existing dataset rather than gathering it from a site.
In the context of the CompTIA Data+ objectives, which statement best describes data acquisition?
The process of arranging data into normalized relational tables
The process of removing duplicate records and correcting invalid values
The process of obtaining and importing data from internal and external sources into an environment for analysis
The process of building dashboards from a finished dataset
Correct answer: The process of obtaining and importing data from internal and external sources into an environment for analysis
Obtaining and importing data from internal and external sources into an environment for analysis is data acquisition, because acquisition is the front-end step of gathering raw data through methods such as APIs, web scraping, surveys, sampling, observation, and public databases. Removing duplicates and correcting values is data cleansing, a later preparation step, not acquisition.
A nightly process loads only the records that were inserted or changed in the source system since the previous run, rather than reloading the entire table. Which integration method does this describe?
Delta load
Data parsing
Full load
Transposing
Correct answer: Delta load
A delta load is the method, because it transfers only the new or changed records since the last extraction, reducing volume and processing time compared with reloading everything. A full load would reload the entire dataset each time; transposing and parsing are manipulation techniques, not integration timing strategies.
A team extracts raw data from several sources, loads it unchanged into a cloud data warehouse, and then runs transformations using the warehouse's compute engine. Which integration approach is being used?
Delta load
ELT (extract, load, transform)
ETL (extract, transform, load)
Web scraping
Correct answer: ELT (extract, load, transform)
ELT (extract, load, transform) is correct, because the data is loaded into the destination first and transformed afterward using the target system's processing power, a pattern common with scalable cloud warehouses. ETL transforms data before loading it into the destination, which is the opposite ordering of the transform and load steps.
What is the primary difference between ETL and ELT?
ETL transforms data before loading it into the target, while ELT loads raw data first and transforms it inside the target
ETL is used only for streaming data, while ELT is used only for batch data
ETL never moves data between systems, while ELT always copies data twice
ETL applies only to unstructured data, while ELT applies only to structured data
Correct answer: ETL transforms data before loading it into the target, while ELT loads raw data first and transforms it inside the target
ETL transforms data before loading while ELT loads raw data first and transforms inside the target, which is the defining distinction. ETL applies transformations in a staging area before the destination receives the data, whereas ELT pushes raw data into the target and leverages its compute for transformations. The streaming-versus-batch and structured-versus-unstructured contrasts are not what separates the two.
An analyst is documenting how raw data should be staged before it reaches an on-premises data warehouse that has limited storage and strict schema requirements. Transformations must be completed before any data lands in the warehouse. Which process fits this requirement?
ETL (extract, transform, load)
Imputation
ELT (extract, load, transform)
Delta load only
Correct answer: ETL (extract, transform, load)
ETL (extract, transform, load) fits, because transformations are completed in a staging layer and only cleaned, conformed data is loaded into the warehouse, which suits a storage-constrained, strict-schema target. ELT would load raw data into the warehouse first, which conflicts with the limit on storage and the strict schema-on-write requirement.
A market research group gathers opinions by distributing a structured questionnaire to 500 customers and recording their responses. Which data collection method is this?
Web scraping
Surveys
Delta load
API extraction
Correct answer: Surveys
Surveys is the method, because a structured questionnaire distributed to respondents to capture their answers is the definition of survey-based collection. Web scraping and API extraction pull existing data from web or system sources rather than soliciting new responses, and a delta load is an integration strategy.
A quality analyst stands on a factory floor and records how long each assembly step takes without interacting with the workers or systems. Which data collection method best describes this?
Survey
Observation
Sampling
Web scraping
Correct answer: Observation
Observation is the method, because data is gathered by directly watching and recording events or behaviors as they occur, without questioning subjects or pulling from a system. A survey would require soliciting responses, and sampling refers to selecting a subset from an existing population rather than the act of watching events.
A population dataset contains 2,000,000 records, which is too large to analyze in full within the project deadline. The analyst selects a representative subset of 5,000 records using a random selection method to draw conclusions about the whole. Which acquisition concept is being applied?
Appending
Transposing
Sampling
Aggregation
Correct answer: Sampling
Sampling is the concept, because it selects a representative subset from a larger population so conclusions can be drawn about the whole without processing every record. Aggregation summarizes values into totals or averages, while transposing and appending are manipulation operations on structure rather than selection of a subset.
During data profiling, an analyst discovers that the same customer appears in the table three times with identical values across all fields. Which data quality issue does this represent?
An outlier
Duplicate data
Missing values
Specification mismatch
Correct answer: Duplicate data
Duplicate data is the issue, because the same record appears more than once with identical values, which can inflate counts and bias results if not removed. Missing values are empty fields, a specification mismatch is data not conforming to an expected format or rule, and an outlier is an extreme value, none of which describe repeated identical rows.
An analyst is profiling a survey export and finds that a column expected to contain only the values 'Yes' or 'No' also contains entries such as 'Maybe', 'Y', and 'unknown'. Which data quality problem is this?
Specification mismatch
Duplicate data
Outlier
Missing value
Correct answer: Specification mismatch
Specification mismatch is the problem, because the field contains values that do not conform to the defined allowed values or format for that column. Duplicate data refers to repeated records, an outlier is an extreme numeric value, and a missing value is an absent entry rather than an out-of-specification one.
While profiling a dataset, an analyst notices a column meant to store dates contains several entries like 'N/A' and free-text notes, which breaks date calculations. Identifying this problem is an example of which profiling check?
Data type validation
Aggregation
Transposing
Delta loading
Correct answer: Data type validation
Data type validation is the check, because it confirms that the values in a field match the expected data type, here detecting text where dates are required. Aggregation summarizes data, transposing reshapes rows and columns, and delta loading is an integration timing method, none of which detect type violations.
What is data profiling in the data preparation process?
Loading only changed records into a warehouse
Examining a dataset to understand its structure, content, quality, and statistics before it is used
Replacing missing values with estimated values
Combining columns from two tables into one row
Correct answer: Examining a dataset to understand its structure, content, quality, and statistics before it is used
Examining a dataset to understand its structure, content, quality, and statistics before use is data profiling, because profiling assesses things like value distributions, completeness, formats, and anomalies to plan cleansing. Replacing missing values is imputation, loading only changed records is a delta load, and combining columns from two tables is a join or merge.
What is data cleansing?
Detecting and correcting or removing inaccurate, incomplete, duplicate, or improperly formatted records from a dataset
Loading raw data into a warehouse before transforming it
Plotting variables to reveal relationships
Selecting a representative subset of a population for analysis
Correct answer: Detecting and correcting or removing inaccurate, incomplete, duplicate, or improperly formatted records from a dataset
Detecting and correcting or removing inaccurate, incomplete, duplicate, or improperly formatted records is data cleansing, because cleansing improves data quality by fixing or eliminating problems found during profiling. Selecting a subset is sampling, loading before transforming is ELT, and plotting variables is visualization, none of which describe correcting bad records.
A new analyst asks how data wrangling differs from data cleaning. Which explanation is most accurate?
Data cleaning is broader than data wrangling and includes all transformation steps
Data wrangling is the broad end-to-end process of transforming and mapping raw data into a usable form, and data cleaning is the specific subset focused on fixing errors and inconsistencies
The two terms are unrelated; wrangling concerns storage and cleaning concerns visualization
Data wrangling applies only to numeric data while data cleaning applies only to text
Correct answer: Data wrangling is the broad end-to-end process of transforming and mapping raw data into a usable form, and data cleaning is the specific subset focused on fixing errors and inconsistencies
Data wrangling is the broad process of transforming and mapping raw data into a usable form, and data cleaning is the narrower subset focused on fixing errors, which is the accurate relationship. Cleaning is one stage within wrangling rather than the larger process, so claiming cleaning is broader reverses the hierarchy.
What is data wrangling?
The overall process of transforming, restructuring, and enriching raw data into a clean, usable format for analysis
The act of selecting which chart type to use for a report
The encryption of sensitive fields before storage
The scheduling of nightly delta loads
Correct answer: The overall process of transforming, restructuring, and enriching raw data into a clean, usable format for analysis
The overall process of transforming, restructuring, and enriching raw data into a clean, usable format is data wrangling, because wrangling (also called munging) spans cleansing, structuring, and enriching to prepare data for analysis. Choosing a chart is visualization, encryption is a security control, and scheduling delta loads is an integration task.
How does data wrangling differ from ETL?
Data wrangling only moves data between databases, while ETL only fixes errors
ETL is always manual while data wrangling is always automated
Data wrangling is often an exploratory, analyst-driven preparation of a specific dataset, while ETL is a structured, repeatable pipeline that moves and transforms data between systems
They are identical terms with no practical distinction
Correct answer: Data wrangling is often an exploratory, analyst-driven preparation of a specific dataset, while ETL is a structured, repeatable pipeline that moves and transforms data between systems
Data wrangling is exploratory, analyst-driven preparation while ETL is a structured, repeatable pipeline between systems, which captures the practical difference. Wrangling is typically iterative and tied to a particular analysis, whereas ETL is engineered and scheduled to feed warehouses. The automation and movement-only descriptions misstate both terms.
A dataset has 1,000 customer rows, but 80 rows have a blank value in the 'annual_income' field. The analyst must decide how to handle these gaps before modeling. Which preparation issue is being addressed?
Aggregation
Transposing
Missing values
Duplicate data
Correct answer: Missing values
Missing values is the issue, because the blank 'annual_income' fields are absent entries that must be handled before analysis. Duplicate data refers to repeated rows, transposing reshapes the table, and aggregation summarizes values, none of which describe empty fields requiring a fill or removal decision.
An analyst chooses to remove every row that has any missing value before running a statistical test. Which missing-data handling method is this, and what is its main risk?
Aggregation, which hides individual records
Listwise deletion, which can discard large amounts of usable data and bias results
Imputation, which fabricates values that did not exist
Transposing, which swaps rows and columns
Correct answer: Listwise deletion, which can discard large amounts of usable data and bias results
Listwise deletion is the method, and its main risk is discarding large amounts of usable data and introducing bias, because dropping every row with any gap can shrink the sample and skew it if missingness is not random. Imputation fills gaps rather than deleting rows, so it is the alternative being contrasted, not what is described here.
What is imputation in data preparation?
Combining two datasets by matching keys
Reformatting dates into a standard pattern
Replacing missing values with substituted estimates such as the mean, median, mode, or a predicted value
Deleting all rows that contain any missing value
Correct answer: Replacing missing values with substituted estimates such as the mean, median, mode, or a predicted value
Replacing missing values with substituted estimates such as the mean, median, mode, or a predicted value is imputation, because imputation fills gaps so records can be retained for analysis. Deleting rows with gaps is listwise deletion, reformatting dates is a transformation, and matching keys to combine datasets is a join or merge.
An analyst compares listwise deletion with imputation for a dataset where about 30 percent of rows have a missing value in one column. Which consideration favors imputation in this scenario?
Imputation eliminates the need to profile the data first
Imputation preserves the sample size by filling gaps, whereas deleting 30 percent of rows would sharply reduce the data available
Listwise deletion always removes outliers as a side effect
Imputation guarantees the filled values are exactly correct
Correct answer: Imputation preserves the sample size by filling gaps, whereas deleting 30 percent of rows would sharply reduce the data available
Imputation preserves the sample size by filling gaps, whereas deleting 30 percent of rows would sharply reduce available data, which is the consideration favoring imputation here. Imputation estimates values and does not guarantee they are exactly correct, listwise deletion does not specifically target outliers, and profiling is still required either way.
In a sales dataset where most transactions fall between 50 and 500 dollars, one record shows 4,200,000 dollars and appears to be a data-entry error. What is this extreme value called?
An outlier
A specification mismatch
A null value
A duplicate
Correct answer: An outlier
An outlier is the term, because it is a value that lies far outside the typical range of the other observations and may signal an error or a genuine extreme. A duplicate is a repeated record, a null value is a missing entry, and a specification mismatch is a value violating a defined format rather than simply being extreme.
An analyst finds several extreme values in a dataset and is unsure whether they are errors or genuine. Which approach reflects sound handling of outliers?
Investigate the cause first, then decide whether to correct, keep, or exclude them based on whether they are errors or valid extremes
Always delete every outlier immediately to clean the data
Always keep every outlier because removing any value is never acceptable
Replace every outlier with zero so it has no effect
Correct answer: Investigate the cause first, then decide whether to correct, keep, or exclude them based on whether they are errors or valid extremes
Investigating the cause first and then deciding to correct, keep, or exclude based on whether the values are errors or valid extremes reflects sound handling. Outliers can be genuine signals or mistakes, so blanket deletion, blanket retention, or replacing them with zero all risk distorting the analysis instead of addressing the root cause.
What is data manipulation in the preparation stage?
Defining who may access a dataset and under what conditions
Changing the structure, content, or organization of data through operations such as filtering, sorting, aggregating, and reshaping
Selecting a chart that best tells the data story
Permanently encrypting fields to protect them
Correct answer: Changing the structure, content, or organization of data through operations such as filtering, sorting, aggregating, and reshaping
Changing the structure, content, or organization of data through operations such as filtering, sorting, aggregating, and reshaping is data manipulation, because manipulation reorganizes data to make it usable for analysis. Encryption is a security control, chart selection is visualization, and access definition is a governance function.
An analyst keeps only the rows where 'region' equals 'West' so the report focuses on western sales, removing all other rows from view. Which manipulation technique is this?
Transposing
Filtering
Parsing
Aggregating
Correct answer: Filtering
Filtering is the technique, because it returns only the rows that meet a specified condition, here 'region' equals 'West'. Aggregating summarizes groups of rows into totals or averages, transposing swaps rows and columns, and parsing breaks a value into components, none of which simply restrict rows by a condition.
What is data aggregation?
Splitting one column into several columns
Loading only changed rows into a warehouse
Replacing missing values with the median
Combining multiple records into summary values such as sums, counts, or averages grouped by a category
Correct answer: Combining multiple records into summary values such as sums, counts, or averages grouped by a category
Combining multiple records into summary values such as sums, counts, or averages grouped by a category is data aggregation, because aggregation rolls detailed rows up into grouped summaries (for example, total sales by region). Splitting a column is parsing, replacing missing values is imputation, and loading changed rows is a delta load.
A column contains full names stored as 'Last, First' in one string. The analyst splits each value into separate 'last_name' and 'first_name' fields by interpreting the comma delimiter. Which manipulation technique is this?
Parsing
Appending
Aggregating
Transposing
Correct answer: Parsing
Parsing is the technique, because it breaks a single value into meaningful components based on delimiters or patterns, here separating a combined name into two fields. Aggregating summarizes rows, transposing flips rows and columns, and appending adds rows from another dataset, none of which split a string into parts.
What does transposing data accomplish?
Filling missing values with an estimate
Switching the orientation of data so that rows become columns and columns become rows
Combining two tables on a shared key
Removing duplicate rows from a table
Correct answer: Switching the orientation of data so that rows become columns and columns become rows
Switching the orientation so that rows become columns and columns become rows is transposing, because it pivots the layout of a dataset to reshape it for a different analytical view. Removing duplicates is deduplication, combining tables on a key is a join or merge, and filling missing values is imputation.
A survey stored gender as 1, 2, and 3, but the analyst converts these codes into 'Female', 'Male', and 'Nonbinary' to make a report readable. Which manipulation technique is this?
Aggregating
Recoding
Web scraping
Filtering
Correct answer: Recoding
Recoding is the technique, because it transforms the values of a variable into different categories or labels, here mapping numeric codes to readable text. Aggregating summarizes data, filtering restricts rows, and web scraping is a collection method, none of which reassign or relabel a variable's values.
An analyst stacks December sales records onto the bottom of a table that already holds January through November sales, so all rows share the same columns. Which manipulation technique is this?
Joining on a key
Appending
Parsing
Transposing
Correct answer: Appending
Appending is the technique, because it adds rows from one dataset to the bottom of another that shares the same column structure. Joining on a key combines columns from two tables by matching values, transposing reshapes orientation, and parsing splits a value into components.
What is a dataset merge?
Reordering a table from highest to lowest value
Deleting all rows that contain missing values
Combining two or more datasets into a single dataset, typically by matching one or more common key fields
Converting numeric codes into text labels
Correct answer: Combining two or more datasets into a single dataset, typically by matching one or more common key fields
Combining two or more datasets into one, typically by matching common key fields, is a dataset merge, because merging joins related records across sources into a unified table. Deleting rows with missing values is listwise deletion, reordering is sorting, and converting codes to labels is recoding.
Two tables are merged so that the result keeps only the rows whose key exists in BOTH tables. Which join type is this?
Inner join
Right outer join
Left outer join
Full outer join
Correct answer: Inner join
An inner join keeps only rows whose key appears in both tables, returning matched records and discarding unmatched ones from either side. A left or right outer join keeps all rows from one side plus matches, and a full outer join keeps all rows from both sides, so none of those restrict the result to matches only.
An analyst wants a result that keeps every customer from the Customers table and attaches order details where they exist, leaving order fields blank for customers with no orders. Which join produces this?
Inner join
Cross join
Right outer join (Orders on the right)
Left outer join (Customers on the left)
Correct answer: Left outer join (Customers on the left)
A left outer join with Customers on the left keeps every row from the left table and attaches matching right-table rows, filling unmatched right fields with nulls. An inner join would drop customers without orders, a right outer join would keep all orders instead of all customers, and a cross join pairs every row with every other row.
What does a full outer join return when combining two tables?
Only rows from the left table
Every possible combination of rows from both tables
All rows from both tables, matching them where keys align and filling unmatched fields with nulls
Only rows whose keys exist in both tables
Correct answer: All rows from both tables, matching them where keys align and filling unmatched fields with nulls
A full outer join returns all rows from both tables, matching where keys align and filling unmatched fields with nulls, so no record from either side is lost. Returning only matched rows describes an inner join, only left rows describes a left join, and every possible combination describes a cross join.
What is database normalization?
Organizing tables and columns to reduce redundancy and improve data integrity, typically by splitting data into related tables
Combining many small tables into one wide table for faster reads
Scaling numeric values to a common range such as 0 to 1
Encrypting columns that contain personal information
Correct answer: Organizing tables and columns to reduce redundancy and improve data integrity, typically by splitting data into related tables
Organizing tables and columns to reduce redundancy and improve integrity by splitting data into related tables is database normalization, which applies normal-form rules so each fact is stored once. Scaling numeric values to a range is feature normalization in analysis, merging into a wide table is denormalization, and encrypting columns is a security control.
A reporting database is intentionally restructured to combine related tables into fewer, wider tables so that analysts can read it with fewer joins, accepting some redundancy for faster queries. Which design choice describes the difference being applied?
Denormalization, which trades redundancy for read performance, as opposed to normalization, which minimizes redundancy
Parsing, which splits combined fields into parts
Imputation, which fills in missing values
Normalization, which always speeds up reads by removing tables
Correct answer: Denormalization, which trades redundancy for read performance, as opposed to normalization, which minimizes redundancy
Denormalization is the choice, trading some redundancy for faster reads by combining tables, which contrasts with normalization's goal of minimizing redundancy through more, smaller related tables. Normalization typically increases the number of joins rather than removing tables to speed reads, and parsing and imputation are unrelated manipulation tasks.
A data analyst is summarizing weekly support-ticket counts for five weeks: 12, 19, 7, 23, and 15. The team lead asks for the range of the dataset. What value should the analyst report, and what does it represent?
16, the difference between the highest and lowest values
15.2, the arithmetic average of the values
7, the most frequently occurring value
15, the middle value of the sorted dataset
Correct answer: 16, the difference between the highest and lowest values
The range is 16, calculated as the maximum minus the minimum: 23 minus 7 equals 16. The range is the simplest measure of dispersion and shows the total spread between the largest and smallest observations. The value 15.2 is the mean (sum 576), and 15 is the median, but neither describes spread.
A retention analyst examines account tenures (in months) for five customers: 4, 4, 6, 8, and 18. Recognizing that the single 18-month account skews the average upward, which measure of central tendency best represents the typical customer's tenure, and what is its value?
The range, which is 14 months
The median, which is 6 months
The mode, which is 8 months
The mean, which is 8 months
Correct answer: The median, which is 6 months
The median, which is 6 months, best represents the typical value here because it is resistant to the outlier. With values sorted as 4, 4, 6, 8, 18, the middle value is 6. The mean is 8 (sum 540) but is pulled upward by the 18-month account, which is why the median is preferred for skewed data; the mode is 4 (the most frequent value), and the range measures spread rather than center.
While preparing a statistics summary, an analyst must explain how the mean, median, and mode differ to a non-technical stakeholder. Which description correctly distinguishes all three measures of central tendency?
The mean is the middle value, the median is the average, and the mode is the smallest value
The mean and median are always identical, and the mode is the largest value
The mean is the most frequent value, the median is the average, and the mode is the middle value
The mean is the arithmetic average, the median is the middle value of ordered data, and the mode is the most frequent value
Correct answer: The mean is the arithmetic average, the median is the middle value of ordered data, and the mode is the most frequent value
The correct distinction is that the mean is the arithmetic average (sum of values divided by the count), the median is the middle value when the data is ordered, and the mode is the value that occurs most often. These three are the standard measures of central tendency in descriptive statistics. The mean and median coincide only in a perfectly symmetric distribution, not always, which is why a separate definition for each matters when data is skewed.
An analyst reports that exam scores have a standard deviation of 6 points and notes that the variance is 36. A colleague asks how variance and standard deviation relate. Which explanation is correct?
Standard deviation is the average of the data, while variance measures the median spread
Variance and standard deviation are the same quantity expressed in different scales
Variance is the standard deviation, so it is always smaller
Variance is the average squared deviation from the mean, and the standard deviation is its square root in the original units
Correct answer: Variance is the average squared deviation from the mean, and the standard deviation is its square root in the original units
Variance is the average of the squared deviations from the mean, and the standard deviation is the variance, expressed in the same units as the original data. That is why a variance of 36 corresponds to a standard deviation of 6. Because variance is in squared units, the standard deviation is usually preferred for communication; the claim that variance is the standard deviation reverses the relationship.
A quality analyst observes a strong positive correlation between the number of ceiling fans sold and the number of heat-related illnesses in a city, both rising in summer. A manager wants to conclude that fan sales cause the illnesses. What is the most statistically sound response?
A strong positive correlation always indicates a direct causal link
Correlation does not imply causation; a third factor such as hot weather likely drives both
The illnesses must be causing the fan sales because correlation is bidirectional
The correlation proves fans cause illness because the relationship is strong
Correct answer: Correlation does not imply causation; a third factor such as hot weather likely drives both
The sound response is that correlation does not imply causation, and a confounding variable such as hot weather likely drives both fan sales and heat illnesses. A correlation only measures the strength and direction of association between two variables; it cannot establish that one causes the other. Concluding causation from correlation, even a strong one, is a classic analytical error because lurking variables and coincidence are not ruled out.
A team is deciding whether to use correlation analysis or regression analysis on two numeric variables. They want to predict monthly revenue from advertising spend, not merely measure association. Which statement correctly distinguishes the two techniques?
Correlation and regression are identical and produce the same output
Correlation predicts one variable from another, while regression only measures association strength
Correlation measures the strength and direction of association, while regression models how one variable changes as a predictor changes so values can be estimated
Regression can only be used on categorical data, while correlation requires numeric data
Correct answer: Correlation measures the strength and direction of association, while regression models how one variable changes as a predictor changes so values can be estimated
The correct distinction is that correlation measures the strength and direction of the linear association between two variables, while regression builds a model of how a dependent variable changes with a predictor so that values can be estimated or predicted. Because the team wants to predict revenue from spend, regression is the right choice. Correlation alone yields a coefficient but no predictive equation, so it cannot generate estimates.
After running a hypothesis test comparing two marketing campaigns, an analyst obtains a p-value of 0.02 against a preset significance level (alpha) of 0.05. How should the analyst interpret this result?
Because the p-value is less than alpha, fail to reject the null hypothesis; the result is not significant
The p-value of 0.02 means there is a 2 percent chance the null hypothesis is true
Alpha of 0.05 is the probability that the alternative hypothesis is correct
Because the p-value is less than alpha, reject the null hypothesis; the result is statistically significant
Correct answer: Because the p-value is less than alpha, reject the null hypothesis; the result is statistically significant
Because the p-value (0.02) is less than the chosen alpha (0.05), the analyst rejects the null hypothesis and concludes the result is statistically significant. Alpha is the significance level set in advance, representing the acceptable probability of a Type I error (rejecting a true null hypothesis). The p-value is the probability of observing results at least as extreme as those seen if the null were true; it is not the probability that the null hypothesis itself is true.
A retail operations team asks an analyst to build a single screen that consolidates daily sales, inventory turnover, and customer satisfaction so managers can monitor performance at a glance. What is the analyst being asked to build?
A data dictionary
A pivot index
A dashboard
A schema diagram
Correct answer: A dashboard
A dashboard is the correct answer. In data analytics a dashboard is a single visual interface that consolidates multiple metrics, charts, and key indicators so users can monitor performance at a glance without running separate reports. A data dictionary documents data elements rather than displaying performance, so it does not fit the at-a-glance monitoring purpose.
An analyst wants to highlight a metric such as monthly recurring revenue that the business has identified as critical to its strategic goals. Which term describes this type of measurable value used to gauge progress toward a business objective?
A primary key
A confidence interval
A data mart
A key performance indicator (KPI)
Correct answer: A key performance indicator (KPI)
A key performance indicator (KPI) is the correct answer. In data analytics a KPI is a measurable value that shows how effectively an organization is progressing toward a specific business objective, such as monthly recurring revenue or customer churn. A primary key is a database field that uniquely identifies a record, which is unrelated to measuring business performance.
A finance director needs a report that refreshes automatically and lets viewers filter by region and drill into individual transactions while viewing it. Which report or dashboard type best meets this need?
A dynamic dashboard
A static PDF report
An ad-hoc memo
A printed recurring report
Correct answer: A dynamic dashboard
A dynamic dashboard is the correct answer. A dynamic dashboard connects to live or refreshing data and allows interactivity such as filtering and drill-down, whereas a static report or dashboard is a fixed snapshot that cannot be filtered or drilled into after it is produced. The viewer interactivity and automatic refresh requirements point to the dynamic option rather than the fixed static one.
An executive requests a visualization that shows a single current value, such as this quarter's customer satisfaction score, relative to a target range using a needle or arc display. Which chart type is most appropriate?
A box plot
A gauge chart
A scatter plot
A histogram
Correct answer: A gauge chart
A gauge chart is the correct answer. A gauge chart displays a single value against a defined scale or target range using a needle or colored arc, making it well suited for showing one KPI relative to a goal. A scatter plot shows the relationship between two variables and cannot convey a single value against a target the way a gauge does.
An analyst exports raw sales records into a tool and creates a summary that groups revenue by region in rows and by product category in columns, with totals at the intersections. What feature is the analyst using?
A funnel chart
A pivot table
A control chart
A choropleth map
Correct answer: A pivot table
A pivot table is the correct answer. A pivot table is an interactive summarization tool that reorganizes and aggregates raw records by dragging fields into rows, columns, and value areas to produce cross-tabulated totals. A choropleth map shades geographic regions by value and cannot cross-tabulate two categorical dimensions into a summary grid the way a pivot table does.
A marketing manager occasionally needs a one-off answer to an unplanned question, such as which campaign drove sign-ups during a single unexpected traffic spike. Which report type best describes this request?
An ad-hoc report
A recurring report
A compliance report
A self-service dashboard
Correct answer: An ad-hoc report
An ad-hoc report is the correct answer. An ad-hoc report is created on demand to answer a specific, one-time question that is not part of a regular reporting schedule. A recurring report runs on a fixed cadence such as weekly or monthly, which does not match a single unplanned request.
A business intelligence team wants non-technical staff to build their own filtered views and simple charts without submitting requests to the analytics team. Which reporting approach are they enabling?
Static snapshot reporting
Compliance reporting
Tactical research reporting
Self-service reporting
Correct answer: Self-service reporting
Self-service reporting is the correct answer. Self-service reporting gives business users governed access to data and tools so they can build and filter their own reports without depending on the analytics team for each request. Compliance reporting is produced specifically to satisfy regulatory or audit requirements and is not about empowering end users to self-serve.
An analyst is choosing between a bar chart and a histogram for two different tasks. Which statement correctly describes when to use each?
Use a bar chart to compare values across distinct categories and a histogram to show the frequency distribution of a continuous variable across bins
Use both interchangeably because they display the same kind of data
Use a histogram to compare distinct categories and a bar chart to show distribution
Use a bar chart for continuous data and a histogram for categorical data
Correct answer: Use a bar chart to compare values across distinct categories and a histogram to show the frequency distribution of a continuous variable across bins
Using a bar chart for distinct categories and a histogram for a binned continuous distribution is the correct answer. Bar charts compare separate categories and typically have gaps between bars, while histograms group a continuous variable into ranges and the bars touch to show how values are distributed. Treating the two as interchangeable is wrong because they answer different questions: comparison versus distribution.
A senior analyst reviews a colleague's quarterly revenue chart and notes that the vertical axis starts at 90 rather than 0, making a small increase look dramatic. According to reporting best practices, what is the main concern?
The chart is fine because the data values are unchanged
A truncated axis can mislead viewers by exaggerating differences
Truncating the axis improves accuracy and should always be done
Starting the axis at 90 is required for revenue charts
Correct answer: A truncated axis can mislead viewers by exaggerating differences
A truncated axis misleading viewers by exaggerating differences is the correct answer. Reporting best practices warn that starting a value axis above zero on a bar or area chart can visually inflate small changes and distort the story the data tells. The data values themselves are unchanged, but the visual proportions misrepresent the magnitude of the difference, which is exactly why this is a concern.
An analyst is preparing a presentation that walks executives from a problem, through key findings, to a clear recommendation using a logical sequence of visuals and narration. What practice is the analyst applying?
Running a hypothesis test
Performing schema normalization
Telling a data story
Building a data lake
Correct answer: Telling a data story
Telling a data story is the correct answer. Data storytelling structures findings into a narrative with context, insight, and a recommendation so an audience can follow and act on the analysis, rather than simply presenting disconnected charts. Schema normalization is a database design activity and has nothing to do with communicating insights to stakeholders.
When designing a dashboard, an analyst places the most important summary KPIs in the top-left area and supporting detail lower on the page. What dashboard design principle is being followed?
Maximizing the number of charts per screen
Hiding the most important metrics to reduce clutter
Using as many colors as possible for variety
Arranging content by visual hierarchy and reading order
Correct answer: Arranging content by visual hierarchy and reading order
Arranging content by visual hierarchy and reading order is the correct answer. Effective dashboard design places the highest-priority metrics where the eye lands first, typically the top-left in left-to-right reading cultures, and arranges supporting detail below. Maximizing charts per screen works against this principle because clutter reduces clarity and slows comprehension.
A compliance team requires a report delivered every month in an identical format showing required regulatory metrics, with no interactive elements. Which report type best fits this requirement?
An ad-hoc report
A self-service dashboard
A recurring report
An exploratory analysis
Correct answer: A recurring report
A recurring report is the correct answer. A recurring report is generated on a fixed schedule in a consistent format, which suits regulatory and operational needs that repeat predictably. An ad-hoc report is produced once for a specific unplanned question and would not satisfy a standing monthly requirement.
An analyst must choose colors for a dashboard that will be viewed by an audience that includes colorblind users. Which design choice best supports accessibility?
Rely only on color hue to distinguish every category
Use red and green together to indicate good and bad values
Remove all text labels to keep the design minimal
Use colorblind-safe palettes and add labels or patterns so meaning does not rely on color alone
Correct answer: Use colorblind-safe palettes and add labels or patterns so meaning does not rely on color alone
Using colorblind-safe palettes with labels or patterns is the correct answer. Accessible reporting ensures meaning is not conveyed by color alone, so adding direct labels, patterns, or distinguishable palettes lets all viewers interpret the data. Relying on red and green together is a common pitfall because those hues are the hardest for many colorblind users to tell apart.
An analyst builds a dashboard that pulls from an operational database and needs to decide how often the underlying data should update so users see timely numbers without overloading the source system. Which design component is being decided?
The chart color palette
The axis label font
The report file format
The data refresh rate (refresh interval)
Correct answer: The data refresh rate (refresh interval)
The data refresh rate is the correct answer. Defining the refresh interval is a core dashboard design decision that balances data timeliness against the load placed on the source system. Choosing a color palette or font affects appearance but does not determine how current the displayed data is, which is the issue described.
Before building any visualization, an analyst meets with stakeholders to clarify what decisions the report must support and which metrics matter to them. Why is this step considered a reporting best practice?
It replaces the need to choose an appropriate visualization
It guarantees the chosen chart type will always be a pie chart
It eliminates the need to validate data quality
Translating business requirements first ensures the report answers the right questions for its audience
Correct answer: Translating business requirements first ensures the report answers the right questions for its audience
Translating business requirements first is the correct answer. Gathering stakeholder needs up front ensures the report is built around the decisions and metrics that matter to the audience, preventing rework and irrelevant visuals. It does not remove the separate obligations to validate data quality or to select an appropriate visualization, both of which still apply.
A data analyst profiles a customer table and finds that 4,000 of 50,000 rows are missing an email address. The analyst is asked to report which data quality dimension this gap most directly measures. Which dimension is it?
Completeness
Validity
Timeliness
Uniqueness
Correct answer: Completeness
Completeness is the dimension measured here, because completeness describes whether all required values are present and is typically scored as the percentage of non-null values; 4,000 missing emails out of 50,000 is a 92 percent completeness rate for that field. Validity asks whether present values conform to a defined format or rule, and uniqueness asks whether duplicate records exist, neither of which is about absent values. Among the recognized data quality dimensions of accuracy, completeness, consistency, timeliness, validity, and uniqueness, only completeness directly quantifies missing data.
During a data governance review, a customer's birth year is stored as 1990 in the CRM but as 1992 in the billing system for the same person. Which data quality dimension does this conflict most directly violate?
Completeness
Validity
Accuracy
Consistency
Correct answer: Consistency
Consistency is the dimension violated, because consistency means the same data value matches across all systems and records where it appears; two systems holding different birth years for one customer is a textbook consistency failure. Completeness concerns missing values, not conflicting ones, and validity concerns conformance to format rules rather than agreement between systems. The fact that both values follow a correct four-digit year format is exactly why this is a consistency problem and not a validity problem.
A marketing dataset contains the columns full name, home address, Social Security number, and email address. A data analyst must flag which fields qualify as personally identifiable information (PII) for governance purposes. Which statement best describes PII?
Any data that has been aggregated so individuals can no longer be distinguished
Only government-issued identifiers such as Social Security or passport numbers
Only health-related information held by a covered healthcare entity
Any information that can identify a specific individual, either on its own or when combined with other data
Correct answer: Any information that can identify a specific individual, either on its own or when combined with other data
PII is any information that can identify a specific individual, either directly or when combined with other available data, so name, home address, Social Security number, and email can all be PII. Limiting PII to government identifiers is too narrow, because quasi-identifiers like address and email also count when they can single someone out. Health information held by a covered entity is the narrower category of protected health information under HIPAA, and aggregated data that no longer distinguishes individuals is, by definition, no longer PII.
A healthcare analytics team wants to share a patient dataset with an external research vendor but must remove the ability to re-identify individuals permanently, with no key kept to reverse the process. Which de-identification technique fits this requirement?
Anonymization
Pseudonymization
Encryption
Role-based access control
Correct answer: Anonymization
Anonymization fits, because anonymization irreversibly strips identifying information so that the data can no longer be traced back to an individual and no reversal key is retained. Pseudonymization replaces identifiers with tokens but keeps a separate mapping that allows re-identification, so it is reversible and does not meet a permanent-removal requirement. Encryption protects data in transit or at rest but is reversible with the key, and role-based access control restricts who can view data rather than altering the data's identifiability.
An organization processes the personal data of customers located in the European Union. Under the GDPR principle of data minimization, what should the organization do?
Store all personal data indefinitely to support historical reporting
Collect as much personal data as possible so it is available for future analysis
Encrypt all collected data so any amount of collection is permitted
Collect and retain only the personal data that is necessary for the specified processing purpose
Correct answer: Collect and retain only the personal data that is necessary for the specified processing purpose
Collecting and retaining only the personal data necessary for the stated purpose is the GDPR data minimization principle, which limits processing to what is adequate, relevant, and limited to what is necessary. Gathering as much data as possible for unspecified future use directly contradicts minimization, and storing data indefinitely conflicts with the related storage-limitation principle. Encryption is a security safeguard that protects data but does not authorize collecting more than is necessary, so it cannot substitute for minimization.
A new analyst asks how data governance differs from data management on their team. Which statement best captures the distinction?
Governance and data management are interchangeable terms for the same set of activities
Governance is the hands-on work of building pipelines, while management only writes policy documents
Governance defines the policies, roles, and decision rights for data, while management is the day-to-day execution of collecting, storing, and processing that data
Governance applies only to external regulators, while management applies only inside the company
Correct answer: Governance defines the policies, roles, and decision rights for data, while management is the day-to-day execution of collecting, storing, and processing that data
The accurate distinction is that data governance sets the policies, accountability, roles, and decision rights that say how data should be handled, while data management is the operational, day-to-day work of collecting, storing, integrating, and processing data according to those rules. Treating the two as interchangeable misses that governance is the oversight layer and management is the execution layer. The reversed description that puts pipeline-building under governance and policy-writing under management inverts the two, and governance is not limited to regulators since it is primarily an internal accountability framework.
Before loading a web sign-up file into the customer database, an analyst configures a rule that rejects any record whose email field does not match a valid email pattern and whose age field is not a number between 0 and 120. This screening of incoming values against defined rules is best described as which activity?
Data classification
Data validation
Data lineage tracking
Master data management
Correct answer: Data validation
This is data validation, because data validation checks incoming or stored values against defined rules, formats, and ranges, such as a valid email pattern or an age within an acceptable range, to catch errors before bad data enters a system. Data lineage tracking documents where data came from and how it moved and transformed, not whether individual values are correct. Data classification labels data by sensitivity, and master data management maintains a single trusted version of core entities, so neither performs the per-value rule checking described here.
A governance team maps the stages that a dataset moves through, from initial creation, to storage, active use, archival, and finally secure destruction. What is this end-to-end sequence of stages called?
A data dictionary
Data lineage
Data normalization
The data lifecycle
Correct answer: The data lifecycle
This end-to-end sequence is the data lifecycle, which describes the stages data passes through from creation and storage, through active use and sharing, to archival and eventual destruction, and it shapes governance decisions like retention and disposal at each stage. Data lineage instead traces the origin and transformation path of specific data as it flows between systems rather than naming its overall life stages. A data dictionary documents the meaning and structure of fields, and data normalization is a database-design technique to reduce redundancy, so neither describes the create-to-destroy sequence.
To find us again, just search “Career Employer CompTIA Data+”
What is the purpose of using a scatter plot in data analysis?
Pick an answer to see the explanation
Click Start Test above to launch a full-length CompTIA Data+ practice test weighted exactly like the real DA0-002 exam, or drill a single domain — Data Concepts & Environments, Data Acquisition & Preparation, Data Analysis, Visualization & Reporting, or Data Governance. Every question includes a clear explanation so you learn the reasoning, not just the answer.
CompTIA Data+ — current exam code DA0-002 (V2) — is an early-career data analytics certification that validates your ability to turn raw data into actionable business insight.[1] These free CompTIA Data+ practice questions mirror the current 2026 content outline so you practice the way the real exam is built.[3] Pair these with our free study guide, flashcards.
CompTIA Data+ is one of the 14 CompTIA certifications — explore all our CompTIA practice tests to compare and prep across the whole family.
CompTIA Data+ at a Glance
CompTIA Data+ (DA0-002) at a glance
Detail
CompTIA Data+ (DA0-002)
Number of questions
Maximum of 90
Time limit
90 minutes
Question types
Multiple-choice and performance-based (PBQs)
Passing score
675 on a scale of 100-900
Administered by
Pearson VUE (in-person test center or OnVUE online proctored)
Recommended experience
18-24 months in a data analyst or similar role
Exam cost
~255USD(voucher;304 with retake assurance)
Recertification
Valid 3 years; renew with 30 CEUs
What Is on the CompTIA Data+ Exam?
The CompTIA Data+ DA0-002 (V2) exam covers five domains: Data Concepts & Environments (20%), Data Acquisition & Preparation (22%), Data Analysis (24%), Visualization & Reporting (20%), and Data Governance (14%).[1]
Data Analysis carries the most weight, and the V2 blueprint rebalanced the older DA0-001 split — renaming Data Mining to Data Acquisition & Preparation and broadening Visualization to Visualization & Reporting.[2] Our full practice test is weighted to match:
CompTIA Data+ weighting by domain (DA0-002)
Data Analysis24% · ≈16 Qs
Data Acquisition & Preparation22% · ≈14 Qs
Data Concepts & Environments20% · ≈13 Qs
Visualization & Reporting20% · ≈13 Qs
Data Governance, Quality & Controls14% · ≈9 Qs
Practice Questions by Domain
Use Start Test for a full weighted DA0-002 simulation, or open the hub and pick a single domain to drill your weak area. After each full exam, your results show a per-domain breakdown so you know exactly where to focus — most candidates need the most reps on Data Analysis and the statistics-heavy topics.
What Are the Requirements to Take CompTIA Data+?
CompTIA Data+ has no mandatory prerequisites — anyone can register. CompTIA recommends 18-24 months of experience in a data analyst or similar role, with exposure to databases and analytical tools, a basic understanding of statistics, and hands-on data visualization experience.[3] Earning CompTIA Tech+ or A+ first can help build foundational IT knowledge, but neither is required.
How Do You Register for the CompTIA Data+ Exam?
You register for CompTIA Data+ by purchasing an exam voucher from the CompTIA Store or an authorized reseller, then scheduling your exam through Pearson VUE.[1] You can test in person at a Pearson VUE test center or remotely via OnVUE online proctoring from home.
Online testing requires a webcam, microphone, stable internet, a clean private workspace, and a valid government-issued ID for check-in. Have your voucher number ready when you book.
What Is the Passing Score for CompTIA Data+?
The passing score for CompTIA Data+ is 675 on a scale of 100 to 900.[1] Scores use a weighted, scaled model rather than a simple percentage correct, so not every question carries equal weight.
Performance-based questions (PBQs) typically appear first and can be worth more than standard multiple-choice items. You receive a pass/fail result immediately at the end of your session, along with a score report.
How Hard Is CompTIA Data+? (Pass Rate)
CompTIA does not publish official pass rates for Data+, but industry estimates put the first-attempt pass rate near 70-85%.[4] Most of the challenge comes from the breadth of topics across five domains and from the performance-based questions, rather than from extreme technical depth — candidates often find statistics, data-mining concepts, and visualization best-practice questions the trickiest.
~70-85%
Estimated pass rate
no official figure published
675
Passing scaled score
of 100-900
24%
Data Analysis domain
largest section
The takeaway: drill until you’re consistently scoring above target on full-length practice — especially Data Analysis and statistics — before you book your exam date.
What to Expect on Exam Day
Arrive at your Pearson VUE test center at least 15 minutes early to check in — bring a valid, unexpired government-issued photo ID whose name matches your registration.[1] You’ll store phones and personal items in a locker; no notes are allowed.
A short tutorial precedes the exam, then you have 90 minutes to answer up to 90 multiple-choice and performance-based questions, with PBQs typically appearing first. If you test via OnVUE online proctoring, expect a clean private room, a webcam check, and an ID scan.
You receive a pass/fail result immediately, and CompTIA posts your score report to your account. Having simulated the full timing with practice tests makes that clock feel routine.
How to Use This CompTIA Data+ Practice Test
Recreate exam conditions. Take the full test timed, with no notes.[4]
Diagnose, then drill. Use a full DA0-002 simulation to find weak domains, then drill them.
Prioritize Data Analysis + statistics. They’re the biggest score-movers.
Learn the why. Read every explanation — understanding beats memorizing.
Answer everything. There’s no guessing penalty, so never leave a question blank.
Why Get CompTIA Data+ Certified?
CompTIA Data+ is a vendor-neutral credential that proves you can mine and prepare data, run descriptive and exploratory analysis, build clear visualizations, and apply governance and quality controls — exactly the skills employers want in early-career data analysts.[3] These free CompTIA Data+ practice tests are the most efficient way to get there.
Conclusion
Passing the DA0-002 exam comes down to knowing data concepts, analysis, visualization, and governance cold. Use this free CompTIA Data+ practice test to find your weak domains, drill them to mastery, and walk in confident on test day — and round out your prep with our free study guide, flashcards.
CompTIA Data+ Practice Test FAQ
DA0-002 (V2) is the current version. It launched October 14, 2025. The older DA0-001 (V1) retired in English on April 14, 2026 (with Japanese and Thai versions available until July 16, 2026). If you are testing now, you will take DA0-002, which has updated content on cloud data environments, AI, governance, and modern visualization.
The passing score for CompTIA Data+ is a scaled score of 675 on a 100-900 scale. The exam uses weighted scoring, so this does not map to a fixed percentage of questions correct. You get your pass/fail result immediately after finishing.
The exam has a maximum of 90 questions, a mix of multiple-choice and performance-based questions (PBQs), and you have 90 minutes to complete it.
Data Concepts and Environments (20%), Data Acquisition and Preparation (22%), Data Analysis (24%), Visualization and Reporting (20%), and Data Governance (14%). Data Analysis carries the most weight on the current exam.
There are no required prerequisites. CompTIA recommends 18-24 months in a data analyst or similar role, with exposure to databases, analytical tools, basic statistics, and data visualization. Anyone can register, but the recommended experience makes the exam significantly more manageable.
An exam voucher is about $255 USD (around $304 with retake assurance) as of the DA0-002 launch; check the CompTIA Store for current pricing. The certification is valid for three years and can be renewed by earning 30 continuing education units (CEUs) or by passing a higher-level CompTIA exam.
There is no waiting period before your second attempt — you can retake the exam as soon as you're ready. From the third attempt onward, CompTIA requires you to wait at least 14 calendar days between tries. Each attempt requires a separate voucher, so a retake-assurance voucher can save money if you're unsure.
No — it is a closed-book, proctored exam with no notes or external references allowed. The Pearson VUE software provides an on-screen calculator, and performance-based questions present simulated tools within the exam interface. Whether you test at a center or via OnVUE, your workspace must be clear.
Career Employer is the ultimate resource to help you get started working the job of your dreams. We cover topics from general career information, career searching, exam preparation with free study materials, career interviewing, and becoming successful in your career of choice.
Here at Career Employer, we focus a lot on providing factually accurate information that is always up to date. We strive to provide correct information using strict editorial processes, article editing, and fact-checking for all of the information found on our website. We only utilize trustworthy and relevant resources. To find out more, make sure to read our full editorial process page here.
