Tableau Desktop Specialist Exam Practice Questions - Part 1 | Become a Certified Tableau Developer

Summary

This YouTube video introduces a series on Tableau Desktop certification, offering tips and study materials for exam success. The script covers exam details, including the structure of 45 multiple-choice questions, time limits, scoring, and fees. It delves into the exam's four domains, focusing on 'Connecting to and Preparing Data' with topics like live vs. extract connections, metadata, and data relationships. The video promises a question-by-question breakdown in subsequent episodes, aiming to clarify concepts and boost certification chances.

Takeaways

• 😀 The video is part of a Tableau Desktop Certification series aimed at sharing tips and tricks for exam success and providing study material.
• 📚 Viewers are encouraged to subscribe to the channel and hit the Bell icon for updates on future videos.
• ⏱ The exam consists of 45 multiple-choice and multiple-select questions with a time limit of 60 minutes and a passing score of 750 out of 1000.
• 💰 The exam's registration fee is $100 plus GST.
• 👩‍💻 The target audience is individuals with at least 3 months of experience using Tableau Desktop.
• 🔑 The certification, once obtained, does not expire and is valid for a lifetime.
• 📈 The exam is divided into four domains, with varying numbers of questions expected from each.
• 🔍 Domain one focuses on connecting to and preparing data, with topics such as live versus extract connections, metadata, and data relationships.
• 📝 The video series will discuss 20 questions per video, aiming to cover as many as possible to assist viewers in passing the exam.
• 🔑 The first question of the series addresses when to use data blending to combine data, with the correct answer being when using data sources that cannot be combined with the default method of using a relationship.
• 🔄 The difference between live and extract connections is highlighted, with live allowing real-time data and extract requiring periodic refreshes.
• 🚫 Direct connections to extracts are not recommended due to various limitations, such as inability to refresh and potential data model loss.

Q & A

What is the primary purpose of the certification series discussed in the video?

The primary purpose of the certification series is not only to help viewers clear the certification exam but also to gain knowledge and skills related to Tableau Desktop.

How many questions are there in the Tableau Desktop certification exam?

There are 45 questions in the Tableau Desktop certification exam, which are in the form of multiple-choice and multiple-select items.

What is the time limit for completing the Tableau Desktop certification exam?

The time limit for the Tableau Desktop certification exam is 60 minutes.

What is the passing score for the Tableau Desktop certification exam?

The passing score for the Tableau Desktop certification exam is 750 out of 1000.

What is the registration fee for the Tableau Desktop certification exam, including GST?

The registration fee for the Tableau Desktop certification exam is $100 plus GST.

Who is the target audience for the Tableau Desktop certification exam?

The target audience for the Tableau Desktop certification exam are individuals who have skills with Tableau Desktop and a minimum of 3 months of experience.

How many domains are there in the Tableau Desktop certification exam, and what are they?

There are four domains in the Tableau Desktop certification exam: 1) Connecting to and preparing data, 2) Exploring and analyzing the data, 3) Sharing insights, and 4) Understanding Tableau Concepts.

What is the focus topic for Domain 1: Connecting to and preparing data in the certification exam?

The focus topics for Domain 1 include live versus extract, what happens when you connect to the data, metadata, table extensions, relationships versus joins versus blends, and multiple ways to rename a field, among others.

What is the correct answer to the question 'When should you use data blending to combine data?'

The correct answer is when using data sources that cannot be combined with the default method of using a relationship.

What are the differences between live and extract connections in Tableau Desktop?

Live connections allow real-time data and work directly with the data source, reflecting any changes made to the dataset. Extract connections create a subset of the data that needs to be refreshed periodically. Live connections take more time to load data compared to extract connections.

Why are direct connections to the extract not recommended in Tableau Desktop?

Direct connections to the extract are not recommended because table names will be different, the extract cannot be refreshed, and the data model and relationships will be lost.

How many data sources can be blended in Tableau Desktop?

In Tableau Desktop, you can blend two data sources, creating a primary and a secondary dataset.

What is the advantage of using relationships to combine tables in Tableau Desktop?

The advantages of using relationships to combine tables include making it easier to analyze data across multiple tables at different levels of granularity and ensuring that tables are only queried when fields from the tables are added to the views.

What happens when you assign a Geographic role to a field in Tableau Desktop?

When you assign a Geographic role to a field in Tableau Desktop, the software adds two fields: latitude and longitude.

What are the options available while creating an extract in Tableau Desktop?

The options available while creating an extract in Tableau Desktop include filters, aggregation, number of rows, hide unused fields, and history and data storage.

Outlines

00:00

📚 Introduction to Tableau Desktop Certification Series

The script introduces a new series on the YouTube channel dedicated to Tableau Desktop certification. The host offers to share tips, tricks, and study materials for exam preparation. Viewers are encouraged to subscribe and enable notifications for updates. The certification aims to validate skills and knowledge, with the exam consisting of 45 multiple-choice and multiple-select questions to be completed within 60 minutes. A passing score is 750 out of 1000, with a registration fee of $100 plus GST. The target audience includes individuals with at least three months of experience using Tableau Desktop. The certification, once obtained, does not expire and is valid for life. The video will cover the exam pattern, which is divided into four domains, with the first domain focusing on connecting to and preparing data.

05:01

📝 Exam Details and Domain One Overview

This paragraph delves into the specifics of the certification exam, including the number of questions, types of questions, and the time limit. It outlines the passing score and registration fees. The script then moves on to describe the first domain in detail, which includes topics such as live versus extract connections, metadata, table extensions, relationships, joins, blends, and field renaming. The host plans to discuss 20 questions per video, aiming to cover as many as possible in the series to aid viewers in passing the exam. The first question discussed is about the appropriate use of data blending, with options provided and the correct answer explained.

10:07

🔍 Differences Between Live and Extract Connections

The script continues with a comparison between live and extract connections in Tableau. It explains that live connections allow for real-time data interaction, while extracts are subsets of data that need periodic refreshing. Live connections are said to take more time to load data due to handling full data sets, unlike extracts. The paragraph also addresses misconceptions about live connections not slowing down operations or queries and clarifies that both connections have distinct functionalities. The correct options for the differences between live and extract are identified, with the script guiding viewers on the correct answers to questions about direct connections to extracts and data source details.

15:11

🗺️ Geographic Roles and Data Source Editing

This section of the script discusses the assignment of geographic roles to fields in Tableau, which by default adds latitude and longitude fields. It also covers how to change the data type of a field within a view and add default comments to a field. The script provides step-by-step instructions for these actions. Additionally, it explores the effects of using a union to combine tables, explaining that it typically results in an increase in the number of rows. The paragraph concludes with a question about the color of tick marks for primary and secondary data sources in a blend, revealing the correct answer through a visual example.

🛠️ Managing Metadata and Creating Extracts

The final paragraph of the script focuses on managing metadata in Tableau, which allows users to view hidden fields, field names in the original data source, and to clean and fix issues. It also addresses the automatic assignment of data types and roles when connecting to a data source. The script clarifies that Tableau creates a live connection by default. Lastly, it discusses the options available when creating an extract, such as filtering, aggregating, specifying the number of rows, hiding unused fields, and managing history and data storage. The correct answers for the available options while creating an extract are provided, and the video concludes with a call to action for likes, shares, subscriptions, and staying tuned for future videos.

Keywords

💡Tableau Certification

Tableau Certification is a professional credential offered by Tableau Software that validates one's skills in using Tableau Desktop for data visualization and analysis. In the video, the host is starting a series dedicated to helping viewers prepare for the certification exam, indicating the importance of this certification in the field of data analytics.

💡Multiple Choice and Multiple Select

These terms refer to the types of questions that will appear on the Tableau certification exam. Multiple choice questions have one correct answer, while multiple select items allow for more than one correct answer. The script mentions that multiple select items have more 'verage' than multiple choice, implying they may be more complex or carry more weight in scoring.

💡Time Limit

The 'Time Limit' of 60 minutes is the maximum duration allowed for candidates to complete the Tableau certification exam. This constraint is crucial for exam preparation, as it sets the pace for how quickly one must work through the questions.

💡Passing Score

A 'Passing Score' of 750 out of 1,000 is the minimum score required to pass the Tableau certification exam. This score represents the threshold that candidates must exceed to earn the certification, emphasizing the need for a strong understanding of Tableau Desktop.

💡Registration Fees

The 'Registration Fees' of $100 plus GST is the cost associated with signing up for the Tableau certification exam. This fee is an important consideration for potential candidates who must budget for the exam as part of their certification journey.

💡Target Audience

The 'Target Audience' for the Tableau certification exam is individuals who have skills with Tableau Desktop and a minimum of 3 months of experience. This indicates that the exam is designed for those who have practical experience with the software and are looking to validate their abilities.

💡Exam Pattern

The 'Exam Pattern' refers to the structure of the certification exam, which is divided into four domains. Each domain covers different aspects of Tableau Desktop usage, and the script outlines the approximate number of questions and topics that candidates can expect from each domain.

💡Data Blending

Data Blending is a technique used in Tableau to combine data from different sources when the data cannot be combined using a relationship. The script discusses when to use data blending, such as when using data sources that cannot be combined with the default method of using a relationship.

💡Live vs. Extract Connection

The terms 'Live' and 'Extract Connection' refer to two different ways of connecting to data sources in Tableau. Live connections allow for real-time data interaction, while extract connections involve a subset of data that needs to be refreshed periodically. The script differentiates between these two by explaining their functionalities and implications for data analysis.

💡Metadata

In the context of Tableau, 'Metadata' refers to the information about the data source, such as data type, field names, and other properties. The script mentions metadata in relation to managing and understanding the structure of the data, which is crucial for effective data analysis and preparation.

💡Pivot and Split

Pivot and Split are features in Tableau that allow users to manipulate data fields. Pivoting a field turns it into columns, while splitting divides a field into multiple parts based on certain criteria. These features are essential for reshaping data to fit specific analysis needs, as mentioned in the script.

💡Data Interpreter

The 'Data Interpreter' in Tableau is a tool that helps users understand and prepare data for analysis. It can suggest the best way to interpret the data, such as recognizing dates or numerical values, which is an important step in the data preparation process discussed in the script.

💡Union

A 'Union' in Tableau is a method of combining data from two tables by appending rows from one table to another. The script mentions that a union typically results in an increase in the number of rows, which is an important consideration when merging datasets.

💡Geographic Role

Assigning a 'Geographic Role' to a field in Tableau allows the software to recognize the field as a geographic identifier, such as latitude and longitude. This enables users to perform spatial analysis and visualizations. The script notes that assigning this role adds specific fields to the dataset.

💡Default Properties

In Tableau, 'Default Properties' are the initial settings that apply to a field when it is added to a visualization. These properties can include comments, data types, and other attributes that define how the field behaves and is displayed. The script provides an example of how to add a comment to a field using default properties.

Highlights

Introduction to the Tableau Desktop Certification series, offering tips and study materials for exam preparation.

The certification aims to not only clear the exam but also to gain practical skills.

Details of the exam structure, including the number of questions, question types, and time limit.

The passing score and registration fee for the certification exam.

Target audience for the certification, focusing on individuals with at least 3 months of experience with Tableau Desktop.

The certification is valid for a lifetime once obtained.

Exam pattern divided into four domains with the number of questions expected from each.

Domain one focuses on connecting to and preparing data, with key topics such as live versus extract and metadata table extensions.

Explanation of multiple-choice and multiple-select item questions and their differences.

Discussion on when to use data blending to combine data sources.

Differences between live and extract connections, including their impact on data loading times and refresh.

Reasons why direct connections to extracts are not recommended.

Information stored in Tableau Data Source (TDS) files, including data source type and connection information.

Limitations on the number of data sources that can be blended in Tableau.

The process of adjusting data granularity through aggregation and the use of 'Group by'.

Advantages of using relationships to combine tables in Tableau.

The correct pathway to edit the data source in Tableau.

The creation of aliases for fields and the types of fields that cannot be aliased.

The addition of geographic roles to fields and the default fields added by Tableau.

The method to change the data type of a field within a view.

Adding default comments to a field and the correct pathway to do so.

The effects of using a union on the number of columns and rows in a dataset.

Use cases for managing metadata in Tableau, including viewing hidden fields and the original field names.

The automatic assignment of data type and role when connecting to a data source in Tableau.

Options available when creating an extract in Tableau, such as filters, aggregation, and data storage.

Transcripts

hello guys welcome back to my YouTube

channel today I'm going to start table

desktop certification series here I will

share tips and tricks how to clear the

exam as well as their study material

before starting this video if you have

not subscribed to the channel hit the

Subscribe button and press the Bell icon

for upcoming and interesting videos so

without any further delay let's get

started the purpose of the certification

series is not only to clear the

certification but to gain the not as

well first let's discuss some of the

details of the exam then we will move to

the question so number of the questions

are 45 and these question are multiple

choice and multiple select items

multiple select item question have more

verage than multiple choice we will

discuss both type of question in our

series and the time limit is 60 Minutes

passing scores is 750 out of 1,000 and

registration fees is $100 plus GST

Target target audience target audience

is basically who has skills with tblo

desktop with the minimum of 3 months of

experience okay maintaining

certification so this certification

doesn't expire once you clear this

certification this certification will

valid

lifetime now discuss about the exam

pattern so exam is divided into four

domains so first domain is connecting to

and preparing data you can expect 10 to

11 question from this domain domain two

is exploring and analyzing the data you

can expect 16 to 17 question from this

domain domain three is sharing insights

you can expect 11 or 11 to 12 question

from this

domain understanding T Concepts you can

expect six to seven question from this

domain okay you can expect one or two

question extra or less per domain okay

so today we are going to discuss domain

one domain one is connecting to and

preparing the data you will get 10 to 11

question from this domain so these are

the focus topic for this domain one is

live versus extract so you you can

expect one or two or maybe three

question from this second one is what

happen when you connect to the data this

is like directly mentioned in our

syllabus of the table desktop series and

third one is metadata table extension so

mainly Focus ontd you can expect one or

two question from the table extension

relationship versus join versus blend

you can expect 3 to four or maybe more

question based on relationship versus

join versus blend and then multiple ways

to rename a field alas default

properties data types and how to change

their data type how to access default

properties pivot and split and data

interpreter so these are 11 topics that

are mainly focused in this domain

okay now let's move to our question part

and discuss some of the question one by

one in every video I'm going to discuss

20 question and I'll try to discuss as

much as question I can in this series so

that it would be beneficial for you to

clear the exam the first question of our

series is when should you use data

blending to combine the data let's check

their option when the data has same

structure but is for different time of

period this is wrong because in the data

blending we can connect the data from

different time period as well okay when

data is from same connection this is

also wrong because we use data blending

to connect data from multiple data

sources or multiple connection when the

data will be used in multiple worksheet

within a workbook okay this is also

wrong because for this we can use join

and relationship as well so this is also

wrong and last one is D when using data

sources that cannot be combined with the

default method of using a relationship

this is right one because let's say we

are working uh with the published data

source so with published data source the

only way to combine the data is data

blending okay the answer is

D second one is what is the difference

between live and extract connection

select all that apply let's check their

option live allows realtime data while

extract our kind of batches that needs

to be refreshed from time to time get

the updated data okay this is correct

because live basically work we are

working directly with the data sources

and any changes made to the data set

will be reflect in our database so this

is right and extract our kind of batches

batches is basically subset of the data

that needs to be refreshed so this is

Right Live connection takes more time to

load the data then exct this is also

correct because as we are working with

the live data set or full set of the

data so live take more time to load the

data rather than extract connection okay

A and B are right live connection

doesn't slow down operation queries

which result in fetching data quickly

this is wrong because if we calculate

the time taken by live and extract to

fetch out the data so live takes more

time as compared to extract so C option

is wrong both the connection same time

to work with and they don't have any

functional difference this is also wrong

because live is full subset live is full

data and extract is subset of the data

so this is also wrong so the right

option

is a and

b third one is why are the direct

connection to the extract is not

recommended select all apply the table

names will be different this is right

extract cannot be refreshed this is also

right data model and the relationship

will be R this is also right the extract

connection cannot be removed once it is

connected directly this is wrong for

this let's discuss the official document

of the Tableau to no more about this

option okay so from this article you can

see why we don't connect directly to the

extract table names will be different

you cannot extract the refresh the data

model will be lost okay you can read the

more details about here I will provide

this link in the description box

okay but the right option

is

a b and c okay now next question is data

source. TDS contains only information we

need to connect to the data source

including the following select all apply

so basically in this question we need to

tell which type of information TDS store

okay so it store data source type this

is correct group sets calculated Fields

beans this is also correct connection

information specified on the data source

EX for example data server address Port

location of the file table this is also

right default build properties for

example number format aggregation and so

this is also right okay

so answer

is all

option okay next question is how many

data source can be blend in the table 2

3 4 5 so the right answer is two because

when we connect the data by using data

blending it create two data set that is

one is primary and secondary okay so the

right answer is two in relationship we

need to define the following joint type

inner joint left join right join or it

is not required to define a join in

relationship if you know the answer

please write down in the comment

section right answer is it is not

required to define a joint in

relationship because relationship

doesn't requir a joint to connect the

data okay so the right answer is d

which option leads to adjusting the

granularity of the data in the

table aggregate Group by Group by field

and extract answer is aggregate because

Aggregate and the granularity are

opposite to each other if more

granularity less aggregation less

granularity more aggregation okay so the

right answer

is

a next question is advantage to using

relationship to combine table select all

apply first option is make it easier to

change the key Fields used to combine

the table this is wrong because we can

do this by using data blending as well

so this is not an advantage make it

easier to analyze data across multiple

tables at different levels of grity this

is correct because relationship keeps

both the table as a separated table and

we can analyze both the tables at

different level of granularity okay

makes it easier to combine rows from one

table with rows from another this is

wrong because we can do this by using

Union not with relationship tables are

only quered when fields are from the

tables are added to the Views this is

correct right answer is B and

D next question is select the correct

Pathway to to edit the data source let's

try it how we can edit the data

source go to data then our data source

and then added data source let's check

which option is matching with this data

menu select a data source and added data

source so the right answer is

a alas cannot be created for the

following select all applies options are

discrete Dimension continuous Dimension

measures and dates let's try one by

one so this is discrete Dimension when

we right click on it we are getting the

option so this is wrong and now change

it to continuous we are not getting any

option to change alas so this is right

option let's try on the data as well we

are not getting any option to change the

alas for the date so this is also right

option we can check for for the ship

data as well we are not getting and for

any measures we are not getting okay so

the right answer is b c

d next question is when assigning

Geographic role to a field table adds

two Fields the measures area of the data

pin okay so by default T added five

fields in the tables that is measure

name latitude longitude and here you

sometime you will get order of count

number of rows extract count or order of

count okay and the fifth one is measure

value okay so for but in this question

it is asking for only for Geographic

role so for Geographic role it adds

latitude and longitude so the right

answer is

a

choose the correct path to change the

data type of a field in the view let's

check how we can change the data type of

a field in the

view let's say we want to change it for

customer name right click on it go to

change data type and then select the

data type okay let's check which option

is matching with this right click the

field in the data pen that is common in

all the fields change the data type that

is also matching

and then choose the appropriate data

type so B option is matching if you look

at this there is one extra step data

type that is not available when we check

how to change the data type okay so the

right answer is

B next question is choose the correct

path to add a default commands for a

field let's see how we can add a

commment to a field for this right click

on any field

then go to default properties then go to

comments okay from here you can add the

comments let's say hello and click on

okay you can see when you over on it you

will get the comments okay so let's

check which option is matching right

click a field in the data pen that is

common in all then go to default

properties and then command so a option

is matching so right answer is

a

a union of the two table usually result

in increase in the number of columns

increase in the number of rows decrease

in the number of column decrease in the

number of rows so how a union works so

Union is basically upend the data of the

two tables so right option is increase

in the number of rows that is

B let's move to the next

slide next question is when using a

blend what is the color of the tick mark

on the primary and the secondary data

source respectively options are red and

blue orange and blue blue and red blue

and orange let's check it I have already

added two data

sources let's drag one field from

parametry and one field from secondary

so you can see blue color is assigned to

the primary and the orange assigned to

secondary the right answer is

D next question is valid use case of

managing metadata select all apply

options are to view all hidden Fields

this is correct because by using metata

we can view all the hidden fields from

the dashboards or the worksheets to see

the field name in the original dat so

this is also correct to see the table a

field belong this is also correct to

clean and automatically fix the issue

this is wrong so the right answer is a b

and

c when user connect to table the data

fields in their data set are

automatically assigned a dash and dash

options are type and Rule data type and

value role and type Dimension and

measures the right answer is first W

assign type type and then assign role so

right answer is

a so what are type and role type is

basically data type table assign a

specific data type to each field based

on their data and role is whether it is

discrete or continuous Dimension or

discrete or continuous measure

okay Dash is used to so that labels

appears differently in the so alas by

default what does table do when you

connect to the data so table create a

live connection to the data so if you

notice whenever we connect to the data

TBL automatically connect data to the

live connection okay so the right answer

is create live connection to the data

this question is important because this

is directly mentioned in the

syllabus let's move to the last question

of this video what are the options

available while creating extract select

all apply first let's go and create

extract click on

extract go to addit and you can see we

are getting filter option aggregate

number of rows hide unused field and

history and data storage as well okay

let's see how many options are matching

with

this

filters aggregation hide unused field

and history means all are matching the

right answer

is

all I have not added all in the option

menu because I want you to check all the

option and then select correct options

okay that's it for this video thank you

so much guys if you like the video

please do like share and subscribe and

stay tuned for upcoming parts