最新なTableau TCC-C01問題集（57題）、真実試験の問題を全部にカバー！

質問 1：
A client builds a dashboard that presents current and long-term stock measures. Currently, the data is at a daily level. The data presents as a bar chart that presents monthly results over current and previous years. Some measures must present as monthly averages.
What should the consultant recommend to limit the data source for optimal performance?
A. Limit data to current and previous years and leave data at daily level to calculate the averages in the report.
B. Move calculating averages to data layer and aggregate dates to monthly level.
C. Limit data to current and previous years as well as to the last day of each month to eliminate the need to use the averages.
D. Limit data to current and previous years, move calculating averages to data layer, and aggregate dates to monthly level.
正解：D

質問 2：
From the desktop, open the CC workbook.
Open the Manufacturers worksheet.
The Manufacturers worksheet is used to
analyze the quantity of items contributed by
each manufacturer.
You need to modify the Percent
Contribution calculated field to use a Level
of Detail (LOD) expression that calculates
the percentage contribution of each
manufacturer to the total quantity.
Enter the percentage for Newell to the
nearest hundredth of a percent into the
Newell % Contribution parameter.
From the File menu in Tableau Desktop, click
Save.
正解：
See the complete Steps below in Explanation:
Explanation:
To modify the Percent Contribution calculated field to use a Level of Detail (LOD) expression and accurately calculate the percentage contribution of each manufacturer to the total quantity, follow these steps:
* Open the CC Workbook and Access the Worksheet:
* Double-click on the CC workbook from the desktop to open it in Tableau Desktop.
* Navigate to the Manufacturers worksheet by selecting its tab at the bottom of the window.
* Modify the Percent Contribution Calculated Field:
* Navigate to the Data pane and find the "Percent Contribution" calculated field.
* Right-click on the "Percent Contribution" field and select 'Edit'.
* Modify the formula to incorporate an LOD expression that calculates the total quantity across all manufacturers and the specific quantity per manufacturer:
{FIXED [Manufacturer]: SUM([Quantity])} / {SUM([Quantity])}Quantity])}
* This formula uses{FIXED [Manufacturer]: SUM([Quantity])}to compute the total quantity contributed by each manufacturer, regardless of other dimensions in the view. The total quantity
{SUM([Quantity])}calculates the grand total across all manufacturers. The division calculates the percentage contribution.
* Click 'OK' to save the updated calculated field.
* Enter Percentage for Newell:
* With the updated "Percent Contribution" field, drag it onto the view to update the chart or table.
* Identify the value corresponding to 'Newell' in the updated visualization.
* Round this value to the nearest hundredth of a percent as required.
* Enter this value into the "Newell % Contribution" parameter. To do this, locate the parameter in the Data pane or on the dashboard, right-click it, and choose 'Edit'. Enter the calculated percentage for Newell.
* Save Your Changes:
* From the File menu, click 'Save' to store all the modifications you have made to the workbook.
References:
* Tableau Help: Offers detailed guidance on using LOD expressions for precise and context-independent aggregations.
* Tableau Desktop User Guide: Provides comprehensive instructions on managing calculated fields and parameters, ensuring accurate data analysis.
By following these steps, you will have successfully updated the calculation for percent contribution using LOD expressions, providing a more accurate analysis of each manufacturer's contribution to the total quantity.
Moreover, updating the parameter with Newell's specific contribution rounds out the task by reflecting precise data inputs for reporting or further analysis.

質問 3：
A client has a dashboard that uses a bar chart to visualize sales by Sub-Category and a detail table that has all the orders for the products within Sub- Category. The table has more than 10,000 rows of data and is slow to load.
A consultant plans to add an action so when the client interacts with the bar chart, only the relevant data appears in the table.
What will provide the fastest rendering of the dashboard?
A. Add a highlight action and set Target Highlighting to All Fields.
B. Add a highlight action and set Target Highlighting to Sub-Category.
C. Add a filter action, set "Run action on" to Select, and set "Clearing the selection will" to Exclude all values.
D. Add a filter action, set "Run action on" to Menu, and set "Clearing the selection will" to Show all values.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)

質問 4：
A client wants guidance for Creators to build efficient extracts from large data sources.
What are three Tableau best practices that the Creators should use? Choose three.
A. Use only live connections as they are always faster than extracts.
B. Use aggregate data for visible dimensions, whenever possible.
C. Hide all unused fields.
D. Keep only the data required for analysis by using extract filters.
E. Include all the data from the original data source in the extract.
正解：B,C,D
解説: (Pass4Test メンバーにのみ表示されます)

質問 5：
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'
ELSEIF [ProfitMargin] <0 Then 'Unprofitable'
END
C. IF [ProfitMargin]>=0.50 Then 'Highly Profitable'
ELSEIF [ProfitMargin]>=0 Then 'Profitable'
ELSE 'Unprofitable'
END
D. IF([ProfitMargin]>=0.50,'Highly Profitable', 'Profitable')
ELSE 'Unprofitable'
END
正解：C
解説: (Pass4Test メンバーにのみ表示されます)

質問 6：
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?
A. Use a calculated field that refers to a user-selected parameter to calculate shipping costs for each order and then display the aggregate values.
B. Recommend that the client model for only profitability for the next 24 hours instead of a full week.
C. 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.
D. Aggregate the orders then use a calculated field that refers to a user-selected parameter to calculate the shipping costs.
正解：A
解説: (Pass4Test メンバーにのみ表示されます)