DA0-001 Exam Questions

Given the following data table: Which of the following are appropriate reasons to undertake data cleansing? (Select two).

A data analyst must fulfill a request for information that is needed weekly and should be automatically emailed to a specific set of users. Which of the following types of reports...

A data analyst needs to create a master file that includes customer information from the tables below: Given the three tables above, the analyst wants to filter down the informatio...

An analyst is designing a dashboard that will provide a story of the sales and sales customer ratio. The following data is available: Which of the following charts should the analy...

Which of the following describes the use of a representative amount of data from a main repository?

Which of the following is the best description of discrete data types?

Which of the following data governance concepts fits into the security requirements category?

A stakeholder wants to see daily sales targets organized in a dashboard by country, state, city, and ZIP Code. Which of the following delivery considerations must a data analyst ta...

Which of the following should an analyst do to best summarize the data on a data set?

Which of the following data types must be used when working with variables that require classification into two or more groups before analysis?

An organization would like to add a secondary email field to its customer database in order toenrich the customer profiles. Which of the following data manipulation techniques shou...

Which of the following is the best variable formal to store a customer's age using the least possible amount of storage data?

A gambler thinks that a coin is fair and is equally likely to turn up heads or tails when the coin is flipped. Which of the following tests should the gambler use to fest this hypo...

An analyst needs to summarize the number of people in Chicago in 2022 using the following set of data: Which of the following steps should the analyst use to provide results? (Choo...

An analyst wants to combine two data sets into a single spreadsheet. Column names from the first spreadsheet are listed in rows in the second spreadsheet. Which of the following is...

Which of the following programming languages are best suited for analysis and machine-learning applications? (Choose two.)

Which of the following is most likely to be used as a data-mining ETL tool?

A company notifies its employees that emails will be automatically moved to a cloud-based server in 180 days. Which of the following describes this concept?

An analyst wants to check the progress and performance regarding the number of customers an organization served in the last six years. Which of the following represents the type of...

A business unit made the following modification to the values in a table: Which of the following data quality dimensions was applied in this scenario?

A reporting analyst is creating a dashboard that shows the year-over-year performance for a sales organization. Which of the following is the best visual for the analyst use to ill...

Which of the following query statements would be used when filtering data in a relational database management system? (Choose two.)

Which of the following is an object associated with a table that sorts and stores table row data in a key-value pair?

An analyst is working with a data set that lists individuals' first and last names in separate columns. Which of the following processes should the analyst use to combine the first...

A data analyst reviews the following data set: Which of the following is the range value?

An analyst collected data that includes primary account numbers, expiration dates, and service codes. Which of the following data governance classifications is used to describe thi...

An analyst in a consumer bank department wants to showcase the concentration of accounts opened in the United States by ZIP Code to describe the effectiveness of the bank's marketi...

A data analyst needs to write a SOL query measuring last month's website visits and distribute a summary report to the marketing team. Which of the following is the analyst creatin...

A data analyst is helping a retail store categorize its customers into five different groups based on the following information: - How recently the customers made purchases - How f...

Which of the following is a relational database?

An analyst wants to extract data from a variety of sources and store the data in a cloud-based environment prior to cleaning. Which of the following integration techniques should t...

A data analyst needs to apply quality control concepts to a data set for accuracy. Which of the following is the best way to do this?

A client has requested an analysis of all pet care items purchased by current customers and their social media connections in the past 12 months. Which of the following data analys...

Which of the following is the best approach to use to gain a general understanding of a data set?

A salesperson who is prospecting potential clients collected the following data: Which of the following is an issue with this data?

Given the following table: Which of the following methods is the best way to describe the changes in the values in the table?

During data cleansing, an analyst conducts measures of central tendency on a data set. Which of the following data is the analyst attempting to identify?

An analyst needs to determine the appropriate data type for the following sample data: Sample data collected: 5.99 Which of the following data types should be used for this data?

Which of the following types of analysis is used when comparing last week's sales to the previous week's sales?

Which of the following data protection methods provides confidentiality for data in transit?

A business intelligence team wants to create a new dashboard in order to solve a problem statement. Which of the following is the correct order of steps the team should take?

A column is being used to store strings of variable lengths. Performance is a concern, so the column needs to use as little space as possible. Which of the following data types bes...

A data analyst has been asked to create one table that has each employee's first name, last name, sales, and address. The sales and addresses are listed in the tables below: Which...

Which of the following types of analyses should be used to evaluate the connections and anomalies in a data set when either known patterns are being violated or new patterns are em...

Which of the following data manipulation techniques should an analyst use to hide unnecessary data during analysis?

An analyst wants to create a historical data set for the past five years with each year in its own data set. Which of the following methods is the best way to create this historica...

A data set for sales per month includes the following data: Which of the following cleaning and profiling methods should be applied to the data set?

The total values in this month's revenue report are twice as much as last month's. Which of the following most likely occurred during the ETL process?

An analyst is reporting on the average income for a county and is reviewing the following data: Which of the following is the reason the analyst would need to cleanse the data in t...

A company wants to know how its customers interact with an e-commerce website based on clicks over items. Which of the following is the primary requirement for this report?