Which of the following are the options to export the data used to build the view / visualisations?

• A.CSV file
• B.PDF File
• C.JSON format
• D.MS Access Database

Correct Answer: D

Explanation
You can export the data in a Tableau data source, including all or part of the records from your original data.
Alternatively, you can export only the portion of data used to generate the view.
Since the question mentions the data used to build the view, we'll focus on that :
*Export data in the view to Microsoft Access or .csv*
Export the data that is used to generate the view as an Access database (Windows only) or .csv file (Mac only).
1) In Tableau Desktop, select Worksheet > Export > Data.
2) Select a location and type a name for your Access database or .csv file.
3) Click Save.
4) If you're on Windows, the Export Data to Access dialog box displays to give you the option to immediately use the new Access database and continue working in Access without interrupting your work flow.

Comment: *

Name: *

Email: *

Verification: *

For creating variable sized bins we use __________________

• A.Calculated Fields
• B.Table Calculations
• C.Sets
• D.Groups

Correct Answer: A

One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0-5, 6-10, 11-15, and so on. Then you can count the number of people in each age group.
Create a calculated field for variable bin size
Step 1
Select Analysis > Create Calculated Field.
Step 2
In the Calculated Field dialog box, complete the following steps:

Comment: *

Name: *

Email: *

Verification: *

You want to provide additional information when hovering over a field in the Data pane as shown in the following exhibit.

What should you configure for the field?

• A.An alias
• B.A header label
• C.A hierarchy
• D.A default comment

Comment: *

Name: *

Email: *

Verification: *

Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?

• A.68,620
• B.74,683
• C.37,455
• D.46,493

Correct Answer: C

If you answered this question quickly and correctly, you're well prepared for the exam! Most students stumble while creating a Dual axis chart, so go ahead and give yourself a pat on the back!
To create a dual axis chart for the problem mentioned:
1) Drag Product Type to the column shelf, and Sales and Profit to the Row shelf:

2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:


3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:

4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.

Now the chart looks like this:

Now we change the Profit chart type to line:


5) Finally, we synchronise the axis as follows: Right click on the axis, and choose 'Synchronise axis'

And, our final view and answer is:

Comment: *

Name: *

Email: *

Verification: *

Which two filter modes can you use with dimension filters? Choose two

• A.Multiple Values (drop-down)
• B.At most
• C.Wildcard Match
• D.Range of Values

Comment: *

Name: *

Email: *

Verification: *