최신Salesforce Certified Tableau Consultant - Analytics-Con-301무료샘플문제
문제1
A consultant wants to improve the performance of reports by moving calculations to the data layer and materializing them in the extract.
Which calculation should the consultant use?
A consultant wants to improve the performance of reports by moving calculations to the data layer and materializing them in the extract.
Which calculation should the consultant use?
정답: A
설명: (ITDumpsKR 회원만 볼 수 있음)
문제2
A shipping clerk wants to use a Sankey diagram to analyze the flow of goods between different categories, shipping modes, and locations to spot bottlenecks and optimize the most critical paths. The company uses Tableau Cloud.
How should the shipping clerk create a chart that depicts the above information?
A shipping clerk wants to use a Sankey diagram to analyze the flow of goods between different categories, shipping modes, and locations to spot bottlenecks and optimize the most critical paths. The company uses Tableau Cloud.
How should the shipping clerk create a chart that depicts the above information?
정답: A
설명: (ITDumpsKR 회원만 볼 수 있음)
문제3
A business analyst needs to create a view in Tableau Desktop that reports data from both Excel and MSSQL Server.
Which two features should the business analyst use to create the view? Choose two.
A business analyst needs to create a view in Tableau Desktop that reports data from both Excel and MSSQL Server.
Which two features should the business analyst use to create the view? Choose two.
정답: A,B
설명: (ITDumpsKR 회원만 볼 수 있음)
문제4
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 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?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제5
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.
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.
정답:
See the complete Steps below in Explanation:
Explanation:
To add a line showing the cumulative percentage of sales contributed by each product to the incremental sales in the Incremental worksheet of your Tableau Desktop, follow these detailed 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 Incremental worksheet by clicking on its tab at the bottom of the window.
* Calculate Cumulative Sales Percentage:
* Create a new calculated field to compute the cumulative percentage of sales. Right-click in the Data pane and select 'Create Calculated Field'.
* Name this field "Cumulative Sales Percentage".
* Enter the following formula to calculate the running sum of sales as a percentage of the total sales:
(RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) [Sales]))
* Click 'OK' to save the calculated field.
* Add the Cumulative Sales Percentage Line to the Chart:
* Drag the "Cumulative Sales Percentage" field to the Rows shelf, placing it next to the existing Sales measure.
* Ensure that the cumulative line appears as a continuous line. Right-click on the "Cumulative Sales Percentage" field on the Rows shelf, select 'Change Chart Type', and choose 'Line'.
* Adjust the axis to synchronize or dual-axis if necessary. Right-click on the axis of the
"Cumulative Sales Percentage" and select 'Synchronize Axis' if it's on a dual-axis setup.
* Format the Cumulative Sales Percentage Line:
* Click on the "Cumulative Sales Percentage" line in the visualization.
* Navigate to the 'Format' pane to adjust the line style, thickness, and color to make it distinct from other data in the chart.
* Save Your Changes:
* From the File menu, click 'Save' to ensure all your changes are stored.
References:
Tableau Help: Provides additional details on creating calculated fields and customizing line charts.
Tableau User Guide: Offers extensive instructions on formatting charts, including line types and axis synchronization.
By following these steps, you will successfully add a cumulative sales percentage line to your chart, enhancing the visualization to reflect the incremental contribution of each product to the overall sales in a dynamic and informative manner.
Explanation:
To add a line showing the cumulative percentage of sales contributed by each product to the incremental sales in the Incremental worksheet of your Tableau Desktop, follow these detailed 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 Incremental worksheet by clicking on its tab at the bottom of the window.
* Calculate Cumulative Sales Percentage:
* Create a new calculated field to compute the cumulative percentage of sales. Right-click in the Data pane and select 'Create Calculated Field'.
* Name this field "Cumulative Sales Percentage".
* Enter the following formula to calculate the running sum of sales as a percentage of the total sales:
(RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) [Sales]))
* Click 'OK' to save the calculated field.
* Add the Cumulative Sales Percentage Line to the Chart:
* Drag the "Cumulative Sales Percentage" field to the Rows shelf, placing it next to the existing Sales measure.
* Ensure that the cumulative line appears as a continuous line. Right-click on the "Cumulative Sales Percentage" field on the Rows shelf, select 'Change Chart Type', and choose 'Line'.
* Adjust the axis to synchronize or dual-axis if necessary. Right-click on the axis of the
"Cumulative Sales Percentage" and select 'Synchronize Axis' if it's on a dual-axis setup.
* Format the Cumulative Sales Percentage Line:
* Click on the "Cumulative Sales Percentage" line in the visualization.
* Navigate to the 'Format' pane to adjust the line style, thickness, and color to make it distinct from other data in the chart.
* Save Your Changes:
* From the File menu, click 'Save' to ensure all your changes are stored.
References:
Tableau Help: Provides additional details on creating calculated fields and customizing line charts.
Tableau User Guide: Offers extensive instructions on formatting charts, including line types and axis synchronization.
By following these steps, you will successfully add a cumulative sales percentage line to your chart, enhancing the visualization to reflect the incremental contribution of each product to the overall sales in a dynamic and informative manner.
문제6
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?
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?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)