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 4 Question 14 Discussion

A Data Analyst has 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.The analyst wants to ensure that every calculation is affected by including only animals of a particular type.Which type of filter should the analyst create on the worksheet?
C) Context
A) Extract
B) Table calculation
D) Measure

Salesforce Analytics-DA-201 Exam - Topic 4 Question 14 Discussion

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

A Data Analyst has 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.

The analyst wants to ensure that every calculation is affected by including only animals of a particular type.

Which type of filter should the analyst create on the worksheet?

Show Suggested Answer Hide Answer
Suggested Answer: C

by India at May 02, 2026, 06:55 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
Gail
3 days ago
Context filter is definitely the way to go!
upvoted 0 times
...
Dortha
8 days ago
Extract could work, but it’s not as flexible.
upvoted 0 times
...
Viki
13 days ago
Agreed! It sets the stage for other calculations.
upvoted 0 times
...
Ming
18 days ago
I think a Context filter is best. It narrows down the data first.
upvoted 0 times
...
Franchesca
23 days ago
I disagree, Measure filters can also be useful depending on the analysis.
upvoted 0 times
...
Margret
29 days ago
Context filters are the way to go for this situation, no doubt!
upvoted 0 times
...
Cristy
1 month ago
Wait, are we sure about that? I thought Extract filters were the best for large datasets.
upvoted 0 times
...
Reuben
1 month ago
I think a Table calculation could work too, but not as efficiently.
upvoted 0 times
...
Vincenza
1 month ago
Definitely a Context filter! It narrows down the data effectively.
upvoted 0 times
...
Makeda
2 months ago
I’m a bit confused; I thought extract filters were used for performance, but I’m not sure if they would work for this specific requirement.
upvoted 0 times
...
Twila
2 months ago
This question reminds me of a practice problem where we had to choose between different filter types. I think context filters were emphasized as the best for this scenario.
upvoted 0 times
...
Lashonda
2 months ago
I'm not entirely sure, but I remember something about table calculations being more about aggregating data rather than filtering it.
upvoted 0 times
...
Zoila
2 months ago
I think the context filter might be the right choice since it can limit the data for all calculations based on the selected animal type.
upvoted 0 times
...
Cordie
2 months ago
Extract filters sound familiar, but I don't think they apply here since we need to focus on calculations rather than just pulling data.
upvoted 0 times
...
Cecily
4 months ago
I practiced a similar question where context filters were emphasized for large datasets. It seems like the best option for ensuring accurate calculations.
upvoted 0 times
...
Brittney
4 months ago
I'm not entirely sure, but I feel like table calculations are more about manipulating data after it's already been filtered. Could that be a distraction in this question?
upvoted 0 times
...
Xuan
4 months ago
I think I remember something about context filters being used to limit data before other calculations are applied. That might be the right choice here.
upvoted 0 times
...

Save Cancel