Glossary: Terms and definitions

We’ve covered a lot of terms—some of which you may have already known, and some of which are new. To make it easy to remember what a word means, we created this glossary of terms and definitions.

To use the glossary for this course item, click the link below and select “Use Template.”

Link to glossary: Week 4 Glossary

OR

If you don’t have a Google account, you can download the glossary directly from the attachment below.

Course 5 Week 4 Glossary _ DA terms and definitions

Weekly challenge 4

1st grade

Question 1

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

A. =COUNT(G2:G30,”=shipped”)

B. =SUM(G2:G30,”=shipped”)

C. =COUNTIF(G2:G30,”=shipped”)

D. =MAX(G2:G30,”=shipped”)

The correct answer is C. =COUNTIF(G2:G30,”=shipped”)

Question 2

You are working in a spreadsheet and use the SUMIF function in the following formula as part of your analysis.

=SUMIF(A1:A25,”<10”,C1:C25)

Which part of this formula is the criteria or condition?

A. ”<10”

B. SUMIF

C. C1:C25

D. A1:A25

The correct answer is A. ”<10”

Question 3

What is the purpose of using pivot tables?

A. To allow the use of SQL in spreadsheets

B. To view data in multiple ways to find insights and trends

C. To multiply two arrays and add the results

D. To allow quick copying from one table to another

The correct answer is B. To view data in multiple ways to find insights and trends

Question 4

How many different columns have been added to the values section of the pivot table editor?

A. 1

B. 3

C. 6

D. 2

The correct answer is D. 2

Question 5

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

A. FROM

B. SELECT

C. AS

D. WITH

The correct answer is C. AS

Question 6

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

A. Quotation Marks - “ “

B. Curly Braces - { }

C. Parentheses - ( )

D. Square Brackets - [ ]

The correct answer is C. Parentheses - ( )

Question 7

What is the purpose of using data validation during your analysis process?

A. To guarantee that all of your stakeholders will be happy with your results

B. To ensure that you are able to use every piece of data from your raw data

C. To ensure that all data is complete, accurate, secure, and consistent

D. To guarantee that visualizations are visually pleasing

The correct answer is C. To ensure that all data is complete, accurate, secure, and consistent

Question 8

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

A. Determine if the inconsistent values are valid.

B. Remove the inconsistent values.

C. Convert the inconsistent values to JSON.

D. Fill the odd values with filler values.

The correct answer is A. Determine if the inconsistent values are valid.

Question 9

Which of the following statements about temporary tables is correct?

A. They are declared by enclosing a FROM statement between ##.

B. They must be created using the WITH AS SQL clause.

C. They are automatically deleted when the SQL database session ends.

D. They are a special feature of BigQuery unavailable in other RDBMS.

The correct answer is C. They are automatically deleted when the SQL database session ends.

Question 10

Which of the following SQL queries adds a table into the database? Select all that apply.

• CREATE TABLE my_table AS (SELECT * FROM other_table);
• WITH my_table AS (SELECT * FROM other_table WHERE x = 0);
• SELECT * FROM table;
• SELECT * FROM table GROUP BY columnA ORDER BY columnB;

2nd grade

Passed 100%

Question 1

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

A. =COUNTIF(G2:G30,“=K102145”)

B. =COUNTIF(G2:G30,“K102145”)

C. =COUNTIF(K102145=G2:G30)

D. =COUNTIF(G2:G30,K102145)

The correct answer is B. =COUNTIF(G2:G30,“K102145”)

Question 2

You are working in a spreadsheet and use the SUMIF function in the following formula as part of your analysis.

=SUMIF(D2:D10,”>=50”,E2:E10)

Which part of this formula indicates the range of values to be added?

A. >=50

B. D2:D10

C. E2:E10

D. =SUMIF

The correct answer is C. E2:E10

Question 3

You create a pivot table and want to add up the total of all cells for each row and column value in the pivot table. Which function in the values menu would you use to summarize the data?

A. SUM

B. AVERAGE

C. PRODUCT

D. COUNTA

The correct answer is A. SUM

Question 4

What column is set as a value in the following pivot table?

A. Direction

B. MAX

C. Duration

D. Date

The correct answer is C. Duration

Question 5

In the following SQL query, which column is part of an addition operation that creates a new column?

SELECT 
    Yes_Responses,
    No_Responses,
    Total_Surveys,
    Yes_Responses + No_Responses AS Responses_Per_Survey
FROM
    Survey_1

A. Total_Surveys

B. Responses_Per_Survey

C. Survey_1

D. Yes_Responses

The correct answer is D. Yes_Responses

Question 6

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

(colA + colB) / colC = new_col

A. colB is subtracted from colA then the result is multiplied by colC.

B. colB is added to colA then the result is divided by colC.

C. colB is divided by colC then the result is added to colA.

D. colB is added to colA then the result is multiplied by colC.

The correct answer is B. colB is added to colA then the result is divided by colC.

Question 7

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

A. Data visualization

B. Data validation

C. Data augmentation

D. Data-driven development

The correct answer is B. Data validation

Question 8

What is the purpose of the != operator in SQL?

A. To return the remainder of a division operation

B. To set a value equal to another

C. To check if two values or expressions are not equal

D. To add two values

The correct answer is C. To check if two values or expressions are not equal

Question 9

What is a reason to use a temporary table instead of a standard table in SQL?

A. A temporary table allows functions that are unavailable to standard tables.

B. A temporary table allows analysts to repeatedly work with the same subset of data.

C. A temporary table calculates formulas using less memory than standard tables.

D. A temporary table calculates formulas faster than standard tables.

The correct answer is B. A temporary table allows analysts to repeatedly work with the same subset of data.

Question 10

Which of the following SQL queries adds a table into the database? Select all that apply.

• CREATE TABLE my_table AS (SELECT * FROM other_table);
• WITH my_table AS (SELECT * FROM other_table WHERE x = 0);
• SELECT * FROM table;
• SELECT * FROM table GROUP BY columnA ORDER BY columnB;