Free DA0-001 Exam braindumps download (DA0-001 exam dumps Free)

QUESTION: 31

An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:

Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

Aggregate
Logical
Date
Sort

Answer(s): B

Show Answer Next Question

QUESTION: 32

While reviewing survey data, an analyst notices respondents entered “Jan,” “January,” and “01” as responses for the month of January. Which of the following steps should be taken to ensure data consistency?

Delete any of the responses that do not have “January” written out.
Replace any of the responses that have “01”.
Filter on any of the responses that do not say “January” and update them to “January”.
Sort any of the responses that say “Jan” and update them to “01”.

Answer(s): C

Show Answer Next Question

QUESTION: 33

Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

Missing data
Duplicate data
Redundant data
Invalid data

Answer(s): B

Show Answer Next Question

QUESTION: 34

A county in Illinois is conducting a survey to determine the mean annual income per household. The county is 427sq mi (2.65q km). Which of the following sampling methods would MOST likely result in a representative sample?

A stratified phone survey of 100 people that is conducted between 2:00 p.m. and 3:00 p.m.
A systematic survey that is sent to 100 single-family homes in the county
Surveys sent to ten randomly selected homes within 5mi (8km) of the county’s office
Surveys sent to 100 randomly selected homes that are reflective of the population

Answer(s): D

Show Answer Next Question