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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce Analytics-Con-301 Exam - Topic 5 Question 8 Discussion

Actual exam question for Salesforce's Analytics-Con-301 exam
Question #: 8
Topic #: 5
[All Analytics-Con-301 Questions]

A stakeholder has multiple files saved (CSV/Tables) in a single location. A few files from the location are required for analysis. Data transformation (calculations)

is required for the files before designing the visuals. The files have the following attributes:

. All files have the same schema.

. Multiple files have something in common among their file names.

. Each file has a unique key column.

Which data transformation strategy should the consultant use to deliver the best optimized result?

Show Suggested Answer Hide Answer
Suggested Answer: B

Moving calculations to the data layer and materializing them in the extract can significantly improve the performance of reports in Tableau. The calculation ZN([Sales])*(1 - ZN([Discount])) is a basic calculation that can be easily computed in advance and stored in the extract, speeding up future queries. This type of calculation is less complex than table calculations or LOD expressions, which are better suited for dynamic analysis and may not benefit as much from materialization12.

References: The answer is based on the best practices for creating efficient calculations in Tableau, as described in Tableau's official documentation, which suggests using basic and aggregate calculations to improve performance1. Additionally, the process of materializing calculations in extracts is detailed in Tableau's resources2.

Given that all files share the same schema and have a common element in their file names, the wildcard union is an optimal approach to combine these files before performing any transformations. This strategy offers the following advantages:

Efficient Data Combination: Wildcard union allows multiple files with a common naming scheme to be combined into a single dataset in Tableau, streamlining the data preparation process.

Uniform Schema Handling: Since all files share the same schema, wildcard union ensures that the combined dataset maintains consistency in data structure, making further data manipulation more straightforward.

Pre-Transformation Combination: Combining the files before applying transformations is generally more efficient as it reduces redundancy in transformation logic across multiple files. This means transformations are written and processed once on the unified dataset, rather than repeatedly for each individual file.

References:

Wildcard Union in Tableau: This feature simplifies the process of combining multiple similar files into a single Tableau data source, ensuring a seamless and efficient approach to data integration and preparation.


by Jackie at Nov 21, 2025, 03:35 AM

Limited Time Offer

25%

Off

Get Premium Analytics-Con-301 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Fernanda
3 days ago
Wait, can we really use wildcard unions for this? Sounds risky!
upvoted 0 times
...
Dianne
8 days ago
I disagree, A seems more straightforward for merging.
upvoted 0 times
...
Shawna
13 days ago
Haha, the consultant should just use a magic wand to make the data appear! No need for all this technical stuff.
upvoted 0 times
...
Herminia
18 days ago
Option D seems like the best choice. Joining the files after the transformations will give you more control over the data.
upvoted 0 times
...
Cherry
24 days ago
I'd go with option C. Applying the transformations first and then doing the union makes more sense to me.
upvoted 0 times
...
Elfrieda
29 days ago
I vaguely remember that merging files with a unique key might be better for analysis, so maybe option D could be the right choice?
upvoted 0 times
...
Luther
1 month ago
I think applying transformations to each file first makes sense, but I can't recall if we should join or union them afterward.
upvoted 0 times
...
Nickolas
1 month ago
I'm a bit unsure about whether to join or union the files. I feel like we did a similar question where joining was recommended, but I'm not completely confident.
upvoted 0 times
...
Katy
1 month ago
I remember we discussed the importance of schema consistency in our practice sessions, so I think using the wildcard union could be a good approach here.
upvoted 0 times
...
Juliana
2 months ago
This is a good example of where understanding data transformation strategies is crucial. I feel pretty confident I can tackle this one - I'll just need to double-check the details of each option to make the right choice.
upvoted 0 times
...
Helga
2 months ago
Option D seems like it could work too, but I'm not sure if that would be as efficient as option C. I think I'll go with C and see if I can justify that choice in my answer.
upvoted 0 times
...
Alishia
2 months ago
I'm a bit confused by the difference between the join and union options. I'll need to review those concepts to make sure I understand which one is more appropriate here.
upvoted 0 times
...
Almeta
2 months ago
Option B is the way to go! Wildcard union is the most efficient way to combine those files.
upvoted 0 times
...
Vernell
3 months ago
I think option B is the best choice here. Wildcard unions are super efficient!
upvoted 0 times
...
Adelaide
3 months ago
I'm with Shawna on this one. Wizardry is the way to go, forget about all these data transformation strategies.
upvoted 0 times
...
Frederic
3 months ago
Okay, let's see. The key seems to be that the files have the same schema and a common element in the file names. I'm leaning towards option C - that way I can apply the transformations to each file individually before combining them.
upvoted 0 times
...
Kendra
3 months ago
Hmm, this looks like a tricky one. I'll need to think through the options carefully to figure out the best approach.
upvoted 0 times
Milly
2 months ago
But what about option C? Transforming first could save time later.
upvoted 0 times
...
Jesusa
3 months ago
I think option A could work well. Merging first might simplify things.
upvoted 0 times
...
...

Save Cancel