ExamGecko
Home Home / Tableau / TDS-C01

Tableau TDS-C01 Practice Test - Questions Answers, Page 5

Question list
Search
Search

List of questions

Search

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?

A.
584
A.
584
Answers
B.
901
B.
901
Answers
C.
Correct)
C.
Correct)
Answers
D.
205
D.
205
Answers
E.
660
E.
660
Answers
Suggested answer: B

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:

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?

A.
1
A.
1
Answers
B.
2
B.
2
Answers
C.
3
C.
3
Answers
D.
4
D.
4
Answers
Suggested answer: C

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 )

Which of the following is not a Trend Line Model?

A.
Linear Trend Line
A.
Linear Trend Line
Answers
B.
Exponential Trend Line
B.
Exponential Trend Line
Answers
C.
binomial Trend Line
C.
binomial Trend Line
Answers
D.
Logarithmic Trend Line
D.
Logarithmic Trend Line
Answers
Suggested answer: C

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

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.

A.
rue
A.
rue
Answers
B.
False
B.
False
Answers
Suggested answer: B

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 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?

A.
0.783262
A.
0.783262
Answers
B.
0.739284
B.
0.739284
Answers
C.
0.759329
C.
0.759329
Answers
D.
0.748472
D.
0.748472
Answers
Suggested answer: A

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:

For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

A.
Random
A.
Random
Answers
B.
Manual
B.
Manual
Answers
C.
Topological
C.
Topological
Answers
D.
Hierarchical
D.
Hierarchical
Answers
Suggested answer: B

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:

Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into _______________________

A.
Dimensions and Measures
A.
Dimensions and Measures
Answers
B.
Rows and Columns
B.
Rows and Columns
Answers
C.
Labels and Values
C.
Labels and Values
Answers
D.
Numbers and Headers
D.
Numbers and Headers
Answers
Suggested answer: A

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,

To connect Tableau to a CSV data source what type of connection should you use?

A.
Spatial
A.
Spatial
Answers
B.
Excel
B.
Excel
Answers
C.
Text
C.
Text
Answers
D.
JSON
D.
JSON
Answers
Suggested answer: C

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:

Which of the following are valid ways to copy a worksheet visualisation as an image?

A.
By simply clicking Control + V on the keyboard
A.
By simply clicking Control + V on the keyboard
Answers
B.
By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy->Image
B.
By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy->Image
Answers
C.
Using the Marks shelf and choosing Copy->Image
C.
Using the Marks shelf and choosing Copy->Image
Answers
D.
By right clicking on the worksheet visualisation and selecting Copy->Image
D.
By right clicking on the worksheet visualisation and selecting Copy->Image
Answers
Suggested answer: B, D

Explanation:

The following are 2 correct ways to copy the worksheet visualisation as an image:

AND

You want to add Custom shapes to your visualisation. Where can you add these new shapes?

A.
In Downloads -> My Tableau Repository -> Shapes
A.
In Downloads -> My Tableau Repository -> Shapes
Answers
B.
In My Computer -> C: -> Tableau -> Shapes
B.
In My Computer -> C: -> Tableau -> Shapes
Answers
C.
In Program Files -> Tableau -> Shapes
C.
In Program Files -> Tableau -> Shapes
Answers
D.
In My Documents -> My Tableau Repository -> Shapes
D.
In My Documents -> My Tableau Repository -> Shapes
Answers
Suggested answer: D

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.

Total 318 questions
Go to page: of 32