Pass Tableau TDA-C01 Exam With Practice Test Questions Dumps Bundle
2024 Valid TDA-C01 test answers & Tableau Exam PDF
NEW QUESTION # 15
You have a dashboard that is configured for desktop browsers.
You want to customize a layout for mobile users.
Which option should you select first? (Click the appropriate Option in the Answer Area.)
Answer:
Explanation:
Explanation:
To customize a layout for mobile users, you should select the Device Preview option first. This option will allow you to see how your dashboard will look on different types of devices, such as phones, tablets, or desktops. You can also choose different models and orientations to preview different screen sizes and resolutions. From the Device Preview mode, you can add, edit, or delete device layouts for each device type.
You can also adjust the size, position, and formatting of the dashboard elements for each device layout. References:
Create Dashboard Layouts for Different Device Types - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 16
You have the following tiled dashboard that has one sheet.
You want to replace fit sheet with Sheet2.
What should you do?
- A. From the context menu of Sheet3. select Deselect
- B. Drag Sheet2 to the dashboard.
- C. Right-click Sheet2 and select Add to Dashboard.
- D. From the context menu of Sheet3. select Remove Dashboard item
- E. Select Sheets and click the Swap Sheet button next to Sheet2.
Answer: E
Explanation:
To replace a sheet on a tiled dashboard, you can simply drag the new sheet from the Sheets pane to the dashboard and drop it over the existing sheet. This will replace the old sheet with the new one and keep the same size and position. Alternatively, you can right-click on the old sheet and select Replace Data Source, then choose the new sheet from the list. Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards_organize_floating_layoutcontainers.htm https://help.tableau.com/current/pro/desktop/en-us/dashboards_replace_datasource.htm
NEW QUESTION # 17
Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.
- A. check the steps below in explanation
Answer: A
Explanation:
To create a histogram on the Quantity field by using bin size of 3, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
Click on the Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.
Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.
Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.
Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a # sign next to it.
Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.
Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.
NEW QUESTION # 18
You conned to a Microsoft SQL Server database
You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
Answer:
Explanation:
Explanation:
Select
Where
The correct way to complete the query is:
SELECT * FROM [dbo] . [Students]
WHERE [Students].[City] = 'Berlin'
The SELECT statement is used to retrieve data from a table or a view. The * symbol means that all columns will be returned. The FROM clause specifies the table or view name and the schema name.
The WHERE clause is used to filter the data based on a condition. The condition is [Students].[City] =
'Berlin', which means that only rows where the City column of the Students table is equal to 'Berlin' will be returned.
The other options are not relevant for this query. CAST is a function that converts a value from one data type to another. JOIN is a clause that combines data from two or more tables based on a common field. ON is a keyword that specifies the join condition. UNION is a set operation that combines the results of two or more queries into one result set.
References: https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/queries/where-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver15#join
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-union-transact-sql?view=sql-server-v
NEW QUESTION # 19
Open the link to Book1 found on the desktop. Open the Line worksheet.
Modify the chart to show only main and max values of both measures in each region.
Answer:
Explanation:
To modify the chart to show only min and max values of both measures in each region, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Line worksheet.
Click on the Line tab at the bottom of the workbook to open the worksheet. You will see a line chart that shows the sales and profit for each month by region.
Drag Month from the Columns shelf to Filters shelf. This will open a dialog box that allows you to filter by different criteria.
Select Range of Dates from the dialog box. This will show you options to filter by a range of dates or values.
Select Minimum and Maximum from the drop-down list next to Month. This will filter by the minimum and maximum values of Month for each region. You can also enter specific values or use the sliders to adjust the range.
Click OK to apply the filter. You will see that the line chart now shows only min and max values of both measures in each region.
NEW QUESTION # 20
A colleague provides you with access to a folder that contains the following files:
* Sates.csv
* Bookl.twb
* Sates.hyper
* Export.mdb
Which He contains an extract?
- A. Sales.hyper
- B. Book1.twb
- C. Export mdb
- D. Sales.csv
Answer: A
Explanation:
A .hyper file is an extract file that contains a snapshot of data from a data source. It is a compressed and optimized file format that can be used to improve the performance and portability of dashboards and workbooks. A .twb file is a workbook file that contains the visualization and connection information, but not the data itself. A .csv file is a comma-separated values file that contains plain text data. A .mdb file is a Microsoft Access database file that contains tables, queries, forms, and other objects. References:
https://help.tableau.com/current/pro/desktop/en-us/save_savework_packagedworkbooks.htm
https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm
https://help.tableau.com/current/pro/desktop/en-us/examples_csv.htm
https://support.microsoft.com/en-us/office/introduction-to-access-database-files-9f9a0f8c-9a3c-4a0b-8e6c-6d1f1
In Tableau, a .hyper file is an extract file created by the Hyper database engine.
It contains a snapshot of the data pulled into Tableau and is used to perform data analysis without the need for a live connection to the data source.
NEW QUESTION # 21
You have the following box plot that shows the distribution of average profits made in every state by region.
Which region has the smallest distribution of profits?
- A. Cast
- B. West
- C. South
- D. Central
Answer: D
Explanation:
The central region has the smallest distribution of profits because it has the smallest interquartile range (IQR), which is the distance between the first and third quartiles of the box plot. The IQR measures the spread of the middle 50% of the data. The smaller the IQR, the less variation in the data. Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_boxplot.htm https://www.statisticshowto.com/probability-and-statistics/interquartile-range/
NEW QUESTION # 22
You have the following map.
You need the map to appear as shown in the following visualization.
What should you do?
- A. Change the mark type to Map
- B. Drag Population to Size on the Marks card
- C. Change the mark type to Density
- D. Change the opacity to 75%
- E. Drag Location to Size on the Marks card
Answer: C
NEW QUESTION # 23
You have the following dashboard.
When a user selects a only on the map the data on the bar chart must show only the data for the selected city. The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)
Answer:
Explanation:
NEW QUESTION # 24
You have the following two datasets:
* A Microsoft Excel worksheet that has two columns named Employee Name and Department
* A Microsoft SQL Server table that has three columns named Employee Name. Pay Grade and Team Size.
You want to use Tableau Prep to join the two datasets.
Which three actions should you perform m order? (Place the three correct options in order.)
Answer:
Explanation:
1 - Specify Employee Name as the join key
2 - Open both data sources in Tableau Desktop
3 - Join both datasets and select the join type
NEW QUESTION # 25
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the Top 10 NOC based on the number of medals won.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 26
You have the following dataset.
When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.
What should you do?
- A. Change the data type of the Sates field to Siring
- B. Change the default number format of the Sales told
- C. Create a calculated field that uses a formula of 'S' + stri < (Sales)/1000)).
- D. Create a calculated field that uses a formula of 'S' * str (Round((sales],2)) + 'k'
Answer: B
Explanation:
To make Sales appear automatically as shown in the second table, you should change the default number format of the Sales field. The default number format is how Tableau displays a field when you drag it to a worksheet. You can change the default number format by right-clicking on the field and selecting Default Properties > Number Format from the menu. This will open a dialog box where you can choose a category, such as Currency or Percentage, and customize the options, such as decimal places or prefixes.
In this case, you want to change the default number format of Sales to Currency with zero decimal places and a custom prefix of "S". This will make Sales appear as "S" followed by the rounded value in thousands.
The other options are not correct for this scenario. Changing the data type of Sales to String will not affect how it appears on a worksheet. Creating a calculated field that uses a formula will not change the default number format of Sales, but create a new field that you have to drag to a worksheet. Converting Sales to Attribute will return only one value for each partition of data, which will not show any variation over time. Reference: https://help.tableau.com/current/pro/desktop/en-us/formatting.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_change_default.htm
NEW QUESTION # 27
You have the following tiled dashboard that has one sheet.
You want to replace the sheet with Sheet2.
What should you do?
- A. From the context menu of Sheet3. select Deselect
- B. Select Sheet3 and click the Swap Sheet button next to Sheet2.
- C. Right-click Sheet2 and select Add to Dashboard.
- D. From the context menu of Sheet3. select Remove Dashboard item
- E. Drag Sheet2 to the dashboard.
Answer: E
Explanation:
In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard area where the current sheet (Sheet3) resides. This action will replace the existing sheet with the new one. Right-clicking and adding to the dashboard adds an additional sheet rather than replacing, and the context menu options mentioned in the other choices are not the standard methods for replacing sheets within a dashboard.
NEW QUESTION # 28
You have the following visualization.
You want the count of Returns displayed only for the first year in the table.
How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
NEW QUESTION # 29
You have the following visualization.
Answer:
Explanation:
NEW QUESTION # 30
You have the following dashboard that contains two sheets.
You want to minimize the whitespace between the sheets.
What should you configure?
- A. The size
- B. The background
- C. The position
- D. The padding
- E. The border
Answer: D
Explanation:
To minimize the whitespace between the sheets, you should configure the padding of the sheets and the dashboard. Padding is the amount of space between the edge of a sheet or dashboard and its content. You can adjust the padding by using the Layout tab in the Format pane. You can reduce the padding for each sheet by selecting the sheet and changing the values for the inner and outer padding. You can also reduce the padding for the dashboard by selecting the dashboard and changing the values for the outer padding. Reducing the padding will make the sheets and the dashboard more compact and eliminate unnecessary whitespace. Reference:
Format Dashboards - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 31
You have the Mowing dashboard.
Which two elements are floating? Choose two.
- A. The color legend
- B. The map
- C. The Rate of Obesity chart
- D. The little
- E. The state filter
Answer: B,C
NEW QUESTION # 32
You have a data source that contains the following columns.
You want to sort customers based on the most expensive orders.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
Explanation:
A screenshot of a computer Description automatically generated
NEW QUESTION # 33
From Tableau Desktop you sign in lo a Tableau Server site.
What appears in the list of available data sources when you search for a published data source?
- A. All the data sources published to the site within the folders to which you have access
- B. All the data sources published to the site
- C. All the data sources published to the Tableau Server
- D. All the data sources published to the Tableau Server within the folders to which you have access
Answer: A
Explanation:
When you sign in to a Tableau Server site from Tableau Desktop and search for a published data source, you will see all the data sources published to the site within the folders to which you have access. You will not see data sources published to other sites or folders that you do not have permission to view. You can also filter your search by project, owner, or tag. References:
https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm
https://help.tableau.com/current/pro/desktop/en-us/connect_tableauserver.htm When signed in to Tableau Server from Tableau Desktop, you'll only be able to see the data sources that have been published to the site and are within the folders that you have been granted access to. Tableau's permission and project structure mean that you won't see all data sources from the entire server unless you have permissions to do so.
NEW QUESTION # 34
You have the Mowing dashboard.
Which two elements are floating? Choose two.
- A. The color legend
- B. The Rate of Obesity chart
- C. The state filter
- D. The little
- E. The map
Answer: B,C
Explanation:
In Tableau dashboards, floating elements are those that can be freely moved over the dashboard canvas without being snapped into the tiled layout. The floating elements are often indicated by their standalone frames and the ability to overlap with other dashboard items. From the provided image, the state filter and the Rate of Obesity chart can be identified as floating if they can be moved independently of the tiled grid layout that constrains other elements.
NEW QUESTION # 35
You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.
You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?
- A. Condition filter
- B. Top filter
- C. General filter
- D. Wildcard filter
Answer: A
Explanation:
To use the City dimension to create a dynamic filter that shows the cities that have a population greater than one million, you should use a condition filter. A condition filter is a type of filter that shows only the values that meet a specified condition based on a measure or a calculation. You can create a condition filter by dragging a dimension to the Filters shelf and selecting Condition from the dialog box. Then you can enter a formula or choose an option that defines your condition.
In this case, you want to create a condition filter based on Population, which is a measure. You can drag City to the Filters shelf and select Condition from the dialog box. Then you can choose By field from the tab and select Population > Sum > Greater than > 1000000 from the drop-down lists. This will create a condition filter that shows only the cities that have a sum of population greater than one million.
The other options are not correct for this scenario. A general filter is not a specific type of filter, but a term that refers to any type of filter in Tableau. A wildcard filter is a type of filter that shows only the values that match a specified pattern or string, such as "New*" or "*ton". A top filter is a type of filter that shows only the top or bottom N values of a measure or dimension based on a ranking or an aggregation. Reference: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_condition.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_wildcard.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
NEW QUESTION # 36
......
Top Tableau TDA-C01 Courses Online: https://dumpstorrent.actualpdf.com/TDA-C01-real-questions.html
