Free CompTIA Data+ Practice Test (DA0-001) 2026

Right answer (B): That's correct! Structured data is organized into a predefined schema with rows and columns in a relational database, making it easy to query and analyze.

Wrong answers:

• A): Unstructured data lacks a predefined format and includes items like images, videos, and free-form text documents.
• C): Semi-structured data has some organizational properties like tags or markers (JSON, XML) but does not fit neatly into relational tables.
• D): Qualitative data describes qualities or characteristics rather than referring to the organizational format of the data itself.

Right answer (C): That's correct! A foreign key is a column in one table that references the primary key in another table, establishing a relationship that links records across tables.

Wrong answers:

• A): An index improves query performance by creating a sorted lookup structure but does not define relationships between tables.
• B): A view is a virtual table created from a saved SQL query that presents data from one or more tables without storing it separately.
• D): A stored procedure is a precompiled set of SQL statements saved in the database for reuse, not a mechanism for linking tables.

Right answer (A): That's correct! Extract is the first phase of ETL where data is pulled from source systems such as databases, APIs, flat files, or cloud services into a staging area.

Wrong answers:

• B): Evaluate is not part of the ETL acronym, although data quality checks may occur during the transformation phase.
• C): Encrypt refers to securing data using cryptographic algorithms and is a security measure rather than a data pipeline step.
• D): Export describes sending data out of a system and is the opposite direction of what extraction accomplishes in the ETL workflow.

Right answer (D): That's correct! Data cleaning involves identifying and correcting errors such as duplicate records, missing values, inconsistent formats, and invalid entries to improve data quality.

Wrong answers:

• A): Data visualization presents data graphically and is used after cleaning to communicate findings, not to fix data quality issues.
• B): Data aggregation combines multiple data points into summary statistics like totals or averages but does not address duplicates or missing values.
• C): Data partitioning splits datasets into subsets for processing or analysis but does not resolve underlying quality problems in the data.

Right answer (B): That's correct! Regression analysis models the relationship between a dependent variable (revenue) and one or more independent variables (advertising spend) to quantify their correlation.

Wrong answers:

• A): Frequency distribution shows how often each value appears in a dataset but cannot measure the relationship between two different variables.
• C): Time series decomposition breaks data into trend, seasonal, and residual components over time but is not designed for measuring cause-effect relationships.
• D): Cluster analysis groups similar data points together based on characteristics but does not quantify the strength of a relationship between specific variables.

Right answer (C): That's correct! When the mean is significantly higher than the median, outliers on the high end pull the average up, indicating a right-skewed (positively skewed) distribution.

Wrong answers:

• A): A normal distribution has the mean, median, and mode approximately equal with a symmetric bell curve shape.
• B): A left-skewed distribution would show the mean lower than the median because outliers on the low end pull the average down.
• D): A bimodal distribution has two peaks but does not necessarily cause the mean to exceed the median in a predictable direction.

Right answer (A): That's correct! A pie chart displays proportional parts of a whole, making it ideal for showing percentage breakdowns of categories that sum to 100%.

Wrong answers:

• B): A scatter plot shows the relationship between two continuous variables using data points on an x-y axis, not category proportions.
• C): A histogram displays the frequency distribution of a single continuous variable across bins, not categorical percentage breakdowns.
• D): A line chart shows trends over time by connecting sequential data points and is not designed for showing proportional category splits.

Right answer (D): That's correct! A dynamic dashboard with a live data connection refreshes automatically when underlying data changes, providing real-time insights without manual intervention.

Wrong answers:

• A): A static PDF report is a fixed snapshot that requires manual regeneration each time data changes.
• B): A printed spreadsheet captures data at one point in time and cannot update itself as new records are entered.
• C): A one-time email summary delivers information once and does not refresh or update with subsequent data entries.

Right answer (B): That's correct! Data privacy and compliance policies define how personal data is collected, stored, processed, and shared in accordance with regulations like GDPR, CCPA, and HIPAA.

Wrong answers:

• A): Data warehousing is a storage architecture for consolidating data from multiple sources for analysis, not a governance or compliance practice.
• C): Data visualization standards govern how charts and dashboards are designed for clarity, not how personal data is legally handled.
• D): Data compression algorithms reduce file sizes for storage efficiency and have no bearing on regulatory compliance or privacy requirements.

Right answer (C): That's correct! Role-based access control restricts system access by assigning permissions based on user roles, ensuring individuals can only view or modify data relevant to their job functions.

Wrong answers:

• A): Improving query performance involves indexing, caching, and query optimization techniques that are unrelated to access control mechanisms.
• B): Automating data backups is a disaster recovery practice managed by backup scheduling tools, not access control policies.
• D): Normalizing database tables is a schema design technique that reduces data redundancy and has nothing to do with controlling who can access the data.