ExamGecko
Search Search Login
Home Home / CompTIA / DA0-001
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A JSON file is an example of:
Given the diagram below: Which of the following steps is missing?
An analyst notices changes in sales ratios when analyzing a quarterly report. Which of the following is the analyst conducting?
Given the below: Which of the following numbers represents a Type I error?
Which of the following is the best description of the term 'data governance'?
A data analyst is performing a data merge within a spreadsheet using the tables below: The analyst is attempting to pull the addresses from Table 2 into Table 1 using the last names and is receiving an error message. Which of the following steps can the analyst perform to fix the error?
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?
Refer to the exhibit. Given the diagram below: Which of the following data schemas shown?
Given the following report: Which of the following components need to be added to ensure the report is point-in-time and static? (Select two).
Which one the following is not considered an aggregate function?

Question 85 - DA0-001 discussion

Report
Export

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)

A.
Apostrophe.
Answers
A.
Apostrophe.
B.
Commas.
Answers
B.
Commas.
C.
Symbols.
Answers
C.
Symbols.
D.
Duplicates.
Answers
D.
Duplicates.
E.
Misspellings.
Answers
E.
Misspellings.
Suggested answer: D, E

Explanation:

1. Duplicates

2. Misspellings

The most common data quality issues are difficult to resolve in Excel because of their rigidity. It forces analysts to do a ton of manual work, which results in a high probability of an error being introduced to the data set. Those common issues include:

- Blanks

- Nulls

- Outliers

- Duplicates

- Extra spaces

- Misspellings

- Abbreviations and domain-specific variations

- Formula error codes

When introduced, these errors can skew or even invalidate the resulting analysis. A smart tool would minimize the possibility of error by automating the manual work. In Excel, you might look for data quality issues in one of two ways. First, you might use auto filters on specific columns to scan for anomalies and blanks or you might use a pivot table to find gaps and discrepancies.

In either case, you're scanning for the anomalies yourself. Suffice it to say that's not a very efficient process. It also means accuracy is only as good as the analyst's eye, so the probability of error varies throughout the day.

Show Answer
asked 02/10/2024
Santanu Roy
34 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms