This page was exported from Actual Test Materials [ http://blog.actualtests4sure.com ] Export date:Fri Nov 15 20:17:53 2024 / +0000 GMT ___________________________________________________ Title: (2022) TDS-C01 Dumps and Practice Test (150 Questions) [Q51-Q73] --------------------------------------------------- (2022) TDS-C01 Dumps and Practice Test (150 Questions) Guide (New 2022) Actual Tableau TDS-C01 Exam Questions NEW QUESTION 51The View Data window displays as much of the data as possible by default, up to _______________ rows.  20,000  5,000  10,000  15,000 ExplanationThe 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.htmNEW QUESTION 52To use a quick table calculation, which of the following programming languages do you need to know?  ython  Java  Javascript  None of these ExplanationYou 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 calculation1) 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.NEW QUESTION 53Using 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?  $16,581  (Correct)  $147,950  $48,115  $33,768 ExplanationPhew! 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 54Which 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.NEW QUESTION 55Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us  1 , 4  2 , 2  2 , 3  1 , 2 ExplanationTableau auto-generates :1 Dimension – Measure Names4 Measures – Latitude, Longitude, Number of records, Measure ValuesStarting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)NEW QUESTION 56Which of the following returns the Absolute Value of a given number?  ABS(Number)  CEILING(Number)  FLOOR(Number)  ZN(Number) ExplanationFrom the official Tableau website:NEW QUESTION 57When 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.  Regex Search  Union Search  Pattern Search  Wildcard Search ExplanationYou 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 58________________ 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 59Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into_______________________  Dimensions and Measures  Rows and Columns  Labels and Values  Numbers and Headers ExplanationWhen 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.Further,NEW QUESTION 60______________ refers to the level of detail for a piece of data, wherever you are looking.  Data Cleanliness  Data granularity  Data connectivity  Data LOD ExplanationData is generated and analyzed at many different levels of granularity. Granularity is the level of detail of the data. For example, when looking at graduation data, granularity would describe whether a row in the data set represents a single person or the graduating class of a university.NEW QUESTION 61Which of the following calculations DO NOT need a quick table calculation?  Variance  Rank  Moving Average  Standard Deviation ExplanationFor Standard Deviation and Variance, we don’t need to use quick table calculations, since they are available by default. See below:However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average belong to only this category.NEW QUESTION 62Dragging 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 63Which of the following are valid ways of Grouping Data?  Using Marks in the view  Using Labels in the View  From the Analytics Pane  From the Dimensions Shelf Explanation**IMPORTANT QUESTION AND EXPLANATION, PLEASE READ**3 ways to group data –1) Marks2) Labels3) Dimensions shelf.*IMPORTANT*If we Group the data by selecting the marks, then they remain separate marks in the view and then have the same colour. Also, a new group is created in the Dimensions shelf. Example – Using the sample superstore dataset, first plot a bar chart showing sales for each sub-category:Here, if we Select Phones, Chairs and Storage by selecting the MARKS (Bars), and then group them:They remain seperate marks (BARS) but are grouped by the same colour.Now, if we didn’t do this, and rather grouped by selecting their Labels (Names):Then they no longer remain separate Marks (bars) but are rather consolidated into a single Bar:Finally, we can group directly from the Dimensions shelf as follows:Now choose Phones, Chairs and Storage and Click Group:You will now automatically have a new Dimension as follows:NEW QUESTION 64True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table  True  False ExplanationThis 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.NEW QUESTION 65Dates in Tableau are typically treated as ______________  Dimensions  Measures ExplanationFor 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.NEW QUESTION 66By definition, Tableau displays measures over time as a ____________  Packed Bubble  Bar  Stacked Bar  Line ExplanationLine charts connect individual data points in a view. They provide a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values.Please refer to the images below:NEW QUESTION 67Larger 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 68True or False: Sets can be created on Measures  True  False ExplanationSets are custom fields that are created within Tableau Desktop based on dimensions from your data source.They are subsets of your data, which can be created manually or computed. Either dimensions or measures can be used to determine what is included or excluded from a set using conditional logic, but to CREATE a set we use dimensions.Reference : https://interworks.com/blog/rcurtis/2016/10/26/tableau-deep-dive-sets-introduction-sets/NEW QUESTION 69For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.  Random  Manual  Topological  Hierarchical ExplanationFor a manual sort, no matter how the data changes, the values will always stay in the sort order you kept stuff in.From the official website:NEW QUESTION 70You want to add Custom shapes to your visualisation. Where can you add these new shapes?  In Downloads -> My Tableau Repository -> Shapes  In My Computer -> C: -> Tableau -> Shapes  In Program Files -> Tableau -> Shapes  In My Documents -> My Tableau Repository -> Shapes ExplanationHere’s how to add image files to your repository:1) Find image file on the internet. I try to find consistent image formats if I plan to use a set of shapes such as logos or flags.2) Download the image to your computer.3) Drag images into your My Documents -> My Tableau repository -> Shapes folder.4) Open Tableau and your new shapes will automatically be included in your “edit shapes” menu.NEW QUESTION 71True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity  True  False ExplanationWhenever you add a measure to your view, an aggregation is applied to that measure by default. This default is controlled by the Aggregate Measures setting in the Analysis menu.If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can disaggregate the view. Disaggregating your data means that Tableau will display a separate mark for every data value in every row of your data source.To disaggregate all measures in the view:Clear the Analysis >Aggregate Measures option. If it is already selected, click Aggregate Measures once to deselect it.NEW QUESTION 72Yes or No: The number of marks will increase when you increase the number of Dimensions in a view  No  Yes ExplanationOf course! As an example, see below:1) Using the Sample Superstore data, let’s plot a bar chart showing the Sales for each Category:Observe that we have 3 marks – Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark , and so on for all charts.1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark – a single continous axis, but 3 different marks (Technology, Furniture and Office supplies ) on the x-axis.2) Now let’s add subcategory to the view as well (another dimension):Observe that the number of marks has increased – i.e the number of Bars.Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)NEW QUESTION 73Download the Dataset from:https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?  September 2017  March 2018  December 2017  January 2018 ExplanationFollow the steps to get the correct answer : January 2018* We are talking about dates, so use the Time series sheet as follows:* Next, the following should be your view and clearly, January 2018 is the lowest point:Read more about dates:https://interworks.com/blog/rcurtis/2017/01/30/tableau-deep-dive-dates-introduction-dates/ Loading … TDS-C01 Exam Dumps Pass with Updated 2022 Certified Exam Questions: https://www.actualtests4sure.com/TDS-C01-test-questions.html --------------------------------------------------- Images: https://blog.actualtests4sure.com/wp-content/plugins/watu/loading.gif https://blog.actualtests4sure.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2022-04-14 10:27:27 Post date GMT: 2022-04-14 10:27:27 Post modified date: 2022-04-14 10:27:27 Post modified date GMT: 2022-04-14 10:27:27