Learning Tableau

Home
Practice Quizzes
Blog

Learning Tableau

Accelerate your Career and Get Certified

Specialist Quiz – Connecting to & Preparing Data

Thursday, November 4th, 2021

Welcome to your Specialist Quiz - Connecting to & Preparing Data

How can the users refresh an extract immediately in Tableau desktop? [select all that apply]

a) Select a Data Source on Data Menu -> Extract

b) Select a Data Source on Data Menu -> Extract -> Refresh

c) Sign in to Tableau Server -> Click Tasks at the top of the page -> Under Extract Refreshes select the workbook or data source -> On the Actions menu click Run now.

d) Select a Data Source on Data Menu -> Extension -> Refresh

What is the difference between Live and Extract connections? [select all that apply]Add description here!

a) Live allows real-time data while extracts are kind of batch which needs to be refreshed from time to time to get the updated data.

b) Live Connection takes more time to load data than Extract Connection.

c) Live Connection does not slow down operational queries which results in fetching data quickly.

d) Both the connection takes same time to work with and they do not have any functional difference.

Why the direct connection to the extract is not recommended? [select all that apply]

a) The table names will be different

b) The extract cannot be refreshed

c) The data model and relationships will be lost.

d) The extract cannot be removed once it is connected directly.

Data Source (.tds) contains only the information we need to connect to the data source, including the following: [select all that apply][1.1.4 Save metadata properties in a TDS]

a) Data source type

b) Groups, sets, calculated fields, bins

c) Connection information specified on the data source page; for example, database server address, port, location of local files, tables

d) Default field properties; for example, number formats, aggregation, and sort order

How many data sources can we blend in Tableau?[1.1.5 Create a data source that uses multiple connections]

a) Two

b) Three

c) Four

d) Five

In a Relationship we need to define the following Join type –

[1.2 Create and manage the data model]
[1.2.1 Add relationships to a data source]

a) Inner Join

b) Left Join

c) Right Join

d) It is not required to define a join type in a relationship

Which option leads to adjusting the granularity of data in Tableau?[1.2.2 Add joins and unions]

a) Aggregate

b) Group by

c) Grouped Fields

d) Extract

Advantages to using relationships to combine tables: [select all that apply][1.2.3 Explain when to use a join versus a relationship]

a) Make the data source easier to define, change, and reuse.

b) Make it easier to analyse data across multiple tables at the correct level of detail (LOD).

c) Requires the use of LOD expressions or LOD calculations for analysis at different levels of detail.

d) Only query data from tables with fields are used in the current viz.

Select the correct pathway to edit the data source -

[1.3 Manage data properties]
[1.3.1 Rename a data field]

a) Data Menu -> Select a Data source -> Edit Data Source

b) Data Menu -> Select a Data source -> Extract Data

c) Data Menu -> Select a Data source -> View Data

d) Data Menu -> Select a Data source -> Edit Data Source Filters

Aliases cannot be created for the following – [select all that apply]

[1.3.2 Assign an alias to a data value]

a) Discrete dimension

b) Continuous dimension

c) Measures

d) Dates

While assigning geographic role to a field, Tableau adds two fields to the Measures area of the Data pane:

[1.3.3 Assign a geographic role to a data field]

a) Latitude and Longitude.

b) Meridian and Longitude.

c) Meridian and Latitude.

d) Only Meridian

Choose the correct path to change the data type for a field in the view -

[1.3.4 Change data type for a data field (number, date, string, Boolean, etc.)]

a) Right click the field in the Data pane -> Change Data Type -> Data Types -> Choose the appropriate data type

b) Right click the field in the Data pane -> Change Data Type -> Choose the appropriate data type

c) Right click the field in the Data pane -> Data Types -> Choose the appropriate data type

d) Right click the field in the Data pane -> Choose the appropriate data type

Choose the correct path to add a default comment for a field-

[1.3.5 Change default properties for a data field (number format, aggregation, colour, date format, etc.)]

a) Right click a field in the Data pane-> Default Properties-> Comment

b) Right click a field in the Data pane-> Aggregation -> Default Properties-> Comment

c) Right click a field in the Data pane -> Comment

d) Right click a field in the Data pane-> Describe-> Comment

Time is Up!

Time's up

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

Website

Δ

Download Practice Quizzes

Including step-by-step solutions.

Get All Data Analyst Quizzes
Get All Specialist Quizzes

Data Analyst Practice Quizzes

Hands-on Analysis Quiz 1
Hands-on Analysis Quiz 2
Hands-on Analysis Quiz 3
Knowledge-based Quiz 1
Knowledge-based Quiz 2
Forecasting
Trendlines
Data Manipulation
Calculations
Level of Detail
Joins and Blends

Specialist Practice Quizzes

Knowledge-based questions on Connecting to and Preparing Data
Knowledge-based questions on Exploring & Analyzing Data
Knowledge-based questions on Sharing Insights

Online Courses

Our online Tableau courses can help you get certified as a Data Analyst or Tableau Specialist.

Power BI

Interested in learning Power BI? Check out the quizzes here.

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

Learn More

4.5 Instructor Rating
19,555 Students

5,452 Reviews
2 courses

© Learning Tableau. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC