[Jan-2022] TDS-C01 Exam Dumps, TDS-C01 Practice Test Questions
Attested TDS-C01 Dumps PDF Resource [2022]
NEW QUESTION 51
Using 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?
- A. 1,461
- B. 111,060
- C. 1,222
- D. 112,256
Answer: D
Explanation:
Explanation
If 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, October
NEW QUESTION 52
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. Wildcard Search
- B. Pattern Search
- C. Union Search
- D. Regex Search
Answer: A
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 53
Larger image
What is this entire view referred to as in Tableau?
- A. Analytics Pane
- B. Summary Pane
- C. Data pane
- D. Distribution Pane
Answer: A
Explanation:
Explanation
Distribution Pane
Explanation
This is the Analytics pane! Read more from the official documentation below:
NEW QUESTION 54
True or False: Tableau can create worksheet-specific filters
- A. True
- B. False
Answer: A
Explanation:
Explanation
Yes, it is possible to create worksheet-specific filters in Tableau.
When you add a filter to a worksheet, by default it applies to the current worksheet. Sometimes, however, you might want to apply the filter to other worksheets in the workbook.
Then, you can select specific worksheets to apply the filter to or apply it globally to all worksheets that use the same data source or related data sources.
NEW QUESTION 55
Which one of the following is a dimension?
- A. Latitude
- B. Longitude
- C. Measure Names
- D. Number of records
Answer: C
Explanation:
Explanation
Measure Names is a dimension. Latitude, Longitude, and Number of records are all measures.
NEW QUESTION 56
When is an axis created for the visualisation in Tableau?
- A. When we drag a continuous field to the row/column shelf
- B. When we drag a discrete field to the row/column shelf
- C. When we drag a measure to the row/column shelf
- D. When we drag a dimension to the row/column shelf
Answer: A
Explanation:
Explanation
An Individual Axis in Tableau is obtained by adding a continuous into Rows or Columns Shelf.
Example:
In order to show Individual Axis in Tableau First, we drag and drop the Color from Dimension shelf to Column Shelf. Next, we drag and drop the Sales Amount from measures shelf to Rows Shelf. Since it is a continuous value, the Sales Amount will be aggregated to default Sum. Once you drag them, following Chart report will be generated.
Next, we drag and Drop one more measure value, i.e., Total Product Cost from Measures Region to Rows Shelf. Because it is a Measure value, Total Product Cost is aggregated to default Sum. From the below screenshot, you can observe that Tableau has created an individual axis for each measure (continuous field).
NEW QUESTION 57
Which of the following 2 columns CANNOT be deleted in Tableau?
- A. Measure Values
- B. Measure Names
- C. Number of Records
- D. Calculated Fields
Answer: A,B
Explanation:
Explanation
Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated.
Calculated Fields, and Number of records can both be deleted.
NEW QUESTION 58
Which Sub-Category had the least Profit in the Office Supplies category?
- A. Binders
- B. Labels
- C. Envelopes
- D. Fasteners
Answer: D
Explanation:
Explanation
To reach the correct answer, follow the steps below:
1) Drag Category, and sub-category to the row shelf. Drag Profit to the Column shelf
2) Click the Sort-ascending icon as shown above, to sort the profits from least to greatest as shown:
Click the 'Show mark labels icon'
As we can see, Fasteners has the least Profit in the Office Supplies Category, and hence is our correct answer!
NEW QUESTION 59
Yes or No: The number of marks will increase when you increase the number of Dimensions in a view
- A. Yes
- B. No
Answer: A
Explanation:
Explanation
Of 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 60
__________ is a technique in Tableau which will identify marks with similar characteristics
- A. Sets
- B. Clustering
- C. Union
- D. Grouping
Answer: B
Explanation:
Explanation
Cluster analysis partitions marks in the view into clusters, where the marks within each cluster are more similar to one another than they are to marks in other clusters.
NEW QUESTION 61
Using 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?
- A. (Correct)
- B. $33,768
- C. $48,115
- D. $16,581
- E. $147,950
Answer: D
Explanation:
Explanation
Phew! 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 62
True or False: Sets can be created on Measures
- A. True
- B. False
Answer: B
Explanation:
Explanation
Sets 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 63
How can you format an axis as Bold in Tableau?
- A. By right clicking on the axis, choosing format, and then setting its font to bold.
- B. By choosing the axis and selecting Command/Control + B on your keyboard
- C. By right clicking on the axis, choosing Edit Axis, 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: A
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 64
Which of the following can you add a reference line to?
- A. Dimensions
- B. Calculated Fields
- C. Measures
- D. Groups
Answer: B,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 65
Which of the following are valid ways to copy a worksheet visualisation as an image?
- A. Using the Marks shelf and choosing Copy->Image
- B. By simply clicking Control + V on the keyboard
- C. By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy->Image
- D. By right clicking on the worksheet visualisation and selecting Copy->Image
Answer: C,D
Explanation:
Explanation
The following are 2 correct ways to copy the worksheet visualisation as an image:
AND
NEW QUESTION 66
When 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?
- A. Data source Filter
- B. None of the these
- C. Context Filter
- D. Extract Filter
Answer: C
Explanation:
Explanation
IMPORTANT QUESTION, PAY ATTENTION
By 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 67
Which of the following is a good reason for using a bullet graph?
- A. Comparing the actual sales against the target sales
- B. Forecasting future sales
- C. Analysing the trend over a given time period
- D. Displaying the year-on-year growth in sales
Answer: A
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 68
How do you identify a continuous field in Tableau?
- A. It is preceded by a 'Abc' symbol in the data window
- B. It is identified by a blue pill in the visualization
- C. It is identified by a green pill in a visualization
- D. It is preceded by a '=#' symbol in the data window
Answer: D
Explanation:
Explanation
When 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.
NEW QUESTION 69
How can you MANUALLY assign geographic roles to a dimension from the data pane?
- A. Right click it -> Geographic role -> and then assign the appropriate geographic role
- B. Edit the config file in My Documents -> MyTableauRepository for a quick fix
- C. Right click it -> Edit Default properties -> Assign geographic roles
- D. Edit the data source manually for a quick resolution
Answer: A
Explanation:
Explanation
From the data pane, simply right click on the dimension, choose geographic role, and then select the appropriate role as follows:
NEW QUESTION 70
Which of the following are the options to export the data used to build the view / visualisations?
- A. JSON format
- B. MS Access Database
- C. CSV file
- D. PDF File
Answer: B
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 71
......
Latest TDS-C01 Actual Free Exam Questions Updated 150 Questions: https://freetorrent.itpass4sure.com/TDS-C01-practice-exam.html
