This page was exported from Free valid test braindumps [ http://free.validbraindumps.com ] Export date:Sat Apr 5 13:11:44 2025 / +0000 GMT ___________________________________________________ Title: Desktop-Specialist Pre-Exam Practice Tests (Updated 150 Questions) [Q80-Q101] --------------------------------------------------- Desktop-Specialist Pre-Exam Practice Tests | (Updated 150 Questions) Valid Desktop-Specialist Exam Q&A PDF - One Year Free Update NEW QUESTION 80When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?  Monitor, Default, Phone, Tablet  Phone, Tablet, Laptop, Desktop  Default, Phone, Tablet, Desktop  Phone, Monitor, Laptop, Default ExplanationThe following options are available in the Device preview section when creating a Dashboard:NEW QUESTION 81Which of the following is not a Trend Line Model?  Linear Trend Line  Exponential Trend Line  binomial Trend Line  Logarithmic Trend Line ExplanationAccording to the official Tableau documentation, there are 5 types of trend lines which we can work with in Tableau :1) Linear Trend Line2) Logarithmic Trend Line3) Exponential Trend Line4) Polynomial Trend Line5) Power ModelHence, 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.htmNEW QUESTION 82Which one of the following is a dimension?  Longitude  Measure Names  Number of records  Latitude ExplanationMeasure Names is a dimension. Latitude, Longitude, and Number of records are all measures.NEW QUESTION 83Larger imageWhat is this view referred to as in Tableau?  Analytics Pane  Window Pane  Data Pane  Dimensions & Measures ExplanationTableau displays data source connections and data fields for the workbook in the Data pane on the left side of the workspace.The Data pane includes:Dimension fields – Fields that contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view. Examples of dimensions include dates, customer names, and customer segments.Measure fields – Fields that contain numeric, quantitative values can be measured. You can apply calculations to them and aggregate them. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default). Examples of measures: sales, profit, number of employees, temperature, frequency.For more information on what dimensions and measures are, see Dimensions and Measures, Blue and Green.Calculated fields – If your underlying data doesn’t include all of the fields you need to answer your questions, you can create new fields in Tableau using calculations and then save them as part of your data source. These fields are called calculated fields.For more information on calculated fields, see Create Custom Fields with Calculations.Sets – Subsets of data that you define. Sets are custom fields based on existing dimensions and criteria that you specify. For more information, see Create Sets.Named sets from an MS Analysis Services server or from a Teradata OLAP connector also appear in Tableau in this area of the Data pane. You can interact with these named sets in the same way you interact with other custom sets in Tableau.Parameters – Values that can be used as placeholders in formulas, or replace constant values in calculated fields and filters. For more information, see Create Parameters.NEW QUESTION 84Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?  28.415%  23.497%  25.683%  22.404% ExplanationPhew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We’ll be using filters, as well as quick table calculations (percent of total) for this one.1) Firstly, let’s drag Country and to the Rows shelf, and year (discrete) to the Columns shelf.Then, drag Publications to the Text Icon in the Marks Shelf. The following is our view:NEW QUESTION 85________________ is hosted by Tableau to share our visualisations publically with the world.  Tableau Reader  Tableau Desktop  Tableau Server  Tableau Public ExplanationTableau Public is a free service that lets anyone publish interactive data visualizations to the web.Visualizations that have been published to Tableau Public (“vizzes”) can be embedded into web pages and blogs, they can be shared via social media or email, and they can be made available for download to other users.Check it out : https://public.tableau.com/en-us/s/NEW QUESTION 86Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?  Yes  No ExplanationThis is a tricky question. We are talking about story POINTS, and not entire stories in the question.To create a story, lets say I have a blank story with 1 dashboard and 1 worksheet.I can simply drag the dashboard into the view to create a new story point.Now, if I try to adjust the worksheet beside it in this same view, I cannot. See below:The only option available is to replace the existing view. Therefore, the answer is NO since they both cannot be added.Read more about stories in Tableau: https://help.tableau.com/current/pro/desktop/en-us/story_create.htmNEW QUESTION 87Dragging a ______________ to colour creates distinct colours for each item whereas dragging a______________ to colour creates a gradient  Discrete value, Continuous Value  Geographic Value, Discrete Value  Continuous Value, Discrete Value  Longitude, Latitude ExplanationRemember 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 88________________ 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.  .tbm  .tds  .tde  .twb ExplanationAccording 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 89For a relative date filter, the default anchor is _________________  The current time  Today’s date  The target date  The date we specify ExplanationRelative 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 shelfRight-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 unitIn 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 TODAYNEW QUESTION 90Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?  592,593  293,202  416,702  336,908 ExplanationSince you need BOTH State and the YEAR, we need to use an Inner Join.Follow the steps below:NEW QUESTION 91Using 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?  111,060  1,461  112,256  1,222 ExplanationIf 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, OctoberNEW QUESTION 92You can create _______________ for members in a dimension so that their labels appear differently in the view.  parameters  duplicates  copies  aliases ExplanationYou 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 93What does the following icon do in Tableau?Larger image  Create a Story  Create a Story and Dashboard both  Create a Worksheet  Create a Dashboard ExplanationThe icon shown is used to add a new Dashboard! From the official documentation:NEW QUESTION 94When using Animations in a Tableau, which of the following is the default duration for animations?  0.4s  0.3s  0.5s  0.2s ExplanationThe LATEST Tableau Desktop Sepcialist exam blueprint now requires you to know some basics about animations as well!NOTE: Animations are DISABLED by default and must be manually enabled.You can also reset all settings to default by clickin on ‘Reset All’NEW QUESTION 95How would you calculate GDP per capita in Tableau?  SUM([GDP]/[POPULATION])  SUM([Population]/[GDP]])  SUM([GDP]*[POPULATION])  SUM([GDP]) / SUM([Population]) ExplanationGDP / Population = GDP Per CapitaHere Sum is a function, / and + are operators. On the bottom there are comments.NEW QUESTION 96Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?  To support additional functionality such as count distinct  Fast to create  Help improve performance  To have access to the freshest possible data at all times ExplanationFrom the official documentation, the following are the major advantages of using Tableau Data Extracts:From Tableau 2020.2 onwards, .hyper is the recommended way since it is faster than .tde!NEW QUESTION 97When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?  Data source Filter  Extract Filter  Context Filter  None of the these ExplanationIMPORTANT QUESTION, PAY ATTENTIONBy default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter. Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.You may create a context filter to:1) Improve performance – If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.2) Create a dependent numerical or top N filter – You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.NEW QUESTION 98For creating variable sized bins we use __________________  Calculated Fields  Table Calculations  Sets  Groups ExplanationOne 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 sizeStep 1Select Analysis > Create Calculated Field.Step 2In the Calculated Field dialog box, complete the following steps:NEW QUESTION 99Which of the following is the correct way to calculate Profit Ratio in Tableau?  Profit / Sales  Sales / Profit  SUM(Profit) / SUM(Sales)  SUM(Sales)/SUM(Profit) ExplanationTHIS IS A VERY IMPORTANT QUESTIONAggregation 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 100Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?  9  7  10  8 ExplanationFollow along to reach the correct answer:1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:Click on Date in the Column shelf and convert it to continuous month :2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:3) Finally, click on the Show mark Labels icon:4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:NEW QUESTION 101Which of the following chart type makes use of ‘binned’ data?  Gantt Chart  Bullet chart  Histogram  Treemaps ExplanationA 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. Loading … Tableau Desktop Specialist Exam Free Update Certification Sample Questions: https://www.validbraindumps.com/Desktop-Specialist-exam-prep.html --------------------------------------------------- Images: https://free.validbraindumps.com/wp-content/plugins/watu/loading.gif https://free.validbraindumps.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2023-01-23 13:40:24 Post date GMT: 2023-01-23 13:40:24 Post modified date: 2023-01-23 13:40:24 Post modified date GMT: 2023-01-23 13:40:24