最新的Salesforce Certified Tableau Data Analyst - Analytics-DA-201免費考試真題
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.
正確答案: B,C
說明：（僅 Fast2test 成員可見）
You company has two divisions located in the United States and Germany Bach division has a separate database. The following is a sample of the sales data for the division in the United States.
The following is a sample of the sales data for me division in Germany.
You have population data in a file named Populatio.csv. the following is a sample of the data.
You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.
You need to prepare the data to support the planned visualization. The data source must support being published .
Which four actions should you perform in order?
(Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options.
Use Answer Area arrows to re-order the options)
The following is a sample of the sales data for me division in Germany.
You have population data in a file named Populatio.csv. the following is a sample of the data.
You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.
You need to prepare the data to support the planned visualization. The data source must support being published .
Which four actions should you perform in order?
(Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options.
Use Answer Area arrows to re-order the options)
正確答案:
Explanation:
1) Open Tableau prep
2) Create a new column ...
3) Union the sales ...
4) Join the sales ...
References: https://help.tableau.com/current/prep/en-us/prep_get_started.htm https://help.tableau.com/current
/prep/en-us/prep_union.htm https://help.tableau.com/current/prep/en-us/prep_clean.htm https://help.tableau.
com/current/prep/en-us/prep_join.htm
A Data Analyst would like to receive the draft results of a colleague's Tableau Prep flow to start work on a dashboard before it has been published.
What should the analyst do to accomplish this?
What should the analyst do to accomplish this?
正確答案: D
When a Data Analyst needs to format workbook settings, which options are available in the Format Workbook panel?
正確答案: C
You have the following dataset.
Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?
Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?
正確答案:
Explanation:
To calculate the ranking shown in the Rank field, you need to use the RANK_UNIQUE function, which returns the unique rank of each value in a partition. You need to specify the expression as SUM([Sales]), which calculates the total sales for each product. You also need to specify the order as descending, which means that the highest sales will have the lowest rank. Finally, you need to specify the restart as every
[Category], which means that the ranking will reset for each category. References: https://help.tableau.com
/current/pro/desktop/en-us/functions_functions_tablecalculation.htm https://help.tableau.com/current/pro
/desktop/en-us/calculations_calculatedfields_lod_rank.htm
in which three formats can you export a worksheet from the Worksheet menu? Choose three
正確答案: A,B,F
說明：（僅 Fast2test 成員可見）
You are creating an annual report in Microsoft Word.
In Tableau Desktop, you build a chart in a worksheet.
You want to create an image of the chart that you can add to the annual report.
What are two ways to create the image? Choose two.
In Tableau Desktop, you build a chart in a worksheet.
You want to create an image of the chart that you can add to the annual report.
What are two ways to create the image? Choose two.
正確答案: C,D
說明：（僅 Fast2test 成員可見）
You have a dataset that contains people and the awards they have won.
Which formula should you use to get the number of different types of awards that have been won?
Which formula should you use to get the number of different types of awards that have been won?
正確答案: C
說明：（僅 Fast2test 成員可見）
A Data Analyst needs to calculate the first Tuesday of each month in the data.
Which set of functions should the analyst use to perform this calculation?
Which set of functions should the analyst use to perform this calculation?
正確答案: B
You have a dashboard that contains confidential information about patients health. The data needs to always be up to date tor a team of healthcare workers How should you share me dashboard with the healthcare workers?
正確答案: D
說明：（僅 Fast2test 成員可見）
You have a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.
The following is a sample of the data.
You want to improve the performance of the views by including only animals of a particular type.
To which filter should you add the Type field on the worksheet?
The following is a sample of the data.
You want to improve the performance of the views by including only animals of a particular type.
To which filter should you add the Type field on the worksheet?
正確答案: D
A Data Analyst is given the following table and asked to create a flow that adds a date field to the data. This field should automatically update as new dates (months) are added to the original table.
Which technique should the analyst use as the first step to achieve this in Tableau Prep?
Which technique should the analyst use as the first step to achieve this in Tableau Prep?
正確答案: B
You have the following dataset.
When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.
What should you do?
When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.
What should you do?
正確答案: A
說明：（僅 Fast2test 成員可見）