Analytics window functions

Which of the following functions is used to return a value for a subsequent row in relation to the current row?

• COUNT

• SUM

• LEAD

• RANK

Which of the following is NOT one of the three groups of window functions in BigQuery?

• Standard aggregations

• Navigation functions

• Filtering functions

• Ranking and numbering functions

What is the purpose of the LEAD function in BigQuery?

• To calculate the average of a column

• To return a value for a subsequent row in relation to the current row

• To count the number of rows in a table

• To rank rows within a partition

In the context of BigQuery window functions, what does the COUNT function do?

• It counts the number of rows in a table.

• It returns a value for a subsequent row in relation to the current row.

• It calculates the sum of a column.

• It ranks rows within a partition.

What is a key feature of the WITH clause in BigQuery?

• It performs a rank operation on rows.

• It is used to isolate SQL operations and make complex queries more manageable.

• It computes some value expression over a different row in the window frame.

• It returns a value for a subsequent row in relation to the current row.

Which of the following examples is used to rank employees by tenure?

• Partitioning by department and ordering by start date

• Counting the number of employees in each department

• Summing the salaries of all employees

• Calculating the average tenure of employees

What are navigation functions in BigQuery generally used for?

• To aggregate data across rows

• To compute some value expression over a different row in the window frame from the current row

• To count the number of rows in a table

• To rank rows within a partition

Which SQL clause in BigQuery allows for the creation of a named subquery?

• SELECT

• FROM

• WHERE

• WITH

What does the ranking and numbering group of functions primarily deal with?

• Aggregating data

• Determining relationships between rows of data rather than by an external measurement

• Filtering rows based on a condition

• Calculating statistical values

In the example of ranking employees by tenure, what is the sequence of operations performed?

• Counting, partitioning, ordering

• Ordering, summing, ranking

• Partitioning, ordering, ranking

• Filtering, partitioning, ordering