Tableau TCC-C01 問題集

質問 1：
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.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A client calculates the percent of total sales for a particular region compared to all regions.

Which calculation will fix the automatic recalculation on the % of total field?
A. {FIXED [Region]:[Sales]}/{FIXED: SUM([Sales])}
B. {FIXED [Region]:sum([Sales])}
C. {FIXED [Region]:sum([Sales])}/SUM([Sales]}
D. {FIXED [Region]:sum([Sales])}/{FIXED :SUM([Sales])
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A client has a published data source in Tableau Server and they want to revert to the previous version of the data source. The solution must minimize the impact on users.
What should the consultant do to accomplish this task?
A. Delete and recreate the data source manually.
B. Select a previous version from Tableau Server, download it, and republish that data source.
C. Request that a server administrator restore a Tableau Server backup.
D. Select a previous version from Tableau Server, and then click Restore.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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.

質問 5：
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. Query metadata through the GraphiQL engine.
B. Connect directly to the Site Content data source within the Admin Insights project.
C. Download metadata through Tableau Catalog.
D. Access metadata through the Metadata API.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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. Include all the data from the original data source in the extract.
B. Hide all unused fields.
C. Use only live connections as they are always faster than extracts.
D. Use aggregate data for visible dimensions, whenever possible.
E. Keep only the data required for analysis by using extract filters.
正解：B,D,E
解説: (Topexam メンバーにのみ表示されます)