Which 3 tasks require more planning in an air-gapped deployment? Interactive Container Service - Maps
- Licensing
- External Data Administration/TSM Controller Internal Data Source Properties.
What happens if Backgrounder process goes down? Tableau Server will still work but actions may take longer If there is only one process, then Tableau Server would no longer be able to render views Refresh and subscription jobs on the failed Backgrounder process are retried once the Backgrounder process recovers from failure. It helps to avoid having your users sign in twice to access a view that is embedded into a webpage.
It does this through setting up trusted relationships between Tableau Server and 1 or more web servers.
What is RTO (recovery time objective)? A measure of how much time can elapse before full recovery; that is, the maximum length of time within which a business process must be restored after a disruption.
- long RTO = longer downtime
- low RTO is good for mission-critical systems • Copying of extract files to and from the affected node stops.
• Removing extract files that are no longer needed on the affected node is suspended. (This removal process is usually referred to as "extract reaping.") -Change its schedule
>Change to schedule that enters queue earlier in day
>Change to schedule that runs more frequently
>Change schedule from serial to parallel
(Serial uses one backgrounder process and is slower
Parallel uses all available backgrounder processes)
-Change its priority It helps to avoid having your users sign in twice to access a view that is embedded into a webpage.
It does this through setting up trusted relationships between Tableau Server and 1 or more web servers.
What is the name of the ability to make certain topology changes or updates without restarting the server? Ad Hoc Topology Dynamic Topology Bus Topology Small Network Topology.
Which process runs automatically on all nodes where Data Server is running? Data Server Gateway Ask Data Cache Server.
What kind of policy serves as an additional layer of security across cross-site scripting and other malicious web-based attacks? Backup Tableau Server and then store the .tsbak file on a computer outside of your Tableau Server installation Content Security Policy (CSP)
- Implemented as an HTTP response header that allows you to specify where external resources can be safely loaded from tabcmd creategroup <group name> SAML Service.
Which topology configurations optimize server backups? -Co-locate file File Store & TSM/Administration Controller on the same node (especially true if your org uses many extracts)
-Co-locate the repository & TSM/Administration Controller on the same node (time savings is less significant than first option) A measure of tolerance of data loss in terms of time, i.e. the duration of time for which data loss is acceptable
- defined by how often you take backups
- more frequent backups = lower RPO
- if a backup takes 8 hours, that's your smallest RPO Extensions API
- Can interact with data from other business apps directly in Tableau
- Can integrate 3rd party functionality inside the dashboard
- Lets users modify data in a viz and have that change automatically update the source data in the data base or web app It helps to avoid having your users sign in twice to access a view that is embedded into a webpage.
It does this through setting up trusted relationships between Tableau Server and 1 or more web servers.
CPU threshold that should trigger an incident: 80% over 5 minutes less than 20% available 75% over 5 minutes less than 25% available.
True or False: JMX is enabled by default False File Store True False.
You must use tsm maintenance backup to create a backup of repository and file store data (contains workbook and user metadata, extract files, and site configuration data)
You must use tsm setting export to backup configuration and topology data.
Which process is an internal service that only communicates with the Data Source Properties service? Messaging Service Internal Data Source Properties Data Server Elastic Server.
Memory threshold that should trigger an incident: 80% over 5 minutes Less than 25% available Less than 20% available Less than 15% available.
Which tool helps assess environment scalability through load testing? Tableau Prep Flow Service TabJolt Administration/tsm Agent Gateway.
What can you use to connect to extracts of data from Facebook or Twitter from Tableau Online? All business services on that node will fail as well, and depending on those services Tableau Server may run in a degraded state. Workbook content will appear to be missing (not being returned in search results) Block off all other hosts from accessing the range of JMX ports You can refresh extracts from Tableau Desktop (Refresh from Source option or republish the data source). You cannot use Tableau Bridge.
Actions by All Users -Overview of background jobs
-Time it takes for jobs to run, when backgrounder is busy or overloaded, jobs that completed successfully or not
-How long did the jobs wait before running?
-How long does it take for each job to run?
-What is the total run time for each job?
-How long does it take for each job to run? -Change its schedule
>Change to schedule that enters queue earlier in day
>Change to schedule that runs more frequently
>Change schedule from serial to parallel
(Serial uses one backgrounder process and is slower
Parallel uses all available backgrounder processes)
-Change its priority Extract-specific tasks that run on the server
What Extracts Ran on this Server? Shows extracts that ran in the specified timeline
You can click Success or Error to filter by status
How much time did Extracts take?
How Many Extracts Succeeded or Failed by day? -Shows Login Activity, View Access, and Data source Use
-Publish and Download: shows publishing and downloading of flows, workbooks, and data sources
-Subscriptions: shows counts of subscription email sent for workbooks and views. Also shows the counts of flow runs.
What happens if Cache Server process fails? Data Source Management
Data Quality
Enrichment & Preparation
Data Security
Metadata Management
Monitoring & Management On a separate node since Prep flows are CPU and RAM intensive Tableau Server will still work but actions may take longer Requests being handled by that instance will fail, but subsequent requests will be routed to other running Application Server processes.
TSM commands for configuring a reverse proxy: -tsm configuration set -k gateway.public.host -v "name" (ex: tableau.example.com)
-tsm configuration set -k gateway.trusted -v "server_ip_address"
-tsm configuration set -k gateway.trusted_hosts -v "proxy1.example.com, proxy1, ftp.example.com" (aliases)
-tsm configuration set -k gateway.public.port -v 443
-tsm pending-changes apply tsm configuration set -k elasticserver.vmopts -v -Change its schedule
>Change to schedule that enters queue earlier in day
>Change to schedule that runs more frequently
>Change schedule from serial to parallel
(Serial uses one backgrounder process and is slower
Parallel uses all available backgrounder processes)
-Change its priority Ongoing extract refreshes will fail.
New refreshes of .tde extracts will not be impacted, but .hyper extract refreshes on that node WILL continue to fail until the engine is recovered
If a viz rendering is running any query on the failed node, rendering will fail
If the viz includes a shadow extract and the request is routed to a node with a failed Data Engine, the view rendering will continue to fail until engine is recovered.
How do you create a performance recording without using the cache? The share button at the top of each view (unless showShareOptions parameter is set to false) You can refresh extracts from Tableau Desktop (Refresh from Source option or republish the data source). You cannot use Tableau Bridge (unless showShareOptions parameter is set to false)
Include "refresh=yes" at the end of the URL
Example: http://serverhost/views/workbookname/viewname?:record_performance=yes&:refresh=yes Backup Tableau Server and then store the .tsbak file on a computer outside of your Tableau Server installation.
In which kind of governance model does IT/another authority own data access and produce data sources and dashboards for business consumption in a one-to-many manner? (Small number of Creators with everyone else as Viewers) Delegated Centralized Batch-sequential Distributed.
How long can Tableau server run when there is a problem with the initial node and you have redundant processes on other nodes? Webhooks API
- Enables Tableau events to send an HTTP POST notification to the web location of your choice 72 hours before lack of licensing services impacts other processes Application Server
Backgrounder
VizQL Server
Data Server
File Store (only when configured locally) Up to half the number of physical cores on the node.
Actions by Recent Users -Shows Login Activity, View Access, and Data source Use
-Publish and Download: shows publishing and downloading of flows, workbooks, and data sources
-Subscriptions: shows counts of subscription email sent for workbooks and views. Also shows the counts of flow runs -View Active, Recently Active, and Idle users that are signed into the Server
-Active = 5 minutes
-Recently Active = last 30 minutes
-Idle = more than 30 minutes ago -Change its schedule
>Change to schedule that enters queue earlier in day
>Change to schedule that runs more frequently
>Change schedule from serial to parallel
(Serial uses one backgrounder process and is slower
Parallel uses all available backgrounder processes)
-Change its priority -Overview of background jobs
-Time it takes for jobs to run, when backgrounder is busy or overloaded, jobs that completed successfully or not
-How long did the jobs wait before running?
-How long does it take for each job to run?
-What is the total run time for each job?
-How long does it take for each job to run?.
Which process is a web server that handles all requests to Tableau Server from browsers, Tableau Desktop, and other clients? Gateway Router Data Server Proxy.
What kind of impact does enabling encryption at rest have? 1. Create a server backup and save it to a network file location
2. Uninstall Tableau Server 2018.1 from the primary and worker nodes
3. Install Tableau Server 2019.1 on the initial (formerly primary) node
4. Generate a bootstrap file on the initial node.
tsm topology nodes get-bootstrap-file -f C:\bootstrap.json
5. Copy the bootstrap file to the additional (formerly worker) node.
6. Install Tableau Server 2019.1 on the additional node.
7. Run an upgrade script on the initial node.
upgrade-tsm
8. Start Tableau Server from the TSM page.
or tsm start
9. Test that the server upgrade was successful. All other Tableau Server processes running on the same node will display as "unavailable". Server will run as expected but you cannot make config/topology changes .hyper extracts (must be upgraded to .hyper file if previously a .tde, as well as files such as excel or json as only .hyper files are encrypted) - Slight to moderate increase in backgrounder load, as it alters existing jobs and introduces new jobs
- Increase in Viz Load Time and Worker Load (requires data to be decrypted once)
- Increases backup file size up to 50-100% (compression is ineffective on encrypted extracts)
- Increase time to restore a backup (added time for exchange of encryption keys)
*for server installations with many encrypted extracts, consider disabling compression for faster backups*.
Disk space threshold that should trigger an incident: 80% over 5 minutes Less than 20% available Less than 15% available Less than 1% available.
Tableau Server IdPs that can be used to automate adding or removing users from Tableau Online: - Okta
- OneLogin Search & Browse Site SAML, OpenID Connect Kerberos, Local Authentication.
Which processes cannot be moved from initial node unless there is a failure? -License Service/License Manager
-TSM Controller/Administration Controller Non-Interactive Container Service Backgrounder
Cache Server Cluster Controller
Metrics Service
SAML Service
Administration Agent
Database Maintenance
Backup/Restored
Site Import/Export.
Which process is also installed when the first instance of Application Server is installed on a node? Internal Data Source Properties Interactive Container Service Saml Service Cluster Controller.
Tabcmd command to create initial admin user on a server tabcmd initialuser --username "admin" --password "password" --server <server> Workbook content will appear to be missing (not being returned in search results) Tableau Server will still work but actions may take longer All business services on that node will fail as well, and depending on those services Tableau Server may run in a degraded state.
Which API allows you to dynamically include popular data science programming languages, tools, and platforms? • Copying of extract files to and from the affected node stops.
• Removing extract files that are no longer needed on the affected node is suspended. (This removal process is usually referred to as "extract reaping.") Queries running through the Data Server process will fail, resulting in a failed view rendering, extract refresh, or alert. Any view that does not use Data Server for any of its data sources should still function correctly Analytics Extensions API
- Creates a connection to external services/calculation engine that expands power of Tableau Desktop script calculations
- Facilitates dynamic viz exploration -License Service/License Manager
-TSM Controller/Administration Controller.
What can you do to increase security when enabling JMX? -License Service/License Manager
-TSM Controller/Administration Controller Block off all other processes If there is only one process, then Tableau Server would no longer be able to render views Block off all other hosts from accessing the range of JMX ports.
SSL Port 143 443 80 8850.
What are the elements of Content Governance? Content Management
Authorization
Content Validation
Content Promotion
Content Certification
Content Utilization Data Source Management
Data Quality
Enrichment & Preparation
Data Security
Metadata Management
Monitoring & Management Cluster Controller
Metrics Service
SAML Service
Administration Agent
Database Maintenance
Backup/Restored
Site Import/Export .hyper extracts (must be upgraded to .hyper file if previously a .tde, as well as files such as excel or json as only .hyper files are encrypted).
Which process is responsible for reading and writing Metric data in Tableau Server? Ask Data Tableau Metric Reading Metrics Service Interactive Container Service.
PostgreSQL Port 443 8060 8160 3033.
What is the final step in a server upgrade and its TSM commands? Refresh and subscription jobs on the failed Backgrounder process are retried once the Backgrounder process recovers from failure. -Rebuild the search index
-tsm maintenance reindex search
-tsm maintenance reset-searchserver -Cleaup the server
-tsm maintenance cleaup
-tsm restart All business services on that node will fail as well, and depending on those services Tableau Server may run in a degraded state.
Which process handles fast search, filter, retrieval, and display of content metadata on the server? Gateway Cache Server Search and Browse Pickup and Delivery.
What happens if Data Engine process fails? All business services on that node will fail as well, and depending on those services Tableau Server may run in a degraded state. Ongoing extract refreshes will fail.
New refreshes of .tde extracts will not be impacted, but .hyper extract refreshes on that node WILL continue to fail until the engine is recovered
If a viz rendering is running any query on the failed node, rendering will fail
If the viz includes a shadow extract and the request is routed to a node with a failed Data Engine, the view rendering will continue to fail until engine is recovered -Change its schedule
>Change to schedule that enters queue earlier in day
>Change to schedule that runs more frequently
>Change schedule from serial to parallel
(Serial uses one backgrounder process and is slower
Parallel uses all available backgrounder processes)
-Change its priority It helps to avoid having your users sign in twice to access a view that is embedded into a webpage.
It does this through setting up trusted relationships between Tableau Server and 1 or more web servers.
TSM Port 8950 8850 8080 80.
Which part of Tableau Blueprint is AD synchronization included in? Implementation Maintenance Usability Deployment.
Which API allows you to query and discover metadata about Tableau content and external assets indexed by Tableau Catalog? Metadata API
- Enables users to engage in data discovery, lineage tracking, and impact analysis REST API Javascript API Extensions API
- Can interact with data from other business apps directly in Tableau
- Can integrate 3rd party functionality inside the dashboard
- Lets users modify data in a viz and have that change automatically update the source data in the data base or web app.
How many backgrounder processes can you have on a node? Up to half the number of physical cores on the node two Same number of physical cores on the node up the number of physical cores on the node.
What should you do during 72 hour window following initial node problem? Move License Service/License Manager and TSM Controller/Admin Controller to another node The entire Tableau Server cluster will be unavailable Request to Tableau Support Restart Tableau Server and request IT Team.
List authentication methods and their compatibility with Local Authentication vs. AD/LDAP: Authentication Method | Local | AD/LDAP
SAML | Yes | Yes
Kerberos | No | Yes
Mutual SSL | Yes | Yes
OpenID | Yes | No
Trusted Authentication | Yes | Yes is running
status is unavailable
is in a degraded state
is in an error state
is synchronizing
is decommissioning
is running (Active Repository)
is running (Passive Repository)
is stopped All business services on that node will fail as well, and depending on those services Tableau Server may run in a degraded state. Application Server
Backgrounder
VizQL Server
Data Server
File Store (only when configured locally).
What should you always do before upgrading to a new version of Tableau Server? It helps to avoid having your users sign in twice to access a view that is embedded into a webpage.
It does this through setting up trusted relationships between Tableau Server and 1 or more web servers. You can refresh extracts from Tableau Desktop (Refresh from Source option or republish the data source). You cannot use Tableau Bridge Backup Tableau Server and then store the .tsbak file on a computer outside of your Tableau Server installation On a separate node since Prep flows are CPU and RAM intensive.
A client has a single node deployment and wants to add a known number of extra users in the future. What tool can the client use to test the system's response? Dynamic Topology Tabjolt Tableau Data Management Tableau Server Management .
Which process is responsible for monitoring various components, detecting failures, and running failover when needed? Cluster Controller TSM Windows monitoring Cache Server.
Which processes are single-threaded, and will improve performance with additional instances? Backgrounder
Cache Server Vizql Server Backup/restore Data Server.
Which process manages connections to Tableau Server data sources? Vizql Server Elastic Server Data Engine Data Server.
Your client notices CPU usage is very high and would like to add more backgrounders to a dedicated node. What should the configuration be? 5 core 32 Gb 2 backgrounder processes 4 core 32 GB 2 backgrounder processes 4 core 64 Gb 2 backgrounder processes 8 core 64 Gb 2 backgrounder processes.
Tabcmd command to create users tabcmd creategroup <group name> tabcmd createusers <csv file> tabcmd addusers "Development" --users "users.csv" tabcmd users <csv file>.
What are the elements of Data Governance? Data Source Management
Data Quality
Enrichment & Preparation
Data Security
Metadata Management
Monitoring & Management Data Source Management
Data Quality
Enrichment & Preparation
Metadata Management
Monitoring & Management Data Source Management
Data Quality
Enrichment & Preparation
Data Server
Metadata Management
Monitoring & Management Data Visualization
Data Quality
Enrichment & Preparation
Data Security
Metadata Management
Monitoring & Management.
Ask Data Usage 2 unless the number of cores is fewer than 8 Usage patterns of Ask Data for a site
Distinct Users over time
Distinct data source owners over time
Top ask data users
Top ask data data sources
Top ask data data source owners What is the total data source usage by day?
What data sources are used most?
Who uses data sources most often? http://serverhost/views/workbookname/viewname?:record_performance=yes&:refresh=yes.
Which licensing and permission restrictions do embedded views follow? Lets admins see usage data for Tableau Desktop licenses
-Who is using a Tableau Desktop license in my enterprise?
-Have any licenses been shared or transferred?
-Is any license being used on a computer where it should not be?
-Does a specific user use their license?
-What types of licenses are being used in my enterprise?
-Do I need to convert any trial licenses? The same licensing and permission restrictions used on Tableau Server and Tableau Online. With role-based licenses, in order for a user to see a view that is embedded in a web page, the person accessing the view must also have an account on Tableau Server/Online. With core-based licensing, a guest account is available. This allows people in the organization to view embedded Tableau vizzes without signing into the server. Internal Data Source Properties - Maps
- Licensing
- External Data.
Out of the following checked boxes, which should a user deselect to promote faster view rendering in a published workbook?
- Show Selections
- Show Worksheets as Tabs
- Include External Files
- All of the above - Show Selections - Show Worksheets as Tabs - Include External Files - All of the above.
Which API enables Tableau to send an SMS whenever a data source refresh occurs, or notify a web app to synchronize data when a workbook is created? REST API Webhooks API
- Enables Tableau events to send an HTTP POST notification to the web location of your choice Metadata API
- Enables users to engage in data discovery, lineage tracking, and impact analysis Interactive and Non-Interactive MIcroservice Containers.
Authentication Mechanisms compatible with an Active Directory identity store only: Kerberos, Windows Automatic Login (SSPI) Trust Authentication, Local Authentication Site saml, openid connect All of the above.
Which part of Tableau Blueprint is resource management included in? Implementation Maintenance Independent Responding Usability.
Which TSM process monitors the coordination service for changes to configuration or topology and delivers new configurations to each service (configuration) or deploys new services and removes old ones (topology)? Administration/TSM Agent Coordination Service Cluster Controller Zookeeper.
Default Data Server Instances -Shows how many data quality warnings are active over a period of time
-How many warnings have been changed over that same time period
-Data quality warning details If there is only one process, then Tableau Server would no longer be able to render views 2 unless the number of cores is fewer than 8 one Instances.
Traffic to Views -Access & Interactions
-Publish & Download
-Subscriptions
-Default: 7 days Total view count per day
Total view count by time
What views are seen the most
Who accesses views most often -See how much disk space is in use on the computers that run Server and identify sudden changes in disk space usage
-Displayed as a decimal GB value
-What is the most recent disk space usage?
-How has free disk space trended in the last month? (by server name) Metadata API
- Enables users to engage in data discovery, lineage tracking, and impact analysis.
Which process acts as a proxy between Tableau Server and SAML Indentity Providers? Identity Management Service SAML Service Coordination Service Data Server.
Topology for Query Heavy Environments: - Separate the node with File Store from node with VizQL
- Typically 16 cores are recommended per node with 16 GB RAM per core
- Run one process of File Store on a separate node that isn't running VizQL or Backgrounder
- Run 2 VizQL processes, 2 Cache Server processes, and 2 Data Server processes on the nodes not running file store processes
- Have one File Store/Data Engine node for every 2 VizQL Server nodes
- Default config: 4 nodes for high availability considerations - Isolate backgrounder on a second node
- Run 2 VizQL processes, 2 Cache Server processes, and 2 Data Server processes -Change its schedule
>Change to schedule that enters queue earlier in day
>Change to schedule that runs more frequently
>Change schedule from serial to parallel
(Serial uses one backgrounder process and is slower
Parallel uses all available backgrounder processes)
-Change its priority 1. Disable Scheduled Tasks (refreshes, flows, subscriptions)
2. Run Setup:
- On initial node open prompt as admin
- Navigate to directory where setup program is stored and run it
- Run the setup program individually for each additional node (and don't select "Automatically launch the upgrade script"
- Note: server must be stopped right before completing upgrade
- Run the following on the initial node once the new version is installed on every node in the cluster:
upgrade-tsm
3. Start Tableau Server
- Run the following:
tsm start
4. Verify Tableau Server Upgrade
- in TSM command line, verify processes by running:
tsm status -v
- re-enable subscriptions scheduling
- verify TSM global settings, user access, published workbooks/data sources, tableau prep builder, count of tableau objects, API functionality
5. Uninstall previous version (from control panel) and delete 'Tableau Server' folders from \packages directory.
What does SMTP stand for? Hypertext Transfer Protocol Simple Mail Transfer Protocol Data Source Properties Simple Multiplex Tableau Port.
What is TabMon? Identify which workbooks and data sources are taking up the most disk space on the server
What Users Use the Most Space?
What Projects Use the Most Space?
What Workbooks and Data Sources Use the Most Space? (Bars color coded based on time since last refresh) A performance monitoring agent that can be used to analyze performance of a Tableau Server installation through periodically sampling target hosts for a set of Perfmon and MBean counters Displays delay for flow, extract refresh, and subscription tasks
How long did extracts wait before execution?
How long did subscriptions wait before execution? Analytics Extensions API
- Creates a connection to external services/calculation engine that expands power of Tableau Desktop script calculations
- Facilitates dynamic viz exploration.
Which process is used by Ask Data to index data? Internal Data Source Properties Cache Server Elastic Server Data Server.
Which processes are enabled for dynamic topology changes? Backgrounder
VizQL TSM Vizql Server Backgrounder Cache Server.
PostgreSQL backup Port 8061 1.0310 8051 443.
Options for changing a job's prioritization: A measure of tolerance of data loss in terms of time, i.e. the duration of time for which data loss is acceptable
- defined by how often you take backups
- more frequent backups = lower RPO
- if a backup takes 8 hours, that's your smallest RPO -tsm configuration set -k gateway.public.host -v "name" (ex: tableau.example.com)
-tsm configuration set -k gatweay.public.port -v 443
-tsm configuration set -k gateway-trusted -v (10.32.139.45, 10.32.139.46, 10.32, 139.47) OR (proxy1, proxy2, proxy3) It helps to avoid having your users sign in twice to access a view that is embedded into a webpage.
It does this through setting up trusted relationships between Tableau Server and 1 or more web servers. -Change its schedule
>Change to schedule that enters queue earlier in day
>Change to schedule that runs more frequently
>Change schedule from serial to parallel
(Serial uses one backgrounder process and is slower
Parallel uses all available backgrounder processes)
-Change its priority.
When should you run a backup? Midday During non-business hours Early morning Late afternoon.
Which single-threaded process is shared across the server cluster, and accepts requests from VizQL, backgrounder, data server, and sometimes application server? Cache Server Vizql Server Data Server Caching Server.
Steps in recovering from a (non-initial) node failure: 1. Run Controller recovery script on node that is still working. To do this, open Command Prompt, go to Tableau Server script directory, and type in following command:
Move-tsm-controller -n <nodeID>
(nodeID is the id for the node you want TSM controller to run on)
2. Close and reopen command window then verify TSM/Admin Controller is running on the node by running:
Tsm status -v
3. Stop Tableau Server by running:
Tsm stop --ignore-node-status <nodeID>
4. Add the license service to the node:
Tsm topology set-process -pr licenseservice -n <nodeID> -c 1
5. Remove the old License Service from the original node, where "nodeID" is the initial node that has failed:
Tsm topology set-process -pr licenseservice -n <nodeID> -c 0
6. If the initial node has been running the only instance of CFS, add CFS to this node:
Tsm topology set-process -pr clientfileservice -n node2 -c 1
7. If initial node was running messaging service add it to this node:
Tsm topology set-process -pr activemqserver -n node2 -c 1
8. (optional) also add other processed that were running on that node but not the new one.
Tsm topology set-process -pr <process name> -n node2 -c 1
9. Apply changes
Tsm pending-changes apply --ignore-node-status <nodeID>
- You may be prompted with a restart prompt (will be displayed even if server is stopped but in that case there is no restart)
- Prompt can be suppressed with --ignore-prompt, but doesn't change restart behavior
10. Restart TSM Controller (must be run as admin)
Net stop tabadmincontroller_0
Net start tabadmincontroller_0
11. Apply pending changes
Tsm pending-changes apply --ignore-node-status <nodeID>
12. Activate the Tableau Server license on the new Controller node:
Tsm licenses activate -k <product-key>
13. Verify license is properly activated:
Tsm licenses list
14. If initial node was running Coordination Service, run new coordination service ensemble that doesn't include that node. In 3 node cluster where initial node was running CS, deploy a NEW, single-instance CS on a diff node and clean up old ensemble.
Ex: tsm topology deploy-coordination-service -n node2 --ignore-node-status node1
15. If initial node was running file store instance, REMOVE that instance:tsm topology filestore decommission -n <nodeID> --delete-filestore
16. Apply pending changes and use --ignore-warnings flag if new CS ensemble you deployed is a single node ensemble:
Tsm pending-changes apply --ignore-node-status node1 --ignore-warnings
17. Remove initial node where nodeID is initial node that failed
Tsm topology remove-nodes -n <nodeID>
18. Apply pending changes and use --ignore-warnings flag if new CS ensemble you deployed is a single node ensemble
Tsm pending-changes apply --ignore-warnings
19. Start tableau server:
Tsm start
20. Replace initial node so cluster has original # of nodes. Ideally, only reuse the failed node if you know why it failed and can prevent from happening again Tableau Prep Conductor 1. Meet prerequisites:
- At least one functioning node has instance of File Store
- At least one functioning node has a Repository
- At least one functioning node has Client File Service (CFS)
2. Identify failed node:
Tsm status -v
(failed node will have "ERROR" status and process will be unavailable. Node ID is listed as "node<n>" with machine name following.
3. Stop Tableau Server. Run with --ignore-node-status, which runs without consideration of the status of the specified node.
Tsm stop --ignore-node-status <nodeID>
4. Determine if key processes were running on the node.
- If it was running the Messaging Service, you must remove the service from the failed node and add it to a new node.
>Remove from failed node:
Tsm topology set-process -pr activemqserver -n <nodeID> -c 0
>Add it to new node:
Tsm topology set-process -pr activemqserver - n <nodeID> -c 1
- If it was running Coordination Service, you must deploy new ensemble before removing the node: >Tsm topology deploy-coordination-service - n <good_nodeID> --ignore-node-status <failed_nodeID>
- If it was running the only instance of Client File Service (CFS), you must configure new instance of CFS on working node. You should config CFS on every node that is running the Coordination Service
- If it was running File Store, you need to force-decommission File Store and remove it before you can remove the node:
>Tsm topology filestore decommission -n <nodeID> --delete-filestore
>Apply pending changes (use -ignore-warnings if you had a 3 node cluster and a single Coordination Service instance)
>Tsm pending-changes apply --ignore-warnings --ignore-node-status <nodeID>
5. If cluster was 3 node cluster and there are repos on the remaining working nodes, either: REMOVE ONE REPOSITORY or ADD NEW NODE. (*NOTE: you are limited to 1 instance of the repo when you have fewer than 3 nodes)
- Remove one repo:
Tsm topology set-process - n <nodeID> -pr pgsql -c 0
6. Run command to remove failed node (adds change to the pending changes list):
Tsm topology remove-nodes -n <nodeID>
7. Verify node removal is pending:
Tsm pending-changes list
8. Apply pending changes to remove the node:
Tsm pending-changes apply
9. Start Tableau Server
Tsm start
10. Install Tableau Server on new node and config node w/ processes that the old, failed node was running
11. On a fresh computer (or original computer after removing Tableau), install Tableau using original Setup program and bootstrap file generated from initial node.
12. Redeploy new Coordination Service ensemble after nodes are all up and running
13. Add an instance of Client File Service (CFS) to every node that is running the Coordination Service A measure of tolerance of data loss in terms of time, i.e. the duration of time for which data loss is acceptable
- defined by how often you take backups
- more frequent backups = lower RPO
- if a backup takes 8 hours, that's your smallest RPO.
What happens when an Administration Agent process fails? Backup Tableau Server and then store the .tsbak file on a computer outside of your Tableau Server installation All other Tableau Server processes running on the same node will display as "unavailable". Server will run as expected but you cannot make config/topology changes Data Source Management
Data Quality
Enrichment & Preparation
Data Security
Metadata Management
Monitoring & Management Cluster Controller
Metrics Service
SAML Service
Administration Agent
Database Maintenance
Backup/Restored
Site Import/Export.
Which process (also known as VizPortal) handles the web application, REST API calls, and supports browsing and searching? Blade Server Cache Server Application Server Private Server.
Which process runs flows and processes flows for ingestion by Data Catalog? Elastic Server Tableau Prep Conductor Tableau Prep Flow Service Data Server
Data Engine.
What kind of files are covered by Encryption at Rest? You can refresh extracts from Tableau Desktop (Refresh from Source option or republish the data source). You cannot use Tableau Bridge .hyper extracts (must be upgraded to .hyper file if previously a .tde, as well as files such as excel or json as only .hyper files are encrypted) The share button at the top of each view (unless showShareOptions parameter is set to false) • Copying of extract files to and from the affected node stops.
• Removing extract files that are no longer needed on the affected node is suspended. (This removal process is usually referred to as "extract reaping.").
What happens if VizQL Server process fails? If there is only one process, then Tableau Server would no longer be able to render views Requests being handled by that instance will fail, but subsequent requests will be routed to other running Application Server processes. A measure of how much time can elapse before full recovery; that is, the maximum length of time within which a business process must be restored after a disruption.
- long RTO = longer downtime
- low RTO is good for mission-critical systems Ongoing extract refreshes will fail.
New refreshes of .tde extracts will not be impacted, but .hyper extract refreshes on that node WILL continue to fail until the engine is recovered
If a viz rendering is running any query on the failed node, rendering will fail
If the viz includes a shadow extract and the request is routed to a node with a failed Data Engine, the view rendering will continue to fail until engine is recovered.
Gateway Port 8060 80 8061 Usage patterns of Ask Data for a site
Distinct Users over time
Distinct data source owners over time
Top ask data users
Top ask data data sources
Top ask data data source owners.
What is the WDC? It helps to avoid having your users sign in twice to access a view that is embedded into a webpage.
It does this through setting up trusted relationships between Tableau Server and 1 or more web servers. A collection of APIs that enable developers to connect Tableau to any data on the web (examples: Reddit, Jira, Strava, Twitter, Facebook).
You can create your own WDC that reads data from virtually any site that publishes data in JSON, XML, or HTML -Identify content that hasn't been used or accessed in the specified time threshold
-% of total space usage being consumed by stale content
-Total space used by all stale content (GB)
-Space used by each object
-Content details Usage patterns of Ask Data for a site
Distinct Users over time
Distinct data source owners over time
Top ask data users
Top ask data data sources
Top ask data data source owners.
Which processes, when installed, will also include an installation of Data Engine? (unless the node already has an instance of Data Engine) Which processes, when installed, will also include an installation of Data Engine? (unless the node already has an instance of Data Engine) Application Server
Backgrounder
VizQL Server
Data Server
File Store (only when configured locally) -License Service/License Manager
-TSM Controller/Administration Controller Cluster Controller
Metrics Service
SAML Service
Administration Agent
Database Maintenance
Backup/Restored
Site Import/Export.
Which process should be installed on any node where Application Server is installed for improved performance? Data Source Properties Elastic Server Interactive Container Service Cluster Controller.
Which command creates a backup of workbook and user metadata, data extract files, and site configuration data in a .tsbak file? tsm maintenance backup tsm maintenance ziplogs maintenance tsm maintenance restore.
Which part of Tableau Blueprint is log file cleanup included in? Tsm Maintenance Ziplogs Monitoring Support Maintenance.
Which TSM process serves as the single source of truth? License Manager Coordination Service Cluster Controller Site Import/export.
Which API is used to create and deploy templates or migrate workbooks from test to production data sources? -Co-locate file File Store & TSM/Administration Controller on the same node (especially true if your org uses many extracts)
-Co-locate the repository & TSM/Administration Controller on the same node (time savings is less significant than first option) Backgrounder
Cache Server Document API
- It can get connection information from data sources and workbooks such as: server name, username, database name, authentication type, and connection type
- It can update connection information in workbooks and data sources such as: server name, username, database name
- It can get field information from data sources and workbooks, such as fields in a data source and fields being used by certain sheets - Slight to moderate increase in backgrounder load, as it alters existing jobs and introduces new jobs
- Increase in Viz Load Time and Worker Load (requires data to be decrypted once)
- Increases backup file size up to 50-100% (compression is ineffective on encrypted extracts)
- Increase time to restore a backup (added time for exchange of encryption keys)
*for server installations with many encrypted extracts, consider disabling compression for faster backups*.
Which process holds the PostgreSQL database that stores workbook and user metadata (and external assets metadata when Tableau Catalog is enabled)? Repository File Store Data Engine Data Server.
TSM command to restore backups: tsm settings export maintenance tsm maintenance backup tsm maintenance restore.
Stale Content Extract-specific tasks that run on the server
What Extracts Ran on this Server? Shows extracts that ran in the specified timeline
You can click Success or Error to filter by status
How much time did Extracts take?
How Many Extracts Succeeded or Failed by day? A measure of tolerance of data loss in terms of time, i.e. the duration of time for which data loss is acceptable
- defined by how often you take backups
- more frequent backups = lower RPO
- if a backup takes 8 hours, that's your smallest RPO -Identify content that hasn't been used or accessed in the specified time threshold
-% of total space usage being consumed by stale content
-Total space used by all stale content (GB)
-Space used by each object
-Content details is running
status is unavailable
is in a degraded state
is in an error state
is synchronizing
is decommissioning
is running (Active Repository)
is running (Passive Repository)
is stopped.
When is a Snapshot backup a viable backup option? Only when Tableau Serve is configured with External File Store. It helps to avoid having your users sign in twice to access a view that is embedded into a webpage.
It does this through setting up trusted relationships between Tableau Server and 1 or more web servers. -Rebuild the search index
-tsm maintenance reindex search
-tsm maintenance reset-searchserver Move License Service/License Manager and TSM Controller/Admin Controller to another node.
Range of ports reserved for dynamic mapping of Tableau processes 8000-9000 2000-4000 8010-8013 7990-8000.
Authentication Mechanisms compatible with Local, Active Directory, and LDAP identity stores: Backgrounder Vizql Messaging Services Basic, SAML, Trusted Authentication, Mutual SSL Site Saml, Openid Connect.
Elastic Server characteristics: What is the total data source usage by day?
What data sources are used most?
Who uses data sources most often? Queries running through the Data Server process will fail, resulting in a failed view rendering, extract refresh, or alert. Any view that does not use Data Server for any of its data sources should still function correctly - Can be running on more than one node in a cluster
- Can be moved to any node
- Should have an odd number of instances running Data Source Management
Data Quality
Enrichment & Preparation
Data Security
Metadata Management
Monitoring & Management.
How do you increase Elastic Server heap size? tsm configuration set -k elasticserver.vmopts -v tsm settings export data source properties backgrounder
cache server.
Which two processes are included on initial node and can always be moved to other nodes? Client File Service (CFS)
Coordination Service File Store
Client File Service(CFS) File Store
Coordination Service File Store
TSM.
Which process provides the interactive Prep Flow experience in the browser? Tableau Prep Flow Authoring Prep Conductor Tableau Prep Minerva Service Centralized.
True or False: You can use VM snapshots for backing up Tableau Server - Adjust number of VizQL processes (add one at a time)
- Increase the number of cache server processes
- Reduce the number of backgrounder processes True False.
You must use tsm maintenance backup to create a backup of repository and file store data (contains workbook and user metadata, extract files, and site configuration data)
You must use tsm setting export to backup configuration and topology data A measure of tolerance of data loss in terms of time, i.e. the duration of time for which data loss is acceptable
- defined by how often you take backups
- more frequent backups = lower RPO
- if a backup takes 8 hours, that's your smallest RPO.
What happens if a File Store process fails? is running
status is unavailable
is in a degraded state
is in an error state
is synchronizing
is decommissioning
is running (Active Repository)
is running (Passive Repository)
is stopped It helps to avoid having your users sign in twice to access a view that is embedded into a webpage.
It does this through setting up trusted relationships between Tableau Server and 1 or more web servers. • Copying of extract files to and from the affected node stops.
• Removing extract files that are no longer needed on the affected node is suspended. (This removal process is usually referred to as "extract reaping.") A measure of tolerance of data loss in terms of time, i.e. the duration of time for which data loss is acceptable
- defined by how often you take backups
- more frequent backups = lower RPO
- if a backup takes 8 hours, that's your smallest RPO.
Which service provides published data source metadata to client services like Ask Data? Repository Data Source Properties Data Server Elastic Server.
Default VizQL Process Instances Only when Tableau Serve is configured with External File Store. Block off all other hosts from accessing the range of JMX ports Total view count per day
Total view count by time
What views are seen the most
Who accesses views most often Equal to (# cores)/4, up to a maximum of 4 process instances.
Which service is used to support communication between microservices in Tableau Server? Message Telephony Unified Messaging Hardware Requirements Messaging Services.
Where should Tableau Prep Conductor be installed? The share button at the top of each view (unless showShareOptions parameter is set to false) - Maps
- Licensing
- External Data On a separate node since Prep flows are CPU and RAM intensive During non-business hours.
Which API is used to connect to connect to data sources and write the data into extract files and write custom scripts that update/read data in existing extract files? Hyper API
- Gets data from non-supported data sources into Tableau
- Updates data within extract files
- Accesses data from an extract
- Creates .hyper files REST API Metadata API
- Enables users to engage in data discovery, lineage tracking, and impact analysis Javascript API.
Authentication Mechanisms compatible with a local identity store only: Site SAML, OpenID Connect Kerberos, Windows Automatic Login (SSPI) Trusted Authentication, SAML LDAP, OpenID.
Which port cannot be changed? 443 143 80
8060.
Range of ports used by Tableau Server for License Service. This range must be open on the node running the license service and accessible from other nodes. 8000-9000 26990-26995 27000-27009 27020-27030.
Which process controls the storage of extracts? Elastic Server Data Server File Store Repository.
Which process loads and renders views, computes, and executes queries? Data Server VizQL Server Cache Server Application Server.
Which process is responsible for performing maintenance operations on the Tableau Server repository? Distributed Databases Operational Systems Database Maintenance Database Recovery.
Which process is required on any node with an instance of VizQL Server or Vizportal/Application Server? Gateway Ask Data Router Application Server.
Tableau Bridge can connect to the following: Relational Data
File Data
Private cloud data and some ODBC data
Some web data connector (WDC) data. (Bridge CANNOT access a data provider's website using OAuth, like Salesforce/Google or WDC data sources like Facebook/Twitter/QBO) tabcmd addusers "groupname" --users <csv file> tabcmd login -s <server> -t <site> -u <username> -p <password False.
You must use tsm maintenance backup to create a backup of repository and file store data (contains workbook and user metadata, extract files, and site configuration data)
You must use tsm setting export to backup configuration and topology data.
Which process runs server tasks, including extract refreshes, subscriptions, 'Run Now' tasks, and tasks initiated from tabcmd? Data Server Beefmaster Backgrounder Stocker.
Topology to optimize for extracts: Content Management
Authorization
Content Validation
Content Promotion
Content Certification
Content Utilization Include "refresh=yes" at the end of the URL
Example: http://serverhost/views/workbookname/viewname?:record_performance=yes&:refresh=yes -Change its schedule
>Change to schedule that enters queue earlier in day
>Change to schedule that runs more frequently
>Change schedule from serial to parallel
(Serial uses one backgrounder process and is slower
Parallel uses all available backgrounder processes)
-Change its priority - Isolate backgrounder on a second node
- Run 2 VizQL processes, 2 Cache Server processes, and 2 Data Server processes.
What does Trusted Authentication help to avoid? All other Tableau Server processes running on the same node will display as "unavailable". Server will run as expected but you cannot make config/topology changes - Slight to moderate increase in backgrounder load, as it alters existing jobs and introduces new jobs
- Increase in Viz Load Time and Worker Load (requires data to be decrypted once)
- Increases backup file size up to 50-100% (compression is ineffective on encrypted extracts)
- Increase time to restore a backup (added time for exchange of encryption keys)
*for server installations with many encrypted extracts, consider disabling compression for faster backups* Shows info on other tasks that aren't refreshes: edited Oauth connections, subscription notifications, etc.
-How Many Tasks Succeeded or Failed on this Site?
-What Background Tasks Ran on this Site? It helps to avoid having your users sign in twice to access a view that is embedded into a webpage.
It does this through setting up trusted relationships between Tableau Server and 1 or more web servers.
In which kind of governance model is there a strong collaboration between IT and business users, fostering the availability of certified content/data sources, ad-hoc content, as well as a clearly-defined process of validation, promotion, and certification? Self-Governing Federation Delegated Centralized.
If a user is not seeing their views show up on the server and is getting extract refresh failure notifications for workbooks with no data extracts, which process is failing? Metrics service Search & Browse Data source Properties SAML service.
What happens if Data Server process fails? Refresh and subscription jobs on the failed Backgrounder process are retried once the Backgrounder process recovers from failure. If there is only one process, then Tableau Server would no longer be able to render views Queries running through the Data Server process will fail, resulting in a failed view rendering, extract refresh, or alert. Any view that does not use Data Server for any of its data sources should still function correctly You can refresh extracts from Tableau Desktop (Refresh from Source option or republish the data source). You cannot use Tableau Bridge.
Topology to optimize for user traffic: - Adjust number of VizQL processes (add one at a time)
- Increase the number of cache server processes
- Reduce the number of backgrounder processes - Adjust number of backgrounders processes (add one at a time)
- Increase the number of cache server processes
- Reduce the number of VizQL processes - Separate the node with File Store from node with VizQL
- Typically 16 cores are recommended per node with 16 GB RAM per core
- Run one process of File Store on a separate node that isn't running VizQL or Backgrounder
- Run 2 VizQL processes, 2 Cache Server processes, and 2 Data Server processes on the nodes not running file store processes
- Have one File Store/Data Engine node for every 2 VizQL Server nodes
- Default config: 4 nodes for high availability considerations - Separate the node with File Store from node with VizQL
- Typically 16 cores are recommended per node with 32 GB RAM per core
- Run one process of File Store on a separate node that isn't running VizQL or Backgrounder
- Run 2 VizQL processes, 2 Cache Server processes, and 2 Data Server processes on the nodes not running file store processes
- Have one File Store/Data Engine node for every 4 VizQL Server nodes
- Default config: 4 nodes for high availability considerations.
Which API allows you to create an extension with write-back functionality in order to increase viz interactivity? -Co-locate file File Store & TSM/Administration Controller on the same node (especially true if your org uses many extracts)
-Co-locate the repository & TSM/Administration Controller on the same node (time savings is less significant than first option) Analytics Extensions API
- Creates a connection to external services/calculation engine that expands power of Tableau Desktop script calculations
- Facilitates dynamic viz exploration REST API Extensions API
- Can interact with data from other business apps directly in Tableau
- Can integrate 3rd party functionality inside the dashboard
- Lets users modify data in a viz and have that change automatically update the source data in the data base or web app.
In which kind of governance model are new roles (outside of IT or a central authority) introduced such as Site Administrators, Data Stewards, and Content Authors with increasing collaboration between IT and business users? Centralized Decentralized Self-governing Delegated.
Default Cache Server Instances 2 unless the number of cores is fewer than 8 One instance more than four and less than eight Same as TSM instances.
SMTP Port 25 Simple Mail Transfer Protocol 80 8000-9000.
Tabcmd command to synchronize an Active Directory group internal data source properties tabcmd syncgroup <group name> tsm maintenance backup tabcmd createusers <csv file>.
Tabcmd command to synchronize an Active Directory group tabcmd groupsync <group name> tabcmd syncgroup <group name> tabcmd syncactivedir <group name> tabcmd createusers <csv file>.
You notice that AD synchronization tasks are taking a long time. Which view will help you troubleshoot? Background Tasks for Non Extracts IT Team. Background Tasks for Extracts
Backgrounder Vizql.
What happens when a Service Manager process fails? If there is only one process, then Tableau Server would no longer be able to render views All business services on that node will fail as well, and depending on those services Tableau Server may run in a degraded state. A measure of tolerance of data loss in terms of time, i.e. the duration of time for which data loss is acceptable
- defined by how often you take backups
- more frequent backups = lower RPO
- if a backup takes 8 hours, that's your smallest RPO Backup Tableau Server and then store the .tsbak file on a computer outside of your Tableau Server installation.
Which two container processes are for internal Tableau Server microservices that are bundled together for ease of deployment and scalability purposes? Client File Service (CFS)
Coordination Service Data Source Properties Interactive and Non-Interactive MIcroservice Containers Background Tasks for Non Extracts.
What happens when a Gateway process fails? All other Tableau Server processes running on the same node will display as "unavailable". Server will run as expected but you cannot make config/topology changes The entire Tableau Server cluster will be unavailable • Copying of extract files to and from the affected node stops.
• Removing extract files that are no longer needed on the affected node is suspended. (This removal process is usually referred to as "extract reaping.") Refresh and subscription jobs on the failed Backgrounder process are retried once the Backgrounder process recovers from failure.
TSM commands for configuring a load balancer: tabcmd addusers "groupname" --users <csv file> -tsm configuration set -k gateway.public.host -v "name" (ex: tableau.example.com)
-tsm configuration set -k gateway.public.port -v 443
-tsm configuration set -k gateway-trusted -v (10.32.139.45, 10.32.139.46, 10.32, 139.47) OR (proxy1, proxy2, proxy3) Configure identity store settings:
tsm settings import -f path-to-file.json
Configure gateway settings (optional):
tsm settings import -f path-to-json-file.json
Configure product usage data (optional):
tsm setting import -f path-to-json-file.json
Configure sample workbook installation (optional):
tsm configuration set -k install.component.samples -v false
Apply pending configuration changes:
tsm pending-changes apply
Verify LDAP configuration:
tsm user-identity-store verify-user-mappings -v <user name>
tsm user-identity-store verify-group-mappings -v <group name> -tsm configuration set -k gateway.public.host -v "name" (ex: tableau.example.com).
A user wants to be able to view the Desktop License Usage and Desktop License Expiration dashboards with the lowest possible permissions capabilities. What role should they get? Security Manager Network Engineer Server Administrator Explore(Can publish).
Data Quality Warning History -Shows how many data quality warnings are active over a period of time
-How many warnings have been changed over that same time period
-Data quality warning details Content Management
Authorization
Content Validation
Content Promotion
Content Certification
Content Utilization -Shows how many data quality warnings aren't active over a period of time
-How many warnings have been changed over that same data source
-Data quality details What is the total data source usage by day?
What data sources are used most?
Who uses data sources most often?.
Where do you find a view's embed code? The share button at the top of each view (unless showShareOptions parameter is set to false) Block off all other hosts from accessing the range of JMX ports Workbook content will appear to be missing (not being returned in search results) A measure of how much time can elapse before full recovery; that is, the maximum length of time within which a business process must be restored after a disruption.
- long RTO = longer downtime
- low RTO is good for mission-critical systems.
Tabcmd command to create group tabcmd syncgroup <group name> tabcmd creategroup <group name> tabcmd groupcreate <group name> tabcmd groupsync <group name>.
|
