DA0-001 Exam Questions

Which of the following best describes the law of large numbers?

A C-suite executive would like to monitor KPIs for each department on a monthly basis. Which of the following explains why the executive wants to conduct this performance analysis?

An analyst is working on a project for a director. During this process, the analyst pulled the data, created summarized tables and graphs with descriptions, created a report summar...

A collections manager has a team calling customers who are past due on their accounts in an attempt to collect payments. The manager receives the call list in the form of a printed...

A data analyst is developing a data dictionary that aligns with a company's data management processes and policies. Which of the following best describes what should be included in...

After completing web scraping, which of the following file formats needs to be parsed?

A data analyst received the information in the table below from a recently completed marketing campaign: Which of the following is the total order conversion rate?

An analyst reviews the following table: Which of the following data types is represented in the values in the RefNo column?

Given the information in the following tables: Online transactions: In-store transactions: Which of the following describes merging these tables to create a master file that includ...

Given the image below: The data should be cleaned because of the presence of:

Several analysts are working simultaneously to compile a company's annual report and meet a tight deadline. Since each analyst is making changes, the analysts are concerned that th...

Data was previously stored in the following relational tables: A database architect changes the relational database structure to include an additional lookup table, which includes...

Which of the following BEST describes the difference between discrete and continuous values?

A survey asks participants to rate a company on a scale of one to ten. Which of the following BEST describes the rating variable?

A director who is responsible for reporting performance to executives has requested a dashboard for C-suite users who are not satisfied with the current multipage printed reports....

Which of the following statistical methods can be used to measure changes over time?

A feature can take certain values (A, B, C, D, E, and F) and represents a grade of students from a college. Which of the following variables does this describe?

Given the image below: Which of the following data schemas is portrayed?

Which of the following is a best practice when updating a legacy data source?

Which of the following BEST defines a data outlier?

An analyst needs to create a dashboard with three tiers of information: management, general public (internal users), and external stakeholders. The management team should be able t...

An analyst needs to modify an existing dashboard because data is often out of date. Which of the following is the BEST way for the analyst to help resolve the issue?

A data analyst has just finished cleansing a database table and is now ready to update the master. However, the analyst must first check to ensure all the work is accurate. Which o...

Which of the following data formats are examples of unstructured data? (Choose two.)

A data analyst is preparing a presentation for the company's board of directors. The presentation will not contain any confidential information and will only be provided to the boa...

Given the following table: Which of the following explains why this data set needs to be cleansed?

An analyst is summarizing the results from a recently completed survey. The results have been validated, but the analyst notices a few rows of data are missing at the bottom. For w...

Which of the following data analytics tools would be BEST to retrieve data from a relational database management system?

A data analyst is reviewing the results of a survey. Respondents used the terms "avg," "average," and "avg." throughout the survey in a response for the word "average." Because of...

A business analyst reviews the following text: txt = "I have registered for a certification exam and will take it within a couple of months. I need to work hard to pass the exam wi...

A customer's telephone number is in the format 123-456-7890. Which of the following data types is used for the phone number?

A team is planning to automate daily reporting for a company. Prior to this rollout, the team wants to determine how to ensure the data is refreshed at approximately the same time...

Which of the following describes a formal process for acquiring data from websites?

A data analyst needs to survey customers about their preferences for various types of soda. Which of the following sampling methods should the analyst use to collect the survey dat...

Given the following data set: Which of the following steps would be MOST appropriate to cleanse the data set?

An analyst notices changes in sales ratios when analyzing a quarterly report. Which of the following is the analyst conducting?

Which of the following is the BEST example of unstructured data?

A data analyst has received a data set that contains actual and projected sales for the fourth quarter of 2019. Which of the following statistical methods should the analyst use to...

A data analyst has received a list of customer names in alphabetical order that needs to instead be put in order by transaction date. Which of the following data manipulation techn...

A data analyst has been asked to find the mean, median, and mode of the distribution in the data shown below: Which of the following is the correct answer?

Which of the following is the correct extension for a tab-delimited spreadsheet file?

A data analyst needs to analyze a sales data set to identify the sales representatives who are selling the most units per month. Which of the following should the analyst perform?

Which of the following concepts should be applied if a data set with 40 fields needs to be pared down to 20 fields and contains similar data across multiple fields?

Which of the following is the BEST description of the term "data governance"?

In comparison to other data types, which of the following can hold a mix of numbers and letters?

Company A recently merged with Company B and will be reporting first quarter numbers soon. Prior to the release, an analyst wants to ensure the data was accurately blended together...

Given the following numbers: 7, 2, 3, 3, 5 Which of the following is the mean?

A data analyst has been asked to manipulate the data in the table below by first applying a DISTINCT function, and then applying a SUM function, to get the total product cost for a...

A market research firm has data sets based on surveys. A data analyst wants to know if any outliers are present in a data set. Which of the following would be the BEST method to ex...

A staff member is analyzing open-ended customer comments from an email survey. Which of the following is the EASIEST way to visualize the data?