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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

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'?
D) SELECT * FROM main.analytics.articles WHERE array_contains(tags, 'sql');
A) SELECT * FROM main.analytics.articles WHERE tags IN ('sql');
B) SELECT * FROM main.analytics.articles WHERE tags LIKE '%sql%';
C) SELECT * FROM main.analytics.articles WHERE 'sql' IN tags;

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

Actual exam question for Databricks's Databricks Certified Data Analyst Associate exam
Question #: 58
Topic #: 1
[All Databricks Certified Data Analyst Associate Questions]

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'?

Show Suggested Answer Hide Answer
Suggested Answer: D

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

Limited Time Offer

25%

Off

Get Premium Databricks Certified Data Analyst Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel

Currently there are no comments in this discussion, be the first to comment!


Save Cancel