Summer Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Free CompTIA DA0-001 Practice Exam with Questions & Answers | Set: 12

Questions 166

A data analyst has removed the outliers from a data set due to large variances. Which of the following central tendencies would be the best measure to use?

Options:
A.

Range

B.

Mean

C.

Mode

D.

Median

CompTIA DA0-001 Premium Access
Questions 167

A marketing analytics team received customer transaction data from two different sources. The data is complete and accurate; however, the field names appear to be inconsistent. Given the following tables:

DA0-001 Question 167

Which of the following is considered best practice if the team wants to consolidate the files and conduct further analysis?

Options:
A.

Standardize the field names.

B.

Recode the data values.

C.

Overwrite the field names in one of the tables.

D.

Edit the field names in the data dictionary.

Questions 168

An organization wants to evaluate whether project activities are within the set projections and in line to meet the desired project targets. Which of the following types of analysis is best suited for this situation?

Options:
A.

Trend analysis

B.

Performance analysis

C.

Descriptive analysis

D.

Exploratory analysis

Questions 169

A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment. Which of the following should the data analyst use to BEST communicate this information to the manager?

Options:
A.

A real-time monitor that allows the manager to view performance the day the campaign was launched

B.

A sell-service dashboard that allows the manager to look at the company's annual budget performance

C.

A spreadsheet of the raw data from all marketing campaigns and channels

D.

A summary with statistics, conclusions, and recommendations from the data analyst

Questions 170

An analyst needs to create an analytics dashboard for an employee intranet site to improve the search functionality, display relevant information, and maintain an updated FAQ page. Which of the following visualizations would best represent what employees are searching for?

Options:
A.

A word cloud

B.

A histogram

C.

A pie chart

D.

A scatter plot

Questions 171

Which of the following best describes how discrete data differs from continuous data?

Options:
A.

Discrete data cannot create a sloped line.

B.

Discrete data can only be a finite number of values.

C.

Discrete data can have decimal points.

D.

Discrete data applies only to numbers.

Questions 172

A collections manager has a team calling customers who are past due on their accounts in an attempt to collect payments. The manager receives the call list in the form of a printed report that is generated by the accounting department at the beginning of each week. Consequently, the collections team calls some customers who have made payments in the time since the report was last printed. Which of the following reporting enhancements could the accounting department implement to best reduce the number of calls on current accounts?

Options:
A.

Modify the date range on the report

B.

Include a time stamp on the report.

C.

Increase the frequency of report generation.

D.

Add a report run date to the report.

Questions 173

Which of the following is the best approach to use to gain a general understanding of a data set?

Options:
A.

Descriptive statistics

B.

Basic projections

C.

Gap analysis

D.

Trend analysis

Questions 174

A data analyst has a set with more than 40.000 rows in the sample schema below:

DA0-001 Question 174

The analyst would like to create one column that contains the customers’ birth dates. Which of the following data quality dimensions would BEST explain the reason for compilation?

Options:
A.

Data accuracy

B.

Data completeness

C.

Data duplication

D.

Data integrity

Questions 175

A data architect is designing a data solution for a retail clothing store chain. Each store has a database that tracks sales transactions. The data architect needs to create a summary table that will be used for a senior executive dashboard. The summary table should not contain duplicate store information. Which of the following should the data architect create?

Options:
A.

A check constraint

B.

A primary key

C.

A foreign key

D.

A unique constraint

Questions 176

Which of the following will MOST likely be streamed live?

Options:
A.

Machine data

B.

Key-value pairs

C.

Delimited rows

D.

Flat files

Questions 177

A sales manager wants quarterly sales reports broken down by unit and week. Which of the following data output lists includes the most necessary information?

Options:
A.

Order number. salesperson. date shipped, recipient address, and price

B.

Item name, salesperson. recipient address, shipping cost. and date shipped

C.

Item number, item name, salesperson. date sold. and price

D.

Item name. salesperson. price. shipping cost. and date shipped

Questions 178

An analyst is building a new dashboard for a user. After an initial conversation with the user. the analyst created a mock-up of the dashboard. Which of the following best explains why the analyst created the mock-up?

Options:
A.

To identify the dimensions and measures

B.

To send to the client after deploying the dashboard to production

C.

To confirm important details before dashboard development begins

D.

To receive client approval for the final dashboard design

Questions 179

Given the following data sample:

DA0-001 Question 179

Which of the following best describes the data quality issue?

Options:
A.

Data outlier

B.

Consistent data

C.

Duplicate data

D.

Invalid data

Questions 180

Which of the following tools would be best to use to calculate the interquartile range, median, mean, and standard deviation of a column in a table that has 5.000.000 rows?

Options:
A.

Microsoft Excel

B.

R

C.

Snowflake

D.

SQL