DA0-002 Practice Test

DA0-002 Practice Test practice questions, page 5 of 6, with answer review and explanations.

Question 21

A data analyst needs to join data from two tables in a way that all data from one table is shown even if a matching row is not in the other table. Which of the following should the analyst use to achieve the desired output?

  1. INNER JOIN
  2. CROSS JOIN
  3. RIGHT OUTER JOIN
  4. FULL OUTER JOIN

Question 22

Which of the following best represents a type of infrastructure that requires a company to purchase and maintain all of its own servers?

  1. Private
  2. Cloud
  3. Hybrid
  4. Public

Question 23

A data analyst receives a flat file that includes dates. The analyst needs to calculate the number of days from the dates on the file to the current date. Which of the following is the best way to complete this task?

  1. Convert data to date format and use date functions.
  2. Validate the date format with logical functions and use date functions to analyze.
  3. Use date functions to analyze the data with no conversion.
  4. Transform data to a numerical value and use mathematical functions.

Question 24

A manager wants a report that contains the days off for each direct report. The manager needs this report to always be up-to-date with the latest data. Which of the following describes the refresh frequency that the manager is requesting?

  1. Real-time
  2. Ad hoc
  3. Snapshot
  4. Dynamic

Question 25

The human resources department wants to know the number of employees who earn $125,000 or more. However, the department is concerned about duplicates in the data set. Given the following table: Which of the following SQL statements resolves this issue?