Free CompTIA Data+Practice Test

A data analyst is working with a dataset containing customer information from multiple sources. Some records use 'M' and 'F' for gender, while others use 'Male' and 'Female'. What data quality dimension is primarily affected?

Which of the following best describes structured data?

A data analyst needs to extract data from a REST API that returns information in JSON format. Which data mining technique is being used?

When creating a dashboard for executive stakeholders, which visualization type is MOST appropriate for showing the overall progress toward quarterly sales targets?

A dataset contains 1,000 records. After applying a filter, only 250 records remain. What is the sampling method being used?

A company is analyzing website traffic data and notices that the mean session duration is 8 minutes, but the median is only 3 minutes. What does this indicate about the data distribution?

A data analyst is working with a SQL database and needs to combine customer data from one table with order data from another table, keeping all customers even if they haven't placed orders. Which SQL JOIN operation should be used?

An organization wants to implement role-based access control (RBAC) for their data warehouse. What is the PRIMARY benefit of this approach?

A data analyst is creating a visualization to show the relationship between advertising spend and sales revenue across 50 different campaigns. Which chart type would be MOST effective?

During data profiling, an analyst discovers that a column containing product prices has 15% NULL values. Which data quality issue should be addressed FIRST?

A company stores transactional data in a relational database optimized for daily operations (OLTP). They want to analyze historical trends across multiple years. What type of system should they implement?

An analyst is performing exploratory data analysis on customer age data and calculates the following: Q1=25, Q2=35, Q3=50. A customer aged 95 appears in the dataset. Using the IQR method (1.5 × IQR), is this an outlier?

A marketing team wants to visualize customer segments based on annual income and purchase frequency. They have identified 5 distinct segments. Which visualization would BEST communicate these segments?

A data analyst needs to remove duplicate records from a dataset where duplicates are defined as records with the same customer ID and transaction date, but they want to keep the record with the highest transaction amount. What process is this?

When presenting analysis results, an analyst uses a heat map to show sales performance across different regions and product categories. Several cells appear in dark red. What does this typically indicate in a standard heat map color scheme?

A healthcare organization must ensure that patient data analysis complies with regulatory requirements, including data anonymization before sharing with research partners. Which data governance component is MOST critical in this scenario?

An e-commerce company is analyzing customer behavior and wants to predict which customers are likely to churn. They have historical data including purchase frequency, average order value, customer service interactions, and account age. Which type of analysis should they perform?

A data team is implementing a dimensional model for their data warehouse with a central fact table containing sales transactions and multiple dimension tables for products, customers, time, and stores. What schema design pattern is being used?

A data analyst is extracting data from multiple CSV files with inconsistent date formats: some use 'MM/DD/YYYY', others use 'DD-MM-YYYY', and some use 'YYYY-MM-DD'. Before loading this data into the warehouse, which ETL step is MOST critical to implement?

A financial services company performs a correlation analysis between various economic indicators and stock performance. They find a correlation coefficient of -0.85 between unemployment rates and market returns. What should the analyst conclude?