Free Practice Questions for Salesforce Analytics-DA-201 Exam

To schedule a refresh of the data, you need to ensure that Tableau Server or Tableau Online can access the database without prompting for credentials. This can be done by embedding the credentials in the workbook or the published data source. You also need to extract the data from the database and publish it as a separate data source or as part of the workbook. A live connection would not allow you to refresh the data on a sched ule, as it would always query the database directly. A hyper file is a format for storing extracted data, but it is not a requirement for scheduling a refresh. References:

Tableau Certified Data Analyst Exam Prep Guide , page 10, section “Publishing and Scheduling Data Refreshes”

Tableau Help: Embedding Database Credentials

Tableau Help: Extract Your Data

The LOOKUP function is used to return the value of a specified field in a different row, which can be defined relative to the current row. In this context, it can be used to in clude a number with the position of each state within each region by looking up the SUM([Quantity]) in each respective position.  References:  The information is inferred from general Tableau knowledge as well as the following sources:

Tableau Functions (Alphabetical)

LOOKUP

Tableau Certified Data Analyst Exam Guide

The hierarchy contains Market, Market Size, and State, but the stakeholder wants the total at whichever higher hierarchy level remains in the view. An EXCLUDE LOD expression is designed for exactly this type of dynamic view-dependent aggregation because it removes a specified dimension from the current visualization level of detail while retaining the other dimensions that are present. Using {EXCLUDE [State] : SUM([Sales] )} removes State from the calculation. If Market and Market Size are visible, the result is calculated at that combination; if the hierarchy is collapsed so only Market remains, the calculation adapts to Market. A FIXED expression would establish a fixed granularity independent of the view and would not adapt in the same way. Therefore, option A provides the required hierarchy-sensitive total.

An INCLUDE LOD expression is specifically useful when a calculation must incorporate a finer-grained dimension that is not already present in the visualization. INCLUDE adds the specified dimension to the level of detail established by the dimensions currently in the view, calculates the expression at that finer grain, and then allows Tableau to reaggregate the result at the view’s level. For example, { INCLUDE [Customer Name] : SUM([Sales] ) } can calculate sales per customer even when Customer Name itself is absent from the displayed view. If the dimension is already present in the view, INCLUDE generally adds no additional granularity for that field. The dimension does not specifically need to reside on the Marks card, Rows/Columns shelves, or Filters shelf. Therefore, Not in the View is the correct answer.

To minimize the whitespace between the sheets, you should configure the padding of the sheets and the dashboard. Padding is the amount of space between the edge of a sheet or dashboard and its content. You can adjust the padding by using the Layout tab in the Format pane. You can reduce the padding for each sheet by selecting the sheet and changing the values for the inner and outer padding. You can also reduce the padding for the dashboard by selecting the dashboard and changing the values for the outer padding. Reducing the padding will make the sheets and the dashboard more compact and eliminate unnecessary whitespace. References:

Format Dashboards - Tableau

Tableau Certified Data Analyst Study Guide

The target visualization shows a subtotal after the members of each Category while retaining the individual Sub-Category rows. In Tableau, Analysis > Totals > Add All Subtotals inserts subtotal rows or columns when multiple dimensions are present on Rows or Columns. Here, Category and Sub-Category are both on Rows, so Tableau can calculate a subtotal for each Category group. Show Column Grand Totals and Show Row Grand Totals create totals for the entire view along the corresponding direction; they do not insert a separate total inside every Category section. Column Totals to Top only changes the placement of existing column totals. Because the requirement is to add a Total row for Furniture, Office Supplies, and Technology individually, Add All Subtotals is the correct command.

A .hyper file is an extract file that contains a snapshot of data from a data source. It is a compressed and optimized file format that can be used to improve the performance and portability of dashboards and workbooks. A .twb file is a workbook file that contains the visualization and connection information, but not the data itself. A .csv file is a comma-separated values file that contains plain text data. A .mdb file is a Microsoft Access database file that contains tables, queries, forms, and other objects. References: https://help.tableau.com/current/pro/desktop/en-us/save_savework_packagedworkbooks.htm https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm https://help.tableau.com/current/pro/desktop/en-us/examples_csv.htm https://support.microsoft.com/en-us/office/introduction-to-access-database-files-9f9a0f8c-9a3c-4a0b-8e6c-6d1f1f7c2b7e

In Tableau, a .hyper file is an extract file created by the Hyper database engine. It contains a snapshot of the data pulled into Tableau and is used to perform data analysis without the need for a live connection to the data source.