[May-2024 Newly Released] Desktop-Specialist Exam Questions For You To Pass

Tableau Desktop-Specialist Exam: Basic Questions With Answers

NEW QUESTION # 33
The calculation [Ship Date] - [Order Date] will return _______________

• A. Number of orders placed in that duration
• B. Number of days between these dates
• C. Number of orders shipped between these dates
• D. Number of unique orders placed between these dates

Answer: B

Explanation:
Explanation
As the names suggest, if we subtract the order date from the shipping date, we simply get the number of days between these 2 dates.
We can these use this calculated field in our charts, and can use COUNT, SUM, AVG etc with them according to our need.

NEW QUESTION # 34
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

• A. Blue, Red
• B. Orange, Blue
• C. Blue, Orange
• D. Red, Blue

Answer: C

Explanation:
Explanation
When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark.
See below:

NEW QUESTION # 35
Which of the following is a good reason for using a bullet graph?

• A. Displaying the year-on-year growth in sales
• B. Analysing the trend over a given time period
• C. Comparing the actual sales against the target sales
• D. Forecasting future sales

Answer: C

Explanation:
A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales.

NEW QUESTION # 36
Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser?

• A. NO, this is not currently possible in Tableau
• B. YES, we can do this with the help of a plugin
• C. YES, we can do this with the help of Tableau Public
• D. YES, we can do this with the help of a Web-Page object

Answer: D

Explanation:
To interactively display information from the web INSIDE a dashboard, you can use a URL action with a web page object.
For example, you might have a dashboard that shows profits by country. In addition to showing the profit data in your dashboard, you also want to display supplemental information about the countries from a web site.

NEW QUESTION # 37
Which of the following are valid options to define the scope of a reference line? Choose 3.

• A. Window
• B. cell
• C. Axis
• D. Pane
• E. Section
• F. Table

Answer: B,D,F

Explanation:
When we create a reference line, we get the following 3 options for the scope:
Graphical user interface, chart Description automatically generated

NEW QUESTION # 38
Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

• A. 25.79%
• B. 29.49%
• C. 23.39%
• D. 27.73%

Answer: D

Explanation:
We need to use the concept of Groups for this question. Follow along:
1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:

2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:

3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:

We can see the answer already : 23.386% in the view above (even before grouping!)
4) Finally, we get the following view and our answer:

NEW QUESTION # 39
________________ is hosted by Tableau to share our visualisations publically with the world.

• A. Tableau Reader
• B. Tableau Server
• C. Tableau Desktop
• D. Tableau Public

Answer: D

Explanation:
Tableau Public is a free service that lets anyone publish interactive data visualizations to the web.
Visualizations that have been published to Tableau Public ("vizzes") can be embedded into web pages and blogs, they can be shared via social media or email, and they can be made available for download to other users.
Check it out : https://public.tableau.com/en-us/s/

NEW QUESTION # 40
To connect Tableau to a CSV data source what type of connection should you use?

• A. JSON
• B. Spatial
• C. Excel
• D. Text

Answer: D

Explanation:
Explanation
Tableau recognises a CSV file as a TEXT file, and therefore it is the correct option.
The following are the steps to import a CSV file:
1) From the data connection screen, click on Text:

2) Choose the appropriate file, and click Open:

3) Finally, Tableau imports the data as shown below:

NEW QUESTION # 41
Which of these is NOT a type of Quick Filter available in Tableau?

• A. Multiple Values (dropdown)
• B. Wildcard Match
• C. Single Value (slider)
• D. Regex Match

Answer: D

Explanation:
Upon clicking on a filter, we see the following options:

Clearly, Regex Match is not one of these options!

NEW QUESTION # 42
Dates in Tableau are typically treated as ______________

• A. Measures
• B. Dimensions

Answer: B

Explanation:
Explanation
For relational data sources, dates and times are automatically placed in the Dimensions area of the Data pane and are identified by the date or date-time icon. For example, the Order Date and Ship Date dimensions from an Excel data source are shown below:

When you place a relational date on a shelf, the field name is automatically modified to reflect the default date level. Tableau defines the default date level to be the level at which there are multiple instances. For example, if the date field includes multiple years, the default level is year. However, if the date field contains data for just one year but includes multiple months, then the default level is month.

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

• A. False
• B. True

Answer: B

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 # 44
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?

• A. 25.683%
• B. 22.404%
• C. 28.415%
• D. 23.497%

Answer: B

Explanation:
Explanation
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 and 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:

NEW QUESTION # 45
Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

• A. If we want to dynamically enter parameters to the visualisation.
• B. If we want to use filters in the visualisation.
• C. If we want a static view of the visualisation.
• D. If we want to interact with the visualisation.

Answer: C

Explanation:
Exporting the visualisation gives us a static view of the visualisation.
It is NOT possible to interact with it, use filters, or dynamically enter anything in a visualisation exported PDF.
In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. You do not need to have Adobe Acrobat installed on your computer.
When you print an individual sheet to PDF, filters in the view are not included. To show filters, create a dashboard containing the sheet and export the dashboard to PDF. (IMPORTANT)

NEW QUESTION # 46
DOWNLOAD THE DATASET FROM:
https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ-574wld4InEplyKT8RP?usp=sharing (if you haven't already) Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?

• A. United Kingdom
• B. United States
• C. Canada
• D. France

Answer: D

Explanation:
Follow along to get the correct answer:
Drag Country to the view, and then Patents to the Size Mark on the Marks shelf as follows :
2) But, this isn't all right? We need to focus on the year 2013. This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:
2.1 As it is (continuous)

2.2 Converting to discrete first & then using it

and then :

3) We can now see that France, with 485 has the 2nd most number of patents for the year 2013

NEW QUESTION # 47
What statement correctly describes a requirement to create a reference line in Tableau?

• A. One of the axis must contain an aggregated measure.
• B. The reference line must be paired with a date field.
• C. The reference line must be created on a continuous axis.
• D. One of the axis must contain a dimension.

Answer: A

Explanation:
In Tableau, to create a reference line, one of the axes in the view must contain an aggregated measure.
Reference lines are typically used to add context or additional information to the data in a view, and they are often based on some form of aggregate such as the average, median, sum, etc., of a measure.

NEW QUESTION # 48
What is the default behavior of Tableau when you add a measure to the view?

• A. You are prompted to add an aggregation.
• B. An aggregation is applied that is independent of the context of the view.
• C. An aggregation is applied that varies depending on the context of the view.
• D. The measure is added disaggregated.

Answer: C

Explanation:
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.

NEW QUESTION # 49
For Bullet Graphs we need at least ____________ measures

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

Answer: A

Explanation:
Explanation
A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures.
Therefore, we need at least 2 measures for creating bullet graphs.

NEW QUESTION # 50
Which action describes the process for changing a measure so that it automatically aggregates an average instead of a sum?

• A. Right-click the field in the Data pane and select Change Data Type to change it.
• B. Add the field to the view, right-click the axis, and select Format to change it.
• C. Right-click the field in the Data pane and select Default Properties to change it.
• D. Right-click and drag the field into the view to change it.

Answer: C

Explanation:
To change a measure so that it automatically aggregates as an average instead of a sum, you should right-click the field in the Data pane and select Default Properties. In the Default Properties menu, you can set the default aggregation for the measure, such as setting it to calculate an average by default when added to a view.

NEW QUESTION # 51
_________________ 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. Data segregation
• B. Data Blending
• C. Data Joining
• D. Union

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 # 52
_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

• A. Tableau Packaged Workbook (.twbx)
• B. Tableau Data Source (.tds)
• C. Tableau Data Extract (.tde)
• D. Tableau Workbook (.twb)

Answer: C

Explanation:
Explanation
Tableau Data Extract (TDE) is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Performance is optimised because it queries its own database engine instead of the local data source.
When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data. When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.
Extracts are advantageous for several reasons:
1) Supports large data sets: You can create extracts that contain billions of rows of data.
2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data.
3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.
4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct.
5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.

NEW QUESTION # 53
Which of the following is true about 'Incremental refresh' when creating Extracts in Tableau?

• A. It replaces all of the contents in the extract
• B. They can only be used with large datasets
• C. It only adds rows that are new since the previous refresh.
• D. There is no difference, both are the same when using extracts. They are different when using live connections.

Answer: C

Explanation:
Extracts are saved subsets of data that you can use to improve performance or to take advantage of Tableau functionality not available or supported in your original data. When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data.
When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.

NEW QUESTION # 54
What allows you to drill up or down in the level of detail (LOD)?

• A. Hierarchies
• B. Groups
• C. Bins
• D. Sets

Answer: A

Explanation:
Hierarchies in Tableau allow users to drill up and down to explore data at different levels of detail. By setting up a hierarchy, users can navigate through levels of the hierarchy to analyze data at each level, from the highest summary down to the finest detail.

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

• A. No
• B. Yes

Answer: B

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 # 56
For a relative date filter, the default anchor is _________________

• A. The date we specify
• B. Today's date
• C. The current time
• D. The target date

Answer: B

Explanation:
Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most recent data.
Step 1: Drag a date field to the filter shelf
Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.

Step 2: Select a time unit
In the Filter dialog box, click Relative dates, and then select the unit of time for the filter. For example, to show only the three most recent weeks, select Weeks.

Here, you can clearly see that the default date is TODAY

NEW QUESTION # 57
......

New 2024 Realistic Free Tableau Desktop-Specialist Exam Dump Questions and Answer: https://pass4sure.dumptorrent.com/Desktop-Specialist-braindumps-torrent.html