Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Tableau Server (GL) > Study Areas > Flashcards

Study Areas Flashcards

1
Q

What are the 10 high level services that make up a Tableau Server installation (2019.2). Hint (see diagram onAdmin Guide page). Note - there are more ‘processes’ running within these high level services.

A 
Gateway
Backgrounder
Data Server
Data Engine
VizQL Server
Cache Server
Application Server
Ask Data
Elastic Cache
Tableau Prep Condictor
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which Process: What process is the component that redirects traffic from all Tableau clients to the available server nodes in a cluster

A

Gateway

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

Which Process: What is a logical grouping of services that provide data freshness, shared meta data management, governed data sources, and in-memory data. The underlying processes that power Data Services are the Backgrounder, Data Server and Data Engine processes

A

Data Services

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

Which Process: Composes of the VizQL and Cache Server processes, provide user-facing visualization and analytics services and caching services

A

Analytics Services

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

Which Process: Sharing and Collaboration, and Content Management Service are powered by the Application Server process. Core Tableau Server functionality such as user login, content management (projects, sites, permissioning, etc.) and administration activities are provided by the Application Server process.

A

Application Server

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

Which Process: contains structured relational data like metadata, permissions, workbooks, data extracts, user info, and other data. The File Store process enables data extract file redundancy across the cluster and ensures extracts are locally available on all cluster nodes. Under heavier loads, extract files are available locally across the cluster for faster processing and rendering. All of the Tableau Server services use and rely on the Repository process

A

Repository Service

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

Where can you install Tableau Server

A

Tableau’s architecture is flexible, allowing you to run the platform just about anywhere. You can install Tableau Server on-premises, in your private cloud or data center, on Amazon EC2, on Google Cloud Platform, or on MS Azure. Tableau analytics platform can also run atop virtualization platforms. We recommend you follow the best practices for each virtualization platform to ensure the best performance from Tableau Server

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

Coordination Service - Overview

A

The Coordination Service is built on Apache ZooKeeper, an open-source project, and coordinates activities on the server, guaranteeing a quorum in the event of a failure, and serving as the source of “truth” regarding the server topology, configuration, and state. The service is installed automatically on the initial Tableau Server node, but no additional instances are installed as you add additional nodes. Because the successful functioning of Tableau Server depends on a properly functioning Coordination Service, we recommend that for server installations of three or more nodes, you add additional instances of the Coordination Service by deploying a new Coordination Service ensemble. This provides redundancy and improved availability in the event that one instance of the Coordination Service has problems.

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

Coordination Service - Hardware

A

The hardware for your cluster can have some effect on how well the Coordination Service runs. In particular:

Memory. The Coordination Service maintains state information in memory. By design, the memory footprint is small, and is typically not a factor in overall server performance.

Disk speed. Because the service stores state information on disk, it benefits from fast disk speed on the individual node computers.

Connection speed between nodes. The service communicates continuously between cluster nodes; a fast connection speeds between nodes helps with efficient synchronization.

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

Coordination Service - Configuration

A

The Coordination Service is installed automatically on the initial node of Tableau Server. If you are running a single-node installation, you do not need to do anything to deploy or configure the Coordination Service. If your installation includes three or more nodes, you’ll be prompted to configure a Coordination Service ensemble when you add your third node. This is not required, but is highly recommended as the Coordination Service serves a key function for high availability, acting as the source of “truth” about server topology, configuration, and state.

To configure a Coordination Service ensemble, use the TSM CLI and add the Coordination Service to the nodes you want running it. For details on how to deploy a Coordination Service ensemble, see Deploy a Coordination Service Ensemble .

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

Coordination Service - Quorum

A

To ensure that the Coordination Service can work properly, the service requires a quorum—a minimum number of instances of the service. This means that the number of nodes in your installation impacts how many instances of the Coordination Service you want to configure in your ensemble.

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

Coordination Service - Number of instances

A

The maximum number of Coordination Service instances you can have in an ensemble on Tableau Server depends on how many Tableau Server nodes you have in your deployment. Configure a Coordination Service ensemble based on these guidelines:

Total number of server nodes Recommended number of Coordination Service nodes in ensemble (must be 1, 3, or 5) Notes
1-2 nodes 1 node This is the default and requires no changes unless you want to move the Coordination Service off your initial node and onto your additional node.
3-4 nodes 3 nodes
5 or more nodes 5 nodes Five is the maximum number of Coordination Service instances you can install.

If you reduce the nodes in your cluster from three (or more) to two nodes, a warning tells you Tableau Server can no longer support high availability:

A minimum of three Tableau Server nodes are required for high availability. You can add a third node now,
or continue with only two nodes. Continuing with only two nodes means Tableau Server will not be highly available.
You can always add a third node later. Click OK to continue with 2 nodes, or Cancel to go back and add a node.
If you continue, Tableau Server will run, but you will not have any automatic failover of the repository.

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

Coordination Service - Check Status

A

The Coordination Service is not included in the listing when you View Server Process Status. To see the state of the service, you can use the tsm status command:

tsm status -v

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

Data Engine - Overview

A

Hyper is Tableau’s in-memory Data Engine technology optimized for fast data ingests and analytical query processing on large or complex data sets. Starting in Tableau 10.5 release, Hyper powers the Data Engine in Tableau Server, Tableau Desktop, Tableau Online, and Tableau Public. The Data Engine is used when creating, refreshing or querying extracts. It is also used for cross-database joins to support federated data sources with multiple connections.

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

Data Engine - CPU Usage

A

Hyper technology leverages the new instruction sets in CPU and is capable of parallelizing and scaling to all the available cores. Hyper technology is designed to scale to many cores efficiently, and also to maximize the use of each single core as much as possible. This means that you can expect to see the CPU being fully used during query processing. Adding more CPU is expected to result in performance improvement.

Modern operating systems such as Microsoft Windows, Apple macOS, and Linux have mechanisms to make sure that even if a CPU is fully used, incoming and other active processes can run simultaneously. In addition, to manage overall resource consumption and to prevent overloading and completely starving other processes running on the machine, the Data Engine monitors itself to stay within the limits set in the Tableau Server Resource Manager (SRM). Tableau Server Resource Manager monitors the resource consumption and notifies Data Engine to reduce the usage when it exceeds the predefined limit.

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

Data Engine - Memory

A

Memory usage of the Data Engine depends on the amount of data required to answer the query. The Data Engine will try to run this in-memory first. A working set memory is allocated to store an intermediate data structure during query processing. In most cases, systems have enough memory to do these types of processing, but if there isn’t enough available memory, or if more than 80% of RAM is utilized, the Data Engine shifts to spooling by temporarily writing to disk. The temporary file get deleted after the query has been answered. Therefore, spooling is an indication that more memory may be needed. Memory usage should be monitored and upgraded appropriately to avoid performance issues caused by spooling.

To manage memory resources on the machine, the maximum memory limit for Data Engine is set by Tableau Server Resource Manager (SRM).

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

Data Engine - Server Configuration

A

A single instance of Data Engine is automatically installed per node where an instance of File Store, Application Server (VizPortal), VizQLServer, Data Server, or Backgrounder is installed. The Data Engine can scale by itself and uses as much CPU and memory as needed, thus removing the need for multiple instances of the Data Engine. For more information on the server processes, see Tableau Server Processes.

The instance of Data Engine installed on the node where File Store is installed is used for querying data for view requests. The instance of Data Engine installed on the node where backgrounder is installed is used for extract creation and refreshes. This is an important consideration when you are doing performance tuning. For more information, see Performance Tuning Examples.

Data Server, VizQL Server, and the Application Server (VizPortal) all use the local instance of Data Engine to do cross-database joins and create shadow extracts. Shadow extract files are only created when you work with workbooks that are based on non-legacy Excel or text, or statistical files. Tableau creates a shadow extract file in order to load the data more quickly.

In Tableau Server 10.5 one instance of Data Engine is installed automatically when you install backgrounder. The backgrounder process uses the single instance of Data Engine (hyperd.exe) installed on the same node

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

2019.2 Minimum Specs

A

Trail: 4 Cores / 8 vCPU & 16GB RAM
Prod: 8 Cores /16 vCPU & 32GB RAM

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

TSM - Connect to remote server

A

tsm login -s -u

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

Anon Access

A

Anonymous access to embedded Tableau views requires that you enable “guest user” for Tableau Server. Guest user also requires that you license Tableau Server according to the number of cores you are running, rather than a named-user (interactor) model

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

Scale Out

A

When you scale out Tableau Server, you add computers (or nodes). To create a highly available deployment with failover, you need at least three nodes. For example, you might run most CPU-intensive server processes on two nodes and use the third node for the gateway and coordination controller services.

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

Task Priority

A

The priority determines the order in which refresh tasks are run, where 0 is the highest priority and 100 is the lowest priority. The priority is set to 50 by default.

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

Execution mode

A

The execution mode indicates to the Tableau Server backgrounder processes whether to run refreshes in parallel or serially. Schedules that run in parallel use all available backgrounder processes and serial schedules run on only one backgrounder process. However, a schedule can contain one or more refresh tasks, and each task will only use one backgrounder process, whether in parallel or serial mode. This means that a schedule in parallel execution mode will use all available backgrounder processes to run the tasks under it in parallel, but each task will only use one backgrounder process. A serial schedule uses only one backgrounder process to run one task at a time.

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

Task Frequency

A

You can set the frequency to hourly, daily, weekly, or monthly.

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

When can data refresh be performed

A

At Publish TIme
UI (Data Window)
Command Line (find example)
Schedule

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

Schedule Failure Email Goes to?

A

Email goes to data and workbook owners

Receivers can opt out

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

Which Service? Stores and distributes files needed by TSM (e.g. certificates, customization files, etc.).

A

Client File Service (CFS)

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

Failure Notifications - Site or Server setting?

A

Site

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

What is contained in the Refresh Failure emails

A 
Extract name 
Location on the server
Time of last successful refresh
Number of consecutive times the refresh has failed
Reason for the failure 
Possible solution
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

How many times will a refresh fail before suspension

A

After five consecutive failures, the refresh schedule is suspended until you or the data owner takes an action to address the cause of the failure, such as updating database credentials or a path to the original data file

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

How do you change the number of times will a refresh fail before suspension?

A

use tsm to set wgserver.alerts.observed_days via command line

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

What are the different Task types?

A

Refreshing extracts
Running flows (Prep)
Delivering subscriptions
Internal system jobs

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

What limitations impact scheduled tasks?

A

The number of concurrent tasks is limited to the number of backgrounder processes you have configured for Tableau Server.
Separate refreshes for the same extract cannot run at the same time.
Tasks associated with a schedule that is set to run serially run one at a time.

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

Subscriptions are at a site or server level

A

Site

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

How do subscriptions get suspended?

A

After 5 failures, via the UI or API

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

How do you change the number of failures before a subscription suspends?

A

tsm config set backgrounder.subscription_failure_threshold_for_run_prevention=14 (14 being the new value).

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

What do you see on the Job view in the Web UI?

A

For each job generated, there is a Job ID , the status of that Job, the priority, the type of task that the job was generated from, as well as the current run time, if the job is in-progress, and current queue time, if queued. The Job ID can be useful when viewing jobs on Admin views and can also be used to query the Workgroups Database.

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

What do you see when you click on the Job ID on the Job view in the Web UI?

A

When you click on the Job ID, you will see more detailed information about the job, such as the Job LUID, the project name, the schedule , the content name, content owner, and the site name. The site name is displayed if you navigate to the Jobs page using the Manage All Sites menu.

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

How can you cancel a running job in 2019.2?

A

In 2019.3 you can cancel jobs using UI. 2019.2 and below was only via REST API

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

What are the different Job Statuses

A 
Completed
In Progress
In Progress (late)
Pending
Pending (late)
Cancelled
Failed
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

What should you consider if you have a slow extract refresh

A 
Isolate time period it is running
Reduce Size of Extract
Configure Incremental
Reduce Frequency
Consider Execution Mode (Paralell)
Increase Backgrounder Processes
Isolate affected backgrounder processes on distributed cluster
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

What types of user login security are supported?

A

Either local auth or 3rd party such as Kerberos, SSPI, SAML, or OpenID.

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

How can you add users when configured for local security?

A

User identities can be added to Tableau Server in the server UI, using tabcmd Commands, or using the REST API.

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

What are the different types of external security that can be configured for TS?

A

NTLM & SSPI - do not use SSPI for SAML. See tsm authentication sspi
Kerberos (Windows)
SAML
OpenID
Mutual SSL (install client certificate)
Trusted Authentication - supply ticket to whitelisted Web Server
LDAP

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

What are proxy servers and how can TS leverage them?

A

To enable internet access to Tableau Server do not put it in direct on internet or DMZ. Use proxies
Forward proxy servers mediate traffic from inside the network to targets on the internet.
Reverse proxy servers mediate traffic from the internet to targets inside the network.

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

What syntax do you use with TSM to set a configuration property

A

tsm configuration set –key –value

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

What syntax do you use to retrieve a configuration value using TSM

A

tsm configuration get -k

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

Can you use tsm to connect to a node remotely?

A

Yes

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

How many groups of tsm commands can you name?

A 
tsm authentication
tsm configuration
tsm configuration set Options
tsm customize
tsm data-access
tsm initialize
tsm jobs
tsm licenses
tsm login
tsm logout
tsm maintenance
tsm pending-changes
tsm register
tsm reset
tsm restart
tsm security
tsm settings
tsm sites
tsm start
tsm status
tsm stop
tsm topology
tsm user-identity-store
tsm version
tsm File Paths
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q

What are the different types of maintenance calls you can make using tsm eg backup/cleanup etc?

A 
tsm maintenance backup
tsm maintenance cleanup
tsm maintenance metadata-services
tsm maintenance metadata-services enable
tsm maintenance metadata-services disable
tsm maintenance metadata-services get-status
tsm maintenance reindex-search
tsm maintenance restore
tsm maintenance send-logs
tsm maintenance validate-resources
tsm maintenance ziplogs
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q

How do you see what changes are pending on the server using tsm?

A

tsm pening-changes list

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

What types of operation can you perform using tsm topology commands?

A

You can use the tsm topology commands to prepare File Store nodes for safe removal or to put them back into read-write mode. You can also initiate a repository failover, get a list of nodes or ports, get the bootstrap configuration file required to add additional nodes to your cluster, remove nodes, and configure external repository.

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

Which services require access to the licence server

A 
Application Server
Backgrounder
Data Engine
Data Server
Tableau Prep Conductor
VizQL Server
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q

When creating a new project, how are the default permission configured?

A

Inherit from the parent site or Default site if top level.

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

If a site has grant permissions for a capability but a parent site has denied, which site takes precedence?

A

If there are nested projects, permissions set at the child level take precedence over permissions set at the parent level

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

If there is a change to permissions at the project level, will it be applied to all of the content within that project?

A

No. Changes to permissions at the project level only impact new content, they are not enforced for existing content

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

Can permissions on content be different to the project permissions?

A

Yes. If there are permissions set on content (workbook, data source, or flow) during or after publication, these take precedence over rules set at the project level.

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

What happens to the permissions of a workbook if a user who is not the owner of the workbook saves over the top of it?

A

They become the owner, with all the permissions that entails. The original owner’s access to the content is then determined by their permissions as a user rather than the owner.

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

Which two processes run only on the initial node and cannot be moved to any other node except in a failure situation

A

Licence Service (Manager) and TSM Controller (Administration Controller)

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

Which two process are installed on the initial node but can be added or moved to other nodes.

A

Client File Service (CFS) and the Coordination Service.

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

What services must be added to the extra nodes (3 min total) to enable HA on Tableau Server

A

Second instance of Repo and second instance Data Engine/File Store. Additional gateways can also be added. You can also add a load balancer to distribute requests among those gateways

62
Q

How many Coordination ensembles can a Tableau Server have. (ensemble can be many Coordination services)

A

Just 1. After deploying a second ensemble (eg for HA) you need to clean up the old one using:
tsm topology cleanup-coordination-service
Note: Tableau Server must be stopped for this to run.

63
Q

What are the recommended number of Coordination processes for a cluster with: (provide 3 answers)
1-2 Nodes
3-4 Nodes
4-5 Nodes

A

1-2 Nodes : 1 Coordination Service
3-4 Nodes : 3 Coordination Services
5+ Nodes : 5 Coordination Services (the max number)

64
Q

What processes are installed on a basic single node installation of Tableau Server (17 unique).

A 
Gateway
Search & Browse
Application Server (VizPortal) (x2)
VizQL Server (x2)
Data Server (x2)
Ask Data
Elastic Server
Cache Server (x2)
Backgrounder (x2)
Interactive Microservice Container
Non Interactive Microservice Container
Data Engine
File Store
Repository
Licensing
Cluster Controller
Coordination Service
65
Q

For HA - which step requires TSM

A

Coordination Service Ensemble

66
Q

For HA - What can happen if you attempt to clean up the old Coordination Service ensemble before the server is in the proper state

A

You can put the server into an unrecoverable state and may need to completely reinstall Tableau

67
Q

If there is a problem with a new instance of the Coordination Service (if it shows as stopped for example) - what can you do to recover

A

You can toggle back to your previous Coordination Service ensemble using the tsm topology toggle-coordination-service command

68
Q

What happens when you run the Tableau Server obliterate script

A

The steps below completely remove Tableau Server on Windows, and delete all related data, users, configuration information, and logs. This includes any files in \temp. Tableau Server licenses are also deactivated if you include the -l option

69
Q

What happens if you delete or disable a user in Active Directory and then synchronize that user’s group on Tableau Server

A

The user is removed from the Tableau Server group you synchronized.
The user’s role is set to “unlicensed.”
The user will still belong to the All Users group.
The user is unable to sign in to Tableau Server

70
Q

What happens if you remove a user from a group in Active Directory and then synchronize that group on Tableau Server

A

The user is removed from the Tableau Server group you synchronized.
The users role is retained: it is not set to “unlicensed.”
The user will still belong to the All Users group.
The user will still have permission to the Tableau Server with access to everything that the All Users group is granted permission to use.

71
Q

When using Active Directory, will a user ever be deleted from Tableau Server via a synchronize?

A

No. It will always need to be done via Tableau Server

72
Q

Can you set up Active Directory that is in a different domain to the Tableau Server?

A

Yes in these two situations:

1) Two-way trust has been established between the server’s domain and the users’ domain
2) The server’s domain trusts the users’ domain (one-way trust)

73
Q

Can you change the name of an Active Directory Group that has been synchronized to Tableau Server?

A

Yes but only in Active Directory. Not via Tableau Server.

74
Q

What operating systems can Tableau Server be installed on?

A

Windows Server 2008R2-2019

75
Q

Is search on Tableau Server case sensitive?

A

No

76
Q

How do I search for a specific attribute in Tableau Server Search?

A

attrname:value eg publisher:jdoe

Note you can add multiple using spaces

77
Q

Which Tableau Services require access to the license server?

A 
Application Server
Backgrounder
Data Engine
Data Server
Prep Conductor
VizQL Server
78
Q

What is a locked project?

A

Project permissions are only inherited from their parent or ancestor project.

79
Q

Are permissions implicitly allowed or denied?

A

Denied. Non admins must be granted permission to access content.

80
Q

When a workbook is saved with “Show sheets as tabs” option enabled. What permission is applied to the views.

A

The Workbook permissions.

81
Q

What is the workflow that inspects permissions to determine if a user has access to content?

A

1) Is user specifically Denied?
2) Is user specifically Allowed?
3) Is member of group Denied?
4) Is member of group Allowed?

82
Q

Do Individual permissions take precedence over Group permissions?

A

Yes.

83
Q

What is the order of precedence for evaluating content access?

A

1) Admin site role
2) Licence denies capabilities
3) Project Owner
4) Project Leader
5) User is content owner
6) User - capability denied
7) User - capability allowed
8) Group - capability denied
9) Group - capability allowed
10) User is denied

84
Q

What features are only available from the TSM command line ie not from the UI

A 
Preferred active repository
Data cache configuration
Initial install-only settings
Initial SQL
Site SAML
SAP HANA SSO
Rebuilding the Search Index
85
Q

Does the tsm maintenance backup command include config data

A

No

86
Q

Can you move repository form the initial node on a 2 node cluster

A

No

87
Q

Can the server that hosts the installation of Tableau Server have a dynamic IP?

A

No. The computer where you install Tableau Server must have a static IP address

88
Q

If you are adding Tableau Prep Conductor to your Tableau Server installation, what does Tableau recommend in terms of Server set up and specs

A

Run on separate node with 4 cores and 16GB RAM

89
Q

What happens when you publish a cube data source such as SSAS

A

You have to download it in Tableau Desktop. You cannot connect directly to a Cube data source

90
Q

What are the three types of search

A

Tableau provides multiple ways of searching for content:

Quick search for when you want to search across the entire site.

Filtered search for when you want to search the content shown on the current page.

Favorites search for when you have a view open but want to search for one of your favorite pieces of content.

91
Q

File Store is the Tableau Service that controls the distributed storage of what?

hyper files
Data Neccessary for NLP
Data Source Connection Metadata
Certificates, Keys etc

A

Hyper Files

92
Q

TSM processes that run, even when Tableau Server is stopped include:

A

Administration Agent
Administration Controller (REST API endpoint)
Client File Service
Coordination Service (based on Apache Zookeeper™)
Service Manager
Licensing Service

93
Q

When you log into Tableau Server, the Gateway process forwards the request to…

A

Application Server (good link) - https://help.tableau.com/current/server-linux/en-us/processes.htm

94
Q

You can change from local store to an external store, or you can change from an external store to a local store. In either case, to change the identity store type, you complete these steps

A

Reinstall Tableau and restore content

95
Q

To use OpenID Connect on Tableau Server, the server must be configured to use

A

a local Identity store

96
Q

tableau-server-obliterate.cmd -a -y -y -y

A

Removes Tableau Server from current node

97
Q

You can only restore a tsbak file when….

A

It is the same identity store. See https://help.tableau.com/current/server/en-us/db_restore.htm

98
Q

Which Services remain active when Tableau Server is shutdown

A 
Admin Controller
Admin Agent
Coordination Service
Client File Service
Licensing Service

see https://help.tableau.com/current/server-linux/en-us/tsm_overview.htm

99
Q

TSM Controller process can……

A

Only be one instance
Also referred to as Admin Controller
Hosts the TSM Rest API for configuring Tableau Server

100
Q

Guest Users are

A

Only available with core based licences
Can only interact with Tableau Views
To share views with guest you must provide url or embed in web page

101
Q

If you install Tableau on multiple nodes, drivers must be installed on any node running…..

A

Data Server
Backgrounder
VizQL
Application Server

102
Q

What is stored in the client file service?

A

Customisation Files
Auth Keys
Auth related certificates

103
Q

For both single and multi node instances IP addresses must be…..

A

Static

104
Q

Which Tableau Server process is being described?

  • Responsible for monitoring various components, detecting failures
  • Running failover when needed
  • Must be installed on each node
A

Cluster Controller

105
Q

Which of the following processes listed are single-threaded? (Select all)

A

Cluster (No)
Gateway (No)
Backgrounder (Yes)
Cache Server (Yes)

106
Q

True or False: If your web server uses SSPI (Security Support Provider Interface), you do not need to setup Trusted Authentication

A

True

107
Q

Which command should you run to verify your SMTP connection?

A

tsm email test-smtp-connection

108
Q

The TSM Status Page in the TSM UI shows you the state of server processes. Which two processes can be found here but are not located in the Tableau Server Status Page?

A

TSM Controller

Licence Server

109
Q

Which Tableau Server process is being described?

  • Handles the web application
  • Handles REST API calls
  • Supports browsing and searching
A

Application Server

110
Q

Which TSM process is being described? Based on Apache ZooKeeper, it serves as the source of truth regarding server topology, configuration, and state

A

Coordination Service

111
Q

Select all the site roles that can be assigned to a person with an Explorer license

A 
Site Admin (Expl)
Read only
Explorer
Explorer (Can Pub)
Server Admin

Link to Tableau Server documentation:

https://help.tableau.com/current/server/en-us/users_site_roles.htm

112
Q

Which of the following are cube data sources supported in Tableau (Select all)

A

MS SSAS
Essbase
PowerPivot
SAP Netweaver

(not SAP HANA)

113
Q

Which Tableau Server process is being described? Tableau Server’s librarian - handles fast index search, filter, retrieval, and display of content metadata on the server

A

Search and Browse

114
Q

A user with a Viewer license type and site role can create data-driven alerts

A

False

115
Q

Which of the following are situations where a user can be assigned the Unlicensed role? (Select all)

A

Remove a user who still has content on server
Product Key Expired
Import from CSV with licence level set to expired
Reached max number of licences

116
Q

Tableau recommends that only two ports should be accessible to external traffic. How should the gateway and tabadmincontroller port be configured?

A

Gateway port 80

Tabadmincontroller port 8850

117
Q

Which of the following processes are NOT licensed? (Select all)

A

Ask Data
Cluster Controller
Cache Server

118
Q

Select all the correct statements that describe how cube data sources affect Tableau functionalities:

A

Cannot be published to Tableau Online

Data Source filters are not available

119
Q

Which two (2) processes do not display on the Tableau Server Status page, but are indicated in the Tableau Services Manager (TSM) Status Page in the UI?

A

TSM Controller

Licence Server

120
Q

Which TSM process is being described?

  • Manages most shared files in a multi-node cluster
  • Authentication related certificates, keys, and files (OpenID, mutual SSL, SAML, and Kerberos), and customization files
A

Client File Service

121
Q

With Kerberos delegation, Tableau Server can use the Kerberos credentials of the viewer of a workbook or view to execute a query on behalf of the user. Select all the data sources where Tableau supports Kerberos delegation

A

Oracle, SQL Server, Vertica, Teradata

Not SAP Hana

122
Q

Given the following signs, how should you optimize Tableau Server?

  • The backgrounder process consistently has a high percentage of processor time
  • VizQL has a low percentage of processor time, even during peak traffic hours
A

Optimise for extract refreshes

123
Q

Which of the following statements correctly describe how a user’s site role will be affected by synchronizing with an external Active Directory group? (Select all)

A

If you do not add a minimum site role, the user is added as unlicenced

A users site role can be promoted but never demoted based on the minimum site role

Link to Tableau Server documentation: https://help.tableau.com/current/server/en-us/groups_create_adsync.htm

124
Q

For jobs scheduled at the same time, which of the following task type will run first?

A

Flow runs

Link to Tableau Server documentation: https://help.tableau.com/current/server/en-us/task_prioritization.htm

125
Q

In the command tsm data-access caching set -r , what value should be set if you want Tableau Server to always get the latest data?

A

0 or ‘always’

126
Q

What will happen if the limit for a role is left blank?

A

The Server licence limit is used

127
Q

What happens if you import users to the server, but not to a specific site?

A

Users are not assigned to a site and marked Unlicenced

Link to Tableau Server documentation: https://help.tableau.com/current/server/en-us/csvguidelines.htm

128
Q

Select the correct statement below. Assume that the project content permissions are set to ‘Customizable’:

A

If there are nested projects children take presedence over parents.

129
Q

True or False: A job with a priority of 100 will run before a job with a priority of 10

A

FALSE

Link to Tableau Server documentation: https://help.tableau.com/current/server/en-us/task_prioritization.htm

130
Q

A user has been added to a site as an EXPLORER, however the site has already met its role limit set by the Server Administrator for Explorers. There are still available licenses at the higher tier. What will happen?

A

User will be added as an explorer but will consume a creator licence

131
Q

What happens when you delete a user in Active Directory, and then perform a sync operation on that user’s group with Tableau Server? (Select all)

A

User role set to unlicenced
User removed from Tableau Server group synchronised
The user is unable to sign into Tableau Server
The user will still belong to the All Users group

Link to Tableau Server documentation: https://help.tableau.com/current/server/en-us/groups_create_adsync.htm

132
Q

Which Tableau Services Manager (TSM) command customizes the look and feel of Tableau Server?

A

tsm customize

133
Q

Given the following signs, how should you optimize Tableau Server?

  • During peak traffic hours, resource utilization for memory is consistently high
  • Spikes in user traffic affect load times for views
A

Optimise for user traffic

134
Q

Which of the following statements is correct about where you can configure site role limits?

A

Through the Server Settings UI or REST API (not TSM interface)

135
Q

True or False: Server administrators do not count against site role limits

A

TRUE

136
Q

Which of the following is the correct statement about site roles that can manage the licenses and site roles in Tableau Server?

A

Server Admins can set site role limits (Creator, Viewer, Explorers etc) but not Site Admins

137
Q

Which of the following types of logos and headers can be customized with the TSM command, tsm customize? (Select all)

A

Server Name
Header Logo
Sign In Logo

138
Q

Permissions determine how users can interact with content such as workbooks and data sources. Select the correct options where permissions can be configured in Tableau Server:

A

REST API

Server UI

139
Q

Which of the following statements is correct about Tableau Server’s capability to send alerts and email notifications?

A

Tableau Server must connect to another mail server

140
Q

It is common knowledge that users granted the Explorer (Can Publish) site role with an Explorer license can publish workbooks using existing data sources, but cannot connect to external data and create new data sources. What happens if a user with an Explorer license is granted the Server Administrator site role?

A

A Server Admin with Explorer licence still cannot connect to external data and create new data sources

141
Q

Which Tableau Server process is responsible for external directory synchronization?

A

Backgrounder

Explanation
Link to Tableau Server documentation: https://help.tableau.com/current/server/en-us/groups_globalsync.htm

142
Q

Tableau Security Workflow

A

Is user specifically denied - Yes == Denied
else
Is user specifiaclly allowed - Yes == Allowed
else
Is group specifically denied - Yes == Denied
ekse
Is group specifically allowed - Yes == Allowed
else
Denied

143
Q

Three simple rules for capability evaluation

A

A capability that is never explicitly allowed is denied.
A group-level Deny trumps a group-level Allow.
Individual permissions trump group-level permissions.

144
Q

On the Schedules page, you are able to view the number of tasks associated with what type of schedules?

A

Extract Refreshes and Flows

145
Q

Who can manage subscriptions

A

Administrators, project leaders, and the workbook owner can all manage the subscriptions for a single workbook.

146
Q

How long does your Tableau Online site need to be active before you can enable Admin Insights?

A

30 days

147
Q

Postgres DB runs on port?

A

8060

148
Q

Which Tableau Server administrative view shows you which views are the most expensive in terms of server performance? It also features two key metrics: Average Load Time and Exact Load Time.

A

Stats for load times

149
Q

“Clears the initial admin user so that you can enter a new one. After running this command, you must rerun tabcmd initialuser to create a new initial admin.”

A

tsm reset

150
Q

Which tsm configuration set option controls whether Tableau Server collects historical user activity and other information in the repository?

A

auditing.enabled

151
Q

Which Tableau Server administrative view displays how long it takes for views to load and how many sessions are running at a time on the server?

A

Performance of Views

Tableau Server (GL) (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions