Tableau-Desktop-Specialist Dumps Tableau-Desktop-Specialist Braindumps Tableau-Desktop-Specialist Real Questions Tableau-Desktop-Specialist Practice Test Tableau-Desktop-Specialist Actual Questions Tableau Tableau-Desktop-Specialist Tableau Desktop Specialist https://killexams.com/pass4sure/exam-detail/Tableau-Desktop-Specialist Question: 90 In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________. A. top left bottom left B. top right, bottom right C. top left, bottom right D. top right, bottom left Answer: D Explanation: Tree maps size begins from maximum in top left to smallest in bottom right. See below to learn how to create a TreeMap and add colours to it: Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_treemap.htm Question: 91 When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively? A. Red, Blue B. Orange, Blue C. Blue, Red D. Blue, Orange Answer: D Explanation: When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark. See below: Reference: https://www.tutorialspoint.com/tableau/tableau_data_blending.htm Question: 92 Dates in Tableau are typically treated as ______________ A. Dimensions B. Measures Answer: A Explanation: For relational data sources, dates and times are automatically placed in the Dimensions area of the Data pane and are identified by the date or date-time icon. For example, the Order Date and Ship Date dimensions from an Excel data source are shown below: When you place a relational date on a shelf, the field name is automatically modified to reflect the default date level. Tableau defines the default date level to be the level at which there are multiple instances. For example, if the date field includes multiple years, the default level is year. However, if the date field contains data for just one year but includes multiple months, then the default level is month. Reference: https://help.tableau.com/current/pro/desktop/en-us/dates.htm Question: 93 True or False: It is possible to change the Geographic Role of a dimension A. True B. False Answer: A Explanation: Explanation A geographic role associates each value in a field with a latitude and longitude value. Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map view. For example, you can assign the City geographic role to a field that contains a list of city names. To assign a geographic role to a field: In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field. When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane: Latitude (generated) and Longitude (generated). These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles. If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map. Reference: https://help.tableau.com/current/pro/desktop/en-us/maps_geographicroles.htm Question: 94 To use a quick table calculation, which of the following programming languages do you need to know? A. ython B. Java C. Javascript D. None of these Answer: D Explanation: You don’t need to know ANY programming language to use quick table calculations! Follow along with the steps below to learn how to apply a quick table calculation to a visualization: 1) Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau. 2) Navigate to a new worksheet. 3) From the Data pane, under Dimensions, drag Order Date to the Columns shelf. 4) From the Data pane, under Dimensions, drag State to the Rows shelf. 5) From the Data pane, under Measures, drag Sales to Text on the Marks Card. 6) From the Data pane, under Measures, drag Profit to Color on the Marks Card. 7) On the Marks card, click the Mark Type drop-down and select Square. The visualization updates to look like this: Apply the quick table calculation 1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average. Note: You can only perform quick table calculations on measures in the view. A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving average of profit across the years. Reference: https://help.tableau.com/current/pro/desktop/enus/calculations_tablecalculations_quick.htm Question: 95 How would you calculate GDP per capita in Tableau? A. SUM([GDP]/[POPULATION]) B. SUM([Population]/[GDP]]) C. SUM([GDP]*[POPULATION]) D. SUM([GDP]) / SUM([Population]) Answer: D Explanation: GDP / Population = GDP Per Capita Here Sum is a function, / and + are operators. On the bottom there are comments. Question: 96 Which of the following are the options to export the data used to build the view / visualisations? A. CSV file B. PDF File C. JSON format D. MS Access Database Answer: D 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. Reference: https://help.tableau.com/current/pro/desktop/en-us/save_export_data.htm Question: 97 True or False: The Highlighting action can be disabled for the entire workbook. A. True B. False Answer: A Explanation: Yes, it is possible to disable highlighting for the entire workbook. For more information: https://help.tableau.com/current/pro/desktop/engb/actions_highlight.htm Question: 98 Using 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? A. 28.415% B. 23.497% C. 25.683% D. 22.404% Answer: D Explanation: Phew! 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 Institution 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: Question: 99 Which of the following are benefits of using Data Extracts in Tableau? A. Improved Performance B. Ability to use the data offline C. Working with freshest data at all times D. Faster to work with 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! Reference: https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm Question: 100 True or False: A reference line cannot be added from the Analytics Pane A. True B. False Answer: B Explanation: You can add a reference line to any continuous axis in the view. To add a reference line: Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item and the current view. In a simple case, the drop target area offers three options: Reference: https://help.tableau.com/current/pro/desktop/en-us/reference_lines.htm 6$03/( 48(67,216 7KHVH TXHVWLRQV DUH IRU GHPR SXUSRVH RQO\ )XOO YHUVLRQ LV XS WR GDWH DQG FRQWDLQV DFWXDO TXHVWLRQV DQG DQVZHUV .LOOH[DPV FRP LV DQ RQOLQH SODWIRUP WKDW RIIHUV D ZLGH UDQJH RI VHUYLFHV UHODWHG WR FHUWLILFDWLRQ H[DP SUHSDUDWLRQ 7KH SODWIRUP SURYLGHV DFWXDO TXHVWLRQV H[DP GXPSV DQG SUDFWLFH WHVWV WR KHOS LQGLYLGXDOV SUHSDUH IRU YDULRXV FHUWLILFDWLRQ H[DPV ZLWK FRQILGHQFH +HUH DUH VRPH NH\ IHDWXUHV DQG VHUYLFHV RIIHUHG E\ .LOOH[DPV FRP $FWXDO ([DP 4XHVWLRQV .LOOH[DPV FRP SURYLGHV DFWXDO H[DP TXHVWLRQV WKDW DUH H[SHULHQFHG LQ WHVW FHQWHUV 7KHVH TXHVWLRQV DUH XSGDWHG UHJXODUO\ WR HQVXUH WKH\ DUH XS WR GDWH DQG UHOHYDQW WR WKH ODWHVW H[DP V\OODEXV %\ VWXG\LQJ WKHVH DFWXDO TXHVWLRQV FDQGLGDWHV FDQ IDPLOLDUL]H WKHPVHOYHV ZLWK WKH FRQWHQW DQG IRUPDW RI WKH UHDO H[DP ([DP 'XPSV .LOOH[DPV FRP RIIHUV H[DP GXPSV LQ 3') IRUPDW 7KHVH GXPSV FRQWDLQ D FRPSUHKHQVLYH FROOHFWLRQ RI TXHVWLRQV DQG DQVZHUV WKDW FRYHU WKH H[DP WRSLFV %\ XVLQJ WKHVH GXPSV FDQGLGDWHV FDQ HQKDQFH WKHLU NQRZOHGJH DQG LPSURYH WKHLU FKDQFHV RI VXFFHVV LQ WKH FHUWLILFDWLRQ H[DP 3UDFWLFH 7HVWV .LOOH[DPV FRP SURYLGHV SUDFWLFH WHVWV WKURXJK WKHLU GHVNWRS 9&( H[DP VLPXODWRU DQG RQOLQH WHVW HQJLQH 7KHVH SUDFWLFH WHVWV VLPXODWH WKH UHDO H[DP HQYLURQPHQW DQG KHOS FDQGLGDWHV DVVHVV WKHLU UHDGLQHVV IRU WKH DFWXDO H[DP 7KH SUDFWLFH WHVWV FRYHU D ZLGH UDQJH RI TXHVWLRQV DQG HQDEOH FDQGLGDWHV WR LGHQWLI\ WKHLU VWUHQJWKV DQG ZHDNQHVVHV *XDUDQWHHG 6XFFHVV .LOOH[DPV FRP RIIHUV D VXFFHVV JXDUDQWHH ZLWK WKHLU H[DP GXPSV 7KH\ FODLP WKDW E\ XVLQJ WKHLU PDWHULDOV FDQGLGDWHV ZLOO SDVV WKHLU H[DPV RQ WKH ILUVW DWWHPSW RU WKH\ ZLOO UHIXQG WKH SXUFKDVH SULFH 7KLV JXDUDQWHH SURYLGHV DVVXUDQFH DQG FRQILGHQFH WR LQGLYLGXDOV SUHSDULQJ IRU FHUWLILFDWLRQ H[DPV 8SGDWHG &RQWHQW .LOOH[DPV FRP UHJXODUO\ XSGDWHV LWV TXHVWLRQ EDQN DQG H[DP GXPSV WR HQVXUH WKDW WKH\ DUH FXUUHQW DQG UHIOHFW WKH ODWHVW FKDQJHV LQ WKH H[DP V\OODEXV 7KLV KHOSV FDQGLGDWHV VWD\ XS WR GDWH ZLWK WKH H[DP FRQWHQW DQG LQFUHDVHV WKHLU FKDQFHV RI VXFFHVV 7HFKQLFDO 6XSSRUW .LOOH[DPV FRP SURYLGHV IUHH [ WHFKQLFDO VXSSRUW WR DVVLVW FDQGLGDWHV ZLWK DQ\ TXHULHV RU LVVXHV WKH\ PD\ HQFRXQWHU ZKLOH XVLQJ WKHLU VHUYLFHV 7KHLU FHUWLILHG H[SHUWV DUH DYDLODEOH WR SURYLGH JXLGDQFH DQG KHOS FDQGLGDWHV WKURXJKRXW WKHLU H[DP SUHSDUDWLRQ MRXUQH\ 'PS .PSF FYBNT WJTJU IUUQT LJMMFYBNT DPN WFOEPST FYBN MJTU .LOO \RXU H[DP DW )LUVW $WWHPSW *XDUDQWHHG