Which of the following are forecast quality metrics available in Tableau?

• A.RMSE
• B.MAPE
• C.AISE
• D.MASE

Comment: *

Name: *

Email: *

Verification: *

Connect to the "Covid data" source. What is the percentage increase in the new cases from July 2020 to Jan
2021?

• A.118.50%
• B.125%
• C.113.50%
• D.98%

Correct Answer: C

Create a filter on date field and select only July 2020 and Jan 2021.
Graphical user interface, application Description automatically generated

Drop Date Month Discrete to Columns and New cases to the Text.
Right-Click on New Cases field and Quick Table Calc ->Percent Difference Graphical user interface, application Description automatically generated

Graphical user interface, text, application, chat or text message Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

Groups can be used in a calculated field.

• A.True
• B.False

Correct Answer: A

Group can be used in a calculated field
Graphical user interface, text, application Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

Connect to the "World Cup Results" and use tables WorldCupMatches, WorldCups. Which of the following year had the highest percentage of Away goals? Consider only those years when the host country did not win the world cup.

• A.2010
• B.2002
• C.1994
• D.1934

Correct Answer: A

Explanation
In WorldCupMatches table, we have the information of Away goals, and in the WorldCups table, we have the information of the Winner team and goal scored.
In WorldCups, there is only row for each year. But in WorldCupMatches, there is a separate row for each match. This is the perfect example to use blend as here we need to first aggregate the data from WorldCupMatches table.
Let's establish the blend relationship between these two data sources, on the basis of Country and Year.

Let's use WorldCups as the primary data source, so add the field from this data source to the view. Drop Year to Rows and change it discrete. Drop Country and Winner field as well to the rows.

In WorldCupMatches data source, create a calculated field :
Drop this field to the Text, and format it so that it will be shown in percentage.
Out of the given options, only in 1934 host country won the world cup

2010 is the correct answer.

Comment: *

Name: *

Email: *

Verification: *

Connect to the "Significant Volcano Eruption" data source. How many volcano eruptions took place within 30 miles of the Black Peak volcano in the Alaska Peninsula?

• A.0
• B.1
• C.2
• D.3

Correct Answer: A

Add the Latitude to Rows and Longitude to columns. Or double click on these fields.
Don't use Latitude (generated)/Longitude (generated) fields.
Drop Location to filter and select 'Alaska Peninsula'
Drop Name to the Label Marks card.
Your view will look like this:
Map Description automatically generated

Use the radial selection tool to find the number of volcano eruptions that took place within 30 miles of the Black Peak volcano. You need to zoom-in first, only then you would be able to find the distance using a radial selection tool.
A picture containing chart Description automatically generated

There were no eruptions that took place with 30 miles of Black Peak.

Comment: *

Name: *

Email: *

Verification: *