Changed DA0-001 Exam Questions

CompTIA Data+ Certification Exam Questions and Answers

Question 89

An analyst wants to extract data from a variety of sources and store the data in a cloud-based environment prior to cleaning. Which of the following integration techniques should the analyst use?

Options:

ETL

API

SQL

ELT

Question 90

A data analyst has been asked to create one table that has each employee's first name, last name, sales, and address. The sales and addresses are listed in the tables below:

Which of the following steps should the analyst take to create the table?

Options:

Transpose the first name and last name in both tables. Use lookup to pull the address field from Table 2 into Table 1.

Use lookup with the first name or first name to pull the address field from Table 2 into Table 1.

Use the append formula in both tables for the first name and last name. Use lookup to pull the address field from Table 2 into Table 1.

Create a column that concatenates the first name and last name in each table. Use concatenate and lookup to bring the address field into Table 1.

Question 91

Each month an analyst needs to execute a data pull for the two prior months. Which of the following is the most efficient function for the analyst to use?

Options:

Logical

Date

Aggregate

System

Question 92

During data cleansing, an analyst conducts measures of central tendency on a data set. Which of the following data is the analyst attempting to identify?

Options:

Duplicate

Missing

Outlying

Invalid

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

CompTIA Data+ Certification Exam Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

CompTIA

Fortinet

Microsoft

Salesforce