Specialist Practice Questions - Connecting to & Preparing Data

Use the Specialist study guide to quickly look up information related to these questions. More Specialist practice questions available here.

Enter Email to Submit Quiz & Subscribe

1. 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

2. 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.

3. 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.

4. 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

5. 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

6. 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

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

8. Advantages to using relationships to combine tables: [select all that apply]

[1.2.3 Explain when to use a join versus a relationship]

a) Makes it easier to change the key fields used to combine the tables

b) Make it easier to analyse data across multiple tables at different levels of granularity

c) Makes it easier to combine rows from one table with rows from another

d) Tables are only queried when fields from the tables are added to the viz.

9. 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

10. 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

11. 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

12. 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

13. 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

13 thoughts on “Specialist Practice Questions – Connecting to & Preparing Data”

Scott
December 6, 2021 at 7:57 pm

takes quite a long time to render results

Reply
1. LearningTableau
  December 16, 2021 at 2:44 pm
  
  This should be fixed now.
  
  Reply
Charanya
December 10, 2021 at 4:51 pm

Thanks for the Desktop Specialist questions.Its very helpful to pass Tableau Certifcations.

Reply
1. LearningTableau
  December 16, 2021 at 2:46 pm
  
  Thanks Charanya!
  
  Reply
Allison
January 11, 2022 at 4:48 am

For the advantages of the relationship, I think the answer has a wrong one. should be ABD instead of ABC. Since on the tableau website, it says here are some advantages to using relationships to combine tables:

-Make your data source easier to define, change, and reuse.
-Make it easier to analyze data across multiple tables at the correct level of detail (LOD).
-Do not require the use of LOD expressions or LOD calculations for analysis at different levels of detail.
-Only query data from tables with fields used in the current viz.

Reply
Julius
May 22, 2022 at 3:12 pm

Excellent understanding of Tableau and I appreciate this exam guide! I have worked with Tableau for about two and a half years in college for my data mining and database management courses but it’s rather tricky to remember the process when you’re not visually doing these tasks and just reading the words. I am about to graduate in a few weeks and I enjoy doing data visualizations on Tableau in my free time and thought having these certifications would boost my resume. Thank you for making this exam guide along with the answers. Hopefully, I will be able to pass this exam and then the Data Analytics Certification

Reply
Nick
December 25, 2022 at 3:44 am

how can I see the answers?

Reply
Bleda
December 27, 2022 at 9:19 pm

I don’t see the results. Where can I find them?

Reply
1. Narcis
  December 30, 2022 at 7:29 pm
  
  Hello Bleda,
  
  If you still have issues seeing the results, you can find the solutions here – https://learningtableau.com/download/1422/
  
  Thank you,
  Narcis
  
  Reply
sam
February 10, 2023 at 6:54 pm

hi

Reply
1. LearningTableau
  February 14, 2023 at 7:39 pm
  
  hi – contact support@learningtableau.com for help
  
  Reply
Nitin
July 2, 2023 at 5:04 pm

Thank you for the questions, this helps us understand our level of learning and we could always go back and regain strength in our weaker fields for the final certification exam.

Reply
Haile
September 1, 2023 at 11:10 pm

Thanks a lot

Reply

13 thoughts on “Specialist Practice Questions – Connecting to & Preparing Data”

Leave a Reply Cancel reply