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

Tableau TDA-C01 Practice Test - Questions Answers, Page 6

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 the following dataset. Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?

Question 51

Report
Export
Collapse

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.
5
A.
5
Answers
B.
4
B.
4
Answers
C.
6
C.
6
Answers
D.
3
D.
3
Answers
Suggested 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 is1.

Question 52

Report
Export
Collapse

You have the following table.

You need each record to alternate between grey and white.

What should you change in the Format Shading pane?

A.
the row banding size to 1
A.
the row banding size to 1
Answers
B.
the column banding size to 1
B.
the column banding size to 1
Answers
C.
the row banding size to 3
C.
the row banding size to 3
Answers
D.
the column banding size to 3
D.
the column banding size to 3
Answers
Suggested answer: A

Question 53

Report
Export
Collapse

HOTSPOT

You have a data set that contains three columns named Sales, Profit, and Quantity.

You need to build the following scatter plot.


Question 53
Correct answer: Question 53

Question 54

Report
Export
Collapse

DRAG DROP

You have the following calculated fields in a worksheet.

[Calc1] = DATEADD ('year', -1, TODAY ())

[Calc2] = DATETRUNC ( 'month' , DATEADD ('year', -1, TODAY ())

You want to calculate the month to date value of the prior year.

How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)


Question 54
Correct answer: Question 54

Explanation:

Finding the Month-to-Date Values for the Prior Year

[DATEADD Function]

[DATETRUNC Function]

Question 55

Report
Export
Collapse

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
A.
Inner
Answers
B.
Left
B.
Left
Answers
C.
Full outer
C.
Full outer
Answers
D.
Union
D.
Union
Answers
Suggested 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:

Join Your Data - Tableau

Join Types in Tableau

Question 56

Report
Export
Collapse

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?

A.
Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.
A.
Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.
Answers
B.
Add both sheets to the dashboard. Set Fit to Fix width.
B.
Add both sheets to the dashboard. Set Fit to Fix width.
Answers
C.
Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.
C.
Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.
Answers
D.
Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
D.
Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
Answers
Suggested answer: D

Explanation:

To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories.Reference:

Size and Lay Out Your Dashboard - Tableau

Create a Dashboard - Tableau

Format Dashboard Layout in Tableau - GeeksforGeeks

Question 57

Report
Export
Collapse

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.

A.
From the Worksheet menu, use the Export option.
A.
From the Worksheet menu, use the Export option.
Answers
B.
From the Worksheet menu, use the Copy option.
B.
From the Worksheet menu, use the Copy option.
Answers
C.
From the File menu, use the Export As Version option.
C.
From the File menu, use the Export As Version option.
Answers
D.
From the Dashboard menu, use the Export Image option.
D.
From the Dashboard menu, use the Export Image option.
Answers
E.
From the Dashboard menu, use the Copy Image option.
E.
From the Dashboard menu, use the Copy Image option.
Answers
Suggested answer: A, B

Explanation:

To create an image of the chart that you can add to the annual report, you can use either the Export option or the Copy option from the Worksheet menu. The Export option will allow you to save the image as a file in a specified location, name, and format. The Copy option will allow you to copy the image to the clipboard and paste it into another application, such as Microsoft Word. Both options will let you choose which elements to include in the image, such as title, caption, legend, etc.Reference:

Export Views from Tableau Desktop to Another Application

Copy and Paste Views from Tableau Desktop to Another Application

Question 58

Report
Export
Collapse

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?

A.
(SUM ([Sales]) - LOOKUP (SUM ( [Sales]), -4))
A.
(SUM ([Sales]) - LOOKUP (SUM ( [Sales]), -4))
Answers
B.
(SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )
B.
(SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )
Answers
C.
(SUM([Sales]) / (LOOKUP (SUM ([Sales]), -4))
C.
(SUM([Sales]) / (LOOKUP (SUM ([Sales]), -4))
Answers
D.
(ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )
D.
(ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )
Answers
Suggested answer: B

Explanation:

The formula in option B calculates the percent difference in sales relative to the same quarter the previous year. It subtracts the sales of the same quarter from the previous year from the current year's sales, and then divides this by the previous year's sales. This gives a percentage change, which aligns with what is shown in the Calculation field of your dataset. The LOOKUP function returns the value of a specified offset from the current row in the partition. In this case, the offset is -4, which means the value of the same measure four rows above the current row. This corresponds to the same quarter of the previous year, assuming the data is sorted by quarter.Reference:

LOOKUP Function - Tableau

Table Calculations - Tableau

Tableau Certified Data Analyst Study Guide

Question 59

Report
Export
Collapse

HOTSPOT

You have a blank dashboard.

You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.

To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.)


Question 59
Correct answer: Question 59

Explanation:

Add Show/Hide Buttons - Tableau

Layout Containers - Tableau

Question 60

Report
Export
Collapse

HOTSPOT

You receive a tab-delimited data file name sales.tsv.

You need to connect to the file.

Which option should you select in Tableau Desktop?


Question 60
Correct answer: Question 60
Total 120 questions
Go to page: of 12
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