Question 21

Oliver is designing an ETL process to copy sales data into a data warehouse on a hourly basis.
What approach should Oliver choose that would be most efficient and minimize the chance of losing historical data?
  • Question 22

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

    What type of regulation is the Payment Card Industry Data Security Standard (PCIDSS)?
  • Question 24

    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?
  • Question 25

    Which of the following would be considered non-personally identifiable information?