태블로 문제 유형 정리 - Part 2

Q.Which of the following is not a Trend Line model?

A. Linear Trend Line
B. Exponential Trend Line
C. Binomial Trend Line
D. Logarithmic Trend Line

 

answer : c

이외에도 polynomial 다변수함수랑 Power 제곱 등이 있다.

---

Q. The aggregation function attr() returns a * when __________________.

 

A. There is a single value for all rows in the group.
B. It is a null value.
C. There are more than one value in all rows in the group.
D. The data is not present at the desired level..

 

answer : C

 

Tip : 

특성(ATTR) 함수의 작동 방식 및 MIN 또는 SUM 같은 다른 집계와의 차이점

 

ATTR()은 뷰(예: 막대, 원, 셀 등)에서 단일 파티션으로 그룹화되는 기초 데이터의 각 레코드에서 모든 값을 비교합니다. 값이 모두 동일하면 ATTR()은 해당 값을 반환합니다. 그렇지 않으면 ATTR()은 별표를 반환합니다.

 

ATTR 함수는 필드 내의 모든 멤버를 평가하고 1) 필드 내에 단일 값만 있거나(MIN = MAX) 2) 모든 멤버가 동일한 경우(MIN = MAX) 값을 반환하고 그렇지 않은 경우 "*"를 반환합니다. 이는 "필드 내에 둘 이상의 값이 있음"으로 해석될 수 있습니다. 

 

---

Q. Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser?

 

A. True, with the use of Tableau Server
B. True, with the use of a Web Page object
C. False, not possible
D. True, requires a plug-in

 

answer : B. True, with the use of a Web Page object

 

---

Q. Live vs. extracts data connection

 

LIVE
- changes will be shown automatically
- creates slower performance for huge data
- Server availability could be a problem
- Best to use when numbers HAVE to be correct

EXTRACT
- creates a static snapshot of your data
- better performance and portability
- save and refresh the snapshot
- best to use when numbers aren't as important

 

---

Q. How to save metadata properties in a .TDS

 

 

방법

1. go to the sheet
2. right click on the data source
3. select 'Add to Saved Data Sources'
4. make sure the end of the file ends in .TDS

• 추가 설명
• 통합 문서(.twb) - Tableau 통합 문서 파일의 파일 확장명은 .twb입니다. 통합 문서에는 하나 이상의 워크시트와 0개 이상의 대시보드 및 스토리가 포함됩니다.
• 책갈피(.tbm) - Tableau 책갈피의 파일 확장명은 .tbm입니다. 책갈피는 단일 워크시트를 포함하며 작업을 빠르게 공유하는 편리한 방법입니다. 자세한 내용은 책갈피 저장(링크가 새 창에서 열림)을 참조하십시오.
• 패키지 통합 문서(.twbx) - Tableau 패키지 통합 문서의 파일 확장명은 .twbx입니다. 패키지 통합 문서는 지원되는 로컬 파일 데이터 및 배경 이미지와 함께 통합 문서를 포함하는 단일 zip 파일입니다. 이 형식은 원본 데이터 액세스 권한이 없는 다른 사람들과 공유하기 위해 작업을 패키지하는 최상의 방법입니다. 자세한 내용은 패키지 통합 문서를 참조하십시오.
• 추출(.hyper 또는 .tde) – 추출을 만들 때 사용된 버전에 따라 Tableau 추출의 파일 확장명은 .hyper 또는 .tde일 수 있습니다. 추출 파일은 다른 사용자와 데이터를 공유하는 경우, 오프라인으로 작업해야 하는 경우 및 성능 향상을 위해 사용할 수 있는 하위 집합 또는 전체 데이터의 로컬 복사본입니다. 자세한 내용은 데이터 추출을 참조하십시오. (내 컴퓨터에 안에 저장되는 내용)
• 데이터 원본(.tds) - Tableau 데이터 원본 파일의 파일 확장명은 .tds입니다. 데이터 원본 파일은 자주 사용하는 원본 데이터에 빠르게 연결하기 위한 바로 가기입니다. 데이터 원본 파일은 실제 데이터가 아니라 실제 데이터에 연결하는 데 필요한 정보와 기본 속성 변경, 계산된 필드 만들기, 그룹 추가 등 실제 데이터를 기반으로 수행한 모든 수정 내용을 포함합니다. 자세한 내용은 데이터 원본 저장를 참조하십시오.
• 패키지 데이터 원본(.tdsx) - Tableau 패키지 데이터 원본 파일의 파일 확장명은 .tdsx입니다. 패키지 데이터 원본은 위에서 설명한 데이터 원본 파일(.tds)뿐만 아니라 추출 파일(.hyper 또는 .tde), 텍스트 파일, Excel 파일, Access 파일 및 로컬 큐브 파일과 같은 모든 로컬 파일 데이터도 포함하는 zip 파일입니다. 이 형식을 사용하면 컴퓨터에 로컬로 저장된 원래 데이터에 액세스할 수 없는 다른 사람과 공유할 수 있는 단일 파일을 만들 수 있습니다. 자세한 내용은 데이터 원본 저장를 참조하십시오.

 

---

Q. When is it best to use a blend?

 

answer : 

1. Cross-database join is not supported
2. Tables are at different LOD
3. Joins create duplicate data or data cleaning is required
4. If you have a lot of data and the join is time consuming

 

 

LOD에 대한 추가 설명 : 잘 설명되어 있다.

https://help.tableau.com/current/pro/desktop/ko-kr/calculations_calculatedfields_lod.htm

세부 수준 식

---

Q. How do you rename a data field?

 

answer : Right click on the data field and select 'rename'

---

 

Q. [노가다 문제] How to assign an alias to a data value?

 

answer : Right click a dimension and select 'Aliases". In the edit aliases dialog box, under value, select a member and enter a new name

 

---

Q. [노가다 문제] How to assign a geographic role to a data field?

answer : click the data type icon next to the field and select 'geographic role'.
then select the geographic role you want to assign to that field

---

Q. Change data type for a data field (number, date, string, boolean, etc)

 

answer :

A. On the data source page, click on the icon associated with the field and select the new data type
B. In the data pane, if you right click on the field and scroll down to 'change data type'

 

 

Tip : data source page란?

 

 

데이터 연결을 위해서, 테이블간 relation이나 cell의 값들을 한눈에 파악할 수 있는 공간

 

 

 

B. In the data pane, if you right click on the field and scroll down to 'change data type'

---

Q. [노가다 문제]Change default properties for a data field (number format, aggregation, color, date, format, etc)

 

 

answer : In the data pane, right click on the field, scroll down to 'default properties' and change the desired value

 

 

 

---

Q. How to create a visual group?

 

 

answer  :

Control click all of the fields you want created in the group.
Right click on these values and select the group button

 

관련 영상 :

https://www.google.com/search?q=tableau+create+a+visual+group&ei=p7ThYYu-OsWtoATQkqbQDA&oq=tableau+visual+group&gs_lcp=Cgdnd3Mtd2l6EAMYADIICAAQBxAeEBMyBAgAEBMyBggAEB4QEzIICAAQCBAeEBM6BwgAEEcQsAM6CAgAEAgQDRAeOggIABANEAUQHjoKCAAQDRAFEAoQHjoGCAAQBxAeOgUILhCABDoICAAQCBAHEB46CAgAEAcQBRAeOggIABANEB4QEzoKCAAQCBAHEB4QE0oECEEYAEoECEYYAFCmGFjFJGD9MmgDcAB4AIABdogBtQqSAQQwLjEymAEAoAEByAEKwAEB&sclient=gws-wiz#kpvalbx=_wLThYfizEY2Y-AbOo6fQCg21 

tableau create a visual group - Google 검색

---

Q. [단순 암기]How to create a group using labels?

A.Right click on the field you would like to be grouped, click on 'create' and then 'group'. Be sure to select 'include other'

---

Q. [난이도 상] How to create a set?

 

 

answer  :

For a static set, select all fields you want included in the set from the view, right click and select 'create set'

For a dynamic set, right click on the field you want to create a set for, scroll down to 'create' and select 'set'

 

---

Q. [단순 암기] Which of the following URL prefixes are permitted when creating a URL Action in Tableau?

 

A. FTP

B. SMTP

C. HTTPS

D. HTTP

 

answer : FTP, HTTPS, HTTP

추가적으로,

- http, https, ftp, mailto, news, gopher, tsc, tsl, sms, tel, file

- Tableau Desktop은 C:\Example folder\example.txt와 같은 로컬 경로도 지원함

 

---

Q. Which of the following programming languages do you need to know to use a quick Table Calculation?

 

A. Python

B. Java

C. JavaScript

D. None of the above

 

Answer : D

 

---

Q. How many measures do we need for Bullet Graph?

A. 3

B. 1

C. 2

D. 4

answer : C

---

Q. [단순 암기] Which is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

A. Tableau Packaged Workbook

B. Tableau Workbook

C. Tableau Data Extract

D. Tableau Data Source

answer : C, tde 라고 불린다

 

정보 : 

snapshot 이란, 마치 사진 찍듯이 특정 시점에 스토리지의 파일 시스템을 포착해 보관하는 기술을 의미

 

---

Q. [단순 암기]

When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

A. Red, Blue

B. Orange, Blue

C. Blue, Orange

D. Blue, Red

answer : C , blue ,orange

 

---

Question. [단순 암기] If you decide you want to see all of the marks in the view at the most detailed level of granularity, what will you do to the view?

 

A. aggregate

B. disaggregate

C. sort

D. split

 

answer : B. disaggregate

Explanation -
Disaggregating your data means that Tableau will display a separate mark for every data value in every row of your data source.

---

Question. [다수 문항 답변] You may create a context filter to:

 

A. To replace a data source filter

B. To create a dependent filter

C. Improve performance

D. Create a dependent numerical or top N filter

 

answer :

c.improve performance,

d.create a dependent numerical or top N filter

Tableau context filters allow you to cut down the amount of data that flows into your viz, which can help improve performance.

---

Q. [단순 암기] For a relative date filter, the default anchor is?

 

A. The current time

B. Today's Date

C. The target date

D. The date we specify

 

answer : B. Today's Date

 

Relative date filters make it easy to create views that always show the most recent data.

---

Question. [난이도 하]Which data type in Tableau does this icon represent?
T|F

 

A. String

B. True or False

C. Boolean

D. Geographic

 

answer : C. Boolean

In terms of performance, Boolean is as good as it gets.

---

Question. [단순 암기] Measures placed in a view are aggregated by?

 

A. COUNT

B. MEDIAN

C. SUM

D. AVERAGE

 

answer : C. SUM

Sum function returns a value such as -1.42e-14 for a column of numbers that you know should sum to exactly 0

기본적으로 덧셈으로 집계가 이루어지는데, 태블로 공식 사이트에서는,

The measures are automatically aggregated as sums. The default aggregation (SUM) is indicated in the field names.

 

---

Question. [단순 암기] Maximum numbers of tables in Tableau we can join?

 

A. 12

B. 64

C. 32

D. 128

 

answer : C. 32

The maximum number of 32 tables can be joined in Tableau. A table size must also be limited to 255 columns (fields).

 

32 테이블 : 최대 결합 가능한 테이블

255 열 : 테이블 최대 사이즈 (2의 8승은 256인데 여기서 1뺸 값!!)

 

---

Question. [단순 암기, 난이도하]How do you identify a continuous field in Tableau?

 

A. It is identified by a blue pill in the visualization

B. It is identified by a green pill in a visualization

C. It is preceded by a '=#'symbol in the data window

D. It is preceded by a 'ABc' symbol in the data window

 

 

answer : B. It is identified by a green pill in a visualization

 

추가적으로, 태블로에서 숫자와 정수에 대해서 표현하기 위해, 특수문자들을 사용한다.

 

the equals sign (=) there means that the field is a calculated field that the user has created. The number sign (#) means that the field has a numeric data type.

 

As another example, you'll also see ones that say "=Abc" next to them. This means that the field is a calculated field that's a string.

---

Question. [단순 암기] Which of the following are interactive elements that can be added to a dashboard for users?

A. URL Action

B. Filter Action

C. Highlight Action

D. Edit Tooltip Action

 

answer : A, B, C 

---

Question. [암기] Which of the following are valid ways to copy a worksheet visualisation as an image?

 

A. By simply clicking Control + V on the keyboard

B. By clicking on Worksheet in the Tableau Main Menu above,and choosing Copy->Image

C. Using the Marks shelf and choosing Copy->Image

D. By right clicking on the worksheet visualisation and selecting Copy->Image

 

answer : B, D

To create an image file you can reuse, export the view rather than copy it. You can choose BMP, JPEG, or PNG format on macOS, with the additional option of EMF on Windows. Note, however, that EMF format substitutes Tableau fonts

---

Question. [난이도 하] What is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don’t allow relationships or joins

A. Data segregation

B. Data Blending

C. Data joining

D. Union

 

answer : B

Data blending in Tableau is the operation of combining multiple data sources into the same view by finding common fields between them to join on.

---

Question. [난이도 하]

What would you use to connect to multiple tables in a single data source at once

A. A Blend

A Hierarchy

A Set

A Join

answer : D. a join

---

Q. To connect Tableau to a CSV data source what type of connection should you use?

Spatial

Text

Excel

JSON

 

ans. text

---

Q. [실습 문제]

Find which customer had the LEAST sales in this set if you are creating a Set containing Customer Names whose Sales are GREATER than 30,000.

answer. 하는 방법 참고 : https://www.exam4training.com/which-customer-had-the-least-sales-in-this-set/

Which customer had the LEAST sales in this set? - Exam4Training

---

Q.The icon associated with the field that has been grouped is a?

Paper Clip

Globe

Intersection

=#

ans: paper clip

---

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

Loads your actual file into Tableau

Creates an extract of the data

Sorts the data in descending order

Creates a live connection to the data

 

ans. d. Creates a live connection to the data

---

Question. [난이도 상] Which of the following is NOT a new feature introduced in Tableau 2020.1?

Set Control

Buffer Calculations

Dynamic Parameters

Viaz Animations

 

Ans. a. set control

---

 

Q. How can Data blending simulates a traditional Join?

Left

Inner

Full Outer

Right

 

ans. A. Left

---

Q. [난이도 상] Which of the following charts types always includes bars sorted in descending order?

A. Pareto Chart

B. Pie Chart

C. Gantt Chart

D. Stacked Bar Chart

 

ans. A. Pareto Chart

Explanation -
A Pareto Chart, named for Vilfredo Pareto, is a dual-axis combination chart used to highlight dimension members that are having the biggest impact to the measure in question. On the primary axis, bars are used to show the raw quantities for each dimension member, sorted in descending order.

---

Q.We can use which service as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.

 

Tableau Reader

Tableau Online

Tableau Server

Tableau Desktop

 

ans. Tableau Reader

Tableau Reader is a free desktop application that you can use to open and interact with data visualizations built in Tableau Desktop.

---

Q. [문제 똑바로 읽기, 날씨에 관한 것] Dates in Tableau are typically treated as?

 

A. JSON

B. Tableau Form

C. Dimensions

D. Measures

 

ans. C. Dimensions

Dimensions affect the level of detail in the view. Measures contain numeric, quantitative values that you can measure. Measures can be aggregated.

 

---

Q. [하이퍼링크의 액션은 URL!!] Action which is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.

Go to Hyperlink

Go to URL

Go to Web page

Go to sheet

 

answer : B. Go to URL

---

Q. [핵심만 보기!]

Which of the following is a good reason for using a bullet graph?

 

A. Comparing the actual sales against the target sales

B. A bullet chart is a variation of Bar chart

C. Tableau visualizes estimated future values of the measure

D. Displaying the year-on-year growth

 

ans. A. Comparing the actual sales against the target sales

---

Q. [난이도 하, 핵심인것!] Which of the following are benefits of using Data Extracts in Tableau?

A. Performance

B. Portability

C. Working with freshest data at all times

D. Pre-aggregations

 

ans. A,B,D

To work with the MOST up-do-date data, use a live connection instead.

 

Pre-aggregations

---

Q. [간단한 사용법] A Tableau Support case can be opened in which of the following valid ways?

A. Using the Developer Community Forum

B. Contacting Salesforce using their website

C. Using the support option on the Tableau website

D. Using the Tableau learn website

 

ans. C. Using the support option on the Tableau website

---

Q.[단순 암기 및 실습] Which of the following Device options are available in the Device Preview section, when you are creating a dashboard for multiple devices

A. Phone,Desktop, Tablet,Laptop

B. Default,Desktop,Tablet, Phone

C. Monitor,Default,Phone,Tablet

D. Phone,Monitor,Laptop,Default

 

ans. B.Default,Desktop,Tablet, Phone (데탑,태블릿,폰)

---

Question. [난이도 하]

How can you organise your data in Tableau?

A. Data cleaner

B. Data manager

C. Data interpreter

D. Data organiser

 

answer. C. Data interpreter

Explanation -
The Data Interpreter is a feature when connecting to Excel files. It is designed to help identify the structure of the data in the Excel file and turn it into the proper format for analysis in Tableau.

---

Question.[하]

Which of the following will easily satisfy your requirement if you created a histogram and now want to be able to change the size of bins dynamically.

A. Groups

B. Parameters

C. Calculations

D. Sets

 

Ans. B. Parameters

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.

---

Q. What Dimensions containing values cannot be continuous?

A. Date

B. Boolean

C. String

D. Date and Time

 

Ans. B,Boolean / C. String

---

Q. Which of the following filters is applied FIRST, according to Tableau's 'Order of Operations'?

 

A. Dimension Filter

B. Extract Filter

C. Measure Filter

D. Context Filter

 

Ans. B

테이블의 작동 순서 기억하기

Extract > Data Source Filter > Context Filter > Dimension Filter > Measure Filter > Table Carc Filter

---

Question. [하]

Which server enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

 

A. Tableau Server

B. Tableau Prep

C. Tableau Public

D. Tableau myServer

 

Answer. A.Tableau Server

---

Q. Which of the following would you use to edit the Shape, colour, and Text of your visualisations?

Data Pane

Marks Card

Analytics Pane

Filter Shelf

---

Question. Minimum amount of RAM recommended for any production use of Tableau Server?

8GB

16GB

32GB

128GB

---

Question. [하] What will you use for the members so that they will see their labels appear in a different way?

A. aliases

B. duplicates

C. renames

D.copies

Answer. A.aliases

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.

---

Question.

[??]What do we use for creating variable sized bins?

 

A. Calculated Fields

B. Table Calculations

C. Sets

D. Groups

 

Ans. A

Calculated fields allow you to create new data from data that already exists in your data source.

---

Q. Tableau auto-generates at what dimension(s) and how many measure(s) for us

1,4

2,2

2,3

5,4

 

Ans. 1,4

---

Q. Which of the following filters would you use, when you want to first apply a filter and THEN show the Top N or Bottom N elements?

Data source Filter

Extract Filter

Context Filter

none of these above options

 

ans. C. context filter

- 변수를 생성하는 것이 포함된다

 

---