Tableau TDS-C01 Tableau Desktop Specialist Exam Practice Test

Page: 1 / 14
Total 317 questions
Question 1

Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?



Answer : D

Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We'll be using filters, as well as quick table calculations(percent of total) for this one.

1) Firstly, let's dragCountryandInstitutionto the Rows shelf, and year (discrete) to the Columns shelf. Then, dragPublicationsto the Text Icon in the Marks Shelf. The following is our view:


Question 2

Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?



Answer : A

Yes, it is very much possible to use measures in the same view multiple times. For example, refer to the image below:

We are usingBOTHtheSumof the revenue and theAVGof the revenue in the same view!


Question 3

Which three statements accurately describe dimensions? Choose three.



Answer : A, B, E

Three statements that accurately describe dimensions are: Contain qualitative values Affect the level of detail in the view Can be continuous or discrete Dimensions are fields that contain qualitative values, such as names, dates, or geographical data. You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view by creating headers or labels for marks or by defining how data is partitioned for table calculations. Dimensions can be continuous or discrete depending on their data type and format. Continuous dimensions are those that have an infinite range of possible values, such as numbers or ratios.Discrete dimensions are those that have a finite number of distinct values, such as names, categories, or dates3The other options are not accurate statements about dimensions. Contain numeric, quantitative values is not correct, because fields that contain numeric, quantitative values are measures, not dimensions. Measures are fields that contain numeric values that you can measure and aggregate. Affect the formatting options in the view is not correct, because formatting options are not determined by dimensions, but rather by user preferences and choices.Formatting options allow you to change the appearance of various elements in the workbook, such as fonts, borders, shading, alignment, etc3


Question 4

Which statement accurately describes a join?



Answer : C

According to the [Tableau Desktop Specialist Exam Guide], a join is a way to combine table columns in relational databases by using shared values. A join can be inner, left, right, or full, depending on how the matching rows are included or excluded.


Question 5

Relationships are represented by __________________ and operate at the ____________________.



Answer : A

From the official documentation:

The default view that you first see in the Data Source page canvas is thelogical layerof the data source. You combine data in the logical layer using relationships (or noodles).


Question 6

Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?

Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?



Answer : C

Since you need BOTH State and the YEAR, we need to use an Inner Join.

Follow the steps below:


Question 7

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



Answer : B

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.


Page:    1 / 14   
Total 317 questions