Tableau TDS-C01 Online Practice Questions and Exam Preparation

Tableau TDS-C01 Online Questions & Answers

• Question 61:

  When using a data source that has relationships, how can you add a join between two or more tables?

  A. Double-click a logical table in the canvas
  B. From the Tables pane, drag a table directly on top of an existing logical table
  C. From the Tables pane, double-click a table
  D. From the Connections pane, select Add
  A. Double-click a logical table in the canvas

• Question 62:

  Which of the following situations describe the best reason to use a union?

  A. You have two tables with similarly named columns of data that you want to combine.
  B. You have two data sets with similar data types for which you want to find only distinct values.
  C. You have two tables with differently named columns of data that you want to combine.
  D. You have two data sets saved in different formats that you want to unify into a single format.
  A. You have two tables with similarly named columns of data that you want to combine.

• Question 63:

  _________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

  A. .twb files
  B. .tbm files
  C. .twbx files
  D. .tde files
  D. .tde files

  ---

  Explanation/Reference:

  According to the official Tableau documentation:

  Depending on the version the extract was created in, Tableau extract files can have either the .hyper or .tde file extension. Extract files are a local copy of a subset or entire data set that you can use to share data with others, when you need

  to work offline, and improve performance. For more information, see Extract Your Data.

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

• Question 64:

  What is a valid use case for a bar chart?

  A. To compare measures across categories at a glance
  B. To see relationships between measures
  C. To see individual data points while also viewing associated categories
  D. To compare multiple dimensions over an extended period
  A. To compare measures across categories at a glance

• Question 65:

  Which of the following is NOT a valid official data source in Tableau Desktop?

  A. PostgreSQL
  B. SAP HANA
  C. Google Firebase
  D. Amazon Redshift
  C. Google Firebase

  ---

  Explanation/Reference:

  Presently, there is no official way to connect your data in Firebase directly with Tableau Desktop.

  A workaround however can be to export your Firebase data into Google BigQuery, and then connect it to Tableau Desktop.

  But then again, it is a workaround and not an official out-of-the-box solution.

  The following are the available Data sources available as of now:

  1) Server

  

  2) File

  

• Question 66:

  Which of the following are true about dimensions?

  A. They contain contain numeric, quantitative values
  B. They contain qualitative values (such as names, dates, or geographical data)
  C. They affect the level of detail in the view
  D. Dates are mostly placed in dimensions by default for relational data sources
  B. They contain qualitative values (such as names, dates, or geographical data)
  C. They affect the level of detail in the view
  D. Dates are mostly placed in dimensions by default for relational data sources

  ---

  Explanation/Reference:

  

  

  Measures contain numeric quantitative values hence that option is incorrect.

  Reference 1: https://help.tableau.com/current/pro/desktop/en-us/datafields_typesandroles.htm Reference 2: https://help.tableau.com/current/pro/desktop/en-us/dates.htm

• Question 67:

  Which two actions can you perform when you join tables from multiple connections? (Choose two.)

  A. Add a data source filter
  B. Create a union
  C. Use a stored procedure
  D. Create an extract
  A. Add a data source filter
  D. Create an extract

• Question 68:

  How can you change the default Tableau repository location?

  A. By clicking on Window-> Repository Location
  B. By clicking on Help-> Change Repository Location
  C. By clicking on File-> Repository Location and choosing a new location
  D. By Moving the repository location manually to wherever we want
  C. By clicking on File-> Repository Location and choosing a new location

  ---

  Explanation/Reference:

  According to the official Tableau documentation:

  

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

• Question 69:

  By default, what does Tableau do when you connect to a data source?

  A. Creates an extract of the data
  B. Creates a live connection to the data
  C. Loads your actual file into Tableau
  D. Sorts the data in descending order
  B. Creates a live connection to the data

  ---

  Explanation/Reference:

  Before you can build a view and analyze your data, you must first connect Tableau to your data. Tableau supports connecting to a wide variety of data, stored in a variety of places.

  By default, when you connect a data source to Tableau, Tableau will create a live connection to the data.

  Live connection refers to a data source that contains direct connection to underlying data, which provides real-time or near real-time data. With a live connection, Tableau makes queries directly against the database or other source, and

  returns the results of the query for use in a workbook. Users can create live connections and then share them on Tableau Server so that other Tableau users can use the same data using the same connection and filtering settings.

  Reference: https://help.tableau.com/current/guides/everybody-install/en-us/everybody_admin_data.htm

• Question 70:

  Which two functionalities can you provide to consumers by adding a parameter to a visualization? (Choose two.)

  A. Change fields in the visualization.
  B. Download the underlying data as a CSV file.
  C. Change the results of calculations in the visualization.
  D. Create a new field in the data source.
  A. Change fields in the visualization.
  C. Change the results of calculations in the visualization.