DA0-001 Exam Questions

Which one of the following is a measure of dispersion?

Which one of the following in NOT a common data integration tool?

Which one of the following is a common data warehouse schema?

What would be an example of an acceptable form of primary identification for the Data+ exam?

You are working with a professional statistician to perform an analysis and would like to use a statistics package. Which one of the following would be the most appropriate?

What SQL command is used to delete an entire table from a database?

Which one of the following programming languages is specifically designed for use in analytics applications?

What role in a data governance is typically responsible for day-to-day oversight of data use?

What category of data stewardship work is focused on ensuring that the organization respects the wishes of data subjects?

You are working with a dataset and need to swap the values in rows with those in columns. What action do you need to perform?

When analyzing the values of two variables, you decide to convert both variables so they are on a scale of 0 to 1. What term describes this action?

Taylor wants to investigate how manufacturing, marketing, and sales expenditures impact overall profitability for her company. Which of the following systems is the most appropriat...

Emma is working in a data warehouse and finds a finance fact table links to an organization dimension, which in turn links to a currency dimension that not linked to the fact table...

Encryption is a mechanism for protecting data. When should encryption be applied to data? Choose the best answer.

What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?

Which of the following roles is responsible for ensuring an organization's data quality, security, privacy, and regulatory compliance?

Jenny wants to study the academic performance of undergraduate sophomores and wants to determine the average grade point average at different points during an academic year. What b...

Mario works with a group of R programmers tasked with copying data from an accounting system into a data warehouse. In what phase are the group's R skills most relevant?

You would like to measure how well an organization is achieving its goals. What type of analysis should you perform?

Which one of the following would not normally be considered a summary statistic?

What analytics suite is offered by Microsoft and directly integrates with SQL Server Databases?

You should always choose the analytics tool that is most appropriate for any given situation, even if that means acquiring a new tool.

What R package makes it easy to work with dates?

You have two databases tables that you would like to join together using a foreign key relationship. What term best describes this action?

Which one of the following values will appear first if they are sorted in descending order?

Which one the following is not considered an aggregate function?

You are working with a dataset and want to change the names of categories that you used for different types of books. What term best describes this action?

Joseph is interpreting a left skewed distribution of test scores. Joe scored at the mean, Alfonso scored at the median, and gaby scored and the end of the tail. Who had the highest...

Kelly wants to get feedback on the final draft of a strategic report that has taken her six months to develop. What can she do to get prevent confusion as see seeks feedback before...

The sample customers table below is an example of which description of data?

An analyst binds a dashboard item to the data source shown in Exhibit 1. The analyst applies processing that results in the output shown in Exhibit 2. Which of the following statem...

A data analyst evaluates the data below. The analyst must present the cloud coverage percentage using the following scale: 0-33%: mostly sunny 34-66%: partly cloudy 67-100%: mostly...

An analyst performs a random survey at an entertainment event. The analyst gathers the ages for each survey participant: 32, 16, 81, 17, 50, 93, 24, 10, 67, 42, 89, 15, 76, 29, 33,...

Which of the following methods is used to permanently replace sensitive information with symbols or random characters?

A hypothesis test sometimes rejects the null hypothesis even if the true value of the population parameter is the same as the value in the null hypothesis. This type of result is k...

The sales of a grocery store had an average of $8,000 per day. The store introduced several advertising campaigns in order to increase sales. To determine whether the advertising c...

Given the diagram below. Which of the following types of sampling is depicted in the image?

A data analyst has a set with more than 40,000 rows in the sample schema below: The analyst would like to create one column that contains the customers' birth dates. Which of the f...

Given the table below. Which of the following boxes indicates that a Type Il error has occurred?

Which of the thing is the correct ion for a tab-delimited spre file?

A financial institution is reporting on sales performance to a company at the account level. Due to the sensitive nature of the government the does it with, some account informatio...

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

A data analyst needs to create a data visualization that aids in the cumulative impact of sequentially introduced values that are positive or negative. Which of the following data...

A data analyst is developing a dashboard to track and monitor metrics. Which of the following best practices should be taken into during the FIRST implement process?

A company derives proprietary leads from monthly sales calls and sends them to dealers through a connection that matches the correct leads to the correct dealers. Which of the foll...

Which of the following is an example of a data-mining ETL tool?

An analyst has conducted a review of business questions. Which of the following should the analyst do next to conduct an analysis?

A data analyst is compiling a report that a Chief Executive Officer needs for an impromptu meeting. The report should include information on the previous day's performance. Which o...

Which of the following tools would be best to use to calculate the interquartile range, median, mean, and standard deviation of a column in a table that has 5,000,000 rows?

Which of the following data acquisition concepts is the most appropriate for determining the quality of a company's product?