Tableau Connecting & Preparing Data 5

Question 1

Which data role does Tableau assign to a field shown with a globe icon?

Accepted Answer

Geographic role

Answer

Currency role

Answer

Boolean role

Answer

Date role

Question 2

How does Tableau distinguish dimensions from measures in the Data pane by default?

Accepted Answer

Dimensions are blue, measures are green

Answer

Dimensions are red, measures are yellow

Answer

Both are grey

Answer

By alphabetical order only

Question 3

What does changing a field's data type from string to date enable?

Accepted Answer

Date-based functions, hierarchies, and continuous axes

Answer

Faster text searching only

Answer

Removal of null values

Answer

Automatic joins

Question 4

What is the role of the primary key when joining tables to avoid duplicated rows?

Accepted Answer

It uniquely identifies each row to prevent unintended row multiplication

Answer

It sorts the data alphabetically

Answer

It compresses the extract

Answer

It hides null values

Question 5

Which approach lets you connect to data without writing custom SQL, using a visual canvas?

Accepted Answer

Drag tables onto the data source canvas

Answer

Manually type all queries

Answer

Edit the .hyper file directly

Answer

Use only the command line

Question 6

What does Custom SQL allow in a Tableau connection?

Accepted Answer

Defining a specific query to shape the data at the source

Answer

Disabling all extracts

Answer

Creating dashboards automatically

Answer

Encrypting the workbook

Question 7

Why should null values be addressed during data preparation?

Accepted Answer

They can distort aggregations and joins if left unhandled

Answer

They always speed up queries

Answer

They are automatically deleted by Tableau

Answer

They convert measures to dimensions