Desktop-Specialist Pre-Exam Practice Tests | (Updated 150 Questions)

Valid Desktop-Specialist Exam Q&A PDF - One Year Free Update

NEW QUESTION # 49
_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

• A. Tableau Server
• B. Tableau Public
• C. Tableau myServer
• D. Tableau Prep

Answer: C

Explanation:
Explanation
Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.

NEW QUESTION # 50
True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity

• A. True
• B. False

Answer: A

Explanation:
Explanation
Whenever you add a measure to your view, an aggregation is applied to that measure by default. This default is controlled by the Aggregate Measures setting in the Analysis menu.
If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can disaggregate the view. Disaggregating your data means that Tableau will display a separate mark for every data value in every row of your data source.
To disaggregate all measures in the view:
Clear the Analysis >Aggregate Measures option. If it is already selected, click Aggregate Measures once to deselect it.

NEW QUESTION # 51
How does Tableau know at which level to aggregate values?

• A. Values are always aggregated at the level of granularity of the worksheet.
• B. Tableau doesn't aggregate values, we do!
• C. Aggregation is always done by using Tableau special formulas
• D. Values are always aggregated at the level of the Date Part

Answer: A

Explanation:
Explanation
In Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures.
Whenever you add a measure to your view, an aggregation is applied to that measure by default. The type of aggregation applied varies depending on the context of the view.
When you add a measure to the view, Tableau automatically aggregates its values. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau.
The current aggregation appears as part of the measure's name in the view. For example, Sales becomes SUM(Sales). Every measure has a default aggregation which is set by Tableau when you connect to a data source. You can view or change the default aggregation for a measure-see Set the Default Aggregation for a Measure.
You can change the aggregation for a measure in the view from its context menu:

NEW QUESTION # 52
What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

• A. The calculated fields created in Blends cannot be edited once created
• B. The calculated fields created in Blends cannot use more than 2 fields
• C. Fields used in Blends must first be aggregated
• D. No difference, calculated fields cannot be created in Blends

Answer: C

Explanation:
Explanation
Yes, due to the nature of blends, there are some conditions as follows from the official documentation that must be kept in mind while working with blends:


In addition to handling calculations slightly differently, there are some limitations on secondary data sources.
You may not be able to sort by a field from a secondary data source, and action filters may not work as expected with blended data. For more information, see Other data blending issues.

NEW QUESTION # 53
DOWNLOAD THE DATASET FROM -
https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv-SgzaBq/view?usp=sharing ( if you haven't already from the test instructions page! ) How many different countries are present in the dataset?

• A. 0
• B. 1
• C. 2
• D. 3

Answer: B

Explanation:
Explanation
To reach the correct answer, follow these steps:
1) You can simply drag Country to the view, and look at the marks in the bottom left of Tableau Desktop - 147 marks!

2) Or, you can simply go to Data Source -> Country Tab -> Describe


As you can see, 147 members exist in this Country column!

NEW QUESTION # 54
For creating variable sized bins we use __________________

• A. Sets
• B. Calculated Fields
• C. Table Calculations
• D. Groups

Answer: B

Explanation:
Explanation
One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0-5, 6-10, 11-15, and so on. Then you can count the number of people in each age group.
Create a calculated field for variable bin size
Step 1
Select Analysis > Create Calculated Field.
Step 2
In the Calculated Field dialog box, complete the following steps:

NEW QUESTION # 55
Which of the following are valid ways of Grouping Data?

• A. Using Labels in the View
• B. From the Analytics Pane
• C. Using Marks in the view
• D. From the Dimensions Shelf

Answer: A,C,D

Explanation:
Explanation
**IMPORTANT QUESTION AND EXPLANATION, PLEASE READ**
3 ways to group data -
1) Marks
2) Labels
3) Dimensions shelf.
*IMPORTANT*
If we Group the data by selecting the marks, then they remain separate marks in the view and then have the same colour. Also, a new group is created in the Dimensions shelf. Example - Using the sample superstore dataset, first plot a bar chart showing sales for each sub-category:

Here, if we Select Phones, Chairs and Storage by selecting the MARKS (Bars), and then group them:

They remain seperate marks (BARS) but are grouped by the same colour.
Now, if we didn't do this, and rather grouped by selecting their Labels (Names):

Then they no longer remain separate Marks (bars) but are rather consolidated into a single Bar:

Finally, we can group directly from the Dimensions shelf as follows:

Now choose Phones, Chairs and Storage and Click Group:

You will now automatically have a new Dimension as follows:

NEW QUESTION # 56
True or False: Context Filters are executed after Data Source filters

• A. True
• B. False

Answer: A

Explanation:
Explanation
THIS IS A VERY IMPORTANT QUESTION
To answer this question, you need to understand Tableau's Order of Operations. See below and remember this always:

NEW QUESTION # 57
When is an axis created for the visualisation in Tableau?

• A. When we drag a discrete field to the row/column shelf
• B. When we drag a measure to the row/column shelf
• C. When we drag a continuous field to the row/column shelf
• D. When we drag a dimension to the row/column shelf

Answer: C

Explanation:
Explanation
An Individual Axis in Tableau is obtained by adding a continuous into Rows or Columns Shelf.
Example:
In order to show Individual Axis in Tableau First, we drag and drop the Color from Dimension shelf to Column Shelf. Next, we drag and drop the Sales Amount from measures shelf to Rows Shelf. Since it is a continuous value, the Sales Amount will be aggregated to default Sum. Once you drag them, following Chart report will be generated.

Next, we drag and Drop one more measure value, i.e., Total Product Cost from Measures Region to Rows Shelf. Because it is a Measure value, Total Product Cost is aggregated to default Sum. From the below screenshot, you can observe that Tableau has created an individual axis for each measure (continuous field).

NEW QUESTION # 58
How can you add color to marks in the view in Tableau?

• A. Click on Data in the main menu above, and click on choose color.
• B. From the Analytics pane, drag a model to Color on the Marks card.
• C. In the column/row shelf, right click the field and click on edit in shelf to select the color.
• D. From the Data pane, drag a field to Color on the Marks card.

Answer: D

Explanation:
Explanation
To assign a color to marks in the view, do the following:
From the Data pane, drag a field to Color on the Marks card.
Tableau applies different colors to marks based on the field's values and members. For example, if you drop a discrete field (a blue field), such as Category, on Color, the marks in the view are broken out by category, and each category is assigned a color.

If you drop a continuous field, such as SUM(sales), on Color, each mark in the view is colored based on its sales value.

NEW QUESTION # 59
_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins

• A. Union
• B. Data Blending
• C. Data segregation
• D. Data Joining

Answer: B

Explanation:
Explanation
Data blending is performed on a sheet-by-sheet basis and is established when a field from a second data source is used in the view. To create a blend in a workbook already connected to at least two data sources, bring a field from one data source to the sheet-it becomes the primary data source.
Switch to the other data source and use a field on the same sheet-it becomes a secondary data source. An orange linking icon will appear in the data pane, indicating which field(s) are being used to blend the data sources.

According to the official Tableau Documentation:

To read more about Data Blending, click on THIS link.

NEW QUESTION # 60
By default, measures placed in a view are aggregated by ______________

• A. MEDIAN
• B. AVERAGE
• C. COUNT
• D. SUM

Answer: D

Explanation:
Explanation
By default, measures placed in a view are aggregated by SUM, which means that the data for that field in all of the rows is combined. Measures can also be aggregated as average, median, count, or count distinct.

NEW QUESTION # 61
Which of the following would you use to edit the Shape, colour, and Text of your visualisations?

• A. Analytics Pane
• B. Marks Card
• C. Filter Shelf
• D. Data Pane

Answer: B

Explanation:
Explanation
The Marks Card allows us not only to edit the Shape, Text and Colour, but also to modify the Tooltip and the level of detail of the visualisation!

The Marks card is a key element for visual analysis in Tableau. As you drag fields to different properties in the Marks card, you add context and detail to the marks in the view.

You use the Marks card to set the mark type (see Change the Type of Mark in the View), and to encode your data with color, size, shape, text, and detail. To change the mark settings, see Control the Appearance of Marks in the View.

In this example, three different fields have been dragged to different properties in the Marks card. Segment is on Color, Region is on Shape, and Quantity is on Size.
After you add a field to the Marks card, you can click the icon next to the field to change the property it is using. You can also click the property buttons in the Marks card to change those settings.
Many properties can have multiple fields. For example, you can add multiple fields to Label, Detail, Tooltip, and Color. Size and Shape can only have one field at a time. For more details, see Control the Appearance of Marks in the View.

NEW QUESTION # 62
Which of the following would you use to connect to multiple tables in a single data source at once?

• A. A Hierarchy
• B. A Blend
• C. A Join
• D. A Set

Answer: C

Explanation:
Explanation
The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data.
For example, consider the following two tables originating from a single data source:

We can combine these 2 tables, simply by joining the tables on ID to answer questions like, "How much was paid in royalties for authors from a given publisher?". By combining tables using a join, you can view and use related data from different tables in your analysis.

NEW QUESTION # 63
Which of the following are valid ways to add Totals to a view?

• A. Using the Data Pane
• B. From the Analysis Tab in the Menu bar on top
• C. Using the Marks shelf
• D. Using the Analytics Pane

Answer: B,D

Explanation:
Explanation
To add totals to a view using the Analytics pane:

Also, you can add totals from the Analytics tab in the Menu above:

NEW QUESTION # 64
True or False: It is possible to add a field to more than one hierarchy

• A. True
• B. False

Answer: A

Explanation:
Explanation
Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.

NEW QUESTION # 65
True or False: A reference line cannot be added from the Analytics Pane

• A. False
• B. True

Answer: A

Explanation:
Explanation
You can add a reference line to any continuous axis in the view.
To add a reference line:
Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item and the current view.
In a simple case, the drop target area offers three options:

NEW QUESTION # 66
You can _______________ your data to combine two or more tables by appending values (rows) from one table to another

• A. join
• B. blend
• C. concatenate
• D. union

Answer: D

Explanation:
Explanation
You can union your data to combine two or more tables by appending values (rows) from one table to another.
To union your data in Tableau data source, the tables must come from the same connection.
For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016," "June2016," and "July2016."

A union of these tables creates the following single table that contains all rows from all tables.

NEW QUESTION # 67
Which of the following is a valid way to create Sets in Tableau?

• A. In the Data pane, right-click a dimension and select Create > Set.
• B. In the Data pane, right-click a measure and select Create > Set.
• C. In the Tableau Main Menu, Choose Worksheet and select Create > Set
• D. In the Tableau Main Menu, choose Dashboard and select Create > Set

Answer: A

Explanation:
Explanation
There are two types of sets: dynamic sets and fixed sets. The members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.
To create a dynamic set:
1) In the Data pane, right-click a dimension and select Create > Set.
2) In the Create Set dialog box, configure your set. You can configure your set using the following tabs:
General: Use the General tab to select one or more values that will be considered when computing the set.
You can alternatively select the Use all option to always consider all members even when new members are added or removed.

None of the other options exist, and therefore are incorrect answers.

NEW QUESTION # 68
Larger image

What is this entire view referred to as in Tableau?

• A. Analytics Pane
• B. Summary Pane
• C. Distribution Pane
• D. Data pane

Answer: A

Explanation:
Explanation
Distribution Pane
Explanation
This is the Analytics pane! Read more from the official documentation below:

NEW QUESTION # 69
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?

• A. Yes
• B. No

Answer: A

Explanation:
Explanation
Yes, it is very much possible to use measures in the same view multiple times. For example, refer to the image below:

We are using BOTH the Sum of the revenue and the of the revenue in the same view!

NEW QUESTION # 70
What is the following icon in the Data pane used to do?
Larger image

• A. Clean Data
• B. Extract Data
• C. View Data
• D. Sort Data

Answer: C

Explanation:
Explanation
View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view.
The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.
From the official website:

NEW QUESTION # 71
When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.

• A. Remote Field Name, Field Name
• B. Column Name, Actual Name
• C. Local Name, Actual Name
• D. Local Field, Global Field

Answer: A

Explanation:
Explanation
Using the Sample superstore as a reference, click on the manage metadata icon as follows:

We can rename a particular column name to make it easier to remember and use in Tableau. Let's change Order ID to oID as shown:

Now, we'll see oID when using this data source in Tableau. This WILL NOT affect the original data source.
The remote field name let's us see what the name of the column is in the ORIGINAL Data source.

NEW QUESTION # 72
......

Tableau Desktop Specialist Exam Free Update Certification Sample Questions: https://pass4sure.examstorrent.com/Desktop-Specialist-exam-dumps-torrent.html