100% Reliable Microsoft Desktop-Specialist Exam Dumps Test Pdf Exam Material
Based on Official Syllabus Topics of Actual Tableau Desktop-Specialist Exam
The benefits of earning the Tableau Desktop Specialist Certification are numerous. Firstly, it demonstrates an individual's proficiency in using Tableau Desktop, which enhances their credibility and reputation as a data professional. Secondly, it improves an individual's job prospects and makes them more competitive in the job market. Finally, it provides access to Tableau's exclusive community of certified professionals, which offers networking opportunities, job leads, and access to valuable resources and training.
To prepare for the Tableau Desktop Specialist certification exam, candidates can take advantage of various resources, including in-person training, online courses, and self-study materials. Tableau also offers a practice exam to help candidates get a feel for the types of questions that will be on the actual exam. Desktop-Specialist exam consists of 30 multiple-choice questions that must be completed within 60 minutes.
NEW QUESTION # 25
By default, what does Tableau do when you connect to a data source?
- A. Creates a live connection to the data
- B. Loads your actual file into Tableau
- C. Sorts the data in descending order
- D. Creates an extract of the data
Answer: A
Explanation:
Before you can build a view and analyze your data, you must first connect Tableau to your data. Tableau supports connecting to a wide variety of data, stored in a variety of places.
By default, when you connect a data source to Tableau, Tableau will create a live connection to the data.
Live connection refers to a data source that contains direct connection to underlying data, which provides real-time or near real-time data. With a live connection, Tableau makes queries directly against the database or other source, and returns the results of the query for use in a workbook. Users can create live connections and then share them on Tableau Server so that other Tableau users can use the same data using the same connection and filtering settings.
NEW QUESTION # 26
Given a map, which of the following fields can be placed in Size,Shape,Detail,Color
- A. Sales, State, Country, Profit
- B. Profit, State, Number of Records, Sales
- C. Longitude, Country, State, Sales
- D. Region, Country, Profit, State
Answer: A
Explanation:
Since Sales is a measure, it can easily be depicted via size.
To drill down and change the level of detail, Country is the correct choice since it will contain STATE. We can then depict the various states by different shapes such as circle, square etc.
Finally, the Profit can be depicted via a color! Eg - Red for poor and green for excellent profits!
NEW QUESTION # 27
The default path for all supporting files, data sources, icons, logs etc is in ______________________
- A. Documents -> My Tableau Repository
- B. Documents -> Tableau Files
- C. Downloads -> Tableau Support Files
- D. Documents -> Tableau
Answer: A
Explanation:
By default, all of the above mentioned are stored in Documents -> My Tableau Repository
NEW QUESTION # 28
When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.
- A. Continuous
- B. Mixed
- C. Fading
- D. Discrete
Answer: A
Explanation:
When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field.
When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.
Web version:
Desktop Version:
For more information about color palettes, see Color Palettes and Effects.
NEW QUESTION # 29
If you have a dashboard and are displaying its filter, how can you rearrange it?
- A. By clicking on the filter title and dragging it.
- B. By clicking on the 2 lines on top and dragging the filter.
- C. By clicking on the dropdown and dragging the filter
- D. By clicking anywhere inside the filter and dragging it.
Answer: B
Explanation:
You can drag the filter by clicking on the 2 lines on top, and then dragging the filter as shown:
NEW QUESTION # 30
For creating variable sized bins we use __________________
- A. Calculated Fields
- B. Groups
- C. Table Calculations
- D. Sets
Answer: A
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 # 31
Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through
2014, respectively?
- A. 52,678 and 311,404
- B. 1,807 and 34,571
- C. 5,129 and 88,872
- D. 4,888 and 17,817
Answer: D
Explanation:
Explanation
To reach the correct answer, follow these steps:
1) Drag Order Date (Discrete Year) to the Column shelf, and Region to the Row Shelf as shown:
2) Drag Profit to Text in the Marks Shelf as shown:
3) Click on Analysis as shown -> Totals -> SELECT ROW GRAND TOTALS
The following will be the final view:
You could also Filter by Region to only Focus on Canada, but that's your choice:
THEREFORE,
2012 = 4,888
2011 -> 2014 = 17,817
NEW QUESTION # 32
Which statement accurately describes an extract when the Physical Tables option is selected?
- A. Data shown in the Data pane is separated based on the table type.
- B. Data is limited to only the Top N of data for the connection.
- C. An individual table is created for each physical table in the extract.
- D. All the data is tolled up to the current visible fields.
Answer: C
Explanation:
When the Physical Tables option is selected for an extract in Tableau, an individual table is created for each physical table in the extract. This means that the extract will include a separate table for each underlying table in your database, maintaining the database's structure within the extract. This can be useful when you need to preserve the original granularity of the data or when working with certain database optimizations.
NEW QUESTION # 33
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
- A. June
- B. July
- C. October
- D. September
Answer: C
Explanation:
Explanation
Follow along:
1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.
For sales, click on the pill -> choose Quick Table calculation -> Year over Year growth.
The view should now look like:
NEW QUESTION # 34
You need to uniformly change the size for all marks in a view.
What should you do?
- A. Select Format on the menu, and then select Cell Size.
- B. Select Label on the Marks card and then select Alignment.
- C. Select Size on the Marks card and use the slider to adjust the size
- D. Use the Fit dropdown menu on the toolbar.
Answer: C
Explanation:
You should select Size on the Marks card and use the slider to adjust the size to uniformly change the size for all marks in a view. The Size property on the Marks card allows you to control the size of marks in the view by moving the slider to the left or right. The Size slider affects different marks in different ways, such as making them bigger or smaller, wider or narrower, or thicker or thinner1 The other options are not valid ways to uniformly change the size for all marks in a view. Selecting Label on the Marks card and then selecting Alignment will allow you to change the position of labels on marks, not the size of marks2 Using the Fit dropdown menu on the toolbar will allow you to change how the view fits within the worksheet, not the size of marks3 Selecting Format on the menu, and then selecting Cell Size will allow you to change the height and width of cells in a text table, not the size of marks in other types of views4
NEW QUESTION # 35
At a minimum, what do you need to create a simple scatter plot?
- A. A dimension on Detail and a measure on Columns
- B. A measure on Columns and a measure on Rows
- C. A dimension on Columns and a measure on Rows
- D. A dimension on Columns and a dimension on Rows
Answer: B
Explanation:
To create a simple scatter plot in Tableau, you need to have a measure on Columns and a measure on Rows. A scatter plot is a type of visualization that shows the relationship between two numerical variables. In Tableau, you can create a scatter plot by placing at least one measure on the Columns shelf and at least one measure on the Rows shelf. The measures can be continuous or discrete, but they must be aggregated. The marks in the scatter plot represent the intersection of the values for each measure1 The other options are not valid ways to create a simple scatter plot in Tableau. A dimension on Detail and a measure on Columns will create a bar chart, not a scatter plot. A dimension on Columns and a measure on Rows will create a line chart or an area chart, depending on the mark type. A dimension on Columns and a dimension on Rows will create a text table or a heat map, depending on the mark type1
NEW QUESTION # 36
You need to access options to change a dimension's color palette.
In addition to the Marks card, what else can you use?
- A. Edit in Shelf
- B. The Format menu
- C. The Color legend
- D. Edit Caption
Answer: C
Explanation:
You can use the Color legend to access options to change a dimension's color palette, in addition to the Marks card. The Color legend shows the colors assigned to each member of the dimension in the view. You can right-click on the Color legend and select Edit Colors to open the Edit Colors dialog box, where you can change the color palette, assign specific colors to dimension members, or edit the color transparency and border6 The other options are not valid ways to change a dimension's color palette. Edit in Shelf is a feature that allows you to edit the fields on the Rows or Columns shelves by typing directly on the shelf. It does not affect the color palette of the dimension7 The Format menu allows you to change the appearance of various elements in the workbook, such as fonts, borders, shading, alignment, etc. It does not have options for changing the color palette of the dimension8 Edit Caption is a feature that allows you to add or edit a caption for a worksheet or dashboard. It does not affect the color palette of the dimension
NEW QUESTION # 37
What are two ways to share a dashboard as an image file? Choose two.
- A. Export on the Worksheet menu
- B. Export Image on the Dashboard menu
- C. Copy Formatting on the Format menu
- D. A dashboard export button
Answer: B,D
Explanation:
You can share a dashboard as an image file by using one of the following methods: Export Image on the Dashboard menu, or a dashboard export button. Export Image on the Dashboard menu allows you to export the dashboard as an image file in BMP, JPEG, PNG, or SVG format. A dashboard export button is a custom button that you can create on your dashboard to export it as an image file using a URL action
NEW QUESTION # 38
How can you change the Default Aggregation for a measure in Tableau?
- A. By double clicking on the measure, and then choosing Window -> Default Aggregation
- B. By changing its properties manually every time we need to use it
- C. By right clicking the dimension -> Default properties and choosing Aggregation
- D. By right clicking the measure -> Default properties and choosing Aggregation
Answer: D
Explanation:
According to the official Tableau documentation:
Dimensions don't have aggregation properties, and adding properties manually each time defeats the whole DEFAULT aggregation purpose. Window tab doesn't have any default aggregation option!
NEW QUESTION # 39
What are two requirements to combine two tables by using a union? Choose two.
- A. Related fields must have matching data types.
- B. The tables must have the same number of fields.
- C. Related fields must have different names.
- D. The tables must come from different connections.
Answer: A,B
Explanation:
To perform a union in Tableau, the tables must have a related field with matching data types, and they must have the same number of fields. This allows the tables to be appended vertically in the data source. Different names or tables from different connections do not affect the ability to union the tables.
NEW QUESTION # 40
You have a visualization that uses multiple types of sorting.
How can you clear all sorting of the visualization?
- A. From the Worksheet menu, select Clear, and then select Sorts.
- B. From the Dashboard menu, select Clear.
- C. Right-click a sorted field, and then select Clear Sort.
- D. From the Header label, select the sort icon.
Answer: A
Explanation:
To clear all sorting in a Tableau visualization, you would go to the Worksheet menu, select the "Clear" option, and then choose "Sorts." This action removes all sorting that has been applied to the visualization, including any custom sorting or sorting based on multiple fields. This is a quick way to reset the view to its default sorting state and is particularly useful when you have applied various sorting layers and wish to start fresh.
NEW QUESTION # 41
Which of the following are required to create a trend line?
- A. 1 measure, or a date and a dimension on opposing axes.
- B. 1 measure only
- C. 2 measures on opposing axes, or a date and a measure on
opposing axes. - D. 2 dimensions, or a date and a dimension on opposing axes.
Answer: C
Explanation:
To create a trend line, we need:
Graphical user interface, application Description automatically generated
NEW QUESTION # 42
What does the box in a box plot represent?
- A. Minimum value of the data
- B. The median of the middle half of the data points
- C. Maximum value of the data
- D. The interquartile range
Answer: D
Explanation:
In a box and whisker plot:
1) The ends of the box are the upper and lower quartiles, so the box spans the interquartile range
2) The median is marked by a vertical line inside the box
3) The whiskers are the two lines outside the box that extend to the highest and lowest observations.
NEW QUESTION # 43
Which two types of aggregations can be applied to string fields? Choose two.
- A. Sum
- B. Average
- C. Minimum
- D. Count Distinct
Answer: C,D
Explanation:
The two types of aggregations that can be applied to string fields in Tableau are Count Distinct and Minimum.
Count Distinct counts the unique values of a field, and Minimum finds the smallest value in a field based on the alphanumeric order. String fields do not support numeric aggregations like Sum or Average.
NEW QUESTION # 44
When creating a date filter in Tableau, to what does Anchor refer?
- A. The date in a range-of-dates filter to which you anchor units of time.
- B. The latest date in the data source that can be found.
- C. The mid-point in the range of displayed dates.
- D. The date in a relative-date filter to which you anchor a unit of time.
Answer: D
Explanation:
When creating a date filter in Tableau, anchor refers to the date in a relative-date filter to which you anchor a unit of time. A relative-date filter is a type of filter that allows you to dynamically filter data based on a range of time relative to the current date or a specific date. For example, you can use a relative-date filter to show data for the last 7 days, the next 3 months, or the current quarter1 To create a relative-date filter, you need to specify the following options: The date field that you want to filter. The unit of time that you want to use for the filter, such as days, weeks, months, quarters, or years. The range of time that you want to show relative to the anchor date, such as last, next, this, or to date. The anchor date that you want to use as the reference point for the filter. You can use the current date or a custom date as the anchor date1 For example, if you want to create a relative-date filter that shows data for the last 3 months from January 1st, 2022, you would select the following options: Date field: Order Date Unit of time: Months Range of time: Last 3 Anchor date: Custom (01/01/2022) 1 The other options are not valid definitions of anchor when creating a date filter in Tableau. The mid-point in the range of displayed dates is not related to the anchor date, but rather to the center of the axis that represents the date field. The date in a range-of-dates filter to which you anchor units of time is not correct, because a range-of-dates filter does not use an anchor date, but rather a start and end date that can be fixed or dynamic. The latest date in the data source that can be found is not related to the anchor date, but rather to the maximum value of the date field in the data source2
NEW QUESTION # 45
True or False: It is not possible to blend axes for multiple measures into a single axis
- A. False
- B. True
Answer: A
Explanation:
We can very much blend multiple measures into a single axis. Such charts are called Combined-Axis / Blended-Axis charts. Follow along:
Measures can share a single axis so that all the marks are shown in a single pane. To blend multiple measures, drag one measure or axis and drop it onto an existing axis.
Instead of adding rows and columns to the view, when you blend measures there is a single row or column and all of the values for each measure is shown along one continuous axis. For example, the view below shows quarterly sales and profit on a shared axis.
Note: If you drag a measure on to the canvas and only see a single ruler indicator instead of the double ruler indicator shown below, Tableau creates dual axes instead of a blended axis. For more information about how to create dual axes, see Compare two measures using dual axes.
NEW QUESTION # 46
You create the following visualization.
What is the first step to create the visual grouping of the 10 marks shown in blue?
- A. Select the desired 10 marks in the view.
- B. Create a Group on the Property Description field in the Data pane.
- C. Select the desired 10 text labels under Property Description.
- D. Create a Set on the Neighborhood field in the Data pane.
Answer: A
Explanation:
To visually group marks in Tableau, you typically start by selecting the marks directly in the view. Once the desired marks are selected, you can then create a group from them. This will visually group the selected marks, as indicated by the blue color in the example provided.
NEW QUESTION # 47
Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?
- A. 0
- B. 1
- C. 2
- D. Correct)
- E. 3
Answer: B
Explanation:
Explanation
Follow along the steps below:
* Drag Assortment and Year ID to the column shelf, and Item Number ID to the row shelf. Next, drag Sales to the Text label to create a cross-tab as below:
NEW QUESTION # 48
......
Free Desktop-Specialist Dumps are Available for Instant Access: https://www.pass4surequiz.com/Desktop-Specialist-exam-quiz.html
View All Desktop-Specialist Actual Exam Questions Answers and Explanations for Free: https://drive.google.com/open?id=1Xw_zkJWC1MB1sQwXTG5Sd25qMh7xCukO