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

Actual exam question for Salesforce's Analytics-DA-201 exam

Question #: 7
Topic #: 1

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?

ADimension filler

BTable calculation filter

CContext filter

DMeasure filter

Show Suggested 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:

Submit Cancel

Jose

10 days ago

Measure filter doesn't fit this scenario.

upvoted 0 times

...

Lachelle

15 days ago

Context filter is best for large datasets.

upvoted 0 times

...

Thomasena

20 days ago

Dimension filter? Not sure about that.

upvoted 0 times

...

Paulina

26 days ago

I lean towards dimension filter.

upvoted 0 times

...

Ilene

1 month ago

I thought measure filters were the best for this kind of thing.

upvoted 0 times

...

Ines

1 month ago

Wait, are we sure about that? Seems too simple.

upvoted 0 times

...

Keneth

2 months ago

C) Context filter is the way to go!

upvoted 0 times

...

Giovanna

2 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

2 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

2 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

3 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

3 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

3 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

3 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

3 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

3 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

4 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

...