TDS-C01 Premium Files Updated Nov-2022 Practice Valid Exam Dumps Question [Q20-Q42]

November 21, 2022 admin 0 Comments

Rate this post

TDS-C01 Premium Files Updated Nov-2022 Practice Valid Exam Dumps Question

Practice with TDS-C01 Dumps for Tableau Desktop Specialist Certified Exam Questions & Answer

NO.20 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?

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 )

NO.21 Are animations enabled by default in Tableau?

Yes

Explanation
No, by default, animations are not enabled in Tableau.
We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate.
Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.
When you author animations, you can choose between two different styles: simultaneous or sequential. Here are examples of each type.
1) Simultaneous animations
The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.

2) Sequential animations
Sequential animations take more time but make complex changes clearer by presenting them step-by-step.

To Animate visualizations in a workbook:
1) Choose Format > Animations.
2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:
For Duration, choose a preset, or specify a custom duration of up to 10 seconds.
For Style, choose Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.
3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.

NO.22 Which of the following 2 fields CANNOT be deleted in Tableau?

Number of Records

Measure Names

Measure Values

Calculated Fields

Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated.
Calculated Fields, and Number of records can both be deleted.

NO.23 When using Animations in a Tableau, which of the following is the default duration for animations?

0.4s

0.3s

0.5s

0.2s

Explanation
The LATEST Tableau Desktop Sepcialist exam blueprint now requires you to know some basics about animations as well!
NOTE: Animations are DISABLED by default and must be manually enabled.

You can also reset all settings to default by clickin on ‘Reset All’

NO.24 Which of the following sets would you use to compare the members?

None of these

Dynamic Sets

Static Sets

Combined Sets

You can combine two sets to compare the members. When you combine sets you create a new set containing either the combination of all members, just the members that exist in both, or members that exist in one set but not the other.
Combining sets allows you to answer complex questions and compare cohorts of your data. For example, to determine the percentage of customers who purchased both last year and this year, you can combine two sets containing the customers from each year and return only the customers that exist in both sets.
To combine two sets, they must be based on the same dimensions. That is, you can combine a set containing the top customers with another set containing the customers that purchased last year. However, you cannot combine the top customers set with a top products set.

NO.25 The calculation [Ship Date] – [Order Date] will return _______________

Number of orders placed in that duration

Number of days between these dates

Number of unique orders placed between these dates

Number of orders shipped between these dates

As the names suggest, if we subtract the order date from the shipping date, we simply get the number of days between these 2 dates.
We can these use this calculated field in our charts, and can use COUNT, SUM, AVG etc with them according to our need.

NO.26 Which of the following are benefits of combining sheets using dashboards?

Easier to compare visualisations side by side

It is mandatory to combine sheets when using Tableau

Helps in faster analysis

Provides the ability to use one sheet as a filter for other

The only incorrect option is – It is mandatory to combine sheets when using Tableau.
All others are valid advantages that Dashboards provide when using Tableau!

NO.27 For Bullet Graphs we need at least ____________ measures

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.

NO.28 You just added this field to the Columns shelf.

What will this create?

A vertical header

A horizontal axis

A vertical axis

A horizontal header

We know that continuous fields will always create an axis, so options stating ‘header’ are automatically eliminated. For our question, see below:

Had the question asked us to place this pill on the Rows shelf instead, we would’ve gotten a different answer:

NO.29 True or False : Bins can be created on dimensions

False

rue

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 DATA TYPE 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

NO.30 _________________ 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

Union

Data Joining

Data segregation

Data Blending

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.

NO.31 Data blending simulates a traditional _________________ Join

Inner

Right

Full Outer

Left

Explanation
Data blending simulates a traditional left join. The main difference between the two is when the aggregation is performed. A join combines the data and then aggregates. A blend aggregates and then combines the data.
From the official website:

NO.32 What term is used to describe the following picture?

Larger image

Parameter

Set

Hierarchy

Group

Explanation
When you connect to a data source, Tableau automatically separates date fields into hierarchies so you can easily break down the viz. You can also create your own custom hierarchies. For example, if you have a set of fields named Region, State, and County, you can create a hierarchy from these fields so that you can quickly drill down between levels in the viz.

NO.33 If you have a dashboard and are displaying its filter, how can you rearrange it?

By clicking on the 2 lines on top and dragging the filter.

By clicking on the dropdown and dragging the filter

By clicking on the filter title and dragging it.

By clicking anywhere inside the filter and dragging it.

You can drag the filter by clicking on the 2 lines on top, and then dragging the filter as shown:

NO.34 Which of the following are valid ways to show Mark Labels in the visualisation?

Click on the Show mark labels icon in the Toolbar

Drag the measure to the Text label in the Marks Card

Click on Data in the Menu bar and Choose Show Mark Labels

Click on Analysis in the Menu bar and choose Show Mark Labels

The following showcase how you can show mark labels. Using the Sample Superstore dataset:
1) Let’s create a Bar chart showing the sales for each sub-category:

2) Now you can show labels by:
2.1) Click on Show Mark Labels Icon in the Toolbar ( easiest )

2.2) Drag Sales to the Text icon in the Marks Card:
2.3) Click on Analysis -> Show mark labels from the Tableau menu bar:

NO.35 When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?

Monitor, Default, Phone, Tablet

Phone, Tablet, Laptop, Desktop

Default, Phone, Tablet, Desktop

Phone, Monitor, Laptop, Default

The following options are available in the Device preview section when creating a Dashboard:

NO.36 You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy this requirement?

Save it as a .twm file

Save it as a .twb file

Save it as a .tds file

Save it as a .twbx file

Explanation
After making changes to Data, we can save that new data source as a .tds file. To do so, go to data menu on top and then choose your current connected data source. Then next click on Add to Saved Data sources. This will save all calculated fields, changes to fields etc. It will be saved in My Tableau Repository -> Mydatasources. This will then also appear on Tableau Home Page under saved data sources like SampleSuperStore.
Note: Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you’ve made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.
twb and .twbx are not the BEST solutions since the questions nowhere mentions that we need to store our workbooks as well.
twm is a bookmark which contains a single worksheet and are an easy way to quickly share your work.

NO.37 Which of the following 2 columns CANNOT be deleted in Tableau?

Measure Names

Number of Records

Measure Values

Calculated Fields

Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated.
Calculated Fields, and Number of records can both be deleted.

NO.38 What is the one most important thing you should do after creating a Dual-axis chart?

Synchronise the axis

Change the colours

Edit the labels

Hide the axis

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.

NO.39 Which of the following is not a Trend Line Model?

Linear Trend Line

Exponential Trend Line

binomial Trend Line

Logarithmic Trend Line

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 BINOMIAL trend 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

NO.40 How would you calculate GDP per capita in Tableau?

SUM([GDP]/[POPULATION])

SUM([Population]/[GDP]])

SUM([GDP]*[POPULATION])

SUM([GDP]) / SUM([Population])

GDP / Population = GDP Per Capita

Here Sum is a function, / and + are operators. On the bottom there are comments.

NO.41 True or False: Trend lines can only be used with numeric or date fields

True

False

You can show trend lines in a visualization to highlight trends in your data.
To add trend lines to a view, both axes must contain a field that can be interpreted as a number. For example, you cannot add a trend line to a view that has the Product Category dimension, which contains strings, on the Columns shelf and the Profit measure on the Rows shelf.
However, you can add a trend line to a view of sales over time because both sales and time can be interpreted as numeric values.

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

By simply clicking Control + V on the keyboard

By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy->Image

Using the Marks shelf and choosing Copy->Image

By right clicking on the worksheet visualisation and selecting Copy->Image

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

AND

Loading …

REAL TDS-C01 Exam Questions With 100% Refund Guarantee : https://www.topexamcollection.com/TDS-C01-vce-collection.html

TDS-C01 Practice Tests

TDS-C01 Premium Files Updated Nov-2022 Practice Valid Exam Dumps Question [Q20-Q42]

Related Certifications

TDS-C01
Desktop-Certified-Associate