General Flashcards
What are the client Components?
Tableau Desktop, tabcmd and web browser
What are the server components?
Application, Background task, VizQL, Data server, Data Engine, Repository, Gateway
What are the minimum requirements for production environments
8 Cores 2ghz, 32 GB RAM, 50 GB free disk
What are the requirements for very small deployments
4 cores 2ghz, 8GB RAM, 1,5 minimum free disk space
When to add workers and reconfigure?
- When you deployment is user-intensive
- When there is a heavy use of extracts
- When there are frequent extract refreshes
- when you want improve performance and availability
what is the best method to improve performance for an extract-intensive deployment?
is to isolate the data engine process and backgrounder in two different machines.
which command identify the current version of Tableu server?
tabcmd version
what are the OS supported by Tableau server?
Windows Server 2003 R2 SP2 or higher, Windows Server 2008, Windows Server 2008 R2,
Windows Server 2012,Windows Server 2012 R, Windows 7, Windows 8, or Windows 8.1
Application server process can be load just by a browser-based interaction? True or false
False, it can be also load by running tabcmd
what is the main function of Application server process ?
Handle the web application , supports browsing and searching
The backgrounder process consume a lot of CPU, i/o or network resources, but no much memory. True or false
True
Data Engine is the process that load extracts into memory and perform queries against them. True or false
True
The data engine’s workload is
generated by requests from the VizQL Server process. True or false
True
What processes are multi threaded?
Data Engine, Application server, data server, search and explore and VizQL server
when is it loaded the data server process?
When : is generated by browser, by tableau desktop interactions and extract refresh jobs for Tableau Server data sources.
Which process Loads and renders views, computes and executes queries.
the VizQL server process
what processes need license?
Application server, Background, Data engine, data server, VizQL server
Describe a typical high availability environment
High availability environments are a 4-node cluster with one primary, a failover primary and two workers. The primaries typically only run the gateway while the workers run all processes, specifically the data engine
Tableau workers server ports
3730 – 3731
Data Engine Port
27042
How many data engine proceses can be per node?
There can be up to two data engine processes per node, on up to two nodes in a cluster
What are the processes that don´t required database drivers?
Data Engine, Repository and Gateway
Cube data sources support pass-through connections. True or false?
false
You can set filters in a workbook or data source that control which data a person sees in a published view, based on their Tableau Server login account. True or false
true
Network issues typically come from?
the backgrounder, data engine, data server, or VizQL
What are the services you have to check when there is a problem?
FLEXnet Licensing Service, Secondary Login , Tableau Server(tabsvc), Tablicsrv
What command is needed to removes all log files and temporary files (leave http_requests entries
untouched)
Tabadmin cleanup –restart
Steps to connect to postgres database
Enable external password using “tabadmin dbpass ”, Connect in Tableau Desktop , Enter server name, DB name is workgroup, Default port is 8060, Username is “tableau”, Password is whatever was
Schedules are not local to a site they are global. If you run a schedule it will run all tasks associated to that schedule regardless of site. True or false
TRue
What does Tabadmin ziplogs –d 01/31/2014 mylogs.zip
it creates mylogs.zip and includes logs dated 1/31/2014 to present, excludes earlier
What does Tabadmin configure
Updates configuration by forcing an update to all files in the“ProgramData\Tableau\Tableau Server\data\tabsvc\ —–This includes refreshing the master service configuration file, workgroup.yml When a config change is made it is best practice to run tabadmin config to ensure that all files
are updated
Who executes failover when needed?
- Cluster Controller
- Coordination service
- Failover service
- Data Engine
Cluster controller
What an interactor can do?
Allows to view the workbook or view on the server, edit workbook views, apply filters, view underlying data, export images, and export data.