You have the following three versions of an Azure SQL database:
Test
Production
Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?

• A.Create a JSON file that contains the database server names. Import the JSON file to the dataset.
• B.Create a parameter and update the queries to use the parameter.
• C.Create a query for each database server and hide the development tables.
• D.Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.

Comment: *

Name: *

Email: *

Verification: *

You have a query that returns the data shown in the following exhibit.

You need to configure the query to display the data as shown in the following exhibit.

Which step should you use in the query?

• A.=Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".
  Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta
  [Serialized.Text = true] in type {itemType}}}), "classes")
• B.= Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})
• C.= Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
• D.= Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None),
  {"classes.1"})

Comment: *

Name: *

Email: *

Verification: *

Hotspot Question
You are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time.
How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a report page that contains the visuals shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: cross-filter
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.
Box 2: cross-highlight
Example:
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.

1. Let's see what happens when we select Moderation.

2. Cross-filtering removes data that doesn't apply. Selecting Moderation in the doughnut chart cross-filters the line chart. The line chart now only displays data points for the Moderation segment.
3. Cross-highlighting retains all the original data points but dims the portion that does not apply to your selection. Selecting Moderation in the doughnut chart cross-highlights the column chart. The column chart dims all the data that applies to the Convenience segment and highlights all the data that applies to the Moderation segment.
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions

Comment: *

Name: *

Email: *

Verification: *