[Aug 18, 2023] Get New Desktop-Specialist Practice Test Questions Answers
Desktop-Specialist Dumps and Exam Test Engine
The benefits of passing the Tableau Desktop-Specialist Exam are numerous. Certification demonstrates to potential employers or clients that you have a comprehensive understanding of Tableau Desktop and can use it to solve complex business problems. Certified individuals are also listed on the Tableau website, giving them visibility and recognition within the Tableau community. Additionally, certified individuals have access to exclusive resources, such as the Tableau Desktop Specialist LinkedIn community, where they can network with other certified professionals and stay up to date on the latest Tableau news and trends.
The Tableau Desktop-Specialist exam is conducted online and consists of multiple-choice questions. The duration of the exam is two hours, and individuals must answer 36 questions to pass. Desktop-Specialist exam fee is $100, and individuals who pass the exam will receive a digital badge and a certificate of completion.
NEW QUESTION # 60
______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.
- A. Joining
- B. Combining
- C. Unioning
- D. Blending
Answer: C
Explanation:
Explanation
Unioning is the correct answer!
From the official documentation:
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."
NEW QUESTION # 61
Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?
- A. Peru
- B. Mexico
- C. Argentina
- D. Brazil
Answer: B
Explanation:
Explanation
VERY IMPORTANT QUESTION FOR THE EXAM, PAY ATTENTION
1) To find the number of days between order date and shipping date, we will make use of a calculated field:
In the data pane, click on the dropdown arrow, and choose create calculated field.
Let's name this calculated field "ShippingDelay" (you can name it anything you want :) )
2) Use the DATEDIFF() function, and pass it the arguments as follows:
'day' depicts that we want to calculate the number of DAYS between the two dates. The first argument is
'start_date' which is the ORDER_DATE (day the order was placed), the second argument is 'end_date', which is the SHIP_DATE (date the order was shipped). So by subtracting as follows: SHIP_DATE - ORDER_DATE, we can find the delay in shipping.
Click OK.
3) You should now have a new measure as follows:
4) Phew! The hard part is done! Now let's filter by Market to include only LATAM:
5) Drag Country to the view, and the new calculated field 'ShippingDelay' to SIZE on the Marks Shelf as follows:
*You can also click on Show Text Labels to be sure that you're choosing the Largest value*
Clearly, Mexico has the highest Shipping Delay!
NEW QUESTION # 62
True or False: Trend lines can only be used with numeric or date fields
- A. False
- B. True
Answer: A
Explanation:
Explanation
You can show trend lines in a visualization to highlight trends in your data.
To add trend lines to a view, both axes must contain a field that can be interpreted as a number. For example, you cannot add a trend line to a view that has the Product Category dimension, which contains strings, on the Columns shelf and the Profit measure on the Rows shelf.
However, you can add a trend line to a view of sales over time because both sales and time can be interpreted as numeric values.
NEW QUESTION # 63
Which of the following returns the Absolute Value of a given number?
- A. ZN(Number)
- B. ABS(Number)
- C. CEILING(Number)
- D. FLOOR(Number)
Answer: B
Explanation:
Explanation
From the official Tableau website:
NEW QUESTION # 64
How can you MANUALLY assign geographic roles to a dimension from the data pane?
- A. Right click it -> Geographic role -> and then assign the appropriate geographic role
- B. Edit the data source manually for a quick resolution
- C. Right click it -> Edit Default properties -> Assign geographic roles
- D. Edit the config file in My Documents -> MyTableauRepository for a quick fix
Answer: A
Explanation:
Explanation
From the data pane, simply right click on the dimension, choose geographic role, and then select the appropriate role as follows:
NEW QUESTION # 65
Which of the following calculations DO NOT need a quick table calculation?
- A. Variance
- B. Standard Deviation
- C. Moving Average
- D. Rank
Answer: A
Explanation:
Explanation
For Standard Deviation and Variance, we don't need to use quick table calculations, since they are available by default. See below:
However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average belong to only this category.
NEW QUESTION # 66
Which of the following is the correct way to calculate Profit Ratio in Tableau?
- A. Profit / Sales
- B. Sales / Profit
- C. SUM(Sales)/SUM(Profit)
- D. SUM(Profit) / SUM(Sales)
Answer: D
Explanation:
Explanation
THIS IS A VERY IMPORTANT QUESTION
Aggregation is an important concept to consider when creating calculated fields. A calculated field for SUM([Profit]) / SUM([Sales]) will give you a very different answer than [Profit] / [Sales], even though both formulas are valid.
If you do not provide the aggregation within the calculated field, Tableau will calculate the equation for every record ( row ) in your analysis, then aggregate the answers for all of the rows together when the calculated field is added to the view.
In simple terms, if specify the aggregation such as SUM, what Tableau will do is that it will first calculate the sum of the Profit column ( say x ), then calculate the sum of the Sales column ( say y ), and then simply apply x/y ---> This is what we expect! Perfect!
BUT, if you don't specify the aggregation, it will go to every single ROW, perform Profit / Sales, and then aggregate the answers calculated for each row. This is simply NOT what we wan't!
An example:
NEW QUESTION # 67
Is SUM a table calculation?
- A. Yes
- B. No
Answer: B
Explanation:
Explanation
SUM is an aggregate function, not a table calculation!
A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.
The most common Table calculations are:
Running Total
Percent Difference
Difference
Percent of Total
Rank
Percentile
These can be calculated using : Table(across), Cell, or Specific dimensions!
NEW QUESTION # 68
True or False: It is possible to add a field to more than one hierarchy
- A. False
- B. True
Answer: B
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 # 69
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 States
- B. France
- C. United Kingdom
- D. Canada
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 # 70
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
- A. Extract Filter
- B. Dimension Filter
- C. Measure Filter
- D. Context Filter
Answer: A
Explanation:
Explanation
According to Tableau's order of operations, the Extract filter is right at the top of the hierarchy. The data filtered in the Extract is then passed on to what we see in the Data Pane. See below:
NEW QUESTION # 71
When exporting a worksheet as an image in Tableau, which of the following file formats are available?
- A. Windows Bitmap (.BMP)
- B. JPEG Image (.JPG, .JPEG)
- C. Tagged Image File Format (TIFF)
- D. Portable Network Graphic (.PNG)
Answer: A,B,D
Explanation:
Explanation
The following options are available when an image is Exported:
NOTE: When we Copy an image rather than exporting it, then the image is copied to the clipboard in the TIFF file format! However, it is not available when EXPORTING an image.
NEW QUESTION # 72
Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.
How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Explanation
If you chose 2, then you were very close but probably didn't plot the actual Percent Difference on your view. ( One of the marks is just over the line).
* Firstly, Drop the Week ID onto the column shelf, and convert it to continuous since we need both Year and Quarter as mentioned in the question.
* 2) Next, Drop assortment to filters shelf so that we can focus on Electronics!
3) This should be your view now. Click on the Show Mark Labels icon as shown:
The final view is as follows, with 3 points below 0 ( i.e negative )
NEW QUESTION # 73
True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.
- A. False
- B. rue
Answer: A
Explanation:
Explanation
It is possible in Tableau to use a sheet within a story directly.
Moreover, in Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.
At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.
NEW QUESTION # 74
Which of the following would you use to edit the Shape, colour, and Text of your visualisations?
- A. Filter Shelf
- B. Data Pane
- C. Marks Card
- D. Analytics Pane
Answer: C
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 # 75
Which of the following would you use to connect to multiple tables in a single data source at once?
- A. A Set
- B. A Hierarchy
- C. A Join
- D. A Blend
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 # 76
True or False: Tableau can create worksheet-specific filters
- A. False
- B. True
Answer: B
Explanation:
Explanation
Yes, it is possible to create worksheet-specific filters in Tableau.
When you add a filter to a worksheet, by default it applies to the current worksheet. Sometimes, however, you might want to apply the filter to other worksheets in the workbook.
Then, you can select specific worksheets to apply the filter to or apply it globally to all worksheets that use the same data source or related data sources.
NEW QUESTION # 77
When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.
- A. Pattern Search
- B. Regex Search
- C. Union Search
- D. Wildcard Search
Answer: D
Explanation:
Explanation
You can use Wildcard Search to set up search criteria to automatically include tables in your union. Use the wildcard character, which is an asterisk (*), to match a sequence or pattern of characters in the Excel workbook and worksheet names, Google Sheets workbook and worksheet names, text file names, JSON file names, .pdf file names, and database table names.
When working with Excel, text file data, JSON file, .pdf file data, you can also use this method to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page.
NEW QUESTION # 78
To connect Tableau to a CSV data source what type of connection should you use?
- A. Spatial
- B. Excel
- C. JSON
- 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 # 79
Which of the following charts types always includes bars sorted in descending order?
- A. Pareto Chart
- B. Stacked Bar Chart
- C. Gantt Chart
- D. Pie Chart
Answer: A
Explanation:
Explanation
A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the ascending cumulative total is represented by the line.
On the primary axis, bars are used to show the raw quantities for each dimension member, sorted in descending order.
On the secondary axis, a line graph is used to show the cumulative total in percent format.
NEW QUESTION # 80
......
2023 New DumpsMaterials Desktop-Specialist PDF Recently Updated Questions: https://www.dumpsmaterials.com/Desktop-Specialist-real-torrent.html
Tableau Desktop-Specialist DUMPS WITH REAL EXAM QUESTIONS: https://drive.google.com/open?id=1havbj_Os45pjSsDx7hnBo4yk_7xs6yCQ
