AMAADOR ACADEMYCertificatesVerify a certificate

DATAP

Final check — CompTIA Data+ (DA0-002) Exam Prep: Practice Course and Mock Exam

Answer the 49 questions. You need 80% or more to pass. You can retry as many times as you like.

Study the course →

Question 1According to CompTIA, what is the passing score for Data+ DA0-002?
Question 2A retailer needs a store for five years of cleaned sales history that business users will query through dashboards every morning. Which option fits best?
Question 3An analyst imports a supplier file and finds that postcodes such as 01000 now show as 1000. What caused this?
Question 4Which file format stores data by column in compressed form and is designed for fast analytical queries on large datasets?
Question 5In a dimensional model, a table that holds sales amounts and quantities with keys to date, product and store tables is called what?
Question 6HR wants to keep a record of every department an employee has belonged to, with start and end dates, inside the employee dimension. Which approach meets this?
Question 7A customer satisfaction field holds the values low, medium and high. What kind of data is this?
Question 8A script pulling data from a public API starts receiving HTTP 429 responses after a few hundred calls. What is the best fix?
Question 9A team uses figures from a national statistics office’s published tables. How is this data classified?
Question 10A data scientist’s model runs on her laptop but fails on the server because library versions differ. What should the team use?
Question 11Every morning a clerk copies the same ten figures from a supplier portal into the ERP using fixed steps. The company wants to automate this without changing either system. What fits best?
Question 12Marketing wants to group customers into segments but has no predefined labels for the segments. Which approach should the analyst use?
Question 13Which storage type keeps files as objects with metadata in buckets and is commonly used for data lakes?
Question 14An analyst asks a generative AI tool to summarise survey comments. The summary quotes a statistic that does not appear in the data. What does this illustrate?
Question 15A company must mask national ID numbers before any data reaches its cloud warehouse. Which integration pattern fits this rule?
Question 16An analyst needs a list of all customers with their total orders, including customers who have never ordered. Which join should be used from customers to orders?
Question 17An analyst wants only regions whose total sales exceed 1 million. Which clause filters on the aggregated total?
Question 18A nightly job reloads a 400-million-row table in full and now overruns its time window. Only about 0.1% of rows change each day, and each row has a last_modified timestamp. What should change?
Question 19With Q1 = 50 and Q3 = 80, above which value is an order flagged as a potential outlier using the 1.5 x IQR rule?
Question 20Profiling shows a city column with values Rabat, RABAT, rabat and Rbat. Which data issue is this?
Question 21A query used by a web form builds SQL by concatenating the text a user types into the WHERE clause. What is the main risk and fix?
Question 22Household income in a survey is strongly right-skewed and 5% of values are missing at random. Which simple imputation is most suitable?
Question 23An analyst corrects 300 wrong prices by typing over cells in a spreadsheet. The same file arrives every month with the same faults. What is the main weakness?
Question 24Splitting the field “2026-11-18 09:15:00” into separate date and hour columns is an example of what?
Question 25Twelve branch files with identical columns must be combined into one table of all transactions. Which transformation is this?
Question 26Sales files from Morocco (MAD), France (EUR) and the UAE (AED) will be combined into a group total. What must happen first?
Question 27Before a clustering model, income (thousands) and age (tens) are rescaled to a 0-1 range so that one does not dominate. What is this called?
Question 28After cleansing, a customer table has 48,200 rows instead of the 50,000 received. Nothing in the log explains the difference. What should the analyst do?
Question 29Monthly salaries in a small firm are 9,000, 9,500, 10,000, 10,500 and 61,000 MAD. Which measure best describes a typical salary?
Question 30In a right-skewed distribution, how do the mean and median usually compare?
Question 31An analyst wants to know whether product preference (three products) is related to customer region (four regions). Which test fits?
Question 32A test concludes that a new email design increases clicks, but in reality it has no effect. Which error occurred?
Question 33A study finds that stores with more staff have higher sales (r = 0.8). A manager wants to hire more staff in every store to raise sales. What is the best response?
Question 34A SUM over an imported amount column returns 0 although the column shows values. What is the most likely cause?
Question 35The finance director asks for the result of a three-week pricing analysis before a board meeting tomorrow. What should the analyst send?
Question 36A manager wants to see how monthly website visits have changed over the last three years. Which visual is best?
Question 37A bar chart compares two products’ sales of 980 and 1,000 units, but the y-axis starts at 950, so one bar looks twice as tall. What is wrong?
Question 38Which visual best shows the distribution of delivery times, including the median, quartiles and outliers?
Question 39One sales dashboard must serve twelve regional managers, and each may see only their own region’s figures. What is the best design?
Question 40A dashboard shows the same figures as last Monday although new sales were recorded. Nothing in the dashboard shows an error. What should the analyst check first?
Question 41A report shows national satisfaction as the simple average of five regional averages. The regions have 50 to 5,000 respondents each. What is the problem?
Question 42After release, an analyst finds a calculation error that overstated last quarter’s margin. What should she do?
Question 43Which document lists each field’s name, data type, allowed values and business definition?
Question 44An auditor asks how the revenue figure on the board dashboard was derived from source systems. What best answers this?
Question 45Call-centre staff must confirm a caller’s card by its last four digits but must not see the full number. Which control fits?
Question 46Under GDPR, how is data treated when names are replaced by codes but a separate key table can re-identify people?
Question 47Policy says customer records are deleted seven years after account closure. A lawsuit involving some closed accounts has just started. What applies to those records?
Question 48The CRM and billing systems show different addresses for the same 4% of customers. Which data quality dimension is failing?
Question 49Which role is accountable for approving who may access a dataset and for what purpose?