Here are all the actual test exam dumps for IT exams. Most people prepare for the actual exams with our test dumps to pass their exams. So it's critical to choose and actual test pdf to succeed.

Exam TCC-C01 Topic 1 Question 50 Discussion

Actual exam question for Tableau's TCC-C01 exam
Question #: 50
Topic #: 1
A client has a pipeline dashboard that takes a long time to load. The dashboard is connected to only one large data source that is an extract.
It contains two calculated fields:
. TOTAL([Opportunities])
SUM([Value])
It also contains two filters:
. A Relative Date filter on Created Date, a Date field containing values from 5 years ago until today
. A Multiple Values (Dropdown) filter on Account Name, a String field containing 1,000 distinct values A consultant creates a Performance Recording to troubleshoot the issue, and finds out that the longest-running event is "Executing Query." Which step should the consultant take to resolve this issue?

Suggested Answer: B Vote an answer

To improve the loading time of the pipeline dashboard, which primarily suffers from long query execution times due to a comprehensive Relative Date filter:
* Relative Date Filter Issue: The existing Relative Date filter on "Created Date" covers a broad range (5
* years), leading to significant data processing overhead as it includes granular date calculations over a large dataset.
* Optimized Approach: By replacing the Relative Date filter with a Multiple Values (Dropdown) filter based on YEAR([Created Date]), the filter granularity is reduced. Filtering by year simplifies the query by limiting the volume of data processed and reducing the complexity of the filter condition.
* Implementation Benefit: This approach still provides the flexibility to view data across different years but does so by reducing the load on the database during query execution, which is critical for improving the performance of the dashboard.
ReferencesThis recommendation aligns with Tableau performance optimization strategies, specifically regarding the management of date filters to minimize their impact on query load, as discussed in Tableau performance tuning sessions and guides.

by Hobart at Nov 11, 2024, 10:41 AM

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
Ameni
2025-01-29 06:08:29
Selected Answer: B
✅ B. Replace the Relative Date filter with a Multiple Values (Dropdown) filter on YEAR([Created Date]).
🚀 This reduces computational overhead by using a discrete dimension filter instead of a dynamic date range filter.
upvoted 1 times
...
HANANE
2025-01-06 13:46:17
A is the good one ( relattive date are better as a filter)
upvoted 1 times
...
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.