Easy DA0-002 practice questions
Direct recall — confirm you know the core facts and definitions. 8 easy questions available — no sign-up, always free.
An analyst is preparing a customer contact list. The source table stores names in two separate columns, FirstName and LastName, but the marketing team's email tool requires a single FullName field formatted as 'LastName, FirstName'. Which transformation should the analyst apply to produce the required field?
A data governance team is establishing quality standards for a new customer database. They discover that 15% of customer records are missing a value in the required 'email' field. Which data quality dimension should the team use as the metric to track and report this specific problem?
A retail analyst has been asked to produce a monthly report that summarizes what happened last quarter: total units sold, average revenue per store, and the percentage change from the previous quarter. The stakeholders explicitly state they only want a clear summary of past performance, not forecasts or explanations of causes. Which type of analysis best fits this request?
A data analyst wants to experiment with a new transformation script and several untested queries that may run inefficiently or produce errors. The analyst needs an environment where these changes can be made freely without affecting live business reporting or the data used for pre-release validation. Which environment should the analyst use?
A retail analyst plots monthly online sales for the past three years. The scatter plot shows values steadily increasing over time with no repeating peaks and valleys and no sudden level shifts. Before building a forecast, the analyst wants to correctly label the dominant pattern present in the data. Which pattern best describes what the analyst observes?
An analyst is finalizing a financial summary report for a board of directors. The revenue figures are displayed as raw numbers such as '4823917' and '15602044', and several directors have complained that the values are hard to read and compare at a glance. What is the most appropriate formatting change to improve readability while preserving accuracy?
A retail analyst receives daily transaction totals from two store locations and wants the fastest, simplest measure to report how far apart the highest and lowest daily totals were at each store during the past week. Which measure of dispersion should the analyst use?
A retail analyst is inventorying the company's data assets to decide what can be loaded directly into a relational database without additional processing. Which of the following assets is already in a structured format that fits cleanly into rows and columns?