______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

• A.Joining
• B.Blending
• C.Combining
• D.Unioning

Correct Answer: D

Explanation
Unioning is the correct answer!
From the official documentation:

For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016" , "June2016" and "July2016."

Comment: *

Name: *

Email: *

Verification: *

Which of the following fields would be best used as Dimensions?

• A.Profit
• B.Names
• C.Categories
• D.Sales

Comment: *

Name: *

Email: *

Verification: *

Which of the following are valid ways of Grouping Data?

• A.Using Marks in the view
• B.Using Labels in the View
• C.From the Analytics Pane
• D.From the Dimensions Shelf

Correct Answer: A,B,D

**IMPORTANT QUESTION AND EXPLANATION, PLEASE READ**
3 ways to group data -
1) Marks
2) Labels
3) Dimensions shelf.
*IMPORTANT*
If we Group the data by selecting the marks, then they remain separate marks in the view and then have the same colour. Also, a new group is created in the Dimensions shelf. Example - Using the sample superstore dataset, first plot a bar chart showing sales for each sub-category:

Here, if we Select Phones, Chairs and Storage by selecting the MARKS (Bars), and then group them:

They remain seperate marks (BARS) but are grouped by the same colour.
Now, if we didn't do this, and rather grouped by selecting their Labels (Names):

Then they no longer remain separate Marks (bars) but are rather consolidated into a single Bar:

Finally, we can group directly from the Dimensions shelf as follows:

Now choose Phones, Chairs and Storage and Click Group:

You will now automatically have a new Dimension as follows:

Comment: *

Name: *

Email: *

Verification: *

The View Data window displays as much of the data as possible by default, up to _______________ rows.

• A.20,000
• B.5,000
• C.10,000
• D.15,000

Correct Answer: C

The View Data window displays as much of the data as possible by default, up to 10,000 rows. This can be increased though, if you wish to.

Read more: https://help.tableau.com/current/pro/desktop/en-gb/inspectdata_viewdata.htm

Comment: *

Name: *

Email: *

Verification: *

Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

• A.111,060
• B.1,461
• C.112,256
• D.1,222

Correct Answer: C

Explanation
If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.
To reach the correct answer, follow the steps below:
1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well!
Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!


* The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October

Comment: *

Name: *

Email: *

Verification: *