Step2Study

CompTIA Data+ (DA0-002) practice questions

230 free questions with answers and explanations.

Practice test
  1. 151.A data engineering team is migrating a legacy system's configuration files. These files contain hierarchical key-value pairs, often with nested structures, and need to be easily readable and modifiable by both humans and machines. The team wants a format that is well-supported by web APIs and modern programming languages for data interchange. Which file format is the most appropriate choice?Data Concepts and Environments
  2. 152.A company's records management policy states that tax-related financial documents must be kept for exactly 7 years to comply with IRS requirements, after which they are automatically purged from the archive system. This policy is an example of which governance control?Data Governance, Quality and Controls
  3. 153.A data architect is designing a new data ingestion pipeline that needs to process high volumes of streaming data from IoT devices. The data needs to be minimally transformed before being stored in a data lake for future analytical processing. The architect prioritizes speed and scalability for initial ingestion, deferring complex transformations until data is queried. Which data integration paradigm is best suited for this scenario?Data Mining
  4. 154.A data analyst is querying a database to find all employees who have a job title containing the word 'Engineer' (case-insensitive) and whose salary is above $80,000. The `Employees` table has columns `EmployeeID`, `JobTitle`, and `Salary`. Which SQL query correctly filters the data to meet these requirements?Data Mining
  5. 155.A data engineering team is setting up a new data processing pipeline. They receive data from an external vendor in a format that consists of simple rows of text, where each value is separated by a comma. There are no complex nested structures or metadata within the file; it's purely tabular data. Which file format are they most likely receiving?Data Concepts and Environments
  6. 156.A data analytics team is developing a new sales dashboard for regional managers. The managers frequently need to drill down into specific sales figures for individual products within each region without leaving the dashboard view. Which dashboard design principle should be prioritized to support this requirement?Visualization
  7. 157.A data engineer is developing an ETL pipeline for a marketing analytics platform. The source data contains customer demographics, and the 'Gender' column has inconsistent entries such as 'Male', 'male', 'M', 'Female', 'female', 'F', and some nulls. To ensure data consistency for reporting, all gender entries must be transformed into either 'Male', 'Female', or 'Unknown'. Which SQL function or statement is most suitable for this type of conditional data transformation?Data Mining
  8. 158.A data analyst is investigating customer satisfaction scores (on a scale of 1-5) across different product lines. They want to know if there is a statistically significant difference in the *distribution* of satisfaction scores among Product A, Product B, and Product C. Which statistical test is most suitable for this analysis?Data Analysis
  9. 159.A data quality specialist is analyzing a dataset of customer addresses. They observe that the 'State' column contains entries like 'California', 'CA', 'california', and 'Cal'. To standardize this column for consistent reporting, which data transformation technique should be applied?Data Mining
  10. 160.A large enterprise forms a cross-functional group with representatives from IT, legal, compliance, and business units. This group approves enterprise-wide data policies, resolves disputes over data ownership, and prioritizes data quality initiatives across departments. What is this group called?Data Governance, Quality and Controls
  11. 161.A data analytics team is preparing to present findings on customer churn to stakeholders. They have identified several factors that contribute to churn, including customer tenure, average monthly spend, and number of support tickets. To communicate the relative importance of these factors in predicting churn, which analysis technique would be most effective?Data Analysis
  12. 162.A quality control manager is tracking the number of defects produced per day on an assembly line. Over the past 30 days, the number of defects recorded are: 5, 8, 6, 7, 5, 9, 10, 8, 7, 6, 5, 8, 9, 7, 6, 5, 10, 8, 7, 6, 5, 9, 8, 7, 6, 5, 10, 8, 7, 6. What is the mode of this dataset?Data Analysis
  13. 163.A data analyst is designing a dashboard for sales managers to monitor daily sales performance. The dashboard needs to highlight current sales against a daily target, show the percentage completion, and quickly alert managers if sales are significantly below target. Which dashboard element would be MOST effective for displaying the current sales completion against a target with an immediate visual cue?Visualization
  14. 164.A data analyst is working with a dataset containing customer feedback. Each entry includes a 'Sentiment' rating categorized as 'Positive', 'Neutral', or 'Negative'. The analyst wants to understand the distribution of these ratings but cannot perform arithmetic operations like averaging them directly. Which type of data is represented by the 'Sentiment' rating?Data Concepts and Environments
  15. 165.A data analyst is building a dashboard for a product manager to track the usage of different features within a software application. The product manager needs to see the total daily active users (DAU) and how that total is composed of users engaging with Feature A, Feature B, and Feature C over the last month. The visualization should clearly show the changing proportion of users for each feature relative to the total DAU. Which chart type would BEST represent this data?Visualization
  16. 166.A data analyst reviews a customer database and finds that 15% of records have a blank value in the required 'State' field, which is needed for regional sales reporting. Which data quality dimension is being violated?Data Governance, Quality and Controls
  17. 167.A data analyst is using a statistical model to predict future sales based on historical data. They notice that the model consistently overestimates sales during peak seasons and underestimates them during off-peak seasons. Which type of analysis would be most effective in identifying and quantifying these periodic fluctuations?Data Analysis
  18. 168.A data analyst is performing a hypothesis test to compare the average customer satisfaction scores between three different product lines (Product A, Product B, and Product C). The scores are collected on a continuous scale, and the analyst assumes that the data is normally distributed and the variances across the groups are approximately equal. Which statistical test is most appropriate for this scenario?Data Analysis
  19. 169.A hospital wants to restrict access to electronic patient records based on a combination of dynamic factors, including the requester's department, whether the requester is on the patient's assigned care team, and the time of day the request is made. Which access control model best supports this requirement?Data Governance, Quality and Controls
  20. 170.A data scientist is preparing a dataset for a machine learning model that predicts customer purchasing behavior. The dataset includes 'Customer ID', 'Product Category', 'Purchase Amount', and 'Payment Method'. The 'Product Category' column contains values such as 'Electronics', 'Apparel', 'Home Goods', and 'Food'. Which of the following best describes the 'Product Category' data type?Data Concepts and Environments
  21. 171.A data analytics team has developed a detailed report on quarterly sales performance, including granular data on product categories, regional breakdowns, and customer demographics. The report is intended for both sales managers, who need to identify underperforming products, and marketing executives, who are interested in customer segment trends. Which of the following reporting strategies would be MOST effective in meeting the diverse needs of these stakeholders?Visualization
  22. 172.A data analyst needs to combine customer order data with product catalog information. The 'Orders' table contains 'OrderID' and 'ProductID', while the 'Products' table contains 'ProductID' and 'ProductName'. The analyst wants to see all orders along with their corresponding product names, and also see any products that exist in the catalog but have not yet been ordered. Which SQL JOIN type should be used?Data Mining
  23. 173.A data engineer is building an ELT pipeline for a real-time analytics dashboard. The source system is a high-volume transactional database, and the target is a cloud-based data lake. Due to the requirement for immediate availability of raw data for various downstream analyses, the engineer decides to perform minimal transformations during the 'Load' phase into the data lake. Which type of transformation would be most appropriate to apply at this early stage without significantly impacting the raw data integrity or load speed?Data Mining
  24. 174.A data scientist is preparing a dataset for machine learning. The dataset includes a column named 'CustomerID' which contains unique alphanumeric identifiers for each customer. This column is used solely to distinguish one customer from another and has no inherent order or numerical meaning. What type of data does 'CustomerID' represent?Data Concepts and Environments
  25. 175.A data engineer is building a data ingestion pipeline from a legacy system. The source data includes a 'Transaction_Date' column stored as a string in various inconsistent formats (e.g., 'YYYY-MM-DD', 'MM/DD/YYYY', 'DD-MON-YY'). Before loading into the data warehouse, this column must be converted to a uniform `DATE` data type. Which SQL function is most appropriate for handling this type of conversion, assuming some manual pattern identification might be needed?Data Mining
  26. 176.A data analyst is using a statistical model to predict the likelihood of customer churn. The model outputs a probability score for each customer. To evaluate the model's performance, the analyst needs to set a threshold above which a customer is classified as 'likely to churn'. They want to find a threshold that balances the rate of correctly identified churners with the rate of incorrectly identified non-churners. Which metric helps in evaluating this trade-off?Data Analysis
  27. 177.A financial analyst is comparing the returns of two different investment portfolios, Portfolio A and Portfolio B, over the last five years. They want to determine if there is a statistically significant difference in the average returns between these two independent portfolios. The analyst has reason to believe that the returns data for both portfolios are normally distributed. Which statistical test should the analyst apply?Data Analysis
  28. 178.A data analyst is working with a sales database that contains two tables: `Customers` (CustomerID, CustomerName, Region) and `Orders` (OrderID, CustomerID, OrderDate, OrderAmount). They need to retrieve the names of all customers who have placed an order in the 'North' region AND whose total order amount exceeds $1000. Which SQL clause is primarily used to filter rows based on conditions applied to individual rows before any grouping or aggregation?Data Mining
  29. 179.A data scientist is developing a new algorithm to detect fraudulent transactions. They train the algorithm and now need to evaluate its performance. A critical requirement is to minimize the number of actual fraudulent transactions that are missed by the algorithm, even if it means flagging some legitimate transactions as fraudulent. Which evaluation metric should the data scientist prioritize to meet this requirement?Data Analysis
  30. 180.A financial analyst is querying a large transactional database to identify customers who have made purchases in both the 'Electronics' and 'Apparel' categories. The database has two tables: `Customers (customer_id, customer_name)` and `Orders (order_id, customer_id, category, amount)`. Which SQL join type should the analyst use to retrieve only the `customer_name` of customers present in both categories, ensuring each customer appears only once?Data Mining
  31. 181.A data analyst is working with a dataset that includes customer ages, income levels, and the number of purchases made per month. Which of the following data types best describes the 'number of purchases made per month'?Data Concepts and Environments
  32. 182.A data engineer is working with a raw dataset where the 'ProductCategory' column contains inconsistent entries such as 'Electronics', 'electronics', 'Elec.', and 'ELECTRONICS'. To ensure accurate grouping and analysis, they need to convert all these variations into a single, standardized format, specifically 'Electronics'. Which SQL transformation function would be most effective for this task?Data Mining
  33. 183.A company needs to provide a third-party software vendor with a full copy of its production customer database for testing in a separate, non-production environment. To protect sensitive fields such as Social Security numbers and credit card numbers while preserving the data's format and referential integrity for testing, the company permanently replaces the sensitive values with realistic but fictitious values in the copied dataset before delivery. Which technique is being used?Data Governance, Quality and Controls
  34. 184.A data analyst is preparing a dataset of product reviews for natural language processing. They notice that many reviews contain leading or trailing spaces, or multiple spaces between words (e.g., ' Great product! ' or 'Very good'). Which SQL string function should be used to clean up these extraneous spaces?Data Mining
  35. 185.A retail company is analyzing sales data for different product categories. They want to identify which categories are performing significantly better or worse than the overall average, considering the variability of sales within each category. Which statistical analysis technique would be most appropriate for this task?Data Analysis
  36. 186.A data analyst is evaluating the effectiveness of a new customer loyalty program. They want to determine if there is a statistically significant difference in the average purchase value of customers enrolled in the program compared to those not enrolled. The purchase values are not normally distributed, and the sample sizes are relatively small. Which statistical test is most appropriate for this analysis?Data Analysis
  37. 187.A company's IT security policy states that new employees are granted access only to the specific systems and data required to perform their assigned job duties at the time of hire. Any additional access must go through a formal request and approval process. Which access control principle does this policy describe?Data Governance, Quality and Controls
  38. 188.A data analyst is auditing a dataset of product IDs where each ID should be a 5-digit alphanumeric string (e.g., 'A123B', '0001Z'). They discover some IDs like 'ABC', '123456', or 'A1B2C3D'. To identify records that do NOT conform to the 5-digit alphanumeric requirement, which SQL pattern matching operator would be most effective?Data Mining
  39. 189.A report shows an unexpected spike in total sales revenue. To determine whether the anomaly originated from a transformation error in the ETL pipeline or from the original source system, an analyst reviews documentation that maps each field in the report back through every transformation step to its original source table and column. This documentation is an example of which of the following?Data Governance, Quality and Controls
  40. 190.A data analyst is preparing an executive summary report on quarterly financial performance. The audience consists of senior leadership who are busy and need to grasp key insights quickly. The report includes complex financial models and numerous metrics. To ensure the executives focus on the most critical information and understand the narrative without getting lost in details, which storytelling principle should the analyst emphasize?Visualization
  41. 191.A data engineer is tasked with optimizing a SQL query that frequently joins two large tables: `customers` (10 million rows) and `orders` (100 million rows) on `customer_id`. The `customer_id` column in both tables is indexed. The current query uses an `INNER JOIN`. However, the engineer notices that the execution plan shows a high cost associated with the join operation. Which of the following strategies, if applicable, would likely yield the most significant performance improvement for this specific join?Data Mining
  42. 192.A data scientist is working with a dataset containing customer satisfaction scores on a scale of 1 to 5, where 1 is 'Very Dissatisfied' and 5 is 'Very Satisfied'. While the scores have an order, the difference between a score of 1 and 2 is not necessarily the same as the difference between 4 and 5 in terms of actual satisfaction. Which data type best describes these satisfaction scores?Data Concepts and Environments
  43. 193.A data analyst is comparing the performance of two different marketing campaigns (Campaign A and Campaign B) based on the average number of clicks per ad. They collect data from a sample of ads for each campaign. The analyst wants to determine if there is a statistically significant difference between the average clicks of the two campaigns, assuming the population variances are equal. Which hypothesis test should they use?Data Analysis
  44. 194.A data analyst needs to compare the sales performance of five different product lines over the last three fiscal quarters. The goal is to quickly identify which product lines are consistently performing well or poorly relative to each other. Which chart type would be MOST appropriate for this comparison?Visualization
  45. 195.A data analyst is creating a dashboard for a logistics company to track the delivery status of thousands of packages. The dashboard needs to show the geographical distribution of packages currently 'In Transit,' 'Delayed,' or 'Delivered' across different states and major cities. The primary goal is to quickly identify regions with high concentrations of delayed or in-transit packages. Which visualization type is MOST appropriate for this scenario?Visualization
  46. 196.A data scientist is developing a model to predict customer lifetime value (CLV). They are evaluating different models and need a metric that provides a balanced measure of a model's precision and recall, especially when dealing with imbalanced datasets where one class (e.g., high CLV customers) is much rarer than others. Which metric is best suited for this purpose?Data Analysis
  47. 197.A data engineer is building a data pipeline that processes real-time sensor readings from industrial machinery. Each reading includes a timestamp, machine ID, sensor type, and a numerical value. The data needs to be stored in a way that allows for extremely fast ingestion of new data points and efficient queries over time ranges (e.g., average temperature for machine X over the last hour). Which database type is BEST suited for this scenario?Data Concepts and Environments
  48. 198.A data engineering team is designing a system to store configuration settings for a distributed microservices architecture. Each microservice requires flexible, schema-less storage for its unique settings, which often include nested structures and varying data types. Which database type is best suited for this requirement?Data Concepts and Environments
  49. 199.A data analyst is performing exploratory data analysis on a dataset of customer reviews. The reviews are free-form text, often containing misspellings, slang, and varying sentence structures. The analyst needs to extract sentiment (positive, negative, neutral) and identify key topics from this data. What type of data is this?Data Concepts and Environments
  50. 200.A data engineer is designing a data pipeline to process customer interaction data from a website, including clicks, views, and session information. The primary requirement is extremely fast read and write access for individual records, often retrieved by a simple unique identifier (e.g., session ID). The data structure is relatively simple and does not require complex relationships or queries across multiple attributes. Which NoSQL database type would be most efficient for this use case?Data Concepts and Environments