- (Topic 3)
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.

1. A. Furnishings
2. B. Tables
3. C. Chairs
4. D. Accessories
5. E. Copiers
6. F. Machines G Phones
7. G. Bookcases

Correct Answer: BDF

- (Topic 3)
A Data Analyst has a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.
The analyst wants to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do not match any values in Table2. The field values from Table2 must appear as null values.
Which type of join should the analyst use?

1. A. Inner
2. B. Left only
3. C. Left
4. D. Full outer
5. E. Union

Correct Answer: B

- (Topic 3)
You have a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.
The following is a sample of the data.

You want to improve the performance of the views by including only animals of a particular type.
To which filter should you add the Type field on the worksheet?

1. A. Dimension filler
2. B. Table calculation filter
3. C. Context filter
4. D. Measure filter

Correct Answer: C

- (Topic 3)
You are creating a new dashboard.
You need to add a button to the dashboard that allows users to export the dashboard as an image.
Which type of object should you use?

1. A. Image
2. B. Ask Data
3. C. Extension
4. D. Download
5. E. Navigation

Correct Answer: C

- (Topic 3)
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

1. A. SUM{[Sales]) IN (50000)
2. B. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
3. C. MAX< [Sales], 50000)
4. D. [Sales] > 50000

Correct Answer: BD