Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Databricks Certified Data Analyst Associate Exam - Topic 1 Question 58 Discussion

Posted by Celeste on Sep 29, 2026 at 04:44 AM

A data analyst filters rows where the tags array includes the value 'sql' using this query:

SELECT * FROM main.analytics.articles WHERE tags = 'sql';

This query returns no results.

How should the analyst query to filter for rows where the tags array contains 'sql'?

Suggested Answer: D

Get Premium Databricks Certified Data Analyst Associate Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
9 comments · newest first
RI
Rikki 3 days ago
Are you sure array_contains is the only way?
LA
Lavera 8 days ago
I agree, D is the right choice!
JO
Johnathon 14 days ago
Wait, why wouldn't LIKE work?
BO
Bok 19 days ago
Definitely need to use array_contains for this!
JE
Jennifer 24 days ago
The original query won't work because 'tags' is an array.
RO
Roosevelt 29 days ago
I thought using IN with arrays was valid, but now I'm second-guessing it. I remember array_contains being mentioned as a better approach for this kind of query.
HE
Herman 1 month ago
I think the correct answer might be D, but I’m a bit confused about whether we can use IN with arrays directly. I feel like we did a question like that in our last review.
EL
Elmer 1 month ago
I'm not entirely sure, but I feel like using LIKE might not be the best option here since it's an array. I think we need something more specific.
MA
Ma 1 month ago
I remember we practiced something similar where we had to check if an array contained a specific value. I think it was about using a function like array_contains.
0/2000 characters

Save Cancel