MCQs on Tableau Server and Tableau Online | Tableau Server Management
1. Overview of Tableau Server and Tableau Online
- What is the primary difference between Tableau Server and Tableau Online?
a) Tableau Server is hosted by Tableau, while Tableau Online is hosted by the user
b) Tableau Server is on-premises, while Tableau Online is cloud-based
c) Tableau Server is used for analytics, while Tableau Online is used for data storage
d) Tableau Server is a free product, while Tableau Online requires a paid subscription - Which of the following is a key benefit of using Tableau Online over Tableau Server?
a) Tableau Online requires no installation or maintenance
b) Tableau Online is faster due to being on-premises
c) Tableau Online provides unlimited data storage
d) Tableau Online allows for unlimited user access - What type of deployment model is used by Tableau Server?
a) On-demand deployment
b) Cloud-based deployment
c) On-premises or private cloud deployment
d) SaaS (Software as a Service) - Which of the following can be achieved by using Tableau Server?
a) Hosting Tableau dashboards and providing user access via a web browser
b) Data preparation and cleaning tasks
c) Data extraction and transformation
d) Scheduling reports only - Which of the following best describes Tableau Online?
a) A cloud-based version of Tableau Server with similar features but hosted by Tableau
b) A web-based analytics tool that only supports data visualization
c) A platform designed only for data storage without visualization capabilities
d) A local installation that requires internal hardware
2. Publishing Workbooks to Tableau Server
- Which of the following is required to publish a workbook to Tableau Server?
a) Tableau Server must be installed on the user’s local machine
b) The workbook must be saved as a Tableau Packaged Workbook (.twbx)
c) A Tableau Online account is required for publishing
d) The user must have the necessary permissions to publish the workbook - What happens when a workbook is published to Tableau Server?
a) It is stored on the local machine of the user who published it
b) The workbook is shared with other users based on their permissions
c) The workbook is automatically refreshed every hour
d) The workbook is converted into a static image - Which feature allows users to publish workbooks and data sources to Tableau Server directly from Tableau Desktop?
a) Tableau Publisher
b) Tableau Server Connector
c) Tableau Desktop Server Sync
d) Tableau Desktop’s “Server” menu - When publishing a workbook to Tableau Server, which option allows you to control who can view and interact with the workbook?
a) Publishing permissions
b) Workbook password protection
c) User roles and permissions
d) Filter permissions - Which Tableau feature ensures that published workbooks are always up to date with the latest data from the source?
a) Data Extracts
b) Auto-refresh schedules
c) Live connections
d) Custom Views
3. Managing Permissions and Security
- Which Tableau Server role allows users to manage site settings, users, and permissions?
a) Viewer
b) Server Administrator
c) Site Administrator
d) Publisher - What is the primary function of permissions in Tableau Server?
a) To restrict data sources
b) To control who can access, view, and interact with dashboards and workbooks
c) To filter out irrelevant data
d) To set refresh intervals for data - Which of the following is a best practice for securing Tableau Server?
a) Assigning users to the “Server Administrator” role by default
b) Implementing strong password policies and multi-factor authentication
c) Allowing all users to have full access to workbooks
d) Only using the default permission settings without modification - Which of the following is the most granular level of permissions that can be configured in Tableau Server?
a) Project level
b) Workbook level
c) Data source level
d) Row-level security - What is the role of “Project Leader” in Tableau Server?
a) To manage workbooks and permissions within a project
b) To schedule extract refreshes for the project
c) To monitor Tableau Server performance
d) To handle Tableau Server installations
4. Data Governance in Tableau Server
- What is a key component of data governance in Tableau Server?
a) Data clean-up tools
b) Access control and permission management
c) Extract automation
d) Data preparation scripting - Which Tableau feature enables administrators to control which data users can see at a more granular level?
a) Row-level security
b) Workbook filters
c) Site-level permissions
d) Data source management - In Tableau Server, which of the following is used to ensure that data is only accessible to authorized users?
a) Project permissions
b) Data source filters
c) Row-level security
d) Data extracts - What is the primary responsibility of a Tableau Server Administrator in terms of data governance?
a) To ensure data is cleaned and formatted correctly
b) To monitor performance and optimize queries
c) To manage access to Tableau data and workbooks
d) To schedule refreshes for all data sources - Which type of Tableau Server security ensures that sensitive data is protected based on user-specific roles or data attributes?
a) User-based security
b) Row-level security
c) Server-level security
d) Data-source security
5. Scheduling and Refreshing Extracts
- Which of the following allows users to schedule extract refreshes in Tableau Server?
a) Tableau Prep
b) Tableau Server’s “Schedules” tab
c) Tableau Online’s data refresh schedule
d) Manual refresh in Tableau Desktop - What is the purpose of scheduling extract refreshes on Tableau Server?
a) To automate the process of uploading workbooks
b) To keep the published workbook data updated with the latest changes
c) To optimize Tableau’s performance
d) To back up the data - Which type of data connection must be used to schedule an extract refresh on Tableau Server?
a) Live data connections
b) Tableau data extract (TDE)
c) CSV file connections
d) Data source connections - What happens when an extract refresh is scheduled in Tableau Server?
a) The data in Tableau Server is automatically backed up
b) The server triggers a manual refresh
c) The data in the extract is updated according to the defined schedule
d) The workbook is republished - How can an administrator monitor the status of scheduled extract refreshes on Tableau Server?
a) By viewing the “Extract Refreshes” tab in Tableau Server
b) By manually checking each workbook
c) By setting up email notifications
d) By using Tableau Desktop
6. Monitoring and Managing Performance on Tableau Server
- What is a common method to monitor the performance of Tableau Server?
a) Using the Tableau Server Performance Recording feature
b) Checking the extract logs manually
c) Tracking the number of workbook views
d) Manually refreshing all extracts - Which of the following can be done to optimize Tableau Server performance?
a) Enabling full caching for all workbooks
b) Limiting the number of users on Tableau Server
c) Using extract connections instead of live data connections
d) Disabling all server-based permissions - What can Tableau Server Administrators use to diagnose and troubleshoot performance issues?
a) The Tableau Server Status page
b) The Data Server console
c) The Performance Recording feature
d) The Tableau Desktop interface - Which Tableau Server feature provides detailed logs about server performance and usage?
a) Server Logs
b) Performance Recording
c) Workbook Activity Log
d) Data Extract Logs - How can Tableau Server administrators manage resource allocation for specific users or groups?
a) By using “User Filters”
b) By adjusting the server hardware configurations
c) By setting user roles and resource quotas
d) By creating a dedicated server instance for each group
Answer Key (Tabular Form)
| Qno | Answer (Option with Text) |
|---|---|
| 1 | b) Tableau Server is on-premises, while Tableau Online is cloud-based |
| 2 | a) Tableau Online requires no installation or maintenance |
| 3 | c) On-premises or private cloud deployment |
| 4 | a) Hosting Tableau dashboards and providing user access via a web browser |
| 5 | a) A cloud-based version of Tableau Server with similar features but hosted by Tableau |
| 6 | d) The user must have the necessary permissions to publish the workbook |
| 7 | b) The workbook is shared with other users based on their permissions |
| 8 | d) Tableau Desktop’s “Server” menu |
| 9 | c) User roles and permissions |
| 10 | b) Auto-refresh schedules |
| 11 | c) Site Administrator |
| 12 | b) To control who can access, view, and interact with dashboards and workbooks |
| 13 | b) Implementing strong password policies and multi-factor authentication |
| 14 | d) Row-level security |
| 15 | a) To manage workbooks and permissions within a project |
| 16 | b) Access control and permission management |
| 17 | a) Row-level security |
| 18 | c) Row-level security |
| 19 | c) To manage access to Tableau data and workbooks |
| 20 | b) Row-level security |
| 21 | b) Tableau Server’s “Schedules” tab |
| 22 | b) To keep the published workbook data updated with the latest changes |
| 23 | b) Tableau data extract (TDE) |
| 24 | c) The data in the extract is updated according to the defined schedule |
| 25 | a) By viewing the “Extract Refreshes” tab in Tableau Server |
| 26 | a) Using the Tableau Server Performance Recording feature |
| 27 | c) Using extract connections instead of live data connections |
| 28 | c) The Performance Recording feature |
| 29 | b) Performance Recording |
| 30 | c) By setting user roles and resource quotas |