Pre-Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65pass65

Free CompTIA Data+ Certification Exam Practice Questions

Question # 11

A customer's telephone number is in the format 123-456-7890. Which of the following data types is used for the phone number?

Options:

A.  

Boolean

B.  

Date

C.  

Text

D.  

Number

Discussion 0
Question # 12

A data analyst for a media company needs to determine the most popular movie genre. Given the table below:

Question # 12

Which of the following must be done to the Genre column before this task can be completed?

Options:

A.  

Append

B.  

Merge

C.  

Concatenate

D.  

Delimit

Discussion 0
Question # 13

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

Discussion 0
Question # 14

Amanda needs to create a dashboard that will draw information from many other data sources and present it to business leaders.

Which one of the following tools is least likely to meet her needs?

Options:

A.  

QuickSight.

B.  

Tableau.

C.  

Power BI.

D.  

SPSS Modeler.

Discussion 0
Question # 15

Question # 15

Which of the following summary statements upholds integrity in data reporting?

Options:

A.  

Sales are approximately equal for Product A and Product B across all strategies.

B.  

Strategy 4 provides the best sales in comparison to other strategies.

C.  

While Strategy 2 does not result in the highest sales of Product

D.  

over all products it appears to be the most effective.

D.  

Product D should be promoted more than the other products in all strategies.

Discussion 0
Question # 16

Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?

Options:

A.  

Duplicate data

B.  

Missing data

C.  

Data outliers

D.  

Invalid data type

Discussion 0
Question # 17

A data analyst needs to write a SOL query measuring last month's website visits and distribute a summary report to the marketing team. Which of the following is the analyst creating?

Options:

A.  

Date range

B.  

Distribution list

C.  

Data content

D.  

Report view

Discussion 0
Question # 18

Mario works with a group of R programmers tasked with copying data from an accounting system into a data warehouse.

In what phase are the group's R skills most relevant?

Options:

A.  

Extract.

B.  

Load.

C.  

Transform.

D.  

Purge.

Discussion 0
Question # 19

Which of the following is an example of PII?

Options:

A.  

Age

B.  

Name

C.  

Ethnicity

D.  

Gender

Discussion 0
Question # 20

Given the following data set:

Question # 20

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

Discussion 0

DA0-001 PDF

DA0-001 PDF (Printable)
$54.25
$154.99

DA0-001 Testing Engine

DA0-001 PDF (Printable)
$59.5
$169.99

DA0-001 PDF + Testing Engine

DA0-001 PDF (Printable)
$74.55
$212.99

Free Exams Sample Questions