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

Explanation:

The correct order of the three actions is:

Add the date to the Columns shelf. Add the segment and the sales to the Rows shelf.

Aggregate the date to month and year.

From the Analytics pane, drag Forecast to the worksheet.

The first action is to add the date to the Columns shelf and the segment and the sales to the Rows shelf. This will create a line chart that shows the daily sales by segment over time. You can use the Show Me menu to choose a line chart if it is not selected by default.

The second action is to aggregate the date to month and year. This will group the daily sales into monthly sales and show the yearly trend. You can right-click on the date field on the Columns shelf and select Month (January 2017) from the menu. You can also drag Year from the Dimensions pane to the Columns shelf before or after Month.

The third action is to drag Forecast from the Analytics pane to the worksheet. This will add a forecast that predicts future sales by segment based on historical trends. You can customize the forecast by clicking on it and using the options on the Marks card.

The other options are not relevant for this scenario. Adding a trend line would show a linear or nonlinear relationship between two measures, but not a prediction of future values. Creating a calculated field that uses the model quantile function would return a value from a statistical model based on a given quantile, but not a forecast.

Reference:

https://help.tableau.com/current/pro/desktop/en-us/analytics.htm

https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm

https://help.tableau.com/current/pro/desktop/en-us/dates.htm

https://help.tableau.com/current/pro/desktop/en-us/analytics_forecast.htm

https://help.tableau.com/current/pro/desktop/en-us/functions_functions_statistical.htm#MODEL_QUANTILE

Explanation:

Sales: B. Columns

Profit: D. Rows

Customer Name: C. Detail on the Marks card

Category: A. Color on the Marks card

To create the visualization, you need to drag Sales to Columns, Profit to Rows, Customer Name to Detail on the Marks card, and Category to Color on the Marks card. This will create a scatter plot that shows the relationship between Sales and Profit for each Customer Name, with different colors for each Category.

Reference:

https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/buildexamples_scatter.htm

Explanation:

Replace Data Source

Replace Data Source is a feature that allows you to replace one data source with another one that has the same or similar fields and structure. It updates all the worksheets that use the original data source with the new one, without reloading the data. In this case, you want to replace the data source that contains order data from 2019 with the one that contains order data from 2020.

To replace the data source, you need to do the following steps:

Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the original data source.

Click on the drop-down arrow next to the data source name at the top of the page and select Replace Data Source from the menu. This will open a dialog box that allows you to replace your data source with another one.

Select the data source that contains order data from 2020 from the list of available data sources and click OK. This will replace your original data source with the new one and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.

Reference:

https://help.tableau.com/current/pro/desktop/en-us/datasource_replace.htm

https://help.tableau.com/current/pro/desktop/en-us/datasource_replace_workbook.htm