Salesforce Certified Tableau Data Analyst - Analytics-DA-201 FREE EXAM DUMPS QUESTIONS & ANSWERS
You have the Mowing two tables that contains data about the books in a library.
Both tables are incomplete so there are books missing from the tables.
You need to combine the tables. The solution must ensure that all the data is retained Which type of join should you use?
Both tables are incomplete so there are books missing from the tables.
You need to combine the tables. The solution must ensure that all the data is retained Which type of join should you use?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
A Data Analyst has a data source that contains data for every city in the United States. The following is a sample of the data.
The analyst needs to use the City dimension to create a dynamic filter that shows the cities that have a population greater than 1 million.
Which type of filter should the analyst use?
The analyst needs to use the City dimension to create a dynamic filter that shows the cities that have a population greater than 1 million.
Which type of filter should the analyst use?
Correct Answer: C
Vote an answer
In a worksheet, you have a calculated column named YTD Sales that uses the following formula.
[Order Date] < = TODAY () AND DATETBUNC {"year", [Order Dace]) = DATETPUNC) " year " , TODAY(J) You want to create a calculated column named Exclude Current Month that will be dragged to the Filters shell. Exclude Current Month will exclude the current month values from YTD Sales.
How should you complete the formula for Exclude Current Month? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
[Order Date] < = TODAY () AND DATETBUNC {"year", [Order Dace]) = DATETPUNC) " year " , TODAY(J) You want to create a calculated column named Exclude Current Month that will be dragged to the Filters shell. Exclude Current Month will exclude the current month values from YTD Sales.
How should you complete the formula for Exclude Current Month? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
Correct Answer:
You have the following view.
You want to filter the view lo show only records that have a movie name starting with the word. " The " . You must achieve the goal without writing any formulas.
Which type of filter should you use?
You want to filter the view lo show only records that have a movie name starting with the word. " The " . You must achieve the goal without writing any formulas.
Which type of filter should you use?
Correct Answer: C
Vote an answer
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:
Explanation:
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
You have the following chart that sorts states by the number of products each state has purchased.
Which formula should you use to include a number with the position of each state within each region?
Which formula should you use to include a number with the position of each state within each region?
Correct Answer: B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You have a dataset that contains sates data. The following is a sample of the data.
You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.
Which two formulas achieve the goal Choose two
You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.
Which two formulas achieve the goal Choose two
Correct Answer: B,D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You have the following two datasets:
* A Microsoft Excel worksheet that has two columns named Employee Name and Department
* A Microsoft SQL Server table that has three columns named Employee Name. Pay Grade and Team Size.
You want to use Tableau Prep to join the two datasets.
Which three actions should you perform in order? (Place the three correct options in order.)
* A Microsoft Excel worksheet that has two columns named Employee Name and Department
* A Microsoft SQL Server table that has three columns named Employee Name. Pay Grade and Team Size.
You want to use Tableau Prep to join the two datasets.
Which three actions should you perform in order? (Place the three correct options in order.)
Correct Answer:
Explanation:
The correct order of the three actions is:
* From the connections pane, connect to both data sources
* Join both datasets and select the join type
* Specify Employee Name as the join key
The first action is to connect to both data sources from the connections pane in Tableau Prep. The connections pane is where you can access and add data sources to your flow. You can connect to various types of data sources, such as Excel, SQL Server, or Tableau Server. In this case, you want to connect to an Excel worksheet and a SQL Server table.
The second action is to join both datasets and select the join type. A join is a way of combining data from two or more tables based on a common field. You can join datasets by dragging one table to the canvas and dropping it on top of another table. This will create a join step in your flow. You can select the join type from the drop-down list on the join step. The join type determines which rows are returned from the tables.
The third action is to specify Employee Name as the join key. A join key is a field that is used to match rows from different tables. You can specify the join key by clicking on the field name in each table and dragging it to the center of the join step. This will create a join clause that shows the field name and the operator. In this case, you want to use Employee Name as the join key, because it is a common field between the two datasets.
The other options are not relevant for this scenario. Specifying Department and Team Size as a join condition will not work, because they are not common fields between the two datasets. Opening both data sources in Tableau Desktop will not help you join them in Tableau Prep. Adding a step to aggregate the data in the SQL Server table will not affect the join, but it may change the level of detail of your data. References: https://help.
tableau.com/current/prep/en-us/prep_connect.htm https://help.tableau. com/current/prep/en-us/prep_join.htm
https://help.tableau.com/current/prep/en-us/prep_join_types.htm
You have a data source that contains 20 tables.
You want the tables to be organized within the Data pane based on the type of data contained within the tables.
What should you use?
You want the tables to be organized within the Data pane based on the type of data contained within the tables.
What should you use?
Correct Answer: C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
A Data Analyst needs to update an existing dashboard. The current dashboard shows financial results data, and users have asked for a comparison of budgets to be added to the dashboard. A new data source has been created that includes both the actual costs and budgets and was published to the corporate Tableau site.
How should the analyst update the existing dashboard?
How should the analyst update the existing dashboard?
Correct Answer: C
Vote an answer
Which function should a Data Analyst use to average sales at a less-granular level of detail than is in the view?
Correct Answer: A
Vote an answer
You want to create the following table in a view.
Which function should you use to create the Position column?
Which function should you use to create the Position column?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).