DA0-001 Exam Questions

Which of the following query optimization techniques is the best way for an analyst to make the query execute faster?

Which of the following measurements are best stored as continuous data? (Choose two.)

Which of the following software tools is the best to use in preparing a data dashboard for an executive team?

An analyst is combining two files to create one data set. The first file contains data about schools. The second file contains data about factories. Both files have the following s...

An analyst for a concert venue is analyzing the number of tickets sold for a recent event. Which of the following types of data is the number of sold tickets an example of?

A data analyst wants to use data manipulation to store newly acquired data. Which of the following techniques should the analyst use?

A business manager wants monthly sales reports produced in a way that sales differentiations can easily be seen. Which of the following analysis techniques should the manager use?

A health care data analyst is reviewing records to ensure that the height attribute is within a specific range, as values outside of the range could indicate measurement errors. Th...

Which of the following types of analyses should an analyst use to examine the changes in TV viewership over time?

A data analyst is creating a dashboard with a requirement that users should be able to click on specific data points to view more detailed information. Which of the following shoul...

Which of the following methods is a business analyst most likely to use when checking sales against performance goals?

Which of the following terms best describes data that is not logically consistent with the analyzed context worksheet and may be a reason for data cleansing?

A client requested a biweekly report that highlights the performance of advertising campaigns. The client would also like to see trends and changes over time. Which of the followin...

Which of the following should an analyst use to determine the relationship between the years of schooling and amount of income earned?

A data analyst is working for a shipping company and calculating the volume of boxes according to the following formula: volume = height × width × depth. Which of the following var...

As a result of using a function in a spreadsheet, an analyst received the conversion of rows into columns and columns into rows. Which of the following functions did the analyst us...

Given the following data: Which of the following methods should an analyst apply to the data?

Which of the following tools should an analyst use to non-programmatically develop a visualization?

A group is developing a time-series forecast for future sales. Which of the following is the best way to show possible values for future eras?

A manufacturing company's management team wants to receive regular updates on production metrics without having to manually access the dashboard. The company would like to be autom...

An analyst is comparing two different standardized test training programs to determine whether a significant difference exists in the average scores of test takers in the two progr...

Given the following athlete workout data: Which of the following best describes the data quality issue?

A business intelligence analyst needs to show the frequency of search terms at a new website. Which of the following is the best way to show the results?

Which of the following techniques is the most appropriate for analyzing the geographical distribution of a disease?

A data analyst needs to determine which size of shirt is likely to be the most popular at a store. Shirts come in small, medium, and large sizes. Which of the following is the best...

An analyst is creating a self-serve report that allows users to see performance data for up to 30 days prior. Which of the following steps will allow users to obtain the data they...

A data analyst must develop an interactive dashboard that is connected to a real-time database for the sales team. Which of the following is the best analysis tool for this task?

A data analyst is using unstructured data for a machine-learning project. Which of the following is the data most likely to contain? (Choose three.)

Which of the following is an example of non-structured data?

Which of the following query techniques allows an analyst to select data based on date value?

A data set contains the gender and age in weeks of calves born at four different farms. Which of the following charts is the best type of visualization for this scenario?

An analyst wants to extract information about calves younger than six weeks from a database containing data on calves born within the past year. Which of the following data operati...

Which of the following is an example of a strategy to reduce statistical errors?

A data analyst is trying to improve the accuracy of a collection of customer data. The data analyst needs to verify whether the data is correctly recorded as integers and within a...

Which of the following policies is included in a data user requirement guideline?

A marketing team is finalizing a comprehensive performance report for an upcoming board meeting. The report contains sensitive financial information and is intended for a specific...

A botanist wants to know whether seedling heights planted in a nursery vary greatly. Which of the following is the best approach to use?

A data architect is designing a data solution for a retail clothing store chain. Each store has a database that tracks sales transactions. The data architect needs to create a summ...

Which of the following data analytics tools allows users to store data, retrieve advanced analytics and statistics, and create reports?

Which of the following is the most likely format for an API to use to exchange data?

A nutritionist wants to determine the association between various types of children's diets and the overall health of these children. Which of the following is best suited for this...

Which of the following actions would be most appropriate for initial, exploratory data analysis on a categorical variable of a data set?

A health care data analyst is reviewing a data set containing patient blood pressure measurements taken over the past year. The analyst notices that some of the values for blood pr...

Which of the following would the value "January 15, 23" be classified as?

A financial director needs a report that is focused on the most important data. Which of the following should an analyst do to create a report that meets this need?

A data analyst who works for a government agency is required to obtain the average income of citizens. The list of citizens is given in the following table: A value for one citizen...

A data set has the following values: Which of the following is the best reason for cleansing the data?

Which of the following functions would the use of not in a database query be an example of?