[2026年04月] 最新のSalesforce Analytics-DA-201認定練習テスト問題
確認済みAnalytics-DA-201問題集と解答で一年間無料最速更新
Salesforce Analytics-DA-201 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
質問 # 60
A Data Analyst has the following chart that shows the sum of sales made in different cities.
The analyst wants to show the average sale amount for a city when users hover their mouse over any of the bars.
What should the analyst do?
- A. Right-click on SUM(Sales) in the Columns and select Include in Tooltip.
- B. Drag Sales to Tooltip on the Marks card and change Aggregation to Average.
- C. Drag Sales to Tooltip on the Marks card and modify the Tooltip text.
- D. Right-click on SUM(Sales) in the Columns and change Aggregation to Average.
正解：B
質問 # 61
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 [Subject]- 'Science' THEN 'Sciences'
ELSEIF [Subject]='English' THEN 'Humanities'
ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
END - B. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
End - C. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
- D. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
正解：A、B
解説：
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
質問 # 62
You have a data set that contains three columns named Sales, Profit, and Quantity.
You need to build the following scatter plot.
正解：
解説：
Explanation:
To build the scatter plot shown in the image, you need to place the Profit measure on the Rows shelf and the Sales measure on the Columns shelf. This will create a Cartesian chart with Profit as the y-axis and Sales as the x-axis. Then, you need to change the mark type to Circle on the Marks card. This will display the data points as circles that vary in size according to the Quantity measure. You can also add color or shape encoding to the marks to show additional dimensions or measures in the view. References:
* Build a Scatter Plot
* Understanding and Using Scatter Plots
* Scatter plot in Tableau
質問 # 63
The following table displays the row-level data in a Tableau data source:
A Data Analyst creates this calculated field:
SUM(IF [Item] = 'A' THEN [Sales] END) / COUNT([Order ID])
What is the result of this aggregate calculation?
- A. An error
- B. 0
- C. 1
- D. 2
正解：D
質問 # 64
A colleague provides you with access to a folder that contains the following files:
* Sates.csv
* Bookl.twb
* Sates.hyper
* Export.mdb
Which He contains an extract?
- A. Sales.csv
- B. Sales.hyper
- C. Book1.twb
- D. Export mdb
正解：B
解説：
A .hyper file is an extract file that contains a snapshot of data from a data source. It is a compressed and optimized file format that can be used to improve the performance and portability of dashboards and workbooks. A .twb file is a workbook file that contains the visualization and connection information, but not the data itself. A .csv file is a comma-separated values file that contains plain text data. A .mdb file is a Microsoft Access database file that contains tables, queries, forms, and other objects. References: https://help.
tableau.com/current/pro/desktop/en-us/save_savework_packagedworkbooks.htm https://help.tableau.com
/current/pro/desktop/en-us/extracting_data.htm https://help.tableau.com/current/pro/desktop/en-us
/examples_csv.htm https://support.microsoft.com/en-us/office/introduction-to-access-database-files-9f9a0f8c-
9a3c-4a0b-8e6c-6d1f1f7c2b7e
In Tableau, a .hyper file is an extract file created by the Hyper database engine. It contains a snapshot of the data pulled into Tableau and is used to perform data analysis without the need for a live connection to the data source.
質問 # 65
A Data Analyst has the following dataset:
The analyst wants to create a new calculated dimension field named Category that meets the following conditions:
When Subject is Computer Science or Science, the Category must be Sciences.
When Subject is English or Social Studies, the Category must be Humanities.
Which two logical functions achieve this goal? (Choose two.)
- A. IF ENDSWITH([Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
- B. IF [Subject] = 'Science' THEN 'Sciences'
ELSEIF [Subject] = 'English' THEN 'Humanities'
ELSEIF [Subject] = 'Social Studies' THEN 'Humanities'
ELSEIF [Subject] = 'Computer Science' THEN 'Sciences'
END - C. IIF((CONTAINS([Subject], 'Science') = TRUE), 'Humanities', 'Sciences')
- D. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
END
正解：B、D
質問 # 66
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?
- A. Create a calculated field that uses a formula of 'S' + stri < (Sales)/1000)).
- B. Change the default number format of the Sales told
- C. Create a calculated field that uses a formula of 'S' * str (Round((sales],2)) + 'k'
- D. Change the data type of the Sates field to Siring
正解：B
解説：
To make Sales appear automatically as shown in the second table, you should change the default number format of the Sales field. The default number format is how Tableau displays a field when you drag it to a worksheet. You can change the default number format by right-clicking on the field and selecting Default Properties > Number Format from the menu. This will open a dialog box where you can choose a category, such as Currency or Percentage, and customize the options, such as decimal places or prefixes.
In this case, you want to change the default number format of Sales to Currency with zero decimal places and a custom prefix of "S". This will make Sales appear as "S" followed by the rounded value in thousands.
The other options are not correct for this scenario. Changing the data type of Sales to String will not affect how it appears on a worksheet. Creating a calculated field that uses a formula will not change the default number format of Sales, but create a new field that you have to drag to a worksheet. Converting Sales to Attribute will return only one value for each partition of data, which will not show any variation over time.
References: https://help.tableau.com/current/pro/desktop/en-us/formatting.htm https://help.tableau.com/current
/pro/desktop/en-us/formatting_change_default.htm
To achieve the formatting as shown in the example, where sales figures are displayed with a "K" to represent thousands and rounded to the nearest thousand (e.g., $20K, $44K, etc.), you would need to adjust the default number format of the Sales field in Tableau. By changing the default number format, every instance where the Sales field is used would automatically reflect this new formatting. This is more efficient than creating a calculated field as it preserves the numeric nature of the field, allowing for further numerical operations and aggregations.
質問 # 67
You want to create the following dashboard.
The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.
When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.
How should you lay out the objects on the dashboard?
- A. Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
- B. Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.
- C. Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.
- D. Add both sheets to the dashboard. Set Fit to Fix width.
正解：A
解説：
To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories. References:
* Size and Lay Out Your Dashboard - Tableau
* Create a Dashboard - Tableau
* Format Dashboard Layout in Tableau - GeeksforGeeks
質問 # 68
You have the following visualization.
The Last() calculation is set to compute using Table (across)
Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?
- A. 0
- B. 1
- C. 2
- D. 3
正解：D
解説：
The LAST() function in Tableau returns the number of rows from the current row to the last row in the partition. When you compute using 'Order Date', it will change the partitioning of the calculation. If
'Consumer' in '2018' is the last row in its partition when computed by 'Order Date', then LAST() will return 0 for that cell.
The LAST() function in Tableau is a table calculation that returns the number of rows from the current row to the last row in the partition. The value of LAST() is 0 for the last row, increases by 1 for each row above the last row, and can be negative for rows below the current row if there are such rows in the partition.
In the provided visualization, LAST() is set to compute using Table (across). Changing the compute mode to use "Order Date" will adjust the partitioning of the data upon which the LAST() function is calculated. Since
"Order Date" is likely to be a unique value per row (assuming each order has a unique date), each row becomes its own partition.
For the Consumer segment of the year 2018, if "Order Date" is unique for each row, then the last row in each partition (in this case, each individual row) will have a LAST() value of 0 because there are no other rows in the partition - it's the last row of its own partition.
Therefore, when you change the compute mode of LAST() to use "Order Date", each cell under the Consumer segment for the year 2018 will have the LAST() value of 0, because each order date creates a partition of one, making every row the last in its partition.
質問 # 69
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 row banding size to 1
- B. the column banding size to 3
- C. the column banding size to 1
- D. the row banding size to 3
正解：A
解説：
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.
質問 # 70
A Data Analyst has a website that displays data in a table format.
The analyst wants to connect to the data of the website by using the least amount of effort.
What should the analyst use to connect to the data?
- A. ODBC connector
- B. Web data connector
- C. CSV file
- D. Clipboard
正解：D
質問 # 71
You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3.
You create several filters.
From the Data Source page you plan to add data source fillers
When type of filter will appear in the Edit Data Source Filters dialog box?
- A. A context filler on a dimension m Sheet3
- B. A dimension filter on all the sheets
- C. A table calculation filter used on Sheet
- D. A top N condition filer on a dimension in Sheet 1 and Sheet2
正解：B
解説：
A data source filter is a filter that applies to all the worksheets that use the same data source. It filters the data before any other filters or calculations are applied. You can add a data source filter from the Data Source page by clicking on the Add button next to Filters.
The type of filter that will appear in the Edit Data Source Filters dialog box is a dimension filter on all the sheets. This means that you can choose a dimension from your data source and filter it by values, range, condition, or top/bottom. The filter will affect all the worksheets that use that dimension.
The other types of filters are not data source filters and will not appear in the Edit Data Source Filters dialog box. A table calculation filter is a filter that applies to a table calculation, such as percent of total or running total. A top N condition filter is a filter that shows only the top or bottom N values of a measure or dimension based on a condition. A context filter is a filter that creates a subset of data that other filters can use.
References: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help.tableau.
com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us
/filtering_tablecalculations.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm Data source filters in Tableau apply to the entire data source, affecting all sheets that use that data source. The Edit Data Source Filters dialog box allows you to add filters that operate at the data source level, which is different from context filters, top N filters, or table calculation filters that are applied at the worksheet level.
質問 # 72
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
質問 # 73
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.
正解：
解説：
check the steps below in explanation.
Explanation:
To filter the table to show the members of the Top10 set and the Bottom10 set, 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 Disciplines worksheet.
* Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the disciplines, sales, and profit for each salesperson.
* Click on the drop-down arrow next to Salesperson on the Filters shelf. This will open a menu that allows you to filter by different criteria.
* Select Set from the menu. This will show you the sets that are available for the Salesperson field. You will see Top10 and Bottom10 as two sets that have been created based on the sales ranking.
* Check the boxes next to Top10 and Bottom10. This will filter the table to show only the members of these two sets. You can also click on All to deselect all other values.
* Click OK to apply the filter. You will see that the table now shows 20 rows, 10 for each set.
References: https://help.tableau.com/current/pro/desktop/en-us/sets.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering.htm
質問 # 74
You have the following tiled dashboard that has one sheet.
You want to replace the sheet with Sheet2.
What should you do?
- A. Right-click Sheet2 and select Add to Dashboard.
- B. From the context menu of Sheet3. select Deselect
- C. From the context menu of Sheet3. select Remove Dashboard item
- D. Select Sheet3 and click the Swap Sheet button next to Sheet2.
- E. Drag Sheet2 to the dashboard.
正解：E
解説：
In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard area where the current sheet (Sheet3) resides. This action will replace the existing sheet with the new one. Right-clicking and adding to the dashboard adds an additional sheet rather than replacing, and the context menu options mentioned in the other choices are not the standard methods for replacing sheets within a dashboard.
質問 # 75
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 row banding size to 1
- B. the column banding size to 3
- C. the column banding size to 1
- D. the row banding size to 3
正解：A
解説：
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.
質問 # 76
Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.
Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.
正解：
解説：
check the steps below in explanation.
Explanation:
To modify the bar chart to show the percentage of sales for each Subcategory within every Category, 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 CategoryPercentage worksheet.
* Click on the CategoryPercentage tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the total sales for each Subcategory across all Categories.
* Right-click on Sales on the Columns shelf and select Add Table Calculation from the menu. This will open a dialog box that allows you to apply a calculation to your measure.
* Select Percent of Total from the Calculation Type drop-down list. This will calculate the percentage of sales for each Subcategory out of the total sales for all Subcategories.
* Select Category from the Compute Using drop-down list. This will calculate the percentage of sales for each Subcategory within every Category, instead of across all Categories. The total percentage for every Category will be 100%.
* Click OK to apply the table calculation. You will see that the bar chart now shows the percentage of sales for each Subcategory within every Category.
References: https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations.htm https://help.
tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_create.htm https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_percentoftotal.htm
質問 # 77
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. Change the priority of the refresh.
- B. Run a refresh.
- C. Modify the frequency of the refresh.
- D. Change the refresh from full to incremental.
- E. Delete the refresh.
正解：A、B、E
質問 # 78
Which option must a Data Analyst enable to build the following table to add quarterly totals?
- A. Add Pane Totals
- B. Show Row Grand Totals
- C. Add All Subtotals
- D. Show Column Grand Totals
正解：C
質問 # 79
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?
- A. Condition
- B. General
- C. Top
- D. Wildcard
正解：D
質問 # 80
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.)
正解：
解説：
質問 # 81
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.
- A. From the Worksheet menu, use the Export option.
- B. From the Dashboard menu, use the Export Image option.
- C. From the Worksheet menu, use the Copy option.
- D. From the File menu, use the Export As Version option.
- E. From the Dashboard menu, use the Copy Image option.
正解：A、C
解説：
To create an image of the chart that you can add to the annual report, you can use either the Export option or the Copy option from the Worksheet menu. The Export option will allow you to save the image as a file in a specified location, name, and format. The Copy option will allow you to copy the image to the clipboard and paste it into another application, such as Microsoft Word. Both options will let you choose which elements to include in the image, such as title, caption, legend, etc. References:
* Export Views from Tableau Desktop to Another Application
* Copy and Paste Views from Tableau Desktop to Another Application
質問 # 82
A Data Analyst creates the following story that contains two story points.
The analyst wants to change the story point format to show the current story point number out of the total number of story points.
Which Layout option should the analyst use?
- A. Numbers
- B. Dots
- C. Arrows only
- D. Caption boxes
正解：C
質問 # 83
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?
- A. From the File menu select Import Workbook
- B. From the Data menu select New Data Source
- C. From the File menu select New
- D. From the Data menu select Replace Data Source
正解：B
解説：
To connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet, you need to select New Data Source from the Data menu. This will open the Connect pane, where you can choose Microsoft Excel as your data source and browse for your spreadsheet file. You can then drag and drop your sheets or tables to join or union them in the data source page. References: https://help.tableau.com/current/pro/desktop/en-us
/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_excel.htm When connecting to a dataset in Tableau Desktop, you would go to the 'Data' menu and select 'New Data Source'. This allows you to connect to various types of data sources, including Microsoft Excel spreadsheets, where you can then select the specific file you wish to connect to.
質問 # 84
A Data Analyst has the following view.
The analyst wants to filter the view to show only records that have a movie name starting with the word
"The". The analyst must achieve the goal without writing any formulas.
Which type of filter should the analyst use?
- A. Condition
- B. General
- C. Top
- D. Wildcard
正解：D
質問 # 85
......
最新の2026年最新の実際に出ると確認されたAnalytics-DA-201問題集で100%無料Analytics-DA-201試験問題集：https://www.goshiken.com/Salesforce/Analytics-DA-201-mondaishu.html
無料提供中2026年最新の無料更新されたSalesforce Analytics-DA-201試験問題と解答：https://drive.google.com/open?id=1WnRoyn24TwjDTwXfWIsga0WBD7z1p6LI