[Dec 02, 2021] Reliable TDS-C01 Exam Tips Test Pdf Exam Material [Q57-Q74]

[Dec 02, 2021] Reliable TDS-C01 Exam Tips Test Pdf Exam Material

New 2021 TDS-C01 Test Tutorial (Updated 150 Questions)

NEW QUESTION 57
Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.

A. 95.12%
B. 96.46%
C. 99.46%
D. 97.12%

Answer: D

Explanation:
Explanation
Not too tough. Follow along the steps:
* Drag Color to Filter and choose Red:
* 3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:
* And your final view will look like :

NEW QUESTION 58
______________ refers to the level of detail for a piece of data, wherever you are looking.

A. Data granularity
B. Data connectivity
C. Data LOD
D. Data Cleanliness

Answer: A

Explanation:
Explanation
Data is generated and analyzed at many different levels of granularity. Granularity is the level of detail of the data. For example, when looking at graduation data, granularity would describe whether a row in the data set represents a single person or the graduating class of a university.

NEW QUESTION 59
What is the minimum amount of RAM recommended for any production use of Tableau Server?

A. 16GB
B. 8GB
C. 32GB
D. 64GB

Answer: C

Explanation:
Explanation
The computer on which you are installing or upgrading Tableau Server must meet the minimum hardware requirements. If the Setup program determines that your computer does not meet the following requirements, you will not be able to install Tableau Server.
These minimum requirements are appropriate for a computer that you use for prototyping and testing of Tableau Server. They apply to single-node installations and to each computer in a distributed installation.

NEW QUESTION 60
True or False: It is possible to add a field to more than one hierarchy

A. True
B. False

Answer: A

Explanation:
Explanation
Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.

NEW QUESTION 61
Which of the following would you use to connect to multiple tables in a single data source at once?

A. A Hierarchy
B. A Blend
C. A Set
D. A Join

Answer: D

Explanation:
Explanation
The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data.
For example, consider the following two tables originating from a single data source:

We can combine these 2 tables, simply by joining the tables on ID to answer questions like, "How much was paid in royalties for authors from a given publisher?". By combining tables using a join, you can view and use related data from different tables in your analysis.

NEW QUESTION 62
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 63
For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

A. Manual
B. Random
C. Hierarchical
D. Topological

Answer: A

Explanation:
Explanation
For a manual sort, no matter how the data changes, the values will always stay in the sort order you kept stuff in.
From the official website:

NEW QUESTION 64
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 65
Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

A. 1,461
B. 111,060
C. 1,222
D. 112,256

Answer: D

Explanation:
Explanation
If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.
To reach the correct answer, follow the steps below:
1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well!
Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!

* The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October

NEW QUESTION 66
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 67
For Bullet Graphs we need at least ____________ measures

A. 0
B. 1
C. 2
D. 3

Answer: D

Explanation:
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.

NEW QUESTION 68
When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?

A. Data source Filter
B. None of the these
C. Context Filter
D. Extract Filter

Answer: C

Explanation:
Explanation
IMPORTANT QUESTION, PAY ATTENTION
By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter. Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.
You may create a context filter to:
1) Improve performance - If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.
2) Create a dependent numerical or top N filter - You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.

NEW QUESTION 69
True or False: All rows from both tables are returned in an INNER JOIN

A. True
B. False

Answer: B

Explanation:
Explanation
The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns.
Consider 2 tables "Orders" and "Customers".
If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!

NEW QUESTION 70
The View Data window displays as much of the data as possible by default, up to _______________ rows.

A. 5,000
B. 15,000
C. 20,000
D. 10,000

Answer: D

Explanation:
Explanation
The View Data window displays as much of the data as possible by default, up to 10,000 rows. This can be increased though, if you wish to.

Read more: https://help.tableau.com/current/pro/desktop/en-gb/inspectdata_viewdata.htm

NEW QUESTION 71
Data blending simulates a traditional _________________ Join

A. Full Outer
B. Left
C. Right
D. Inner

Answer: B

Explanation:
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:

NEW QUESTION 72
Which of the following calculations DO NOT need a quick table calculation?

A. Moving Average
B. Rank
C. Standard Deviation
D. Variance

Answer: D

Explanation:
Explanation
For Standard Deviation and Variance, we don't need to use quick table calculations, since they are available by default. See below:

However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average belong to only this category.

NEW QUESTION 73
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. Wildcard Search
B. Pattern Search
C. Union Search
D. Regex Search

Answer: A

Explanation:
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.