Mario works with a group of R programmers tasked with copying data from an accounting system into a data warehouse.

In what phase are the group's R skills most relevant?

A. Extract.

B. Load.

C. Transform.

D. Purge.

An analyst has conducted a review of business questions. Which of the following should the analyst do next to conduct an analysis?

A. Determine the data needs and review the observations.

B. Determine the data needs and sources for analysis.

C. Determine the data needs and schedule interviews.

D. Determine the data needs and begin the analysis.

A data analyst needs to create a data visualization that aids in un 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

A data analyst needs to write a SOL query measuring last month's website visits and distribute a summary report to the marketing team. Which of the following is the analyst creating?

A. Date range

B. Distribution list

C. Data content

D. Report view

Which of the following contains alphanumeric values?

A. 10.1²

B. 13.6

C. 1347

D. A3J7

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 performing region?

A. A line chart

B. A waterfall chart

C. A heat map

D. A stacked bar chart

Which of the following is the median of the number set:3, 7, 5, 6, 9?

A. 5

B. 6

C. 7

D. 9

Which of the following occurs if a 90% confidence interval increases to 95%?

A. The margin of error does not change.

B. The interval remains the same.

C. The interval becomes narrower.

D. The margin of error doubles.

A stakeholder wants to see daily sales targets organized in a dashboard by country, state, city, and ZIP Code. Which of the following delivery considerations must a data analyst take into account when creating the dashboard?

A. Variable formatting

B. Drill-down capability

C. Saved searches

D. Access permissions

A dataset requires an analysis for investigating and discovering abnormalities. Which of the following best describes the nature of the exploratory analysis conducted?

A. Summary of the data's main characteristics

B. Best data tuning method

C. Set of methods for cleaning the data

D. Method of checking the quality of the data

Q3 2020 has just ended, and now a data analyst needs to create an ad-hoc sales report that demonstrates how well the Q3 2020 promotion went versus last year's Q3 promotion.

Which of the following date parameters should the analyst use?

A. 2019 vs. YTD 2020

B. Q3 2019 vs. Q3 2020

C. YTD 2019 vs. YTD 2020

D. Q4 2019 vs. Q3 2020

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 can be completed?

A. Append

B. Merge

C. Concatenate

D. Delimit