TCC-C01 試験問題を無料オンラインアクセス

A client collects information about a web browser customers use to access their website. They then visualize the breakdown of web traffic by browser version.
The data is stored in the format shown below in the related table, with a NULL BrowserID stored in the Site Visitor Table if an unknown browser version accesses their website.

The client uses "Some Records Match" for the Referential Integrity setting because a match is not guaranteed.
The client wants to improve the performance of
the dashboard while also getting an accurate count of site visitors.
Which modifications to the data tables and join should the consultant recommend?

• A.Continue to use NULL as the BrowserID in the Site Visitor Table and leave the Referential Integrity set to "Some Records Match."
• B.Add an "Unknown" option to the Browser Table, reference its BrowserID in the Site Visitor Table, and leave the Referential Integrity set to
  "Some Records Match."
• C.Add an "Unknown" option to the Browser Table, reference its BrowserID in the Site Visitor Table, and change the Referential Integrity to "All Records Match."
• D.Continue to use NULL as the BrowserID in the Site Visitor Table and change the Referential Integrity to
  "All Records Match."

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.

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?

• A.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.
• B.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.
• C.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.
• D.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.

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.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.
• C.Limit data to current and previous years, move calculating averages to data layer, and aggregate dates to monthly level.
• D.Move calculating averages to data layer and aggregate dates to monthly level.

From the desktop, open the CC workbook.
Open the Incremental worksheet.
You need to add a line to the chart that
shows the cumulative percentage of sales
contributed by each product to the
incremental sales.
From the File menu in Tableau Desktop, click
Save.