You view the relationship canvas shown in the following exhibit.
What does Migrated Data indicate?
Correct Answer:A
In the context of Tableau, "Migrated Data" typically refers to data or workbooks that have been upgraded from a previous version of Tableau Desktop. When you open a workbook in a newer version of Tableau, the data sources within that workbook might be labeled as "Migrated Data," indicating that they have undergone a conversion process to be compatible with the new version's features and architecture.
Question 45: Skipped
You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?
Correct Answer:D
A parameter is a global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line.
For example, you may create a calculated field that returns True if Sales is greater than
$500,000 and otherwise returns False. You can replace the constant value of “500000” in the formula with a parameter. Then, using the parameter control, you can dynamically change the threshold in your calculation.
For example -
Reference: https://help.tableau.com/current/pro/desktop/en-us/parameters_create.htm
In an extract, what are three differences between a full refresh versus an incremental refresh? Choose three.
Correct Answer:ADE
According to the [Tableau Desktop Specialist Exam Guide], an incremental refresh only adds rows that are new, based on a specified column and value. A full refresh replaces all the extracted data with the data in the underlying data source. A full refresh is usually very slow, especially for large extracts. An incremental refresh can take less time, depending on how many new rows are added. A full refresh does not need to be configured, it is the default option for extracts in Tableau. An incremental refresh can be run from both Tableau Desktop and Tableau Server.
Which aggregation is available without requiring a table calculation or calculated field?
Correct Answer:B
Standard deviation is an aggregation that is available without requiring a table calculation or calculated field. Standard deviation is a statistical measure that shows how much variation there is from the average value in a set of data. Standard deviation is one of the predefined aggregations in Tableau that can be applied to any measure by selecting it from the context menu of the measure or from the drop-down menu on the Marks card6 The other options are not aggregations that are available without requiring a table calculation or calculated field. Running total, sample covariance, and percent of total are all examples of table calculations, which are computations that are applied to the values in an entire table or partition of a table. Table calculations can be created by selecting them from the context menu of a measure or by using functions in a calculated field7
Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?
Correct Answer:D
Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We'll be using filters, as well as quick table calculations (percent of total) for this one.
1) Firstly, let's drag Country andInstitution to the Rows shelf, and year (discrete) to the Columns shelf. Then, drag Publications to the Text Icon in the Marks Shelf. The following is our view: