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

A data analyst is working for a shipping company and calculating the volume of boxes according to the following formula:

volume = height × width × depth.

Which of the following variable types describes volume?

A. Derived

B. Normalized

C. Concatenated

D. Aggregated

What R package makes it easy to work with dates?

A. Lubridate.

B. Datemath.

C. Stringr.

D. ggplot.

Given the diagram below:

Which of the following data schemas shown?

A. Key-value pairs

B. Online transactional processing

C. Data Lake

D. Relational database

A gambler thinks that a coin is fair and is equally likely to turn up heads or tails when the coin is flipped. Which of the following tests should the gambler use to fest this hypothesis?

A. t-test

B. Chi-squared test

C. Rank sum test

D. Ratio test

Given the diagram below:

Which of the following steps is missing?

A. Remove redundant data.

B. Validate the data types.

C. Connect to the data API.

D. Normalize the data.

A column is being used to store strings of variable lengths. Performance is a concern, so the column needs to use as little space as possible. Which of the following data types best meets these requirements?

A. char

B. nchar

C. varchar

D. nvarchar

An analyst computed a new variable of income per day in the household by multiplying the number of days worked by the number of people working in the household and the income earned per day. Which of the following is the correct name for this new variable?

A. Derived

B. Categorical

C. Continuous

D. Control

A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an example of a:

A. Non-relational schema

B. Galaxy schema

C. Snowflake schema

D. Star schema