You can _______________ your data to combine two or more tables by appending values (rows) from one table to another

• A.join
• B.blend
• C.concatenate
• D.union

Correct Answer: D

Explanation
You can union your data to combine two or more tables by appending values (rows) from one table to another.
To union your data in Tableau data source, the tables must come from the same connection.
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."

A union of these tables creates the following single table that contains all rows from all tables.

Comment: *

Name: *

Email: *

Verification: *

You have a continuous numeric measure named Sales.
Which chart type is created when you double-click the Sales measure?

• A.A text table
• B.A line chart
• C.A pie chart
• D.A bar chart

Comment: *

Name: *

Email: *

Verification: *

Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

• A.October
• B.September
• C.July
• D.June

Correct Answer: A

Follow along:
1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.
For sales, click on the pill -> choose Quick Table calculation -> Year over Year growth.
The view should now look like:

It is clear that October with -55.3% had the lowest Year on Year growth.

Comment: *

Name: *

Email: *

Verification: *

To connect Tableau to a CSV data source what type of connection should you use?

• A.Spatial
• B.Excel
• C.Text
• D.JSON

Correct Answer: C

Tableau recognises a CSV file as a TEXT file, and therefore it is the correct option.
The following are the steps to import a CSV file:
1) From the data connection screen, click on Text:

2) Choose the appropriate file, and click Open:

3) Finally, Tableau imports the data as shown below:

Comment: *

Name: *

Email: *

Verification: *

For a relative date filter, the default anchor is _________________

• A.The current time
• B.Today's date
• C.The target date
• D.The date we specify

Correct Answer: B

Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most recent data.
Step 1: Drag a date field to the filter shelf
Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.

Step 2: Select a time unit
In the Filter dialog box, click Relative dates, and then select the unit of time for the filter. For example, to show only the three most recent weeks, select Weeks.

Here, you can clearly see that the default date is TODAY

Comment: *

Name: *

Email: *

Verification: *