Which of the following query statements would be used when filtering data in a relational database management system? (Select two).

A. ORDER BY

B. HAVING

C. WHERE

D. SELECT

E. INSERT

F. GROUP BY

The ACME Corporation hired an analyst to detect data quality issues in their Excel documents. Which of the following are the most common issues? (Select TWO)

A. Apostrophe.

B. Commas.

C. Symbols.

D. Duplicates.

E. Misspellings.

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

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.

Exhibit.

Which of the following logical statements results in Table B?

A. Option A

B. Option B

C. Option C

D. Option D

Given the below:

Which of the following numbers represents a Type I error?

A. 1

B. 2

C. 3

D. 4

An analyst is currently working on a ticket for revamping a company-wide dashboard that has been in use for five years. Which of the following should be the first step in the development process?

A. Talk to the group that made the request to determine the desired goal.

B. Make changes to a frequently used report that is already in production.

C. Build an additional dashboard with fewer views that are tailored toward each specific team.

D. Develop a more streanMined dashboard to roll out by the next delivery date.

Which of the following report types is most appropriate for a high-level, year-end report requested by a Chief Executive Officer?

A. Dynamic

B. Recurring

C. Ad hoc

D. Self-service

Which of the following best describes a difference between JSON and XML?

A. JSON is quicker to read and write.

B. JSON has to use an end tag.

C. JSON strings are longer

D. JSON is much more difficult to parse.

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