2026年最新の保証された成功できるAnalytics-DA-201問題集でSalesforceのPDF問題
格別な練習Salesforce Certified Tableau Data Analyst問題集で最速合格させます
Salesforce Analytics-DA-201 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
質問 # 88 
How are the colors configured for the map?
- A. A diverging color palette that has five stepped colors
- B. A sequential color gradient
- C. A diverging color palette that has six stepped colors
- D. A single color gradient
正解：A
質問 # 89
You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future Which three actions should you perform m order?
(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)
正解：
解説：
Explanation:
The correct order of the three actions is:
* Add the date to the Columns shelf. Add the segment and the sales to the Rows shelf.
* Aggregate the date to month and year.
* From the Analytics pane, drag Forecast to the worksheet.
The first action is to add the date to the Columns shelf and the segment and the sales to the Rows shelf. This will create a line chart that shows the daily sales by segment over time. You can use the Show Me menu to choose a line chart if it is not selected by default.
The second action is to aggregate the date to month and year. This will group the daily sales into monthly sales and show the yearly trend. You can right-click on the date field on the Columns shelf and select Month (January 2017) from the menu. You can also drag Year from the Dimensions pane to the Columns shelf before or after Month.
The third action is to drag Forecast from the Analytics pane to the worksheet. This will add a forecast that predicts future sales by segment based on historical trends. You can customize the forecast by clicking on it and using the options on the Marks card.
The other options are not relevant for this scenario. Adding a trend line would show a linear or nonlinear relationship between two measures, but not a prediction of future values. Creating a calculated field that uses the model quantile function would return a value from a statistical model based on a given quantile, but not a forecast.
References: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current
/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/dates.htm
https://help.tableau.com/current/pro/desktop/en-us/analytics_forecast.htm https://help.tableau.com/current/pro
/desktop/en-us/functions_functions_statistical.htm#MODEL_QUANTILE
質問 # 90
You have a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.
You want to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do NOT match any values in Table2. The field values from Table2 must appear as null values.
Which type of join should you use?
- A. Left
- B. Inner
- C. Union
- D. Full outer
- E. Left only
正解：E
解説：
To combine the tables by using Tableau Prep and include only values from Table1 that do not match any values in Table2, you should use a left only join. A left only join is a type of join that returns only the rows from the primary table (Table1) that have no matching rows in the secondary table (Table2). The field values from Table2 will appear as null values in the combined table. A left only join is also known as an anti-join or an exclusion join. References:
* Tableau Certified Data Analyst Exam Prep Guide, page 9, section "Preparing Data"
* Tableau Help: Join Your Data
* Tableau Help: Left Only Join
質問 # 91
in which three formats can you export a worksheet from the Worksheet menu? Choose three
- A. .html
- B. .png
- C. .pptx
- D. .csv
- E. .xlsx
- F. .txt
正解：B、C、E
解説：
Tableau provides various options to export data from a worksheet. The formats available are typically those that are best suited for visualization or further data analysis. The options include:
* .png for exporting images of the visualizations
* .xlsx for exporting data in a format that can be opened with Microsoft Excel
* .pptx for creating PowerPoint presentations with the visualization embedded These formats are designed to facilitate sharing and presenting the insights derived from Tableau visualizations, or for conducting further analysis in tools like Excel.
質問 # 92
You have the following visualization.
You Create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards.
What is the Rank Score value for Student ID 4220?
- A. 0
- B. 1
- C. 2
- D. 3
正解：D
解説：
To determine the Rank Score value for Student ID 4220, we look at the visualization provided and apply the table calculation of RANK(AVG([Score])). This function will rank the average scores in ascending order by default, with the lowest score receiving the rank of 1.
Based on the provided visualization, the scores for the students are as follows (from lowest to highest average score):
* Student ID 4183: 39 (Rank 1)
* Student ID 4220: 71 (Rank 6)
* Student ID 4247: 71 (Rank 6, same score as ID 4220 so they share the same rank)
* Student ID 4124: 75.5
* Student ID 4050: 64
* Student ID 4205: 67
* Student ID 4056: 66
Since Student ID 4220 has an average score of 71, which is the third-highest score, it shares the rank with Student ID 4247. However, since Tableau ranks without gaps, the actual rank assigned is 6, considering that there are two students with a rank of 4 (due to the same average score being the second lowest), making the next rank number 6.
Note: The actual ranks for the highest scores are not provided, but they are not needed to determine the rank for Student ID 4220.
https://help.tableau.com/current/prep/en-us/prep_calculations.htm
質問 # 93
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?
- A. Convert the date to Attribute
- B. Convert the date to Exact Date
- C. Select Show Misting Values for the dale
- D. Convert the date to Continuous
正解：D
解説：
References: https://help.tableau.com/current/pro/desktop/en-us/dates.htm https://help.tableau.com/current/pro
/desktop/en-us/dates_continuous.htm https://help.tableau.com/current/pro/desktop/en-us/formatting.htm To ensure the dates are shown in a continuous axis, you should convert the date to a continuous field. This will display the months in a sequence without any breaks, which is needed for showing a trend over time like the cumulative sum of sales.
質問 # 94
A Data Analyst has a workbook that uses an extracted data source.
The analyst publishes the workbook to Tableau Server.
Which three actions can the analyst perform from the Extract Refresh page in Tableau Server? (Choose three.)
- A. Change the priority of the refresh
- B. Delete the refresh
- C. Change the refresh from full to incremental
- D. Run a refresh
- E. Modify the frequency of the refresh
正解：A、D、E
質問 # 95
You have the following table.
You need each record to alternate between grey and white.
What should you change in the Format Shading pane?
- A. the column banding size to 3
- B. the row banding size to 1
- C. the column banding size to 1
- D. the row banding size to 3
正解：B
解説：
To have each record alternate between grey and white, you should change the row banding size to 1 in the Format Shading pane. This setting will ensure that each row has a different shading from the one above and below it, creating an alternating pattern of grey and white rows. References: The answer can be verified through practical application within Tableau or by consulting Tableau's official learning resources, such as Tableau Help: Format Shading or Tableau Training Pass: Formatting.
質問 # 96
Open the link to Book1 found on the desktop. Open the Line worksheet.
Modify the chart to show only main and max values of both measures in each region.
正解：
解説：
check the steps below in explanation.
Explanation:
To modify the chart to show only min and max values of both measures in each region, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Line worksheet.
* Click on the Line tab at the bottom of the workbook to open the worksheet. You will see a line chart that shows the sales and profit for each month by region.
* Drag Month from the Columns shelf to Filters shelf. This will open a dialog box that allows you to filter by different criteria.
* Select Range of Dates from the dialog box. This will show you options to filter by a range of dates or values.
* Select Minimum and Maximum from the drop-down list next to Month. This will filter by the minimum and maximum values of Month for each region. You can also enter specific values or use the sliders to adjust the range.
* Click OK to apply the filter. You will see that the line chart now shows only min and max values of both measures in each region.
References: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_range.htm
質問 # 97
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?
- A. FIND
- B. REPLACE
- C. CONTAINS
- D. SPLIT
正解：B
質問 # 98
You have a workbook that uses an extracted data source.
You publish the workbook to Tableau Server.
Which three actions can you perform from the Extract Refresh page in Tableau Server? Choose three.
- A. Delete the refresh.
- B. Modify the frequency of the refresh.
- C. Run a refresh.
- D. Change the priority of the refresh.
- E. Change the refresh from full to incremental.
正解：A、C、D
質問 # 99
You have a data source that contains the following columns.
You want to sort customers based on the most expensive orders.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
正解：
解説：
Explanation:
質問 # 100
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.
正解：
解説：
check the steps below in explanation.
Explanation:
To split the Customer Name field into two fields named First Name and Last Name, 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.
* Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the Superstore data source.
* Right-click on Customer Name in the table and select Split from the menu. This will split the field into two fields based on a separator, which is a space by default. You will see two new fields named Customer Name - Split 1 and Customer Name - Split 2 in the table.
* Right-click on Customer Name - Split 1 and select Rename from the menu. Type First Name as the new name and press Enter. This will rename the field as First Name.
* Right-click on Customer Name - Split 2 and select Rename from the menu. Type Last Name as the new name and press Enter. This will rename the field as Last Name.
References: https://help.tableau.com/current/pro/desktop/en-us/datasource_prepare.htm
https://help.tableau.com/current/pro/desktop/en-us/split.htm
https://help.tableau.com/current/pro/desktop/en-us/renamefield.htm
質問 # 101
You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.
正解：
解説：
Explanation:
Sales: B. Columns
Profit: D. Rows
Customer Name: C. Detail on the Marks card
Category: A. Color on the Marks card
To create the visualization, you need to drag Sales to Columns, Profit to Rows, Customer Name to Detail on the Marks card, and Category to Color on the Marks card. This will create a scatter plot that shows the relationship between Sales and Profit for each Customer Name, with different colors for each Category.
References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.
com/current/pro/desktop/en-us/buildexamples_scatter.htm
質問 # 102
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.)
正解：
解説：
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
質問 # 103
You have the following dataset.
Which grouping option should you use m Tableau Prep to group al five names automatically?
- A. Pronunciation
- B. Spelling
- C. Manual Selection
- D. Common Characters
正解：B
解説：
Tableau Prep's Grouping feature includes various methods to group similar data. The Spelling option is used when the data has small variations in spelling, such as capitalization differences or common typos. Given that the names in the dataset vary in capitalization and punctuation but are spelled correctly, the Spelling grouping option would be the most appropriate choice to automatically group all five names.
質問 # 104
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.)
正解：
解説：
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
質問 # 105
You have the following dataset.
You want to create a new calculated dimension field named Category that meets the following conditions:
. When Subject is Computer Science or Science, Category must be Sciences.
. When Subject is English or Social Studies, Category must be Humanities.
Which two logical functions achieve the goal? Choose two.
- A. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
- B. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
- C. IF [Subject]- 'Science' THEN 'Sciences'
ELSEIF [Subject]='English' THEN 'Humanities'
ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
END - D. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
End
正解：C、D
解説：
To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either 'Sciences' or 'Humanities'. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign 'Humanities' to any subject that contains 'Science' in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with 'Computer Science' and ignore the other subjects. References:
* Logical Functions - Tableau
* Tableau Certified Data Analyst Study Guide
質問 # 106
You have the following:
Overall Rank and Rank are calculated fields that use the RANK function.
You filter out the sub-category where [Ovorall Rank] - 1.
For which three the sub-categories will the value of Rank change? Choose three.
- A. Copiers
- B. Machines
G Phones - C. Chairs
- D. Tables
- E. Furnishings
- F. Bookcases
- G. Accessories
正解：B、D、G
解説：
In Tableau, the RANK function assigns a rank to each row within a partition of the data, based on the value of the field being ranked. It is important to understand that the rank is recalculated whenever the underlying data or the partitioning changes.
In the given scenario, the Overall Rank is based on the Sales figures, while the Rank (presumably) is based on the Sales within the Category. When filtering on the condition where [Overall Rank] - 1, it means we are excluding the sub-category that has an Overall Rank of 2.
Looking at the data:
* Furnishings has an Overall Rank of 8, which does not meet the filter condition ([Overall Rank] - 1).
Therefore, its rank remains the same.
* Tables have an Overall Rank of 3. When the sub-category with an Overall Rank of 2 is removed (Chairs in this case), Tables move up in the overall ranking. However, since Tables are the top-ranked within the Furniture category, their Rank within the category would remain unchanged at 1.
* Chairs have an Overall Rank of 2, which meets the filter condition and thus will be removed from the view. We cannot determine the change in Rank for Chairs because they are filtered out.
* Accessories have an Overall Rank of 5. If any sub-category with a higher Overall Rank (1 to 4) is removed, the rank of Accessories within the Technology category could change because it is currently ranked 3 in its category. With the removal of Phones (Overall Rank 1), the Rank of Accessories could potentially increase.
* Copiers have an Overall Rank of 6, which does not meet the filter condition. Therefore, its rank remains the same.
* Machines have an Overall Rank of 4. If we remove Phones (Overall Rank 1), Machines will move up in the overall ranking and potentially within the Technology category as well, changing its Rank from 2 to 1.
* Phones have an Overall Rank of 1, which does not meet the filter condition of being Overall Rank 2.
Therefore, its rank remains the same.
* Bookcases have an Overall Rank of 7, which does not meet the filter condition. Therefore, its rank remains the same.
Based on this analysis, when the sub-category with an Overall Rank of 2 (Chairs) is removed, the Rank value will change for Tables, Accessories, and Machines, as they will move up in the overall ranking within their respective categories. However, it's important to note that while Tables will move up in the overall ranking, their rank within the Furniture category would not change as they are already at the top. The rank changes for Accessories and Machines are due to the removal of Phones, which is ranked higher overall and within the Technology category.
質問 # 107
Which function should a Data Analyst use to average sales at a less-granular level of detail than is in the view?
- A. RUNNING_AVG
- B. EXCLUDE
- C. AVG
- D. INCLUDE
正解：B
質問 # 108
You receive a tab-delimited data file name sales.tsv.
You need to connect to the file.
Which option should you select in Tableau Desktop?
正解：
解説：
Explanation:
To connect to a tab-delimited data file named sales.tsv, you should select the option To a File > Text file in Tableau Desktop. This option will allow you to browse and select the file from your local or network drive and connect to it as a data source. You can then specify the text file properties, such as the delimiter, the text qualifier, and whether the first row contains column names. You can also join, union, or blend the data with other data sources if needed. References:
* Text File - Tableau
* Tableau Certified Data Analyst Study Guide
質問 # 109
......
Analytics-DA-201試験問題集と保証された成功率：https://www.passtest.jp/Salesforce/Analytics-DA-201-shiken.html
最高品質のSalesforce Analytics-DA-201試験問題：https://drive.google.com/open?id=1NbQNYt_bggZ-iCZcrXqNVkhuUFiOqBQ2