CERTIFIED-DATA-ANALYST-ASSOCIATE · Question #74
A data analyst needs 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 coun
Sign in or unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to reveal the answer and full explanation for question #74. The question stem and answer options stay visible for context.
Question
A data analyst needs 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 code block will accomplish the above task?
Options
- ASELECT * FROM my_table WHERE age > 25 AND country = 'Canada';
- BSELECT user_id, email_address FROM my_table WHERE age > 25 AND country
- CSELECT age, country FROM my_table WHERE age > 25 AND country = 'Canada';
- DSELECT user_id, email_address FROM my_table WHERE age = 25 AND
Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to see the answer
You've previewed enough free CERTIFIED-DATA-ANALYST-ASSOCIATE questions. Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.