Desktop-Specialist日本語別格な問題集をダウンロードして無料で最新の（Desktop-Specialist日本語テスト問題集をゲット) [Q61-Q82]

Desktop-Specialist日本語別格な問題集をダウンロードして無料で最新の（Desktop-Specialist日本語テスト問題集をゲット2022年02月21日)

Desktop-Specialist日本語問題集は合格保証します合格できるDesktop-Specialist日本語試験問題2022年更新

質問 61
次の2つの列のうち、Tableauで削除できないものはどれですか？

A. レコード数
B. メジャー名
C. 測定値
D. 計算フィールド

正解: B,C

解説:
Explanation
Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated.
Calculated Fields, and Number of records can both be deleted.

質問 62
Tableauで視覚化するための軸はいつ作成されますか？

A. メジャーを行/列シェルフにドラッグするとき
B. 連続フィールドを行/列シェルフにドラッグするとき
C. ディメンションを行/列シェルフにドラッグするとき
D. 離散フィールドを行/列シェルフにドラッグするとき

正解: B

解説:
Explanation
An Individual Axis in Tableau is obtained by adding a continuous into Rows or Columns Shelf.
Example:
In order to show Individual Axis in Tableau First, we drag and drop the Color from Dimension shelf to Column Shelf. Next, we drag and drop the Sales Amount from measures shelf to Rows Shelf. Since it is a continuous value, the Sales Amount will be aggregated to default Sum. Once you drag them, following Chart report will be generated.

Next, we drag and Drop one more measure value, i.e., Total Product Cost from Measures Region to Rows Shelf. Because it is a Measure value, Total Product Cost is aggregated to default Sum. From the below screenshot, you can observe that Tableau has created an individual axis for each measure (continuous field).

質問 63
CoffeeChainテーブルを使用して、州ごとの総経費を示すクロス集計を作成し、列の総計をビューに追加します。次に、ニューヨーク州、カリフォルニア州、ワシントン州をグループ化します。このグループは総売上高の何パーセントを占めていますか？

A. 23.39％
B. 25.79％
C. 27.73％
D. 29.49％

正解: C

解説:
Explanation
We need to use the concept of Groups for this question. Follow along:
1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:

2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:

3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:

We can see the answer already : 23.386% in the view above (even before grouping!)
4) Finally, we get the following view and our answer:

質問 64
_____________は、Tableauがローカルに保存するデータのスナップショットです。必要なフィールドが少ない非常に大きなデータセットに適しています。

A. Tableauデータソース（.tds）
B. Tableauデータ抽出（.tde）
C. Tableauワークブック（.twb）
D. Tableauパッケージワークブック（.twbx）

正解: B

解説:
Explanation
Tableau Data Extract (TDE) is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Performance is optimised because it queries its own database engine instead of the local data source.
When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data. When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.
Extracts are advantageous for several reasons:
1) Supports large data sets: You can create extracts that contain billions of rows of data.
2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data.
3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.
4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct.
5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.

質問 65
データをグループ化する有効な方法は次のうちどれですか？

A. 寸法棚から
B. ビューでのラベルの使用
C. ビューでのマークの使用
D. 分析ペインから

正解: A,B,C

解説:
Explanation
**IMPORTANT QUESTION AND EXPLANATION, PLEASE READ**
3 ways to group data -
1) Marks
2) Labels
3) Dimensions shelf.
*IMPORTANT*
If we Group the data by selecting the marks, then they remain separate marks in the view and then have the same colour. Also, a new group is created in the Dimensions shelf. Example - Using the sample superstore dataset, first plot a bar chart showing sales for each sub-category:

Here, if we Select Phones, Chairs and Storage by selecting the MARKS (Bars), and then group them:

They remain seperate marks (BARS) but are grouped by the same colour.
Now, if we didn't do this, and rather grouped by selecting their Labels (Names):

Then they no longer remain separate Marks (bars) but are rather consolidated into a single Bar:

Finally, we can group directly from the Dimensions shelf as follows:

Now choose Phones, Chairs and Storage and Click Group:

You will now automatically have a new Dimension as follows:

質問 66
Tableauのストーリーポイントにダッシュボードとワークシートの両方を同時に追加することは可能ですか？

A. いいえ
B. はい

正解: A

解説:
Explanation
This is a tricky question. We are talking about story POINTS, and not entire stories in the question.
To create a story, lets say I have a blank story with 1 dashboard and 1 worksheet.
I can simply drag the dashboard into the view to create a new story point.

Now, if I try to adjust the worksheet beside it in this same view, I cannot. See below:

The only option available is to replace the existing view. Therefore, the answer is NO since they both cannot be added.
Read more about stories in Tableau: https://help.tableau.com/current/pro/desktop/en-us/story_create.htm

質問 67
Colorに連続フィールドをドロップすると、Tableauは___________の範囲の色で量的な凡例を表示します。

A. フェード
B. 継続
C. 離散
D. 混合

正解: D

解説:
Explanation
When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field.
When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.
Web version:

Desktop Version:

For more information about color palettes, see Color Palettes and Effects.

質問 68
_________________は、データソースの構成方法をシートごとに変更する必要がある場合、および関係や結合を許可しないデータベースを結合する場合に役立ちます。

A. ユニオン
B. データの分離
C. データ結合
D. データブレンディング

正解: D

解説:
Explanation
Data blending is performed on a sheet-by-sheet basis and is established when a field from a second data source is used in the view. To create a blend in a workbook already connected to at least two data sources, bring a field from one data source to the sheet-it becomes the primary data source.
Switch to the other data source and use a field on the same sheet-it becomes a secondary data source. An orange linking icon will appear in the data pane, indicating which field(s) are being used to blend the data sources.

According to the official Tableau Documentation:

To read more about Data Blending, click on THIS link.

質問 69
売上が30,000を超える顧客名を含むセットを作成します。このセットで最も売上が少ない顧客はどれですか？

A. トムアッシュブルック
B. ペネロペセウォール
C. Sanjit Engle
D. タマラチャンド

正解: B

解説:
Explanation
As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000
1) Right click on customer name --> Create --> Set

2) Let's Name the Set - Customer>30k ( you can name it anything you want :) ) Select USE ALL, and then move to the CONDITION TAB:

3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK

4) You should now have a new Set in the Data Pane as follows:

5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.

6) Click on the Show Mark Labels, and Sort ascending icons as shown:

7) Voila! We have our answer:
c

質問 70
ビジュアライゼーションの形状、色、テキストを編集するために使用するのは次のうちどれですか？

A. マークスカード
B. データペイン
C. 分析ペイン
D. フィルターシェルフ

正解: A

解説:
Explanation
The Marks Card allows us not only to edit the Shape, Text and Colour, but also to modify the Tooltip and the level of detail of the visualisation!

The Marks card is a key element for visual analysis in Tableau. As you drag fields to different properties in the Marks card, you add context and detail to the marks in the view.

You use the Marks card to set the mark type (see Change the Type of Mark in the View), and to encode your data with color, size, shape, text, and detail. To change the mark settings, see Control the Appearance of Marks in the View.

In this example, three different fields have been dragged to different properties in the Marks card. Segment is on Color, Region is on Shape, and Quantity is on Size.
After you add a field to the Marks card, you can click the icon next to the field to change the property it is using. You can also click the property buttons in the Marks card to change those settings.
Many properties can have multiple fields. For example, you can add multiple fields to Label, Detail, Tooltip, and Color. Size and Shape can only have one field at a time. For more details, see Control the Appearance of Marks in the View.

質問 71
データセットを使用して、地域ごとに分類された平均数量を示す棒グラフを作成し、国ごとにフィルタリングして日本のみを表示します。東京州の平均数量はいくらでしたか？

A. 3.840
B. 3.704
C. 3.500
D. 3.000

正解: B

解説:
Explanation
Since we need to focus on 1 country -> Japan, let's filter on it first as follows:
1) Drag Country to the filter shelf, and choose only Japan. Click OK.

2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:
Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.
Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.
The following is our visualisation:

Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME.
Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward :)

質問 72
TableauのシートをPDFにエクスポートする説得力のある理由は次のうちどれですか？

A. 視覚化でフィルターを使用する場合。
B. ビジュアライゼーションと対話したい場合。
C. ビジュアライゼーションにパラメータを動的に入力する場合。
D. 視覚化の静的ビューが必要な場合。

正解: D

解説:
Explanation
Exporting the visualisation gives us a static view of the visualisation.
It is NOT possible to interact with it, use filters, or dynamically enter anything in a visualisation exported PDF.
In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. You do not need to have Adobe Acrobat installed on your computer.
When you print an individual sheet to PDF, filters in the view are not included. To show filters, create a dashboard containing the sheet and export the dashboard to PDF. (IMPORTANT)

質問 73
Tableauの日付は通常、______________として扱われます

A. 寸法
B. 対策

正解: A

解説:
Explanation
For relational data sources, dates and times are automatically placed in the Dimensions area of the Data pane and are identified by the date or date-time icon. For example, the Order Date and Ship Date dimensions from an Excel data source are shown below:

When you place a relational date on a shelf, the field name is automatically modified to reflect the default date level. Tableau defines the default date level to be the level at which there are multiple instances. For example, if the date field includes multiple years, the default level is year. However, if the date field contains data for just one year but includes multiple months, then the default level is month.

質問 74
Tableauで利益率を計算する正しい方法は次のうちどれですか？

A. SUM（利益）/ SUM（売上）
B. 売上高/利益
C. SUM（売上）/ SUM（利益）
D. 利益/売上高

正解: A

解説:
Explanation
THIS IS A VERY IMPORTANT QUESTION
Aggregation is an important concept to consider when creating calculated fields. A calculated field for SUM([Profit]) / SUM([Sales]) will give you a very different answer than [Profit] / [Sales], even though both formulas are valid.
If you do not provide the aggregation within the calculated field, Tableau will calculate the equation for every record ( row ) in your analysis, then aggregate the answers for all of the rows together when the calculated field is added to the view.
In simple terms, if specify the aggregation such as SUM, what Tableau will do is that it will first calculate the sum of the Profit column ( say x ), then calculate the sum of the Sales column ( say y ), and then simply apply x/y ---> This is what we expect! Perfect!
BUT, if you don't specify the aggregation, it will go to every single ROW, perform Profit / Sales, and then aggregate the answers calculated for each row. This is simply NOT what we wan't!
An example:

質問 75
定義上、Tableauは時間の経過に伴う測定値を____________として表示します

A. スタックバー
B. パックされたバブル
C. ライン
D. バー

正解: C

解説:
Explanation
Line charts connect individual data points in a view. They provide a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values.
Please refer to the images below:

質問 76
________________はヘッダーのみを作成できます。 _______________は、ヘッダーと軸の両方を作成します。

A. メジャー、寸法
B. グループ、セット
C. 日付、文字列
D. 寸法、寸法

正解: D

解説:
Explanation
Using the Sample superstore as a reference:
1) Let's plot a bar chart showing SUM(Quantity) for each Segment:
2) Right click on the x-axis (Segment):
Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS.
3) Similarly, right click on the y-axis (Quantity):

Now we have the option to edit BOTH the axis and the header.

質問 77
______________を色にドラッグすると、アイテムごとに異なる色が作成されますが、
______________色を付けるとグラデーションが作成されます

A. 経度、緯度
B. 離散値、連続値
C. 連続値、離散値
D. 地理的価値、離散的価値

正解: B

解説:
Explanation
Remember that dragging a discrete value to colour creates distinct colours for each item whereas dragging a continuous value to colour creates a gradient. ( Same for Map ) From the official documentation:

質問 78
Tableauは、____________ディメンションと_____________メジャーを自動生成します

A. 1、2
B. 2、2
C. 2、3
D. 1、4

正解: D

解説:
Explanation
Tableau auto-generates :
1 Dimension - Measure Names
4 Measures - Latitude, Longitude, Number of records, Measure Values
Starting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)

質問 79
弾丸グラフの場合、少なくとも____________メジャーが必要です

A. 0
B. 1
C. 2
D. 3

正解: C

解説:
Explanation
A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures.
Therefore, we need at least 2 measures for creating bullet graphs.

質問 80
ツリーマップでは、サイズは________________の最大の長方形と________________の最小の長方形で始まります。

A. 左上、右下
B. 右上、右下
C. 左上下左
D. 右上、左下

正解: D

解説:
Explanation
Tree maps size begins from maximum in top left to smallest in bottom right.

See below to learn how to create a TreeMap and add colours to it:

質問 81
アスリートテーブルの使用：
i）各スポーツの平均体重を示すクロス集計付きのシートを作成します（シート1）ii）国ごとの金メダルの総数を示すマップ付きのシートを作成します。サイズをマークとして使用します。
（シート2）
次に、これら両方のシートを含むダッシュボードを作成し、シート2をシート1のフィルターとして使用します。ロシアのバドミントンの平均体重はいくらでしたか。
（null /不明を無視します）

A. 68.77
B. 65.67
C. 76.25
D. 4.87

正解: C

解説:
Explanation
Pretty common question on the Tableau Desktop Specialist exam.
1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:

2) Now, for sheet 2 - Drag nationality to the view, and gold to the size mark in the Marks shelf.
NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:

3) Now, let's create a dashboard, and use both these sheets in it:

4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:

Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows: