DA0-001 Exam Questions

Given the following: Which of the following is the most important thing for an analyst to do when transforming the table for a trend analysis?

Which of the following is a difference between a primary key and a unique key?

Which of the following best describes how discrete data differs from continuous data?

Which of the following file formats is best suited to start exploratory analysis within statistical software?

An analyst wants to model the relationship between a set of continuous variables in order to predict the value of an output variable based on the values of a set of input variables...

A data analyst needs to create a dashboard using the company's yearly revenue data sets. Which of the following would be the best way to plot the information to show the top perfor...

The duration of a phone call in milliseconds is an example of:

Under which of the following circumstances should the null hypothesis be accepted when ?= 0.05?

Which of the following is the first step an analyst should perform upon receiving a business request for analysis?

Which of the following data analytics tools are used to create advanced statistical visualizations? (Choose two).

Joe, an analyst, tests the loading time on a dashboard he is preparing to go live and finds it is slower than he would like. Which of the following must occur to decrease the loadi...

Which of the following would be the BEST way to identify multicollinear attributes in a data set?

A data analyst is creating a dashboard and trying to identify the type of information that should be included. Which of the following should the analyst consider first?

A sales analyst needs to report how the sales team is performing to target. Which of the following files will be important in determining 2019 performance attainment?

A data analyst is using a two-tailed, independent t-test to determine whether the type of stretching, dynamic or static, has any influence on a dancer's flexibility. Which of the f...

An analyst computed a new variable of income per day in the household by multiplying the number of days worked by the number of people working in the household and the income earne...

Which of the following would a data analyst look for first if 100% participation is needed on survey results?

A sales director has requested a report for individual team members within the division be developed. The director would like the report to be shared with all team members, but ind...

Which of the following is an example of PII?

Which of the following is the best technique for transferring data from one database to another with some data manipulation?

Which of the following best describes a business analytics tool with interactive visualization and business capabilities and an interface that is simple enough for end users to cre...

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

Which of the following report types is most appropriate for a high-level, year-end report requested by a Chief Executive Officer?

A company's human resources department has asked a data analyst to categorize the income of all employees into five salary bands: Which of the following types of functions would be...

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

Which of the following is a non-parametric test?

Which of the following best describes a 95% confidence interval?

Which of the following technologies would be BEST suited for creating a multiple linear regression model?

A user imports a data file into the accounts payable system each day. On a regular basis, the field input is not what the system is expecting, so it results in an error for the row...

Given the table below: Which of the following numbers represents a Type I error?

A sales manager wants quarterly sales reports broken down by unit and week. Which of the following data output lists includes the most necessary information?

An analyst is preparing a report that contains weather data. The temperatures are shown in Fahrenheit, but they must be reported in Celsius. Which of the following should the analy...

Which of the following statements would be used to append two tables that have the same number of columns?

A data analyst has been asked to create a daily manufacturing report for the floor manager. Which of the following metrics should be included in the report?

A Chief Executive Officer (CEO) is requesting more up-to-date sales data for improved visibility prior to month-end. An analyst must determine the frequency of a sales report that...

A human resources analyst needs to build a new visualization to highlight the company's hierarchy. Which of the following would be the best way to do this?

Which of the following database schemas features normalized dimension tables?

A military commander would like to see the health scorecards of the troops daily and filter them based on gender and rank. Considering this data is PHI, which of the following woul...

Which of the following reports can be used when insight into operational performance is needed each Wednesday?

During data profiling, an analyst decides to recode the status column in the following data set: Which of the following data concerns explains why the analyst wants to take this ac...

Which of the following are reasons to conduct data cleansing? (Choose two).

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

An analyst needs to join two tables of data together for analysis. All the names and cities in the first table should be joined with the corresponding ages in the second table, if...

Which of the following is the most likely reason for a data analyst to optimize a query using parameterization?

A data analyst needs to collect a similar proportion of data from every state. Which of the following sampling methods would be the most appropriate?

A data analyst needs to perform a full outer join of a customer's orders using the tables below: Sales_table Order_table Which of the following is the mean of the order quantity?

An analyst must obtain the average daily sales for the following week: Which of the following must the analyst perform to obtain this value?

Which of the following best describes an exploratory analysis?

A site reliability team wants to monitor the stability of their website, so they can proactively diagnose issues when they occur. Which of the following deliverables would best sui...

Which of the following query optimization techniques involves examining only the data that is needed for a particular task?