Tableau TDS-C01 Practice Test - Questions Answers, Page 28

To update the font of an entire workbook in Tableau, you should use the 'Format Workbook' pane. This feature allows you to set and modify the default font settings for the entire workbook, ensuring consistency in font style across all sheets and dashboards. It's a global setting that applies to all visual elements in the workbook, including titles, captions, axis labels, and other text elements.

In Tableau, the two elements that can have their values changed by using a dashboard action are Sets and Parameters. Dashboard actions can be configured to modify the values within a set or a parameter, allowing for interactive and dynamic changes in the visualization based on user interactions. For example, selecting a specific data point in a dashboard can trigger an action that updates a set or changes the value of a parameter, which in turn can alter the displayed data or the appearance of visualizations within the dashboard.

To show how Internet Usage values change from year to year as a percentage, you should apply the 'Percent Difference' quick table calculation to the Internet Usage field. This calculation compares each value to the previous value and computes the difference as a percentage, which is ideal for analyzing the rate of change over a sequential time period such as consecutive years.

Dragging a continuous date value to the Rows shelf in Tableau results in a green pill on the Rows shelf, indicating a continuous field. It also results in a quantitative axis being displayed on the visualization. Continuous fields are used to create axes on charts and can represent a range of values smoothly. This is opposed to discrete date values, which would be represented by a blue pill and typically show headers or labels rather than a continuous axis.

To display the complete list of potential data connections when connecting to a server in Tableau, you should select 'More' under the 'To a Server' option. This action will provide a comprehensive list of server types and data sources that Tableau can connect to.

The calculated field formula LEFT('Sales Data', 5) will correctly produce the output 'Sales' from the string value 'Sales Data'. The LEFT function in Tableau returns the specified number of characters from the start of the string. Here, the first 5 characters of 'Sales Data' are 'Sales'.

The two types of aggregations that can be applied to string fields in Tableau are Count Distinct and Minimum. Count Distinct counts the unique values of a field, and Minimum finds the smallest value in a field based on the alphanumeric order. String fields do not support numeric aggregations like Sum or Average.

The default behavior of Tableau when you add a measure to the view is to automatically apply an aggregation to that measure. The type of aggregation applied can vary depending on the context of the view. For example, if no other measures or dimensions affect the measure, Tableau might default to SUM. However, if there are other dimensions in the view that define the level of detail, the aggregation might be different to reflect the context.

The benefits of using a live connection over an extract include:

B: A live connection ensures that the data in the workbook is as up-to-date as the database itself, providing fresher data compared to a static extract which is updated at intervals.

C: A live connection queries the database server directly, which means it uses the server's memory and processing power rather than relying on the client computer's resources.

A live connection does not necessarily require less network overhead (A) as it may continually send queries over the network, and it is not always faster than an extract (D) because extracts can provide quicker response times for complex queries or large datasets.