Tableau Tableau Certifications TDA-C01 Questions & Answers

• Question 41:

  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.)

  Select and Place:

  

  Correct Answer:

  

• Question 42:

  You company has two divisions located in the United States and Germany Bach division has a separate database. The following is a sample of the sales data for the division in the United States.

  

  The following is a sample of the sales data for me division in Germany.

  

  You have population data in a file named Populatio.csv. the following is a sample of the data.

  

  You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.

  You need to prepare the data to support the planned visualization. The data source must support being published .

  Which four actions should you perform in order?

  (Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options. Use Answer Area arrows to re-order the options)

  Select and Place:

  

  Correct Answer:

  

• Question 43:

  You have the following dataset.

  

  You need to create the following worksheet.

  

  The table must show either profit or sales based on the selection from the Parameter 1 menu.

  Which three actions should you perform in orders

  (Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)

  Select and Place:

  

  Correct Answer:

  

• Question 44:

  You have the following dataset.

  

  You want to create a new calculated dimension field named Category that meets the following conditions:

  When Subject is Computer Science or Science, Category must be Sciences. When Subject is English or Social Studies, Category must be Humanities.

  Which two logical functions achieve the goal? Choose two.

  A. IF [Subject]- 'Science' THEN 'Sciences' ELSEIF [Subject]='English' THEN 'Humanities' ELSEIF [Subject]-'Social Studies' THEN 'Humanities' ELSEIF [Subject]= 'Computer Science' THEN 'Sciences' END

  B. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')

  C. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END

  D. CASE [Subject] WHEN 'Computer Science' THEN 'Sciences' WHEN 'Science' THEN 'Sciences' WHEN 'English' THEN 'Humanities' WHEN 'Social Studies' THEN 'Humanities' End

  Correct Answer: AD

  Explanation: To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either `Sciences' or `Humanities'. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign `Humanities' to any subject that contains `Science' in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with `Computer Science' and ignore the other subjects. References: Logical Functions - Tableau Tableau Certified Data Analyst Study Guide

• Question 45:

  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. Customer Region

  B. Order Date

  C. Product Name

  D. Quantity

  E. Revenue

  Correct Answer: DE

  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. References: Dimensions and Measures, Blue and Green - Tableau Tableau Certified Data Analyst Study Guide

• Question 46:

  You create the following worksheet

  

  The Pick Measure parameter contains the following list of values

  

  Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure. Which formula is used in the Selected Measure calculated field lo switch between measures?

  A. Case [Pick Measure] WHEN 1 then ([Sales]) WHEN 2 then ([Profit]) END

  B. Case AVG([Pick Measure]) WHEN [Sales] then 1 WHEN [Profit] then 2 END

  C. Case [Pick Measure: WHEN [Sales] then 1 WHEN [Profit] then 2 END

  D. Case STFMEPick Measure]) WHEN "Sales" then ([Sales]) WHEN "Profit" then ([Profit]) e::i

  Correct Answer: A

  Explanation: https://help.tableau.com/current/pro/desktop/en-us/parameters_swap.htm This formula uses a parameter (Pick Measure) to switch between the Sales and Profit measures. When the user selects '1', it shows Sales, and when '2' is selected, it shows Profit. This dynamic switching is enabled by the Case function.

• Question 47:

  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 as a union.

  B. 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

  C. 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

  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

  Correct Answer: C

  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.

• Question 48:

  You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary. DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.

  You want to combine the tables to meet the following requirements:

  Each record in Employeelnfo must be retained in the combined table. The records must contain the Department Name, Size, and VP fields. Every record must have a full name.

  Which type of join should you use?

  A. Inner

  B. Left

  C. Full outer

  D. Union

  Correct Answer: B

  Explanation: To combine the tables and meet the requirements, you should use a left join. A left join will keep all the records from the left table (Employeelnfo) and match them with the records from the right table (DepartmentInfo) based on the common field (Department ID). If there is no matching record in the right table, the fields from the right table will be null. This way, you will retain all the records from Employeelnfo, and also include the Department Name, Size, and VP fields from DepartmentInfo. Every record will have a full name because it is a field from the left table. A left join will look like this: References: Join Your Data - Tableau Join Types in Tableau

• Question 49:

  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?

  A. FIRST ()

  B. INDEX ()

  C. WINDOW_SUM(SUM ([Quantity]))

  D. LOOKUP (SUM ([Quantity]))

  Correct Answer: D

  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. References: The information is inferred from general Tableau knowledge as well as the following sources: Tableau Functions (Alphabetical) LOOKUP Tableau Certified Data Analyst uide

• Question 50:

  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.

  A. Furnishings

  B. Tables

  C. Chairs

  D. Accessories

  E. Copiers

  F. Machines

  G. Phones

  H. Bookcases

  Correct Answer: BDF

  Explanation: 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 to 1. 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.