/
Tableau Fundamentals and Data Engineering
Save to my account
Sign up
Tableau Fundamentals and Data Engineering
Tableau Fundamentals and Data Engineering
Study
1
Question
What are the three primary indicators used to define whether a dataset qualifies as Big Data?
11:02
Answer
Big Data is characterized by Volume (the massive size of generated data), Velocity (the high speed at which data streams are produced and processed), and Variety (the inclusion of structured, semi-structured, and unstructured data).
2
Question
How does the human brain's processing of visual information compare to its processing of text?
19:37
Answer
The human brain processes visual information approximately 60,000 times faster than it processes text. Additionally, individuals retain 80% of what they see and interact with, compared to only 20% of what they read.
3
Question
What is the primary technical limitation of Microsoft Excel regarding dataset capacity compared to Tableau?
25:55
Answer
Microsoft Excel is generally limited to handling approximately 1 million records, whereas Tableau is specifically designed for Big Data use cases and can manage massive volumes through high-performance in-memory data engines.
4
Question
How does Row Level Security (RLS) enforce the 'need to know' principle within an organization?
27:34
Answer
Row Level Security restricts data access by ensuring users only see the specific rows relevant to their job function. This allows a single dashboard to display different content based on whether the user is in Sales, HR, or Finance.
5
Question
What is the core distinction between an Extract connection and a Live connection in Tableau?
72:50
Answer
A Live connection sends real-time queries directly to the external database for maximum data freshness, while an Extract connection creates a snapshot or subset of data stored in-memory for optimized performance.
6
Question
What are the management responsibilities in the Infrastructure as a Service (IaaS) model compared to the Software as a Service (SaaS) model?
56:26
Answer
In IaaS, the cloud provider manages hardware while the organization manages software and projects. In SaaS, the provider manages both hardware and software, and the organization only manages its specific business projects.
7
Question
Which specific formats does Tableau use to store metadata and actual data respectively?
78:19
Answer
Tableau stores metadata (information about the data model and columns) in XML files. The actual underlying data is stored in the proprietary Hyper format, which uses a column-store method for fast retrieval.
8
Question
What distinguishes the Tableau Desktop product from Tableau Public Desktop?
45:41
Answer
Tableau Desktop requires a license, connects to over 90 sources, and allows private publishing. Tableau Public is free but limits connections to local files, handles only 15 million rows, and requires publishing to a public server.
9
Question
What is the primary function of the VizQL Server component within the Tableau Server architecture?
89:59
Answer
The VizQL Server serves as the brain of Tableau; it translates user interactions into queries and renders the visual graphical elements of the dashboards for the user.
10
Question
What is the role of the Gateway component in the Tableau Server infrastructure?
86:38
Answer
The Gateway is responsible for receiving incoming requests from clients and forwarding them to the appropriate server components, such as the Application Server or VizQL Server, for processing.
11
Question
How does the 'Data is the new oil' metaphor apply to raw data processing?
12:59
Answer
Raw data is often unprocessed, unorganized, and holds little inherent value. Similar to oil, it must be extracted and refined through data engineering and analysis to become a valuable asset for decision-making.
12
Question
What information is specifically stored in a Tableau Data Source (.tds) file?
75:44
Answer
A .tds file contains the metadata and connection information necessary to access a data source, including renaming, aggregations, and data models, but it does not contain the actual data itself.
13
Question
What are the two primary responsibilities of the Gateway in a Tableau Server environment?
95:23
Answer
The Gateway acts as a distributor that routes client requests to the correct server components and performs load balancing in a multi-node environment.
14
Question
Which specific component is responsible for the authentication and authorization processes in Tableau Server?
96:15
Answer
The Application Server handles user login requests and verifies permissions by checking against the Repository or an external Active Directory.
15
Question
How does the Application Server process a workbook during the publishing stage?
96:15
Answer
It splits the workbook into two distinct files: an XML file for the metadata stored in the Repository and a Hyper file for the data stored in the File Store.
16
Question
What core functionality does the VQL Server provide within the Tableau architecture?
97:04
Answer
The VQL Server acts as the 'brain' that converts user drag-and-drop actions into database queries and transforms raw data back into images and visuals.
17
Question
In what way does the Data Server function as a proxy for external data sources?
98:55
Answer
It uses data connectors to establish connections and translates Tableau requests into the specific query language that the external database understands.
18
Question
How does the Data Server implement data security during a user request?
92:41
Answer
The Data Server checks user permissions and applies filters to the raw data based on the established data security setup before returning results.
19
Question
What are the primary operations performed by the Tableau Data Engine?
99:46
Answer
The Data Engine creates new extracts, executes update operations via the Backgrounder, and queries data specifically stored inside Tableau extracts.
20
Question
What specific types of data are stored within the Tableau Repository?
100:40
Answer
The Repository stores workbook metadata (XML files), usage data for performance tracking, and security information such as user access permissions.
21
Question
What is the function of the Backgrounder component in Tableau Server?
101:32
Answer
The Backgrounder checks schedules every 10 seconds to trigger the process of refreshing data inside published extracts.
22
Question
What distinguishes the Cache Server's role from other storage components?
101:32
Answer
The Cache Server stores temporary results like images, icons, and query results to pull data quickly for dashboards that were previously accessed.
23
Question
Which connection types are permitted in Tableau Public Desktop?
105:12
Answer
Tableau Public Desktop only allows 'Extract' connections, meaning data must be copied into the software rather than being a 'Live' connection.
24
Question
What are three major limitations of using a Tableau Public account?
107:35
Answer
Accounts are limited to 10 GB of storage, data cannot be refreshed automatically, and all published workbooks must be made public to the world.
25
Question
In the Tableau interface, what is the 'Start Page' primarily used for?
120:38
Answer
The Start Page is the initial interface used to connect to data sources, open recently used workbooks, and access Tableau community resources.
26
Question
How can a user navigate back to the Data Source page from a Worksheet in Tableau Desktop?
121:28
Answer
A user can either click the 'Data Source' tab at the bottom left or double-click the data source name in the Data pane on the left side.
27
Question
What information is provided by the status bar at the bottom of the Tableau interface?
129:09
Answer
The status bar displays technical details such as the number of marks (bars/points), rows, columns, and the total value of the measure in the view.
28
Question
What does a grayed-out icon in the Tableau toolbar indicate?
124:03
Answer
A grayed-out icon signifies that the function is not currently relevant to the active visualization, not that it is unavailable in that version of Tableau.
29
Question
How does a Tableau Dashboard differ from a Worksheet?
131:08
Answer
A Worksheet is for building a single visualization, while a Dashboard allows the developer to combine multiple sheets into one unified interactive view.
30
Question
What is the primary purpose of creating a 'Story' in Tableau?
132:03
Answer
A Story is a sequence of visualizations or dashboards used for presentations to walk stakeholders through data step-by-step or tell a narrative.