MENU
A data analyst is processing a complex aggregation on a table with zero null values and the query returns the following result:
Which query did the analyst execute in order to get this result?
A)
B)
C)
D)
Suggested Answer: B
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
20 comments · newest first
DA
Darrel
1 month ago
I’m confused. All options look similar. Need to analyze more.
YO
Yoko
1 month ago
Option B seems off to me. Not sure it fits the result.
HY
Hyman
2 months ago
I agree with Catrice. C has the best logic behind it.
BR
Brandon
2 months ago
I'm leaning towards Option D. The output matches my expectations.
EL
Ellen
2 months ago
I feel like Option A could also work. The syntax seems familiar.
CA
Catrice
2 months ago
I think it's Option C. Looks like the right aggregation.
RE
Reena
2 months ago
Option D seems like a wild card, but it could work!
AR
Ardella
3 months ago
Wait, how can there be zero nulls and still get that result?
CA
Caprice
3 months ago
I'm leaning towards Option B, but not 100% sure.
JO
Jose
3 months ago
Definitely not Option A, that one doesn't fit.
VA
Val
3 months ago
I think the analyst used Option C. Looks right!
CL
Clarinda
3 months ago
Option D seems like a wild card, but it could work!
ON
Ona
3 months ago
Wait, how can there be zero nulls and still get that result?
PO
Pok
4 months ago
I'm leaning towards Option B, but not 100% sure.
MA
Marsha
5 months ago
Definitely not Option A, that one doesn't fit.
TA
Tamekia
5 months ago
I think the analyst used Option C. Looks right!
TI
Tijuana
6 months ago
I’m leaning towards Option A, but I’m a bit confused about the differences in the results each option would produce.
TR
Trinidad
6 months ago
I feel like I’ve seen a question like this before, and I think it was about using COUNT or SUM.
HU
Huey
6 months ago
I think it might be Option C, but I need to double-check the syntax for the GROUP BY clause.
KR
Kristian
6 months ago
I remember practicing similar questions, but I'm not entirely sure which aggregation function was used here.