最新的Salesforce Certified Tableau Data Analyst - Analytics-DA-201免費考試真題
問題1
You have the following chart that shows the cumulative of sales from various dates.
You want the months to appear as shown in the following chart.
What should you do?
You want the months to appear as shown in the following chart.
What should you do?
正確答案: B
說明：（僅 VCESoft 成員可見）
問題2
A Data Analyst needs to analyze the financial performance of the sales team. In order to make the dashboards easier to understand, the analyst needs to format the financial values to show the dollar symbol ($) in front of the value.
How should the analyst enable this formatting across the workbook?
How should the analyst enable this formatting across the workbook?
正確答案: D
問題3
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?
正確答案: C
說明：（僅 VCESoft 成員可見）
問題4
A Data Analyst is the owner of an alert.
The analyst receives an email notification that the alert was suspended.
Where should the analyst go to resume the suspended alert?
The analyst receives an email notification that the alert was suspended.
Where should the analyst go to resume the suspended alert?
正確答案: C
說明：（僅 VCESoft 成員可見）
問題5
In a dataset, a Data Analyst has a string field named Name that contains unnecessary semicolons.
Which function should the analyst use to remove the semicolons from the Name field?
Which function should the analyst use to remove the semicolons from the Name field?
正確答案: B
問題6
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?
正確答案: A
說明：（僅 VCESoft 成員可見）
問題7
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?
正確答案: A
問題8
Which type of visualization interaction can a Data Analyst achieve using set actions?
正確答案: D
說明：（僅 VCESoft 成員可見）
問題9
You have a table that contains the following data.
How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
正確答案:
Explanation:
To complete the formula, you should drag the option MAX from the list of options and drop it into the first blank space, and then drag the option [Sales] and drop it into the second blank space. The formula will look like this: Option (MAX) Option ([Sales] ). This formula will calculate the maximum value of the sales field for each country. You can use this formula to create a calculated field that will show the highest sales amount for each country in your data source. References:
* Create a Simple Calculated Field - Tableau
* MAX Function - Tableau
* Tableau Certified Data Analyst Study Guide
問題10
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?
正確答案: C
問題11
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?
正確答案: B
說明：（僅 VCESoft 成員可見）
問題12
You have a Tableau workbook that has a live data source. The data source connects to a Microsoft SQL Server database. Only the users in your department can access the database.
You plan to publish the workbook to a Tableau Server site named Public. All the users in your company can access Public.
What are two ways to ensure that all the users can view the worksheets in the workbook? Choose two.
You plan to publish the workbook to a Tableau Server site named Public. All the users in your company can access Public.
What are two ways to ensure that all the users can view the worksheets in the workbook? Choose two.
正確答案: A,B
問題13
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.)
正確答案:
問題14
A Data Analyst is creating a map that includes multiple data layers at country, state, and city levels. Users want to customize their map by turning layers on and off as needed.
How should the analyst provide this functionality?
How should the analyst provide this functionality?
正確答案: C
說明：（僅 VCESoft 成員可見）
