TDS-C01 Braindumps PDF, Tableau TDS-C01 Exam Cram [Q50-Q74]

TDS-C01 Braindumps PDF, Tableau TDS-C01 Exam Cram

New 2022 TDS-C01 Sample Questions Reliable TDS-C01 Test Engine

NEW QUESTION 50
_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins

A. Data Blending
B. Data Joining
C. Data segregation
D. Union

Answer: A

Explanation:
Explanation
Data blending is performed on a sheet-by-sheet basis and is established when a field from a second data source is used in the view. To create a blend in a workbook already connected to at least two data sources, bring a field from one data source to the sheet-it becomes the primary data source.
Switch to the other data source and use a field on the same sheet-it becomes a secondary data source. An orange linking icon will appear in the data pane, indicating which field(s) are being used to blend the data sources.

According to the official Tableau Documentation:

To read more about Data Blending, click on THIS link.

NEW QUESTION 51
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

A. June
B. October
C. September
D. July

Answer: B

Explanation:
Explanation
Follow along:
1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.
For sales, click on the pill -> choose Quick Table calculation -> Year over Year growth.
The view should now look like:

NEW QUESTION 52
Which of the following are the options to export the data used to build the view / visualisations?

A. PDF File
B. CSV file
C. MS Access Database
D. JSON format

Answer: C

Explanation:
Explanation
You can export the data in a Tableau data source, including all or part of the records from your original data.
Alternatively, you can export only the portion of data used to generate the view.
Since the question mentions the data used to build the view, we'll focus on that :
*Export data in the view to Microsoft Access or .csv*
Export the data that is used to generate the view as an Access database (Windows only) or .csv file (Mac only).
1) In Tableau Desktop, select Worksheet > Export > Data.
2) Select a location and type a name for your Access database or .csv file.
3) Click Save.
4) If you're on Windows, the Export Data to Access dialog box displays to give you the option to immediately use the new Access database and continue working in Access without interrupting your work flow.

NEW QUESTION 53
What is a story point in Tableau?

A. A collection of worksheets
B. A single worksheet or dashboard
C. A collection of dashboards
D. A collection of both worksheets and dashboards

Answer: B

Explanation:
Explanation
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.
A story is a sheet, so the methods you use to create, name, and manage worksheets and dashboards also apply to stories (for more details, see Workbooks and Sheets). At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet (worksheet or dashboard) in a story is called a story point.
When you share a story -for example, by publishing a workbook to Tableau Public, Tableau Server, or Tableau Online-users can interact with the story to reveal new findings or ask new questions of the data.

NEW QUESTION 54
Dragging a ______________ to colour creates distinct colours for each item whereas dragging a
______________ to colour creates a gradient

A. Discrete value, Continuous Value
B. Longitude, Latitude
C. Continuous Value, Discrete Value
D. Geographic Value, Discrete Value

Answer: A

Explanation:
Explanation
Remember that dragging a discrete value to colour creates distinct colours for each item whereas dragging a continuous value to colour creates a gradient. ( Same for Map ) From the official documentation:

NEW QUESTION 55
How can you change the default Tableau repository location?

A. By clicking on Help -> Change Repository Location
B. By clicking on File -> Repository Location and choosing a new location
C. By clicking on Window -> Repository Location
D. By Moving the repository location manually to wherever we want

Answer: D

Explanation:
Explanation
According to the official Tableau documentation:

NEW QUESTION 56
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. 0
B. 1
C. 2
D. 3

Answer: C

Explanation:
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 )

NEW QUESTION 57
By default, measures placed in a view are aggregated by ______________

A. COUNT
B. MEDIAN
C. SUM
D. AVERAGE

Answer: C

Explanation:
Explanation
By default, measures placed in a view are aggregated by SUM, which means that the data for that field in all of the rows is combined. Measures can also be aggregated as average, median, count, or count distinct.

NEW QUESTION 58
Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.

A. 95.12%
B. 97.12%
C. 99.46%
D. 96.46%

Answer: B

Explanation:
Explanation
Not too tough. Follow along the steps:
* Drag Color to Filter and choose Red:
* 3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:
* And your final view will look like :

NEW QUESTION 59
For Bullet Graphs we need at least ____________ measures

A. 0
B. 1
C. 2
D. 3

Answer: D

Explanation:
Explanation
A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures.
Therefore, we need at least 2 measures for creating bullet graphs.

NEW QUESTION 60
The icon associated with the field that has been grouped is a ______________

A. Globe
B. Intersection
C. =#
D. Paper Clip

Answer: D

Explanation:
Explanation
You can create a group to combine related members in a field. The icon associated with a group is a paper clip!

NEW QUESTION 61
Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?

A. 46,493
B. 37,455
C. 68,620
D. 74,683

Answer: B

Explanation:
Explanation
If you answered this question quickly and correctly, you're well prepared for the exam! Most students stumble while creating a Dual axis chart, so go ahead and give yourself a pat on the back!
To create a dual axis chart for the problem mentioned:
1) Drag Product Type to the column shelf, and Sales and Profit to the Row shelf:

2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:

3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:

4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.

Now the chart looks like this:

Now we change the Profit chart type to line:

5) Finally, we synchronise the axis as follows: Right click on the axis, and choose 'Synchronise axis'

And, our final view and answer is:

NEW QUESTION 62
True or False: Sets can be created on Measures

A. False
B. True

Answer: A

Explanation:
Explanation
Sets are custom fields that are created within Tableau Desktop based on dimensions from your data source.
They are subsets of your data, which can be created manually or computed. Either dimensions or measures can be used to determine what is included or excluded from a set using conditional logic, but to CREATE a set we use dimensions.

Reference : https://interworks.com/blog/rcurtis/2016/10/26/tableau-deep-dive-sets-introduction-sets/

NEW QUESTION 63
Is it possible to make a Measure discrete?

A. No
B. Yes

Answer: B

Explanation:
Explanation
Of course! Follow along:
Right click on any measure, and choose Discrete as shown:

Once you do this, the green pill becomes blue in colour, indicating that it is now Discrete!

NEW QUESTION 64
True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

A. True
B. False

Answer: A

Explanation:
Explanation
This is true, indeed!
The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.

NEW QUESTION 65
What is the minimum amount of RAM recommended for any production use of Tableau Server?

A. 64GB
B. 16GB
C. 32GB
D. 8GB

Answer: C

Explanation:
Explanation
The computer on which you are installing or upgrading Tableau Server must meet the minimum hardware requirements. If the Setup program determines that your computer does not meet the following requirements, you will not be able to install Tableau Server.
These minimum requirements are appropriate for a computer that you use for prototyping and testing of Tableau Server. They apply to single-node installations and to each computer in a distributed installation.

NEW QUESTION 66
What is the one most important thing you should do after creating a Dual-axis chart?

A. Change the colours
B. Synchronise the axis
C. Edit the labels
D. Hide the axis

Answer: B

Explanation:
Explanation
After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.

To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.
In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis.
If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear.
In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.

NEW QUESTION 67
Which of these is NOT a type of Quick Filter available in Tableau?

A. Wildcard Match
B. Regex Match
C. Multiple Values (dropdown)
D. Single Value (slider)

Answer: B

Explanation:
Explanation
Upon clicking on a filter, we see the following options:

Clearly, Regex Match is not one of these options!

NEW QUESTION 68
Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

A. 3.840
B. 3.704
C. 3.500
D. 3.000

Answer: B

Explanation:
Explanation
Since we need to focus on 1 country -> Japan, let's filter on it first as follows:
1) Drag Country to the filter shelf, and choose only Japan. Click OK.

2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:
Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.
Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.
The following is our visualisation:

Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME.
Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward :)

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

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

Answer: D

Explanation:
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.

NEW QUESTION 70
What is the following icon in the Data pane used to do?
Larger image

A. Extract Data
B. View Data
C. Clean Data
D. Sort Data

Answer: B

Explanation:
Explanation
View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view.
The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.
From the official website:

NEW QUESTION 71
What does it imply if a field has a blue background?

A. It is a dimension
B. It is continuous
C. It is a measure
D. It is discrete

Answer: D

Explanation:
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.

NEW QUESTION 72
True or False : Bins can be created on dimensions

A. rue
B. False

Answer: A

Explanation:
Explanation
Bin are a user-defined grouping of numerical data in the data source.
According to the official Tableau documentation: It's sometimes useful to convert a continuous measure (or a numeric dimension) into bins.
Have a look at the following image. When we right click a measure, we get the following options:

However, for a dimension (this is because the of this dimension is a string:

But what if we have a dimension of type NUMBER (NUMERIC DIMENSION)? See below:

We can clearly create bins from dimensions too - they just have to be numeric :) For more information, please refer to: https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm