Week 3 – Aggregating data for analysis – Shuffle Q/A 3

31. A data analyst uses an absolute reference to lock a function array so rows and columns don’t change if the function is copied. What symbol is used to create an absolute reference?

  • Ampersand (&)
  • Asterisk (*)
  • Dollar sign ($)
  • Hashtag (#)

32. What are some of the advantages of using subqueries in SQL? Select all that apply.

  • Subqueries can use special functions.
  • The logic is easier to read and understand.
  • All of the logic is in one place.
  • The query processes more efficiently.

33. The VALUE function converts a numeric value into a text string in a spreadsheet.

  • True
  • False

34. A data analyst locks the rows and columns in their spreadsheet by wrapping their function’s data array in dollar signs ($). Why would they do this?

  • To avoid incorrect calculations caused by changing the array
  • So that the data auto deletes after the function is used
  • So that other analysts’ functions can not access the arrayFeedback: 
  • To stop people from accessing sensitive information in the array

35. Which of the following terms describe a subquery? Select all that apply.

  • Nested query
  • Inner select
  • Inner query
  • Small query

36. The following is a selection from a spreadsheet:

To search for the growth in population in China, what is the correct VLOOKUP syntax?

  • =VLOOKUP(China, A2*C10, 3, false)
  • =VLOOKUP(China, A2:C10, 2, false)
  • =VLOOKUP(“China”, A2:C10, 3, false)
  • =VLOOKUP(“China”, A2:C10, 2, false)

37. You are exploring the employee retention rate for a department in your company. You realize that evaluating several other departments would also be a good idea. You decide to aggregate the data from all desired departments. What does this mean?

  • You have modified the data from each source in order to make it suitable for analysis.
  • You have collected the data from various sources into a single, summarized collection.
  • You have investigated each of the various data sources individually and compared the results.
  • You have ensured that the departments’ data is properly stored, managed, and maintained.

38. A data analyst writes a query in SQL. Inside this query, they have a second query. What is another name for the first query? Select all that apply.

  • Outer query
  • Central select
  • Outer select
  • Subquery

Devendra Kumar

Project Management Apprentice at Google

Leave a Reply