🔍

DA0-001 — questions

Page 2 of 15 · 294 total questions.

DA0-001 Question 21

Single page →
Topic 1 · Question 21

An e-commerce company recently tested a new website layout. The website was tested by a test group of customers, and an old website was presented to a control group. The table below shows the percentage of users in each group who made purchases on the websites: Which of the following conclusions is accurate at a 95% confidence interval?

Exhibit 1 for question 21
  • AIn Germany, the increase in conversion from the new layout was not significant. (correct answer)
  • BIn France, the increase in conversion from the new layout was not significant.
  • CIn general, users who visit the new website are more likely to make a purchase.
  • DThe new layout has the lowest conversion rates in the United Kingdom.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: In Germany, the increase in conversion from the new layout was not significant.

DA0-001 Question 22

Single page →
Topic 1 · Question 22

An analyst needs to provide a chart to identify the composition between the categories of the survey response data set: Which of the following charts would be BEST to use?

Exhibit 1 for question 22
  • AHistogram
  • BPie (correct answer)
  • CLine
  • DScatter pot
  • EWaterfall
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Pie

DA0-001 Question 23

Single page →
Topic 1 · Question 23

Five dogs have the following heights in millimeters: 300, 430, 170, 470, 600 Which of the following is the mean height for the five dogs?

  • A394mm (correct answer)
  • B405mm
  • C493mm
  • D504mm
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: 394mm

DA0-001 Question 24

Single page →
Topic 1 · Question 24 · Select all that apply

Which of the following are reasons to create and maintain a data dictionary? (Choose two.)

  • ATo improve data acquisition (correct answer)
  • BTo remember specifics about data fields
  • CTo specify user groups for databases
  • DTo provide continuity through personnel turnover (correct answer)
  • ETo confine breaches of PHI data
  • FTo reduce processing power requirements
Reveal answer & explanation
Correct answer: A, D

The correct answer is A, D. Option A: To improve data acquisition Option D: To provide continuity through personnel turnover

DA0-001 Question 25

Single page →
Topic 1 · Question 25

A recurring event is being stored in two databases that are housed in different geographical locations. A data analyst notices the event is being logged three hours earlier in one database than in the other database. Which of the following is the MOST likely cause of the issue?

  • AThe data analyst is not querying the databases correctly.
  • BThe databases are recording different events.
  • CThe databases are recording the event in different time zones. (correct answer)
  • DThe second database is logging incorrectly.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: The databases are recording the event in different time zones.

DA0-001 Question 26

Single page →
Topic 1 · Question 26

Which of the following is an example of a at flat file?

  • ACSV file (correct answer)
  • BPDF file
  • CJSON file
  • DJPEG file
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: CSV file

DA0-001 Question 27

Single page →
Topic 1 · Question 27

Given the following graph: Which of the following summary statements upholds integrity in data reporting?

Exhibit 1 for question 27
  • ASales are approximately equal for Product A and Product B across all strategies.
  • BStrategy 4 provides the best sales in comparison to other strategies.
  • CWhile Strategy 2 does not result in the highest sales of Product D, over all products it appears to be the most effective. (correct answer)
  • DProduct D should be promoted more than the other products in all strategies.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: While Strategy 2 does not result in the highest sales of Product D, over all products it appears to be the most effective.

DA0-001 Question 28

Single page →
Topic 1 · Question 28

An analyst is required to run a text analysis of data that is found in articles from a digital news outlet. Which of the following would be the BEST technique for the analyst to apply to acquire the data?

  • AWeb scraping (correct answer)
  • BSampling
  • CData wrangling
  • DETL
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Web scraping

DA0-001 Question 29

Single page →
Topic 1 · Question 29

An analyst runs a report on a daily basis, and the number of datapoints must be validated before the data can be analyzed. The number of datapoints increases each day by approximately 20% of the total number from the day before. On a given day, the number of datapoints was 8,798. Which of the following should be the total number of datapoints on the next day?

  • A7,038
  • B9,600
  • C10,600 (correct answer)
  • D10,800
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: 10,600

DA0-001 Question 30

Single page →
Topic 1 · Question 30

An analyst has been tracking company intranet usage and has been asked to create a chat to show the most-used/most-clicked portions of a homepage that contains more than 30 links. Which of the following visualizations would BEST illustrate this information?

  • AScatter plot
  • BHeat map (correct answer)
  • CPie chart
  • DInfographic
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Heat map

DA0-001 Question 31

Single page →
Topic 1 · 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?

Exhibit 1 for question 31
  • AAggregate
  • BLogical (correct answer)
  • CDate
  • DSort
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Logical

DA0-001 Question 32

Single page →
Topic 1 · 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?

  • ADelete any of the responses that do not have “January” written out.
  • BReplace any of the responses that have “01”.
  • CFilter on any of the responses that do not say “January” and update them to “January”. (correct answer)
  • DSort any of the responses that say “Jan” and update them to “01”.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Filter on any of the responses that do not say “January” and update them to “January”.

DA0-001 Question 33

Single page →
Topic 1 · Question 33

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

  • AMissing data
  • BDuplicate data (correct answer)
  • CRedundant data
  • DInvalid data
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Duplicate data

DA0-001 Question 34

Single page →
Topic 1 · 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?

  • AA stratified phone survey of 100 people that is conducted between 2:00 p.m. and 3:00 p.m.
  • BA systematic survey that is sent to 100 single-family homes in the county
  • CSurveys sent to ten randomly selected homes within 5mi (8km) of the county’s office
  • DSurveys sent to 100 randomly selected homes that are reflective of the population (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Surveys sent to 100 randomly selected homes that are reflective of the population

DA0-001 Question 35

Single page →
Topic 1 · Question 35

Which of the following statistical methods requires two or more categorical variables?

  • ASimple linear regression
  • BChi-squared test (correct answer)
  • CZ-test
  • DTwo-sample t-test
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Chi-squared test

DA0-001 Question 36

Single page →
Topic 1 · Question 36

Which of the following data manipulation techniques is an example of a logical function?

  • AWHERE
  • BAGGREGATE
  • CBOOLEAN
  • DIF (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: IF

DA0-001 Question 37

Single page →
Topic 1 · Question 37

A sales team wants visibility of current sales numbers, pipeline, and team performance. The team would also like to see calculations of individuals’ earned commissions and projected commissions based on sales, but they want that information to be kept confidential. Which of the following would be the BEST way to provide this visibility?

  • ACreate a dashboard displaying a data refresh date so users know the current sales numbers and configure permissions to control access.
  • BCreate a dashboard for sales numbers, pipeline, and team and individual performance for the management team.
  • CCreate a dashboard with filters for the overall team, individuals, and management. Users can filter to see the data they want.
  • DCreate a dashboard with views for team, individuals, and management. Configure permissions to control access. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Create a dashboard with views for team, individuals, and management. Configure permissions to control access.

DA0-001 Question 38

Single page →
Topic 1 · Question 38

Which of the following is a characteristic of a relational database?

  • AIt utilizes key-value pairs.
  • BIt has undefined fields.
  • CIt is structured in nature. (correct answer)
  • DIt uses minimal memory.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: It is structured in nature.

Explanation

Network address translation maps addresses between networks and commonly lets private hosts share public connectivity.

DA0-001 Question 39

Single page →
Topic 1 · Question 39

A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Which of the following date ranges should be on the report?

  • AJanuary 1, 2020 to April 1, 2020
  • BJanuary 1, 2020 to April 7, 2020
  • CJanuary 1, 2020 to April 8, 2020 (correct answer)
  • DJanuary 1, 2020 to April 9, 2020
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: January 1, 2020 to April 8, 2020

DA0-001 Question 40

Single page →
Topic 1 · Question 40

Given the following data tables: Which of the following MDM processes needs to take place FIRST?

Exhibit 1 for question 40Exhibit 2 for question 40Exhibit 3 for question 40
  • ACreation of a data dictionary
  • BCompliance with regulations
  • CStandardization of data field names (correct answer)
  • DConsolidation of multiple data fields
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Standardization of data field names

Showing questions 21–40 of 294 · Page 2 of 15