Practice More Questions From: Advanced Functions
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
0 Comments
