[2022] TDS-C01.pdf - Questions Answers PDF Sample Questions Reliable
Tableau TDS-C01 Dumps PDF Are going to be The Best Score
NEW QUESTION 86
_____________ 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 Workbook (.twb)
- D. Tableau Data Source (.tds)
Answer: B
Explanation:
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 87
Question 45: Skipped
You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?
- A. Sets
- B. Parameters
- C. Groups
- D. Calculation
Answer: B
Explanation:
Explanation
A parameter is a global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line.
For example, you may create a calculated field that returns True if Sales is greater than $500,000 and otherwise returns False. You can replace the constant value of "500000" in the formula with a parameter.
Then, using the parameter control, you can dynamically change the threshold in your calculation.
For example -
NEW QUESTION 88
A field that shows average home values for the United States in 2016 is most likely :
- A. A geographical dimension
- B. A continuous date value dimension
- C. A discrete date part dimension
- D. An aggregated measure
Answer: D
Explanation:
Explanation
This question is directly from the Official Tableau Desktop Specialist exam guide.
Since we are talking about the AVERAGE home values for the United States in 2016, the question is directly offering us a hint that the answer has something to do with aggregation and that too the values tell us that we're working with MEASURES.
Date part and Date values don't really make much sense given the question, and neither does geography.
Therefore, the answer naturally is "An aggregated measure".
NEW QUESTION 89
Which of the following are benefits of using Data Extracts in Tableau?
- A. Faster to work with
- B. Ability to use the data offline
- C. Working with freshest data at all times
- D. Improved Performance
Answer: A,B,D
Explanation:
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!
NEW QUESTION 90
We can join a maximum of ______ tables in Tableau
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Explanation
It is possible to join a maximum of 32 tables in Tableau!
NEW QUESTION 91
Given a map, which of the following fields can be placed in Size,Shape,Detail,Color
- A. Region, Country, Profit, State
- B. Longitude, Country, State, Sales
- C. Sales, State, Country, Profit
- D. Profit, State, Number of Records, Sales
Answer: C
Explanation:
Explanation
Since Sales is a measure, it can easily be depicted via size.
To drill down and change the level of detail, Country is the correct choice since it will contain STATE. We can then depict the various states by different shapes such as circle, square etc.
Finally, the Profit can be depicted via a color! Eg - Red for poor and green for excellent profits!
NEW QUESTION 92
What term is used to describe the following picture?
- A. Hierarchy
- B. Larger image
- C. Parameter
- D. Set
- E. Group
Answer: D
Explanation:
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.
NEW QUESTION 93
________________ can only create header. _______________ will create header and axis both.
- A. Dates, Strings
- B. Dimensions, Measures
- C. Measures, Dimensions
- D. Groups, Sets
Answer: B
Explanation:
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.
NEW QUESTION 94
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 Kingdom
- B. France
- C. Canada
- D. United States
Answer: B
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 95
Which of the following chart type makes use of 'binned' data?
- A. Gantt Chart
- B. Histogram
- C. Treemaps
- D. Bullet chart
Answer: B
Explanation:
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.
NEW QUESTION 96
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.000
- C. 3.500
- D. 3.704
Answer: D
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 97
You can create _______________ for members in a dimension so that their labels appear differently in the view.
- A. aliases
- B. copies
- C. parameters
- D. duplicates
Answer: A
Explanation:
Explanation
You can create aliases (alternate names) for members in a dimension so that their labels appear differently in the view.
Aliases can be created for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures.
To create an alias:
1) In the Data pane, right-click a dimension and select Aliases.
2) In the Edit Aliases dialog box, under Value (Alias), select a member and enter a new name.
* To submit your changes: In Tableau Desktop, click OK.
On Tableau Server or Tableau Online, click the X icon in the top-right corner of the dialog box.
When you add the field to the view, the alias names appear as labels in the view. For example:
NEW QUESTION 98
How can you format an axis as Bold in Tableau?
- A. By right clicking on the axis, choosing format, and then setting its font to bold.
- B. By choosing the axis and selecting Command/Control + B on your keyboard
- C. By right clicking on the axis, choosing Edit Axis, and then setting its font to bold.
- D. By clicking on Format on the main menu bar, choosing field labels, and setting it to bold.
Answer: A
Explanation:
Explanation
To make an axis bold, simply right click it, select format, and then click on Font to choose Bold:
None of the other options are valid ways to make the axis bold.
Read more about editing axis: https://help.tableau.com/current/pro/desktop/en-us/formatting_editaxes.htm
NEW QUESTION 99
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: A
Explanation:
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 100
When exporting a worksheet as an image in Tableau, which of the following file formats are available?
- A. Tagged Image File Format (TIFF)
- B. JPEG Image (.JPG, .JPEG)
- C. Windows Bitmap (.BMP)
- D. Portable Network Graphic (.PNG)
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 101
Which Sub-Category had the least Profit in the Office Supplies category?
- A. Binders
- B. Labels
- C. Envelopes
- D. Fasteners
Answer: D
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 102
Which of the following are the options to export the data used to build the view / visualisations?
- A. JSON format
- B. MS Access Database
- C. CSV file
- D. PDF File
Answer: B
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 103
Which data type in Tableau does this icon represent?
Larger image
- A. Geographic
- B. True or False
- C. Boolean
- D. String
Answer: A
Explanation:
Explanation
The following is the table for the data types in Tableau along with their icons:
NEW QUESTION 104
What will the following function return?
LEFT("Tableau", 3)
- A. eau
- B. An error
- C. Tab
- D. ble
Answer: B
Explanation:
Explanation
The following is the official documentation for the String function LEFT:
NEW QUESTION 105
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us
- A. 2 , 2
- B. 2 , 3
- C. 1 , 4
- D. 1 , 2
Answer: C
Explanation:
Explanation
Tableau auto-generates :
1 Dimension - Measure Names
4 Measures - Latitude, Longitude, Number of records, Measure Values
Starting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)
NEW QUESTION 106
For creating variable sized bins we use __________________
- A. Sets
- B. Calculated Fields
- C. Table Calculations
- D. Groups
Answer: B
Explanation:
Explanation
One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0-5, 6-10, 11-15, and so on. Then you can count the number of people in each age group.
Create a calculated field for variable bin size
Step 1
Select Analysis > Create Calculated Field.
Step 2
In the Calculated Field dialog box, complete the following steps:
NEW QUESTION 107
We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.
- A. Tableau Server
- B. Tableau Online
- C. Tableau Desktop
- D. Tableau Reader
Answer: D
Explanation:
Explanation
The word 'static tool' gives it away.
According to the official website :
NEW QUESTION 108
The default path for all supporting files, data sources, icons, logs etc is in ______________________
- A. Downloads -> Tableau Support Files
- B. Documents -> Tableau Files
- C. Documents -> My Tableau Repository
- D. Documents -> Tableau
Answer: C
Explanation:
Explanation
By default, all of the above mentioned are stored in Documents -> My Tableau Repository
NEW QUESTION 109
True or False: Context Filters are executed after Data Source filters
- A. True
- B. False
Answer: A
Explanation:
Explanation
THIS IS A VERY IMPORTANT QUESTION
To answer this question, you need to understand Tableau's Order of Operations. See below and remember this always:
NEW QUESTION 110
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
- A. Blue, Red
- B. Blue, Orange
- C. Red, Blue
- D. Orange, Blue
Answer: B
Explanation:
Explanation
When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark.
See below:
NEW QUESTION 111
......
Use TDS-C01 Exam Dumps (2022 PDF Dumps) To Have Reliable TDS-C01 Test Engine: https://actualtests.realvalidexam.com/TDS-C01-real-exam-dumps.html
