Free CompTIA DA0-002 Exam Dumps Questions & Answers

A data analyst needs to combine the results of two separate queries that have similar data and the same number of columns. The output must also have distinct rows. Which of the following should the data analyst use?

• A.Outer join
• B.Concatenate
• C.Union
• D.Aggregate

Which of the following best describes the function of a data type?

• A.To differentiate the real value of the field in its context
• B.To identify the program needed to open a file
• C.To make the addition of individual records simpler
• D.To provide a generic identifier for files used in analysis

A sales analyst is using the following table to produce a report on January sales data:

Which of the following inconsistencies is present in the data set?

• A.Redundancy
• B.Missing values
• C.Outliers
• D.Duplication

Which of the following data repositories stores unformatted data in its original, raw form?

• A.Data lake
• B.Data warehouse
• C.Data mart
• D.Data silo

A data analyst deployed a report for public access. A user states that the report is not showing the latest information, even though the user updated the source an hour ago. Which of the following should the data analyst check first?

• A.Database connection
• B.User privileges
• C.Event log
• D.Report corruption