ExamGecko
Search Search Login
Home Home / Tableau / TDA-C01
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

You want to create the following dashboard that will contain two sheets. What should you do?
HOTSPOT You have a data set that contains three columns named Sales, Profit, and Quantity. You need to build the following scatter plot.
You have the following dashboard. From the context menu of Sales over time, select Ignore Actions. Several Lays later, you decide that you want to filter both Sales over time and Detail table by selecting a data point on the map. What should you do?
DRAG DROP In a worksheet, you have a calculated column named YTD Sales that uses the following formula. [Order Date] <= TODAY () AND DATETBUNC {''year'', [Order Dace]) = DATETPUNC)'year', TODAY(J) You want to create a calculated column named Exclude Current Month that will be dragged to the Filters shell. Exclude Current Month will exclude the current month values from YTD Sales. How should you complete the formula for Exclude Current Month? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
You want to create the following table in a view. Which function should you use to create the Position column?
DRAG DROP 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.)
In a dataset, you have a string field named Name that contains unnecessary semicolons. Which function should you use to remove the semicolons from the Name field?
You have a Tableau workbook. You want to make the workbook available in Tableau Online. What should you do?
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?
You have a workbook that uses an extracted data source. You publish the workbook to Tableau Server. Which three actions can you perform from the Extract Refresh page in Tableau Server? Choose three.

Question 72 - TDA-C01 discussion

Report
Export

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
Answers
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')
Answers
B.
IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
C.
IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
Answers
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
Answers
D.
CASE [Subject] WHEN 'Computer Science' THEN 'Sciences' WHEN 'Science' THEN 'Sciences' WHEN 'English' THEN 'Humanities' WHEN 'Social Studies' THEN 'Humanities' End
Suggested answer: A, D

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.Reference:

Logical Functions - Tableau

Tableau Certified Data Analyst Study Guide

Show Answer
asked 23/09/2024
Tolga Kesici
48 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms