You have the following dataset that contain null values in the Profits field.

You want the data to appear as shown in the following table.
Which two formulas achieve the goal? Choose two.

• A.ZN ([Profits])
• B.ISNULL ([Profits])
• C.IFNULL [(profits] ,0)
• D.IF [Profits] != null then [Profits] END

Comment: *

Name: *

Email: *

Verification: *

You subscribe to a view that delivers a daily email to your inbox.
You want to make the subscription available to other stakeholders.
What should you do?

• A.From the dashboard overview page, modify the subscription.
• B.From the My Content overview page, modify the alert.
• C.From the worksheet, modify the subscription.
• D.From the My Content overview page, modify the subscription.

Comment: *

Name: *

Email: *

Verification: *

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.)

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.
References: 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

Comment: *

Name: *

Email: *

Verification: *

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.)

Correct Answer:

Explanation:

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Left only
• B.Union
• C.Inner
• D.Left
• E.Full outer

Comment: *

Name: *

Email: *

Verification: *