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

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

Given the following data:

Which of the following BEST describes the data set?

A. There is data bias.
B. The data is incomplete.
C. The data is inconsistent.
D. The data is outliers.

Given the table below:

Which of the following variable types BEST describes the "Year" column?

A. Numeric
B. Date
C. Alphanumeric
D. Text

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

Which of the following BEST describes standard deviation?

A. A measure that is used to establish a relationship between two variables
B. A measure of how data is distributed
C. A measure of the amount of dispersion of a set of values
D. A measure that is used to find the significant difference between variables

While reviewing survey data, a research analyst notices data is missing from all the responses to a single question. Which of the following methods would BEST address this issue?

A. Replace missing data.
B. Remove duplicate data.
C. Replace redundant data.
D. Remove invalid data.

A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of:

A. dependent data.
B. duplicate data.
C. invalid data
D. redundant data

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.