Free Access to Tableau.TCC-C01.v2025-01-06.q20 with Valid Practice Test (Page 5)

Question 16

A consultant is designing a dashboard that will be consumed on desktops, tablets, and phones. The consultant needs to implement a dashboard design that provides the best user experience across all the platforms.
Which approach should the consultant take to achieve these results?

A.Build one dashboard that has desktop, tablet, and phone layouts, and fix the size of the layouts.
B.Build one dashboard and fix the size of the dashboard.
C.Build one dashboard and set the size to Automatic.
D.Build one dashboard for each type of device and fix the size of the layouts.

Question 17

A client notices that while creating calculated fields, occasionally the new fields are created as strings, integers, or Booleans. The client asks a consultant if there is a performance difference among these three data types.
What should the consultant tell the customer?

A.Strings are fastest, followed by integers, and then Booleans.
B.Integers are fastest, followed by Booleans, and then strings.
C.Strings, integers, and Booleans all perform the same.
D.Booleans are fastest, followed by integers, and then strings.

Question 18

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.

Correct Answer:

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.

Question 19

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.ZN([Sales])*(1 - ZN([Discount]))
B.CASE [Sector Parameter]
WHEN 1 THEN "green"
WHEN 2 THEN "yellow"
C.SUM([Profit])/SUM([Sales])
D.POWER(ZN(SUM([Sales]))/
LOOKUP(ZN(SUM([Sales])), FIRST()),ZN(1/(INDEX()-1)))
- 1
END

Question 20

A multi-national company wants to have a Tableau dashboard that will provide country-level information for both its forecast summaries and year-on-year metrics. The company wants to toggle between these two views while leaving main key performance indicators (KPIs) visible on the main dashboard.
Which method is the most efficient in achieving the company's requirements?

A.Create a dashboard with the sheets containing the main KPIs and the forecast summary worksheet.
. Duplicate this dashboard and replace the forecast view worksheet with the year-on-year metrics worksheet.
. Add navigation buttons to both dashboards.
B.Create a parameter that accepts values from a list that contains "Forecast View" and "Year-on-Year View."
. Right-click the parameter and select Add to Sheet for both worksheets.
. Navigate back to the dashboard and to the upper corner of the two worksheets.
. Enable the Use as Filter option.
C.Create a single worksheet with all the measures required for both the forecast summary and the year-on-year views.
. Create a Boolean parameter and a corresponding calculated field with the following calculation: True.
. Add a blank dashboard object and in the Layout tab, check the box for "Control visibility using value" and select the parameter you created.
D.Create a Boolean parameter with the two names of the views as aliases and a corresponding calculated field with the following calculation: True.
. Add the forecast summary sheet to the dashboard and add the year-on-year metrics sheet to the same dashboard as a Floating dashboard object.
. Add the calculated fields as a Detail under the Marks card of the floating view, create a "Change Parameter" action, and set the
"Target Parameter" and "Source Fields" to the parameter and calculated field you created.
. Check the box for "Control visibility using value" in the Layout tab of the floating view and select the parameter you created.

Question 16

Question 17

Question 18

Question 19

Question 20

Download PDF File