DA0-001 Online Training Archives

It is easy for you to download CompTIA DA0-001 CompTIA Data+ Certification Online Training from Exam4Training. It has been specifically designed for CompTIA DA0-001 exam. These exams are designed by CompTIA certified professionals which is the reason why I will always recommend it when it comes to pass DA0-001 exam. With the help of Exam4Training you will get all the latest questions and answers for CompTIA Data+ Certification exam. I am confident that you can score excellent grades for the CompTIA Data+ DA0-001 exam.

Page 1 of 5

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

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

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

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

8in (20cm)

5 kids

2.5mi (4km)

10.7lbs (4.9kg)

5. Which of the following contains alphanumeric values?

10.1Ε²

13.6

1347

A3J7

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

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

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

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

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

Page 2 of 5

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

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

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

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

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

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

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

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

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

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

Page 3 of 5

21. Analytics reports should follow corporate style guidelines.

True.

False.

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

Variance.

Mode.

Median.

Mean.

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

XSS

ELT

ETL

APIs

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

Snowflake.

Square.

Spiral.

Sphere.

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

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

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

DRO

MODIF

DELET

ALTE

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

Python.

C++

Java.

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

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

Page 4 of 5

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

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

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

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

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

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

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

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

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

40. 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 5 of 5

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

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

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

Which statistic best matches her need?

Interquartile range.

Range.

Median.

Standard deviation.

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

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

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

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

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

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

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