[Nov 26, 2022] New Real TDS-C01 Exam Dumps Questions
Pass Your TDS-C01 Exam Easily with Accurate Tableau Desktop Specialist PDF Questions
NEW QUESTION 112
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.
- A. Union Search
- B. Wildcard Search
- C. Pattern Search
- D. Regex Search
Answer: B
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.
NEW QUESTION 113
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
- B. False
Answer: B
Explanation:
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.
NEW QUESTION 114
Which of the following are valid ways to italicize Tooltip content in Tableau?
- A. Click on Dashboard in the Menu bar, select Tooltip, and then use the italics option
- B. Click on Tooltip in the Marks card, select the text, and then use the Italics option
- C. Click on Format in the Menu bar, choose Font, and then edit the
Tooltip options to italicize the font - D. Click on Worksheet in the Menu bar, select Tooltip, and then use
the italics option
Answer: B,C,D
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:
NEW QUESTION 115
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 116
What does the box in a box plot represent?
- A. Maximum value of the data
- B. The median of the middle half of the data points
- C. The interquartile range
- D. Minimum value of the data
Answer: C
Explanation:
In a box and whisker plot:
1) The ends of the box are the upper and lower quartiles, so the box spans the interquartile range
2) The median is marked by a vertical line inside the box
3) The whiskers are the two lines outside the box that extend to the highest and lowest observations.
NEW QUESTION 117
Yes or No: The number of marks will increase when you increase the number of Dimensions in a view
- A. Yes
- B. No
Answer: A
Explanation:
Explanation
Of course! As an example, see below:
1) Using the Sample Superstore data, let's plot a bar chart showing the Sales for each Category:
Observe that we have 3 marks - Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark , and so on for all charts.
1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark - a single continous axis, but 3 different marks (Technology, Furniture and Office supplies ) on the x-axis.
2) Now let's add subcategory to the view as well (another dimension):
Observe that the number of marks has increased - i.e the number of Bars.
Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)
NEW QUESTION 118
Yes or No: The number of marks will increase when you increase the number of Dimensions in a view
- A. Yes
- B. No
Answer: A
Explanation:
Of course! As an example, see below:
1) Using the Sample Superstore data, let's plot a bar chart showing the Sales for each Category:
Observe that we have 3 marks - Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark , and so on for all charts.
1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark - a single continous axis, but 3 different marks (Technology, Furniture and Office supplies ) on the x-axis.
2) Now let's add subcategory to the view as well (another dimension):
Observe that the number of marks has increased - i.e the number of Bars.
Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)
NEW QUESTION 119
When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.
- A. stepped
- B. reversed
- C. diverging
- D. converging
Answer: C
Explanation:
NEW QUESTION 120
Using the atheletes table:
i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1) ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark.
(Sheet 2)
Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?
(Ignore any nulls / unknowns)
- A. 4.87
- B. 76.25
- C. 68.77
- D. 65.67
Answer: B
Explanation:
Explanation
Pretty common question on the Tableau Desktop Specialist exam.
1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:
2) Now, for sheet 2 - Drag nationality to the view, and gold to the size mark in the Marks shelf.
NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:
3) Now, let's create a dashboard, and use both these sheets in it:
4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:
Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:
NEW QUESTION 121
Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser?
- A. YES, we can do this with the help of a Web-Page object
- B. YES, we can do this with the help of a plugin
- C. YES, we can do this with the help of Tableau Public
- D. NO, this is not currently possible in Tableau
Answer: A
Explanation:
To interactively display information from the web INSIDE a dashboard, you can use a URL action with a web page object.
For example, you might have a dashboard that shows profits by country. In addition to showing the profit data in your dashboard, you also want to display supplemental information about the countries from a web site.
NEW QUESTION 122
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
- A. Extract Filter
- B. Context Filter
- C. Dimension Filter
- D. Measure Filter
Answer: A
Explanation:
Explanation
According to Tableau's order of operations, the Extract filter is right at the top of the hierarchy. The data filtered in the Extract is then passed on to what we see in the Data Pane. See below:
NEW QUESTION 123
________________ can only create header. _______________ will create header and axis both.
- A. Dimensions, Measures
- B. Groups, Sets
- C. Measures, Dimensions
- D. Dates, Strings
Answer: A
Explanation:
Using the Sample superstore as a reference:
1) Let's plot a bar chart showing SUM(Quantity) for each Segment:
2) Right click on the x-axis (Segment):
Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS.
3) Similarly, right click on the y-axis (Quantity):
Now we have the option to edit BOTH the axis and the header.
Reference:
2) Right click on the x-axis (Segment):
Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS.
3) Similarly, right click on the y-axis (Quantity):
Now we have the option to edit BOTH the axis and the header.
NEW QUESTION 124
Which of the following charts types always includes bars sorted in descending order?
- A. Gantt Chart
- B. Pie Chart
- C. Pareto Chart
- D. Stacked Bar Chart
Answer: C
Explanation:
A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the ascending cumulative total is represented by the line.
On the primary axis, bars are used to show the raw quantities for each dimension member, sorted in descending order.
On the secondary axis, a line graph is used to show the cumulative total in percent format.
NEW QUESTION 125
________________ files are shortcuts for quickly connecting to the original data that you use often. 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.
- A. .twb
- B. .tde
- C. .tbm
- D. .tds
Answer: D
Explanation:
According to the official Tableau documentation:
Tableau data source files have the .tds file extension. Data source files are shortcuts for quickly connecting to the original data that you use often. 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. For more information, see Save Data Sources.
NEW QUESTION 126
When exporting a worksheet as an image in Tableau, which of the following file formats are available?
- A. Tagged Image File Format (TIFF)
- B. Portable Network Graphic (.PNG)
- C. JPEG Image (.JPG, .JPEG)
- D. Windows Bitmap (.BMP)
Answer: B,C,D
Explanation:
Explanation
The following options are available when an image is Exported:
NOTE: When we Copy an image rather than exporting it, then the image is copied to the clipboard in the TIFF file format! However, it is not available when EXPORTING an image.
NEW QUESTION 127
DOWNLOAD THE DATASET FROM - https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv-SgzaBq/view?usp=sharing ( if you haven't already from the test instructions page! ) How many different countries are present in the dataset?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
To reach the correct answer, follow these steps:
1) You can simply drag Country to the view, and look at the marks in the bottom left of Tableau Desktop - 147 marks!
2) Or, you can simply go to Data Source -> Country Tab -> Describe
As you can see, 147 members exist in this Country column!
NEW QUESTION 128
_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.
- A. Tableau Packaged Workbook (.twbx)
- B. Tableau Data Extract (.tde)
- C. Tableau Data Source (.tds)
- D. Tableau Workbook (.twb)
Answer: B
Explanation:
Tableau Data Extract (TDE) is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Performance is optimised because it queries its own database engine instead of the local data source.
When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data. When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.
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.
NEW QUESTION 129
Which of the following are compelling reasons to use a Stacked Bar Chart?
- A. To be able to visualize complex information with fewer bars /
marks - B. To easily visualize trends over time
- C. To visualize each discrete category using a separate bar.
- D. To visualize parts of a whole
Answer: A,D
Explanation:
Stacked bar charts will usually have lesser number of bars compared to a normal bar chart:
Normal bar chart - 9 bars
Stacked Bar Chart - 3 bars
We can easily see a 'part-of-a-whole' methodology being used here as well - we are seeing the breakdown of Segments within each Category.
To easily visualize trends over time - This is the definition of a line chart.
To visualize each discrete category using a separate bar - This can be accomplished using a simple bar chart, why use a stacked one?
NEW QUESTION 130
DOWNLOAD THE DATASET FROM:
https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ-574wld4InEplyKT8RP?usp=sharing (if you haven't already) Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?
- A. United States
- B. Canada
- C. United Kingdom
- D. France
Answer: D
Explanation:
Explanation
Follow along to get the correct answer:
* Drag Country to the view, and then Patents to the Size Mark on the Marks shelf as follows :
2) But, this isn't all right? We need to focus on the year 2013. This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:
2.1 As it is (continuous)
2.2 Converting to discrete first & then using it
and then :
3) We can now see that France, with 485 has the 2nd most number of patents for the year 2013
NEW QUESTION 131
......
TDS-C01 Certification Exam Dumps Questions in here: https://drive.google.com/open?id=115A32VmHAOZ5i0jT75MA6epCXPKjvjWG
Updated TDS-C01 Exam Practice Test Questions: https://www.itexamsimulator.com/TDS-C01-brain-dumps.html
