An analyst must obtain the average daily sales for the following week:
 
Which of the following must the analyst perform to obtain this value?

A. Data normalization

B. Data append

C. Data aggregation

D. Data blending

A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the following should an analyst suggest so the user has a dynamic, seamless experience?

A. Create multiple reports, one for each needed date range.

B. Build calculations into the report so they are done automatically.

C. Add macros to the report to speed up the filtering and calculations process.

D. Create a dashboard with a date range picker and calculations built in.

Given the information in the following tables:
Online transactions:
 
In-store transactions:
 
Which of the following describes merging these tables to create a master file that includes all transactions for both online and in-store sales?

A. Data audit

B. Data completeness

C. Data validation

D. Data consolidation

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

A team is planning to automate daily reporting for a company. Prior to this rollout, the team wants to determine how to ensure the data is refreshed at approximately the same time every day.
Which of the following would be the BEST step for the team to take to get the data connected and refreshed on a daily automated schedule?

A. Connect the input to a CSV file that can be replaced daily.

B. Connect the input to an extract that can be replaced daily by a member of the team.

C. Connect the input to a live connection within the data warehouse that refreshes daily.

D. Connect the input to a Microsoft Excel macro that is updated daily on schedule and then fed into the connection.

A research analyst wants to determine whether the data being analyzed is connected to other datapoints. Which of the following is the BEST type of analysis to conduct?

A. Trend analysis

B. Performance analysis

C. Link analysis

D. Exploratory analysis

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

Which of the following is a difference between a primary key and a unique key?

A. A unique key cannot take null values, whereas a primary key can take null values.

B. There can be only one primary key in a data set, whereas there can be multiple unique keys.

C. A primary key can take a value more than once, whereas a unique key cannot take a value more than once.

D. A primary key cannot be a date variable, whereas a unique key can be.

Randy scored 76 on a math test, Katie scored 86 on a science test, Ralph scored 80 on a history test, and Jean scored 80 on an English test. The table below contains the mean and standard deviation of the scores for each of the courses:
 
Using this information, which of the following students had the BEST score?

A. Randy

B. Katie

C. Ralph

D. Jean

A data analyst received the information in the table below from a recently completed marketing campaign:
 
Which of the following is the total order conversion rate?

A. 13.2%

B. 14.8%

C. 22.3%

D. 85.2%

SIMULATION -
The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state. Specifically, the director wants to see the following:
* County outages
* Status
* Overall trend of outages
INSTRUCTIONS:
Please, select each visualization to fit the appropriate space on the dashboard and choose an appropriate color scheme. Once you have selected all visualizations, please, select the appropriate titles and labels, if applicable. Titles and labels may be used more than once.
If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.
 
 
 
 
 

A customer list from a financial services company is shown below:
 
A data analyst wants to create a likely-to-buy score on a scale from 0 to 100, based on an average of the three numerical variables: number of credit cards, age, and income. Which of the following should the analyst do to the variables to ensure they all have the same weight in the score calculation?

A. Recode the variables.

B. Calculate the percentiles of the variables.

C. Calculate the standard deviations of the variables.

D. Normalize the variables.

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

A. Boolean

B. String

C. Integer

D. Float

Which of the following data formats are examples of unstructured data? (Choose two.)

A. XML

B. CSV

C. XLS

D. PNG

E. JSON

F. MP4

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

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?

A. A dancer’s flexibility is improved through static stretching.

B. The change in a dancer’s flexibility is not equal to zero.

C. There is a difference in a dancer’s flexibility between static and dynamic stretching.

D. The means of the static and dynamic stretching groups do not differ from each other.

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.

Which of the following is an example of PII?

A. Age

B. Name

C. Ethnicity

D. Gender

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

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 wants to model the relationship between a set of continuous variables in order to predict the value of an output variable based on the values of a set of input variables.
Which of the following types of analyses should the analyst use?

A. Chi-squared

B. Correlation

C. Regression

D. t-test

A staff member is analyzing open-ended customer comments from an email survey. Which of the following is the EASIEST way to visualize the data?

A. A stacked chart

B. A word cloud

C. A bar chart

D. A bubble chart

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

Which of the following is the best reason to use database views instead of tables?

A. Views reduce the need for repetitive, complex data joins.

B. Views allow for the storage of temporary data, whereas tables do not.

C. Views allow for the joining of multiple data sources, whereas tables do not.

D. Views can be used to restrict sensitive information.

A data analyst is preparing a presentation for the company’s board of directors. The presentation will not contain any confidential information and will only be provided to the board members. Which of the following is the MOST important information to include in the presentation?

A. A watermark

B. The version number

C. A distribution list

D. Company branding

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

A. Non-relational

B. Galaxy

C. Snowflake

D. Star

A director who is responsible for reporting performance to executives has requested a dashboard for C-suite users who are not satisfied with the current multipage printed reports. The requirements for the dashboard are extensive and include displaying almost all the available data. An analyst is concerned that what is being requested will overwhelm users and result in an unused dashboard.
Which of the following is the FIRST step the analyst should take?

A. Clarify the goal of the reporting and work to pare down the requirements for a more effective use of data and a streamlined view.

B. Create a dashboard wireframe/mockup and send it to the director and C-suite users for review and approval before moving forward.

C. Develop a dashboard with multiple views managed by permissions so executives only see the information relevant to them individually.

D. Build an interactive dashboard so users can drill down to the most relevant information through the use of saved searches and filters.

Which of the following is the BEST example of unstructured data?

A. A JSON file

B. A relational database

C. A CSV file

D. An audio file

The current date is July 14, 2020. A data analyst has been asked to create a report that shows the company’s year-over-year Q2 2020 sales. Which of the following reports should the analyst compare?

A. Q2 2020 and Q4 2019

B. YTD 2020 and YTD 2019

C. Q2 2020 and Q2 2019

D. Q2 2020 and Q2 2021

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 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

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.

Which of the following data analytics tools would be BEST to retrieve data from a relational database management system?

A. R

B. Python

C. SQL

D. SAS

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 data acquisition concepts is the most appropriate for determining the quality of a company’s product?

A. Web scraping

B. Observation

C. Survey

D. Sampling

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?

A. Deploy the dashboard to production.

B. Change the field definitions.

C. Update the dashboard subscribers.

D. Optimize the dashboard.

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

Which of the following BEST defines a data outlier?

A. A datapoint that is significantly close to the trend line

B. A datapoint that has the highest significant number of observations

C. A datapoint that differs significantly from other observations

D. A datapoint that is above the trend line

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

In comparison to other data types, which of the following can hold a mix of numbers and letters?

A. Character

B. Float

C. Integer

D. Alphanumeric

A data analyst must separate the column shown below into multiple columns for each component of the name:
 
Which of the following data manipulation techniques should the analyst perform?

A. Imputing

B. Transposing

C. Parsing

D. Concatenating

Which of the following is used for calculations and pivot tables?

A. IBM SPSS

B. SAS

C. Microsoft Excel

D. Domo

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.

Which of the following best describes how discrete data differs from continuous data?

A. Discrete data cannot create a sloped line.

B. Discrete data can only be a finite number of values.

C. Discrete data can have decimal points.

D. Discrete data applies only to numbers.

A data analyst has been asked to derive a new variable labeled “Promotion_flag” based on the total quantity sold by each salesperson. Given the table below:
 
Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the Quantity_sold column?

A. Date

B. Mathematical

C. Logical

D. Aggregate

Given the table below:
 
Which of the following numbers represents a Type I error?

A. 1

B. 2

C. 3

D. 4

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.

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 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

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