Tableau TDS-C01 Practice Test - Questions Answers, Page 5
List of questions
Question 41
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?
Explanation:
Follow along the steps below:
Drag Assortment and Year ID to the column shelf, and Item Number ID to the row shelf. Next, drag Sales to the Text label to create a cross-tab as below:
Question 42
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.
How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?
Explanation:
If you chose 2, then you were very close but probably didn't plot the actual Percent Difference on your view. ( One of the marks is just over the line).
Firstly, Drop the Week ID onto the column shelf, and convert it to continuous since we need both Year and Quarter as mentioned in the question.
2) Next, Drop assortment to filters shelf so that we can focus on Electronics!
3) This should be your view now. Click on the Show Mark Labels icon as shown:
The final view is as follows, with 3 points below 0 ( i.e negative )
Question 43
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Which of the following is not a Trend Line Model?
Explanation:
According to the official Tableau documentation, there are 5 types of trend lines which we can work with in Tableau :
1) Linear Trend Line
2) Logarithmic Trend Line
3) Exponential Trend Line
4) Polynomial Trend Line
5) Power Model
Hence, the correct answer is BINOMIALtrend line which is not present in Tableau.
See the following image:
For more information, refer to:https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm
Question 44
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.
Explanation:
It is possible in Tableau to use a sheet within a story directly.
Moreover, in Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.
At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.
Question 45
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Question 30: Skipped
Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State. Add a Linear trend line to the view. What is its R-squared value?
Explanation:
Trend lines have become popular questions in recent Tableau examinations. Follow along:
1) First drag Sales to the Rows shelf and Profit to the Columns shelf:
You will only see a single mark since the view is aggregated.
2) Now, break down this view by state. Drag State into Detail on the Marks shelf ( or directly to the view):
3) Finally, move to the Analytics pane, and drag Trend line to the view. When you drag it, select the Linear option!:
4) The following is our view. Hover over the trend line to see the R-squared value:
Question 46
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.
Explanation:
For a manual sort, no matter how the data changes, the values will always stay in the sort order you kept stuff in.
From the official website:
Question 47
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into _______________________
Explanation:
When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.
Further,
Question 48
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
To connect Tableau to a CSV data source what type of connection should you use?
Explanation:
Tableau recognises a CSV file as a TEXT file, and therefore it is the correct option.
The following are the steps to import a CSV file:
1) From the data connection screen, click on Text:
2) Choose the appropriate file, and click Open:
3) Finally, Tableau imports the data as shown below:
Question 49
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Which of the following are valid ways to copy a worksheet visualisation as an image?
Explanation:
The following are 2 correct ways to copy the worksheet visualisation as an image:
AND
Question 50
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You want to add Custom shapes to your visualisation. Where can you add these new shapes?
Explanation:
Here's how to add image files to your repository:
1) Find image file on the internet. I try to find consistent image formats if I plan to use a set of shapes such as logos or flags.
2) Download the image to your computer.
3) Drag images into your My Documents -> My Tableau repository -> Shapes folder.
4) Open Tableau and your new shapes will automatically be included in your 'edit shapes' menu.
Question