Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

A data analyst needs to observe the relationship between two numeric variables and identify the clustering pattern as well as the outliers. Which of the following visualizations should the analyst use?

A.

Heat map

B.

Tree map

C.

Scatter plot

D.

Stacked chart

Which of the following describes the use of a representative amount of data from a main repository?

A.

Observation

B.

Delta load

C.

Web scraping

D.

Sampling

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

Kelly wants to get feedback on the final draft of a strategic report that has taken her six months to develop.

What can she do to get prevent confusion as see seeks feedback before publishing the report?

Choose the best answer.

A.

Distribute the report to the appropriate stakeholders via email.

B.

Use a watermark to identify the report as a draft.

C.

Show the report to her immediate supervisor.

D.

Publish the report on an internally facing website.

A data scientist wants to see which products make the most money and which products attract the most customer purchasing interest in their company.

Which of the following data manipulation techniques would he use to obtain this information?

A.

Data append

B.

Data blending

C.

Normalize data

D.

Data merge

An analyst is reviewing the following data:

Car IDSpeed

123155

566436

564418

650567

546436

645638

Which of the following should the analyst include in the measures of central tendency for speed?

A.

Mode = 38 Range = 31 Mean = 42.5

B.

Range = 49 Max = 67 Min = 18

C.

Mode = 36 Max = 67 Min = 18

D.

Mode = 36 Median = 37 Mean = 41.5

A salesperson who is prospecting potential clients collected the following data:

Which of the following is an issue with this data?

A.

Duplicate data

B.

Invalid data

C.

Missing value

D.

Redundant data

Which of the following is an object associated with a table that sorts and stores table row data in a key-value pair?

A.

Foreign key

B.

Function

C.

Stored procedure

D.

Clustered index

A data analyst needs to apply quality control concepts to a data set for accuracy. Which of the following is the best way to do this?

A.

Standardization

B.

Parameterization

C.

Encryption

D.

Cross-validation

A data analyst has been asked to create a daily manufacturing report for the floor manager Which of the following metrics should be included in the report?

A.

Tons of steel produced per hour

B.

Annual sales budget

C.

End-of-day stock price

D.

Daily corporate employee count