QUESTION 13
You receive a tab-delimited data file name sales.tsv.
You need to connect to the file.
Which option should you select in Tableau Desktop?

QUESTION 14
You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset named Price Indices.
In which step can you transform rows of monthly data into rows of yearly data”

QUESTION 15
You have a data set that contains three columns named Sales, Profit, and Quantity.
You need to build the following scatter plot.

QUESTION 16
You want to ensure that when you click a bar on a dashboard, a tooltip appears that contains a link named
“Click here to know more!” as shown in the following exhibit.

QUESTION 17
You have a workbook that connects to a database. The database requires authentication.
You plan to publish the workbook and schedule a daily refresh of the data.
Which two conditions must be met to schedule the refresh? Choose two.

QUESTION 18
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.

QUESTION 19
A Data Analyst has the following dataset in Microsoft Excel.

The analyst is using Data Interpreter to cleanse the dataset. Data Interpreter provides the following results.

How many rows of data will be ingested into Tableau as values?

QUESTION 20
You have the following dashboard that contains two visualizations.

You want to show only one visualization at time. Users must be able to switch between visualizations.
What should you me?

QUESTION 21
You have a sales dataset that contains the following fields.

You need to analyze the average revenue per product in different regions over time.
Which two fields should be measures? Choose two.

QUESTION 22
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.

QUESTION 23
In a dataset, a Data Analyst has a string field named Category that contains unnecessary trailing spaces.
Which function should the analyst use to remove the trailing spaces from the Category field?

QUESTION 24
A Data Analyst has 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.

The analyst wants to ensure that every calculation is affected by including only animals of a particular type.
Which type of filter should the analyst create on the worksheet?

QUESTION 25
You have the following dashboard.

When a user selects a only on the map the data on the bar chart must show only the data for the selected city.
The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)

QUESTION 26
A Data Analyst is subscribed to several views.
The analyst needs to unsubscribe from the views.
What should the analyst use?

QUESTION 27
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.

QUESTION 28
You have a data source that contains the following columns.

You have the following view that shows the percentage of total sales by category:

You want to change the calculation to show the percentage of total sales within the categories of every region annually. Which Compute Using option should you use? (Click the appropriate Option in the Answer Area.)

QUESTION 29
You have the following dataset.
Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?

QUESTION 30
You plan to publish a workbook to Tableau Server.
You want to ensure that users can see other published dashboards from their current dashboard.
Which setting should you configure? (Click the appropriate Option in the Answer Area.)

QUESTION 31
You have the following visualization.

You want the count of Returns displayed only for the first year in the table.
How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

QUESTION 32
You have the following data source in tableau Server.

You need to ensure that the data is updated every hour.
What should you select?

QUESTION 33
You have a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.
You want 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 you use?

QUESTION 34
You have a Tableau workbook that has a live data source. The data source connects to a Microsoft SQL Server database. Only the users in your department can access the database.
You plan to publish the workbook to a Tableau Server site named Public. All the users in your company can access Public.
What are two ways to ensure that all the users can view the worksheets in the workbook? Choose two.

QUESTION 35
You have the following dataset.

You need to generate the results in the Day field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

QUESTION 36
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