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?

Create a list of URLs that the users can click in Salesforce.

Publish to Tableau Mobile for viewing.

Create subscriptions for each view to deliver reports by email.

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

{ FIXED [Order ID] : SUM([Sales]) } > { FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }

[Sales] > { FIXED [Order ID] : SUM([Sales]) }

{ FIXED [Order ID] : SUM([Sales]) } > { FIXED [Region] : SUM([Sales]) }

{ FIXED [Order ID] : SUM([Sales]) } > { FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }

{ FIXED [Order ID] : SUM([Sales]) } > { INCLUDE [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }

A client wants to count all the distinct orders placed in 2010. They have written the following calculation, but the result is incorrect.IF YEAR([Date])=2010 THEN COUNTD ([OrderID]) ENDWhich calculation will produce the correct result?

COUNTD(IF YEAR([Date])=2010 THEN [OrderID] END)

IF MIN(YEAR([Date]))=2010 THEN WINDOW_COUNTD([OrderID]) END

IF YEAR([Date])=2010 THEN {COUNTD ([OrderID])} END

COUNTD(IF YEAR([Date])=2010 THEN [OrderID] END)

COUNT(IF YEAR([Date])=2010 THEN [OrderID] END)

A client wants to migrate their Tableau Server to Tableau Cloud. The Tableau Server is configured with three sites: Finance, Strategy, and Marketing. Aconsultant must provide a solution that minimizes user impact and costs.Which configuration should the consultant recommend for Tableau Cloud to meet the client's requirements?

One Tableau Cloud instance configured with a Finance project folder, Strategy project folder, and Marketing project folder

One Tableau Cloud instance with two sites for Strategy and Marketing, and one Tableau Server instance for Finance

Three separate Tableau Cloud instances for Finance, Strategy, and Marketing

One Tableau Cloud instance configured with all workbooks in a single project

A client has several long-term shipping contracts with different vendors that set rates based on shipping volume and speed. The client requests a dashboard that allows them to model shipping costs for the next week based on the selected shipping vendor. Speed for the end user is critical.Which dashboard building strategy will deliver the desired result?

Use a calculated field that refers to a user-selected parameter to calculate shipping costs for each order and then display the aggregate values.

Recommend that the client model for only profitability for the next 24 hours instead of a full week.

Calculate the potential shipping cost for each order with each vendor, display the aggregate costs in a large table, and use quick filters to limit the options visible to the user.

Aggregate the orders then use a calculated field that refers to a user-selected parameter to calculate the shipping costs.

Use a calculated field that refers to a user-selected parameter to calculate shipping costs for each order and then display the aggregate values.

A multi-national company wants to have a Tableau dashboard that will provide country-level information for both its forecast summaries and year-on-year metrics. The company wants to toggle between these two views while leaving main key performance indicators (KPIs) visible on the main dashboard.Which method is the most efficient in achieving the company's requirements?

Create a Boolean parameter with the two names of the views as aliases and a corresponding calculated field with the following calculation: True. . Add the forecast summary sheet to the dashboard and add the year-on-year metrics sheet to the same dashboard as a Floating dashboard object. . Add the calculated fields as a Detail under the Marks card of the floating view, create a 'Change Parameter' action, and set the 'Target Parameter' and 'Source Fields' to the parameter and calculated field you created. . Check the box for 'Control visibility using value' in the Layout tab of the floating view and select the parameter you created.

Create a dashboard with the sheets containing the main KPIs and the forecast summary worksheet. . Duplicate this dashboard and replace the forecast view worksheet with the year-on-year metrics worksheet. . Add navigation buttons to both dashboards.

Create a parameter that accepts values from a list that contains 'Forecast View' and 'Year-on-Year View.' . Right-click the parameter and select Add to Sheet for both worksheets. . Navigate back to the dashboard and to the upper corner of the two worksheets. . Enable the Use as Filter option.

Create a single worksheet with all the measures required for both the forecast summary and the year-on-year views. . Create a Boolean parameter and a corresponding calculated field with the following calculation: True. . Add a blank dashboard object and in the Layout tab, check the box for 'Control visibility using value' and select the parameter you created.

Create a Boolean parameter with the two names of the views as aliases and a corresponding calculated field with the following calculation: True. . Add the forecast summary sheet to the dashboard and add the year-on-year metrics sheet to the same dashboard as a Floating dashboard object. . Add the calculated fields as a Detail under the Marks card of the floating view, create a 'Change Parameter' action, and set the 'Target Parameter' and 'Source Fields' to the parameter and calculated field you created. . Check the box for 'Control visibility using value' in the Layout tab of the floating view and select the parameter you created.

A company has a sales team that is segmented by territory. The team's manager wants to make sure each sales representative can see only data relevant to that representative's territory in the team Sales Dashboard.The team is large and has high turnover, and the manager wants the mechanism for restricting data access to be as automated as possible. However, the team does not have a Tableau Data Management license.What should the consultant recommend to meet the company's requirements?

Create a data source by joining the sales data table to an entitlements data table. Add a data source filter to restrict access and publish the data source. Connect the Sales Dashboard to this published data source.

Create one group for each territory and assign sales representatives to the appropriate groups. Map each group to a territory in the Sales Dashboard. Publish this dashboard to the Sales Dashboard project and ensure all users have permissions to view the dashboard.

Create separate workbooks for each territory. Publish each dashboard to the same Sales Dashboard project, and set permissions so each sales representative can see only the dashboards for their territories.

Create a data source by joining the sales data table to an entitlements data table. Add a data source filter to restrict access and publish the data source. Connect the Sales Dashboard to this published data source.

Create a user filter in the Sales Dashboard workbook and map each sales representative to the territories they are responsible for. Publish this dashboard to the Sales Dashboard project and ensure all users have permissions to view the dashboard.

A client is searching for ways to curate and document data in order to obtain data lineage. The client has a data source connected to a data lake.Which tool should the consultant recommend to meet the client's requirements?

Tableau Catalog with Tableau Data Management Add-on

Tableau Catalog without Tableau Data Management Add-on

Tableau Catalog with Tableau Data Management Add-on

Tableau Catalog with Tableau Server Management Add-on

A client has a published dashboard. They change the dashboard and then republish it. Now, users report that their web browser bookmarks to the dashboard are broken.What are two possible causes for this issue? Choose two.

The dashboard was published to a different project.

The dashboard was published with a new name.

New credentials were embedded into the data source.

The dashboard was published to a different project.

The dashboard was published with a new name.

A client has a database that stores widget inventory by day and it is updated on a nonstandard schedule as shown below. They want a data visualization that shows widget inventory daily, however their business unit does not have the ability to modify the data warehouse structure.What should the client do to achieve the desired result?

Use Tableau Prep to add new rows.

Create a temporary table in the database.

Use Tableau Desktop to visualize null values.

Update the Widget Inventory Table to be a daily snapshot.

Use Tableau Prep to add new rows.

A client's dashboard has two sections dedicated to their shops and warehouses shown when a viewer chooses either shops or warehouses with a parameter.There are a few quick filters that apply to both, while others apply to only shops or only warehouses.Currently, the quick filters are all shown at the left side of the dashboard. The client wants to hide all filters, but when shown, make it easy for the viewer to find the quick filters that work for only shops or only warehouses.Which solution should the consultant recommend that meets the client's needs and is most user-friendly?

Use Dynamic Zone Visibility to show only the quick filters that apply with the chosen parameter value and a Show/Hide Button to hide container with all the filters.

Divide the quick filters into three groups: General, for shops. Place the general filters on the left of dashboard for warehouses. Place other filters next to the sections to which they apply.

Use Dynamic Zone Visibility to inform viewers which quick filters apply to warehouses or shops.

Hide container with all quick filters with a Show/Hide Button.

Use Dynamic Zone Visibility to show only the quick filters that apply with the chosen parameter value and a Show/Hide Button to hide container with all the filters.

A client currently has a workbook with the table shown below. Which method will produce the output for the Total Sales Value field for all the categories shown in the table?

Level of Detail (LOD) Calculation

A client is working in Tableau Prep and has a field named Orderld that is compiled by country, year, and an order number as shown in the following table. What should the consultant use to transform the table in the most efficient manner?

A calculated field that uses the TRIM function

A calculated field that uses the LEFT function

Tableau TCC-C01 Practice Test 2 - Free Online Exam Prep & Questions

A client needs to design row-level security (RLS) measures for their reports. The client does not currently have Tableau Data Management Add-on, and it may be an option in the future.

What should the consultant recommend as the safest and easiest way to manage for the long term?

Become a Premium Member for full access

Unlock Premium Member

Tableau TCC-C01 Practice Test 2

Question

Tableau TCC-C01 Practice Tests

Practice Tests