Tableau TCC-C01 問題集

質問 1：
Use the following login credentials to sign in
to the virtual machine:
Username: Admin
Password:
The following information is for technical
support purposes only:
Lab Instance: 40201223
To access Tableau Help, you can open the
Help.pdf file on the desktop.

From the desktop, open the CC workbook.
Open the Categorical Sales worksheet.
You need to use table calculations to
compute the following:
. For each category and year, calculate
the average sales by segment.
. Create another calculation to
compute the year-over-year
percentage change of the average
sales by category calculation. Replace
the original measure with the year-
over-year percentage change in the
crosstab.
From the File menu in Tableau Desktop, click
Save.
正解：
See the complete Steps below in Explanation:
Explanation:
To compute the required calculations and update the worksheet in Tableau Desktop, follow these steps:
* Compute Average Sales by Segment for Each Category and Year:
* Open the CC workbook and navigate to the Categorical Sales worksheet.
* Drag the 'Sales' field to the Rows shelf if it's not already there.
* Drag the 'Segment' field to the Rows shelf as well, placing it next to 'Category' and 'Year'.
* Right-click on the 'Sales' field in the Rows shelf and select 'Quick Table Calculation' > 'Average'.
This will compute the average sales for each segment within each category and year.
* Create a Calculation for Year-over-Year Percentage Change:
* Right-click in the data pane and select 'Create Calculated Field'.
* Name the calculated field something descriptive, e.g., "YoY Sales Change".
* Enter the formula to calculate the year-over-year percentage change:
(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))
* Click 'OK' to save the calculated field.
* Replace the Original Measure with the Year-over-Year Percentage Change in the Crosstab:
* Remove the original 'Sales' measure from the view by dragging it off the Rows shelf.
* Drag the newly created "YoY Sales Change" calculated field to the Rows shelf where the 'Sales' field was originally.
* Format the "YoY Sales Change" field to display as a percentage. Right-click on the field in the Rows shelf, select 'Format', and adjust the number format to percentage.
* Save Your Changes:
* From the File menu, click 'Save' to ensure all your changes are stored.
References:
* Tableau Help: Offers guidance on creating calculated fields and using table calculations.
* Tableau Desktop User Guide: Provides instructions on formatting and saving worksheets.
These steps allow you to manipulate data within Tableau effectively, using table calculations to analyze trends and changes in sales data by category and segment over years.

質問 2：
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?
A. Hide container with all quick filters with a Show/Hide Button.
B. 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.
C. Use Dynamic Zone Visibility to inform viewers which quick filters apply to warehouses or shops.
D. 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.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
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. Joining the tables in Tableau Prep
B. Blending the first two tables with the third
C. Relating the tables in Tableau Desktop
D. Joining the tables in Tableau Desktop
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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?
A. Use Tableau Desktop to visualize null values.
B. Update the Widget Inventory Table to be a daily snapshot.
C. Use Tableau Prep to add new rows.
D. Create a temporary table in the database.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
A consultant builds a report where profit margin is calculated as SUM([Profit]) / SUM([Sales]). Three groups of users are organized on Tableau Server with the following levels of data access that they can be granted.
. Group 1: Viewers who cannot see any information on profitability
. Group 2: Viewers who can see profit and profit margin
. Group 3: Viewers who can see profit margin but not the value of profit Which approach should the consultant use to provide the required level of access?
A. Use user filters to allow only Groups 2 and 3 access to data on profitability. Then, create a calculated field that limits visibility of profit value to Group 2 and use the calculation in the view in the report.
B. Use user filters to access data on profitability to all groups. Then, create a calculated field that allows visibility of profit value to Group 2 and use the calculation in the view in the report.
C. Specify in the row-level security (RLS) entitlement table individuals who can see profit, profit margin, or none of these. Then, use the table data to create user filters in the report.
D. Specify with user filters in each view individuals who can see profit, profit margin, or none of these.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
An executive-level workbook leverages 37 of the 103 fields included in a data source. Performance for the workbook is noticeably slower than other workbooks on the same Tableau Server.
What should the consultant do to improve performance of this workbook while following best practice?
A. Use filters, hide unused fields, and aggregate values.
B. Restrict users from accessing the workbook to reduce server load.
C. Connect to the data source via a custom SQL query.
D. Split some visualizations on the dashboard into many smaller visualizations on the same dashboard.
正解：A
解説: (Topexam メンバーにのみ表示されます)