You have the following chart that shows profits and discounts over time. You need to combine the lines to appear as shown in the following chart. What should you do?

Drag Discount to Color on the Marks card

Drag Discount to the Columns shelf

You have a dataset that contains sates data. The following is a sample of the data. You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.Which two formulas achieve the goal Choose two

IIF(SUM< [Sales] )>50000, TRUE, FALSE)

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.

IF [Profits] != null then [Profits] END

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?

Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace Reference, and then select Dorm_Name_New

Bring in the secondary data source as a union.

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

Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace Reference, and then select Dorm_Name_New

Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source

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?

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

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

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

Case STFMEPick Measure]) WHEN 'Sales' then ([Sales]) WHEN 'Profit' then ([Profit]) e::i

You have the following map. You need the map to appear as shown in the following visualization. What should you do?

Change the mark type to Density

Drag Location to Size on the Marks card

Drag Population to Size on the Marks card

You want to create the following dashboard. The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.When you click a category on the top sheet, the sheets must resize as shown in the following exhibit. How should you lay out the objects on the dashboard?

Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.

Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.

Add both sheets to the dashboard. Set Fit to Fix width.

Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.

Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.

You are creating an annual report in Microsoft Word.In Tableau Desktop, you build a chart in a worksheet.You want to create an image of the chart that you can add to the annual report.What are two ways to create the image? Choose two.

From the Worksheet menu, use the Export option.

From the Worksheet menu, use the Copy option.

From the Worksheet menu, use the Export option.

From the Worksheet menu, use the Copy option.

From the File menu, use the Export As Version option.

From the Dashboard menu, use the Export Image option.

From the Dashboard menu, use the Copy Image option.

You have the following dataset. Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?

(SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )

(SUM ([Sales]) - LOOKUP (SUM ( [Sales]), -4))

(SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )

(SUM([Sales]) / (LOOKUP (SUM ([Sales]), -4))

(ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )

You are subscribed to several views.You need to unsubscribe from the views.What should you use?

The My Content area of Tableau web pages

The Notifications area of Tableau Prep

The Data Source page of Tableau Desktop

You have a Tableau workbook.You want to make the workbook available in Tableau Online.What should you do?

From the Server menu, select Publish Workbook.

From the Server menu, select Tableau Public, and then select Save to Tableau Public.

From the File menu, select Export Packaged Workbook.

From the Server menu, select Publish Data Source.

From the Server menu, select Publish Workbook.

You have the following tiled dashboard that has one sheet. You want to replace the sheet with Sheet2.What should you do?

Select Sheet3 and click the Swap Sheet button next to Sheet2.

Right-click Sheet2 and select Add to Dashboard.

From the context menu of Sheet3, select Deselect.

From the context menu of Sheet3, select Remove Dashboard Item.

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.

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

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

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

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

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

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

You connect to a database server by using Tableau Prep. The database server has a data role named Role1.You have the following field in the data. You need to apply the Role1 data role to the Material field.Which two actions should you perform? Choose two.

For the data type of the Material field, select Custom, and then select Role1.

From the More actions menu of Materials, select Group Values, and then select Spelling.

From the More actions menu of Materials, select Valid in the Show values section.

For the data type of the Material field, select Custom, and then select Role1.

From the More actions menu of Materials, select Group Values, and then select Spelling.

From the More actions menu of Materials, filter the selected values.

You have the following Map. You need the map to appear as shown in the following visualization. What should you do?

Change the mark type to Density.

Drag Location to Size on the Marks card.

Drag Population to Size on the Marks card.

Change the mark type to Density.

Tableau TDA-C01 Practice Test 2 - Free Online Exam Prep & Questions

You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.

Tableau TDA-C01 image Question 41 76264 09232024004731000000

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?

Become a Premium Member for full access

Unlock Premium Member

Tableau TDA-C01 Practice Test 2

Question

Tableau TDA-C01 Practice Tests

Practice Tests