New PracticeDump Desktop-Specialist Exam Questions| Real Desktop-Specialist Dumps Updated on May 16, 2024
Desktop-Specialist Braindumps – Desktop-Specialist Questions to Get Better Grades
NEW QUESTION # 114
You have a dashboard that shows car rental statistics by city, including a field named Car Dropoff City in the view. A URL action in the dashboard uses https://en.wikipedia.org/wiki/<Car Dropoff City> as the URL target.
When you click Salt Lake City in the view, to where will the URL action direct you?
- A. https://en.wikipedia.org/wiki/Salt.LakeXity
- B. https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City
- C. https://en.wikipedia.org/wiki/<Salt-Lake-City>
- D. https://en.wikipedia.org/wiki/<Car Dropoff City>
Answer: B
Explanation:
When you click Salt Lake City in the view, the URL action will direct you to
https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City. A URL action is a hyperlink that points to a web page or other web-based resource outside of Tableau. You can use URL actions to create an email or link to additional information about your data. To customize links based on your data, you can automatically enter field values as parameters in URLs3 In this case, the URL action uses https://en.wikipedia.org/wiki/<Car Dropoff City> as the URL target, where <Car Dropoff City> is a field value from the view. When you click Salt Lake City in the view, Tableau will replace <Car Dropoff City> with Salt Lake City in the URL target.
However, since spaces are not allowed in URLs, Tableau will encode them as + signs instead. Therefore, the final URL will be https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City3 The other options are not correct because they do not reflect how Tableau encodes field values in URL actions.
NEW QUESTION # 115
Which of the following are true about dimensions?
- A. They contain qualitative values (such as names, dates, or
geographical data) - B. They contain contain numeric, quantitative values
- C. Dates are mostly placed in dimensions by default for relational data sources
- D. They affect the level of detail in the view
Answer: A,C,D
Explanation:
Measures contain numeric quantitative values hence that option is incorrect.
Reference 1: https://help.tableau.com/current/pro/desktop/en-us/datafields_typesandroles.htm Reference 2: https://help.tableau.com/current/pro/desktop/en-us/dates.htm
NEW QUESTION # 116
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. Canada
- B. France
- C. United Kingdom
- D. United States
Answer: B
Explanation:
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 # 117
Larger image
What is this entire view referred to as in Tableau?
- A. Analytics Pane
- B. Summary Pane
- C. Data pane
- D. Distribution Pane
Answer: A
Explanation:
Distribution Pane
Explanation:
This is the Analytics pane! Read more from the official documentation below:
NEW QUESTION # 118
How does Tableau know at which level to aggregate values?
- A. Values are always aggregated at the level of granularity of the worksheet.
- B. Values are always aggregated at the level of the Date Part
- C. Aggregation is always done by using Tableau special formulas
- D. Tableau doesn't aggregate values, we do!
Answer: A
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 # 119
Which of the following are interactive elements that can be added to a dashboard for users?
- A. URL Action
- B. Edit Tooltip Action
- C. Highlight Action
- D. Filter Action
Answer: A,C,D
Explanation:
We can perform filter, URL and highlight actions out of the above given choices on a dashboard. Please refer to the image below:
Graphical user interface Description automatically generated
NEW QUESTION # 120
_________________ 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 Blending
- B. Data segregation
- C. Data Joining
- D. Union
Answer: A
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 # 121
If you are working with a huge dataset, which of the following are strong reasons to use a context filter?
- A. To help clean the data
- B. To include only the data of interest
- C. Improve query performance
- D. To make the context filter a dependent filter
Answer: B,C
Explanation:
By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter (Option stating - To create a dependent filter eliminated here). Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.
You may create a context filter to:
1) Improve performance - If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.
2) Create a dependent numerical or top N filter - You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.
For example, suppose you're in charge of breakfast products for a large grocery chain. Your task is to find the top 10 breakfast products by profitability for all stores. If the data source is very large, you can set a context filter to include only breakfast products. Then you can create a top 10 filter by profit as a dependent filter, which would process only the data that passes through the context filter.
Graphical user interface, application Description automatically generated
NEW QUESTION # 122
Which of the following are benefits of using Data Extracts in Tableau?
- A. Ability to use the data offline
- B. Working with freshest data at all times
- C. Improved Performance
- D. Faster to work with
Answer: A,C,D
Explanation:
Explanation
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.
To work with the MOST up-do-date data, use a live connection instead!
NEW QUESTION # 123
You want to save a view as an image that you can paste into a Microsoft Word document. Which two statements accurately describe exporting a view as an image? Choose two.
- A. Default exports include everything in the view, including Tableau fonts.
- B. The default export format is PNG.
- C. The exported image is a vector-based file that embeds the Tableau fonts.
- D. The default export format is TIFF.
Answer: A,C
Explanation:
When exporting a view as an image in Tableau, the default export includes everything that is currently displayed in the view, with Tableau applying its own styling, including fonts. The default format for an exported image is PNG, which is a raster-based file format that captures all visual elements as pixels. PNG is widely used for its lossless compression and is suitable for detailed images like those produced by Tableau.
Unlike vector-based images, PNGs do not embed fonts, and the image quality remains consistent when the image is viewed on different platforms, which makes it ideal for inserting into documents like Microsoft Word.
NEW QUESTION # 124
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 # 125
Relationships are represented by __________________ and operate at the ____________________.
- A. noodles, logical layer
- B. Venn diagrams, physical layer
- C. Venn diagrams, logical layer
- D. noodles, physical layer
Answer: A
Explanation:
From the official documentation:
The default view that you first see in the Data Source page canvas is the logical layer of the data source. You combine data in the logical layer using relationships (or noodles).
NEW QUESTION # 126
Are animations enabled by default in Tableau?
- A. No
- B. Yes
Answer: A
Explanation:
No, by default, animations are not enabled in Tableau.
We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate.
Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.
When you author animations, you can choose between two different styles: simultaneous or sequential. Here are examples of each type.
1) Simultaneous animations
The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.
2) Sequential animations
Sequential animations take more time but make complex changes clearer by presenting them step-by-step.
To Animate visualizations in a workbook:
1) Choose Format > Animations.
2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:
For Duration, choose a preset, or specify a custom duration of up to 10 seconds.
For Style, choose Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.
3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.
NEW QUESTION # 127
What are two examples of a date value?
Choose two.
- A. Wednesday
- B. December
- C. January 1.1995
- D. 2020-05-01
Answer: C,D
Explanation:
Date values in Tableau represent specific points in time and are typically formatted in a standard date format.
Option A, "2020-05-01", is a standard date format representing the 1st of May, 2020.
Option D, "January 1, 1995", is another example of a date value, representing the 1st of January, 1995.
Options B ("December") and C ("Wednesday") represent a month and a day of the week, respectively, but do not specify a particular date.
NEW QUESTION # 128
A dual axis chart is useful for comparing two measures that___________.
- A. have little in common
- B. have different scales
- C. are Table Calculations
- D. are aggregated Dimensions
Answer: B
Explanation:
A dual axis chart is useful for comparing two measures that have different scales. A dual axis chart is a type of visualization that shows two measures using two independent axes layered on top of one another. A dual axis chart allows you to compare and contrast two measures that have different ranges or units of measurement, such as sales and profit margin, temperature and precipitation, or population and GDP per capita. A dual axis chart can also show different mark types for each measure, such as bars and lines, circles and areas, or shapes and texts. The other options are not valid reasons for using a dual axis chart for comparing two measures. Have little in common is not correct, because a dual axis chart is meant to show some kind of relationship or correlation between two measures, not just contrast them. Are Table Calculations is not correct, because a dual axis chart can be used with any type of measure, whether it is an aggregation, a calculation, or an expression. Are aggregated Dimensions is not correct, because a dual axis chart cannot be used with dimensions, only with measures. Dimensions are fields that contain qualitative values that are used to categorize or segment data, not compare them.
NEW QUESTION # 129
To display data that has both negative and positive quantitative values, Tableau Desktop will display marks by using__________________as the default.
- A. a categorical palette
- B. the full color range
- C. a diverging palette
- D. a sequential palette
Answer: C
Explanation:
Tableau Desktop will display marks by using a diverging palette as the default to display data that has both negative and positive quantitative values. A diverging palette is a type of color palette that uses two different color ranges to show positive and negative values. For example, a red-green diverging palette uses shades of red for negative values and shades of green for positive values. A diverging palette is automatically applied when there are both negative and positive values for a measure that is placed on Color on the Marks card5 The other options are not correct types of color palettes that Tableau Desktop uses as the default for data with both negative and positive values. A full color range is not a valid term for a color palette in Tableau. A sequential palette is a type of color palette that uses different shades of one color to show variations in a single measure. A sequential palette is usually applied when there are only positive values for a measure that is placed on Color on the Marks card5 A categorical palette is a type of color palette that uses different colors to show discrete values or categories. A categorical palette is usually applied when there is a dimension that is placed on Color on the Marks card5
NEW QUESTION # 130
Which of the following are valid ways to italicize Tooltip content in Tableau?
- A. Click on Worksheet in the Menu bar, select Tooltip, and then use
the italics option - B. Click on Dashboard in the Menu bar, select Tooltip, and then use the italics option
- C. Click on Tooltip in the Marks card, select the text, and then use the Italics option
- D. Click on Format in the Menu bar, choose Font, and then edit the
Tooltip options to italicize the font
Answer: A,C,D
Explanation:
The only incorrect option is - Click on Dashboard in the Menu bar, select Tooltip, and then use the italics option.
This option doesn't exist. See below:
The rest of the options do exist, and therefore are correct:
Graphical user interface, text, application Description automatically generated
NEW QUESTION # 131
What are three ways to access bolding options for the text in a tooltip? Choose three.
- A. Select Worksheet on the menu, and then select Tooltip
- B. Select Tooltip on the Marks card.
- C. Hover over a mark and press ALT+F.
- D. Select Format on the menu, and then select Font
- E. Hover over a mark and press CTRL+B.
- F. Right-click on the Field and select Format.
Answer: A,B,F
Explanation:
To access bolding options for the text in a tooltip in Tableau, you can:
Select Tooltip on the Marks card, which allows you to edit the tooltip for the specific marks.
Select Worksheet on the menu, and then Tooltip, to open the tooltip editor for the worksheet.
Right-click on the Field and select Format, which lets you format the text including bolding options in the tooltip.
NEW QUESTION # 132
Which of the following situations describe the best reason to use a union?
- A. You have two data sets saved in different formats that you want to unify into a single format.
- B. You have two tables with differently named columns of data that you want to combine.
- C. You have two tables with similarly named columns of data that you want to combine.
- D. You have two data sets with similar data types for which you want to find only distinct values.
Answer: C
Explanation:
You should use a union when you have two tables with similarly named columns of data that you want to combine. A union is a method for combining data by appending rows of one table onto another table. The tables that you union must have the same number of fields, the same field names, and the same data types2
NEW QUESTION # 133
From which three locations can you sort a visualization? Choose three.
- A. The Worksheet menu
- B. The Analysis menu
- C. Tooltip on the Marks card
- D. An axis
- E. DCA header
- F. Afield label
Answer: A,D,F
Explanation:
According to the Tableau Desktop Specialist Exam Guide, one of the exam objectives is to "Sort data in a visualization". The guide also states that "You can sort data in a visualization from three locations: the Worksheet menu, an axis, or a field label" (page 15).
NEW QUESTION # 134
When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?
- A. Blue, Red
- B. Red, Blue
- C. Orange, Blue
- D. Blue, Orange
Answer: D
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 # 135
Which of the following chart type makes use of 'binned' data?
- A. Histogram
- B. Treemaps
- C. Bullet chart
- D. Gantt Chart
Answer: A
Explanation:
Explanation
A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.
NEW QUESTION # 136
For creating variable sized bins we use __________________
- A. Groups
- B. Sets
- C. Calculated Fields
- D. Table Calculations
Answer: C
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 # 137
A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.
- A. Go to Web page
- B. Go to URL
- C. Go to Hyperlink
- D. Go to Sheet
Answer: B
Explanation:
Tricky options! Go to hyperlink and Go to Web page are not valid Actions in Tableau.
A URL action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.
You can use URL actions to create an email or link to additional information about your data. To customize links based on your data, you can automatically enter field values as parameters in URLs.
Graphical user interface, text, application, Word Description automatically generatedGraphical user interface, text, application, email Description automatically generatedGraphical user interface, text, application, Word Description automatically generatedText, letter Description automatically generated
NEW QUESTION # 138
The Shape option is available for which two views? Choose two.
- A. Packed bubbles
- B. Heat maps
- C. Scatter plots
- D. Side-by-side circles
Answer: A,C
Explanation:
The Shape option is available for scatter plots and packed bubbles views. The Shape option allows you to change the shape of marks in the view by selecting from a predefined set of shapes or adding custom shapes. You can access the Shape option by placing any field on Shape on the Marks card4 Scatter plots are views that show the relationship between two numerical variables by plotting them as coordinates on a Cartesian plane. You can create a scatter plot by placing at least one measure on Columns and at least one measure on Rows on the Marks card. You can then use Shape to assign different shapes to different categories or segments in your data5 Packed bubbles are views that show hierarchical data as a set of nested circles. Each circle represents a dimension member and its size is proportional to a measure value. You can create a packed bubble chart by placing one or more dimensions on Detail and one measure on Size on the Marks card. You can then use Shape to change the shape of circles to other shapes such as squares or stars6 The other options are not valid views for using the Shape option. Side-by-side circles are views that show proportions of a whole by using circles with different angles and sizes arranged horizontally or vertically. You can create a side-by-side circle chart by placing one dimension on Columns or Rows and one measure on Angle and Size on the Marks card. You cannot use Shape to change the shape of circles in this view7 Heat maps are views that show the distribution of two or more measures by using a color gradient and size. You can create a heat map by placing one or more dimensions on Columns and Rows and two measures on Color and Size on the Marks card. You cannot use Shape to change the shape of marks in this view8
NEW QUESTION # 139
......
Desktop-Specialist Exam Dumps - Try Best Desktop-Specialist Exam Questions: https://torrentpdf.practicedump.com/Desktop-Specialist-exam-questions.html