TDS-C01認定お試し[2022年10月18日] 最新TDS-C01のPDF問題集
ベストTableau TDS-C01学習ガイドと問題集でof2022年更新
Tableau TDS-C01 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
| トピック 10 |
|
| トピック 11 |
|
質問 38
Which of the following is the correct way to calculate Profit Ratio in Tableau?
- A. SUM(Sales)/SUM(Profit)
- B. Sales / Profit
- C. SUM(Profit) / SUM(Sales)
- D. Profit / Sales
正解: C
解説:
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:
質問 39
Which of the following options best describe measures?
- A. They are categorical, qualitative
- B. They are categorical, quantitative
- C. They are numerical, quantitative
- D. They are numerical, qualitative
正解: C
解説:
Data fields are made from the columns in your data source. Each field is automatically assigned a data type (such as integer, string, date), and a role: Discrete Dimension or Continuous Measure (more common), or Continuous Dimension or Discrete Measure (less common).
Dimensions 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.
Measures contain numeric, quantitative values that you can measure. Measures can be aggregated. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default).
質問 40
How would you calculate GDP per capita in Tableau?
- A. SUM([Population]/[GDP]])
- B. SUM([GDP]*[POPULATION])
- C. SUM([GDP]/[POPULATION])
- D. SUM([GDP]) / SUM([Population])
正解: D
解説:
GDP / Population = GDP Per Capita
Here Sum is a function, / and + are operators. On the bottom there are comments.
質問 41
In order to avoid any confusions, what should you do after creating a Dual-axis chart?
- A. Change the colours
- B. Edit the labels
- C. Hide the axis
- D. Synchronise the axis
正解: D
解説:
After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.
To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.
In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis.
If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear.
In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.
質問 42
Are animations enabled by default in Tableau?
- A. No
- B. Yes
正解: A
解説:
No, by default, animations are not enabled in Tableau.
We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate.
Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.
When you author animations, you can choose between two different styles: simultaneous or sequential. Here are examples of each type.
1) Simultaneous animations
The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.
2) Sequential animations
Sequential animations take more time but make complex changes clearer by presenting them step-by-step.
To Animate visualizations in a workbook:
1) Choose Format > Animations.
2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:
For Duration, choose a preset, or specify a custom duration of up to 10 seconds.
For Style, choose Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.
3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.
質問 43
Given a map, which of the following fields can be placed on Size,Shape,Detail,Color
- A. Sales, State, Country, Profit
- B. Region, Country, Profit, State
- C. Longitude, Country, State, Sales
- D. Profit, State, Number of Records, Sales
正解: A
解説:
Since Sales is a measure, it can easily be depicted via size.
To drill down and change the level of detail, Country is the correct choice since it will contain STATE. We can then depict the various states by different shapes such as circle, square etc.
Finally, the Profit can be depicted via a color! Eg - Red for poor and green for excellent profits!
質問 44
Download the Dataset from:
https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?
- A. September 2017
- B. March 2018
- C. January 2018
- D. December 2017
正解: C
解説:
Explanation
Follow the steps to get the correct answer : January 2018
* We are talking about dates, so use the Time series sheet as follows:
* Next, the following should be your view and clearly, January 2018 is the lowest point:
Read more about dates:
https://interworks.com/blog/rcurtis/2017/01/30/tableau-deep-dive-dates-introduction-dates/
質問 45
Are animations enabled by default in Tableau?
- A. No
- B. Yes
正解: A
解説:
Explanation
No, by default, animations are not enabled in Tableau.
We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate.
Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.
When you author animations, you can choose between two different styles: simultaneous or sequential. Here are examples of each type.
1) Simultaneous animations
The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.
2) Sequential animations
Sequential animations take more time but make complex changes clearer by presenting them step-by-step.
To Animate visualizations in a workbook:
1) Choose Format > Animations.
2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:
For Duration, choose a preset, or specify a custom duration of up to 10 seconds.
For Style, choose Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.
3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.
質問 46
______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.
- A. Combining
- B. Unioning
- C. Blending
- D. Joining
正解: B
解説:
Unioning is the correct answer!
From the official documentation:
For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016" , "June2016" and "July2016."
質問 47
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
- A. July
- B. September
- C. October
- D. June
正解: C
解説:
Follow along:
1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.
For sales, click on the pill -> choose Quick Table calculation -> Year over Year growth.
The view should now look like:
It is clear that October with -55.3% had the lowest Year on Year growth.
質問 48
Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a
____________ and a ____________.
- A. role, type
- B. Data type, Value
- C. type, role
- D. dimension, measure
正解: A
解説:
Explanation
When users connect to Tableau, the data fields in their data set are automatically assigned a role and a type.
Role can be of the following two types:
1) Dimension
2) Measure
Type can be of the following :
1) String
2) Number
3) Geographic
4) Boolean
5) Date
6) Date and Time
質問 49
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
- A. Dimension Filter
- B. Extract Filter
- C. Measure Filter
- D. Context Filter
正解: B
解説:
Explanation
According to Tableau's order of operations, the Extract filter is right at the top of the hierarchy. The data filtered in the Extract is then passed on to what we see in the Data Pane. See below:
質問 50
What is the following icon in the Data pane used to do?
Larger image
- A. View Data
- B. Extract Data
- C. Clean Data
- D. Sort Data
正解: A
解説:
Explanation
View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view.
The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.
From the official website:
質問 51
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. United Kingdom
- B. France
- C. Canada
- D. United States
正解: B
解説:
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
質問 52
If you are working with a huge dataset, which of the following are strong reasons to use a context filter?
- A. To make the context filter a dependent filter
- B. Improve query performance
- C. To help clean the data
- D. To include only the data of interest
正解: B,D
解説:
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 (Option stating - To create a dependent filter eliminated here). 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.
For example, suppose you're in charge of breakfast products for a large grocery chain. Your task is to find the top 10 breakfast products by profitability for all stores. If the data source is very large, you can set a context filter to include only breakfast products. Then you can create a top 10 filter by profit as a dependent filter, which would process only the data that passes through the context filter.
質問 53
Which of the following points are True about Viz Animations?
- A. It is possible to turn them on for the entire workbook at once
- B. They can be turned on for certain worksheets only
- C. Animations work well with maps, polygons, and density marks in web
browsers - D. Sequential animations take more time but make complex changes
clearer by presenting them step-by-step
正解: A,B,D
解説:
All of the given options are true except - Animations work well with maps, polygons, and density marks in web browsers.
From the official documentation:
As seen above, we can either turn the animations for the entire workbook (upper red box), or only for the current sheet ( lower red box )
1) Simultaneous animations
The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.
2) Sequential animations
Sequential animations take more time but make complex changes clearer by presenting them step-by-step.
質問 54
A union of two tables usually results in an
- A. increase in the number of columns
- B. decrease in the number of columns
- C. increase in the number of rows
- D. decrease in the number of rows
正解: C
解説:
From the official Tableau documentation:
You can union your data to combine two or more tables by appending values (ROWS) from one table to another. To union your data in Tableau data source, the tables must come from the same connection.
質問 55
Which of the following 2 fields CANNOT be deleted in Tableau?
- A. Number of Records
- B. Measure Names
- C. Calculated Fields
- D. Measure Values
正解: B,D
解説:
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.
質問 56
For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.
- A. Hierarchical
- B. Manual
- C. Random
- D. Topological
正解: B
解説:
Explanation
For a manual sort, no matter how the data changes, the values will always stay in the sort order you kept stuff in.
From the official website:
質問 57
......
有効なTDS-C01試験 最新問題で2022年最新の学習ガイド：https://www.jpntest.com/shiken/TDS-C01-mondaishu
トップクラスTableau TDS-C01試験最先端学習ガイド！練習問題バージョン：https://drive.google.com/open?id=1CXkR3nFWzv9v1gUsYUttg9qT-3K9OwBV