CompTIA DA0-001 Dumps (V12.02) – Achieve Remarkable Results in the CompTIA Data+ Certification Exam

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

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?

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

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?

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

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

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?

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?

10. Refer to the exhibit.

Given the diagram below:

Which of the following data schemas shown?

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?

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?

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

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?

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

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

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

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

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?

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?

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?

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?

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?

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

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?

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

27. Refer to the exhibit.

Given the following graph:

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

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?

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?

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?

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?

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?

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

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?

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

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

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?

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

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?

40. Refer to the exhibit.

Given the following data tables:

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

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

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.)

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.)

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?

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

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?

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?

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?

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

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?

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:

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?

53. Which of the following BEST describes standard deviation?

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?

55. Refer to the exhibit.

Given the table below:

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

56. Refer to the exhibit.

Given the following data:

Which of the following BEST describes the data set?

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?

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?

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

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?

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?

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:

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.)

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

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?

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

67. Which of the following will MOST likely be streamed live?

68. A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:

69. A data analyst is designing a dashboard that will provide a story of sales and determine which site is providing the highest sales volume per customer. 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?

70. An analyst needs to conduct a quick analysis.

Which of the following is the FIRST step the analyst should perform with the data?

71. A data analyst has been asked to create a sales report that calculates the rolling 12-month average for sales.

If the report will be published on November 1, 2020, which of the following months shouts the report cover?

72. A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a

LEFT JOIN:

Customer Table -

In-store Transactions C

Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?

73. A data analyst needs to create a weekly recurring report on sales performance and distribute it to all sales managers.

Which of the following would be the BEST method to automate and ensure successful delivery for this task?

74. Which of the following is an example of a discrete variable?

75. Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?

76. The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state.

Specifically, the director wants to see the following:

* County outages

* Status

* Overall trend of outages

INSTRUCTIONS:

Please, select each visualization to fit the appropriate space on the dashboard and choose an appropriate color scheme. Once you have selected all visualizations, please, select the appropriate titles and labels, if applicable. Titles and labels may be used more than once.

If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.

77. Q3 2020 has just ended, and now a data analyst needs to create an ad-hoc sales report that demonstrates how well the Q3 2020 promotion went versus last year's Q3 promotion.

Which of the following date parameters should the analyst use?

78. A data analyst has been asked to create an ad-hoc sales report for the Chief Executive Officer (CEO).

Which of the following should be included in the report?

79. Which of the following can be used to translate data into another form so it can only be read by a user who has a key or a password?

80. Which of the following is an example of a discrete data type?

81. Which of the following contains alphanumeric values?

82. A junior web developer is developing a new application where users can upload short videos. The first task is to create a homepage that shows the headline "Upload Your Short Videos" and a clickable button that says "upload now".

Which of the following HTML commands would help the developer to complete the task successfully?

83. A web developer wants to ensure that malicious users can't type SQL statements when they asked for input, like their username/userid.

Which of the following query optimization techniques would effectively prevent SQL Injection attacks?

84. Consider the following dataset which contains information about houses that are for sale:

Which of the following string manipulation commands will combine the address and region name columns to create a full address?

full_address------------------------- 85 Turner St, Northern Metropolitan 25 Bloomburg St, Northern

Metropolitan 5 Charles St, Northern Metropolitan 40 Federation La, Northern Metropolitan 55a Park St, Northern Metropolitan

85. The ACME Corporation hired an analyst to detect data quality issues in their Excel documents.

Which of the following are the most common issues? (Select TWO)

86. Consider this dataset showing the retirement age of 11 people, in whole years:

54, 54, 54, 55, 56, 57, 57, 58, 58, 60, 60

This tables show a simple frequency distribution of the retirement age data.

87. Which of the following value is the measure of dispersion "range" between the scores of ten students in a test.

The scores of ten students in a test are 17, 23, 30, 36, 45, 51, 58, 66, 72, 77.

88. A data scientist wants to see which products make the most money and which products attract the most customer purchasing interest in their company.

Which of the following data manipulation techniques would he use to obtain this information?

89. A data analyst wants to create "Income Categories" that would be calculated based on the existing variable "Income".

The "Income Categories" would be as follows:

Income category 1: less than $1.

Income category 2: more than $1 and less than $20,000.

Income category 3: more than $20,001 and less than $40,000.

Income category 4: more than $40,001.

Which of the following data manipulation techniques should the data analyst use to create "Income Categories"?

90. Angela is aggregating data from CRM system with data from an employee system.

While performing an initial quality check, she realizes that her employee ID is not associated with her identifier in the CRM system.

What kind of issues is Angela facing? Choose the best answer.

91. Andy is a pricing analyst for a retailer. Using a hypothesis test, he wants to assess whether people who receive electronic coupons spend more on average.

What should Andy's null hypothesis be?

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

93. Daniel is using the structured Query language to work with data stored in relational database.

He would like to add several new rows to a database table.

What command should he use?

94. Jhon is working on an ELT process that sources data from six different source systems.

Looking at the source data, he finds that data about the sample people exists in two of six systems.

What does he have to make sure he checks for in his ELT process? Choose the best answer.

95. Samantha needs to share a list of her organization's top 50 customers with the VP of sales. She would like to include the name of the customer, the business they represent, their contact information, and their total sales over the past year.

The VP does not have any specialized analytics skills or software but would like to make some

personal notes on the dataset.

What would be the best tool for Samantha to use to share this information?

96. Alex wants to use data from his corporate sale, CRM, and shipping systems to try and predict future sales.

Which of the following systems is the most appropriate? Choose the best answer.

97. Analytics reports should follow corporate style guidelines.

98. Which one of the following is a measure of dispersion?