This page was exported from IT Certification Exam Braindumps [ http://blog.braindumpsit.com ] Export date:Sat Apr 12 17:03:00 2025 / +0000 GMT ___________________________________________________ Title: [UPDATED Dec-2024] Best Value Available Preparation Guide for TDA-C01 Exam [Q72-Q88] --------------------------------------------------- [UPDATED Dec-2024] Best Value Available Preparation Guide for TDA-C01 Exam 1 Full TDA-C01 Practice Test and 122 Unique Questions, Get it Now! Q72. You have the following worksheet.You want to create a table calculation that shows sales growth over each year.How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.) Explanation:There are different ways to create a table calculation that shows sales growth over each year, but one possible answer is:SUM([Sales])LOOKUP(SUM([Sales]), -1)PREVIOUS_VALUE(0)To calculate the sales growth over each year, you need to compare the current year’s sales with the previous year’s sales and divide the difference by the previous year’s sales. You can use the SUM, LOOKUP, and PREVIOUS_VALUE functions to achieve this. The SUM function returns the total sales for each year. The LOOKUP function returns the value of an expression in a target row, specified as a relative offset from the current row. The PREVIOUS_VALUE function returns the value of the expression in the previous row, or a specified value if there is no previous row. The formula for the table calculation is:(SUM([Sales]) – LOOKUP(SUM([Sales]), -1)) / PREVIOUS_VALUE(0)This formula subtracts the sales of the previous year (LOOKUP(SUM([Sales]), -1)) from the sales of the current year (SUM([Sales])) and divides the result by the sales of the previous year. If there is no previous year, the formula uses 0 as the denominator (PREVIOUS_VALUE(0)) to avoid division by zero errors.References:Tableau Certified Data Analyst Exam Prep Guide, page 11, section “Creating Calculated Fields” Tableau Help: SUM Function Tableau Help: LOOKUP Function Tableau Help: PREVIOUS_VALUE FunctionQ73. 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 ? Q74. You want to create the following dashboard that will contain two sheets.What should you do?  Drag both sheets to the dashboard and add a border to each sheet.  Drag both sheets to the dashboard and add a background lo each sheet.  Add both sheets lo a horizontal container and add a border to the container.  Add a border to both sheets and add both sheets to a horizontal object. Q75. You want to add a draft watermark to a dashboard as shown in the following exhibit.Which type of object should you use?  Image  Sheet  Web page  Horizontal References: https://help.tableau.com/current/pro/desktop/en-us/dashboards.htmhttps://help.tableau.com/current/pro/desktop/en-us/dashboards_create_layouts.htmhttps://help.tableau.com/current/pro/desktop/en-us/dashboards_create_watermarks.htm To add a draft watermark to a Tableau dashboard, you would use an image object. You can overlay this image across your dashboard, possibly with some transparency, to achieve the watermark effect without interfering with the readability of the dashboard content.Q76. You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.What should you do from Tableau Desktop?  From the Data menu select New Data Source  From the Data menu select Replace Data Source  From the File menu select New  From the File menu select Import Workbook Q77. You have the following chart that sorts states by the number of products each state has purchased.Which formula should you use to include a number with the position of each state within each region?  FIRST ()  INDEX ()  WINDOW_SUM(SUM ([Quantity]))  LOOKUP (SUM ([Quantity])) The LOOKUP function is used to return the value of a specified field in a different row, which can be defined relative to the current row. In this context, it can be used to include a number with the position of each state within each region by looking up the SUM([Quantity]) in each respective position. Reference: The information is inferred from general Tableau knowledge as well as the following sources:Tableau Functions (Alphabetical)LOOKUPTableau Certified Data Analyst Exam GuideQ78. You create the following story that contains two story point.You want to change the story point format to show the current story point number out of the total number of story points.Which Layout option should you use?  Dots  Arrows only  Caption boxes  Numbers To change the story point format to show the current story point number out of the total number of story points, you should use the Numbers option in the Layout tab. This option will display the story points as numbers in a horizontal or vertical sequence, such as 1/2, 2/2. You can also choose to show or hide the next and previous arrows for navigation. The Numbers option will help you indicate the progress and order of your story points more clearly than the other options. Reference:Creating a Story – TableauNew in 9.0: Formatting the Story Points Navigator – TableauTableau Certified Data Analyst Study GuideQ79. You want to add a comment to March 2020 as shown in the following visualization.You have the following sets in a Tableau workbook* Top N Customers* Customers of 2020* Top N Products* Sellers of 2020Which two sets can you combine? Choose two  Sellers of 2020  Customers of 2020  Top N Products  Top N Customers To combine two sets, they must have at least one dimension in common. In this case, Customers of 2020 and Top N Customers both have Customer Name as a dimension, so they can be combined using set operations such as union, intersection, or difference. Sellers of 2020 and Top N Products have different dimensions (Seller Name and Product Name), so they cannot be combined. References:https://help.tableau.com/current/pro/desktop/en-us/sets.htmhttps://help.tableau.com/current/pro/desktop/en-us/sets_create.htm#combine-sets In Tableau, sets can be combined if they are created from the same dimension. From the options provided,“Customers of 2020” and “Top N Customers” are likely created from the same dimension (Customers).Therefore, these two sets can be combined to create a new set that includes or excludes members based on the combined criteria. Combining sets like “Top N Products” with “Customers of 2020” would not be feasible unless they are from the same dimension, which is typically not the case.Q80. You create a worksheet named Sales by Region and hide the tide of the worksheet. You print the worksheet as a PDF and notice that the worksheet title appears. You need to prevent the title from appearing when you print the worksheet as a PDF. Which settings should configure from the File menu in Tableau Desktop?  Page Setup  Print  Export As PowerPoint  Share  Export As Version Q81. Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.Add a distribution band on Profit to show the standard deviation from- 1 to 1. Send us your feedback on itQ82. You have the Mowing dashboard.Which two elements are floating? Choose two.  The state filter  The color legend  The map  The Rate of Obesity chart  The little 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.htmQ83. 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?  5  4  6  3 To determine the Rank Score value for Student ID 4220, we look at the visualization provided and apply the table calculation of RANK(AVG([Score])). This function will rank the average scores in ascending order by default, with the lowest score receiving the rank of 1.Based on the provided visualization, the scores for the students are as follows (from lowest to highest average score):Student ID 4183: 39 (Rank 1)Student ID 4220: 71 (Rank 6)Student ID 4247: 71 (Rank 6, same score as ID 4220 so they share the same rank) Student ID 4124: 75.5 Student ID 4050: 64 Student ID 4205: 67 Student ID 4056: 66 Since Student ID 4220 has an average score of 71, which is the third-highest score, it shares the rank with Student ID 4247. However, since Tableau ranks without gaps, the actual rank assigned is 6, considering that there are two students with a rank of 4 (due to the same average score being the second lowest), making the next rank number 6.Note: The actual ranks for the highest scores are not provided, but they are not needed to determine the rank for Student ID 4220.https://help.tableau.com/current/prep/en-us/prep_calculations.htmQ84. You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization. Q85. You have the Mowing two tables that contains data about the books in a library.Both tables are incomplete so there are books missing from the tables.You need to combine the tables. The solution must ensure that all the data is retained Which type of join should you use?  Full outer join  Right join  left join  Inner join To combine the two tables that contain data about books in a library and ensure that all the data is retained, you should use a full outer join. A full outer join is a type of join that returns all rows from both tables, regardless of whether there is a match or not. If there is no match, null values are filled in for the missing fields.To perform a full outer join, you need to do the following steps:Connect to both tables as your data sources in Tableau. You can use either live or extract connections.Drag one table to the canvas and drop it on top of another table. This will create a join between them based on a common field.Click on the join icon between the tables and select Full Outer Join from the drop-down list. This will change the join type to full outer join and show all rows from both tables.Optionally, you can add or remove join clauses by clicking on Add or Remove buttons next to each clause. You can also change or rename fields by clicking on them.The other types of joins are not correct for this scenario. An inner join returns only the rows that have a match in both tables, which will exclude any books that are missing from either table. A left join returns all rows from the left table and only the matching rows from the right table, which will exclude any books that are only in the right table. A right join returns all rows from the right table and only the matching rows from the left table, which will exclude any books that are only in the left table. References:https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htmhttps://help.tableau.com/current/pro/desktop/en-us/join_types.htmWhen combining two datasets that are both incomplete and where it’s important to retain all data from both sources, a full outer join is appropriate. This type of join ensures that all records from both tables are included in the combined dataset, even if there are no matching records in the other table.Q86. 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. check the steps below in explanationExplanation:To filter the table to show the members of the Top10 set and the Bottom10 set, 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 Disciplines worksheet.Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the disciplines, sales, and profit for each salesperson.Click on the drop-down arrow next to Salesperson on the Filters shelf. This will open a menu that allows you to filter by different criteria.Select Set from the menu. This will show you the sets that are available for the Salesperson field. You will see Top10 and Bottom10 as two sets that have been created based on the sales ranking.Check the boxes next to Top10 and Bottom10. This will filter the table to show only the members of these two sets. You can also click on All to deselect all other values.Click OK to apply the filter. You will see that the table now shows 20 rows, 10 for each set.Q87. You have the following:Overall Rank and Rank are calculated fields that use the RANK function.You filter out the sub-category where [Ovorall Rank] – 1.For which three the sub-categories will the value of Rank change? Choose three.  Furnishings  Tables  Chairs  Accessories  Copiers  MachinesG Phones  Bookcases In Tableau, the RANK function assigns a rank to each row within a partition of the data, based on the value of the field being ranked. It is important to understand that the rank is recalculated whenever the underlying data or the partitioning changes.In the given scenario, the Overall Rank is based on the Sales figures, while the Rank (presumably) is based on the Sales within the Category. When filtering on the condition where [Overall Rank] – 1, it means we are excluding the sub-category that has an Overall Rank of 2.Looking at the data:Furnishings has an Overall Rank of 8, which does not meet the filter condition ([Overall Rank] – 1).Therefore, its rank remains the same.Tables have an Overall Rank of 3. When the sub-category with an Overall Rank of 2 is removed (Chairs in this case), Tables move up in the overall ranking. However, since Tables are the top-ranked within the Furniture category, their Rank within the category would remain unchanged at 1.Chairs have an Overall Rank of 2, which meets the filter condition and thus will be removed from the view. We cannot determine the change in Rank for Chairs because they are filtered out.Accessories have an Overall Rank of 5. If any sub-category with a higher Overall Rank (1 to 4) is removed, the rank of Accessories within the Technology category could change because it is currently ranked 3 in its category. With the removal of Phones (Overall Rank 1), the Rank of Accessories could potentially increase.Copiers have an Overall Rank of 6, which does not meet the filter condition. Therefore, its rank remains the same.Machines have an Overall Rank of 4. If we remove Phones (Overall Rank 1), Machines will move up in the overall ranking and potentially within the Technology category as well, changing its Rank from 2 to1.Phones have an Overall Rank of 1, which does not meet the filter condition of being Overall Rank 2.Therefore, its rank remains the same.Bookcases have an Overall Rank of 7, which does not meet the filter condition. Therefore, its rank remains the same.Based on this analysis, when the sub-category with an Overall Rank of 2 (Chairs) is removed, the Rank value will change for Tables, Accessories, and Machines, as they will move up in the overall ranking within their respective categories. However, it’s important to note that while Tables will move up in the overall ranking, their rank within the Furniture category would not change as they are already at the top. The rank changes for Accessories and Machines are due to the removal of Phones, which is ranked higher overall and within the Technology category.Q88. You want to add a comment to March 2020 as shown in the following visualization.You have the following sets in a Tableau workbook* Top N Customers* Customers of 2020* Top N Products* Sellers of 2020Which two sets can you combine? Choose two  Sellers of 2020  Customers of 2020  Top N Products  Top N Customers  Loading … Tableau TDA-C01 certification exam covers a wide range of topics related to data analytics, including data visualization, business intelligence, data analysis, and data reporting. Participants in this certification program will learn how to use different Tableau tools and features to create effective visualizations and dashboards. They will also develop skills in interpreting data and identifying trends and patterns that can be used to make data-driven decisions. In addition, participants will learn how to create effective data reports and communicate data insights to stakeholders. Achieving the Tableau TDA-C01 certification demonstrates a candidate's ability to use Tableau software to solve complex data problems and effectively communicate insights from data. Tableau Certified Data Analyst certification is recognized by top companies and organizations worldwide, making it a valuable asset for professionals looking to advance their careers in the field of data analysis. With the increasing demand for skilled data analysts, the Tableau TDA-C01 certification can give candidates a competitive edge in the job market and open up new career opportunities.   Get Instant Access to TDA-C01 Practice Exam Questions: https://www.braindumpsit.com/TDA-C01_real-exam.html --------------------------------------------------- Images: https://blog.braindumpsit.com/wp-content/plugins/watu/loading.gif https://blog.braindumpsit.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2024-12-02 09:45:05 Post date GMT: 2024-12-02 09:45:05 Post modified date: 2024-12-02 09:45:05 Post modified date GMT: 2024-12-02 09:45:05