DA0-001Preview

Which of the following is the best reason to use database views instead of tables?

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 individual team members should not be identifiable within the report. Which of the following access requirements would support the director’s needs?

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 create their own reports and dashboards?

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 following data visualization methods should the analyst use?

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:

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?

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 customer bought product, at what frequency, and at what value. Which of the following types of analysis would this practice be considered?

Which of the following is a non-parametric test?

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

Given the table below:

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 and a broken import process. To resolve the issue, the user opens the file, finds the error in the row, and manually corrects it before attempting the import again. The import sometimes breaks on subsequent attempts, though.

Which of the following changes should be made to this process to reduce the number of errors?

Given the table below:

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 analyst do to fix this issue?

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 was previously distributed on an as-needed basis.

Which of the following would be the most appropriate frequency for this report?

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 documents and editing them before submissions are considered final. Which of the following is the BEST way to meet this stakeholder requirement?

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?