Tableau Data Analyst Test - 1

Welcome to your Tableau Data Analyst – Test-01

Name

Phone

Q1. You are given a task to replace the data source. Choose the correct steps in order:

1. Go to the sheet tab and select Data > Replace Data Source.
2. Open a new sheet where you want to replace the data source
3. On the Data Source page, drag a table to the canvas to set up the data source (if this isn’t automatically done for you).
4. Open a workbook that connects to the original data source.
5. In the Replace Data Source dialog box, select the Current data source and the Replacement data source.
6. When finished, click OK.
7. Select Data > New Data Source and then connect to the new data source.

Select 1 option(s):

4-7-3-1-5-6

2-7-3-1-5-6

4-7-2-3-5-1-6

2-7-4-3-1-5-6

7-4-3-1-5-6

Q2. You are given two data sets. The result should be to show all customers and their corresponding sales records using a custom SQL query:

Sales: Customers:

Select 1 option(s):

SELECT * FROM Sales
LEFT JOIN Customers
ON Sales.ID=Customers.ID
GROUP BY Name;

SELECT * FROM Customers
LEFT JOIN Sales
ON Customers.ID=Sales.ID
GROUP BY Name;

SELECT * FROM Customers
LEFT JOIN Sales
ON Customers.ID=Sales.ID AND Customers.Name = Sales.Value
GROUP BY Name;

SELECT * FROM Customers
LEFT JOIN Sales
ON Customers.ID=Sales.ID
WHERE Name = ‘Phillina Ober‘;

Q3. Which of the following is valid about Published Data Source when you sign in Tableau Server Site?

Select 1 option(s):

You can see all data on Tableau Server which you have access

You can see all data on Tableau Server Site which you have access

You can see all data on Tableau Server

You can see all data on Tableau Server Site

Q4. You need to open *twb file on your Tableau desktop. Choose the appropriate section to open it.

Select 1 option(s):

Tableau Server

Microsoft Excel

Text File

More... (To a File)

JSON File

PDF File

Q5. You are given a task to combine these two data sources but keep duplicate records. Choose the appropriate custom SQL statement.

Data1:

Data2:

Select 1 option(s):

JOIN

UNION

LEFT JOIN

RIGHT JOIN

UNION ALL

Q6. Select all true statements about ad-hoc calculations.

Select 3 option(s):

Ad-hoc calculations are not available when you create groups, sets, hierarchies, or parameters.

Ad-hoc calculations are valid for creating trend lines, forecasts, reference lines, bands, and distributions.

Only one ad-hoc calculation can be open at a time.

Ad-hoc calculations are supported on the Rows, Columns, Marks, and Pages shelves.

All of the above

Q7. What best describes how this FIXED expression works in a view?

{FIXED : SUM([Sales])}

Select 1 option(s):

Calculates the sum of sales of each Category and Year.

Calculates the sum of sales for each Category and Year.

Calculates the total sum of sales

Calculates the sum of sales of the Category in each Year.

Q8. Choose the way how to get this “Draft“ sign in a dashboard.

Select 1 option(s):

Image Objects

Navigation Objects

Web Page Objects

Blank Objects

Q9. Which filter do you use to get sub-categories with sales over 100K?

Select 1 option(s):

Top filter

General Filter

Condition filter

Wildcard filter

Q10. How to get sales data by category only for 2020?

Select 1 option(s):

FIRST()=-1

FIRST=1

FIRST=2

FIRST(-1)

FIRST(1)

Q11. You have a Profit.tsv file. Which section do you choose to open it in Tableau Prep Builder?

Select 1 option(s):

Microsoft Excel

PDF file

Tableau extract

Tableau Server

Text file

Spatial file

Q12. Choose the correct answer:

RANK(_______)

Select 1 option(s):

SUM([Sales])

[Sales]

SUM(Sales)

Sales

Q13. Which of the following export options are available from the Tableau worksheet?

Select 3 option(s):

.pptx

.png

.html

.csv

.xlxs

Q14. There are two dashboards in the workbook. Which object is used to move to the next dashboard

Select 1 option(s):

Web Page

Blank

Navigation

Link

Go to sheet

Go to URL

Q15. Which month shows a higher percent increase?

Select 1 option(s):

March

May

December

September

Q16. You used Data Interpreter and based on the result how many rows will be shown in Tableau as values?

Select 1 option(s):

Q17. Which type of join should be used when you want to keep all the records from both tables, but only match those that have matching values in both tables?

Select 1 option(s):

Inner Join

Left Join

Right Join

Full Outer Join

Q18. You have a data set that contains the Date, Sales, Profit, and Quantity fields. To create the view in the picture, choose the correct steps.

Select 1 option(s):

Drag Date to the Columns, Measure Values to the Rows, and Measure Names to the Colors.

Drag Date to the Columns, Sales, Profit, and Quantity to the Rows, set Quantity to Dual Axis, drag Measure Names to the Rows

Drag Date to the Columns, Sales and Profit to the Rows, set Profit to Dual Axis, drag Quantity next to Dual Axes, Measure Names to the Rows

Drag Date to the Rows, Measure Values to the Columns, and Measure Names to the Colors.

Q19. Which of the following gives the moving average of Profit for 5 days?

Select 1 option(s):

WINDOW_AVG(SUM([Profit]), -4, 0)

MOVING_AVG(SUM([Profit]), -4, 0)

WINDOW_AVG(SUM([Profit]), -5, 0)

MOVING_AVG(SUM([Profit]), -5, 0)

Q20. Choose valid syntaxes for a Level of Detail (LOD) expression in Tableau.

Select 4 option(s):

{SUM([Sales])}

{INCLUDE [Category] : AVG([Profit])}

{EXCLUDE [Date] : MAX([Revenue])}

{AGG([Sales]) : MIN([Profit])}

{FIXED : SUM([Sales])}

Q21. Which of the following calculations gives that result?

Select 1 option(s):

CONCATENATE([First Name], [Last Name])

[First Name] + [Last Name]

[First Name] + ‘ ‘ + [Last Name]

REPLACE([First Name], [Last Name])

Q22. Which of the following returns part of a given date as an integer?

Select 1 option(s):

DATEPART()

DATENAME()

DATETRUNC()

MAKEDATE()

Q23. You have a dataset with a “Date“ field that contains dates in the format “MM/DD/YYYY“. You want to create a view that shows the sum of sales by quarter. Which Tableau function would you use to accomplish this?

Select 1 option(s):

DATEADD

DATEDIFF

DATEPART

DATETRUNC

Q24. Choose the correct output file type in Tableau Prep.

Select 3 option(s):

Tableau Data extract

Microsoft Excel

Comma Separated Values

Power Point

Microsoft Word

Q25. What does that icon mean?

Select 1 option(s):

The workbook is directly connected to a relational data source or file.

The workbook is connected to a cube (multidimensional) data source. In Tableau, cube data sources are supported only in Windows.

The workbook is connected to an extract that still references the underlying data.

The workbook is connected to an Excel table, sub-table, or named range.

The workbook is connected to a data source that has been published to Tableau Server.

Q26. In Tableau Server, what is the minimum frequency at which you can schedule a data extract refresh?

Select 1 option(s):

Every 15 minutes

Every 30 minutes

Every hour

Every day

Every 2 hours

Q27. What is the most appropriate grouping method for this case in Tableau Prep?

Select 1 option(s):

Automatic

Pronunciation

Spelling

Common characteristics

Manual Selection

Q28. Choose the valid worksheet action(s) in Tableau.

Select 3 option(s):

Filter

Highlight

Go to Dashboard

Change Group Values

Go to URL

Q29. If Tableau Prep Builder samples the data in the input step, which of the following occurs?

Select 1 option(s):

The entire data set is used in the flow and to create the output.

The sampled data is used in the flow and to create the output.

The entire data set is used in the flow, but the sampled data is used to create the output.

The sampled data is used in the flow, but the entire data set is used to create the output.

Q30. You are given a data set which contains twitter handle of users. You need to get their first name only but first letter should be the Capital letter. Choose the correct functions.

Data set:

Expected Result:

_____(_____(_____([Twitter], 2), ‘_‘, 1))

Select 1 option(s):

PROPER, SPLIT, MID

SPLIT, UPPER, MID

UPPER, SPLIT, MID

MID, SPLIT, LOOKUP

CONTAINS, UPPER, SPLIT

FIND, UPPER, SPLIT

Q31. According to Tableau‘s Order of Operations, which of the following operations is performed first, and which one is the last?

Select 2 option(s):

Context Filters

Table Calc Filters

Extract Filters

Measure Filters

Dimension Filters

Data Source Filters

Q32. Which of the following fields would be appropriate to get the color palette on the map?

Select 2 option(s):

Q33. This is the Sales by Cities sorted in Descending order. You are given a task to take the TOP 10 cities by Sales for the last month in the data set. When the records come in for the upcoming months, the TOP 10 cities should be updated accordingly. Choose the correct answer(s)

Select 1 option(s):

Select TOP 10 cities in the view, right-click and choose Group

Select TOP 10 cities in the view, right-click and choose Create Set

Right-click City field in the Data pane, create a set with TOP 10 option by Sales field

Right-click City field in the Data pane, create a set with Condition option by setting Sales field greater than 43K.

Right-click City field in the Data pane, create a group by choosing first 10 city names in the list

Q34. Which of the following gives MEDIAN([Sales])?

Select 1 option(s):

PERCENTILE([Sales],.5)

WINDOW_MIN([Sales],.5)

RANK_PERCENTILE([Sales],.5)

WINDOW_MEDIAN([Sales],.5)

WINDOW_PERCENTILE([Sales],.5)

Q35. Choose the correct calculation(s)

Select 3 option(s):

SUM(Price)*[Quantity]

SUM(Price*Quantity)

SUM(Price)*SUM(Quantity)

[Price]*SUM(Quantity)

SUM(Price)*10

Q36. What is the shaded region in the picture?

Select 1 option(s):

Forecast Indicator

Prediction Interval

Seasonal Pattern

Forecast Length

Q37. How do you get that result?

Select 1 option(s):

CEILING([Sales])

FLOOR([Sales])

ROUND([Sales],1)

BUFFER([Sales])

Q38. What can you publish into Tableau Server?

Select 2 option(s):

Workbooks

Views

Data Sources

Worksheets

Stories

Q39. You want to create a table showing the number of orders by category. What steps should be taken?

Select 1 option(s):

Create a function using COUNTD([Order ID]), drag the function to the row shelf then Category to the column shelf.

Create a function using COUNT([Order ID]), drag the function to the column shelf then Category to the row shelf.

Create a function using COUNT([Order ID]), drag the function to the text shelf then Category to the row shelf.

Create a function using UNIQUE ([Order ID]), drag the function to the row shelf then Category to the column shelf.

Q40. What does this data story type shape mean in Tableau?

Select 1 option(s):

Describes how something your audience cares about relates to the bigger picture.

Shows how two or more subjects differ.

Sets context so that your audience better understands what‘s going on in a particular category.

Uses a chronology to illustrate a trend.

Highlights important shifts when one category overtakes another.

Q41. Which of the following statements about aliases in Tableau is true?

Select 1 option(s):

Changing the alias of a field will change the underlying data source

Aliases can only be applied to discrete dimensions, not continuous dimensions

Aliases can be created for a discrete measure

Aliases can be created for the dates

Q42. Which statement will replace missing values with 0‘s in the table below?

Select 1 option(s):

ISNULL([Sales])

IFNULL(LOOKUP(SUM([Sales]),0),0)

IFNULL([Sales],0)

ZN(LOOKUP(SUM([Sales]),0),0)

Edit Aliases and replace null with 0

Q43. How to create a Quick LOD expression?

Select 1 option(s):

Control-click (or Command-click on a Mac) the measure you want to aggregate and drag it to the dimension you want to aggregate on.

Right-click on the selected measure and select Create > LOD Calculation.

Click on the selected measure, go to the Analysis menu, and select Quick LOD

Click the drop-down icon on the data pane and select Create Calculated Field

Q44. Choose the correct steps to create this scatter plot

Select 4 option(s):

Drag the Profit measure to Rows.

Drag the Category dimension to Color on the Marks card.

Drag the Sales measure to Rows.

Drag the Category dimension to Size on the Marks card.

Drag the Sales measure to Columns.

Drag the Order ID dimension to Details on the Marks card.

Q45. What needs to create a pie chart?

Select 2 option(s):

At least 1 dimension

At least 1 measure

1 or 2 measures

1 or 2 dimensions