Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 31:

  True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  In fact, the opposite of this is true.

  Trick : Whenever you think of joins-> Think that after the join is created, we get 1 single flat combined (joined) table. This flat combined table is created prior to us creating our visualizations. This happens at the physical layer. If you ever think about relationships, know that all tables will remain distinct and separate, and relationships sit at the logical layer. At run time, when you bring in the dimensions and measures to create your viz, Tableau very smartly creates the necessary joins, relates the tables and sends queries to these tables to get the resultant data back in the most meaningful way possible. This allows you to focus on using your data and revealing insights from it and focus less on the data preparation aspect!

  Refer to logical layer vs physical layer from the official documentation: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm

• Question 32:

  The default path for all supporting files, data sources, icons, logs etc is in ______________________

  A. Documents-> Tableau Files
  B. Documents-> Tableau
  C. Documents-> My Tableau Repository
  D. Downloads-> Tableau Support Files
  C. Documents-> My Tableau Repository

  ---

  Explanation/Reference:

  By default, all of the above mentioned are stored in Documents-> My Tableau Repository Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm

• Question 33:

  When altering the data type of a field, what are two available data type options? (Choose two.)

  A. Scientific
  B. Date
  C. Vector
  D. Number (decimal)
  B. Date
  D. Number (decimal)

• Question 34:

  You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy this requirement?

  A. Save it as a .twm file
  B. Save it as a .twb file
  C. Save it as a .tds file
  D. Save it as a .twbx file
  C. Save it as a .tds file

  ---

  Explanation/Reference:

  After making changes to Data, we can save that new data source as a .tds file. To do so, go to data menu on top and then choose your current connected data source. Then next click on Add to Saved Data sources. This will save all calculated fields, changes to fields etc. It will be saved in My Tableau Repository-> Mydatasources. This will then also appear on Tableau Home Page under saved data sources like SampleSuperStore. Note: Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.

  twb and .twbx are not the BEST solutions since the questions nowhere mentions that we need to store our workbooks as well. twm is a bookmark which contains a single worksheet and are an easy way to quickly share your work.

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

• Question 35:

  ________________ can only create header. _______________ will create header and axis both.

  A. Dimensions, Measures
  B. Measures, Dimensions
  C. Groups, Sets
  D. Dates, Strings
  A. Dimensions, Measures

  ---

  Explanation/Reference:

  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. Reference: https://help.tableau.com/current/pro/desktop/en-us/view_parts.htm

  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.

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

• Question 36:

  True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  Joins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin.

  

  Inner join

  

  Left Join

  Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.

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

• Question 37:

  Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a ____________ and a ____________.

  A. role, type
  B. Data type, Value
  C. type, role
  D. dimension, measure
  A. role, type
  B. Data type, Value
  D. dimension, measure

• Question 38:

  Which of the following is not a Trend Line Model?

  A. Linear Trend Line
  B. Exponential Trend Line
  C. binomial Trend Line
  D. Logarithmic Trend Line
  C. binomial Trend Line

  ---

  Explanation/Reference:

  According to the official Tableau documentation, there are 5 types of trend lines which we can work with in Tableau : 1) Linear Trend Line 2) Logarithmic Trend Line 3) Exponential Trend Line 4) Polynomial Trend Line 5) Power Model

  Hence, the correct answer is BINOMIAL trend line which is not present in Tableau. See the following image: For more information, refer to: https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm

  

• Question 39:

  Which of the following are valid ways to italicize Tooltip content in Tableau?

  A. Click on Format in the Menu bar, choose Font, and then edit the Tooltip options to italicize the font
  B. Click on Tooltip in the Marks card, select the text, and then use the Italics option
  C. Click on Worksheet in the Menu bar, select Tooltip, and then use the italics option
  D. Click on Dashboard in the Menu bar, select Tooltip, and then use the italics option
  A. Click on Format in the Menu bar, choose Font, and then edit the Tooltip options to italicize the font
  B. Click on Tooltip in the Marks card, select the text, and then use the Italics option
  C. Click on Worksheet in the Menu bar, select Tooltip, and then use the italics option

  ---

  Explanation/Reference:

  The only incorrect option is-Click on Dashboard in the Menu bar, select Tooltip, and then use the italics option. This option doesn't exist. See below:

  

  The rest of the options do exist, and therefore are correct:

  

  

  

• Question 40:

  Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser?

  A. YES, we can do this with the help of a plugin
  B. NO, this is not currently possible in Tableau
  C. YES, we can do this with the help of a Web-Page object
  D. YES, we can do this with the help of Tableau Public
  C. YES, we can do this with the help of a Web-Page object

  ---

  Explanation/Reference:

  To interactively display information from the web INSIDE a dashboard, you can use a URL action with a web page object.

  For example, you might have a dashboard that shows profits by country. In addition to showing the profit data in your dashboard, you also want to display supplemental information about the countries from a web site.

  

  

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