1.
Вопрос 1
A data analyst working with a large dataset of student grades aims to identify all students who
scored above 90% in a specific subject, sort their names alphabetically, and calculate the group
average. Why would the analyst use SQL instead of spreadsheet built-in functions to perform this
task?
SQL allows them to write multiple queries to identify the students instead of individually filtering the
data using spreadsheet functions.
SQL allows them to write a single query to identify the students instead of individually filtering the
data using spreadsheet functions.
SQL allows them to write a single query to identify the students, whereas spreadsheets do not offer
a filtering function.
SQL automatically calculates averages and identifies criteria related to grades and scores.
Правильно
That’s correct! SQL allows you to write one query that does the same work as multiple tasks in a
spreadsheet.
Статус: [object Object]
1 / 1 балл
2.
Вопрос 2
What is one of the benefits of learning a new programming language like SQL?
It improves your skills as a data analyst when working with databases and data analytics programs
beyond spreadsheets
It improves the quality of your data by enabling you to extract and shape relevant data
It allows you to perform advanced data manipulation in spreadsheets
It allows you to automate repetitive tasks when working in spreadsheets
Правильно
That’s correct! SQL is a useful and powerful language to learn.
Статус: [object Object]
1 / 1 балл
3.
Вопрос 3
What capabilities does SQL offer when working with large data sets?
SQL can filter and extract data through individual functions.
SQL can perform complex calculations and image processing.
SQL can filter and extract data based on specific criteria.
SQL can predict patterns and trends.
Правильно
That’s correct! SQL helps data analysts filter and extract specific data from large datasets and is a
key feature in data analysis.
Статус: [object Object]
1 / 1 балл
4.
Вопрос 4
What query language is used in Google Sheets?
Spreadsheet Query Language
Google Visualization API Query Language
Google Visualization Language
Google Data Language
Неправильно
Not quite. Please review the video SQL in Google Sheets.
Статус: [object Object]
0 / 1 балл
5.
Вопрос 5
A data analyst wants to write a query and select all the columns from their dataset. What should they
include in the clause?
Include a semicolon (;) after typing the “SELECT” clause
Include a semicolon (;) before typing the “SELECT” clause
Include an asterisk (*) after typing the “SELECT” clause
Include an asterisk (*) before typing the “SELECT” clause
Неправильно
Not quite. Please review the video SELECT Statements.
Статус: [object Object]
0 / 1 балл
6.
Вопрос 6
What are non-numeric values called?
Strings
Integers
Operators
Booleans
Правильно
That’s correct! These include values like words, letters, or combinations of letters and numbers.
Статус: [object Object]
1 / 1 балл
7.
Вопрос 7
You are querying a data set and want to select all rows in column C and limit the results to 15 rows.
Which of the following commands would you use?
SELECT * WHERE C=”Online” ORDER BY E *LIMIT 15
SELECT * WHERE C=Online ORDER BY E *LIMIT 15
SELECT * WHERE C=’Online’ ORDER BY E LIMIT 15
SELECT * WHERE C=’Online’ ORDER BY E + LIMIT 15
Правильно
That’s correct! To limit your query, add the word LIMIT and the number of rows you want to show.
Статус: [object Object]
1 / 1 балл
8.
Вопрос 8
When working in Google Sheets, how would you modify your query to calculate the sum of values
from columns D and E?
Include D & E directly after selecting columns
Include D, E directly after selecting columns
Include D_E directly after selecting columns
Include D + E directly after selecting columns
Правильно
That’s correct! To add these two columns, add the + symbol at the end of the query.
Статус: [object Object]
1 / 1 балл
9.
Вопрос 9
You are working with a data set containing a company's sales figures, including columns for item
costs (D) and quantity sold (E). Which of the following queries will calculate the average item cost?
SELECT SUM(D), COUNT (E)
SELECT SUM(D), COUNT (D) + SUM(E), COUNT (E)
SELECT SUM(D), COUNT (D) / SUM(E), COUNT (E)
SELECT SUM(D), COUNT (D), SUM(E), COUNT (E)
Правильно
That’s correct! This query will calculate the total revenue by adding the sum of the item costs (D) and
the sum of quantities sold (E).
Статус: [object Object]
1 / 1 балл
10.
Вопрос 10
Which aggregation functions are commonly used with the GROUP BY clause?
COUNT, SUM, AVG, MIN, MAX
ORDER BY, MIN, MAX
WHERE, AND ORDER BY
COUNT, SUM, AVG, AND ORDER BY
Неправильно
Not quite. Please review the video Group By Functions.
1.
Вопрос 1
What is one advantage of using SQL in data analysis?
It allows collaboration with spreadsheet features
It helps extract specific relevant data from a large data set
It creates real-time data visualizations
It includes advanced formatting features
Правильно
That’s correct! SQL allows you to select and retrieve specific data from a large dataset by selecting
only columns relevant to your analysis.
Статус: [object Object]
1 / 1 балл
2.
Вопрос 2
What is one of the benefits of learning a new programming language like SQL?
It improves your skills as a data analyst when working with databases and data analytics programs
beyond spreadsheets
It allows you to perform advanced data manipulation in spreadsheets
It improves the quality of your data by enabling you to extract and shape relevant data
It allows you to automate repetitive tasks when working in spreadsheets
Правильно
That’s correct! SQL is a useful and powerful language to learn.
Статус: [object Object]
1 / 1 балл
3.
Вопрос 3
True or False: You can use SQL to select specific data and perform calculations, like finding a
dataset's maximum or minimum values.
True
False
Неправильно
Not quite. Please review the video Examples: Using SQL.
Статус: [object Object]
0 / 1 балл
4.
Вопрос 4
What is the correct format when using the QUERY function in Google Sheets?
QUERY(data, query, [headers])
QUERY(headers, data, [query])
QUERY(query, data, [headers])
QUERY(data, headers, [query])
Неправильно
Not quite. Please review the video SQL in Google Sheets.
Статус: [object Object]
0 / 1 балл
5.
Вопрос 5
A data analyst working in Google Sheets writes the statement " SELECT A, C." What does this query
intend to do?
Retrieve results from columns A and C in no particular order
Add the values in columns A and C
Retrieve results from columns A and C in that order
Sort the data in columns A and C
Правильно
That’s correct! To select and choose specific data from a dataset, include the letter ID in your
chosen order, with a comma between each ID.
Статус: [object Object]
1 / 1 балл
6.
Вопрос 6
What are non-numeric values called?
Booleans
Operators
Integers
Strings
Правильно
That’s correct! These include values like words, letters, or combinations of letters and numbers.
Статус: [object Object]
1 / 1 балл
7.
Вопрос 7
Which of the following example commands uses the ORDER BY clause correctly?
SELECT * WHERE D=’Product’ and ORDER BY C
SELECT * WHERE D=”Product” + ORDER BY C
SELECT * WHERE D=’Product’ *ORDER BY C
SELECT * WHERE D=’Product’ ORDER BY C
Неправильно
Not quite. Please review the video ORDER BY and LIMIT Clauses.
Статус: [object Object]
0 / 1 балл
8.
Вопрос 8
What are arithmetic operators used for in Google Sheets?
To perform calculations on numeric values in data
To format cells with special numbers
To create charts based on numerical data
To create conditional formatting rules
Неправильно
Not quite. Please review the video Arithmetic Functions.
Статус: [object Object]
0 / 1 балл
9.
Вопрос 9
You are working with a data set of columns containing a company's sales figures, such as item costs
(D) and quantity sold(E). Which of the following queries will calculate the total revenue generated?
SELECT SUM(D), SUM(E)
SELECT SUM(D, E)
SELECT SUM(D*E)
SELECT SUM(D+E)
Неправильно
Not quite. Please review the video Aggregate Functions.
Статус: [object Object]
0 / 1 балл
10.
Вопрос 10
Consider the following SQL query:
=QUERY(data!A1:L,"SELECT * GROUP BY E")
What should you add to make this an accurate query?
COUNT, AVG, or SUM
SELECT
WHERE
TO or FROM
Неправильно
Not quite. Please review the video Group By Functions.
Статус: [object Object]
0 / 1 балл
1.
Вопрос 1
What is one advantage of using SQL in data analysis?
It creates real-time data visualizations
It allows collaboration with spreadsheet features
It helps extract specific relevant data from a large data set
It includes advanced formatting features
Правильно
That’s correct! SQL allows you to select and retrieve specific data from a large dataset by
selecting only columns relevant to your analysis.
Статус: [object Object]
1 / 1 балл
2.
Вопрос 2
What is one advantage of using SQL in data analysis?
SQL retrieves specific data from a database without changing it and automatically retrieves the
most updated information from the source.
SQL allows collaboration with multiple sources.
SQL provides real-time reports, ensuring all data is relevant and up-to-date.
SQL retrieves data and changes it to ensure it is up-to-date.
Правильно
That’s correct! SQL collects up-to-date information from the original data source without
modifying the data.
Статус: [object Object]
1 / 1 балл
3.
Вопрос 3
What capabilities does SQL offer when working with large data sets?
SQL can perform complex calculations and image processing.
SQL can filter and extract data based on specific criteria.
SQL can predict patterns and trends.
SQL can filter and extract data through individual functions.
Правильно
That’s correct! SQL helps data analysts filter and extract specific data from large datasets and is
a key feature in data analysis.
Статус: [object Object]
1 / 1 балл
4.
Вопрос 4
What query language is used in Google Sheets?
Google Visualization Language
Spreadsheet Query Language
Google Data Language
Google Visualization API Query Language
Неправильно
Not quite. Please review the video SQL in Google Sheets.
Статус: [object Object]
0 / 1 балл
5.
Вопрос 5
What is the purpose of a SELECT statement when writing queries in Google Sheets?
It tells the query which data to retrieve from the data set
It sets the query’s filtering criteria
It indicates the sorting order
It defines the data types in the column
Неправильно
Not quite. Please review the video SELECT Statements.
Статус: [object Object]
0 / 1 балл
6.
Вопрос 6
What are non-numeric values called?
Operators
Booleans
Strings
Integers
Неправильно
Not quite. Please review the video AND, OR, and WHERE Clauses.
Статус: [object Object]
0 / 1 балл
7.
Вопрос 7
True or False: The ORDER BY clause enables you to include in your query how many resulting
rows you want or the number of resulting rows up to a limit.
True
False
Правильно
That’s correct! The LIMIT clause, not the ORDER BY clause, allows you to specify how
many rows you want to include in the query result.
Статус: [object Object]
1 / 1 балл
8.
Вопрос 8
When working in Google Sheets, how would you modify your query to calculate the sum of
values from columns D and E?
Include D & E directly after selecting columns
Include D, E directly after selecting columns
Include D_E directly after selecting columns
Include D + E directly after selecting columns
Неправильно
Not quite. Please review the video Arithmetic Functions.
Статус: [object Object]
0 / 1 балл
9.
Вопрос 9
You are working with a data set of columns containing a company's sales figures, such as item
costs (D) and quantity sold(E). Which of the following queries will calculate the total revenue
generated?
SELECT SUM(D*E)
SELECT SUM(D), SUM(E)
SELECT SUM(D, E)
SELECT SUM(D+E)
Неправильно
Not quite. Please review the video Aggregate Functions.
Статус: [object Object]
0 / 1 балл
10.
Вопрос 10
Consider the following SQL query:
=QUERY(data!A1:L,"SELECT * GROUP BY E")
What should you add to make this an accurate query?
SELECT
TO or FROM
WHERE
COUNT, AVG, or SUM
Неправильно
Not quite. Please review the video Group By Functions.
