Tableau Gold Study Flashcards

1
Q

How do you know how has seen a particular view?

A

It’s below the comments section at the bottom of the view. You must be an admin to view.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Explain how the Resulting Permissions works, what info does it convey?

A

Number of users in the group and the resulting permissions that they have acquired at the user/group level.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Can you configure Tableau Server to support non-English speaking users?

A

Yes. Each user can set the Language and Locale of the Tableau Server interface. This will change all of the non-content language on Tableau Server.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Suppose a user has View permission for a workbook. Are they guaranteed the ability to view that workbook?

A

Unanswered

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Case: User is using Trusted Ticket authentication to achieve SSO and is having a hard time exposing the Tableau Server navigation to my users. What is going wrong?

A

Tickets are only valid for navigating to views. To enable unrestricted tickets issue the unresticted ticket tabadmin command.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How do I embed a view without the toolbar?

A

Add to the end of the URL: ?:embed=yes&:toolbar=no

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Case: I’m not sure if my user’s views are rendering properly. Can I check this?

A

Yes. Add to the end of the URL: ?:render=false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What Tableau Utility found in both Tableau Desktop and Server help identify how a workbook is performing?

A

The performance recorder tracks the time elapsed for an individual workbook to execute queries.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is the Javascript API?

A

Allows you to implement Tableau visualizations into your own web applications.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is the REST API?

A

Allows you to automate many Server Admin tasks.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is the Extract API?

A

Use to connect to data that is not currently supported as a Tableau Data Source. Allows you to make a program that accesses/processes data to create a TDE.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the repository?

A

It stores application data, file data, TWBs and TDSs. It is based on PostgreSQL.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is VizQL Server?

A

Creates visualizations in server. It takes simple visual interactions and creates database specific SQL or MDX.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is the Backgrounder?

A

Responsible for extract refreshes, fulfilling subscriptions and keeping the Server healthy.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is the Base Install?

A

Consists of coordination (Apache Zookeeper) and the cluster controller (takes action on server health issues). Installs 1 instance of each on each server in the cluster.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is a Gateway?

A

Receives incoming client HTPP requests and directs them to the appropriate service. Acts as an internal load balancer.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is the Data Server?

A

Data Server serves meta-data and connections to desktop and serves authors. Invoked when a data source is published via Tableau Desktop. Proxy between requests for data and individual data sources.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is the Cache Server?

A

Keeps data hot. Acts as a shared cache across all Tableau processes in a cluster.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is the File Store?

A

Repository and replication of TDE files.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is the Data Engine?

A

Used to manage storage for Extracts and queries. Creates TDEs and manages them.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What is Search and Browsing process?

A

Handles the search feature, queries meta-data from TWBs and TDSs; based on Apache SOLR.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What are some ways that you can add interactivity to your dashboards?

A

What kind of interactivity do you need?-Use as Filter-Apply to All Sheets-Add Dynamic Titles-Use filter actions for filter, URL and highlighting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

How is Tableau breaking out of the BI box?

A

By putting humans, not databases, at the center of the design.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

What is a cube? Does Tableau support them?

A

Yes. But the pre-aggregation of the multi-dimensional data sources may limit drilling-down within Tableau. Tableau absolutely supports them though.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What’s the difference between using ODBC connections versus Tableau’s named connections?

A

Named connections are optimized and tuned by Tableau to assure performance and robust functionality. ODBC connections rely on the vendor’s driver capabilities.

26
Q

I have a Mac and need to connect to a cube, can I?

A

Native connectors are limited to the driver capabilities of our database vendors. You could run a VM inside your mac or use a PC to access the data source.

27
Q

Is Tableau easy to scale-out?

A

You can easily install workers nodes by downloading the package from our site. Each one takes about 30 minutes.

28
Q

Why can’t you create a forecast from a bar chart of Category and Sales?

A

You have to include at least one date and one measure in the view. If there are not enough data points in the view then you can’t build a forecast.

29
Q

Why is 10 the recommended maximum for unique colors categorical data?

A

8 colors max is recommended as a visual best practice. Anything more and color loses its impact.

30
Q

Who defines the measures and dimensions?

A

For relational - Tableau determines them automatically. All numeric fields are measures and everything else is a dimension.For cubes - Explicitly defined by author of the cube.

31
Q

Are calculations performed locally in Tableau?

A

Tableau pushes most calculations back to the database. All aggregations are performed on the database.

32
Q

Are my calculations written back to the database?

A

No. Tableau is a safe environment - it never changes your data. Calculations are computed on the fly based on current values in the database.

33
Q

Does Tableau have to import data to run queries?

A

Nope, you can connect live and leverage your investment in your existing database.

34
Q

Tableau doesn’t support Gauge views, like Qlik - Why not?

A

It’s generally harder to read a radial measure. Bullet graphs are a much easier to read alternative.

35
Q

What is multi-threaded?

A

Within a process, being able to perform multiple tasks simultaneously across multiple CPUs.

36
Q

Is data blending within a single database the same as using multiple tables in the connection dialog?

A

No, joins happen in the database with raw data as part of one universal query. Blends happen in Tableau with the already aggregated data.Joins - 1 queryBlends - 2 queries

37
Q

What is availability?

A

The ability to be resistant to component failures. Increasing the availability of a solution will increase the complexity and total cost.

38
Q

What is scalability?

A

Architecturing a Tableau Server environment to handle a growing amount of simultaneous requests.

39
Q

What multi-process?

A

Adding more throughput by running multiple instances of a process or service. These can be on a single or distributed servers.

40
Q

Why doesn’t Tableau support 3D? What’s the alternative?

A

What do you like about 3D charts? Use small multiples as multi-dimensional alternative. Easier to read.

41
Q

How do I find the number of days/seconds/etc. between two date dimensions in my data set?

A
  1. DATEDIFF(‘Year’,[Date 1],[Date 2])2. [Date 2] - [Date 1]
42
Q

How do I find all my customers that have bought a product in “Technology” but not “Office Supplies”?

A

Conditional filtering

43
Q

What is the cluster controller?

A

Monitors components, detects failures and executes failover when needed.

44
Q

What is the coordination service?

A

Responsible of ensuring there is a quorum for making decisions during failover.

45
Q

Can I deploy a single Tableau Server distributed across the server zones in my IT infrastructure?

A

No. You must deploy Tableau Server in the same zone whether it is a single or multi-node.

46
Q

How do I sync my Active Directory with my Tableau server?

A

Using the command line utility to run the “syncgroup” command.

47
Q

What are the most common ways to refresh my extracts?

A

Using Data Server to schedule extract refreshes or run an on-demand refresh through the CLU.

48
Q

What kind of Server admin tasks can I do with Tableau’s Command Line Utility?

A
  1. Add/Delete/Modify Users
  2. Add/Delete/Modify Groups
  3. Add Projects
  4. Add/Delete Permissions
49
Q

What is a reverse proxy?

A

A reverse proxy is a server that sits “in front” of the Tableau Server. This is useful for allowing requests without making the IP of the server visible and load balancing.

50
Q

Do I need to enable Kerberos? What is that used for?

A

Kerberos enables companies to leverage their database security model with ease.

51
Q

Case: The majority of my employees are not very technically inclined and I don’t want to have them worrying about data connections? Solution for this?

A

Data server will allow the admin to define data sources, add metadata and author entirely new calculations and data fields. Do data governance securely!

52
Q

What levels of security does Tableau Server author?

A
  1. Sites
  2. Projects
  3. Workbooks/Views
  4. Users/Groups Permissions
  5. Data Server Security
  6. Data Sources VS Data Connections
  7. Row Level Security
53
Q

What are limits on the dimensionality expression in LOD calculations?

A

Only dimension fields; no sets, combined-fields, parameters, table calculations, aggregate calculations, exclude/include keywords, or date expressions; no IF statements

54
Q

Can I bring fields from disparate data sources into the same LOD expression?

A

No. All fields must come from the same data source in LOD expressions.

55
Q

What happens if I use the same LOD expression on multiple worksheets?

A

The LOD expression will me evaluated multiple times. It is not cached outside of the worksheet result cache.

56
Q

What data sources don’t support LOD expressions?

A

Cubes, Google Big Query, Microsoft JET, Splunk, Actian Vectorwise, DataStax, Informatica Data Services.

57
Q

Are LOD expressions materialized in extracts?

A

No, LODs are always calculated on the fly.

58
Q

What is the 1st quartile, median and 3rd quartile?

A

The values observed at 25%, 50%, and 75%

59
Q

What is the standard deviation?

A

Measures the amount of dispersion or variation in a set of values.

60
Q

What is skewness?

A

Measures the asymmetry of the distribution of values around the mean. Left is positive, Right is negative.

61
Q

What is excess kurtosis?

A

A description of the flatness or skinniness of the distribution.

62
Q

Under what circumstances do blended fields return an asterisk value?

A

If there are multiple matching members you will see an asterisk in the view.