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

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

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?
C) Context filter
A) Dimension filler
B) Table calculation filter
D) Measure filter

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

by Isabella at Nov 19, 2025, 06:40 AM

Limited Time Offer

25%

Off

Get Premium Analytics-DA-201 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Jose
2 months ago
Measure filter doesn't fit this scenario.
upvoted 0 times
...
Lachelle
2 months ago
Context filter is best for large datasets.
upvoted 0 times
...
Thomasena
2 months ago
Dimension filter? Not sure about that.
upvoted 0 times
...
Paulina
2 months ago
I lean towards dimension filter.
upvoted 0 times
...
Ilene
3 months ago
I thought measure filters were the best for this kind of thing.
upvoted 0 times
...
Ines
3 months ago
Wait, are we sure about that? Seems too simple.
upvoted 0 times
...
Keneth
3 months ago
C) Context filter is the way to go!
upvoted 0 times
...
Giovanna
4 months 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
4 months 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
4 months 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
4 months 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
4 months 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
4 months 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
5 months 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
5 months 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
5 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
5 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
5 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
5 months ago
Context filter makes sense for performance.
upvoted 0 times
...
Emerson
6 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
6 months ago
I think it's a context filter.
upvoted 0 times
...
Daniel
6 months ago
A) Dimension filter could work too, but C is better.
upvoted 0 times
...
Samira
6 months ago
Totally agree, context filters boost performance!
upvoted 0 times
...
Aaron
6 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
7 months ago
Hmm, this looks like a tricky one. I'll need to think through the different filter options carefully.
upvoted 0 times
Lorrie
30 days ago
True, but we should weigh all options before deciding.
upvoted 0 times
...
Stefania
1 month ago
Context filters can improve performance significantly.
upvoted 0 times
...
Rikki
1 month ago
Why context? Isn’t a dimension filter more straightforward?
upvoted 0 times
...
Aretha
2 months ago
I think a context filter might be the best choice.
upvoted 0 times
...
Lorrie
2 months ago
I agree, it’s definitely tricky.
upvoted 0 times
...
...

Save Cancel