Get New 2024 Tableau exam TDA-C01 Dumps Bundle On flat Updated Dumps!
Full TDA-C01 Practice Test and 100 unique questions with explanations waiting just for you, get it now!
NEW QUESTION # 15
You have the following dataset that contain null values in the Profits field.
You want the data to appear as shown in the following table.
Which two formulas achieve the goal? Choose two.
- A. ZN ([Profits])
- B. ISNULL ([Profits])
- C. IF [Profits] != null then [Profits] END
- D. IFNULL [(profits] ,0)
Answer: A,D
Explanation:
Both the ZN and IFNULL functions in Tableau can be used to replace NULL values with zeros. The ZN function converts NULL to zero directly, while the IFNULL function allows you to specify that NULL should be replaced with zero. Both will result in showing zero for any NULL values in the Profits field.
References: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IFNULL
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IF
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ZN
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ISNULL
NEW QUESTION # 16
You have a sales dataset that contains the following fields.
You need to analyze the average revenue per product in different regions over time.
Which two fields should be measures? Choose two.
- A. Revenue
- B. Customer Region
- C. Quantity
- D. Order Date
- E. Product Name
Answer: A,C
Explanation:
To analyze the average revenue per product in different regions over time, you need to use two fields that contain numeric, quantitative values that you can measure and aggregate. Quantity and Revenue are both measures that fit this criterion. You can multiply Quantity and Revenue to get the total sales for each product, and then divide by the number of products to get the average revenue. You can also use these measures to create charts and tables that show the trends and comparisons over time and across regions. Reference:
Dimensions and Measures, Blue and Green - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 17
You have the following dataset:
You want to create a parameter to dynamically filter the data to produce the following results.
Which two types of parameters can you use to produce the results? Choose two.
- A. String
- B. Datetime
- C. Integer
- D. Float
- E. Boolean
- F. Date
Answer: A,C
Explanation:
In the context of filtering data in Tableau, both string and integer parameters can be used to dynamically filter data. A string parameter can be used to filter text-based values, while an integer parameter is suitable for numerical values. In the provided dataset and result URLs, it appears that a unique identifier or key (which could be a string or integer) is being used to filter specific data entries. Reference: The information is based on the following sources:
An Introduction to Parameters in Tableau
Create Parameters - Tableau
NEW QUESTION # 18
You have the following primary data source that contains a dimension named Dorm_Code.
You receive the following secondary data source that contains updated dorm codes.
You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.
What should you do?
- A. Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace References, and then select Dorm_Name_New
- B. Bring in the secondary data source as a union.
- C. Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dcrm_Name_New] in the calculation window
- D. Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source
Answer: A
Explanation:
Using relationships: You can use relationships to link the secondary data source with the primary data source based on a common field. This will allow you to use fields from both data sources in your visualization without creating new fields or duplicating data. You can then replace references to update the dimension values. For example, you can use relationships to link the updated dorm codes with the primary data source and then replace Dorm_Code with Dorm_Code_New in your visualization.
https://community.tableau.com/s/question/0D54T00000C5ldZSAR/update-data-view-based-on-dimension To update existing visualizations with new codes without changing the field name, using relationships to bring in the secondary data source is appropriate. Then using Replace References allows you to update the references from the old dorm codes to the new ones while maintaining the existing field name.
NEW QUESTION # 19
You have the following bar chart.
You want the chart to appear as shown in the Mowing exhibit.
What should you add?
- A. A distribution band
- B. A reference line
- C. An average line
- D. A reference band
Answer: D
Explanation:
A reference band is a shaded area that shows a range of values on an axis. You can use a reference band to highlight a target range, a confidence interval, or a standard deviation. In this case, you want to add a reference band that shows the range of values from 0 to 100 on the y-axis. This will create a shaded area behind the bars that indicates the percentage of sales.
To add a reference band, you need to do the following steps:
Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet.
Drag Reference Band from the Analytics pane to Y-Axis on the worksheet. This will add a reference band on the y-axis that shows the average and confidence interval for all values.
Click on the Edit button on the reference band to open the Edit Reference Band dialog box. You will see options to customize your reference band.
Change the Band From value to 0 and the Band To value to 100. This will change the reference band to show the range of values from 0 to 100 on the y-axis.
Click OK to apply the changes. You will see that the reference band now shows a shaded area behind the bars.
NEW QUESTION # 20
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 # 21
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 Density
- B. Change the mark type to Map
- C. Drag Population to Size on the Marks card
- D. Change the opacity to 75%
- E. Drag Location to Size on the Marks card
Answer: C
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
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To split the Customer Name field into two fields named First Name and Last Name, 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.
Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the Superstore data source.
Right-click on Customer Name in the table and select Split from the menu. This will split the field into two fields based on a separator, which is a space by default. You will see two new fields named Customer Name - Split 1 and Customer Name - Split 2 in the table.
Right-click on Customer Name - Split 1 and select Rename from the menu. Type First Name as the new name and press Enter. This will rename the field as First Name.
Right-click on Customer Name - Split 2 and select Rename from the menu. Type Last Name as the new name and press Enter. This will rename the field as Last Name.
References: https://help.tableau.com/current/pro/desktop/en-us/datasource_prepare.htm
https://help.tableau.com/current/pro/desktop/en-us/split.htm
https://help.tableau.com/current/pro/desktop/en-us/renamefield.htm
NEW QUESTION # 24
You have the following visualization.
You Create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards.
What is the Rank Score value for Student ID 4220?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
the rank function returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question.
To answer your question, we need to apply the rank function to the Avg Score column and sort it in descending order. Then we can find the rank score value for Student ID 4220 by looking at the corresponding row.
Here is how the table would look like after applying the rank function and sorting:
As you can see, the rank score value for Student ID 4220 is 1.
NEW QUESTION # 25
You publish a dashboard that uses an extract. The extract refreshes every Monday at 10:00.
You need to ensure that the extract also refreshes on the last day of the month at 18:00.
What should you do?
- A. From Tableau Server, select the workbook, select Refresh Extracts, and then add a new extract refresh.
- B. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.
- C. From Tableau Server, select Schedules, and change the priority of the existing schedule.
- D. From Tableau Server, select Schedules, find the schedule of the extract, and change the frequency to the last day of the month.
Answer: A
Explanation:
To ensure that the extract also refreshes on the last day of the month at 18:00, you need to add a new extract refresh task to the workbook on Tableau Server. You can do this by selecting the workbook, selecting Refresh Extracts, and then choosing Schedule a Refresh. You can then select an existing schedule that matches your desired frequency and time, or create a new schedule with a custom frequency and time. This will add a new extract refresh task to the workbook, in addition to the existing one that refreshes every Monday at 10:00. You can also modify or delete the extract refresh tasks as needed. References:
Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Publishing and Scheduling Data Refreshes" Tableau Help: Refresh Data on a Schedule Tableau Help: Manage Refresh Tasks
NEW QUESTION # 26
Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.
- A. Send us your feedback on it.
- B. Send us your
Answer: A
NEW QUESTION # 27
You are creating a new dashboard.
You need to add a button to the dashboard that allows users to export the dashboard as an image.
Which type of object should you use?
- A. Navigation
- B. Image
- C. Download
- D. Extension
- E. Ask Data
Answer: D
NEW QUESTION # 28
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 # 29
You have the following dataset.
You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer Which formula should you use for the filter?
- A. NAME Tableau-USER-NAME)
- B. USERNAME()=(Tableau_USER_NAME)
- C. ISFULLNAMETableu_USER_NAME))=USERNAME()
- D. NAMEUSERNAME()
Answer: B
Explanation:
To create a boolean calculated field to place on the data source filter, you should use the formula USERNAME() = [Tableau_user]. This formula will return TRUE if the current Tableau user name matches the value in the Tableau_user field, and FALSE otherwise. You can use this formula as a data source filter by dragging it to the Filters shelf and selecting TRUE from the menu. This will filter the data to show only the rows that are relevant to the specific Tableau user.
The other options are not correct for this scenario. NAME([Tableau_user]) is not a valid function in Tableau.
ISFULLNAME([Tableau_user]) = USERNAME() is not a valid expression in Tableau. 'S' + STR([Sales]/1000) is not a boolean expression, but a string expression that converts sales to thousands with a prefix of "S". References: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#USERNAME
https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields.htm In Tableau, the USERNAME() function returns the username of the user who is currently logged in. To create a filter that only shows data relevant to the logged-in Tableau user, a boolean calculated field can be created to compare the current username with the usernames listed in the Tableau_User_Name field of the dataset.
Therefore, the correct formula for this filter is USERNAME() = [Tableau_USER_NAME], which will return true for rows where the Tableau_User_Name matches the current user's username.
NEW QUESTION # 30
You have the following dataset.
Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?
Answer:
Explanation:
NEW QUESTION # 31
You have the Mowing dashboard.
Which two elements are floating? Choose two.
- A. The Rate of Obesity chart
- B. The color legend
- C. The little
- D. The state filter
- E. The map
Answer: A,B
Explanation:
To identify which elements are floating on a dashboard, you can look for a gray border around them when you select them. Alternatively, you can open the Layout pane and see which elements have a pin icon next to them. The pin icon indicates that the element is floating and can be moved freely on the dashboard. Based on these criteria, the state filter and the color legend are floating elements on the dashboard. 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_create_layouts.htm
NEW QUESTION # 32
Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.
Answer:
Explanation:
check the steps below in explanation
Explanation:
To create a filled map to show the distribution of total Sales by State across the United States, 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 Map tab at the bottom of the workbook to open the Map worksheet. You will see a blank worksheet with no marks.
Drag State from the Dimensions pane to Detail on the Marks card. This will create a map that shows each state as a mark. You may need to zoom in or out to see the whole map.
Drag Sales from the Measures pane to Color on the Marks card. This will create a filled map that shows the distribution of total Sales by State across the United States. The color legend will show you the range of values and colors for Sales.
Optionally, you can adjust the color scheme, transparency, size, and borders of the marks by clicking on the Color menu on the Marks card. You can also add labels, tooltips, or filters to enhance your map.
NEW QUESTION # 33
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 34
......
[May-2024] Pass Tableau TDA-C01 Exam in First Attempt Guaranteed: https://drive.google.com/open?id=1qnHC39mUPBHjGq-mtC6qZZ3KIdCRUyQi
Reduce Your Chance of Failure in TDA-C01 Exam: https://www.torrentexam.com/TDA-C01-exam-latest-torrent.html
