Download [TSCA] Tableau Server Certified Associate Certification Exam Guide and more Exams Technology in PDF only on Docsity!
Certification Exam Guide
Question 1. Which Tableau Server component is responsible for routing client requests to the appropriate internal service? A) VizQL Server B) Data Engine (Hyper) C) Gateway D) Backgrounder Answer: C Explanation: The Gateway receives incoming HTTP/HTTPS requests and forwards them to the correct internal Tableau Server process. Question 2. What is the primary function of the VizQL Server? A) Store extracted data files B) Translate visual queries into SQL and render visualizations C) Manage user authentication D) Schedule background tasks Answer: B Explanation: VizQL Server converts user actions into queries, executes them against data sources, and renders the visual output. Question 3. Which process handles extract refreshes and scheduled tasks on Tableau Server? A) VizPortal B) Backgrounder C) Data Engine D) Repository Answer: B
Certification Exam Guide
Explanation: Backgrounder runs extract refreshes, subscriptions, and other scheduled jobs. Question 4. The Tableau Server Repository stores which type of information? A) Extracted data files B) User credentials only C) Metadata about sites, users, workbooks, and permissions D) Rendered images of views Answer: C Explanation: The PostgreSQL Repository holds configuration metadata, not the actual data extracts. Question 5. In a multi-node Tableau Server cluster, which node initially hosts the Repository? A) Any node that runs the Backgrounder service B) The Initial Node configured during installation C) The node with the most CPU cores D) The node designated as the Data Engine node Answer: B Explanation: The Initial Node is the first node set up and contains the Repository and primary services. Question 6. Which operating system is NOT officially supported for Tableau Server installation? A) Windows Server 2019 B) Red Hat Enterprise Linux 8 C) macOS Catalina
Certification Exam Guide
C) SAML Authentication D) Kerberos Authentication Answer: B Explanation: LDAP authentication integrates Tableau Server with Active Directory for credential validation. Question 10. Which single sign‑on protocol uses XML‑based assertions to authenticate users? A) Kerberos B) SAML C) OAuth D) OpenID Connect Answer: B Explanation: SAML exchanges signed XML assertions between the identity provider and Tableau Server. Question 11. To enable Kerberos authentication, which service account must be configured on the Tableau Server? A) Tableau Server Administrator B) Service Account (runas) C) Guest Account D) Data Engine Account Answer: B Explanation: A domain service account is required for Kerberos ticket delegation. Question 12. Which component stores extracted data files on disk?
Certification Exam Guide
A) Repository B) VizQL Server C) Data Engine (Hyper) D) Backgrounder Answer: C Explanation: The Hyper Data Engine manages .hyper extract files on the file store. Question 13. What is the purpose of the Data Server in Tableau Server? A) Host the Repository database B) Provide centralized metadata and shared data source publishing C) Render visualizations for end users D) Manage background tasks Answer: B Explanation: Data Server enables publishing and sharing of data source metadata across sites. Question 14. Which email protocol is used by Tableau Server to send subscription and alert notifications? A) POP B) IMAP C) SMTP D) FTP Answer: C Explanation: Tableau Server connects to an SMTP server to send outbound emails. Question 15. Which site role can create, edit, and delete content, but cannot manage users?
Certification Exam Guide
Question 18. Core‑based licensing is measured by which of the following? A) Number of concurrent users B) Number of CPU cores on the server C) Number of published workbooks D) Number of sites created Answer: B Explanation: Core‑based licensing is tied to the physical or virtual CPU cores of the Tableau Server hardware. Question 19. Which command creates a full backup of a Tableau Server environment? A) tsm maintenance backup B) tsm backup create C) tsm repository backup D) tsm server backup Answer: A Explanation: tsm maintenance backup captures the Repository, configuration, and file store. Question 20. What is the primary difference between a server backup and a repository backup? A) Server backup includes only extract files, repository backup includes only metadata B) Server backup captures the entire environment; repository backup captures only the PostgreSQL metadata C) Server backup is performed on Linux only, repository backup on Windows only D) There is no difference; they are synonymous Answer: B
Certification Exam Guide
Explanation: Server backup includes file store, configuration, and repository; repository backup contains only the PostgreSQL metadata. Question 21. Which Tableau Server administrative view shows the number of active sessions per user? A) Traffic to Views B) Server Usage C) Background Jobs D) User Activity Answer: D Explanation: The User Activity view provides session counts and interaction details per user. Question 22. On a Linux Tableau Server, which command provides a real‑time view of CPU and memory usage? A) tsm status monitor B) top C) ps aux D) vmstat Answer: B Explanation: top displays live system resource utilization. Question 23. Which log file would you examine to troubleshoot a failed extract refresh? A) vizqlserver.log B) backgrounder.log C) dataserver.log D) tabsvc.log
Certification Exam Guide
Answer: D Explanation: “Degraded” reflects issues; if all services are healthy, status would be “Active”. Question 27. When adding users via CSV, which column is mandatory? A) Email B) Username C) Site Role D) Group Membership Answer: B Explanation: The CSV import requires a unique Username for each user. Question 28. Which permission allows a user to download a workbook’s data as a CSV file? A) View B) Export Data C) Save As D) Publish Answer: B Explanation: “Export Data” grants the ability to download underlying data from a view. Question 29. What is the effect of enabling “Project Locking” on a project? A) Prevents any content from being added to the project B) Forces all content within the project to inherit the project’s permissions C) Locks the project’s name from being changed D) Disables background extract refreshes for the project Answer: B
Certification Exam Guide
Explanation: Project locking ensures that permissions are inherited and cannot be overridden at the content level. Question 30. Which of the following best describes a “Site” in Tableau Server? A) A collection of servers in a cluster B) An isolated environment with its own users, groups, and content C) A single workbook published to the server D) A physical location where the server hardware resides Answer: B Explanation: Sites provide multi‑tenant isolation within a single Tableau Server deployment. Question 31. Which command would you use to clean up old log files and free disk space? A) tsm maintenance cleanup B) tsm logs purge C) tsm cleanup logs D) tsm maintenance delete-logs Answer: A Explanation: tsm maintenance cleanup removes archived logs and temporary files. Question 32. What is the recommended minimum RAM for a single‑node Tableau Server handling moderate load? A) 4 GB B) 8 GB C) 16 GB D) 32 GB Answer: C
Certification Exam Guide
D) Repository Answer: A Explanation: VizQL Server renders visualizations into image formats for clients that cannot run JavaScript. Question 36. What does the “Initial Node” designation affect during a Tableau Server upgrade? A) Only the Initial Node is upgraded; others remain unchanged B) The Initial Node hosts the Repository and must be upgraded first C) The Initial Node is automatically removed after upgrade D) The Initial Node determines the license key for the entire cluster Answer: B Explanation: During an upgrade, the Initial Node’s Repository must be upgraded before other nodes join. Question 37. Which setting controls the maximum number of concurrent extract refreshes on a node? A) backgrounder.max_concurrent_jobs B) vizqlserver.max_threads C) dataengine.max_extracts D) repository.max_connections Answer: A Explanation: backgrounder.max_concurrent_jobs defines how many extract jobs can run simultaneously. Question 38. Which of the following is NOT a supported data connector out of the box? A) Snowflake
Certification Exam Guide
B) MongoDB C) PostgreSQL D) Microsoft SQL Server Answer: B Explanation: Tableau Server does not include a native MongoDB connector; it requires a custom ODBC driver. Question 39. In Tableau Server, what does the “Viewer” site role permit? A) Create and edit workbooks B) Publish data sources C) Interact with dashboards and download images D) Manage users and groups Answer: C Explanation: Viewers can view and interact with content but cannot author or publish. Question 40. Which TSM setting is used to change the default HTTPS port? A) gateway.port B) http.port C) https.port D) ssl.port Answer: C Explanation: https.port configures the port on which the Gateway serves HTTPS traffic. Question 41. What is the purpose of the “File Store” in Tableau Server architecture? A) Store metadata about users and groups
Certification Exam Guide
Question 44. Which backup option allows you to restore only the Repository without affecting extracts? A) Full server backup B) Incremental backup C) Repository‑only backup (tsm maintenance backup --repository-only) D) File store backup Answer: C Explanation: The --repository-only flag creates a backup limited to the PostgreSQL metadata. Question 45. Which Tableau Server view provides insight into long‑running background jobs? A) Background Jobs B) Server Monitoring C) Traffic to Views D) Performance Summary Answer: A Explanation: The “Background Jobs” view lists job IDs, durations, and status. Question 46. What is the effect of disabling “Automatic Refresh” on a published extract? A) The extract will never be refreshed B) Users cannot view the data source C) Scheduled refreshes must be manually triggered or scheduled via Backgrounder D) The extract is converted to a live connection Answer: C Explanation: Disabling automatic refresh stops scheduled jobs; manual or custom scheduling is required.
Certification Exam Guide
Question 47. Which command lists all active services on a Tableau Server node? A) tsm services list B) tsm status services C) tsm topology list-services D) tsm processes list Answer: A Explanation: tsm services list displays the status of each Tableau Server service. Question 48. In a high‑availability deployment, what is the purpose of a “Witness” node? A) Store extracts for redundancy B) Host the Repository only, without serving client traffic C) Provide load balancing for the Gateway D) Run background jobs exclusively Answer: B Explanation: A Witness node holds a copy of the Repository to enable failover without handling user requests. Question 49. Which of the following is a recommended practice for optimizing extract refresh performance? A) Run all refreshes on a single Backgrounder process B) Schedule refreshes during peak user hours C) Incrementally refresh extracts instead of full refreshes when possible D) Disable indexing on the data source Answer: C Explanation: Incremental refreshes process only new or changed rows, reducing load and time.
Certification Exam Guide
Question 53. Which of the following actions requires “Project Leader” permission? A) Deleting a workbook inside the project B) Adding users to the site C) Publishing a new data source to the project D) Changing the site’s default language Answer: C Explanation: Project Leader can publish content to the project and manage its permissions. Question 54. When configuring SMTP, which setting determines the sender address displayed in emails sent by Tableau Server? A) smtp.host B) smtp.port C) smtp.sender D) smtp.username Answer: C Explanation: smtp.sender defines the “From” address used in outgoing messages. Question 55. Which Tableau Server feature allows you to publish a workbook that automatically refreshes on a schedule without user interaction? A) Subscriptions B) Extract Refresh Scheduling C) Data‑Driven Alerts D) Live Connections Answer: B
Certification Exam Guide
Explanation: Scheduling an extract refresh ensures the workbook’s data stays current automatically. Question 56. Which of the following is NOT a valid Tableau Server site role? A) Explorer (Can Publish) B) Creator C) Analyst D) Viewer Answer: C Explanation: “Analyst” is not a defined site role; the others are. Question 57. Which setting controls the maximum size of a single extract file on Tableau Server? A) extract.max_file_size B) backgrounder.max_extract_size C) dataengine.max_hyper_file_size D) There is no hard limit; it is limited by disk space Answer: D Explanation: Tableau Server does not impose a hard file‑size limit; extracts grow until disk space is exhausted. Question 58. What is the primary benefit of enabling “Mutual SSL” for Tableau Server? A) Users can log in without passwords B) Both client and server present certificates, providing two‑way authentication C) It speeds up data extracts D) It allows anonymous browsing of dashboards
