Tableau Certified Data Analyst - TDA-C01 Exam Practice Test
A Data Analyst has the following dataset.
The analyst wants to create a parameter to dynamically filter the data to produce the following results based on quantity being above X value.
Which two types of parameters should the analyst use to produce the results? (Choose two)
The analyst wants to create a parameter to dynamically filter the data to produce the following results based on quantity being above X value.
Which two types of parameters should the analyst use to produce the results? (Choose two)
Correct Answer: B,D
You are subscribed to several views.
You need to unsubscribe from the views.
What should you use?
You need to unsubscribe from the views.
What should you use?
Correct Answer: D
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
You have a data source that contains the following columns.
You want to filter regions based on the highest sales. Users must be able to specify the number of regions shown.
Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area.
Use Answer Area arrows to re-order the options.)
You want to filter regions based on the highest sales. Users must be able to specify the number of regions shown.
Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area.
Use Answer Area arrows to re-order the options.)
Correct Answer:
To filter regions based on the highest sales and allow users to specify the number of regions shown, you should perform these actions in order:
Answer area:
* Create an integer data type parameter named Param1.
* Drag Region to the Filters shelf.
* Configure a Top filter by field. Use Param1 and filter by the sum of Sales.
To create a dynamic filter that lets users choose the number of regions to display, you need to use a parameter and a top filter. A parameter is a user-defined variable that can be used in calculations, filters, and reference lines. A top filter is a type of filter that shows only the top or bottom N values based on a specified field or expression.
In this question, you want to filter regions based on the highest sales. You also want users to be able to specify the number of regions shown. To achieve this, you need to follow these steps:
* First, you need to create an integer data type parameter named Param1. This parameter will allow users to enter a number that will determine how many regions to show. You can create a parameter by right- clicking on the Data pane and selecting Create Parameter. Then, you need to specify the name, data type, current value, and allowable values for the parameter. In this case, you can choose Integer as the data type, 10 as the current value, and All as the allowable values. You also need to show the parameter control by right-clicking on the parameter and selecting Show Parameter Control. This will display a slider or a text box where users can enter or adjust the parameter value.
* Next, you need to drag Region to the Filters shelf. This will open the Filter dialog box, where you can choose how to filter the Region field. You can filter by general, wildcard, condition, or top. In this case, you want to filter by top, so you need to select the Top tab.
* Finally, you need to configure a top filter by field. Use Param1 and filter by the sum of Sales. This will filter the Region field by showing only the top N regions based on the sum of Sales, where N is the value of the parameter Param1. You can configure a top filter by field by selecting By field in the Top tab, then choosing the parameter Param1 from the drop-down list, and selecting the aggregation function Sum and the field Sales from the other drop-down lists. This will create a filter expression that looks like this: Top Param1 by SUM(Sales).
By following these steps, you will create a filter that shows only the regions with the highest sales, and allows users to change the number of regions shown by adjusting the parameter value.
References:
Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Filtering Data" Tableau Help: Parameters Tableau Help: Top Filters
Answer area:
* Create an integer data type parameter named Param1.
* Drag Region to the Filters shelf.
* Configure a Top filter by field. Use Param1 and filter by the sum of Sales.
To create a dynamic filter that lets users choose the number of regions to display, you need to use a parameter and a top filter. A parameter is a user-defined variable that can be used in calculations, filters, and reference lines. A top filter is a type of filter that shows only the top or bottom N values based on a specified field or expression.
In this question, you want to filter regions based on the highest sales. You also want users to be able to specify the number of regions shown. To achieve this, you need to follow these steps:
* First, you need to create an integer data type parameter named Param1. This parameter will allow users to enter a number that will determine how many regions to show. You can create a parameter by right- clicking on the Data pane and selecting Create Parameter. Then, you need to specify the name, data type, current value, and allowable values for the parameter. In this case, you can choose Integer as the data type, 10 as the current value, and All as the allowable values. You also need to show the parameter control by right-clicking on the parameter and selecting Show Parameter Control. This will display a slider or a text box where users can enter or adjust the parameter value.
* Next, you need to drag Region to the Filters shelf. This will open the Filter dialog box, where you can choose how to filter the Region field. You can filter by general, wildcard, condition, or top. In this case, you want to filter by top, so you need to select the Top tab.
* Finally, you need to configure a top filter by field. Use Param1 and filter by the sum of Sales. This will filter the Region field by showing only the top N regions based on the sum of Sales, where N is the value of the parameter Param1. You can configure a top filter by field by selecting By field in the Top tab, then choosing the parameter Param1 from the drop-down list, and selecting the aggregation function Sum and the field Sales from the other drop-down lists. This will create a filter expression that looks like this: Top Param1 by SUM(Sales).
By following these steps, you will create a filter that shows only the regions with the highest sales, and allows users to change the number of regions shown by adjusting the parameter value.
References:
Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Filtering Data" Tableau Help: Parameters Tableau Help: Top Filters
The following table displays the row-level data in a Tableau data source:
A Data Analyst creates this calculated field:
SUM(IF [Item] = 'A' THEN [Sales] END) / COUNT([Order ID])
What is the result of this aggregate calculation?
A Data Analyst creates this calculated field:
SUM(IF [Item] = 'A' THEN [Sales] END) / COUNT([Order ID])
What is the result of this aggregate calculation?
Correct Answer: B
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]
You publish a dashboard that uses an extract. The extract refreshes every Monday at 10:00.
You need to ensure that the extract also refreshes on the last day of the month at 18:00.
What should you do?
You need to ensure that the extract also refreshes on the last day of the month at 18:00.
What should you do?
Correct Answer: C
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.
Create a histogram on the Quantity field by using bin size of 3.
Correct Answer:
check the steps below in explanation.
Explanation:
To create a histogram on the Quantity field by using bin size of 3, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
* Click on the Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.
* Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.
* Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.
* Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a
# sign next to it.
* Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.
* Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.
References: https://help.tableau.com/current/pro/desktop/en-us/histograms.htm https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm https://help.tableau.com/current/pro/desktop/en-us/buildmanual_histograms.htm
Explanation:
To create a histogram on the Quantity field by using bin size of 3, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
* Click on the Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.
* Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.
* Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.
* Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a
# sign next to it.
* Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.
* Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.
References: https://help.tableau.com/current/pro/desktop/en-us/histograms.htm https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm https://help.tableau.com/current/pro/desktop/en-us/buildmanual_histograms.htm
You have the following dataset.
Which grouping option should you use m Tableau Prep to group al five names automatically?
Which grouping option should you use m Tableau Prep to group al five names automatically?
Correct Answer: B
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
You have the following primary data source that contains a dimension named Dorm_Code.
You receive the following secondary data source that contains updated dorm codes.
You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.
What should you do?
You receive the following secondary data source that contains updated dorm codes.
You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.
What should you do?
Correct Answer: A
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
You have a workbook that connects to a database. The database requires authentication.
You plan to publish the workbook and schedule a daily refresh of the data.
Which two conditions must be met to schedule the refresh? Choose two.
You plan to publish the workbook and schedule a daily refresh of the data.
Which two conditions must be met to schedule the refresh? Choose two.
Correct Answer: A,C
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
You have the following dashboard.
When a user selects a only on the map the data on the bar chart must show only the data for the selected city.
The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)
When a user selects a only on the map the data on the bar chart must show only the data for the selected city.
The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)
Correct Answer:
Explanation:
To configure the dashboard action, you should select Filter as the action type, Select as the run action on option, and All Fields as the target filters option. This will ensure that when a user selects a city on the map, the bar chart will show only the data for the selected city based on all fields in common between the two worksheets. The action will run only when the user selects a different city. References: https://help.tableau.
com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_filter.htm
You have the following dataset.
Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?
Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?
Correct Answer: D
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
A colleague provides a Data Analyst with access to a folder that contains the following files:
Sales.csv
Book1.twb
Sales.hyper
Export.mdb
Which file is a Tableau extract?
Sales.csv
Book1.twb
Sales.hyper
Export.mdb
Which file is a Tableau extract?
Correct Answer: A
A Data Analyst is using containers on a dashboard.
How should the analyst make sure multiple objects within a container are always taking up the same width or height, even if the container is resized?
How should the analyst make sure multiple objects within a container are always taking up the same width or height, even if the container is resized?
Correct Answer: C