Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

• A.25.79%
• B.23.39%
• C.27.73%
• D.29.49%

Correct Answer: C

Explanation
We need to use the concept of Groups for this question. Follow along:
1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:

2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:

3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:

We can see the answer already : 23.386% in the view above (even before grouping!)
4) Finally, we get the following view and our answer:

Comment: *

Name: *

Email: *

Verification: *

________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.

• A..tbm
• B..tds
• C..tde
• D..twb

Comment: *

Name: *

Email: *

Verification: *

When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.

• A.Regex Search
• B.Union Search
• C.Pattern Search
• D.Wildcard Search

Correct Answer: D

You can use Wildcard Search to set up search criteria to automatically include tables in your union. Use the wildcard character, which is an asterisk (*), to match a sequence or pattern of characters in the Excel workbook and worksheet names, Google Sheets workbook and worksheet names, text file names, JSON file names, .pdf file names, and database table names.
When working with Excel, text file data, JSON file, .pdf file data, you can also use this method to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page.

Comment: *

Name: *

Email: *

Verification: *

Given a map, which of the following fields can be placed on Size,Shape,Detail,Color

• A.Region, Country, Profit, State
• B.Sales, State, Country, Profit
• C.Profit, State, Number of Records, Sales
• D.Longitude, Country, State, Sales

Comment: *

Name: *

Email: *

Verification: *

Which of the following would you use to connect to multiple tables in a single data source at once?

• A.A Blend
• B.A Hierarchy
• C.A Set
• D.A Join

Correct Answer: D

The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data.
For example, consider the following two tables originating from a single data source:

We can combine these 2 tables, simply by joining the tables on ID to answer questions like, "How much was paid in royalties for authors from a given publisher?". By combining tables using a join, you can view and use related data from different tables in your analysis.

Comment: *

Name: *

Email: *

Verification: *