A stakeholder wants to see daily sales targets organized in a dashboard by country, state, city, and ZIP Code. Which of the following delivery considerations must a data analyst take into account when creating the dashboard?

A. Variable formatting

B. Drill-down capability

C. Saved searches

D. Access permissions

A dataset requires an analysis for investigating and discovering abnormalities. Which of the following best describes the nature of the exploratory analysis conducted?

A. Summary of the data's main characteristics

B. Best data tuning method

C. Set of methods for cleaning the data

D. Method of checking the quality of the data

Q3 2020 has just ended, and now a data analyst needs to create an ad-hoc sales report that demonstrates how well the Q3 2020 promotion went versus last year's Q3 promotion.

Which of the following date parameters should the analyst use?

A. 2019 vs. YTD 2020

B. Q3 2019 vs. Q3 2020

C. YTD 2019 vs. YTD 2020

D. Q4 2019 vs. Q3 2020

A data analyst for a media company needs to determine the most popular movie genre.
Given the table below:

Which of the following must be done to the Genre column before this task can be completed?

A. Append

B. Merge

C. Concatenate

D. Delimit

A large data download was divided into two smaller files. Which of the following describes the best way to fix this issue?

A. Blending the two data sets

B. Appending the two data sets

C. Merging the two data sets

D. Aggregating the two data sets

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

Which of following is a non-relational database?

A. Neo4j

B. SQLite

C. MySQL

D. PostgreSQL

Which of the following data manipulation techniques should an analyst use to hide unnecessary data during analysis?

A. Filtering

B. Parametrization

C. Sorting

D. Indexing

A database administrator is required to mask certain table columns containing Pll in order to comply with the company privacy policy. Which of the following are the most likely types of information the administrator should mask? (Select two).

A. Government-issued ID

B. Address

C. Order ID

D. Order date

E. Customer ID

F. Referral number

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