CompTIA Data+ DA0-001 Exam Actual Questions

dumps2023-11-06T10:20:51+08:00

DA0-001 exam is a related test for CompTIA Data+ Certification. In the real CompTIA certification DA0-001 exam, there are 90 questions, and you have 90 minutes to write the test. The required passing score for the CompTIA Data+ DA0-001 exam is 675 (the total score is 900). The available language is English. Free CompTIA Data+ DA0-001 exam actual questions are below.

Page 1 of 7

1. Refer to the exhibit.

A data analyst needs to calculate the mean for Q1 sales using the data set below:

Which of the following is the mean?

$2,466.18

$2,667.60

$3,082.72

$12,330.88

2. A data analyst is creating a report that will provide information about various regions, products, and time periods.

Which of the following formats would be the MOST efficient way to deliver this report?

A workbook with multiple tabs for each region

A daily email with snapshots of regional summaries

A static report with a different page for every filtered view

A dashboard with filters at the top that the user can toggle

3. Refer to the exhibit.

A customer list from a financial services company is shown below:

A data analyst wants to create a likely-to-buy score on a scale from 0 to 100, based on an average of the three numerical variables: number of credit cards, age, and income.

Which of the following should the analyst do to the variables to ensure they all have the same weight in the score calculation?

Recode the variables.

Calculate the percentiles of the variables.

Calculate the standard deviations of the variables.

Normalize the variables.

4. Which of the following actions should be taken when transmitting data to mitigate the chance of a data leak occurring? (Choose two.)

Data identification

Data processing

Data Reporting

Data encryption

Data masking

Fata removal

5. A data analyst has been asked to organize the table below in the following ways:

By sales from high to low -

By state in alphabetic order -

Which of the following functions will allow the data analyst to organize the table in this manner?

Conditional formatting

Grouping

Filtering

Sorting

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

Duplicate data

Missing data

Data outliers

Invalid data type

7. Which of the following is a process that is used during data integration to collect, blend, and load data?

MDM

ETL

OLTP

8. An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe.

Which of the following is the NEXT step the analyst should take in the dashboard creation process?

Optimize the dashboard.

Create subscriptions.

Get stakeholder approval.

Deploy to production.

9. A data analyst has been asked to derive a new variable labeled “Promotion_flag” based on the total quantity sold by each salesperson.

Given the table below:

Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the Quantity_sold column?

Date

Mathematical

Logical

Aggregate

10. Refer to the exhibit.

Given the diagram below:

Which of the following data schemas shown?

Key-value pairs

Online transactional processing

Data Lake

Relational database

Page 2 of 7

11. A company’s marketing department wants to do a promotional campaign next month. A data analyst on the team has been asked to perform customer segmentation, looking at how recently a customer bought the product, at what frequency, and at what value.

Which of the following types of analysis would this practice be considered?

Prescriptive

Trend

Gap

Custer

12. A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final.

Which of the following is the BEST way to meet this stakeholder requirement?

Display the version number next to each submission on the dashboard.

Present a data refresh date at the top of the dashboard.

Confirm the dashboard is adhering to the corporate style guide.

Use permissions to ensure users only see certain versions of the submissions.

13. The number of phone calls that the call center receives in a day is an example of:

continuous data.

categorical data.

ordinal data.

discrete data.

14. A data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business’s performance through the second quarter. The board meeting will be held on July 15, 2020, after the numbers are finalized.

Which of the following report types should the data analyst create?

Static

Real-time

Self-service

Dynamic

15. Which of the following would be considered non-personally identifiable information?

Cell phone device name

Customer’s name

Government ID number

Telephone number

16. Which of the following is the correct data type for text?

Boolean

String

Integer

Float

17. Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?

Rephrase the business requirement.

Determine the data necessary for the analysis.

Build a mock dashboard/presentation layout.

Perform exploratory data analysis.

18. Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

SAS

Microsoft Power BI

IBM SPSS

Python

19. 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?

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

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

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

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

20. A data analyst for a media company needs to determine the most popular movie genre.

Given the table below:

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

Append

Merge

Concatenate

Delimit

Page 3 of 7

21. An e-commerce company recently tested a new website layout. The website was tested by a test group of customers, and an old website was presented to a control group.

The table below shows the percentage of users in each group who made purchases on the websites:

Which of the following conclusions is accurate at a 95% confidence interval?

In Germany, the increase in conversion from the new layout was not significant.

In France, the increase in conversion from the new layout was not significant.

In general, users who visit the new website are more likely to make a purchase.

The new layout has the lowest conversion rates in the United Kingdom.

22. An analyst needs to provide a chart to identify the composition between the categories of the survey response data set:

Which of the following charts would be BEST to use?

Histogram

Pie

Line

Scatter pot

Waterfall

23. Five dogs have the following heights in millimeters: 300, 430, 170, 470, 600

Which of the following is the mean height for the five dogs?

394mm

405mm

493mm

504mm

24. Which of the following are reasons to create and maintain a data dictionary? (Choose two.)

To improve data acquisition

To remember specifics about data fields

To specify user groups for databases

To provide continuity through personnel turnover

To confine breaches of PHI data

To reduce processing power requirements

25. A recurring event is being stored in two databases that are housed in different geographical locations. A data analyst notices the event is being logged three hours earlier in one database than in the other database.

Which of the following is the MOST likely cause of the issue?

The data analyst is not querying the databases correctly.

The databases are recording different events.

The databases are recording the event in different time zones.

The second database is logging incorrectly.

26. Which of the following is an example of a at flat file?

CSV file

PDF file

JSON file

JPEG file

27. Refer to the exhibit.

Given the following graph:

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

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

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

While Strategy 2 does not result in the highest sales of Product D, over all products it appears to be the most effective.

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

28. An analyst is required to run a text analysis of data that is found in articles from a digital news outlet.

Which of the following would be the BEST technique for the analyst to apply to acquire the data?

Web scraping

Sampling

Data wrangling

ETL

29. 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?

7,038

9,600

10,600

10,800

30. An analyst has been tracking company intranet usage and has been asked to create a chat to show the most-used/most-clicked portions of a homepage that contains more than 30 links.

Which of the following visualizations would BEST illustrate this information?

Scatter plot

Heat map

Pie chart

Infographic

Page 4 of 7

31. An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:

Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

Aggregate

Logical

Date

Sort

32. While reviewing survey data, an analyst notices respondents entered “Jan,” “January,” and “01” as responses for the month of January.

Which of the following steps should be taken to ensure data consistency?

Delete any of the responses that do not have “January” written out.

Replace any of the responses that have “01”.

Filter on any of the responses that do not say “January” and update them to “January”.

Sort any of the responses that say “Jan” and update them to “01”.

33. Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

Missing data

Duplicate data

Redundant data

Invalid data

34. A county in Illinois is conducting a survey to determine the mean annual income per household. The county is 427sq mi (2.65q km).

Which of the following sampling methods would MOST likely result in a representative sample?

A stratified phone survey of 100 people that is conducted between 2:00 p.m. and 3:00 p.m.

A systematic survey that is sent to 100 single-family homes in the county

Surveys sent to ten randomly selected homes within 5mi (8km) of the county’s office

Surveys sent to 100 randomly selected homes that are reflective of the population

35. Which of the following statistical methods requires two or more categorical variables?

Simple linear regression

Chi-squared test

Z-test

Two-sample t-test

36. Which of the following data manipulation techniques is an example of a logical function?

WHERE

AGGREGATE

BOOLEAN

37. A sales team wants visibility of current sales numbers, pipeline, and team performance. The team would also like to see calculations of individuals’ earned commissions and projected commissions based on sales, but they want that information to be kept confidential.

Which of the following would be the BEST way to provide this visibility?

Create a dashboard displaying a data refresh date so users know the current sales numbers and configure permissions to control access.

Create a dashboard for sales numbers, pipeline, and team and individual performance for the management team.

Create a dashboard with filters for the overall team, individuals, and management. Users can filter to see the data they want.

Create a dashboard with views for team, individuals, and management. Configure permissions to control access.

38. Which of the following is a characteristic of a relational database?

It utilizes key-value pairs.

It has undefined fields.

It is structured in nature.

It uses minimal memory.

39. A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day.

Which of the following date ranges should be on the report?

January 1, 2020 to April 1, 2020

January 1, 2020 to April 7, 2020

January 1, 2020 to April 8, 2020

January 1, 2020 to April 9, 2020

40. Refer to the exhibit.

Given the following data tables:

Which of the following MDM processes needs to take place FIRST?

Creation of a data dictionary

Compliance with regulations

Standardization of data field names

Consolidation of multiple data fields

Page 5 of 7

41. Which of the following is used for calculations and pivot tables?

IBM SPSS

SAS

Microsoft Excel

Domo

42. Refer to the exhibit.

Given the following report:

Which of the following components need to be added to ensure the report is point-in-time and static? (Choose two.)

A control group for the phrases

A summary of the KPIs

Filter buttons for the status

The date when the report was last accessed

The time period the report covers

The date on which the report was run

43. An analyst has been asked to validate data quality.

Which of the following are the BEST reasons to validate data for quality control purposes? (Choose two.)

Retention

Integrity

Transmission

Consistency

Encryption

Deletion

44. A research analyst wants to determine whether the data being analyzed is connected to other datapoints.

Which of the following is the BEST type of analysis to conduct?

Trend analysis

Performance analysis

Link analysis

Exploratory analysis

45. Which of the following variable name formats would be problematic if used in the majority of data software programs?

First_Name_

FirstName

First_Name

First Name

46. Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?

Simple random

Cluster

Systematic

Stratified

47. Given the following customer and order tables:

Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?

Five rows, eight columns

Seven rows, eight columns

Eight rows, seven columns

Nine rows, five columns

48. A development company is constructing a new unit in its apartment complex.

The complex has the following floor plans:

Using the average cost per square foot of the original floor plans, which of the following should be the price of the Rose unit?

$640,900

$690,000

$705,200

$702,500

49. Which of the following is a control measure for preventing a data breach?

Data transmission

Data attribution

Data retention

Data encryption

50. A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range.

Which of the following should an analyst suggest so the user has a dynamic, seamless experience?

Create multiple reports, one for each needed date range.

Build calculations into the report so they are done automatically.

Add macros to the report to speed up the filtering and calculations process.

Create a dashboard with a date range picker and calculations built in.

Page 6 of 7

51. A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of:

dependent data.

duplicate data.

invalid data

redundant data

52. While reviewing survey data, a research analyst notices data is missing from all the responses to a single question.

Which of the following methods would BEST address this issue?

Replace missing data.

Remove duplicate data.

Replace redundant data.

Remove invalid data.

53. Which of the following BEST describes standard deviation?

A measure that is used to establish a relationship between two variables

A measure of how data is distributed

A measure of the amount of dispersion of a set of values

A measure that is used to find the significant difference between variables

54. A data analyst was asked to create a chart that shows the relationship between study hours and exam scores for each student using the data sets in the table below:

Which of the following charts would BEST represent the relationship between the variables?

A histogram

A scatter plot

A heat map

A bar chart

55. Refer to the exhibit.

Given the table below:

Which of the following variable types BEST describes the “Year” column?

Numeric

Date

Alphanumeric

Text

56. Refer to the exhibit.

Given the following data:

Which of the following BEST describes the data set?

There is data bias.

The data is incomplete.

The data is inconsistent.

The data is outliers.

57. An analysts building a monthly report for production and wants to ensure the audience is aware of its once-a-month cadence.

Which of the following is the MOST important to convey that information?

The date of the dashboard build

The data refresh date

A report summary

Frequently asked questions

58. An analyst is working with the income data of suburban families in the United States. The data set has a lot of outliers, and the analyst needs to provide a measure that represents the typical income.

Which of the following would BEST fulfill the analyst’s goal?

Median

Mean

Mode

Standard deviation

59. Which of the following would be used to store unstructured data from different sources?

A data lake

A database management system

A database

A data warehouse

60. An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard.

The following data is available:

Which of the following types of charts should be considered to BEST display the data?

Include a bar chart using the site and the percentage of new customers data.

Include a line chart using the site and the percentage of new customers data.

Include a pie chat using the site and percentage of new customers data.

Include a scatter chart using the site and the percent of new customers data.

Page 7 of 7

61. A cereal manufacturer wants to determine whether the sugar content of its cereal has increased over the years.

Which of the following is the appropriate descriptive statistic to use?

Frequency

Percent change

Variance

Mean

62. The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:

a t-test.

a performance analysis.

an exploratory data analysis.

a link analysis.

63. Different people manually type a series of handwritten surveys into an online database.

Which of the following issues will MOST likely arise with this data? (Choose two.)

Data accuracy

Data constraints

Data attribute limitations

Data bias

Data consistency

Data manipulation

64. Which of the following data sampling methods involves dividing a population into subgroups by similar characteristics?

Systematic

Simple random

Convenience

Stratified

65. A data analyst must separate the column shown below into multiple columns for each component of the name:

Which of the following data manipulation techniques should the analyst perform?

Imputing

Transposing

Parsing

Concatenating

66. Which of the following descriptive statistical methods are measures of central tendency? (Choose two.)

Mean

Minimum

Mode

Variance

Correlation

Maximum

CompTIA Data+ DA0-001 Exam Actual Questions

CompTIA Data+ DA0-001 Exam Actual Questions

Share this post

Leave a Reply Cancel reply

Related Posts