A market research firm has data sets based on surveys. A data analyst wants to know if any outliers are present in a data set. Which of the following would be the BEST method to examine the numerical variables in the data set visually and find any outliers?

A. Plot the linear correlations between each pair of variables and look for unusual relationships

B. Create a bar chart for each variable and look for any distributions that are unusual.

C. Build a scatter plot of each variable and look for observations that are out of place.

D. Order each variable in a spreadsheet from lowest to highest and look for unusual numbers at the beginning or at the end of the list.

Given the following numbers:
7, 2, 3, 3, 5
Which of the following is the mean?

A. 2

B. 3

C. 4

D. 7

Which of the following is a best practice when updating a legacy data source?

A. Placing old data in new fields

B. Keeping only the most recent data

C. Creating a codebook to document field changes

D. Removing the data source from production

Which of the following is the correct data type for text?

A. Boolean

B. String

C. Integer

D. Float

Which of the following descriptive statistical methods are measures of central tendency? (Choose two.)

A. Mean

B. Minimum

C. Mode

D. Variance

E. Correlation

F. Maximum

A data analyst has been asked to manipulate the data in the table below by first applying a DISTINCT function, and then applying a SUM function, to get the total product cost for a customer:
 
Which of the following is the final cost of the product?

A. $5,402

B. $6,297

C. $7,634

D. $8,642

An analyst is working on a project for a director. During this process, the analyst pulled the data, created summarized tables and graphs with descriptions, created a report summary, and inserted all items into a report. After writing the report, which of the following would be the most appropriate next step?

A. Complete an audit on the data pulled for the report.

B. Complete a check for quality in the report.

C. Complete a review of the data and a check for consistency.

D. Complete a trend analysis to be included in the report.

Which of the following are reasons to create and maintain a data dictionary? (Choose two.)

A. To improve data acquisition

B. To remember specifics about data fields

C. To specify user groups for databases

D. To provide continuity through personnel turnover

E. To confine breaches of PHI data

F. To reduce processing power requirements

An analyst is summarizing the results from a recently completed survey. The results have been validated, but the analyst notices a few rows of data are missing at the bottom. For which of the following data qualities does this present the GREATEST issue?

A. Data completeness

B. Data integrity

C. Data consistency

D. Data accuracy

A data analyst is creating a report that will provide information about various regions, products, and time periods. Which of the following formats would be the MOST efficient way to deliver this report?

A. A workbook with multiple tabs for each region

B. A daily email with snapshots of regional summaries

C. A static report with a different page for every filtered view

D. A dashboard with filters at the top that the user can toggle

A data analyst has been asked to find the mean, median, and mode of the distribution in the data shown below:
 
Which of the following is the correct answer?

A. Mean: 5 -Median: 3 -Mode: 7 –

B. Mean: 5 -Median: 7 -Mode: 7 –

C. Mean: 6 -Median: 3 -Mode: 7 –

D. Mean: 6 -Median: 7 -Mode: 7

Given the following report:
 
Which of the following components need to be added to ensure the report is point-in-time and static? (Choose two.)

A. A control group for the phrases

B. A summary of the KPIs

C. Filter buttons for the status

D. The date when the report was last accessed

E. The time period the report covers

F. The date on which the report was run

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?

A. Data refresh rate

B. Consumer types

C. Access permissions

D. Data sources and attributes

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

Given the following customer and order tables:
 
 
Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?

A. Five rows, eight columns

B. Seven rows, eight columns

C. Eight rows, seven columns

D. Nine rows, five columns

Given the following:
 
Which of the following is the most important thing for an analyst to do when transforming the table for a trend analysis?

A. Fill in the missing cost where it is null.

B. Separate the table into two tables and create a primary key.

C. Replace the extended cost field with a calculated field.

D. Correct the dates so they have the same format.

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

A data analyst is designing a dashboard that will provide a story of sales and determine which site is providing the highest sales volume per customer. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:
 
Which of the following types of charts should be considered?

A. Include a line chart using the site and average sales per customer.

B. Include a pie chart using the site and sales to average sales per customer.

C. Include a scatter chart using sales volume and average sales per customer.

D. Include a column chart using the site and sales to average sales per customer.

A survey asks participants to rate a company on a scale of one to ten. Which of the following BEST describes the rating variable?

A. Continuous

B. Ordinal

C. Categorical

D. Nominal

An analyst is working with the income data of suburban families in the United States. The data set has a lot of outliers, and the analyst needs to provide a measure that represents the typical income. Which of the following would BEST fulfill the analyst’s goal?

A. Median

B. Mean

C. Mode

D. Standard deviation

Five dogs have the following heights in millimeters:
300, 430, 170, 470, 600
Which of the following is the mean height for the five dogs?

A. 394mm

B. 405mm

C. 493mm

D. 504mm

A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment. Which of the following should the data analyst use to BEST communicate this information to the manager?

A. A real-time monitor that allows the manager to view performance the day the campaign was launched

B. A sell-service dashboard that allows the manager to look at the company’s annual budget performance

C. A spreadsheet of the raw data from all marketing campaigns and channels

D. A summary with statistics, conclusions, and recommendations from the data analyst

The accounting team has requested a series of self-serve, dynamic reports. Aside from the reporting time frame, the report criteria are identical. Which of the following should the analyst create?

A. A single report with the option to select the date range

B. One consolidated report with all available data

C. Automated reports to be distributed based on the time frames in the requirements

D. The reports as requested in the requirements document

A data analyst is reviewing the results of a survey. Respondents used the terms “avg,” “average,” and “avg.” throughout the survey in a response for the word “average.” Because of this, the analyst changed all related answers to say “average.” Which of the following are reasons why the analyst MOST likely made these changes? (Choose two.)

A. Data attribute limitations

B. Data accuracy

C. Data completeness

D. Data manipulation

E. Data blending

F. Data consistency

Which of the following BEST describes the difference between discrete and continuous values?

A. Discrete values change.

B. Discrete values are not distinct.

C. Continuous values are restricted by separation.

D. Discrete values are obtained by counting.

Company A recently merged with Company B and will be reporting first quarter numbers soon. Prior to the release, an analyst wants to ensure the data was accurately blended together. Which of the following is the MOST efficient way to ensure the data is reported correctly?

A. Assume the data was blended together and wait for feedback.

B. Filter on every column to look for inconsistencies in the data.

C. Spot check a few numbers to look for inconsistencies.

D. Review the files separately and ensure the blended totals match.

Which of the following would be considered non-personally identifiable information?

A. Cell phone device name

B. Customer’s name

C. Government ID number

D. Telephone number

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

A collections manager has a team calling customers who are past due on their accounts in an attempt to collect payments. The manager receives the call list in the form of a printed report that is generated by the accounting department at the beginning of each week. Consequently, the collections team calls some customers who have made payments in the time since the report was last printed. Which of the following reporting enhancements could the accounting department implement to best reduce the number of calls on current accounts?

A. Modify the date range on the report.

B. Include a time stamp on the report.

C. Increase the frequency of report generation.

D. Add a report run date to the report.

An analyst is required to run a text analysis of data that is found in articles from a digital news outlet. Which of the following would be the BEST technique for the analyst to apply to acquire the data?

A. Web scraping

B. Sampling

C. Data wrangling

D. ETL

A data analyst needs to create a weekly recurring report on sales performance and distribute it to all sales managers. Which of the following would be the BEST method to automate and ensure successful delivery for this task?

A. Use scheduled report delivery.

B. Implement subscription access delivery.

C. Print out a copy.

D. Upload the report to the server.

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

An analyst has been tracking company intranet usage and has been asked to create a chat to show the most-used/most-clicked portions of a homepage that contains more than 30 links. Which of the following visualizations would BEST illustrate this information?

A. Scatter plot

B. Heat map

C. Pie chart

D. Infographic

Given the image below:
 
Which of the following data schemas is portrayed?

A. Non-relational

B. Galaxy

C. Snowflake

D. Star

Given the following table:
 
Which of the following explains why this data set needs to be cleansed?

A. Redundant data

B. Invalid data

C. Duplicate data

D. Missing data

Which of the following is the first step an analyst should perform upon receiving a business request for analysis?

A. Determine the data needs and sources for analysis.

B. Initiate the analysis for exploratory data analysis.

C. Review the business questions to understand the scope.

D. Finalize the methodology to solve the problem.

Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?

A. Simple random

B. Cluster

C. Systematic

D. Stratified

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?

A. 2018 goal data

B. 2018 actual revenue

C. 2019 goal data

D. 2019 commission plan

Different people manually type a series of handwritten surveys into an online database. Which of the following issues will MOST likely arise with this data? (Choose two.)

A. Data accuracy

B. Data constraints

C. Data attribute limitations

D. Data bias

E. Data consistency

F. Data manipulation

Which of the following is an example of a at flat file?

A. CSV file

B. PDF file

C. JSON file

D. JPEG file

An analyst runs a report on a daily basis, and the number of datapoints must be validated before the data can be analyzed. The number of datapoints increases each day by approximately 20% of the total number from the day before. On a given day, the number of datapoints was 8,798. Which of the following should be the total number of datapoints on the next day?

A. 7,038

B. 9,600

C. 10,600

D. 10,800

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.

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

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

The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:

A. a t-test.

B. a performance analysis.

C. an exploratory data analysis.

D. a link analysis.

While reviewing survey data, an analyst notices respondents entered “Jan,” “January,” and “01” as responses for the month of January. Which of the following steps should be taken to ensure data consistency?

A. Delete any of the responses that do not have “January” written out.

B. Replace any of the responses that have “01”.

C. Filter on any of the responses that do not say “January” and update them to “January”.

D. Sort any of the responses that say “Jan” and update them to “01”.

An analyst has been asked to validate data quality. Which of the following are the BEST reasons to validate data for quality control purposes? (Choose two.)

A. Retention

B. Integrity

C. Transmission

D. Consistency

E. Encryption

F. Deletion

An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:
 
Which of the following types of charts should be considered to BEST display the data?

A. Include a bar chart using the site and the percentage of new customers data.

B. Include a line chart using the site and the percentage of new customers data.

C. Include a pie chat using the site and percentage of new customers data.

D. Include a scatter chart using the site and the percent of new customers data.

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 feature can take certain values (A, B, C, D, E, and F) and represents a grade of students from a college. Which of the following variables does this describe?

A. Discrete variable

B. Ordinal variable

C. Numerical variable

D. Continuous variable