Step2Study

CompTIA Data+ (DA0-002) practice questions

230 free questions with answers and explanations.

Practice test
  1. 51.A data scientist is preparing a dataset for a machine learning model that predicts housing prices. The dataset includes a 'Square_Footage' column, which has a few extremely high values that are clearly data entry errors (e.g., 100,000 sq ft for a typical residential home). These outliers can skew the model's training. Removing these records entirely is not feasible due to the limited dataset size. Which data cleansing technique should the data scientist use to mitigate the impact of these extreme outliers without deleting the records?Data Mining
  2. 52.A business analyst is creating a dashboard to track key performance indicators (KPIs) for sales. The dashboard will be used by executives who need to quickly grasp overall performance and identify areas needing attention. Which design principle should be prioritized to ensure the dashboard is effective for this audience?Visualization
  3. 53.A data analyst is tasked with creating a report that compares the revenue generated by different product lines over the past five years. The report needs to clearly show the individual contribution of each product line to the total revenue each year, as well as the overall trend of total revenue. Which chart type is MOST suitable for this scenario?Visualization
  4. 54.A data scientist is developing a machine learning model to classify customer reviews as positive or negative. After training the model, they evaluate its performance using a test dataset. The model correctly identifies 90% of all positive reviews and 85% of all negative reviews. However, when examining the reviews predicted as positive, only 70% were actually positive, while 30% were incorrectly classified. Which metric is described by the 70% figure?Data Analysis
  5. 55.A data analyst is preparing a dataset for building a predictive model. They notice that one of the features, 'Income', has a wide range of values, from $20,000 to $500,000, while another feature, 'Number of Purchases', ranges from 1 to 50. Some machine learning algorithms are sensitive to features with different scales, potentially giving undue weight to features with larger numerical ranges. Which preprocessing technique should the analyst apply to address this issue?Data Analysis
  6. 56.A data scientist is preparing a dataset for machine learning. The dataset contains customer information including 'CustomerID' (unique identifier), 'FirstName', 'LastName', 'EmailAddress', 'OrderCount' (number of orders), and 'LastOrderDate'. The scientist observes that 'OrderCount' is stored as text, which causes errors during numerical operations. To resolve this, 'OrderCount' needs to be converted to an integer. Which data quality dimension is primarily being addressed by this conversion?Data Concepts and Environments
  7. 57.A financial analyst is preparing a report to show the correlation between advertising spend and sales revenue over the past two years. The report needs to identify if there's a positive, negative, or no relationship, and potentially highlight any outliers. Which chart type would be MOST appropriate for this task?Visualization
  8. 58.A data scientist is analyzing the impact of a new marketing campaign on website traffic. They observe an initial surge in traffic immediately after the campaign launch, followed by a gradual decline. Which type of trend analysis would be most suitable to identify and quantify this pattern?Data Analysis
  9. 59.An organization's CRM, ERP, and support ticketing systems each store a different version of the same customer's mailing address. As part of a master data management initiative, the team applies survivorship rules to select the most trusted value from each source and produces one authoritative customer record used across all systems. This resulting record is best described as which of the following?Data Governance, Quality and Controls
  10. 60.A data quality team is reviewing a dataset where customer names are stored in various inconsistent formats (e.g., 'JOHN DOE', 'john doe', 'Johnathan Doe'). Before integrating this data into a master customer database, they need to apply a transformation to ensure all names follow a 'Proper Case' format (e.g., 'John Doe'). Which of the following SQL functions would be most effective for this specific transformation when applied to a `customer_name` column?Data Mining
  11. 61.A data analyst is working with a large dataset of customer transactions. They notice that some records have missing values in the 'Purchase_Amount' column, which is critical for their analysis. Simply removing these records would lead to significant data loss. Which of the following data cleansing techniques would be most appropriate to address these missing values without discarding entire records?Data Mining
  12. 62.A data analytics team needs to integrate data from various sources, including customer relationship management (CRM) systems, enterprise resource planning (ERP) systems, and external market research feeds. The goal is to perform complex analytical queries, generate reports, and support business intelligence dashboards. The data needs to be highly structured, consistent, and optimized for read performance for historical analysis. Which data environment is best suited for this purpose?Data Concepts and Environments
  13. 63.A data engineer is tasked with combining customer purchase history with product catalog information. The 'Purchases' table contains `CustomerID`, `ProductID`, and `PurchaseDate`. The 'Products' table contains `ProductID`, `ProductName`, and `Category`. The business requirement is to list all products that have ever been purchased, along with the customer who bought them, but also to include products from the catalog that have never been purchased. Which SQL join type is most appropriate for this scenario?Data Mining
  14. 64.A data analyst is designing a dashboard for a retail company to monitor inventory levels across various warehouses. The dashboard needs to highlight products that are critically low on stock, nearing reorder points, or overstocked. The users require an immediate visual alert for these conditions without needing to read specific numbers. Which design principle should the analyst apply to achieve this?Visualization
  15. 65.A company's records retention policy specifies that customer transaction records must be kept for seven years to satisfy tax regulations. Once a record reaches the end of that seven-year period, the policy requires the record to be permanently destroyed using a method that renders the data unrecoverable, such as cryptographic erasure of encrypted backups or physical shredding of storage media. Which stage of the data lifecycle does this final action represent?Data Governance, Quality and Controls
  16. 66.A data analyst is creating an interactive dashboard to monitor customer churn. The dashboard needs to show the churn rate over the last 12 months, segmented by customer tenure groups (e.g., <1 year, 1-3 years, >3 years). Users should be able to quickly see the trend for each tenure group and how their churn rates compare against each other. Which chart type is MOST suitable for this requirement?Visualization
  17. 67.A data architect is setting up a new data pipeline to ingest real-time sensor data. The data needs to be available for immediate analysis in a data lake, but complex transformations, aggregations, and data quality checks will be performed later by downstream processes. Which data integration approach would be most suitable for this scenario?Data Mining
  18. 68.A data architect is designing a new data acquisition pipeline for sensor data from IoT devices. Each sensor transmits data in a slightly different JSON format, but all contain a 'timestamp' and 'value' field. To ensure that incoming data conforms to a predefined structure before it's stored in the data lake, preventing malformed records from polluting the lake, which mechanism should be implemented?Data Mining
  19. 69.A data analyst is performing a hypothesis test to determine if a new website design leads to a statistically significant increase in conversion rates. They have set up their null and alternative hypotheses. After collecting data and running the statistical test, they obtain a p-value of 0.03. If the chosen significance level (alpha) for this test is 0.05, what conclusion should the analyst draw?Data Analysis
  20. 70.A data engineer is designing an ETL pipeline to load data from a transactional database into a data warehouse. A key requirement is to ensure that only new or changed records from the source system are processed and loaded into the warehouse to minimize processing time and resource consumption. Which data acquisition strategy is most appropriate for this requirement?Data Mining
  21. 71.A data analyst is investigating the relationship between advertising spend and sales revenue. They calculate a Pearson correlation coefficient of +0.85 between the two variables. What can be concluded from this correlation coefficient?Data Analysis
  22. 72.A data scientist is developing a dashboard to monitor the real-time performance of a machine learning model. The dashboard needs to clearly display the current accuracy, precision, and recall scores, along with whether each metric meets its predefined target. Which dashboard element is MOST effective for this purpose?Visualization
  23. 73.A data engineer is designing a system to store streaming sensor data from thousands of IoT devices. Each device sends a timestamp, device ID, and several numerical readings (e.g., temperature, pressure) every few seconds. The primary access pattern will be querying data for a specific device over a time range, and performing aggregations over time. Which database type is MOST optimized for this use case?Data Concepts and Environments
  24. 74.A logistics company's dashboard shows delivery status information that refreshes only once every 24 hours, but drivers and customers need up-to-the-minute updates to make real-time routing decisions. Which data quality dimension does this scenario illustrate?Data Governance, Quality and Controls
  25. 75.A data scientist is building a predictive model for housing prices. They have a dataset with various features such as square footage, number of bedrooms, and location. Before feeding this data into a machine learning algorithm, they want to ensure that all numerical features contribute equally to the model, regardless of their original scale. For example, square footage might range from 500 to 5000, while the number of bedrooms might range from 1 to 6. What data preprocessing technique should they apply?Data Analysis
  26. 76.A data analyst is creating an executive summary dashboard to monitor the overall health of a company's product portfolio. The dashboard needs to display key metrics like total revenue, customer satisfaction score, and market growth rate, each as a single, prominent numerical value. The goal is for executives to grasp the current status of each metric at a glance without needing to interpret complex charts. Which dashboard element is BEST suited for prominently displaying these individual, critical metrics?Visualization
  27. 77.A data analyst is working with a large dataset containing customer order information. They need to retrieve all orders placed by customers who live in 'New York' AND whose order total is greater than $500. Which of the following SQL clauses would be most effective for filtering the results based on these two conditions?Data Mining
  28. 78.A data engineering team is tasked with integrating data from various operational systems into a central repository for analytics. The data sources include customer transaction logs, website clickstream data, and sensor readings. The team needs to store this data in its raw, original format without imposing a schema at the time of ingestion. Which data storage concept is most appropriate for this requirement?Data Concepts and Environments
  29. 79.A data professional is evaluating a new dataset for potential biases. The dataset contains records of loan applications, including applicant age, income, credit score, and loan approval status. The professional discovers that the dataset disproportionately contains approved loans from a specific demographic group, even when other factors are similar, potentially leading to unfair lending practices if used for an AI model. Which AI concept is most relevant to this concern?Data Concepts and Environments
  30. 80.A data analyst has identified that a significant portion of their sales data is missing due to a technical glitch for a specific month. Simply deleting the records with missing values would lead to a substantial loss of valuable information and potentially bias the analysis. To address this, the analyst wants to estimate and fill in these missing values using a method that maintains the dataset's integrity as much as possible. Which technique is most appropriate?Data Analysis
  31. 81.A data governance committee is reviewing a new data acquisition process. The process involves collecting customer transaction records, which include personally identifiable information (PII) such as names, addresses, and credit card numbers. The committee emphasizes the need for strict controls, including encryption at rest and in transit, access restrictions, and regular audits, to comply with privacy regulations. Which data characteristic is the primary concern driving these requirements?Data Concepts and Environments
  32. 82.A business analyst is preparing a quarterly sales report for a global company. The report needs to compare sales performance across different countries, but also highlight market share within each country. The analyst wants a visualization that can effectively display both geographical distribution and proportional contribution for multiple regional markets. Which chart type is MOST suitable?Visualization
  33. 83.A data analyst is designing a dashboard to display the proportion of sales contributed by each product category for the current quarter. The categories are 'Electronics,' 'Apparel,' 'Home Goods,' and 'Books.' Which chart type is MOST appropriate for visualizing this data?Visualization
  34. 84.A team of marketing analysts is creating a dashboard to monitor the performance of various online advertising campaigns. The dashboard needs to clearly display the current status of key metrics, such as click-through rate (CTR) and cost per acquisition (CPA), against predefined targets. The audience requires a quick, at-a-glance understanding of whether each metric is performing above, below, or within target. Which of the following visualization types would be MOST effective for this purpose?Visualization
  35. 85.A data scientist has developed a complex predictive model for customer churn. The model's performance needs to be communicated to non-technical business stakeholders, clearly illustrating the model's accuracy, precision, and recall without overwhelming them with raw statistical output. The presentation should start with a high-level overview of the problem, introduce the solution, and then detail the results. Which storytelling framework would be MOST effective for this presentation?Visualization
  36. 86.A customer located in the European Union submits a formal request asking a company to permanently delete all of their personal data from company systems, stating the data is no longer necessary for the purpose it was originally collected. Under GDPR, this request corresponds to which data subject right?Data Governance, Quality and Controls
  37. 87.A data analyst is preparing a report for a retail company to illustrate the sales contribution of each product category to the total revenue for the previous year. The goal is to quickly show the proportion of sales generated by each category and identify the top-performing ones, especially if there are many categories. Which chart type would be MOST effective for this visualization?Visualization
  38. 88.A data analyst is preparing a quarterly business review for a diverse audience, including both technical specialists and non-technical stakeholders. The report contains complex statistical analysis and predictive models. To ensure that all audience members, regardless of their technical background, can understand the key findings and their implications, which design principle should be applied when presenting the visualizations?Visualization
  39. 89.A data analyst is preparing a dataset for a new machine learning model. They notice that several records have missing values in a critical 'Customer_Age' column, which is essential for the model's accuracy. Which of the following data cleansing techniques is most appropriate for handling these missing values if the analyst wants to preserve as much data as possible while providing a reasonable estimate?Data Mining
  40. 90.A data analyst is designing a dashboard for regional sales managers. The dashboard must prominently display the current month's sales target achievement for each region, showing both the actual sales and the target, with a clear visual indicator if the target has been met or exceeded. Space on the dashboard is limited. Which visualization design principle should the analyst prioritize to meet these requirements?Visualization
  41. 91.A multinational retailer operates cloud infrastructure in several countries. To comply with a European regulation requiring that personal data of EU citizens be stored and processed on servers physically located within the European Union, the company configures its cloud provider to restrict EU customer data to EU-based data centers only. Which concept does this requirement illustrate?Data Governance, Quality and Controls
  42. 92.A data architect is designing a new data platform for a large e-commerce company. The company generates vast amounts of clickstream data, social media interactions, and customer support chat logs, alongside traditional transactional data. The architect wants a cost-effective solution that can store all this raw, diverse data without imposing a predefined schema, allowing for future analytical flexibility. Which data environment would best meet these requirements?Data Concepts and Environments
  43. 93.A data analyst is developing a dashboard to monitor website engagement metrics, including bounce rate, average session duration, and page views per session. The dashboard is intended for marketing managers who need to quickly see aggregated trends and identify any significant deviations from expected performance across different traffic sources. Which design principle should the analyst prioritize to ensure ease of trend identification and anomaly detection?Visualization
  44. 94.A data analyst is tasked with creating a report that compares the market share of five major competitors in the smartphone industry over the past decade. The report needs to clearly show how each competitor's share has changed relative to the total market and to each other. Which chart type would be MOST suitable for this analysis?Visualization
  45. 95.A healthcare organization replaces patient names in a research dataset with randomly generated unique codes. The organization retains a separately secured mapping table linking each code back to the original patient identity for authorized re-identification if needed later. Which de-identification technique does this represent?Data Governance, Quality and Controls
  46. 96.A data architect is designing a new data pipeline for an e-commerce platform. The platform generates a high volume of clickstream data, which needs to be processed quickly and made available for near real-time analytics. The raw data will be stored in a data lake, and subsequent transformations, aggregations, and data quality checks will be performed within the data lake environment using distributed processing frameworks. Which data integration paradigm best fits this approach?Data Mining
  47. 97.A software development team is building a new microservices-based application. They need a lightweight, human-readable file format to exchange configuration data and API responses between different services. The format must support nested structures and arrays. Which file format would be the most suitable choice?Data Concepts and Environments
  48. 98.A data analyst is designing a dashboard to monitor inventory levels for a large retail chain. The dashboard needs to display the quantity on hand for thousands of unique products across hundreds of stores. The primary goal is to quickly identify products that are critically low in stock or overstocked, without having to scroll through endless lists. Which visualization technique would be MOST effective for this scenario?Visualization
  49. 99.A mobile app development team is designing a new user registration form. To comply with the company's privacy policy, the team decides to collect only the user's name and email address, even though the marketing department requested fields for home address, date of birth, and income level. Which privacy principle is the team applying?Data Governance, Quality and Controls
  50. 100.A retailer's CRM system lists a customer's address as '123 Main St, Apt 4B' while the billing system lists the same customer's current address as '123 Main Street, Suite 4B'. Both entries may reflect the same real address, but the values do not match between the two systems. Which data quality dimension is primarily violated?Data Governance, Quality and Controls