Practice Test 4 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
Which of these is the correct statement for Javascript UDF in BigQuery.
A. The user cannot reference a table in UDF.
B. The output of a single row processed by Javascript UDF should be 5MB or less.
C. Filtering down data before passing to a Javascript UDF does not have any performance benefits.
D. BigQuery only provides persistent UDF that can be used across multiple queries. Creating UDF only for a single query is not yet available.
Correct Answer – B
Option A is incorrect. ”
- A maximum number of unique UDF plus table references per query — 1000 After full expansion, each UDF can reference up to 1000 combined unique tables and UDFs.
Option B is correct. Data processed for a single row by Javascript UDF in BiqQuery should be 5MB or less. BigQuery processing environment for Javascript UDF has limited memory available per query.
Option C is incorrect. Filtering down the data before being passed to Javascript UDF will have performance benefits as query execution will be faster.
Option D is incorrect. Bigquery provides both persistent and temporary UDF. Temporary UDF can only be used in a single query.
Refer GCP Documentation –
Comments are closed, but trackbacks and pingbacks are open.