Page 4 of 15 · 294 total questions.
Under which of the following circumstances should the null hypothesis be accepted when α = 0.05?
The correct answer is D. Option D: When p is 0.06
Which of the following is the first step an analyst should perform upon receiving a business request for analysis?
The correct answer is C. Option C: Review the business questions to understand the scope.
Which of the following data analytics tools are used to create advanced statistical visualizations? (Choose two).
The correct answer is C, E. Option C: Rapid mining Option E: Stata
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 loading time?
The correct answer is D. Option D: Optimize the dashboard.
A data analyst has a set with more than 40,000 rows in the sample schema below: The analyst would like to create one column that contains the customers’ birth dates. Which of the following data quality dimensions would best explain the reason for compilation?
The correct answer is B. Option B: Data completeness
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?
The correct answer is D. Option D: Data sources and attributes
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?
The correct answer is C. Option C: 2019 goal data
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 following is the alternative hypothesis?
The correct answer is C. Option C: There is a difference in a dancer’s flexibility between static and dynamic stretching.
Which of the following is the best reason to use database views instead of tables?
The correct answer is D. Option D: Views can be used to restrict sensitive information.
Which of the following would a data analyst look for first if 100% participation is needed on survey results?
The correct answer is A. Option A: Missing data
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?
The correct answer is B. Option B: Release the report as user-group-based access and include data masking.
Which of the following is an example of PII?
The correct answer is B. Option B: Name
Which of the following is the best technique for transferring data from one database to another with some data manipulation?
The correct answer is C. Option C: Extract, transform, load
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?
The correct answer is C. Option C: Microsoft Power BI
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?
The correct answer is B. Option B: A waterfall chart
Which of the following report types is most appropriate for a high-level, year-end report requested by a Chief Executive Officer?
The correct answer is C. Option C: Ad hoc
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?
The correct answer is C. Option C: Logical
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?
The correct answer is A. Option A: 147mm
Which of the following is a non-parametric test?
The correct answer is D. Option D: Spearman’s rank correlation
Which of the following best describes a 95% confidence interval?
The correct answer is A. Option A: There is a 95% probability that the population mean lies within the stated interval.
Showing questions 61–80 of 294 · Page 4 of 15