DA0-001 Exam Questions

A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of:

While reviewing survey data, a research analyst notices data is missing from all the responses to a single question. Which of the following methods would BEST address this issue?

Which of the following BEST describes standard deviation?

A data analyst was asked to create a chart that shows the relationship between study hours and exam scores for each student using the data sets in the table below: Which of the fol...

Given the table below: Which of the following variable types BEST describes the "Year" column?

Given the following data: Which of the following BEST describes the data set?

An analysts building a monthly report for production and wants to ensure the audience is aware of its once-a-month cadence. Which of the following is the MOST important to convey t...

An analyst is working with the income data of suburban families in the United States. The data set has a lot of outliers, and the analyst needs to provide a measure that represents...

Which of the following would be used to store unstructured data from different sources?

An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. T...

A cereal manufacturer wants to determine whether the sugar content of its cereal has increased over the years. Which of the following is the appropriate descriptive statistic to us...

The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:

Different people manually type a series of handwritten surveys into an online database. Which of the following issues will MOST likely arise with this data? (Choose two.)

Which of the following data sampling methods involves dividing a population into subgroups by similar characteristics?

A data analyst must separate the column shown below into multiple columns for each component of the name: Which of the following data manipulation techniques should the analyst per...

Which of the following descriptive statistical methods are measures of central tendency? (Choose two.)

Which of the following will MOST likely be streamed live?

A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalize...

Randy scored 76 on a math test, Katie scored 86 on a science test, Ralph scored 80 on a history test, and Jean scored 80 on an English test. The table below contains the mean and s...

Given the data below: In which of the following file formats is the data presented?

A commissions analyst has just completed second-quarter payout statements. The analyst created a dashboard to distribute the statements as quickly as possible. Which of the followi...

The current date is July 14, 2020. A data analyst has been asked to create a report that shows the company's year-over-year Q2 2020 sales. Which of the following reports should the...

A data analyst is designing a dashboard that will provide a story of sales and determine which site is providing the highest sales volume per customer. The analyst must choose an a...

An analyst needs to conduct a quick analysis. Which of the following is the FIRST step the analyst should perform with the data?

A data analyst has been asked to create a sales report that calculates the rolling 12-month average for sales. If the report will be published on November 1, 2020, which of the fol...

A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN: Customer Table In-store Transactions Which of the following describes...

A data analyst needs to create a weekly recurring report on sales performance and distribute it to all sales managers. Which of the following would be the BEST method to automate a...

Which of the following is an example of a discrete variable?

Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?

Q3 2020 has just ended, and now a data analyst needs to create an ad-hoc sales report that demonstrates how well the Q3 2020 promotion went versus last year's Q3 promotion. Which o...

A data analyst has been asked to create an ad-hoc sales report for the Chief Executive Officer (CEO). Which of the following should be included in the report?

Which of the following can be used to translate data into another form so it can only be read by a user who has a key or a password?

Which of the following is an example of a discrete data type?

Which of the following contains alphanumeric values?

A junior web developer is developing a new application where users can upload short videos. The first task is to create a homepage that shows the headline "Upload Your Short Videos...

A web developer wants to ensure that malicious users can't type SQL statements when they asked for input, like their username/userid. Which of the following query optimization tech...

Consider the following dataset which contains information about houses that are for sale: Which of the following string manipulation commands will combine the address and region na...

The ACME Corporation hired an analyst to detect data quality issues in their excel documents. Which of the following are the most common issues? (Select TWO)

Consider this dataset showing the retirement age of 11 people, in whole years: 54, 54, 54, 55, 56, 57, 57, 58, 58, 60, 60 This tables show a simple frequency distribution of the re...

Which of the following value is the measure of dispersion "range" between the scores of ten students in a test. The scores of ten students in a test are 17, 23, 30, 36, 45, 51, 58,...

A data scientist wants to see which products make the most money and which products attract the most customer purchasing interest in their company. Which of the following data mani...

A data analyst wants to create "Income Categories" that would be calculated based on the existing variable "Income". The "Income Categories" would be as follows: Income category 1:...

Angela is aggregating data from CRM system with data from an employee system. While performing an initial quality check, she realizes that her employee ID is not associated with he...

Andy is a pricing analyst for a retailer. Using a hypothesis test, he wants to assess whether people who receive electronic coupons spend more on average. What should Andy's null h...

Amanda needs to create a dashboard that will draw information from many other data sources and present it to business leaders. Which one of the following tools is least likely to m...

Daniel is using the structured Query language to work with data stored in relational database. He would like to add several new rows to a database table. What command should he use...

Jhon is working on an ELT process that sources data from six different source systems. Looking at the source data, he finds that data about the sample people exists in two of six s...

Samantha needs to share a list of her organization's top 50 customers with the VP of sales. She would like to include the name of the customer, the business they represent, their c...

Alex wants to use data from his corporate sale, CRM, and shipping systems to try and predict future sales. Which of the following systems is the most appropriate? Choose the best a...

Analytics reports should follow corporate style guidelines.