Maximum Grades By Making ready With Desktop-Specialist Dumps UPDATED 2023
Prepare Desktop-Specialist Exam Questions [2023] Recently Updated Questions
Tableau Desktop-Specialist Certification Exam is a globally recognized certification that examines an individual's knowledge of Tableau Desktop. Desktop-Specialist exam is designed to evaluate one's skills in using Tableau Desktop to perform data analysis and visualization tasks. Tableau Desktop Specialist Exam certification is ideal for individuals who want to demonstrate their proficiency in Tableau Desktop to potential employers or clients. Desktop-Specialist exam is offered by Tableau, a leading data visualization software company. Tableau Desktop Specialist Exam certification exam consists of 36 multiple-choice and multiple-response questions and has a time limit of 120 minutes. The passing score for the exam is 75%, and the certification is valid for three years.
Tableau Desktop-Specialist Certification Exam is designed to test the proficiency of individuals in using Tableau Desktop for data analysis and visualization. It is an industry-standard certification that validates an individual's skills in preparing, analyzing, and presenting data using Tableau Desktop. Desktop-Specialist exam is conducted by Tableau, a leading data visualization software company, and passing it demonstrates a high level of expertise in using Tableau for data analysis.
Tableau Desktop-Specialist certification exam is a performance-based exam that measures the candidate's ability to solve real-world problems using Tableau Desktop. Desktop-Specialist exam consists of multiple-choice questions, hands-on exercises, and scenario-based questions, which test the candidate's ability to analyze, interpret, and visualize data using Tableau Desktop. Desktop-Specialist exam is designed to evaluate the candidate's understanding of Tableau Desktop features and functionality and their ability to use these tools to create effective data visualizations.
NEW QUESTION # 71
The View Data window displays as much of the data as possible by default, up to _______________ rows.
- A. 20,000
- B. 5,000
- C. 15,000
- D. 10,000
Answer: D
Explanation:
Explanation
The View Data window displays as much of the data as possible by default, up to 10,000 rows. This can be increased though, if you wish to.
Read more: https://help.tableau.com/current/pro/desktop/en-gb/inspectdata_viewdata.htm
NEW QUESTION # 72
If you see the following Filter, then you're working with _______________________ Larger image
- A. Grouped Dates
- B. Date Values
- C. Date Parts
- D. Date Functions
Answer: B
Explanation:
Explanation
Dates in Tableau will behave differently depending on whether they are a Datepart (blue) or a Datevalue (green). This affects how the axes display/behave and also how visualisations such as line charts will display.
The difference essentially boils down to Dateparts behaving like a dimension as opposed to a measure which is how Datevalues behave. This means that Dateparts behave like discrete categories on the view whereas Datevalues are more like continuous numeric values.
Dateparts are discrete and they behave the same as dimension filters. If all dates are used on the filter then each individual date will be a datepart that can be selected/excluded. This is the same for each level of date, if datepart months is placed on filters January to December will be tick-able options in the filter. This also means that conditions and top/bottom filters can be applied to datepart filters like any other dimension filter.
Datevalues placed on filters behave like measure filters. A min and a max date can be set and there is a relative dates option which allows you to choose things like only show the previous 3 months or years etc.
NEW QUESTION # 73
True or False: Tableau can create worksheet-specific filters
- A. True
- B. False
Answer: A
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 # 74
How does Tableau know at which level to aggregate values?
- A. Aggregation is always done by using Tableau special formulas
- B. Values are always aggregated at the level of granularity of the worksheet.
- C. Tableau doesn't aggregate values, we do!
- D. Values are always aggregated at the level of the Date Part
Answer: B
Explanation:
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 # 75
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. July
- B. October
- C. September
- D. June
Answer: B
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 # 76
According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?
- A. Dimension Filter
- B. Measure Filter
- C. Extract Filter
- D. Context Filter
Answer: C
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 # 77
You can create _______________ for members in a dimension so that their labels appear differently in the view.
- A. aliases
- B. duplicates
- C. parameters
- D. copies
Answer: A
Explanation:
Explanation
You can create aliases (alternate names) for members in a dimension so that their labels appear differently in the view.
Aliases can be created for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures.
To create an alias:
1) In the Data pane, right-click a dimension and select Aliases.
2) In the Edit Aliases dialog box, under Value (Alias), select a member and enter a new name.
* To submit your changes: In Tableau Desktop, click OK.
On Tableau Server or Tableau Online, click the X icon in the top-right corner of the dialog box.
When you add the field to the view, the alias names appear as labels in the view. For example:
NEW QUESTION # 78
Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?
- A. $147,950
- B. $33,768
- C. $48,115
- D. $16,581
- E. (Correct)
Answer: D
Explanation:
Explanation
Phew! Tricky one! You needed to use filters in this one.
Follow along:
2) Next, as the question mentions, we need to focus on the Assortment PHONE, the color WHITE, and the state of NEW YORK. -> so we use filters for this!
i) First drag Assortment to Filters, and select only Phones :
ii) Next, drag Color to Filters and Choose only White:
iii) Next, drag State ID to Filters, and choose New York (NY):
And Voila! We have our answer as follows:
iv) Last, drag Sales to Label:
NEW QUESTION # 79
Which of the following are valid ways to trigger actions for a Dashboard?
- A. Select
- B. Double click
- C. Menu
- D. Click
- E. Hover
Answer: A,C,E
Explanation:
Explanation
Whenever we want to add actions to a Dashboard, we can trigger then in the following 3 ways:
1) Select
2) Hover
3) Menu
Hover is best for highlighting, select for filtering. Menu action is added to the tooltip and user can decide whether to run that action or not (best for URL actions)
NEW QUESTION # 80
_____________ 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 Workbook (.twb)
- C. Tableau Packaged Workbook (.twbx)
- D. Tableau Data Source (.tds)
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 # 81
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 # 82
When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?
- A. Monitor, Default, Phone, Tablet
- B. Default, Phone, Tablet, Desktop
- C. Phone, Tablet, Laptop, Desktop
- D. Phone, Monitor, Laptop, Default
Answer: D
Explanation:
Explanation
The following options are available in the Device preview section when creating a Dashboard:
NEW QUESTION # 83
Which of the following is not a Trend Line Model?
- A. Logarithmic Trend Line
- B. binomial Trend Line
- C. Linear Trend Line
- D. Exponential Trend Line
Answer: A
Explanation:
Explanation
According to the official Tableau documentation, there are 5 types of trend lines which we can work with in Tableau :
1) Linear Trend Line
2) Logarithmic Trend Line
3) Exponential Trend Line
4) Polynomial Trend Line
5) Power Model
Hence, the correct answer is BINOMIAL trend line which is not present in Tableau.
See the following image:
For more information, refer to: https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm
NEW QUESTION # 84
We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.
- A. Tableau Desktop
- B. Tableau Server
- C. Tableau Reader
- D. Tableau Online
Answer: C
Explanation:
Explanation
The word 'static tool' gives it away.
According to the official website :
NEW QUESTION # 85
Which of the following are valid ways to show Mark Labels in the visualisation?
- A. Click on Data in the Menu bar and Choose Show Mark Labels
- B. Click on Analysis in the Menu bar and choose Show Mark Labels
- C. Drag the measure to the Text label in the Marks Card
- D. Click on the Show mark labels icon in the Toolbar
Answer: B,C,D
Explanation:
Explanation
The following showcase how you can show mark labels. Using the Sample Superstore dataset:
1) Let's create a Bar chart showing the sales for each sub-category:
2) Now you can show labels by:
2.1) Click on Show Mark Labels Icon in the Toolbar ( easiest )
2.2) Drag Sales to the Text icon in the Marks Card:
2.3) Click on Analysis -> Show mark labels from the Tableau menu bar:
NEW QUESTION # 86
What does it imply if a field has a blue background?
- A. It is a measure
- B. It is continuous
- C. It is discrete
- D. It is a dimension
Answer: C
Explanation:
Explanation
When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.
NEW QUESTION # 87
________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.
- A. .tde
- B. .twb
- C. .tbm
- D. .tds
Answer: D
Explanation:
Explanation
According to the official Tableau documentation:
Tableau data source files have the .tds file extension. Data source files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on. For more information, see Save Data Sources.
NEW QUESTION # 88
Which of the following is a compelling reason to export a sheet in Tableau to a PDF?
- A. If we want a static view of the visualisation.
- B. If we want to interact with the visualisation.
- C. If we want to dynamically enter parameters to the visualisation.
- D. If we want to use filters in the visualisation.
Answer: A
Explanation:
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 # 89
_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
- A. Tableau myServer
- B. Tableau Prep
- C. Tableau Server
- D. Tableau Public
Answer: A
Explanation:
Explanation
Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.
NEW QUESTION # 90
Which of the following are valid ways to add Totals to a view?
- A. From the Analysis Tab in the Menu bar on top
- B. Using the Data Pane
- C. Using the Analytics Pane
- D. Using the Marks shelf
Answer: A,C
Explanation:
Explanation
To add totals to a view using the Analytics pane:
Also, you can add totals from the Analytics tab in the Menu above:
NEW QUESTION # 91
Which of the following are benefits of using Data Extracts in Tableau?
- A. Faster to work with
- B. Improved Performance
- C. Working with freshest data at all times
- D. Ability to use the data offline
Answer: A,B,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 # 92
Which of the following chart type makes use of 'binned' data?
- A. Histogram
- B. Bullet chart
- C. Gantt Chart
- D. Treemaps
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 # 93
Larger image
What is this entire view referred to as in Tableau?
- A. Distribution Pane
- B. Analytics Pane
- C. Data pane
- D. Summary Pane
Answer: B
Explanation:
Explanation
Distribution Pane
Explanation
This is the Analytics pane! Read more from the official documentation below:
NEW QUESTION # 94
......
Give push to your success with Desktop-Specialist exam questions: https://www.actualtests4sure.com/Desktop-Specialist-test-questions.html
Desktop-Specialist 100% Guarantee Download Desktop-Specialist Exam PDF Q&A: https://drive.google.com/open?id=1kRyH2HJjjqqUBB6yxSEWPrjMM5kmPDh4
