MENU
You have a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.
The following is a sample of the data.
You want to improve the performance of the views by including only animals of a particular type.
To which filter should you add the Type field on the worksheet?
Suggested Answer: C
Get Premium Analytics-DA-201 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
23 comments · newest first
AL
Aliza
2 days ago
Plus, it reduces the data set size early on.
KA
Karan
7 days ago
Exactly! Context filters are prioritized.
DO
Donette
13 days ago
But Dimension filters apply after context, right?
VA
Vashti
18 days ago
I’m leaning towards Dimension filter. It’s straightforward.
KA
Karan
23 days ago
Agreed! It improves performance significantly.
AL
Aliza
28 days ago
I think a Context filter is best. It narrows down data first.
DE
Devon
1 month ago
Same here! It really helps in focusing the analysis.
MA
Marva
1 month ago
I feel confident about context filter. It’s the best choice here.
AL
Aliza
1 month ago
True, especially with 10 million rows.
DE
Devon
2 months ago
Exactly! Context filter is more efficient with large datasets.
SH
Shizue
2 months ago
Dimension filter is good, but it doesn't prioritize like context.
AL
Aliza
2 months ago
But what about dimension filter? It could work too.
DE
Devon
2 months ago
I agree, context filter makes sense for performance.
SH
Shizue
2 months ago
I think it's a context filter. It narrows down the data first.
MY
Myrtie
2 months ago
Wow, I didn't know a Context filter could improve performance that much!
AN
Anabel
3 months ago
Really? I thought Measure filters were more efficient for this.
RA
Rana
3 months ago
Definitely a Context filter, it narrows down the data effectively.
CA
Cammy
3 months ago
I disagree, I think a Dimension filter would work better.
AL
Alberta
3 months ago
Context filter is the way to go!
MA
Maurine
3 months ago
I’m a bit confused about the difference between context filters and dimension filters. I hope I remember correctly that context filters are the way to go for performance.
CR
Crissy
4 months ago
This question seems similar to one we practiced where we had to optimize filters. I think context filters were the right choice in that case too.
WY
Wynell
4 months ago
I'm not entirely sure, but I feel like dimension filters might also be relevant here since they deal with categorical data like Animal types.
MI
Michell
4 months ago
I think I remember that context filters are used to improve performance by limiting the data set before other filters are applied.