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

• SELECT
• 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”)

• SUM
• SUMPRODUCT
• SUMIF
• SUMIFS

Shuffle Q/A 2

• 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 – [ ]