You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID])
Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.
What should you do?

• A.Add a description of "subscriber count" to the Customer Count measure.
• B.Add a synonym of "subscriber" to the Customer table.
• C.Add a description of "Subscriber" to the Customer table.
• D.Set Summarize By to None for the CustomerlD column.

Comment: *

Name: *

Email: *

Verification: *

You have an API that returns more than 100 columns. The following is a sample of column names.
* client_notified_timestamp
* client_notified_source
* client_notified_sourceid
* client_notified_value
* client_responded_timestamp
* client_responded_source
* client_responded_sourceid
* client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: Table.RemoveColumns
When you do "Remove Columns" Power Query uses the Table.RemoveColumns function Box 2: List.Select Get a list of columns.
Box 3: Text.Contains
Example code to remove columns with a slash (/):
let
Source = Excel.Workbook(File.Contents("C: Source"), null, true),
#"1_Sheet" = Source{[Item="1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"1_Sheet", [PromoteAllScalars=true]),
// get columns which contains any slash among values
ColumnsToRemove =
List.Select(
// get a list of all columns
Table.ColumnNames(#"Promoted Headers"),
(columnName) =>
let
// get all values of a columns
ColumnValues = Table.Column(#"Promoted Headers", columnName),
// go through values and stop when you find the first occurence of a text containing a slash
// if there is a value with a slash, return true else false
ContainsSlash = List.AnyTrue(List.Transform(ColumnValues, each Text.Contains(_, "/"))) in ContainsSlash ),
// remove columns
Result = Table.RemoveColumns(#"Promoted Headers", ColumnsToRemove)
in
Result
Reference:
https://community.powerbi.com/t5/Power-Query/Remove-columns-containing-a-certain-value/td-p/759657

Comment: *

Name: *

Email: *

Verification: *

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.
What should you recommend?

• A.For every report, create and use a single shared dataset that contains the standardized data.
• B.Create a shared dataset for each standardized entity.
• C.Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.
• D.For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

Comment: *

Name: *

Email: *

Verification: *

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A.Add the same slicer to each page and configure Sync slicers.
• B.Edit the interactions of the KPI visualization.
• C.Configure a page-level filter.
• D.Edit the interactions of the slicer that is on the same page as the KPI visualization.
• E.Configure a report-level filter.

Comment: *

Name: *

Email: *

Verification: *

You have a table that contains sales data and approximately 1,000 rows.
You need to identify outliers in the table.
Which type of visualization should you use?

• A.pie chart
• B.scatter plot
• C.donut chart
• D.area chart

Comment: *

Name: *

Email: *

Verification: *