Tableau TCC-C01 Tableau Certified Consultant Online Training

Question #11

A client is considering migrating from Tableau Server to Tableau Cloud.

Which two elements are determining factors of whether the client should use Tableau Server or Tableau Cloud? Choose two.

A . Whether or not the client plans to leverage single sign-on (SSO)
B . Whether or not there are large numbers of concurrent extract refreshes
C . Whether or not the client needs the ability to connect to public, cloud-based data sources
D . Amount of data storage used on the client’s existing server

Reveal Solution Hide Solution

Question #12

A client notices that several groups are sharing content across divisions and are not complying with their data governance strategy. During a Tableau Server audit, a consultant notices that the asset permissions for the client’s top-level projects are set to "Locked," but that "Apply to Nested Projects" is not checked.

The consultant recommends checking "Apply to Nested Projects" to enforce compliance.

Which impact will the consultant’s recommendation have on access to the existing nested projects?

A . Current custom access will be maintained, but new custom permissions will not be granted.
B . Access will be automatically rolled back to the top-level project permissions immediately.
C . Users will be prompted to manually update permissions for all nested projects.
D . Users will be notified that they will automatically lose access to content after 30 days.

Reveal Solution Hide Solution

Question #13

A Tableau Cloud client has requested a custom dashboard to help track which data sources are used most frequently in dashboards across their site.

Which two actions should the client use to access the necessary metadata? Choose two.

A . Connect directly to the Site Content data source within the Admin Insights project.
B . Query metadata through the GraphiQL engine.
C . Access metadata through the Metadata API.
D . Download metadata through Tableau Catalog.

Reveal Solution Hide Solution

Question #14

A company has a data source for sales transactions.

The data source has the following characteristics:

– Millions of transactions occur weekly.

– The transactions are added nightly.

– Incorrect transactions are revised every week on Saturday.

– The end users need to see up-to-date data daily.

A consultant needs to publish a data source in Tableau Server to ensure that all the transactions in the data source are available.

What should the consultant do to create and publish the data?

A . Publish an incremental extract refresh every day and perform a full extract refresh every Saturday.
B . Publish a live connection to Tableau Server.
C . Publish an incremental refresh every Saturday.
D . Publish an incremental extract refresh every day and publish a secondary data set containing data revisions.

Reveal Solution Hide Solution

Question #15

A consultant creates a histogram that presents the distribution of profits across a client’s customers. The labels on the bars show percent shares. The consultant used a quick table calculation to create the labels.

Now, the client wants to limit the view to the bins that have at least a 15% share. The consultant creates a profit filter but it changes the percent labels.

Which approach should the consultant use to produce the desired result?

A . Use a calculation with TOTAL() function instead of a quick table calculation.
B . Add the [Profit] filter to the context.
C . Filter with a table calculation WINDOW_AVG(MIN([Profit]), first(), last())
D . Filter with the table calculation used to create labels.

Reveal Solution Hide Solution

Correct Answer: B
B

Explanation:

When a filter is applied directly to the view, it can affect the calculation of percentages in a histogram because it changes the underlying data that the quick table calculation is based on. To avoid this, adding the [Profit] filter to the context will maintain the original calculation of percent shares while filtering out bins with less than a 15% share. This is because context filters are applied before any other calculations, so the percent shares calculated will be based on the context-filtered data, thus preserving the integrity of the original percent labels.

References: The solution is based on the principles of context filters and their order of operations in Tableau, which are documented in Tableau’s official resources and community discussions123.

When a histogram is created showing the distribution of profits with labels indicating percent shares using a quick table calculation, and a need arises to limit the view to bins with at least a 15% share, applying a standard profit filter directly may undesirably alter how the percent labels calculate because they depend on the overall distribution of data. Placing the [Profit] filter into the context makes it a "context filter," which effectively changes how data is filtered in calculations:

Create a Context Filter: Right-click on the profit filter and select "Add to Context". This action changes the order of operations in filtering, meaning the context filter is applied first.

Adjust the Percent Calculation: With the profit filter set in the context, it first reduces the data set to only those profits that meet the filter criteria. Subsequently, any table calculations (like the percent share labels) are computed based on this reduced data set.

View Update: The view now updates to display only those bins where the profits are at least 15%, and the percent share labels recalculated to reflect the distribution of only the filtered (contextual) data.

References:

Context Filters in Tableau: Context filters are used to filter the data passed down to other filters, calculations, the marks card, and the view. By setting the profit filter as a context filter, it ensures that calculations such as the percentage shares are based only on the filtered subset of the data.

Question #16

A client has a large data set that contains more than 10 million rows.

A consultant wants to calculate a profitability threshold as efficiently as possible.

The calculation must classify the profits by using the following specifications:

– Classify profit margins above 50% as Highly Profitable.

– Classify profit margins between 0% and 50% as Profitable.

– Classify profit margins below 0% as Unprofitable.

Which calculation meets these requirements?

A . IF [ProfitMargin]>0.50 Then ‘Highly Profitable’ ELSEIF [ProfitMargin]>=0 Then ‘Profitable’ ELSE ‘Unprofitable’
END
B . IF [ProfitMargin]>=0.50 Then ‘Highly Profitable’ ELSEIF [ProfitMargin]>=0 Then ‘Profitable’ ELSE ‘Unprofitable’
END
C . IF [ProfitMargin]>0.50 Then ‘Highly Profitable’
ELSEIF [ProfitMargin]>=0 Then ‘Profitable’
ELSEIF [ProfitMargin] <0 Then ‘Unprofitable’
END
D . IF([ProfitMargin]>=0.50,’Highly Profitable’, ‘Profitable’) ELSE ‘Unprofitable’
END

Reveal Solution Hide Solution

Question #17

An online sales company has a table data source that contains Order Date. Products ship on the first day of each month for all orders from the previous month.

The consultant needs to know the average number of days that a customer must wait before a product is shipped.

Which calculation should the consultant use?

A . Calc1: DATETRUNC (‘month’, DATEADD(‘month’, 1, [Order Date]))
Calc2: AVG(DATEDIFF (‘week’, [Order Date], [Calc1]))
B . Calc1: DATETRUNC (‘month’, DATEADD (‘month’, 1, [Order Date]))
Calc2: AVG(DATEDIFF (‘day’, [Order Date], [Calc1]))
C . Calc1: DATETRUNC (‘day’, DATEADD(‘week’, 4, [Order Date]))
Calc2: AVG([Order Date] – [Calc1])
D . Calc1: DATETRUNC (‘day’, DATEADD (‘day’, 31, [Order Date]))
Calc2: AVG ([Order Date] – [Calc1])

Reveal Solution Hide Solution

Question #18

For a new report, a consultant needs to build a data model with three different tables, including two that contain hierarchies of locations and products. The third table contains detailed warehousing data from all locations across six countries. The consultant uses Tableau Cloud and the size of the third table excludes using an extract.

What is the most performant approach to model the data for a live connection?

A . Relating the tables in Tableau Desktop
B . Blending the first two tables with the third
C . Joining the tables in Tableau Prep
D . Joining the tables in Tableau Desktop

Reveal Solution Hide Solution

Question #19

A client uses Tableau Data Management and notices that when they view a data source, they sometimes see a different count of workbooks in the Connected Workbooks tab compared to the lineage count in Tableau Catalog.

What is the cause of this discrepancy?

A . Some workbooks have been connected to the data source, but do not use any fields from it.
B . Some workbooks have not been viewed by enough users yet.
C . Some of the workbooks connected to the data source are not visible to the user due to permissions.
D . Some Creators have connected to the data source in Tableau Desktop but have not yet published a workbook.

Reveal Solution Hide Solution

Question #20

A client wants to report Saturday and Sunday regardless of the workbook’s data source’s locale settings.

Which calculation should the consultant recommend?

A . DATEPART(‘weekday’, [Order Date])>=6
B . DATEPART(‘iso-weekday’, [Order Date])>=6
C . DATENAME(‘iso-weekday’, [Order Date])>=6
D . DATEPART(‘iso-weekday’, [Order Date])=1 or DATEPART(‘iso-weekday’, [Order Date])=7

Reveal Solution Hide Solution