Databricks Certified Data Analyst - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A data analyst is required to query the data in my_table. They want to return the values in columns user_id and email_address where records fit the following filter criteria: age is greater than 25 and country is Canada. The analyst does not want to return values from any other columns.
Which following SQL will accomplish the above task?_
A
SELECT * FROM my_table WHERE age > 25 AND country = ’Canada’;*_
B
SELECT user_id, email_address FROM my_table WHERE age > 25 AND country = ’Canada’;_
C
SELECT age, country FROM my_table WHERE age > 25 AND country = ’Canada’;_
D
SELECT user_id, email_address FROM my_table WHERE age = 25 AND country > ’Canada’;_