Snowflake Exam DSA-C02 Topic 2 Question 31 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 31
Topic #: 2

[All DSA-C02 Questions]

Which of the following Functions do Support Windowing?

AHASH_AGG

BENCRYPT

CEXTRACT

DLISTAGG

Show Suggested Answer

Suggested Answer: D

by Dean at Sep 16, 2024, 02:55 AM

Limited Time Offer

25%

Off

Get Premium DSA-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Thurman

3 months ago

Wait, is LISTAGG a function that lets you group things together and then put them in a list? That sounds pretty useful for windowing!

upvoted 0 times

Florinda

2 months ago

ENCRYPT and EXTRACT are not functions that support windowing. They have different purposes in SQL.

upvoted 0 times

...

Elvera

2 months ago

HASH_AGG and LISTAGG are both functions that support windowing. They can help with aggregating and grouping data in a window.

upvoted 0 times

...

Dustin

2 months ago

Yes, LISTAGG is a function that concatenates the values of a column into a single string using a specified delimiter. It can be very useful for windowing functions.

upvoted 0 times

...

Floyd

3 months ago

EXTRACT is an interesting choice, but I don't think it's related to windowing either. It's more for extracting parts of a date or time value.

upvoted 0 times

Bettyann

2 months ago

ENCRYPT doesn't seem like it would be used for windowing.

upvoted 0 times

...

Judy

3 months ago

I believe HASH_AGG is the correct function for windowing.

upvoted 0 times

...

Dewitt

3 months ago

I think LISTAGG is the function that supports windowing.

upvoted 0 times

...

Lauran

3 months ago

Hmm, ENCRYPT doesn't seem to have anything to do with windowing. That's just for encrypting data, right? I'd rule that one out.

upvoted 0 times

Reta

2 months ago

D) LISTAGG

upvoted 0 times

...

Nichelle

3 months ago

C) EXTRACT

upvoted 0 times

...

Tasia

3 months ago

A) HASH_AGG

upvoted 0 times

...

Gerald

4 months ago

HASH_AGG seems like a good option too, since it's an aggregate function that can be used with window functions. But I'm pretty sure LISTAGG is the right answer.

upvoted 0 times

...

Bettina

4 months ago

I'm not sure about ENCRYPT, but I know that EXTRACT also supports windowing.

upvoted 0 times

...

Pamela

4 months ago

I think LISTAGG is the correct answer here. It's a function that allows you to concatenate multiple rows into a single string, which is a common use case for windowing.

upvoted 0 times