Free Tableau TDA-C01 Practice Test & Real Exam Questions
When using a Show/Hide button in Tableau, what happens if the object is in a Tiled layout container?
Correct Answer: A
Vote an answer
You connect to a database server by using Tableau Prep. The database server has a data role named Role1.
You have the following field in the data.
You need to apply the Role1 data role to the Material field.
Which two actions should you perform? Choose two.
You have the following field in the data.
You need to apply the Role1 data role to the Material field.
Which two actions should you perform? Choose two.
Correct Answer: A,D
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?
What should you do from Tableau Desktop?
Correct Answer: B
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
A Data Analyst has a website that displays data in a table format.
The analyst wants to connect to the data of the website by using the least amount of effort.
What should the analyst use to connect to the data?
The analyst wants to connect to the data of the website by using the least amount of effort.
What should the analyst use to connect to the data?
Correct Answer: B
Vote an answer
You have the following box plot that shows the distribution of average profits made in every state by region.
Which region has the smallest distribution of profits?
Which region has the smallest distribution of profits?
Correct Answer: B
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You have the following calculated fields in a worksheet.
[Calc1] = DATEADD ('year', -1, TODAY ())
[Calc2] = DATETRUNC ( 'month' , DATEADD ('year', -1, TODAY ())
You want to calculate the month to date value of the prior year.
How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
[Calc1] = DATEADD ('year', -1, TODAY ())
[Calc2] = DATETRUNC ( 'month' , DATEADD ('year', -1, TODAY ())
You want to calculate the month to date value of the prior year.
How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
Correct Answer:
To calculate the month to date value of the prior year, you need to filter the order date to be between the first day of the same month of the previous year and the same day of the previous year. You can use the calculated fields [Calc1] and [Calc2] to get these dates. [Calc1] returns the date that is one year before today, and
[Calc2] returns the date that is the first day of the month of [Calc1]. By using these fields in the filter condition, you can get the desired result.
References:
Finding the Month-to-Date Values for the Prior Year
[DATEADD Function]
[DATETRUNC Function]
[Calc2] returns the date that is the first day of the month of [Calc1]. By using these fields in the filter condition, you can get the desired result.
References:
Finding the Month-to-Date Values for the Prior Year
[DATEADD Function]
[DATETRUNC Function]
A Data Analyst has the following chart that shows the sum of sales made in different cities.
The analyst wants to show the average sale amount for a city when users hover their mouse over any of the bars.
What should the analyst do?
The analyst wants to show the average sale amount for a city when users hover their mouse over any of the bars.
What should the analyst do?
Correct Answer: B
Vote an answer
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the Top 10 NOC based on the number of medals won.
Filter the table to show the Top 10 NOC based on the number of medals won.
Correct Answer:
check the steps below in explanation.
Explanation:
To filter the table to show the Top 10 NOC based on the number of medals won, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Disciplines worksheet.
* Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the NOC, discipline, and medals for each country.
* Drag Medals from the Measures pane to the Filters shelf. This will open a dialog box that allows you to filter by different criteria.
* Select Top from the dialog box. This will show you options to filter by the top or bottom values of a field.
* Enter 10 in the text box next to By field. This will filter by the top 10 values of Medals.
* Select NOC from the drop-down list next to By field. This will filter by the top 10 values of NOC based on Medals.
* Click OK to apply the filter. You will see that the table now shows only 10 rows, one for each NOC with the highest number of medals.
References: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current
/pro/desktop/en-us/filtering_topn.htm
Explanation:
To filter the table to show the Top 10 NOC based on the number of medals won, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Disciplines worksheet.
* Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the NOC, discipline, and medals for each country.
* Drag Medals from the Measures pane to the Filters shelf. This will open a dialog box that allows you to filter by different criteria.
* Select Top from the dialog box. This will show you options to filter by the top or bottom values of a field.
* Enter 10 in the text box next to By field. This will filter by the top 10 values of Medals.
* Select NOC from the drop-down list next to By field. This will filter by the top 10 values of NOC based on Medals.
* Click OK to apply the filter. You will see that the table now shows only 10 rows, one for each NOC with the highest number of medals.
References: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current
/pro/desktop/en-us/filtering_topn.htm
