[May-2024] TDS-C01 Exam Dumps, TDS-C01 Practice Test Questions
Attested TDS-C01 Dumps PDF Resource [2024]
NEW QUESTION # 155
Yes or No: The number of marks will increase when you increase the number of Dimensions in a view
- A. No
- B. Yes
Answer: B
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 # 156
What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?
- A. The calculated fields created in Blends cannot use more than 2 fields
- B. No difference, calculated fields cannot be created in Blends
- C. Fields used in Blends must first be aggregated
- D. The calculated fields created in Blends cannot be edited once created
Answer: C
Explanation:
Yes, due to the nature of blends, there are some conditions as follows from the official documentation that must be kept in mind while working with blends:
In addition to handling calculations slightly differently, there are some limitations on secondary data sources. You may not be able to sort by a field from a secondary data source, and action filters may not work as expected with blended data. For more information, see Other data blending issues.
NEW QUESTION # 157
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. 68,620
- B. 74,683
- C. 46,493
- D. 37,455
Answer: D
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 # 158
What will the following function return?
LEFT("Tableau", 3)
- A. eau
- B. Tab
- C. An error
- D. ble
Answer: B
Explanation:
The following is the official documentation for the String function LEFT:
NEW QUESTION # 159
Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?
- A. 25.79%
- B. 29.49%
- C. 27.73%
- D. 23.39%
Answer: C
Explanation:
We need to use the concept of Groups for this question. Follow along:
1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:
2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:
3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:
We can see the answer already : 23.386% in the view above (even before grouping!)
4) Finally, we get the following view and our answer:
NEW QUESTION # 160
Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.
- A. .tdex
- B. .hyper
- C. .tds
- D. .twbx
Answer: B
Explanation:
Beginning in version 10.5, when you create a new extract, it uses the .hyper format instead of the .tde format.
Extracts in the .hyper format take advantage of the improved data engine, which supports the same fast analytical and query performance as the data engine before it, but for even larger extracts.
Although there are many benefits of using .hyper extracts, the primary benefits include the following:
1) Create larger extracts: You can create extracts with billions of rows of data. Because .hyper extracts can support more data, you can consolidate .tde extracts that you previously had to create separately into a single
.hyper extract.
2) Create and refresh extracts faster: While Tableau has always optimized performance for creating and refreshing extracts, version 2020.3 supports faster extract creation and refreshes for even larger data sets.
3) Experience better performance when interacting with views that use extract data sources: Although smaller extracts continue to perform efficiently, larger extracts perform more efficiently.
NEW QUESTION # 161
What is the following icon in the Data pane used to do?
Larger image
- A. Clean Data
- B. Sort Data
- C. Extract Data
- D. View Data
Answer: D
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 # 162
When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.
- A. Remote Field Name, Field Name
- B. Local Field, Global Field
- C. Local Name, Actual Name
- D. Column Name, Actual Name
Answer: A
Explanation:
Using the Sample superstore as a reference, click on the manage metadata icon as follows:
We can rename a particular column name to make it easier to remember and use in Tableau. Let's change Order ID to oID as shown:
Now, we'll see oID when using this data source in Tableau. This WILL NOT affect the original data source.
The remote field name let's us see what the name of the column is in the ORIGINAL Data source.
NEW QUESTION # 163
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?
- A. No
- B. Yes
Answer: B
Explanation:
Yes, it is very much possible to use measures in the same view multiple times. For example, refer to the image below:
We are using BOTH the Sum of the revenue and the AVG of the revenue in the same view!
NEW QUESTION # 164
If you use a percent difference Quick Table Calculation, what value will be the first data value?
- A. null
- B. 0
- C. 1
- D. 0000
Answer: A
Explanation:
When using a Percent difference, Tableau calculates what the percent change has occured as compared to the last data value. BUT, for the first data value, there is no previous value to compare it to. Hence, it appears as NULL.
Chart, line chart Description automatically generated
NEW QUESTION # 165
When should you use a relationship instead of a join for two data sets?
- A. The data sets are in two separate tables within a single spreadsheet.
- B. The data sets include similar data aggregated at different levels of detail.
- C. The data sets include similar data aggregated up to the highest level.
- D. To use both data sets across multiple sheets in a visualization.
Answer: B
Explanation:
You should use a relationship instead of a join for two data sets when the data sets include similar data aggregated at different levels of detail. A relationship is a way of combining data from different tables based on common fields without creating a single table with all fields. A relationship allows you to query data from multiple tables as needed and preserve the level of detail of each table. A relationship is useful when you have data sets that are aggregated at different levels of detail, such as sales by region and sales by product. A relationship can matchdata from different levels of detail without creating null values or duplicate rows. The other options are not valid situations for using a relationship instead of a join for two data sets. The data sets include similar data aggregated up to the highest level is not correct, because a relationship is not needed when both data sets have the same level of detail. You can use either a relationship or a join in this case, depending on your preference and performance. The data sets are in two separate tables within a single spreadsheet is not correct, because a relationship is not limited by the location or format of the data sets. You can use a relationship to combine data from different sources or connections, such as databases, files, or web services.
To use both data sets across multiple sheets in a visualization is not correct, because a relationship does not affect how you use data in your visualization. You can use either a relationship or a join to create multiple sheets and dashboards with your data sets.
NEW QUESTION # 166
True or False: The Highlighting action can be disabled for the entire workbook.
- A. False
- B. True
Answer: B
Explanation:
Yes, it is possible to disable highlighting for the entire workbook.
For more information : https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm
NEW QUESTION # 167
Which of the following situations describe the best reason to use a union?
- A. You have two tables with similarly named columns of data that you want to combine.
- B. You have two data sets with similar data types for which you want to find only distinct values.
- C. You have two tables with differently named columns of data that you want to combine.
- D. You have two data sets saved in different formats that you want to unify into a single format.
Answer: A
Explanation:
You should use a union when you have two tables with similarly named columns of data that you want to combine. A union is a method for combining data by appending rows of one table onto another table. The tables that you union must have the same number of fields, the same field names, and the same data types2
NEW QUESTION # 168
Dimensions containing ____________ and ____________ values cannot be continuous.
- A. Boolean
- B. Date
- C. Date and Time
- D. String
Answer: A,D
Explanation:
According to Tableau's official documentation -
NEW QUESTION # 169
What are three benefits of using an extract as compared to a live connection to a data source? Choose three.
- A. A live connection to a data source provides the best performance for data connections.
- B. A live connection to a data source can be slow due to network and user traffic, whereas a connection to an extract improves performance.
- C. Extracts are stored in memory (RAM), resulting in faster query performance as compared with live data connections.
- D. An extract reduces the amount of data stored on a client computer as compared to a live data connection.
- E. Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections to a data source.
Answer: B,C,E
Explanation:
There are three benefits of using an extract as compared to a live connection to a data source:
A live connection to a data source can be slow due to network and user traffic, whereas a connection to an extract improves performance. An extract is a snapshot of data that is stored locally on your computer or on Tableau Server. An extract can reduce the load on the data source and speed up queries.
Extracts are stored in memory (RAM), resulting in faster query performance as compared with live data connections. When you use an extract, Tableau loads the data into memory and optimizes it for analysis. This allows Tableau to perform calculations and aggregations faster than with live connections.
Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections to a data source. Calculated fields are custom fields that you create using formulas or expressions. When you use an extract, Tableau can process calculated fields more efficiently than with live connections.
NEW QUESTION # 170
Which of the following points are True about Viz Animations?
- A. Animations work well with maps, polygons, and density marks in web
browsers - B. They can be turned on for certain worksheets only
- C. It is possible to turn them on for the entire workbook at once
- D. Sequential animations take more time but make complex changes
clearer by presenting them step-by-step
Answer: B,C,D
Explanation:
All of the given options are true except - Animations work well with maps, polygons, and density marks in web browsers.
From the official documentation:
As seen above, we can either turn the animations for the entire workbook (upper red box), or only for the current sheet ( lower red box )
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.
NEW QUESTION # 171
Which Sub-Category had the least Profit in the Office Supplies category?
- A. Fasteners
- B. Binders
- C. Envelopes
- D. Labels
Answer: A
Explanation:
Explanation
To reach the correct answer, follow the steps below:
1) Drag Category, and sub-category to the row shelf. Drag Profit to the Column shelf
2) Click the Sort-ascending icon as shown above, to sort the profits from least to greatest as shown:
Click the 'Show mark labels icon'
As we can see, Fasteners has the least Profit in the Office Supplies Category, and hence is our correct answer!
NEW QUESTION # 172
If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can __________________ the view.
- A. aggregate the measures
- B. disaggregate the measures
- C. sort the measures
- D. split the measures
- E. break-down the measures
Answer: B
Explanation:
The different aggregations available for a measure determine how the individual values are collected: they can be added (SUM), averaged (AVG), or set to the maximum (MAX) or minimum (MIN) value from the individual row values.
For a complete list of the available aggregations, check out - List of Predefined Aggregations in Tableau.
The level of detail is determined by the dimensions in your view-for information about the concept of level of detail, see How dimensions affect the level of detail in the view.
Disaggregating your data can be useful for analyzing measures that you may want to use both independently and dependently in the view. For example, you may be analyzing the results from a product satisfaction survey with the Age of participants along one axis. You can aggregate the Age field to determine the average age of participants or disaggregate the data to determine at what age participants were most satisfied with the product.
Disaggregating data can be useful when you are viewing data as a scatter plot. See Example: Scatter Plots, Aggregation, and Granularity.
NEW QUESTION # 173
For a relative date filter, the default anchor is _________________
- A. Today's date
- B. The current time
- C. The target date
- D. The date we specify
Answer: C
Explanation:
Explanation
Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most recent data.
Step 1: Drag a date field to the filter shelf
Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.
Step 2: Select a time unit
In the Filter dialog box, click Relative dates, and then select the unit of time for the filter. For example, to show only the three most recent weeks, select Weeks.
Here, you can clearly see that the default date is TODAY
NEW QUESTION # 174
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 # 175
What should you use to create headers in a visualization?
- A. A measure
- B. A dimension
D A filter - C. A parameter
Answer: B
Explanation:
According to the Tableau Help, headers are "labels that identify the different parts of your view". The help also states that "Headers are created when you place a discrete dimension on Columns or Rows" (page 1).
NEW QUESTION # 176 
- A. Area
- B. Gantt
- C. Line
- D. Bullet
Answer: A
Explanation:
According to the official Tableau documentation:
An example of an area chart is shown below:
NEW QUESTION # 177
True or False: When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, then relating these tables is not possible.
- A. False
- B. True
Answer: A
Explanation:
Graphical user interface, application Description automatically generated
Tables that you drag to the logical layer of the Data Source page canvas must be related to each other. When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, you will need to select them.
If no constraints are detected, a Many-to-many relationship is created and referential integrity is set to Some records match. These default settings are a safe choice and provide the most a lot of flexibility for your data source.
NEW QUESTION # 178
Which of the following are valid Dashboard size options?
- A. Range
- B. Automatic
- C. Scaled
- D. Fixed Size
Answer: A,B,D
Explanation:
Scaled is NOT a valid size options when creating Dashboards in Tableau!
After you create a dashboard, you might need to resize and reorganize it to work better for your users.
NEW QUESTION # 179
......
Latest TDS-C01 Actual Free Exam Questions Updated 315 Questions: https://skillmeup.examprepaway.com/Tableau/braindumps.TDS-C01.ete.file.html