You have the following dashboard that contains two visualizations.

You want to show only visualization at time. Users must be able to switch between visualizations.

What should you me?

Reveal Solution Hide Solution

Open the link to Book1 found on the desktop. Open the Line worksheet.

Modify the chart to show only main and max values of both measures in each region.

Reveal Solution Hide Solution

Open the link to Book1 found on the desktop. Open Disciplines worksheet.

Filter the table to show the Top 10 NOC based on the number of medals won.

Reveal Solution Hide Solution

Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.

Create a histogram on the Quantity field by using bin size of 3.

Reveal Solution Hide Solution

You have the following dataset in Microsoft Excel.

You are using interpreter to cleans the dataset.

Data interpreter provides the following results.

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

Reveal Solution Hide Solution

DRAG DROP

You conned to a Microsoft SQL Server database

You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned

How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Select

Where

The correct way to complete the query is:

SELECT * FROM [dbo] . [Students]

WHERE [Students].[City] = ‘Berlin’

The SELECT statement is used to retrieve data from a table or a view. The * symbol means that all columns will be returned. The FROM clause specifies the table or view name and the schema name. The WHERE clause is used to filter the data based on a condition. The condition is [Students].[City] = ‘Berlin’, which means that only rows where the City column of the Students table is equal to ‘Berlin’ will be returned.

The other options are not relevant for this query. CAST is a function that converts a value from one data type to another. JOIN is a clause that combines data from two or more tables based on a common field. ON is a keyword that specifies the join condition. UNION is a set operation that combines the results of two or more queries into one result set.

Reference:

https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/t-sql/queries/where-transact-sql?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver15#join

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-union-transact-sql?view=sql-server-ver15

From Tableau Desktop you sign in lo a Tableau Server site.

What appears in the list of available data sources when you search for a published data source?

Reveal Solution Hide Solution

You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis. You need to configure be shapes to be much larger than the line.

What should you do?

Reveal Solution Hide Solution

You publish a dashboard tut uses an attract. The extract refreshes every Monday at 10:00.

You need to ensure that the extract also refreshes on the last day of the month at 18:00.

What should you do?

Reveal Solution Hide Solution

Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.

Create a filed map to show the distribution of total Sales by State across the United States.

Reveal Solution Hide Solution