AMAADOR ACADEMYالشهاداتالتحقق من شهادة

DATAP

الاختبار النهائي — التحضير لامتحان CompTIA Data+ (DA0‑002): دورة تدريبية وامتحان تجريبي

أجب عن الأسئلة الـ49. تحتاج إلى 80% أو أكثر للنجاح. يمكنك إعادة المحاولة كلما أردت.

هذا الاختبار النهائي متاح بـالإنجليزية.

ادرس الدورة ←

السؤال 1According to CompTIA, what is the passing score for Data+ DA0-002?
السؤال 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?
السؤال 3An analyst imports a supplier file and finds that postcodes such as 01000 now show as 1000. What caused this?
السؤال 4Which file format stores data by column in compressed form and is designed for fast analytical queries on large datasets?
السؤال 5In a dimensional model, a table that holds sales amounts and quantities with keys to date, product and store tables is called what?
السؤال 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?
السؤال 7A customer satisfaction field holds the values low, medium and high. What kind of data is this?
السؤال 8A script pulling data from a public API starts receiving HTTP 429 responses after a few hundred calls. What is the best fix?
السؤال 9A team uses figures from a national statistics office’s published tables. How is this data classified?
السؤال 10A data scientist’s model runs on her laptop but fails on the server because library versions differ. What should the team use?
السؤال 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?
السؤال 12Marketing wants to group customers into segments but has no predefined labels for the segments. Which approach should the analyst use?
السؤال 13Which storage type keeps files as objects with metadata in buckets and is commonly used for data lakes?
السؤال 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?
السؤال 15A company must mask national ID numbers before any data reaches its cloud warehouse. Which integration pattern fits this rule?
السؤال 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?
السؤال 17An analyst wants only regions whose total sales exceed 1 million. Which clause filters on the aggregated total?
السؤال 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?
السؤال 19With Q1 = 50 and Q3 = 80, above which value is an order flagged as a potential outlier using the 1.5 x IQR rule?
السؤال 20Profiling shows a city column with values Rabat, RABAT, rabat and Rbat. Which data issue is this?
السؤال 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?
السؤال 22Household income in a survey is strongly right-skewed and 5% of values are missing at random. Which simple imputation is most suitable?
السؤال 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?
السؤال 24Splitting the field “2026-11-18 09:15:00” into separate date and hour columns is an example of what?
السؤال 25Twelve branch files with identical columns must be combined into one table of all transactions. Which transformation is this?
السؤال 26Sales files from Morocco (MAD), France (EUR) and the UAE (AED) will be combined into a group total. What must happen first?
السؤال 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?
السؤال 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?
السؤال 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?
السؤال 30In a right-skewed distribution, how do the mean and median usually compare?
السؤال 31An analyst wants to know whether product preference (three products) is related to customer region (four regions). Which test fits?
السؤال 32A test concludes that a new email design increases clicks, but in reality it has no effect. Which error occurred?
السؤال 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?
السؤال 34A SUM over an imported amount column returns 0 although the column shows values. What is the most likely cause?
السؤال 35The finance director asks for the result of a three-week pricing analysis before a board meeting tomorrow. What should the analyst send?
السؤال 36A manager wants to see how monthly website visits have changed over the last three years. Which visual is best?
السؤال 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?
السؤال 38Which visual best shows the distribution of delivery times, including the median, quartiles and outliers?
السؤال 39One sales dashboard must serve twelve regional managers, and each may see only their own region’s figures. What is the best design?
السؤال 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?
السؤال 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?
السؤال 42After release, an analyst finds a calculation error that overstated last quarter’s margin. What should she do?
السؤال 43Which document lists each field’s name, data type, allowed values and business definition?
السؤال 44An auditor asks how the revenue figure on the board dashboard was derived from source systems. What best answers this?
السؤال 45Call-centre staff must confirm a caller’s card by its last four digits but must not see the full number. Which control fits?
السؤال 46Under GDPR, how is data treated when names are replaced by codes but a separate key table can re-identify people?
السؤال 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?
السؤال 48The CRM and billing systems show different addresses for the same 4% of customers. Which data quality dimension is failing?
السؤال 49Which role is accountable for approving who may access a dataset and for what purpose?