Advanced Functions
Graded Quiz • 30 min Quiz08 Questions Week 2
Re⥃askly Logo

Advanced Functions

Graded Quiz • 30 min Quiz08 Questions Week 2
Practice More Quizzes:
Quiz
08 Questions Week 2
Quiz
15 Questions Week 3
Quiz
10 Questions Week 4

Q:

What is a typical use case where you could take advantage of an Approximate Aggregation function like APPROX_TOP_COUNT()?

Q:

What is the key benefit of using an approximate aggregation function?

Q:

What does a result of 1 or -1 of a correlation CORR() between a pair of numbers represent?

Q:

What is an analytical function, like RANK(), and how is it different than an aggregate function?

Q:

What clause defines the “window” or partition of data rows within a table that are operating over with your analytic function?

Q:

What is HyperLogLog++ (HLL) and why is it used in BigQuery?

Q:

Which one of these is NOT a benefit of using a Common Table Expression (WITH clause)?

Q:

True or False: User Defined Functions (UDFs) should never be used — consider writing the query with SQL first

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
Find Questions in This Page: "CTRL+F"