Step2Study

CompTIA Data+ (DA0-002) practice questions

230 free questions with answers and explanations.

Practice test
  1. 1.A data team is migrating historical sales data from an old, disparate system into a new data warehouse. The old system has multiple tables with slightly different schemas and naming conventions for customer information (e.g., 'Cust_ID' in one table, 'CustomerID' in another). Before loading, they need to ensure that the customer data from all sources maps correctly to the unified 'CustomerID' and 'CustomerName' columns in the new warehouse. Which step of the ETL process is primarily concerned with reconciling these schema differences and preparing data for the target format?Data Mining
  2. 2.A quality control manager is monitoring the weight of cereal boxes coming off an assembly line. The target weight is 500 grams. To determine if the average weight of the boxes is significantly different from the target weight, which type of hypothesis test should be conducted?Data Analysis
  3. 3.A data quality analyst is reviewing a dataset of product IDs where each ID is expected to be a 6-character alphanumeric string, always starting with 'PROD' followed by two digits. They find entries like 'PROD1A', 'PROD_05', and 'PRODUCT12'. To identify and flag these non-conforming entries, which SQL technique is most effective?Data Mining
  4. 4.A data analyst is designing a dashboard for a customer support team. The dashboard needs to clearly display the average response time, resolution time, and customer satisfaction score. Each metric has a specific target, and the team needs to see at a glance if they are meeting or missing these targets, along with the current value. Given limited dashboard space, which design principle is MOST important to ensure quick comprehension of these three key metrics and their target status?Visualization
  5. 5.A data scientist is preparing a presentation for executive leadership to explain the results of a complex machine learning model that predicts customer churn. The executives are highly engaged but have limited technical knowledge. Which storytelling technique should the data scientist prioritize to ensure the presentation is impactful and understandable?Visualization
  6. 6.A master data management (MDM) system is consolidating customer records from five source systems. A unique identifier such as a national ID number is not consistently available across sources, so the system calculates a similarity score by comparing name, address, phone number, and date of birth across records to estimate the likelihood that two records represent the same customer. Which record matching technique is being used?Data Governance, Quality and Controls
  7. 7.A data team is setting up a new data acquisition process for customer feedback forms. The forms are submitted through a web portal, generating JSON payloads. The team needs to ensure that, before any transformations or loading, the incoming JSON data consistently adheres to a predefined structure, including specific fields and data types. Which data acquisition step is primarily focused on verifying this structural consistency?Data Mining
  8. 8.A data analyst is working with a dataset containing customer feedback. Each entry includes a unique ID, the date of feedback submission, and a free-text comment describing the customer's experience. Which of the following best describes the data type of the 'free-text comment' field?Data Concepts and Environments
  9. 9.A data analyst is performing a complex query on a database with two tables: `Employees (emp_id, emp_name, dept_id)` and `Departments (dept_id, dept_name, location)`. The analyst needs to retrieve the names of all employees and their respective department names, including employees who are not currently assigned to any department (i.e., `dept_id` is NULL in the `Employees` table) and departments that currently have no employees. Which SQL join type is necessary to satisfy these requirements?Data Mining
  10. 10.A data analyst reviews a customer table and finds that every phone number field contains exactly 10 digits with no letters or special characters, matching the required format for that field. Which data quality dimension does this satisfy?Data Governance, Quality and Controls
  11. 11.A marketing team is analyzing the effectiveness of different advertising channels (e.g., social media, email, print) in generating leads. They want to see the proportion of leads each channel contributes to the total over the last quarter, specifically for each of their three main product lines. The visualization should allow for easy comparison of channel effectiveness across product lines. Which chart type is MOST suitable?Visualization
  12. 12.A data analyst is creating a dashboard to monitor the performance of a company's marketing campaigns across various channels (e.g., social media, email, paid search). The dashboard needs to show the total budget allocated to each channel and the corresponding number of leads generated, with a clear comparison of both metrics for each channel. Which chart type is BEST suited for this visualization?Visualization
  13. 13.A data analyst is tasked with visualizing the distribution of customer ages within different demographic segments. The goal is to identify if certain age groups are more prevalent in specific segments and to observe the shape of these distributions. Which of the following chart types would be MOST effective for this analysis?Visualization
  14. 14.A data analyst is preparing a report to visualize the sales performance of different product categories across various regions. The analyst needs to quickly identify top-performing categories within each region and allow for easy comparison. Which chart type is MOST appropriate for this scenario?Visualization
  15. 15.A data analyst is developing an internal dashboard for a software development team to track the progress of various features. The dashboard needs to clearly show the current status of each feature (e.g., 'To Do', 'In Progress', 'Testing', 'Done') and the lead developer assigned to it. The team lead needs to quickly identify bottlenecks and ensure workload distribution. Which visualization type is MOST effective for this scenario?Visualization
  16. 16.A business analyst is reviewing historical sales data to understand the long-term patterns and make future predictions. They observe that sales have been steadily increasing over the past five years, despite some seasonal fluctuations. To identify and quantify this underlying, consistent upward movement in sales, what aspect of trend analysis should they focus on?Data Analysis
  17. 17.A data analyst is examining a dataset of monthly sales figures for a retail company. They observe a general upward trend over several years, but also notice consistent peaks during holiday seasons and dips during off-peak months. Which component of time series data is primarily represented by the consistent peaks and dips occurring at regular intervals?Data Analysis
  18. 18.A data analyst is preparing a visualization for a diverse audience, ranging from technical experts to non-technical business executives. The visualization needs to present complex statistical analysis results in a way that provides detailed information for the experts but also a clear, concise summary for the executives. Which design principle, if implemented effectively, would BEST address the needs of this mixed audience?Visualization
  19. 19.A data governance committee is establishing policies for data acquisition from external vendors. They are particularly concerned about ensuring the data received is accurate, reliable, and adheres to privacy regulations. Which of the following aspects is MOST critical to address during the data acquisition phase to mitigate risks related to data quality and compliance?Data Mining
  20. 20.A data analyst is creating a dashboard to monitor website traffic and user engagement. One key requirement is to show the geographical distribution of website visitors, highlighting which countries contribute the most traffic, and also to visualize the average session duration for each country. The analyst needs a single visualization that can effectively display both geographical location and two quantitative metrics (traffic volume and session duration) per country. Which chart type would be MOST appropriate?Visualization
  21. 21.A data quality team runs a deduplication analysis on a customer database containing 50,000 records and identifies 3,000 records as duplicates of existing customer entries. What is the uniqueness rate of the dataset?Data Governance, Quality and Controls
  22. 22.A data analyst is designing a dashboard for a marketing team to track the performance of various ad creatives. The team wants to see which creative versions are performing best in terms of click-through rate (CTR) and conversion rate (CVR) across different audience segments. The visualization needs to allow for easy comparison of CTR and CVR for each creative within each segment. Which type of chart would be MOST appropriate for this comparison?Visualization
  23. 23.A data architect is designing a new data platform for a large e-commerce company. The company generates massive amounts of raw, unrefined data from various sources including website clickstreams, mobile app usage, social media feeds, and sensor data from warehouses. The primary goal is to store all this data in its native format for future processing and analysis by various teams, without imposing an immediate schema. Which data environment is BEST suited for this purpose?Data Concepts and Environments
  24. 24.A data architect is designing a system to store streaming sensor data from thousands of IoT devices. Each data point consists of a timestamp, device ID, sensor type, and a numerical value. The primary access pattern for this data will involve querying by time range and device ID to retrieve sequences of sensor readings. Which database type is best suited for this use case?Data Concepts and Environments
  25. 25.A data engineer is designing a new data acquisition pipeline for sensor data. The sensors occasionally transmit readings that are orders of magnitude higher or lower than typical values, which are known to be measurement errors or system glitches. These extreme values could skew statistical analyses and machine learning models. Which data transformation technique should be applied to mitigate the impact of these extreme values without completely removing the data points?Data Mining
  26. 26.A data analytics team is tasked with creating a report that compares the market share of five major technology companies within the smartphone industry over the past ten years. The report needs to clearly show how each company's share has changed relative to the others and the total market over time. Which type of chart would be MOST appropriate for this visualization?Visualization
  27. 27.A financial services company assigns an individual to define data quality rules for the customer master table, monitor daily data issues, and coordinate corrections with business units. A senior executive separately holds ultimate accountability for the overall business value and risk of that data asset. Which role does the first individual perform?Data Governance, Quality and Controls
  28. 28.A business analyst is reviewing historical sales data and notices a consistent long-term upward trajectory in product sales over the past decade, despite minor fluctuations year-to-year and seasonal variations. This sustained, general direction of growth is a key indicator for future planning. Which specific component of time series analysis best describes this observed phenomenon?Data Analysis
  29. 29.A data analyst is examining a dataset of customer demographics. One column, 'MaritalStatus', contains values such as 'Single', 'Married', 'Divorced', and 'Widowed'. This column is used to group customers for marketing campaigns. What type of data does 'MaritalStatus' represent?Data Concepts and Environments
  30. 30.A data analyst is working with a dataset of customer survey responses where customers rated their satisfaction on a scale of 'Very Dissatisfied', 'Dissatisfied', 'Neutral', 'Satisfied', and 'Very Satisfied'. The analyst needs to calculate a measure of central tendency that is appropriate for this type of data. Which measure should be used?Data Analysis
  31. 31.A research institution is collecting genetic sequencing data, which consists of long strings of nucleotide bases (A, T, C, G) and associated metadata. This data is extremely large, does not fit neatly into rows and columns, and requires flexible storage that can accommodate varying structures and complex relationships without a rigid schema. Which database paradigm is most suitable for storing this type of data?Data Concepts and Environments
  32. 32.During a customer data consolidation project, a master data management system identifies three source records for the same customer with conflicting phone numbers. The system is configured to automatically select the value from the most recently updated source system as the final value in the golden record. This configuration is an example of which MDM concept?Data Governance, Quality and Controls
  33. 33.A company assigns one employee to make business decisions about how customer data should be classified, who is authorized to access it, and how long it must be retained. A separate IT employee is responsible for implementing the backups, encryption, and storage infrastructure that protect that same data. Which role is accountable for the classification and access decisions?Data Governance, Quality and Controls
  34. 34.A financial institution needs to store highly structured customer account information, including account numbers, balances, transaction history, and personal details. They require ACID properties to ensure data integrity during concurrent transactions. Which data environment is most appropriate for this requirement?Data Concepts and Environments
  35. 35.A business analyst is preparing a report to compare the average sales performance of three distinct product categories across four different regions. The goal is to easily identify which product category performs best in each region and to quickly spot any underperforming categories. Which type of chart would be MOST effective for this visualization?Visualization
  36. 36.A data analyst is performing an exploratory data analysis on a sales dataset. They notice that the 'Revenue' column contains a few values that are significantly higher than the vast majority of other entries, potentially skewing statistical measures like the mean and standard deviation. These extreme values, while possibly legitimate, are distorting the overall distribution. Which data cleansing technique is most appropriate to mitigate the impact of these extreme values on statistical analysis without necessarily deleting them?Data Mining
  37. 37.A business intelligence team needs to analyze historical sales data, customer demographics, and product inventory to identify trends and create reports for strategic decision-making. The data comes from various operational systems and needs to be cleaned, transformed, and loaded into a central repository optimized for complex analytical queries. Which data environment is best suited for this purpose?Data Concepts and Environments
  38. 38.A company's production database must allow full, unmasked access to Social Security numbers for the compliance team, while call center representatives querying that same live database see only the last four digits of each SSN at the moment of query, with no change made to the actual stored values. Which technique satisfies this requirement?Data Governance, Quality and Controls
  39. 39.A data analyst is designing a dashboard that displays real-time customer support metrics, such as average response time and resolution rate. The dashboard needs to be constantly monitored by team leads to identify immediate issues. Which design principle is MOST critical to ensure the dashboard remains effective and actionable in this dynamic environment?Visualization
  40. 40.A research team is investigating the relationship between the number of hours students spend studying per week and their final exam scores. They hypothesize that there is a positive linear relationship. Which statistical analysis technique would be most appropriate to test this hypothesis and quantify the strength and direction of the relationship?Data Analysis
  41. 41.A data analyst is designing a dashboard for a call center to monitor agent performance. The dashboard needs to display key metrics such as average call handling time, first call resolution rate, and customer satisfaction scores. To draw immediate attention to agents whose performance falls below predefined thresholds (e.g., call handling time > 5 minutes), which design element is MOST effective?Visualization
  42. 42.A data scientist is analyzing a customer feedback dataset. They notice that the 'Sentiment Score' column, which should range from -1 (negative) to 1 (positive), contains some values like -5, 2, and 'N/A'. To prepare this data for a machine learning model, which data cleansing technique would be most appropriate for handling the 'N/A' values?Data Mining
  43. 43.A data engineer is designing an ETL pipeline for a new customer relationship management (CRM) system. The source system is an older, on-premise database, and the target is a cloud-based data warehouse. The business requires that all customer records, including new ones, updates to existing records, and deletions, are synchronized daily. Which data acquisition strategy is most efficient for capturing only the changes from the source system without transferring the entire dataset each day?Data Mining
  44. 44.A data scientist receives a dataset in a file format that uses a human-readable, plain-text structure where data items are separated by commas and each line represents a new record. The first line contains the column headers. What file format is being described?Data Concepts and Environments
  45. 45.A data analyst is examining the distribution of customer ages. The data shows a few extremely old customers, causing the distribution to be skewed to the right. The analyst wants to understand the most typical age of a customer without being heavily influenced by these outliers. Which descriptive statistic should they use?Data Analysis
  46. 46.A data analyst is querying a customer database to find all customers who have placed an order in the last 30 days but have not yet received a shipping confirmation. The database contains two tables: `Orders` (OrderID, CustomerID, OrderDate) and `Shipments` (ShipmentID, OrderID, ConfirmationDate). Which type of SQL join should the analyst use, combined with an appropriate WHERE clause, to achieve this result?Data Mining
  47. 47.A data analyst is designing a dashboard for a logistics company to track package delivery status. The dashboard needs to immediately alert dispatchers to any packages that are severely delayed, showing their current status (e.g., 'In Transit', 'Delayed', 'Delivered'). Instead of relying solely on text, the analyst wants to use visual cues to make the 'Delayed' status stand out prominently. Which design principle should the analyst apply to achieve this immediate visual alert?Visualization
  48. 48.A data engineer is designing an ETL process to integrate data from a legacy system into a new data warehouse. The legacy system stores customer addresses in a single free-form text field, while the new data warehouse requires separate fields for street, city, state, and zip code. Which data transformation technique is most appropriate for handling this specific data structure change?Data Mining
  49. 49.A senior data analyst is reviewing a newly developed sales dashboard. The dashboard uses different color palettes for each region's sales charts (e.g., blue for North, green for South, red for East), and the titles for similar metrics vary across different tabs (e.g., 'Total Revenue' on one tab, 'Sales Sum' on another). While the individual charts are accurate, the analyst notes that users are struggling to quickly interpret information and switch between views. Which design principle is MOST likely being violated?Visualization
  50. 50.A company's data retention policy states that customer transaction records must be deleted after seven years. Legal counsel then notifies the data team that the company is now involved in litigation, and certain transaction records dated five years ago must not be deleted until the case is resolved, even though the retention period has not yet expired. Which of the following BEST describes this requirement?Data Governance, Quality and Controls