Week 3 – Databases: Where data lives – Shuffle Q/A 2

21. A data analyst reviews a database of Wisconsin car sales to find the last car models sold in Milwaukee in 2019. How can they sort and filter the data to return the last five cars sold at the top of their list? Select all that apply.

  • Filter out sales outside of Milwaukee
  • Filter out sales not in 2019
  • Sort by sale date in descending order
  • Sort by sale date in ascending order

22. When writing a query, the name of the dataset can either be inside two backticks, or not, and the query will still run properly.

  • True
  • False

23. A data analyst chooses not to use external data because it represents diverse perspectives. This is an appropriate decision when working with external data.

  • True
  • False

Devendra Kumar

Project Management Apprentice at Google

Leave a Reply