태블로 문제 유형 정리 - Part1

 

---

 

---

 

---

 

A

---

 

 

---

 

Question Type: Single Choice

Which of the following is a benefit of using a Tableau Data Source (.tds)?

Options:

A   To hold one or more worksheets, plus zero or more dashboards and stories.

 

B   To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc

 

C   To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.

 

D   To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

 

Answer: B

 

Explanation:

The following are the official definitions from the Tableau documentation for the various file types:

1) .tds (Tableau Data Source) - To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc. (CORRECT ANSWER)

 

2) .twbx ( Tableau packaged workbook) - To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.

 

3) Extract (.hyper or .tde) -- To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

 

3) (.twb) Workbooks -- To hold one or more worksheets, plus zero or more dashboards and stories.

 

 

---

Question Type: Single Choice

If you have a dashboard and are displaying its filter, how can you rearrange it?

Options:

A   By clicking on the 2 lines on top and dragging the filter.

B   By clicking on the dropdown and dragging the filter

C   By clicking on the filter title and dragging it.

D   By clicking anywhere inside the filter and dragging it.

 

Answer: A

 

Explanation:

You can drag the filter by clicking on the 2 lines on top, and then dragging the filter as shown:

 

 

---

 

Question Type: Multiple Choice

Which of the following can you add a reference line to?

Options:

A   Groups

B   Calculated Fields

C   Measures

D   Dimensions

 

 

Answer: B, C

 

Explanation:

You can add reference lines, bands, distributions, or (in Tableau Desktop but not on the web) box plots to any continuous axis in the view.

Reference Lines - You can add a reference line at a constant or computed value on the axis. Computed values can be based on a specified field. You can also include confidence intervals with a reference line.

 

 

 

---

True or False :

 

Bins can be created on dimensions

 

A. False

B. True

 

 

Answer: B

 

Explanation: Bin are a user-defined grouping of numerical data in the data source. According to the official Tableau documentation: It's sometimes useful to convert a continuous measure (or a numeric dimension) into bins. Have a look at the following image. When we right click a measure, we get the following options:

 

연속형 측정값(또는 숫자 차원)을 구간차원으로 변환 - 구간차원으로

 

---

하이라이트 테이블 

하이라이트 테이블이란, 이름에서도 알 수 있듯이 테이블 형태를 색상으로 구분해서 보는 시각화

 

True or False: 

The Highlighting action can be disabled for the entire workbook.

A. True
B. False

 

Answer: A

Explanation:
Yes, it is possible to disable highlighting for the entire workbook.

 

 

 

Highlighting action

하이라이팅 액션

Highlight actions allow you to call attention to marks of interest by coloring specific marks and dimming all others. You can highlight marks in the view using a variety of tools. For example, you can manually select the marks you want to highlight, use the legend to select related marks, use the highlighter to search for marks in context or create an advanced highlight action.

 

특정 데이터에 강조를 주고 싶은 경우에 사용한다

 

---

 

Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)? A. Yes

B. No

 

Answer: A

 

충분히 가능하다.

 

---

Question: 

By definition, Tableau displays measures over time as a ____________

 

A. Packed Bubble

B. Bar

C. Stacked Bar

D. Line

 

Answer: D

 

---

Question: 

Which of the following would you use to connect to multiple tables in a single data source at once?

 

A. A Blend

B. A Hierarchy

C. A Set

D. A Join

 

Answer: D

 

Explanation:

The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data. For example, consider the following two tables originating from a single data source:

 

 

 

 

We can combine these 2 tables, simply by joining the tables on ID to answer questions like, "How much was paid in royalties for authors from a given publisher?". By combining tables using a join, you can view and use related data from different tables in your analysis.

 

 

---

Question: 6

What is the minimum amount of RAM recommended for any production use of Tableau Server?

 

A. 8GB

B. 16GB

C. 32GB

D. 64GB

 

Answer: C

 

Explanation: The computer on which you are installing or upgrading Tableau Server must meet the minimum hardware requirements. If the Setup program determines that your computer does not meet the following requirements, you will not be able to install Tableau Server. These minimum requirements are appropriate for a computer that you use for prototyping and....

 

2가지가 존재

 

1)테스트 및 프로토타입에 대한 최소 하드웨어 요구 사항

(참고로, 코어 수는 "물리적" 코어 수 기반으로, 물리적 코어 수는 실제 서버 하드웨어나 가상 컴퓨터(VM)의 코어 수를 나타낼 수 있는데, 코어 수 계산에서 하이퍼스레딩은 무시한다고 한다)

 

 

 

2) 최소 하드웨어 권장 사항

설치 유형프로세서 CPU RAM디스크의 여유 공간

단일 노드	64비트(x64 칩셋) SSE4.2 및 POPCNT 명령 집합을 지원해야 함 ARM 기반 프로세서는 지원되지 않음	8개 코어, 2.0GHz 이상	32 GB	50 GB
	Tableau Prep Conductor를 Tableau Server 설치에 추가하는 경우 두 번째 노드를 추가하고 이 노드를 실행 중인 Tableau Server Prep Conductor에 전용으로 사용하는 것이 좋습니다. 이 노드에는 최소 4개의 코어(8개 vCPU)와 16GB RAM이 있어야 합니다.
다중 노드 및 엔터프라이즈 배포	기술 지원이 필요한 경우 Tableau에 문의하십시오. 노드는 다음을 제외하고 최소 하드웨어 권장 사항을 충족하거나 초과해야 합니다. 백그라운더를 실행하는 노드는 4개 코어가 적합할 수 있습니다. Tableau Prep Conductor 전용 노드: 최소 4개의 코어(8개 vCPU) 및 16GB RAM.

 

 

태블로 서버 관련 자세한 설명은 해당 링크 참조 : 

- 잘 정리되어 있고, 실제 현업에서 어떻게 활용하는지 참고하기!! 좋은 자료여서 공유!!

https://www.youtube.com/watch?v=AnWcmUQ1nNk&ab_channel=Data-drivenmarketing%2C%EB%B0%80%EB%B2%84%EC%8A%A4 

---

What does Tableau do when you connect to a data source?

a - Loads your actual file into Tableau

b - Creates an extract of the data

c - Sorts the data in descending order

d - Creates a live connection to the data

 

answer - d

 

---

Which of the following chart type makes use of 'binned' data?

 

A. Gantt Chart
B. Bullet chart
C. Histogram
D. Treemaps

 

Answer: C

 

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.
Reference:

---

추가설명 : 

 불릿 그래프(Bullet Chart, 총알 차트)

 

 불릿 그래프(Bullet Chart, 총알 차트)는 실적 데이터를 표현하기 위한 최적의 시각화로 막대 그래프와 유사하게 생겼으나, 타겟 대비 현재 얼마나 목표에 달성했는지 보여주기 위한 목적으로 사용한다. 불릿 그래프와 유사하게 실적 데이터를 표현하는 방식에는 게이지 차트(Gauge chart)가 존재한다. 불릿 그래프는 게이지 차트에 비해 화면을 경제적으로 사용할 수 있다는 면에서 장점을 가질 수 있다. Severino Ribecca는 <그림 1>과 같이 불릿 그래프의 정의를 구체적으로 제시하며, 키워드와 키워드의 빈도를 기반으로 시각화를 한다.

&lt;그림 1&gt; Severino의 불릿 그래프 구조도&gt;

 

bullet 차트 설명 출처: https://jaydata.tistory.com/60 [Data & Graph]

 

 

트리맵에 대한 설명

 

트리맵(Treemap)은 측정값이 어떻게 구성되어 있는지를 보여주기 위한 목적으로 사용한다. Severino Ribecca는 <그림 1>과 같이 트리맵의 정의를 구체적으로 제시하며, 트리 구조 시각화를 다른 방식으로 표현하는 시각화라고 한다. 각 각의 영역은 카테고리별로 측정값의 크기를 나타낸다.

<그림 1> Severino의 트리맵 구조도

출처: https://jaydata.tistory.com/57 [Data & Graph]

---

True or False: Trend lines can only be used with numeric or date fields
A. True
B. False

 

answer : A

 

---

Which of the following is the best reason to use an extract instead of a live connection?

 

a. Your data source only supports a live connection via ODBC.
b. You need the freshest possible data at all times.
c. You need to apply an aggregation that takes too long when using a live connection.
d. You need to join tables that are in the data source.

 

answer : c. You need to apply an aggregation that takes too long when using a live connection.

---

You created a group by selecting field labels in a view. How can you remove members from the group?

a. In the view, right-click the group members you want to remove and select Exclude.
b. In the Data pane, right-click the group and select Edit Group.
c. In the view, right-click the group members you want to remove and select Format.
d. On a color legend, right-click a member you want to remove and select Format legends.

 

answer : b

 

[노가다 문제] 실행해서, 직접 해보면 쉬움

 

Tip :
그룹은 하나의 차원을 선택하고, 데이터 값을 분류하기 위해 사용하는 것으로서,

예를들어, 국가/지역 필드를 선택하고 , 한국을 선택하고 '대한민국'으로 하고, 나머지 나라들에 대하여 '기타'라고 설정할 수 있음

 

 

---

[난이도 상] Question :

Which of the following can you use to create a calculated field that returns data independent of the data granularity in a view?( 데이터 알갱이)

a. An INCLUDE LOD calculation
b. A table calculation
c. A basic calculation
d. A FIXED LOD calculation

 

answer : d. A FIXED LOD calculation

---

[난이도 하, 단순암기] Question :

Interactive elements that you can add to a dashboard for users include ______. (Select all that apply.)

a. URL actions
b. edit tooltip options
c. filter actions
d. hide and unhide all sheet options

e. highlight actions

 

answer : a,c,e

---

[난이도 하]

A field that shows average home values for the United States in 2016 is most likely:

a. A discrete date part dimension
b. A continuous date value dimension
c. A geographical dimension
d. An aggregated measure

 

answer : d. An aggregated measure

---

A Reference Band cannot be based on two fixed points.

 

False
True

 

answer  :  False

 

---

A Reference Distribution plot cannot be along a continuous

True
False

 

answer : False, A Reference Distribution plot can be along a continuous axis.

---