Week 4 – Performing data calculations – Shuffle Q/A 2

21. What SQL keyword is used to define a name for a calculated column?

  • AS
  • FROM
  • WITH

22. A data analyst uses the following formula to calculate a new row in a SQL query. What best describes the result of the formula?

(colA + colB) / colC = new_col

  • colB is added to colA then the result is multiplied by colC.
  • colB is subtracted from colA then the result is multiplied by colC.
  • colB is added to colA then the result is divided by colC.
  • colB is divided by colC then the result is added to colA.

23. What is the process of checking and rechecking the quality of your data so that it is complete, accurate, secure, and consistent?

  • Data-driven development
  • Data visualization
  • Data augmentation
  • Data validation

24. A data analyst finds some data that seems inconsistent. What is the first thing they should do?

  • Remove the inconsistent values.
  • Convert the inconsistent values to JSON.
  • Fill the odd values with filler values.
  • Determine if the inconsistent values are valid.

25. What is a reason to use a WITH AS clause in a SQL statement?

  • The result is temporary.
  • The result is a pivot table.
  • The result calculates faster.
  • The result is a visualization.

26. Which of the following SQL statements can be used to create temporary tables in SQL?

  • WITH my_table FROM (SELECT * FROM other_table);
  • WITH my_table AS (SELECT * FROM other_table WHERE x = 0);
  • CREATE TABLE my_table AS (SELECT * FROM other_table);
  • SELECT * FROM table;

27. A data analyst wants to calculate the number of rows that have a SKU value of “K102145”. Which function could they use?

  • =COUNTIF(G2:G30,K102145)
  • =COUNTIF(K102145=G2:G30)
  • =COUNTIF(G2:G30,“=K102145”)
  • =COUNTIF(G2:G30,“K102145”)

28. A data analyst wants to use a single function to multiply two ranges and then add the multiplied values. What single function can they use to accomplish this?

  • SUM

Shuffle Q/A 2

29. Which values of Date and Direction are used to calculate the value 450 in the following pivot table?

  • 2/3 and Down
  • 2/4 and Up
  • 2/5 and Down
  • 2/4 and Down

30. When writing custom calculations in SQL, what characters can be used to group calculations to change the order of calculation?

  • Parentheses – ( )
  • Curly Braces – { }
  • Quotation Marks – “ “
  • Square Brackets – [ ]

Devendra Kumar

Project Management Apprentice at Google

Leave a Reply