Desktop-Specialist Exam Dumps - Try Best Desktop-Specialist Exam Questions from Training Expert Pass4sureCert
Practice Examples and Dumps & Tips for 2021 Latest Desktop-Specialist Valid Tests Dumps
NEW QUESTION 54
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 55
For Bullet Graphs we need at least ____________ measures
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Explanation
A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures.
Therefore, we need at least 2 measures for creating bullet graphs.
NEW QUESTION 56
Which of the following are the options to export the data used to build the view / visualisations?
- A. JSON format
- B. CSV file
- C. PDF 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 57
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 58
Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser?
- A. NO, this is not currently possible in Tableau
- B. YES, we can do this with the help of a Web-Page object
- C. YES, we can do this with the help of a plugin
- D. YES, we can do this with the help of Tableau Public
Answer: B
Explanation:
Explanation
To interactively display information from the web INSIDE a dashboard, you can use a URL action with a web page object.
For example, you might have a dashboard that shows profits by country. In addition to showing the profit data in your dashboard, you also want to display supplemental information about the countries from a web site.
NEW QUESTION 59
You can _______________ your data to combine two or more tables by appending values (rows) from one table to another
- A. join
- B. union
- C. concatenate
- D. blend
Answer: B
Explanation:
Explanation
You can union your data to combine two or more tables by appending values (rows) from one table to another.
To union your data in Tableau data source, the tables must come from the same connection.
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."
A union of these tables creates the following single table that contains all rows from all tables.
NEW QUESTION 60
Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?
- A. 3.704
- B. 3.500
- C. 3.840
- D. 3.000
Answer: A
Explanation:
Explanation
Since we need to focus on 1 country -> Japan, let's filter on it first as follows:
1) Drag Country to the filter shelf, and choose only Japan. Click OK.
2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:
Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.
Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.
The following is our visualisation:
Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME.
Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward :)
NEW QUESTION 61
How would you calculate GDP per capita in Tableau?
- A. SUM([GDP]) / SUM([Population])
- B. SUM([Population]/[GDP]])
- C. SUM([GDP]/[POPULATION])
- D. SUM([GDP]*[POPULATION])
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 62
Which of the following are valid ways to trigger actions for a Dashboard?
- A. Select
- B. Hover
- C. Menu
- D. Click
- E. Double click
Answer: A,B,C
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 63
What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?
- A. The calculated fields created in Blends cannot be edited once created
- B. The calculated fields created in Blends cannot use more than 2 fields
- C. No difference, calculated fields cannot be created in Blends
- D. Fields used in Blends must first be aggregated
Answer: D
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 64
Larger image
What is this entire view referred to as in Tableau?
- A. Summary Pane
- B. Distribution Pane
- C. Data pane
- D. Analytics Pane
Answer: D
Explanation:
Explanation
Distribution Pane
Explanation
This is the Analytics pane! Read more from the official documentation below:
NEW QUESTION 65
_______________ 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 Public
- C. Tableau Server
- D. Tableau Prep
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 66
Which of the following can you add a reference line to?
- A. Measures
- B. Dimensions
- C. Calculated Fields
- D. Groups
Answer: A,C
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 67
The calculation [Ship Date] - [Order Date] will return _______________
- A. Number of unique orders placed between these dates
- B. Number of orders shipped between these dates
- C. Number of orders placed in that duration
- D. Number of days between these dates
Answer: D
Explanation:
Explanation
As the names suggest, if we subtract the order date from the shipping date, we simply get the number of days between these 2 dates.
We can these use this calculated field in our charts, and can use COUNT, SUM, AVG etc with them according to our need.
NEW QUESTION 68
Which of the following is a good reason for using a bullet graph?
- A. Forecasting future sales
- B. Displaying the year-on-year growth in sales
- C. Comparing the actual sales against the target sales
- D. Analysing the trend over a given time period
Answer: C
Explanation:
Explanation
A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales.
NEW QUESTION 69
Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a
____________ and a ____________.
- A. dimension, measure
- B. role, type
- C. Data type, Value
- D. type, role
Answer: B
Explanation:
Explanation
When users connect to Tableau, the data fields in their data set are automatically assigned a role and a type.
Role can be of the following two types:
1) Dimension
2) Measure
Type can be of the following :
1) String
2) Number
3) Geographic
4) Boolean
5) Date
6) Date and Time
NEW QUESTION 70
Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?
- A. No
- B. Yes
Answer: B
Explanation:
Explanation
Yes, it is very much possible to use measures in the same view multiple times. For example, refer to the image below:
We are using BOTH the Sum of the revenue and the of the revenue in the same view!
NEW QUESTION 71
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. September
- C. June
- D. October
Answer: D
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 72
How can you format an axis as Bold in Tableau?
- A. By choosing the axis and selecting Command/Control + B on your keyboard
- B. By right clicking on the axis, choosing Edit Axis, and then setting its font to bold.
- C. By right clicking on the axis, choosing format, and then setting its font to bold.
- D. By clicking on Format on the main menu bar, choosing field labels, and setting it to bold.
Answer: C
Explanation:
Explanation
To make an axis bold, simply right click it, select format, and then click on Font to choose Bold:
None of the other options are valid ways to make the axis bold.
Read more about editing axis: https://help.tableau.com/current/pro/desktop/en-us/formatting_editaxes.htm
NEW QUESTION 73
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 74
......
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.
Latest 100% Passing Guarantee - Brilliant Desktop-Specialist Exam Questions PDF: https://www.pass4surecert.com/Tableau/Desktop-Specialist-practice-exam-dumps.html
Desktop-Specialist Certification – Valid Exam Dumps Questions Study Guide: https://drive.google.com/open?id=1r-mK_RxFlwifV_AhntTct6FLxdCWiIQc