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

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

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

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

Which of the following is an example of PII?

A. Age

B. Name

C. Ethnicity

D. Gender

A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN:
Customer Table -
 
In-store Transactions -
 
Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?

A. INNER: 6 rows; LEFT: 9 rows

B. INNER: 9 rows; LEFT: 6 rows

C. INNER: 9 rows; LEFT: 15 rows

D. INNER: 15 rows; LEFT: 9 rows

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

A commissions analyst has just completed second-quarter payout statements. The analyst created a dashboard to distribute the statements as quickly as possible. Which of the following will ensure only designated employees can view this information?

A. Publish it on the company intranet.

B. Provide individual links to recipients.

C. Grant subscription access.

D. Print individual dashboards.

Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

A. Missing data

B. Duplicate data

C. Redundant data

D. Invalid data

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

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

Under which of the following circumstances should the null hypothesis be accepted when α = 0.05?

A. When p is 0.00003

B. When p is 0.001

C. When p is 0.04

D. When p is 0.06

Given the data below:
 
In which of the following file formats is the data presented?

A. XLS

B. CSV

C. RTF

D. XML

Given the image below:
 
The data should be cleaned because of the presence of:

A. outliers.

B. non-parametric data.

C. multicollinearity.

D. invalid data.

An analyst needs to create a dashboard with three tiers of information: management, general public (internal users), and external stakeholders. The management team should be able to see all data, while the internal and external groups should see only subsets of that data.
Which of the following is the BEST delivery consideration for the dashboard?

A. Create access permissions so users only see data that is applicable to their user group.

B. Make the dashboard interactive so users can find the data that applies to them.

C. Create an option to save an individual user’s searches and filters by user ID.

D. Create three separate dashboards, one for each user group.

Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?

A. Rephrase the business requirement.

B. Determine the data necessary for the analysis.

C. Build a mock dashboard/presentation layout.

D. Perform exploratory data analysis.

After completing web scraping, which of the following file formats needs to be parsed?

A. .html

B. .txt

C. .csv

D. .tsv

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 following data set:
 
Which of the following steps would be MOST appropriate to cleanse the data set?

A. Remove duplicate data.

B. Remove outliers.

C. Verify the data.

D. Add missing values.

Which of the following is the most likely reason for a data analyst to optimize a query using parameterization?

A. To return a subset of records

B. To insert a temporary table

C. To prevent SQL injections

D. To increase the query speed

A data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business’s performance through the second quarter. The board meeting will be held on July 15, 2020, after the numbers are finalized. Which of the following report types should the data analyst create?

A. Static

B. Real-time

C. Self-service

D. Dynamic

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

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 an example of a discrete variable?

A. The temperature of a hot tub

B. The height of a horse

C. The time to complete a task

D. The number of people in an office

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

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

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

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

A. Non-relational

B. Galaxy

C. Snowflake

D. Star

A data analyst has just finished cleansing a database table and is now ready to update the master. However, the analyst must first check to ensure all the work is accurate. Which of the following data quality checkpoints is the analyst using?

A. Data source

B. Data product

C. Data retrieval

D. Data transformation

Given the following data tables:
 
 
 
Which of the following MDM processes needs to take place FIRST?

A. Creation of a data dictionary

B. Compliance with regulations

C. Standardization of data field names

D. Consolidation of multiple data fields

A Chief Executive Officer (CEO) is requesting more up-to-date sales data for improved visibility prior to month-end. An analyst must determine the frequency of a sales report that was previously distributed on an as-needed basis.
Which of the following would be the most appropriate frequency for this report?

A. Monthly

B. Quarterly

C. Weekly

D. Every other month

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

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 used for calculations and pivot tables?

A. IBM SPSS

B. SAS

C. Microsoft Excel

D. Domo

Which of the following database schemas features normalized dimension tables?

A. Flat

B. Snowflake

C. Hierarchical

D. Star

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 has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:
 
Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

A. Aggregate

B. Logical

C. Date

D. Sort

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 data analyst has a set with more than 40,000 rows in the sample schema below:
 
The analyst would like to create one column that contains the customers’ birth dates. Which of the following data quality dimensions would best explain the reason for compilation?

A. Data accuracy

B. Data completeness

C. Data duplication

D. Data integrity

Which of the following would be used to store unstructured data from different sources?

A. A data lake

B. A database management system

C. A database

D. A data warehouse

An analyst notices changes in sales ratios when analyzing a quarterly report. Which of the following is the analyst conducting?

A. A gap analysis

B. A link analysis

C. A trend analysis

D. A statistical analysis

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 military commander would like to see the health scorecards of the troops daily and filter them based on gender and rank.
Considering this data is PHI, which of the following would be the best way for the commander to view the information?

A. An emailed report

B. A password-protected dashboard

C. A daily printout of a report

D. A cloud-hosted spreadsheet

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

A company wants to determine how its products have been selling over time. The company would like to know about the number of items sold, the category of the product, and the revenue that is generated from that product.
Which of the following tables includes all the information a business analyst would need to fulfill the request?

A.

B.

C.

D.

A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:

A. transactional schema.

B. star schema.

C. non-relational schema.

D. snowflake schema.

A sales director has requested a report for individual team members within the division be developed. The director would like the report to be shared with all team members, but individual team members should not be identifiable within the report. Which of the following access requirements would support the director’s needs?

A. Create an acceptable use policy for the sales data.

B. Release the report as user-group-based access and include data masking.

C. Get a data use agreement from the individual team members.

D. Provide the report based on role and include data encryption.

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 was asked to create a chart that shows the relationship between study hours and exam scores for each student using the data sets in the table below:
 
Which of the following charts would BEST represent the relationship between the variables?

A. A histogram

B. A scatter plot

C. A heat map

D. A bar chart

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.