DA0-001 Exam Questions

A data analyst needs to calculate the mean for Q1 sales using the data set below: Which of the following is the mean?

A data analyst is creating a report that will provide information about various regions, products, and time periods. Which of the following formats would be the MOST efficient way...

A customer list from a financial services company is shown below: A data analyst wants to create a likely-to-buy score on a scale from 0 to 100, based on an average of the three nu...

Which of the following actions should be taken when transmitting data to mitigate the chance of a data leak occurring? (Choose two.)

A data analyst has been asked to organize the table below in the following ways: - By sales from high to low - By state in alphabetic order Which of the following functions will al...

Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?

Which of the following is a process that is used during data integration to collect, blend, and load data?

An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step...

A data analyst has been asked to derive a new variable labeled "Promotion_flag" based on the total quantity sold by each salesperson. Given the table below: Which of the following...

Given the diagram below: Which of the following data schemas shown?

A company's marketing department wants to do a promotional campaign next month. A data analyst on the team has been asked to perform customer segmentation, looking at how recently...

A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out docu...

The number of phone calls that call center receives in a day is an example of:

A data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business's performance through the second quarter. Th...

Which of the following would be considered non-personally identifiable information?

Which of the following is the correct data type for text?

Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?

Which of the following is a common data analytics tool that is also used as an interpreted, high- level, general-purpose programming language?

A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on mar...

A data analyst for a media company needs to determine the most popular movie genre. Given the table below: Which of the following must be done to the Genre column before this task...

An e-commerce company recently tested a new website layout. The website was tested by a test group of customers, and an old website was presented to a control group. The table belo...

An analyst needs to provide a chart to identify the composition between the categories of the survey response data set: Which of the following charts would be BEST to use?

Five dogs have the following heights in millimeters: 300, 430, 170, 470, 600 Which of the following is the mean height for the five dogs?

Which of the following are reasons to create and maintain a data dictionary? (Choose two.)

A recurring event is being stored in two databases that are housed in different geographical locations. A data analyst notices the event is being logged three hours earlier in one...

Which of the following is an example of a at flat file?

Given the following graph: Which of the following summary statements upholds integrity in data reporting?

An analyst is required to run a text analysis of data that is found in articles from a digital news outlet. Which of the following would be the BEST technique for the analyst to ap...

An analyst runs a report on a daily basis, and the number of datapoints must be validated before the data can be analyzed. The number of datapoints increases each day by approximat...

An analyst has been tracking company intranet usage and has been asked to create a chat to show the most-used/most-clicked portions of a homepage that contains more than 30 links....

An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000: Which of the following functions did the analyst...

While reviewing survey data, an analyst notices respondents entered "Jan," "January," and "01" as responses for the month of January. Which of the following steps should be taken t...

Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

A county in Illinois is conducting a survey to determine the mean annual income per household. The county is 427sq mi (2.65q km). Which of the following sampling methods would MOST...

Which of the following statistical methods requires two or more categorical variables?

Which of the following data manipulation techniques is an example of a logical function?

A sales team wants visibility of current sales numbers, pipeline, and team performance. The team would also like to see calculations of individuals' earned commissions and projecte...

Which of the following is a characteristic of a relational database?

A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Wh...

Given the following data tables: Which of the following MDM processes needs to take place FIRST?

Which of the following is used for calculations and pivot tables?

Given the following report: Which of the following components need to be added to ensure the report is point-in-time and static? (Choose two.)

An analyst has been asked to validate data quality. Which of the following are the BEST reasons to validate data for quality control purposes? (Choose two.)

A research analyst wants to determine whether the data being analyzed is connected to other datapoints. Which of the following is the BEST type of analysis to conduct?

Which of the following variable name formats would be problematic if used in the majority of data software programs?

Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?

Given the following customer and order tables: Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the t...

A development company is constructing a new unit in its apartment complex. The complex has the following floor plans: Using the average cost per square foot of the original floor p...

Which of the following is a control measure for preventing a data breach?

A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the f...