A company wants to know how its customers interact with an e-commerce website based on clicks over items. Which of the following is the primary requirement for this report?

A. Data content

B. Frequency

C. Filtering

D. Views

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

A county in Illinois is conducting a survey to determine the mean annual income per household. The county is 427sq mi (2.65q km). Which of the following sampling methods would MOST likely result in a representative sample?

A. A stratified phone survey of 100 people that is conducted between 2:00 p.m. and 3:00 p.m.

B. A systematic survey that is sent to 100 single-family homes in the county

C. Surveys sent to ten randomly selected homes within 5mi (8km) of the county’s office

D. Surveys sent to 100 randomly selected homes that are reflective of the population

An analyst reviews the following data:
7
3
5
2
3
7
7
10
Which of the following is the value of the mode?

A. 3

B. 5

C. 7

D. 10

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

An e-commerce company recently tested a new website layout. The website was tested by a test group of customers, and an old website was presented to a control group. The table below shows the percentage of users in each group who made purchases on the websites:

Which of the following conclusions is accurate at a 95% confidence interval?

A. In Germany, the increase in conversion from the new layout was not significant.

B. In France, the increase in conversion from the new layout was not significant.

C. In general, users who visit the new website are more likely to make a purchase.

D. The new layout has the lowest conversion rates in the United Kingdom.

Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?

A. Duplicate data

B. Missing data

C. Data outliers

D. Invalid data type

Which of the following is an example of a data-mining ETL tool?

A. SSIS

B. Stata

C. SPSS

D. Cognos

An analyst wants to combine two data sets into a single spreadsheet. Column names from the first spreadsheet are listed in rows in the second spreadsheet. Which of the following is the first step the analyst should take to combine the data sets?

A. Blend

B. Merge

C. Concatenate

D. Transpose

An analysts building a monthly report for production and wants to ensure the audience is aware of its once-a-month cadence. Which of the following is the MOST important to convey that information?

A. The date of the dashboard build

B. The data refresh date

C. A report summary

D. Frequently asked questions

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.

An analyst is building a new dashboard for a user. After an initial conversation with the user. the analyst created a mock-up of the dashboard. Which of the following best explains why the analyst created the mock-up?

A. To identify the dimensions and measures

B. To send to the client after deploying the dashboard to production

C. To confirm important details before dashboard development begins

D. To receive client approval for the final dashboard design