New CompTIA Data+ Certification DA0-001 Practice Questions [2022] For Learning

Eleanor2022-07-04T07:26:17+00:00

The CompTIA Data+ certification is available to help the certified professionals have the skills required to facilitate data-driven business decisions. As an early-career data analytics certification, it is not an easy task. For achieving the CompTIA Data+ certification successfully. New CompTIA Data+ certification DA0-001 practice questions from ITPrepare are great, which could be your great way to pass the CompTIA Data+ certification exam smoothly. With the ITPrepare DA0-001 practice questions online, we promise that you will have the correct path to pass.

Read ITPrepare CompTIA Data+ Certification DA0-001 Free Exam Questions Below

Page 1 of 5

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

The sales representatives' home addresses.

Line-item SKU numbers.

YTD total sales.

The customers' first and last names.

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

2019 vs. YTD 2020

Q3 2019 vs. Q3 2020

YTD 2019 vs. YTD 2020

Q4 2019 vs. Q3 2020

3. Oliver is designing an ETL process to copy sales data into a data warehouse on a hourly basis.

What approach should Oliver choose that would be most efficient and minimize the chance of losing historical data?

Bulk load.

Purge and load.

Use ELT instead of ET

Delta load.

4. What SQL command is used to delete an entire table from a database?

DRO

MODIF

DELET

ALTE

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

8in (20cm)

5 kids

2.5mi (4km)

10.7lbs (4.9kg)

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

SELEC

ALTE

INSER

UPDAT

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

SELECT CONCAT(address, ' , ' , regionname) AS full_address FROM melb LIMIT 5;

SELECT CONCAT(address, '-' , regionname) AS full_address FROM melb LIMIT 5;

SELECT CONCAT(regionname, ' , ' , address) AS full_address FROM melb LIMIT 5

SELECT CONCAT(regionname, '-' , address) AS full_address FROM melb LIMIT 5;

8. What would be an example of an acceptable form of primary identification for the Data+ exam?

Passport.

School ID card.

Employee ID card.

Credit card with photo and signature.

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

10. Which one of the following tools would not be considered a fully featured analytics suite?

A. Minitab.

B. MicroStrategy.

C. Domo.

D. Power BI.

Page 2 of 5

11. Andrew conducts a study and wants to capture eye color.

What kind of data is eye color? Choose the best response.

Discrete.

Categorical.

Continuous.

Alphanumeric.

12. Olivia has 15 people on her data analytics team. Her team's charter requires that all team members have read access to the finance, human resources, sales, and customer service areas of the corporate data warehouse.

What is the best way to provision access to her team?

Choose the best answer.

Since there are 15 people on her team, create a role for each person to improve security.

Since there are four discrete data subjects, create one role for each subject area.

Enable multifactor authentication (MFA) to protect the data.

Create a single role that includes finance, human resources, sales, and customer services data.

13. Analytics reports should follow corporate style guidelines.

True.

False.

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?

QuickSight.

Tableau.

Power B

SPSS Modeler.

15. You are working with a dataset and need to swap the values in rows with those in columns.

What action do you need to perform?

Recording

Filtering.

Aggregation.

Transposition.

16. What role in a data governance is typically responsible for day-to-day oversight of data use?

Data processors.

Data custodians

Data owners.

Data stewards.

17. When analyzing the values of two variables, you decide to convert both variables so they are on a scale of 0 to 1.

What term describes this action?

Filtering.

Normalization.

Transposition.

Aggregation.

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

Variance.

Mode.

Median.

Mean.

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

A. Data encryption.

B. Data transmission.

C. Data protection.

D. Data masking.

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

Page 3 of 5

21. George is conducting a survey. He intends to distribute the survey via email and wants to optionally follow up with respondents based on their answers.

What quality dimension is most vital to the success of George's survey?

Choose the best answer.

A. Completeness.

B. Accuracy.

C. Consistency.

D. Validity.

22. What is the median of the following numbers?

13, 2, 65, 3, 5, 4, 7, 3, 4, 7, 8, 2, 4, 4, 60, 23, 43, 2

4.5

23. James wants to analyze profit based on sales of five different product categories.

His source data set consists of 5.8 million rows with columns including region, product category, product name, and sales price.

How should he manipulate the data to facilitate his analysis?

Choose the best answer.

Transpose by region and summarize.

Transpose by product category and summarize.

Transpose by product name and summarize.

Transpose by sales price and summarize.

24. Which one of the following in NOT a common data integration tool?

XSS

ELT

ETL

APIs

25. Jenny wants to study the academic performance of undergraduate sophomores and wants to determine the average grade point average at different points during an academic year.

What best describes the data set she needs?

A. Sample.

B. Observation.

C. Variable.

D. Population.

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

Extract.

Load.

Transform.

Purge.

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

< span >Upload Your Short Videos< /span >< button >upload now< /button >

< p >Upload Your Short Videos< /p >< p >upload now< /p >

< hl >Upload Your Short Videos< /h1 >< button >upload now< /button >

< hl >Upload Your Short Videos< /h1 >< hl >upload now< /h1 >

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

Data merge

Derived variables

Data blending

Data append

29. Taylor wants to investigate how manufacturing, marketing, and sales expenditures impact overall profitability for her company.

Which of the following systems is the most appropriate?

OLT

OLA

Data warehouse.

Data mart.

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

Apostrophe.

Commas.

Symbols.

Duplicates.

Misspellings.

Page 4 of 5

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

People who receive electronic coupons spend more on average.

People who receive electronic coupons spend less on average.

People who receive electronic coupons do not spend more on average.

People who do not receive electronic coupons spend more on average.

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

Duplicate Data.

Redundant Data.

Invalid Data.

Missing Data.

33. Encryption is a mechanism for protecting data.

When should encryption be applied to data? Choose the best answer.

When data is at rest.

When data is at rest or in transit.

When data is in transit.

When data is at rest, unless you are using local storage.

34. Which one of the following is a common data warehouse schema?

Snowflake.

Square.

Spiral.

Sphere.

35. Emma is working in a data warehouse and finds a finance fact table links to an organization dimension, which in turn links to a currency dimension that not linked to the fact table.

What type of design pattern is the data warehouse using?

Star.

Sun.

Snowflake.

Comet.

36. According to the empirical rule, what percent of thee values in a sample fall within three standard deviations of the mean in a normal distribution?

A. 99.70%

B. 95%

C. 90%

D. 68%

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

Data append

Data blending

Normalize data

Data merge

38. Melissa wants to explore central tendency in her dataset.

Which statistic best matches her need?

Interquartile range.

Range.

Median.

Standard deviation.

39. Which one of the following programming languages is specifically designed for use in analytics applications?

Python.

C++

Java.

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

Indexing.

Subset of records.

Temporary table in the query set.

Parametrization.

Page 5 of 5

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

Data mart.

OLA

Data Warehouse.

OLT

42. You are working with a professional statistician to perform an analysis and would like to use a statistics package.

Which one of the following would be the most appropriate?

Rapid Miner.

QLI

Power B

Minitab.

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

Power B

Microsoft Excel.

Minitab.

44. Chris is building a database to store prices for items on a restaurant menu.

What data type is most appropriate for this field?

A. Numeric.

B. Date.

C. Tags.

D. Alphanumeric.

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

ETL process.

Record linkage.

ELT process.

System integration.

46. Harry is looking at home sales prices in single zip code and notices that one home sold for $940,394 when the average selling price of similar homes is $210,420.

What type of data does the $940,394 sales price represent?

Choose the best answer.

Duplicate data.

Data outlier.

Redundant data.

Invalid data.

47. What category of data stewardship work is focused on ensuring that the organization respects the wishes of data subjects?

Data quality.

Data privacy.

Data security.

Regulatory compliance.

48. What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?

49. Which of the following contains alphanumeric values?

10.1Ε²

13.6

1347

A3J7

50. Which of the following roles is responsible for ensuring an organization's data quality, security, privacy, and regulatory compliance?

Data owner.

Data steward.

Data custodian.

Data processor.

New CompTIA Data+ Certification DA0-001 Practice Questions [2022] For Learning