MENU
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?
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
26 comments · newest first
MA
Marci
2 days ago
Measure filters are too broad for this case.
BE
Beata
8 days ago
Context filter is definitely the way to go!
MA
Mari
13 days ago
Extract could work, but it’s not as flexible.
RA
Ranee
18 days ago
Agreed! It sets the stage for other calculations.
JE
Jess
23 days ago
I think a Context filter is best. It narrows down the data first.
AM
Amos
28 days ago
Yes, it’s crucial for accurate analysis!
JO
Josphine
1 month ago
I feel confident about choosing Context. It’s efficient.
LA
Laquanda
1 month ago
Context filters allow for precise calculations.
TA
Tammi
1 month ago
Measure filters are too broad for this task.
GA
Gail
2 months ago
Context filter is definitely the way to go!
DO
Dortha
2 months ago
Extract could work, but it’s not as flexible.
VI
Viki
2 months ago
Agreed! It sets the stage for other calculations.
MI
Ming
2 months ago
I think a Context filter is best. It narrows down the data first.
FR
Franchesca
2 months ago
I disagree, Measure filters can also be useful depending on the analysis.
MA
Margret
2 months ago
Context filters are the way to go for this situation, no doubt!
CR
Cristy
3 months ago
Wait, are we sure about that? I thought Extract filters were the best for large datasets.
RE
Reuben
3 months ago
I think a Table calculation could work too, but not as efficiently.
VI
Vincenza
3 months ago
Definitely a Context filter! It narrows down the data effectively.
MA
Makeda
3 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.
TW
Twila
3 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.
LA
Lashonda
4 months ago
I'm not entirely sure, but I remember something about table calculations being more about aggregating data rather than filtering it.
ZO
Zoila
4 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.
CO
Cordie
4 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.
CE
Cecily
5 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.
BR
Brittney
6 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?
XU
Xuan
6 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.