[Q43-Q60] リアルTableau Desktop-Specialist日本語試験問題 [更新されたのは2023年]

リアルTableau Desktop-Specialist日本語試験問題 [更新されたのは2023年]

Desktop-Specialist日本語試験問題集で合格させるのは更新されたのは2023年年最新のTableau Desktop Specialist Exam (Desktop-Specialist日本語版)

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

A. 対策
B. 寸法

正解：B

解説：
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.

質問 # 44
メタデータの管理オプションを使用すると、列のカスタム名を作成できます。ここで、_____________は列の元の名前ですが、_____________はTableauで作成したカスタム名です。

A. ローカル名、実際の名前
B. ローカルフィールド、グローバルフィールド
C. 列名、実際の名前
D. リモートフィールド名、フィールド名

正解：D

解説：
Explanation
Using the Sample superstore as a reference, click on the manage metadata icon as follows:

We can rename a particular column name to make it easier to remember and use in Tableau. Let's change Order ID to oID as shown:

Now, we'll see oID when using this data source in Tableau. This WILL NOT affect the original data source.
The remote field name let's us see what the name of the column is in the ORIGINAL Data source.

質問 # 45
最初にフィルターを適用し、次に上位N要素または下位N要素を表示する場合、次のフィルターのどれを使用しますか？

A. 抽出フィルター
B. これらのどれも
C. データソースフィルター
D. コンテキストフィルター

正解：D

解説：
Explanation
IMPORTANT QUESTION, PAY ATTENTION
By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter. Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.
You may create a context filter to:
1) Improve performance - If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.
2) Create a dependent numerical or top N filter - You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.

質問 # 46
正誤問題：分析ペインから参照線を追加できない

A. 本当
B. 偽

正解：B

解説：
Explanation
You can add a reference line to any continuous axis in the view.
To add a reference line:
Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item and the current view.
In a simple case, the drop target area offers three options:

質問 # 47
次のフィルタが表示されている場合は、_______________________大きな画像を使用しています

A. 日付値
B. グループ化された日付
C. 日付関数
D. 日付パーツ

正解：A

解説：
Explanation
Dates in Tableau will behave differently depending on whether they are a Datepart (blue) or a Datevalue (green). This affects how the axes display/behave and also how visualisations such as line charts will display.
The difference essentially boils down to Dateparts behaving like a dimension as opposed to a measure which is how Datevalues behave. This means that Dateparts behave like discrete categories on the view whereas Datevalues are more like continuous numeric values.
Dateparts are discrete and they behave the same as dimension filters. If all dates are used on the filter then each individual date will be a datepart that can be selected/excluded. This is the same for each level of date, if datepart months is placed on filters January to December will be tick-able options in the filter. This also means that conditions and top/bottom filters can be applied to datepart filters like any other dimension filter.
Datevalues placed on filters behave like measure filters. A min and a max date can be set and there is a relative dates option which allows you to choose things like only show the previous 3 months or years etc.

質問 # 48
正誤問題：シートをストーリー内で直接使用することはできない。シートはダッシュボード内で使用するか、ダッシュボードをストーリー内で使用する必要があります。

A. 偽
B. rue

正解：A

解説：
Explanation
It is possible in Tableau to use a sheet within a story directly.
Moreover, in Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.
At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.

質問 # 49
大きい画像

Tableauでこのビューは何と呼ばれていますか？

A. 分析ペイン
B. データペイン
C. 寸法と寸法
D. ウィンドウペイン

正解：B

解説：
Explanation
Tableau displays data source connections and data fields for the workbook in the Data pane on the left side of the workspace.
The Data pane includes:
Dimension fields - Fields that contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view. Examples of dimensions include dates, customer names, and customer segments.
Measure fields - Fields that contain numeric, quantitative values can be measured. You can apply calculations to them and aggregate them. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default). Examples of measures: sales, profit, number of employees, temperature, frequency.
For more information on what dimensions and measures are, see Dimensions and Measures, Blue and Green.
Calculated fields - If your underlying data doesn't include all of the fields you need to answer your questions, you can create new fields in Tableau using calculations and then save them as part of your data source. These fields are called calculated fields.
For more information on calculated fields, see Create Custom Fields with Calculations.
Sets - Subsets of data that you define. Sets are custom fields based on existing dimensions and criteria that you specify. For more information, see Create Sets.
Named sets from an MS Analysis Services server or from a Teradata OLAP connector also appear in Tableau in this area of the Data pane. You can interact with these named sets in the same way you interact with other custom sets in Tableau.
Parameters - Values that can be used as placeholders in formulas, or replace constant values in calculated fields and filters. For more information, see Create Parameters.

質問 # 50
Tableauで連続フィールドをどのように識別しますか？

A. データウィンドウの前に「=＃」記号が表示されます
B. 視覚化で青い丸薬で識別されます
C. 視覚化された緑色の錠剤で識別されます
D. データウィンドウの前に「Abc」記号が表示されます

正解：A

解説：
Explanation
When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.

質問 # 51
Tableauサポートケースは、次の有効な方法のどれで開くことができますか？

A. TableauWebサイトのサポートオプションを使用する
B. 開発者コミュニティフォーラムの使用
C. Tableau LearnWebサイトの使用
D. Webサイトを使用してSalesforceに連絡する

正解：A

解説：
Explanation
It is possible to open a Tableau support case by visiting the following link :
https://www.tableau.com/support/case

質問 # 52
正誤問題：LEFTJOINまたはINNERJOINは、結合基準が満たされるたびに行を作成するため、行が重複する可能性があります。これを回避する1つの方法は、代わりにデータブレンディングを使用することです。

A. 本当
B. 偽

正解：A

解説：
Explanation
Joins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin.

Inner join

Left Join
Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.

質問 # 53
通常の計算フィールドと、データブレンディング後に作成された計算フィールドの重要な違いは何ですか？

A. 違いはありません。計算フィールドはブレンドで作成できません
B. ブレンドで使用されるフィールドは最初に集約する必要があります
C. ブレンドで作成された計算フィールドは、一度作成すると編集できません
D. ブレンドで作成された計算フィールドは3つ以上のフィールドを使用できません

正解：B

解説：
Explanation
Yes, due to the nature of blends, there are some conditions as follows from the official documentation that must be kept in mind while working with blends:

In addition to handling calculations slightly differently, there are some limitations on secondary data sources.
You may not be able to sort by a field from a secondary data source, and action filters may not work as expected with blended data. For more information, see Other data blending issues.

質問 # 54
Excel、テキストファイルデータ、JSONファイル、.pdfファイルデータを操作する場合、_________________を使用して、フォルダー間でファイルを結合し、ワークブック間でワークシートを結合できます。検索の範囲は、選択した接続になります。

A. 正規表現検索
B. ワイルドカード検索
C. ユニオン検索
D. パターン検索

正解：B

解説：
Explanation
You can use Wildcard Search to set up search criteria to automatically include tables in your union. Use the wildcard character, which is an asterisk (*), to match a sequence or pattern of characters in the Excel workbook and worksheet names, Google Sheets workbook and worksheet names, text file names, JSON file names, .pdf file names, and database table names.
When working with Excel, text file data, JSON file, .pdf file data, you can also use this method to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page.

質問 # 55
正誤問題：フィールドを複数の階層に追加することが可能

A. 本当
B. 偽

正解：A

解説：
Explanation
Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.

質問 # 56
質問45：スキップ
ヒストグラムを作成したばかりで、ビンのサイズを動的に変更できるようにしたいと考えています。次のうちどれを使用すると、要件を簡単に満たすことができますか？

A. セット
B. 計算
C. グループ
D. パラメータ

正解：D

解説：
Explanation
A parameter is a global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line.
For example, you may create a calculated field that returns True if Sales is greater than $500,000 and otherwise returns False. You can replace the constant value of "500000" in the formula with a parameter.
Then, using the parameter control, you can dynamically change the threshold in your calculation.
For example -

質問 # 57
はいまたはいいえ：ビューの寸法の数を増やすと、マークの数が増えます

A. はい
B. いいえ

正解：A

解説：
Explanation
Of course! As an example, see below:
1) Using the Sample Superstore data, let's plot a bar chart showing the Sales for each Category:

Observe that we have 3 marks - Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark , and so on for all charts.
1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark - a single continous axis, but 3 different marks (Technology, Furniture and Office supplies ) on the x-axis.
2) Now let's add subcategory to the view as well (another dimension):

Observe that the number of marks has increased - i.e the number of Bars.
Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)

質問 # 58
正誤問題：ディメンションの地理的役割を変更することが可能

A. 本当
B. 偽

正解：A

解説：
Explanation
A geographic role associates each value in a field with a latitude and longitude value.
Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map view. For example, you can assign the City geographic role to a field that contains a list of city names.
To assign a geographic role to a field:
In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field.

When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane:
Latitude (generated) and Longitude (generated).
These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles.
If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map.

質問 # 59
cwurDataテーブルを使用して、国ごとの出版物の数を機関ごとに分類し、国ごとにフィルタリングしてUnited Kingdown（UK）のみを表示するクロスタブを作成します。マンチェスター大学の場合、2014年に出版物全体の何パーセントが寄稿されましたか？

A. 22.404％
B. 25.683％
C. 28.415％
D. 23.497％

正解：A

解説：
Explanation
Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We'll be using filters, as well as quick table calculations (percent of total) for this one.
1) Firstly, let's drag Country and to the Rows shelf, and year (discrete) to the Columns shelf.
Then, drag Publications to the Text Icon in the Marks Shelf. The following is our view: