Free CompTIA DA0-001 Exam Dumps Questions & Answers

An analyst is reporting on the average income for a county and is reviewing the following data:

Which of the following is the reason the analyst would need to cleanse the data in this data set?

• A.Missing values
• B.Data completeness
• C.Duplicate data
• D.Data outliers

A data analyst needs to collect a similar proportion of data from every state. Which of the following sampling methods would be the most appropriate?

• A.Random sampling
• B.Stratified sampling
• C.Convenience sampling
• D.Systematic sampling

A sales manager requested a report that contains the first name, last name, and phone number of all of the company's customers and employees. The data engineer needs to return all the records from several tables, even duplicates. Which of the following is the best way to join the two tables?

• A.FULL INNER JOIN
• B.CROSS JOIN
• C.LEFT OUTER JOIN
• D.FULL OUTER JOIN

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?

• A.Create a dashboard with a date range picker and calculations built in.
• B.Create multiple reports, one for each needed date range.
• C.Build calculations into the report so they are done automatically.
• D.Add macros to the report to speed up the filtering and calculations process.

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.

• A.Redundant Data.
• B.Duplicate Data.
• C.Invalid Data.
• D.Missing Data.