Special Summer Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Pass DA0-001 Exam Guide

Page: 18 / 27
Total 363 questions

CompTIA Data+ Certification Exam Questions and Answers

Question 69

An analyst wants to combine two data sets into a single spreadsheet. Column names from the first spreadsheet are listed in rows in the second spreadsheet. Which of the following is the first step the analyst should take to combine the data sets?

Options:

A.

Blend

B.

Merge

C.

Concatenate

D.

Transpose

Question 70

An analyst runs a report on a daily basis, and the number of datapoints must be validated before the data can be analyzed. The number of datapoints increases each day by approximately 20% of the total number from the day before. On a given day, the number of datapoints was 8,798. Which of the following should be the total number of datapoints on the next day?

Options:

A.

7,038

B.

9,600

C.

10,600

D.

10,800

Question 71

Given the following data set:

Which of the following is the best reason for cleansing the data?

Options:

A.

Duplicate data

B.

Imputed data

C.

Redundant data

D.

Corrupt data

Question 72

A data analyst who works for a government agency is required to obtain the average income of citizens. The list of citizens is given in the following table:

A value for one citizen's income is missing. Which of the following approaches should the data analyst take to solve this issue?

Options:

A.

Replace the missing value with the average of the rest of the unemployed citizens.

B.

Insert the value 0 into the field with the missing value.

C.

Impute the mean of the other citizens' incomes into the field with the missing value.

D.

Exclude employed citizens from the analysis.

Page: 18 / 27
Total 363 questions