DA0-001
Free trial
Verified
Question 1
A data analyst needs to calculate the mean for Q1 sales using the data set below:
Which of the following is the mean?
- A: $2,466.18
- B: $2,667.60
- C: $3,082.72
- D: $12,330.88
Question 2
Given the diagram below:
Which of the following data schemas shown?
- A: Key-value pairs
- B: Online transactional processing
- C: Data lake
- D: Relational database
Question 3
Which of the following is the best reason to use database views instead of tables?
- A: Views reduce the need for repetitive, complex data joins.
- B: Views allow for the storage of temporary data, whereas tables do not.
- C: Views allow for the joining of multiple data sources, whereas tables do not.
- D: Views can be used to restrict sensitive information.
Question 4
Which of the following would a data analyst look for first if 100% participation is needed on survey results?
- A: Missing data
- B: Invalid data
- C: Redundant data
- D: Duplicate data
Question 5
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?
- A: Create an acceptable use policy for the sales data.
- B: Release the report as user-group-based access and include data masking.
- C: Get a data use agreement from the individual team members.
- D: Provide the report based on role and include data encryption.
Question 6
Which of the following is an example of PII?
- A: Age
- B: Name
- C: Ethnicity
- D: Gender
Question 7
Which of the following is the best technique for transferring data from one database to another with some data manipulation?
- A: Application programming interfaces
- B: Delta load
- C: Extract, transform, load
- D: Export/import
Question 8
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: Python
- B: R
- C: Microsoft Power BI
- D: SAS
Question 9
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?
- A: A bubble chart
- B: A waterfall chart
- C: A scatter plot
- D: A line chart
Question 10
Which of the following report types is most appropriate for a high-level, year-end report requested by a Chief Executive Officer?
- A: Dynamic
- B: Recurring
- C: Ad hoc
- D: Self-service
Question 11
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 the most appropriate to use?
- A: Statistical
- B: Aggregate
- C: Logical
- D: Mathematical
Question 12
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: 147mm
- B: 154mm
- C: 394mm
- D: 21,704mm
Question 13
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?
- A: Prescriptive
- B: Trend
- C: Gap
- D: Custer
Question 14
Which of the following is a non-parametric test?
- A: One-sample t-test
- B: Two-way ANOVA
- C: Correlation coefficient
- D: Spearman’s rank correlation
Question 15
Which of the following best describes a 95% confidence interval?
- A: There is a 95% probability that the population mean lies within the stated interval.
- B: A stated range may contain 95% of the population mean, 95% of the time.
- C: A set of ranges contains the population mean with 95% certainty.
- D: A range contains 95% of the population mean.
Question 16
Given the table below:
Which of the following boxes indicates that a Type II error has occurred?
- A: 1
- B: 2
- C: 3
- D: 4
Question 17
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?
- A: Delete all incorrect inputs and upload the corrected file.
- B: Have the user manually review the file for data completeness before loading it.
- C: Create a data field to data type validator to run the file through prior to import.
- D: Spot-check the file prior to import to catch and correct field errors.
Question 18
Given the table below:
Which of the following numbers represents a Type I error?
- A: 1
- B: 2
- C: 3
- D: 4
Question 19
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?
- A: Order number, salesperson, date shipped, recipient address, and price
- B: Item name, salesperson, recipient address, shipping cost, and date shipped
- C: Item number, item name, salesperson, date sold, and price
- D: Item name, salesperson, price, shipping cost, and date shipped
Question 20
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?
- A: Normalize the data.
- B: Standardize the data.
- C: Rescale the data.
- D: Aggregate the data.
Question 21
Which of the following statements would be used to append two tables that have the same number of columns?
- A: UNION ALL
- B: MERGE
- C: GROUP BY
- D: JOIN
Question 22
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: Tons of steel produced per hour
- B: Annual sales budget
- C: End-of-day stock price
- D: Daily corporate employee count
Question 23
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: Monthly
- B: Quarterly
- C: Weekly
- D: Every other month
Question 24
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: Display the version number next to each submission on the dashboard.
- B: Present a data refresh date at the top of the dashboard.
- C: Confirm the dashboard is adhering to the corporate style guide.
- D: Use permissions to ensure users only see certain versions of the submissions.
Question 25
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?
- A: A stacked chart
- B: An infographic
- C: A word cloud
- D: A tree map
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!