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 data set for sales per month includes the following data:

Which of the following cleaning and profiling methods should be applied to the data set?

A. Data outliers

B. Invalid data

C. Duplicate data

D. Data type validation

You have two databases tables that you would like to join together using a foreign key relationship.

What term best describes this action?

A. Blending.

B. Appending.

C. Mixing.

D. Merging.

Which of the following are reasons to conduct data cleansing? (Select two).

A. To perform web scraping

B. To track KPls

C. To improve accuracy

D. To review data sets

E. To increase the sample size

F. To calculate trends

An analyst wants to test the association between the number of doors in a car and the number of gears in the car. Which of the following is the best test to use?

A. F-test

B. Acceptance test

C. Chi-squared test

D. Z-test

A marketing analytics team received customer transaction data from two different sources.
The data is complete and accurate; however, the field names appear to be inconsistent.
Given the following tables:

Which of the following is considered best practice if the team wants to consolidate the files and conduct further analysis?

A. Standardize the field names.

B. Recode the data values.

C. Overwrite the field names in one of the tables.

D. Edit the field names in the data dictionary.

An analyst is creating a resource to improve users' experience when they select specific records based on particular dates. Which of the following should the analyst use to create a resource that best meets user needs?

A. Drop-down menu

B. Date range

C. Text field

D. Frequency

A quality assurance manager is examining tolerances in Internet of Things sensors. Which of the following is the best measure for the manager to calculate?

A. Standard deviation

B. Quartile range

C. Median

D. Mean

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.

Which of the following explains why standardization of data field names is important to master data management concepts?

A. The quality of the data is consistent and improved.

B. The data looks more appealing.

C. The colors in data visualization are enhanced.

D. The data is decompressed.

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

Which of the following is the best description of discrete data types?

A. Non-numeric data used to describe attributes of a population sample

B. The frequency of the number of times each value occurs by using whole numbers

C. Numeric values that can be measured on a continuous scale

D. Non-numeric data used to describe attributes of a population sample ranked in a specific order