TDS-C01 Dumps TDS-C01 Braindumps TDS-C01 Real Questions TDS-C01 Practice Test TDS-C01 Actual Questions Tableau TDS-C01 Tableau Desktop Specialist https://killexams.com/pass4sure/exam-detail/TDS-C01 Question: 51 Which of the following would you use to connect to multiple tables in a single data source at once? A. A Blend B. A Hierarchy C. A Set D. A Join Answer: D Explanation: The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data. For example, consider the following two tables originating from a single data source: We can combine these 2 tables, simply by joining the tables on ID to answer questions like, "How much was paid in royalties for authors from a given publisher?". By combining tables using a join, you can view and use related data from different tables in your analysis. Reference: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm Question: 52 True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table A. True B. False Answer: A Explanation: Explanation This is true, indeed! The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match. Reference: https://www.w3schools.com/sql/sql_join_left.asp Question: 53 You can use the __________________ in Tableau to clean / organise your data. A. Data cleaner B. Data manager C. Data interpreter D. Data organiser Answer: C 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. Reference: https://help.tableau.com/current/pro/desktop/en-us/data_interpreter.htm Question: 54 _____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. A. Tableau Packaged Workbook (.twbx) B. Tableau Workbook (.twb) C. Tableau Data Extract (.tde) D. Tableau Data Source (.tds) Answer: C 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. Question: 55 According to Tableau’s ‘Order of Operations’, which of the following filters is applied FIRST? A. Dimension Filter B. Measure Filter C. Context Filter D. Extract Filter Answer: D 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: Reference: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm Question: 56 When using Animations in a Tableau, which of the following is the default duration for animations? A. 0.4s B. 0.3s C. 0.5s D. 0.2s Answer: B Explanation: The 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’ Reference: https://help.tableau.com/current/pro/desktop/en-us/formatting_animations.htm Question: 57 Which of the following is a benefit of using a Tableau Data Source (.tds)? A. To hold one or more worksheets, plus zero or more dashboards and stories. B. To 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 etc C. To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don’t have access to the original data. D. To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance. Answer: B Explanation: The following are the official definitions from the Tableau documentation for the various file types: 1). tds (Tableau Data Source) – To 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 etc. (CORRECT ANSWER) 2). twbx (Tableau packaged workbook) – To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don’t have access to the original data. 3) Extract (. hyper or .tde) C To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance. 3) (.twb) Workbooks C To hold one or more worksheets, plus zero or more dashboards and stories. Reference: https://help.tableau.com/current/pro/desktop/en-us/environ_filesandfolders.htm Question: 58 Larger image What is this entire view referred to as in Tableau? A. Data pane B. Analytics Pane C. Summary Pane D. Distribution Pane Answer: B Explanation: Distribution Pane This is the Analytics pane! Read more from the official documentation below: Reference: https://help.tableau.com/current/pro/desktop/enus/environ_workspace_analytics_pane.htm Question: 59 True or False: Bins can be created on dimensions A. False B. rue Answer: B Explanation: Explanation Bin are a user-defined grouping of numerical data in the data source. According to the official Tableau documentation: It’s sometimes useful to convert a continuous measure (or a numeric dimension) into bins. Have a look at the following image. When we right click a measure, we get the following options: However, for a dimension (this is because the DATA TYPE of this dimension is a string: But what if we have a dimension of type NUMBER (NUMERIC DIMENSION)? See below: We can clearly create bins from dimensions too – they just have to be numeric For more information, please refer to: https://help.tableau.com/current/pro/desktop/enus/calculations_bins.htm 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.000 B. 3.840 C. 3.704 D. 3.500 Answer: C 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 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