Salesforce Certified Tableau Data Analyst - Analytics-DA-201 Exam Practice Test
A Data Analyst has the following worksheet in a dashboard that has a hierarchy from Market to Market Size in the view.
A stakeholder wants to see the total sales for each Market/Market Size depending on which hierarchy level is in the view.
Which calculation should the analyst use to get the Market and/or Market Size total?
A stakeholder wants to see the total sales for each Market/Market Size depending on which hierarchy level is in the view.
Which calculation should the analyst use to get the Market and/or Market Size total?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You have the following dataset.
Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?
Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A Data Analyst configures the When Workbook Opens option in the allowable values section when creating a parameter.
What is a user of a workbook able to do?
What is a user of a workbook able to do?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A Data Analyst has the following visualization.
The analyst needs to add totals to the table as shown in the following visualization.
What should the analyst use from Totals on the Analysis menu?
The analyst needs to add totals to the table as shown in the following visualization.
What should the analyst use from Totals on the Analysis menu?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A colleague provides a Data Analyst with access to a folder that has the following files:
* Sales.csv
* Book1.json
* Sales.tds
* Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?
* Sales.csv
* Book1.json
* Sales.tds
* Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?
Correct Answer: B
Vote an answer
A Data Analyst is building a dashboard and wants to allow users to select which measure is being shown on one of the charts.
Which type of action should the analyst use to accomplish this?
Which type of action should the analyst use to accomplish this?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You have the following worksheet.
You want to create a table calculation that shows sales growth over each year.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
You want to create a table calculation that shows sales growth over each year.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Correct Answer:
Explanation:
There are different ways to create a table calculation that shows sales growth over each year, but one possible answer is:
* SUM([Sales])
* LOOKUP(SUM([Sales]), -1)
* PREVIOUS_VALUE(0)
To calculate the sales growth over each year, you need to compare the current year's sales with the previous year's sales and divide the difference by the previous year's sales. You can use the SUM, LOOKUP, and PREVIOUS_VALUE functions to achieve this. The SUM function returns the total sales for each year. The LOOKUP function returns the value of an expression in a target row, specified as a relative offset from the current row. The PREVIOUS_VALUE function returns the value of the expression in the previous row, or a specified value if there is no previous row. The formula for the table calculation is:
(SUM([Sales]) - LOOKUP(SUM([Sales] ), -1)) / PREVIOUS_VALUE(0)
This formula subtracts the sales of the previous year (LOOKUP(SUM([Sales]), -1)) from the sales of the current year (SUM([Sales] )) and divides the result by the sales of the previous year. If there is no previous year, the formula uses 0 as the denominator (PREVIOUS_VALUE(0)) to avoid division by zero errors.
References:
Tableau Certified Data Analyst Exam Prep Guide , page 11, section "Creating Calculated Fields" Tableau Help: SUM Function Tableau Help: LOOKUP Function Tableau Help: PREVIOUS_VALUE Function
When using Tableau Desktop to connect to a published data source on Tableau Cloud or Tableau Server, which data sources will be displayed to the user?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You have the following dataset:
You want to create a parameter to dynamically filter the data to produce the following results.
Which two types of parameters can you use to produce the results? Choose two.
You want to create a parameter to dynamically filter the data to produce the following results.
Which two types of parameters can you use to produce the results? Choose two.
Correct Answer: C,E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).