Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 141:

  If you see the following Filter, then you're working with _______________________ Larger image

  

  A. Grouped Dates
  B. Date Functions
  C. Date Parts
  D. Date Values
  D. Date Values

  ---

  Explanation/Reference:

  Dates in Tableau will behave differently depending on whether they are a Datepart (blue) or a Datevalue (green). This affects how the axes display/behave and also how visualisations such as line charts will display. The difference essentially boils down to Dateparts behaving like a dimension as opposed to a measure which is how Datevalues behave. This means that Dateparts behave like discrete categories on the view whereas Datevalues are more like continuous numeric values.

  Dateparts are discrete and they behave the same as dimension filters. If all dates are used on the filter then each individual date will be a datepart that can be selected/excluded. This is the same for each level of date, if datepart months is placed on filters January to December will be tick-able options in the filter. This also means that conditions and top/bottom filters can be applied to datepart filters like any other dimension filter. Datevalues placed on filters behave like measure filters. A min and a max date can be set and there is a relative dates option which allows you to choose things like only show the previous 3 months or years etc.

  

  Reference: https://www.thedataschool.co.uk/harry-cooney/tableau-dateparts-vs-datevalues/

• Question 142:

  Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.

  A. .tds
  B. .tdex
  C. .hyper
  D. .twbx
  C. .hyper

  ---

  Explanation/Reference:

  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.

  Reference: https://help.tableau.com/current/pro/desktop/en-us/extracting_upgrade.htm

• Question 143:

  When viewing quick table calculations, such as Percent Difference from, that use a value in the previous column, what will be the first data value in the visualization?

  A. Zero (0)
  B. Null
  C. Duplicated from the nearest column
  D. The current value
  B. Null

  ---

  Explanation/Reference:

  https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_definebasic_runningtotal.htm

• Question 144:

  Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf. Which of the following would create a stacked bar chart?

  A. By dragging another dimension to the Rows shelf
  B. By dragging another measure to Color on the Marks card
  C. By dragging another dimension to Color on the Marks card
  D. By dragging another measure to the Columns shelf
  C. By dragging another dimension to Color on the Marks card

  ---

  Explanation/Reference:

  Very important question for the exam and appears quite a lot too.

  The correct answer is-By dragging another dimension to Color on the Marks card.

  

  Chart, bar chart

  This is what the question says we have already created. Now to convert this into a Stacked bar chart, we will drop another dimension on Color in the Marks card.

  

  Chart, bar chart

  The rest won't create stacked bar charts, and hence are incorrect choices. The best way to answer such questions on the real exam is to quickly do what the options say and see if they satisfy the requirements in the question.

• Question 145:

  By default, measures placed in a view are aggregated. The type of aggregation applied ______________

  A. is always sum
  B. depends on the context of the view
  C. is always COUNT
  D. is always AVERAGE
  B. depends on the context of the view

  ---

  Explanation/Reference:

  By default, measures placed in a view are aggregated. Mostly you'll notice that the aggregation is SUM, but not ALWAYS.

  The type of aggregation applied varies depending on the context of the view.

  Reference: https://help.tableau.com/current/pro/desktop/en-us/calculations_aggregation.htm

• Question 146:

  What allows you to drill up or down in the level of detail (LOD)?

  A. Sets
  B. Bins
  C. Groups
  D. Hierarchies
  D. Hierarchies

• Question 147:

  You are creating a combined axis chart.

  Where should you drag the second measure after dragging the first measure to the Rows shelf?

  A. The Marks card
  B. The Filter card
  C. The horizontal axis in the view
  D. The vertical axis in the view
  D. The vertical axis in the view

  ---

  Explanation/Reference:

  https://help.tableau.com/current/pro/desktop/en-us/qs_combo_charts.htm check the last screen shot the two metrics are on the vertical axis

• Question 148:

  When using Animations in a Tableau, which of the following is the default duration for animations?

  A. 0.4s
  B. 0.3s
  C. 0.5s
  D. 0.2s
  B. 0.3s

  ---

  Explanation/Reference:

  The LATEST Tableau Desktop Sepcialist exam blueprint now requires you to know some basics about animations as well! NOTE: Animations are DISABLED by default and must be manually enabled.

  

  You can also reset all settings to default by clickin on 'Reset All'

  

  Reference: https://help.tableau.com/current/pro/desktop/en-us/formatting_animations.htm

• Question 149:

  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 Reader
  B. Tableau Online
  C. Tableau Server
  D. Tableau Desktop
  A. Tableau Reader

  ---

  Explanation/Reference:

  The word 'static tool' gives it away. According to the official website :

  

  Reference: https://help.tableau.com/current/reader/desktop/en-us/reader_welcome.htm

• Question 150:

  Relationships are represented by __________________ and operate at the ____________________.

  A. noodles, logical layer
  B. noodles, physical layer
  C. Venn diagrams, physical layer
  D. Venn diagrams, logical layer
  A. noodles, logical layer

  ---

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

  

  Reference: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm