Think You're Ready?

Your Final Exam Before the Final Exam.
Dare to Take It?

Which of the following is a domain-specific language used in programming that is designed for managing data that is held in a relational data stream management system?

A. SAS

B. SQL

C. Python

D. R

B.   SQL

Given the following graph:

Which of the following summary statements upholds integrity in data reporting?

A. Sales are approximately equal for Product A and Product B across all strategies.

B. Strategy 4 provides the best sales in comparison to other strategies.

C. While Strategy 2 does not result in the highest sales of Product D, over all products it appears to be the most effective.

D. Product D should be promoted more than the other products in all strategies.

B.   Strategy 4 provides the best sales in comparison to other strategies.

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.

C.   Transform.

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.

B.   Determine the data needs and sources for 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

B.   A waterfall 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

D.   Report view

Which of the following contains alphanumeric values?

A. 10.1²

B. 13.6

C. 1347

D. A3J7

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

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

B.   6

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.

D.   The margin of error doubles.

Page 8 out of 40 Pages