Exit demo DA0-002 CompTIA Data+ PDF format · free preview

CompTIA DA0-002 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/da0-002.html

Question 1
Single choice

A data analyst created a dashboard to illustrate the traffic volume and mean response time for a call center. The traffic data is current, but the mean response time has not updated for more than an hour.

Which of the following is the best way to verify the data's freshness?

A.

Refactoring the code base

B.

Testing for network connectivity issues

C.

Checking the last time the calculation script ran

D.

Determining the number of calls with no timestamps

Question 2
Single choice

A data analyst team needs to segment customers based on customer spending behavior. Given one million rows of data like the information in the following sales order table:

Which of the following techniques should the team use for this task?

A.

Standardization

B.

Concatenate

C.

Binning

D.

Appending

Question 3
Single choice

A senior manager needs a report that can be generated and accessed at any time.

Which of the following delivery methods should a data analyst use?

A.

Ad hoc

B.

Dynamic

C.

Self-service

D.

Static

Question 4
Single choice

A data analyst is preparing a survey for Paralympic Games athletes.

Which of the following should the analyst consider when creating this survey?

A.

Idioms

B.

Color contrast

C.

Refresh speed

D.

Granularity

Question 5
Single choice

Which of the following tables holds relational keys and numeric values?

A.

Fact

B.

Graph

C.

Dimensional

D.

Transactional

Question 6
Single choice

The following SQL code returns an error in the program console:

SELECT firstName, lastName, SUM(income)

FROM companyRoster

SORT BY lastName, income

Which of the following changes allows this SQL code to run?

A.

SELECT firstName, lastName, SUM(income) FROM companyRoster HAVING SUM(income) >
10000000

B.

SELECT firstName, lastName, SUM(income) FROM companyRoster GROUP BY firstName, lastName

C.

SELECT firstName, lastName, SUM(income) FROM companyRoster ORDER BY firstName, income

D.

SELECT firstName, lastName, SUM(income) FROM companyRoster

Question 7
Single choice

A user needs a report that shows the main causes of customer churn rate in a three-year period.

Which of the following methods provides this information?

A.

Inferential

B.

Descriptive

C.

Prescriptive

D.

Predictive

Question 8
Single choice

Which of the following best describes the semi-structured data that is gathered when web scraping?

A.

JSON

B.

CSV

C.

CSS

D.

HTML

Question 9
Single choice

A data analyst is analyzing the following dataset:

Which of the following methods should the analyst use to determine the total cost for each transaction?

A.

Parsing

B.

Scaling

C.

Compressing

D.

Deriving

Question 10
Single choice

A company has a document that includes the names of key metrics and the standard for how those metrics are calculated company-wide.

Which of the following describes this documentation?

A.

Data dictionary

B.

Data explainability report

C.

Data lineage

D.

Data flow diagram

Showing 10 of 171 questions · Unlock the full set