Free Access to Tableau.TCC-C01.v2025-01-06.q20 with Valid Practice Test (Page 3)

Question 6

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?

A.Replace the Multiple Values (Dropdown) filter with a Multiple Values (Custom List) filter.
B.Replace the Relative Date filter with a Multiple Values (Dropdown) filter on YEAR([Created Date]).
C.Replace the TOTAL([Opportunities]) calculation with a Grand Total.
D.Replace SUM([Value]) with WINDOW_SUM([Value]).

Question 7

A client wants to flag orders that have sales higher than the regional average.
Which calculated field will produce the required result?

A.[Sales]
>
{ FIXED [Order ID] : SUM([Sales]) }
B.{ FIXED [Order ID] : SUM([Sales]) }
>
{ FIXED [Region] : SUM([Sales]) }
C.{ FIXED [Order ID] : SUM([Sales]) }
>
{ FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }
D.{ FIXED [Order ID] : SUM([Sales]) }
>
{ INCLUDE [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }

Question 8

A client requests a published Tableau data source that is connected to SQL Server. The client needs to leverage the multiple tables option to create an extract. The extract will include partial data from the SQL Server data source.
Which action will reduce the amount of data in the extract?

A.Use an extract filter.
B.Aggregate the extract to the visible dimensions.
C.Define the filters by using custom SQL.
D.Set up the extract as an incremental refresh.

Correct Answer: A

Using an extract filter is an effective way to reduce the amount of data in a Tableau extract. Extract filters allow you to specify a subset of the data to include, which can significantly decrease the size of the extract by excluding unnecessary data. This is particularly useful when you only need partial data from a larger SQL Server data source.
References:The recommendation to use extract filters to reduce data size is supported by Tableau's best practices for optimizing extracts.These practices suggest keeping the extract's data set short through filtering1.Additionally, discussions in the Tableau Community confirm that hiding fields and using extract filters before extracting data can help reduce the extract size2.
When dealing with large datasets in SQL Server and needing to create a manageable extract in Tableau, using an extract filter is the most direct and effective method to limit the data included:
* Extract Filter: This involves setting filters that apply directly when the data is extracted from the source. This means that only the data meeting the specified criteria will be extracted and loaded into Tableau, significantly reducing the size of the extract.
* To apply an extract filter, in the Data Source page in Tableau, drag the fields you want to filter by to the Filters shelf. Then, configure the desired filter criteria. When you create the extract, choose the option to
* "Add Filters to Extract" and select the configured filters. This ensures that only the data that meets these conditions is extracted from the SQL Server.
This approach not only minimizes the data volume but also speeds up performance in Tableau because it processes a smaller subset of the full dataset.
ReferencesThis procedure is described in detail in Tableau's help documentation on managing extracts and optimizing performance by using extract filters, which is recommended for scenarios involving large datasets or when specific subsets of data are required for analysis.

Question 9

A consultant plans a Tableau deployment for a client that uses Salesforce. The client wants users to automatically see Tableau views of regional sales filtered by customer as soon as the users sign into Salesforce.
Which approach should the consultant use to deliver the final visualization?

A.Embed views into Salesforce.
B.Create a list of URLs that the users can click in Salesforce.
C.Publish to Tableau Mobile for viewing.
D.Create subscriptions for each view to deliver reports by email.

Question 10

A consultant migrated a data source to improve performance. The consultant wants to identify which workbooks need to be updated to point to the new data source.
Which Tableau tool should the consultant use?

A.Data Management
B.Prep Conductor
C.Activity Log
D.Tableau Advanced Management

Question 6

Question 7

Question 8

Question 9

Question 10

Download PDF File