Week 3 – The wonderful world of data – Shuffle Q/A 1

11. A data analyst is working at a small tech startup. On their current project they are in the analyze stage of the data life cycle. What might they do in this stage?

  • Choose the format of their spreadsheet headings
  • Determine who is responsible for managing the data
  • Validate the insights provided by analysts
  • Use a formula to perform calculations

12. Fill in the blank: Data analysis has six process steps whereas the data life cycle has six _____.

  • data analytics tools
  • steps
  • stages
  • key questions

13. What is the main difference between a formula and a function?

  • A formula can be used multiple times in a spreadsheet; a function can only be used once.
  • A formula begins with an equal sign (=); a function begins with an asterisk (*).
  • A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process.
  • A formula is used to add or subtract; a function is used to multiply or divide.

14. What does a data analyst use to request information within a database?

  • Calculation
  • Dashboard
  • Formula
  • Query

15. Why is SQL the most popular structured query language? Select all that apply.

  • SQL allows data analysts to use spreadsheets
  • SQL is the most secure database on the market
  • SQL is easy to understand
  • SQL works with a wide variety of databases

16. A data analyst uses spreadsheets to aggregate data during the capture phase of the data life cycle.

  • True
  • False

17. Fill in the blank: The data life cycle has six _____ .

  • data analytics tools
  • process steps
  • key questions
  • stages

18. Fill in the blank: A query is used to _____ information from a database. Select all that apply.

  • request
  • retrieve
  • visualize
  • update

Shuffle Q/A 2

19. Structured query language (SQL) allows a data analyst to retrieve and request data from a database. What else is SQL used for?

  • Visualizing data within a database
  • The revising phase of the data life cycle
  • Updating databases
  • The sharing phase of the data life cycle

20. Fill in the blank: A business is determining who should be responsible for the data in their current data analysis project. This means that the company is in the ______ stage of the data life cycle.

  • manage
  • plan
  • analyze
  • capture

Devendra Kumar

Project Management Apprentice at Google

Leave a Reply