Desktop-Specialist無料試験問題と解答PDF最新問題2023年10月
最新Desktop-Specialist試験問題集で最近更新された150問題
Tableau Desktop Specialist Exam は、データの接続と準備、データの解析、そして洞察を共有するための3つのカテゴリーに分かれた36の質問から構成されています。受験者は120分間の時間制限があり、合格には少なくとも70％の点数が必要です。この試験はオンラインで実施され、複数の言語で利用可能です。Tableau Desktopで3ヶ月以上の経験がある個人が受験するように設計されています。
質問 # 81
DOWNLOAD THE DATASET FROM:
https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ-574wld4InEplyKT8RP?usp=sharing (if you haven't already) Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?
- A. France
- B. Canada
- C. United States
- D. United Kingdom
正解：A
解説：
Explanation
Follow along to get the correct answer:
* Drag Country to the view, and then Patents to the Size Mark on the Marks shelf as follows :
2) But, this isn't all right? We need to focus on the year 2013. This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:
2.1 As it is (continuous)
2.2 Converting to discrete first & then using it
and then :
3) We can now see that France, with 485 has the 2nd most number of patents for the year 2013
質問 # 82
By definition, Tableau displays measures over time as a ____________
- A. Packed Bubble
- B. Line
- C. Bar
- D. Stacked Bar
正解：B
解説：
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:
質問 # 83
Which of the following is a good reason for using a bullet graph?
- A. Comparing the actual sales against the target sales
- B. Forecasting future sales
- C. Analysing the trend over a given time period
- D. Displaying the year-on-year growth in sales
正解：A
解説：
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. Below is a single bullet graph showing how actual sales compared to estimated sales.
質問 # 84
You can create _______________ for members in a dimension so that their labels appear differently in the view.
- A. aliases
- B. parameters
- C. copies
- D. duplicates
正解：A
解説：
Explanation
You can create aliases (alternate names) for members in a dimension so that their labels appear differently in the view.
Aliases can be created for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures.
To create an alias:
1) In the Data pane, right-click a dimension and select Aliases.
2) In the Edit Aliases dialog box, under Value (Alias), select a member and enter a new name.
* To submit your changes: In Tableau Desktop, click OK.
On Tableau Server or Tableau Online, click the X icon in the top-right corner of the dialog box.
When you add the field to the view, the alias names appear as labels in the view. For example:
質問 # 85
What does the following icon do in Tableau?
Larger image
- A. Create a Dashboard
- B. Create a Story
- C. Create a Story and Dashboard both
- D. Create a Worksheet
正解：A
解説：
Explanation
The icon shown is used to add a new Dashboard! From the official documentation:
質問 # 86
______________ refers to the level of detail for a piece of data, wherever you are looking.
- A. Data connectivity
- B. Data Cleanliness
- C. Data LOD
- D. Data granularity
正解：D
解説：
Explanation
Data is generated and analyzed at many different levels of granularity. Granularity is the level of detail of the data. For example, when looking at graduation data, granularity would describe whether a row in the data set represents a single person or the graduating class of a university.
質問 # 87
How does Tableau know at which level to aggregate values?
- A. Values are always aggregated at the level of the Date Part
- B. Values are always aggregated at the level of granularity of the worksheet.
- C. Tableau doesn't aggregate values, we do!
- D. Aggregation is always done by using Tableau special formulas
正解：B
解説：
Explanation
In Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures.
Whenever you add a measure to your view, an aggregation is applied to that measure by default. The type of aggregation applied varies depending on the context of the view.
When you add a measure to the view, Tableau automatically aggregates its values. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau.
The current aggregation appears as part of the measure's name in the view. For example, Sales becomes SUM(Sales). Every measure has a default aggregation which is set by Tableau when you connect to a data source. You can view or change the default aggregation for a measure-see Set the Default Aggregation for a Measure.
You can change the aggregation for a measure in the view from its context menu:
質問 # 88
Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?
- A. Mexico
- B. Peru
- C. Argentina
- D. Brazil
正解：A
解説：
Explanation
VERY IMPORTANT QUESTION FOR THE EXAM, PAY ATTENTION
1) To find the number of days between order date and shipping date, we will make use of a calculated field:
In the data pane, click on the dropdown arrow, and choose create calculated field.
Let's name this calculated field "ShippingDelay" (you can name it anything you want :) )
2) Use the DATEDIFF() function, and pass it the arguments as follows:
'day' depicts that we want to calculate the number of DAYS between the two dates. The first argument is
'start_date' which is the ORDER_DATE (day the order was placed), the second argument is 'end_date', which is the SHIP_DATE (date the order was shipped). So by subtracting as follows: SHIP_DATE - ORDER_DATE, we can find the delay in shipping.
Click OK.
3) You should now have a new measure as follows:
4) Phew! The hard part is done! Now let's filter by Market to include only LATAM:
5) Drag Country to the view, and the new calculated field 'ShippingDelay' to SIZE on the Marks Shelf as follows:
*You can also click on Show Text Labels to be sure that you're choosing the Largest value*
Clearly, Mexico has the highest Shipping Delay!
質問 # 89
For a relative date filter, the default anchor is _________________
- A. Today's date
- B. The current time
- C. The date we specify
- D. The target date
正解：D
解説：
Explanation
Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most recent data.
Step 1: Drag a date field to the filter shelf
Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.
Step 2: Select a time unit
In the Filter dialog box, click Relative dates, and then select the unit of time for the filter. For example, to show only the three most recent weeks, select Weeks.
Here, you can clearly see that the default date is TODAY
質問 # 90
True or False: All rows from both tables are returned in an INNER JOIN
- A. True
- B. False
正解：B
解説：
Explanation
The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns.
Consider 2 tables "Orders" and "Customers".
If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!
質問 # 91
________________ can only create header. _______________ will create header and axis both.
- A. Dimensions, Measures
- B. Dates, Strings
- C. Measures, Dimensions
- D. Groups, Sets
正解：A
解説：
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.
質問 # 92
In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.
- A. top left bottom left
- B. top left, bottom right
- C. top right, bottom left
- D. top right, bottom right
正解：C
解説：
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:
質問 # 93
Which of the following chart type makes use of 'binned' data?
- A. Gantt Chart
- B. Bullet chart
- C. Treemaps
- D. Histogram
正解：D
解説：
Explanation
A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.
質問 # 94
Which of the following are the options to export the data used to build the view / visualisations?
- A. PDF File
- B. CSV file
- C. JSON format
- D. MS Access Database
正解：D
解説：
Explanation
You can export the data in a Tableau data source, including all or part of the records from your original data.
Alternatively, you can export only the portion of data used to generate the view.
Since the question mentions the data used to build the view, we'll focus on that :
*Export data in the view to Microsoft Access or .csv*
Export the data that is used to generate the view as an Access database (Windows only) or .csv file (Mac only).
1) In Tableau Desktop, select Worksheet > Export > Data.
2) Select a location and type a name for your Access database or .csv file.
3) Click Save.
4) If you're on Windows, the Export Data to Access dialog box displays to give you the option to immediately use the new Access database and continue working in Access without interrupting your work flow.
質問 # 95
True or False: It is possible to change the Geographic Role of a dimension
- A. False
- B. True
正解：B
解説：
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.
質問 # 96
Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?
- A. $33,768
- B. $16,581
- C. (Correct)
- D. $48,115
- E. $147,950
正解：B
解説：
Explanation
Phew! Tricky one! You needed to use filters in this one.
Follow along:
2) Next, as the question mentions, we need to focus on the Assortment PHONE, the color WHITE, and the state of NEW YORK. -> so we use filters for this!
i) First drag Assortment to Filters, and select only Phones :
ii) Next, drag Color to Filters and Choose only White:
iii) Next, drag State ID to Filters, and choose New York (NY):
And Voila! We have our answer as follows:
iv) Last, drag Sales to Label:
質問 # 97
For creating variable sized bins we use __________________
- A. Table Calculations
- B. Groups
- C. Calculated Fields
- D. Sets
正解：C
解説：
Explanation
One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0-5, 6-10, 11-15, and so on. Then you can count the number of people in each age group.
Create a calculated field for variable bin size
Step 1
Select Analysis > Create Calculated Field.
Step 2
In the Calculated Field dialog box, complete the following steps:
質問 # 98
......
Tableau Desktop Specialist試験は、データ分析や可視化のためにTableau Desktopソフトウェアを使用する個人のスキルと知識をテストする認定プログラムです。この試験は、データアナリスト、ビジネスインテリジェンスプロフェッショナル、その他Tableau Desktopとその機能の理解を証明したいデータ愛好家に最適です。この試験はオンラインで実施され、データ接続、データ準備、可視化作成、ダッシュボード作成など、Tableau Desktopに関連するさまざまなトピックをカバーする複数選択問題で構成されています。
Tableau Desktop-Specialistリアル2023年最新のブレーン問題集で模擬試験問題集：https://jp.fast2test.com/Desktop-Specialist-premium-file.html
Desktop-Specialist試験問題リアルDesktop-Specialist練習問題集：https://drive.google.com/open?id=175EjaPXOUOTSw5wJRwy-OrOI8OfXHgQy