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 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 メンバーにのみ表示されます)

質問 3：
A client wants to see data for only the last day in a dataset and the last day is always yesterday. The date is represented with the field Ship Date.
The client is not concerned about the daily refresh results. The volume of data is so large that performance is their priority. In the future, the client will be able to move the calculation to the underlying database, but not at this time.
The solution should offer the best performance.
Which approach should the consultant use to produce the desired results?
A. Filter on Ship Date field using the Yesterday option.
B. Filter on calculation [Ship Date]=TODAY()-1.
C. Filter MONTH/DAY/YEAR on [Ship Date] field and use an option to filter to the latest date value when the workbook opens.
D. Filter on calculation [Ship Date]={MAX([Ship Date])}.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
From the desktop, open the CCworkbook. Use the US PopulationEstimates data source.
You need to shape the data in USPopulation Estimates by using TableauDesktop. The data must be formatted asshown in the following table.

Open the Population worksheet. Enterthe total number of records contained inthe data set into the Total Recordsparameter.
From the File menu in Tableau Desktop,click Save.
正解：
See the complete Steps below in Explanation:
Explanation:
To shape the data in the "US Population Estimates" data source and enter the total number of records into the
"Total Records" parameter in Tableau Desktop, follow these steps:
* Open the CC Workbook and Access the Worksheet:
* From the desktop, double-click on the CC workbook to open it in Tableau Desktop.
* Navigate to the Population worksheet by selecting its tab at the bottom of the window.
* Format and Shape the Data:
* Ensure the data types match those specified in the requirements: Sex, Origin, Race as strings; Year, Age, Population as whole numbers.
* To verify or change the data type, click on the dropdown arrow next to each field name in the Data pane and select "Change Data Type" if necessary.
* Calculate Total Number of Records:
* Create a new calculated field named "Total Records". To do this, right-click in the Data pane and select "Create Calculated Field".
* Enter the formulaCOUNT([Record ID])orSUM([Number of Records])depending on how the data source identifies each row uniquely.
* Drag this new calculated field onto the worksheet to display the total number of records.
* Enter the Value into the Total Records Parameter:
* Locate the "Total Records" parameter in the Data pane. Right-click on the parameter and select
"Edit".
* Manually enter the number displayed from the calculated field into the parameter, ensuring accuracy to meet the data shaping requirement.
* Save Your Changes:
* From the File menu, click 'Save' to ensure all your changes are stored.
References:
* Tableau Desktop Guide: Provides detailed instructions on managing data types, creating calculated fields, and updating parameters.
* Tableau Data Shaping Techniques: Outlines effective methods for manipulating and structuring data for analysis.
This process will ensure the data in the "US Population Estimates" is accurately shaped according to the specified format and that the total number of records is correctly calculated and entered into the designated parameter. This thorough approach ensures data integrity and accuracy in reporting.

質問 5：
A stakeholder has multiple files saved (CSV/Tables) in a single location. A few files from the location are required for analysis. Data transformation (calculations) is required for the files before designing the visuals. The files have the following attributes:
. All files have the same schema.
. Multiple files have something in common among their file names.
. Each file has a unique key column.
Which data transformation strategy should the consultant use to deliver the best optimized result?
A. Use join option to combine/merge all the files together before doing the data transformation (calculations).
B. Use wildcard Union option to combine/merge all the files together before doing the data transformation (calculations).
C. Apply the data transformation (calculations) in each require file and do the wildcard union to combine/merge before designing the visuals.
D. Apply the data transformation (calculations) in each require file and do the join to combine/merge before designing the visuals.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
A client wants to migrate their Tableau Server to Tableau Cloud. The Tableau Server is configured with three sites: Finance, Strategy, and Marketing. A consultant 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?
A. One Tableau Cloud instance configured with a Finance project folder, Strategy project folder, and Marketing project folder
B. One Tableau Cloud instance with two sites for Strategy and Marketing, and one Tableau Server instance for Finance
C. Three separate Tableau Cloud instances for Finance, Strategy, and Marketing
D. One Tableau Cloud instance configured with all workbooks in a single project
正解：A
解説: (Topexam メンバーにのみ表示されます)