New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Salesforce Analytics-DA-201 Exam - Topic 1 Question 7 Discussion

Actual exam question for Salesforce's Analytics-DA-201 exam
Question #: 7
Topic #: 1
[All Analytics-DA-201 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

0/2000 characters
Keneth
3 days ago
C) Context filter is the way to go!
upvoted 0 times
...
Giovanna
8 days ago
I'm going with C) Context filter. It's the most flexible option and should give us the performance we need for this large data set.
upvoted 0 times
...
Jess
13 days ago
Haha, the question says "improve the performance" - I guess they don't want us to choose A) Dimension filler, that would probably slow things down!
upvoted 0 times
...
Kyoko
18 days ago
B) Table calculation filter is the way to go. Filtering the data at the table level will give you the best performance boost for a large data source.
upvoted 0 times
...
Lindsey
24 days ago
D) Measure filter seems like the best option here. Filtering by the Type field is a measure-level operation, so that's the appropriate filter to use.
upvoted 0 times
...
Nikita
29 days ago
I think the answer is C) Context filter. It makes sense to use a context filter to improve performance when dealing with a large data source.
upvoted 0 times
...
Peggy
1 month ago
I’m a bit confused about the difference between context filters and dimension filters. I hope I can remember which one is best for this scenario.
upvoted 0 times
...
Rasheeda
1 month ago
This question feels familiar; I think we had a similar practice question about optimizing filters. Context filters seemed to be the right choice then too.
upvoted 0 times
...
Glenn
1 month ago
I'm not entirely sure, but I think measure filters are more about aggregating data rather than filtering by a specific category like Animal Type.
upvoted 0 times
...
Lashandra
2 months ago
I'm feeling pretty confident on this one. The Type field is a dimension, so the Dimension filter is the correct choice to filter on that field.
upvoted 0 times
...
Selma
2 months ago
The question mentions wanting to improve performance by including only certain animal types. That makes me think the Dimension filter is the way to go.
upvoted 0 times
...
Yuette
2 months ago
I'm a bit confused on the difference between the filter options. Maybe I should review the definitions before deciding.
upvoted 0 times
...
Julie
2 months ago
Context filter makes sense for performance.
upvoted 0 times
...
Emerson
2 months ago
I remember we discussed context filters in class. They can help improve performance by limiting the data processed in other filters.
upvoted 0 times
...
Camellia
3 months ago
I think it's a context filter.
upvoted 0 times
...
Daniel
3 months ago
A) Dimension filter could work too, but C is better.
upvoted 0 times
...
Samira
3 months ago
Totally agree, context filters boost performance!
upvoted 0 times
...
Aaron
3 months ago
Okay, let's see. The data has over 10 million rows, so performance is key. I'm thinking the Context filter might be the best option here.
upvoted 0 times
...
Shaquana
3 months ago
Hmm, this looks like a tricky one. I'll need to think through the different filter options carefully.
upvoted 0 times
...

Save Cancel