Free May-2022 Desktop-Specialist Certification Sample Questions certification Exam
Certification Topics of Desktop-Specialist Exam PDF Recently Updated Questions
Who should take the Tableau Desktop-Specialist: Tableau Desktop Specialist Exam
The Architect-Professional Assessment of Tableau Accredited Solutions is designed for those with an architectural location and a reliable experience of one or more years constructing applicable, cost-effective and scalable Tableau systems. Tableau Desktop-Specialist practice exams effectively demonstrates how stable and practical Tableau application systems can be designed and implemented. Define a market approach utilizing architectural architecture principles Advice on delivery throughout the project life cycle, reflecting on best practices for the organisation.
The Tableau Desktop-Specialist: Tableau Desktop Specialist exam is designed for IT and organisation-level experts with standard Tableau framework expertise. The Tableau CCP credential validates prospective consumers' awareness of these concerns and their qualifications, requirements, main resources and their use and safety, and conformity with the Tableau model, paid versions and costs. Tableau Desktop-Specialist exam dumps is the right starting point for Tableau qualification and also an ideal resource for non-technical project enthusiasts.
How much Tableau Desktop-Specialist: Tableau Desktop Specialist Exam Cost
The cost of the Tableau Desktop-Specialist: Tableau Desktop Specialist Exam is $150. For more information related to exam prices, please visit the official website Tableau Website as the cost of exams may be subjected to vary county-wise.
NEW QUESTION 63
When exporting a worksheet as an image in Tableau, which of the following file formats are available?
- A. JPEG Image (.JPG, .JPEG)
- B. Portable Network Graphic (.PNG)
- C. Windows Bitmap (.BMP)
- D. Tagged Image File Format (TIFF)
Answer: A,B,C
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 64
Which Sub-Category had the least Profit in the Office Supplies category?
- A. Fasteners
- B. Envelopes
- C. Labels
- D. Binders
Answer: A
Explanation:
Explanation
To reach the correct answer, follow the steps below:
1) Drag Category, and sub-category to the row shelf. Drag Profit to the Column shelf
2) Click the Sort-ascending icon as shown above, to sort the profits from least to greatest as shown:
Click the 'Show mark labels icon'
As we can see, Fasteners has the least Profit in the Office Supplies Category, and hence is our correct answer!
NEW QUESTION 65
Dragging a ______________ to colour creates distinct colours for each item whereas dragging a
______________ to colour creates a gradient
- A. Geographic Value, Discrete Value
- B. Discrete value, Continuous Value
- C. Longitude, Latitude
- D. Continuous Value, Discrete Value
Answer: B
Explanation:
Explanation
Remember that dragging a discrete value to colour creates distinct colours for each item whereas dragging a continuous value to colour creates a gradient. ( Same for Map ) From the official documentation:
NEW QUESTION 66
A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.
- A. .twb file
- B. .tde file
- C. .twbx file
- D. .tbm file
Answer: C
Explanation:
Explanation
According to the official Tableau documentation:
Tableau packaged workbooks have the .twbx file extension. A packaged workbook is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data. For more information, see Packaged Workbooks.
NEW QUESTION 67
Which of the following are the options to export the data used to build the view / visualisations?
- A. JSON format
- B. PDF File
- C. CSV file
- D. MS Access Database
Answer: D
Explanation:
Explanation
You can export the data in a Tableau data source, including all or part of the records from your original data.
Alternatively, you can export only the portion of data used to generate the view.
Since the question mentions the data used to build the view, we'll focus on that :
*Export data in the view to Microsoft Access or .csv*
Export the data that is used to generate the view as an Access database (Windows only) or .csv file (Mac only).
1) In Tableau Desktop, select Worksheet > Export > Data.
2) Select a location and type a name for your Access database or .csv file.
3) Click Save.
4) If you're on Windows, the Export Data to Access dialog box displays to give you the option to immediately use the new Access database and continue working in Access without interrupting your work flow.
NEW QUESTION 68
How would you calculate GDP per capita in Tableau?
- A. SUM([GDP]) / SUM([Population])
- B. SUM([GDP]/[POPULATION])
- C. SUM([GDP]*[POPULATION])
- D. SUM([Population]/[GDP]])
Answer: A
Explanation:
Explanation
GDP / Population = GDP Per Capita
Here Sum is a function, / and + are operators. On the bottom there are comments.
NEW QUESTION 69
To connect Tableau to a CSV data source what type of connection should you use?
- A. Spatial
- B. Text
- C. Excel
- D. JSON
Answer: B
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 70
Are animations enabled by default in Tableau?
- A. No
- B. Yes
Answer: A
Explanation:
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 71
What does the following icon do in Tableau?
Larger image
- A. Create a Story
- B. Create a Dashboard
- C. Create a Worksheet
- D. Create a Story and Dashboard both
Answer: B
Explanation:
Explanation
The icon shown is used to add a new Dashboard! From the official documentation:
NEW QUESTION 72
Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?
- A. 111,060
- B. 1,461
- C. 1,222
- D. 112,256
Answer: D
Explanation:
Explanation
If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.
To reach the correct answer, follow the steps below:
1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well!
Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!
* The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October
NEW QUESTION 73
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?
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. October
- B. June
- C. September
- D. July
Answer: A
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:
It is clear that October with -55.3% had the lowest Year on Year growth.
NEW QUESTION 74
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: A
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 75
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. False
- B. True
Answer: B
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 76
For a relative date filter, the default anchor is _________________
- A. Today's date
- B. The current time
- C. The date we specify
- D. The target date
Answer: D
Explanation:
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 77
Which of the following can you add a reference line to?
- A. Groups
- B. Dimensions
- C. Measures
- D. Calculated Fields
Answer: C,D
Explanation:
Explanation
You can add reference lines, bands, distributions, or (in Tableau Desktop but not on the web) box plots to any continuous axis in the view.
Reference Lines - You can add a reference line at a constant or computed value on the axis. Computed values can be based on a specified field. You can also include confidence intervals with a reference line.
NEW QUESTION 78
______________ 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. Blending
- B. Unioning
- C. Combining
- D. Joining
Answer: B
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 79
You can use the __________________ in Tableau to clean / organise your data.
- A. Data manager
- B. Data cleaner
- C. Data organiser
- D. Data interpreter
Answer: D
Explanation:
Explanation
When you track data in Excel spreadsheets, you create them with the human interface in mind. To make your spreadsheets easy to read, you might include things like titles, stacked headers, notes, maybe empty rows and columns to add white space, and you probably have multiple tabs of data too.
When you want to analyze this data in Tableau, these aesthetically pleasing attributes make it very difficult for Tableau to interpret your data. That's where Data Interpreter can help.
NEW QUESTION 80
True or False: All rows from both tables are returned in an INNER JOIN
- A. True
- B. False
Answer: B
Explanation:
Explanation
The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns.
Consider 2 tables "Orders" and "Customers".
If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!
NEW QUESTION 81
_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.
- A. Tableau Data Extract (.tde)
- B. Tableau Data Source (.tds)
- C. Tableau Packaged Workbook (.twbx)
- D. Tableau Workbook (.twb)
Answer: A
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 82
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us
- A. 2 , 3
- B. 2 , 2
- C. 1 , 4
- D. 1 , 2
Answer: C
Explanation:
Explanation
Tableau auto-generates :
1 Dimension - Measure Names
4 Measures - Latitude, Longitude, Number of records, Measure Values
Starting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)
NEW QUESTION 83
A field that shows average home values for the United States in 2016 is most likely :
- A. A geographical dimension
- B. A discrete date part dimension
- C. An aggregated measure
- D. A continuous date value dimension
Answer: C
Explanation:
Explanation
This question is directly from the Official Tableau Desktop Specialist exam guide.
Since we are talking about the AVERAGE home values for the United States in 2016, the question is directly offering us a hint that the answer has something to do with aggregation and that too the values tell us that we're working with MEASURES.
Date part and Date values don't really make much sense given the question, and neither does geography.
Therefore, the answer naturally is "An aggregated measure".
NEW QUESTION 84
What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?
- A. Fields used in Blends must first be aggregated
- B. The calculated fields created in Blends cannot be edited once created
- C. No difference, calculated fields cannot be created in Blends
- D. The calculated fields created in Blends cannot use more than 2 fields
Answer: A
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 85
__________ is a technique in Tableau which will identify marks with similar characteristics
- A. Union
- B. Sets
- C. Clustering
- D. Grouping
Answer: C
Explanation:
Explanation
Cluster analysis partitions marks in the view into clusters, where the marks within each cluster are more similar to one another than they are to marks in other clusters.
NEW QUESTION 86
......
2022 New Preparation Guide of Tableau Desktop-Specialist Exam: https://www.pass4surecert.com/Tableau/Desktop-Specialist-practice-exam-dumps.html
Desktop-Specialist Exam Prep Guide: Prep guide for the Desktop-Specialist Exam: https://drive.google.com/open?id=1vEK19r_gphrS76-9oPm7PN2J35sRqfoQ