Test Online Free Tableau TDS-C01 Exam Questions and Answers
Practice a live sample before buying full access. This page keeps the free TDS-C01 question set organized by page so visitors and search engines can reach the canonical -questions.html URL directly.
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?
Answer: 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.
Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm
Question 32Selectable Answer
A Tableau Support case can be opened in which of the following valid ways?
Answer: Explanation:
It is possible to open a Tableau support case by visiting the following link :
https://www.tableau.com/support/case
Question 33Selectable Answer
When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks.
Search is scoped to the selected connection.
Answer: Explanation:
You can use Wildcard Search to set up search criteria to automatically include tables in your union. Use the wildcard character, which is an asterisk (*), to match a sequence or pattern of characters in the Excel workbook and worksheet names, Google Sheets workbook and worksheet names, text file names, JSON file names, .pdf file names, and database table names.
When working with Excel, text file data, JSON file, .pdf file data, you can also use this method to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page.
Which of the following are correct ways to define a join in Tableau version 2020.3 and
above?
Answer: Explanation:
Remember that joins are defined in the physical layer and relationships in the logical layer.
You can still specify joins between tables in the physical layer of a data source. Double-click a logical table to go to the Join/Union canvas in the physical layer and add joins or unions.
Every top-level, logical table contains at least one physical table. Open a logical table to view, edit, or create joins between its physical tables. Right-click a logical table, and then click Open. Or, just double-click the table to open it.
When you create a data source, it has two layers. The top-level layer is the logical layer of the data source. You combine data between tables in the logical layer using relationships.
The next layer is the physical layer of the data source. You combine data between tables at the physical layer using joins. For more information, see Logical and physical tables in the data model
Which of the following 2 fields CANNOT be deleted in Tableau?
Answer: Explanation:
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.
Question 37Selectable Answer
Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM.
Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?
Answer: Explanation:
VERY IMPORTANT QUESTION FOR THE EXAM, PAY ATTENTION
1) To find the number of days between order date and shipping date, we will make use of a calculated field:
In the data pane, click on the dropdown arrow, and choose create calculated field.
Let's name this calculated field "ShippingDelay" (you can name it anything you want :))
2) Use the DATEDIFF() function, and pass it the arguments as follows:
'day' depicts that we want to calculate the number of DAYS between the two dates. The first argument is 'start_date' which is the ORDER_DATE (day the order was placed), the second argument is 'end_date', which is the SHIP_DATE (date the order was shipped). So by subtracting as follows: SHIP_DATE - ORDER_DATE, we can find the delay in shipping.
Click OK.
3) You should now have a new measure as follows:
4) Phew! The hard part is done! Now let's filter by Market to include only LATAM:
5) Drag Country to the view, and the new calculated field 'ShippingDelay' to SIZE on the Marks Shelf as follows:
*You can also click on Show Text Labels to be sure that you're choosing the Largest value*
Clearly, Mexico has the highest Shipping Delay!
Question 38Selectable Answer
Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a ____________ and a ____________.
Answer: Explanation:
When users connect to Tableau, the data fields in their data set are automatically assigned a role and a type.
Role can be of the following two types:
1) Dimension
2) Measure
Type can be of the following :
1) String
2) Number
3) Geographic
4) Boolean
5) Date
6) Date and Time
Question 39Selectable Answer
Which of the following are valid ways to italicize Tooltip content in Tableau?
Answer: Explanation:
The only incorrect option is - Click on Dashboard in the Menu bar, select Tooltip, and then use the italics option.
This option doesn't exist. See below:
The rest of the options do exist, and therefore are correct:
Graphical user interface, text, application
Description automatically generated
Question 40Selectable Answer
How would you calculate GDP per capita in Tableau?
Answer: Explanation:
GDP / Population = GDP Per Capita
Here Sum is a function, / and + are operators. On the bottom there are comments.
Question 41Selectable Answer
We can join a maximum of ______ tables in Tableau
Answer: Explanation:
It is possible to join a maximum of 32 tables in Tableau!
Reference: https://www.mytectra.com/interview-question/tableau-interview-question-and-answers
Question 42Selectable Answer
Which of the following can you use to create a Histogram?
Answer: Explanation:
A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.
The basic building blocks for a histogram are as follows:
Which of the following are valid way(s) to make either of Rows or Columns Bold without affecting the other?
Answer: Explanation:
1) Right click on Rows or Columns, and choose format. In the Font option click on Bold. (CORRECT) - this will modify only the selected axis (row or column)
2) Choose Format then Font from the Menu bar, and select Bold under the Header option (INCORRECT) - this modifies both rows and columns at the same time
3) Choose Format from the Menu bar, select Row or Column, and then select Bold
under the header option (CORRECT) - this will modify only the selected axis (row or column)
4) Select Text Label on the Marks Card, choose Rows or Columns, and then select Bold. (INCORRECT) - no such option exists
Question 44Selectable Answer
True or False: Enabling any other type of sort (Field, alphabetic, or Nested) clears the manual sort we create.
Answer: Explanation:
This is true. a Manual Sort lets you select a value and move it to the desired position, either by dragging it in the list or using the arrows to the right.
However, as soon as you choose some other type of sort - be it field, nested, or alphabetic, our custom created manual sort gets deleted/cleared.
Reference: https://help.tableau.com/current/pro/desktop/en-us/sortgroup_sorting_computed_howto.htm
Question 45Selectable Answer
Which of the following are benefits of using Data Extracts in Tableau?
Answer: Explanation:
Extracts are advantageous for several reasons:
1) Supports large data sets: You can create extracts that contain billions of rows of data.
2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data.
3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.
4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to
compute Count Distinct.
5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.
To work with the MOST up-do-date data, use a live connection instead!
Reference: https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm
