Unlock the power of your data in the cloud! Get hands-on with Google Cloud's core data services like BigQuery and Looker to validate your practical skills in data ingestion, analysis, and management, and earn your Associate Data Practitioner certification!
Prepare and test your skills
Prepare and test your skills
Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.
A data analyst is using a BigQuery notebook (Colab Enterprise) to analyze sales performance across retail regions. In an earlier Python code cell, the analyst defined a numerical threshold:
StudyCerts
StudyCertssales_threshold = 10000
The analyst now wants to execute a query in a dedicated SQL cell to retrieve all records from sales_dataset.orders where order_total exceeds this value.
How should the analyst reference the Python variable inside the SQL cell query?
Enclose the variable name in double angle brackets, such as WHERE order_total > <>
Prefix the variable name with a dollar sign, such as WHERE order_total > $sales_threshold
Wrap the variable name in percent symbols, such as WHERE order_total > %sales_threshold%
Enclose the variable name in curly braces, such as WHERE order_total > {sales_threshold}
Keep the momentum going with these hand-picked practice scenarios
Want more questions like this?
Get a free certification question every week.
Still curious? Scout, our AI tutor, can explain this concept further and answer your follow-up questions.