Exam Questions Flashcards
1
Q
You plan to get data from flat files for a Power BI dataset.
You need to select a location to store the files.
Which location requires an on-premises data gateway?
a) OneDrive for Business
b) Personal OneDrive account
c) SharePoint Online Team Sites
d) Shared folder on a local network
A
a) OneDrive for Business
b) Personal OneDrive account
c) SharePoint Online Team Sites
d) Shared folder on a local network
The shared folder on a local network will require a gateway as it is not available to the internet. SharePoint Online, OneDrive, and OneDrive for Business all can be refreshed as cloud data sources without a gateway.
2
Q
You have multiple Excel files stored in a folder synced with OneDrive for Business.
You need to import data from the files. The solution must NOT use a data gateway.
Which type of connector should you use?
Select only one answer.
A) Excel workbook
B) Folder
C) SharePoint folder
D) SharePoint list
A
A) Excel workbook
B) Folder
C) SharePoint folder
D) SharePoint list
A SharePoint folder is the only connector that will allow the import of multiple Excel (or CSV) files stored in a OneDrive for Business folder, without using a data gateway. While you can connect to the folder on an on-premises device, it would require a data gateway to refresh in the service. An Excel workbook would only connect to a single Excel file and would also require a data gateway. A SharePoint list connector only connects to SharePoint lists and cannot connect to Excel files.
3
Q
From Power BI Desktop, you create a data source by importing an Excel file that contains 10,000 rows.
You plan to identify data anomalies within the data source.
You need to ensure that column distribution considers all rows in the Excel file.
What should you do?
A) In the Data Source Settings, modify the Advanced settings.
B) In the Data Source Settings, modify the Edit Permissions settings.
C) In the Power Query Editor window, enable the Column Profile view.
D) In the Power Query Editor window, modify the Query Settings.
A
A) In the Data Source Settings, modify the Advanced settings.
B) In the Data Source Settings, modify the Edit Permissions settings.
C) In the Power Query Editor window, enable the Column Profile view.
D) In the Power Query Editor window, modify the Query Settings.
By default, Power BI uses the top 1,000 rows for profiling. To ensure that column distribution considers all rows in the Excel file, you need to modify the Power Query Editor profiling status setting. The Power Query Editor settings, Advanced settings, and Permissions settings have no bearing on the profiling characteristics.
4
Q
From Power BI Desktop, you create a data source by importing an Excel file.
You plan to identify data anomalies within the data source.
Which interface should you use to display the column distribution and column quality graphs?
A
A) Advanced Editor in Power Query Editor
B) Power Query Editor
C) the Data view
D) the Model view
Power Query Editor provides the ability to display the column distribution and column quality graphs. Data view provides access to data within a dataset. Model view provides access to the data model of a dataset. Advanced Editor of Power Query Editor provides the ability to work with the M code used for shaping data in Power Query Editor.
5
Q
You create a report with Power BI Desktop. You are tasked with distributing the report to both internal and external recipients in your organization. The report has the following requirements:
• To be accessible from IOS and Android mobile devices
• To maximize branding and other look and feel aspects
You need to select a distribution option for the report.
Which distribution option should you use?
Choose the correct answer
A) Share the report from Power BI Service.
B) Package content and publish an app.
C) Share a workspace that includes the report.
D) Publish to web and use embed code.
A
A) Share the report from Power BI Service.
B) Package content and publish an app.
C) Share a workspace that includes the report.
D) Publish to web and use embed code.
6
Q
You have a query that retrieves data from a table that contains more than 8,000 rows of data.
In Power Query Editor, you notice that the column statistics for each column shows a count of exactly 1,000.
You need to ensure that the column statistics for each column shows the statistics based on all rows that are returned by the query.
What should you do?
A) Add a Table.Buffer applied step to the query.
B) Change the query load type from Import to DirectQuery.
C) Create a Top N row count parameter for the query.
D) From the query window, select Column profiling on the entire dataset.
A
A) Add a Table.Buffer applied step to the query.
B) Change the query load type from Import to DirectQuery.
C) Create a Top N row count parameter for the query.
D) From the query window, select Column profiling on the entire dataset.
Selecting column profiling for the entire dataset will change the column profiler to analyze the entire query dataset. Adding a Table.Buffer applied step will only cache the entire query in memory during refresh. The query load type in the model will not impact how many rows are used by the column profiler. Using a Top N row count applied step or applying a parameter will not change how the column statistics feature calculates.
7
Q
You are analyzing query data by using Power Query Editor.
You need to ensure that the Column statistics are based on an analysis of the entire dataset.
What should you do?
Select only one answer.
A) Change the query connection type from Import to DirectQuery.
B) From the status bar, change profiling status to entire dataset.
C) In Power Query Editor, enable column profiling from the View ribbon.
D) Load the data into the data model.
A
A) Change the query connection type from Import to DirectQuery.
B) From the status bar, change profiling status to entire dataset.
C) In Power Query Editor, enable column profiling from the View ribbon.
D) Load the data into the data model.
By default, column profiling is only based on the first 1000 rows of the preview. Changing the column profile status to entire dataset will query the entire dataset for the column profiling information.
8
Q
“prompt”
You have an Excel spreadsheet that contains three columns labeled Year, 2021, and 2012. The entries in rows for the first column consists of names of the individual months in the year while the other two columns contain the sales amount for each month for the corresponding year.
You import data from the Excel spreadsheet into Power BI Desktop.
You need to transform the data so it will consist of three columns, with the first one containing month, the second containing year, and the third containing the sales amount for that month and year.
Which transformation should you use first?
Select only one answer.
A) Pivot
B) Remove Columns
C) Transpose Table
D) Unpivot
Clarifier
Footnote
A
A) Pivot
B) Remove Columns
C) Transpose Table
D) Unpivot
Selecting Unpivot will allow you to shape the current table into the one with the year, month, and sales amount columns, which will need to be renamed afterwards. Pivot would be applicable in the opposite scenario, in which flat data needs to be reorganized into one containing aggregate values for each unique value in each column. Transposing would switch rows and columns. Removing columns would result in a table with insufficient data to perform unpivot.
Answer - Clarifier
Answer - Footnote
9
Q
You have a query named FactSales that retrieves data from a SQL Server table.
You need to update the query to prevent new columns that may be added to the table in the future from getting imported during dataset refreshes.
You select the existing columns in the query.
Which two applied steps can you use in Power Query Editor to achieve the goal? Each correct answer presents a complete solution.
Select all answers that apply.
A) Choose Columns
B) Remove Columns
C) Remove Other Columns
D) Transpose
A
A) Choose Columns
B) Remove Columns
C) Remove Other Columns
D) Transpose
Using the Choose Columns and Remove Other Columns options will allow you to explicitly select the columns that you want to keep. This enforces the requirement that new columns will not be automatically added in the future. Using Remove Columns will delete the existing columns in the table, and new columns that get added in the future will still be imported automatically. Transpose treats rows as columns, and columns as rows. It will not limit the number of columns being imported.
10
Q
You have a query that has a column named Country and columns for each month of sales data. The names of the sales data columns use a format of Month Year, for example January 2022. The month columns contain the Sales Amount values for each month.
You need to reshape the table to have all sales amount values in a single column.
A new column should also be added and contain the relevant month year for each row of data.
What should you do from the Power Query Editor?
``` Select only one answer.
A) Select the Country column and then select Pivot Column.
B) Select the Country column and then select Unpivot Other Columns.
C) Select the first sales data column and then select Unpivot Columns.
D) Select Transpose.
~~~
A
A) Select the Country column and then select Pivot Column.
B) Select the Country column and then select Unpivot Other Columns.
C) Select the first sales data column and then select Unpivot Columns.
D) Select Transpose.
``` Selecting Unpivot Other Columns will unpivot all current and future month/year columns into a new sales data column. Transposing treats rows as columns, and columns as rows. It will not create a single sales data column. Selecting Unpivot Columns in the first sales data column will successfully unpivot these columns into a new single column for sales data, but the other sales month/year columns will not be included in the new sales column. Pivoting the data takes values on rows in a column and turns them into new columns.
11
Q
You have a Power BI data source that contains the following tables:
ProductCategory: Lists the product category ID and category name
ProductSubcategory: Lists the product subcategory ID, subcategory name, and the related category ID
ProductList: Lists the product ID, name, and subcategory ID
You need to optimize the data to create a dimension for use in a star schema data model.
How should the tables be transformed before loading into the model?
Select only one answer.
A) Import all three tables into the data model and connect them using relationships.
B) Import only the ProductName table into the model.
C) Merge the queries to create a single loaded table for Product.
D) Use the append command to create a single loaded table for product.
A
A) Import all three tables into the data model and connect them using relationships.
B) Import only the ProductName table into the model.
C) Merge the queries to create a single loaded table for Product.
This answer is correct.
D) Use the append command to create a single loaded table for product.
A star schema should have a single table for each dimension or product, so using the combine command is what is required to create a single product table and aim towards a star schema design.
Combine multiple tables into a single table - Training | Microsoft Learn
12
Q
You have an Excel spreadsheet that contains two columns as follows:
Category: Contain names of categories
Subcategory: Contain names of subcategories for each category
You import the Excel spreadsheet into Power BI Desktop.
You need to transform the data to meet the following requirements:
Have multiple columns, where one column represents one category
Have a single row that includes the total count of subcategories for each category
Which transformation should you use?
A) Pivot Columns
B) Rename Columns
C) Transpose Table
D) Unpivot Columns
A
A) Pivot Columns
B) Rename Columns
C) Transpose Table
D) Unpivot Columns
The pivot column operation converts data into a table by aggregating values in a column. In this case, you can pivot the columns to calculate the count of product subcategories in each product category. The unpivot column operation performs the opposite task, converting columns into rows. Renaming columns would result in a table with different column names but the same data content. Transposing would simply switch rows and columns, without the required aggregation.
13
Q
You have a fact table that contains sales data.
The fact table includes a SalesDate column formatted as a Date data type. Auto date/time setting is disabled in both global and current file options.
You load the fact table into Power BI Desktop.
You need to ensure that you are able to analyze data on a yearly, quarterly, monthly, weekly, and daily basis. Your solution must minimize the model size and administrative effort.
What should you do?
A) Add a separate date dimension table.
B) Add a year, month, and week columns to the fact table.
C) Enable the Auto date/time current file option.
D) Enable the Auto date/time global option.
A
A) Add a separate date dimension table.
B) Add a year, month, and week columns to the fact table.
C) Enable the Auto date/time current file option.
D) Enable the Auto date/time global option.
Adding a separate date dimension table that includes year, month, and week information is the optimal approach which provides the required functionality, while minimizing the model size and administrative effort. Adding a year, month, and week columns to the fact table would increase the amount of administrative effort. Enabling the Auto date/time global or current file option would increase the model size. In addition, it would not provide the ability to describe weekly time periods (only year, quarter, month, and day).
14
Q
You have a Power BI model with the following fact tables and storage modes.
```FactStoreSales (Import mode)
FactOnlineSales (DirectQuery mode)
You have a dimension table named DimCalendar that has a relationship to both fact tables.
~~~
You need to assign a storage mode for DimCalendar. The solution must minimize the time to execute queries that combine data from the dimension table and the fact tables.
Which storage mode should you use?
A) DirectQuery
B) Dual
C) Import
D) none
A
A) DirectQuery
B) Dual
C) Import
D) none
Using Dual mode means that either an import query can be run when accessing data from FactStoreSales, or a DirectQuery query can be run when accessing data from FactOnlineSales. Using Import mode means the queries are only optimized for FactStoreSales (Import). Using DirectQuery mode means the queries are only optimized for FactOnlineSales (DirectQuery). A storage mode of Import, DirectQuery, or Dual must be assigned.
15
Q
You connect Power Query Editor to a database table.
You need to remove the Row ID column. Your solution must ensure that new columns do NOT display in the table model during a scheduled refresh in the future.
What transformation should you use?
A) Select Row ID, then use the Remove Other Columns command.
B) Use the Remove Column command on the Row ID column.
C) Use the Select Columns command and chose the columns to keep.
D) Use the Transpose command, then filter the rows to remove Row ID.
A
A) Select Row ID, then use the Remove Other Columns command.
B) Use the Remove Column command on the Row ID column.
C) Use the Select Columns command and chose the columns to keep.
D) Use the Transpose command, then filter the rows to remove Row ID.
Only the Select Columns command will let you choose columns to keep, delete the columns you do not want, and prevent new columns from showing up in the table in the future.
16
Q
You have designed a star schema to simplify your data.
You need to understand the relationship between the tables in the star schema.
What is the relationship between the fact table and dimension tables?
A) many-to-many
B) many-to-one
C) one-to-many
D) one-to-one
A
A) many-to-many
B) many-to-one
C) one-to-many
D) one-to-one
There is a many-to-one relationship between a fact table and dimension table. For each row in a dimension table there may be multiple matching rows in the fact table.
17
Q
You have the following Power Query M formula that generates a range of dates.
= List.Dates(#date(2020,05,31), 365, #duration(1,0,0,0))
What is the resulting date range?
A) a list of days ending on May 31, 2020 and starting 365 days earlier
B) a list of days starting on May 31, 2020 and ending 365 days later
C) a list of months ending in May 2020 and starting 12 months earlier
D) a list of months starting in May 2020 and ending 12 months later
A
A) a list of days ending on May 31, 2020 and starting 365 days earlier
B) a list of days starting on May 31, 2020 and ending 365 days later
C) a list of months ending in May 2020 and starting 12 months earlier
D) a list of months starting in May 2020 and ending 12 months later
The #date element designates the starting date, 365 designates the duration counter, and #duration(1,0,0,0) designates the duration interval in days, so this formula results in a listing of days starting on May 31, 2020 and ending 365 days later.
18
Q
You plan to use the calculated table functionality to add a duplicate table in Power BI Desktop.
Which characteristics of the original table will be duplicated?
A) data and column visibility only
B) data and hierarchies only
C) data, hierarchies, and column visibility
D) data only
A
A) data and column visibility only
B) data and hierarchies only
C) data, hierarchies, and column visibility
D) data only
A calculated table only duplicates data. Any model configurations such as column visibility or hierarchies must be recreated if needed.
19
Q
You create a data model in Power BI Desktop that contains DAX calculated columns and measures. You now need to create a report.
In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used? Each correct answer presents a complete solution.
A) as a filter in the “Filters on this page” well of the Filters pane
B) as a filter in the “Filters on this visual” well of the Filters pane
C) as an item in the “Add drill-through fields here” well of the Visualizations pane
D) as an item in the Fields well of a slicer
A
A) as a filter in the “Filters on this page” well of the Filters pane
B) as a filter in the “Filters on this visual” well of the Filters pane
C) as an item in the “Add drill-through fields here” well of the Visualizations pane
D) as an item in the Fields well of a slicer
```Unlike a measure, a calculated column can be used in a slicer to place filter options on the report page. DAX measures cannot be placed in the “Filters on this page” well. They can only be placed per visual, in the “Filters on this visual” well of the Filters Pane. Both DAX columns and measures may be used as a visual-level filter. Both DAX columns and measures can be used in the drillthrough well.
~~~
20
Q
You need to develop a quick measure in Power BI Desktop.
Which two elements can you use? Each correct answer presents a complete solution.
Select all answers that apply.
A) Calculations
B) Conditional columns
C) Data Analysis Expression (DAX) queries
D) Fields
E) Power Query M functions
A
A) Calculations
B) Conditional columns
C) Data Analysis Expression (DAX) queries
D) Fields
E) Power Query M functions
When creating a quick measure in Power BI Desktop, you apply calculations to fields. You do not explicitly create a DAX query, but you choose calculations and fields, which result in automatic generation of a DAX query. Conditional columns are separate from quick measures. Unlike quick measures, they create a value for each row in a table and are stored in the .pbix file. Power Query M functions are not directly accessible from the Quick Measure interface.
21
Q
You have a Power BI Desktop dataset that includes a table named Warehouse. The Warehouse table includes a column named Inventory Count, which contains the current number of items for each row of a particular type on a given day.
You have the following Data Analysis Expression (DAX) query that calculates the sum of all values in the Inventory Count column of the Warehouse table:
Current Inventory Count =
CALCULATE (
SUM ( ‘Warehouse’[Inventory Count] ))
You need to ensure that Current Inventory Count returns only the current total number of inventory items, rather than the sum of all inventory items that includes item counts from previous days.
What DAX function should you include in the query?
Select only one answer.
A) CALENDAR
B) CALENDARAUTO
C) DISTINCTCOUNT
D) LASTDATE
A
A) CALENDAR
B) CALENDARAUTO
C) DISTINCTCOUNT
D) LASTDATE
```The LASTDATE function will ensure that the SUM function applies only to the last date of the time period, resulting in a semi-additive behavior. The DISTINCTCOUNT function counts the number of distinct values in a column, which results in additive behavior. The CALENDAR function returns a table with a column named Date that contains a contiguous set of dates based on the start date and end date that you specify. The CALENDARAUTO function returns a table with a column named Date that contains a contiguous set of dates based on data in the model.
~~~
22
Q
You need to use DAX quick measures to generate results to use in a report.
Which type of DAX quick measure calculations will NOT work against a DirectQuery table?
Select only one answer.
A) aggregate per category
B) mathematical operations
C) time intelligence
D) X-functions
A
A) aggregate per category
B) mathematical operations
C) time intelligence
D) X-functions
Time intelligence functions have performance implications and are disabled for quick measures against DirectQuery tables. Mathematical operations, aggregate per category, and X-functions are all supported against DirectQuery.
23
Q
You need to reduce the cardinality of a column in a Power BI dataset.
What should you do?
Select only one answer.
A) Add a prefix to each value in the column.
B) Add a suffix to each value in the column.
C) Replace null values with a value of 0.
D) Reduce the number of distinct values
A
A) Add a prefix to each value in the column.
B) Add a suffix to each value in the column.
C) Replace null values with a value of 0.
D) Reduce the number of distinct values
```A column that has a lot of repeated values and a low number of distinct values will have a low cardinality. Reducing the number of distinct values reduces cardinality. Replacing nulls does not change the number of distinct values. A static prefix or suffix does not change cardinality.
~~~
24
Q
You plan to run Power BI Desktop Performance Analyzer.
You need to ensure that the data engine cache will NOT impact the test results without restarting Power BI Desktop.
What should you do first?
Select only one answer.
A) Add a blank page to the .pbix file and select it.
B) Connect DAX Studio to the data model.
C) Invoke the Clear Cache function.
D) Invoke the Refresh Metadata function.
A
A) Add a blank page to the .pbix file and select it.
B) Connect DAX Studio to the data model.
C) Invoke the Clear Cache function.
D) Invoke the Refresh Metadata
DAX Studio, once connected to the data model, can be used to clear the data engine cache. The Clear Cache function can be invoked from DAX Studio, once you connect it to the data model. The Refresh Metadata function can be invoked from DAX Studio to update the metadata of the currently selected model. Adding a blank page to the .pbix file and selecting it is the first step in clearing the visual cache, not the data engine cache.
25
You have Power BI Desktop.
You need to determine query timings for a report page visual.
Which method should you use?
Select only one answer.
A) Refresh the data model.
B) Run the Best Practices analyzer in Tabular Editor.
C) Use Session Diagnostics from the Power Query Editor.
D) Use the Performance analyzer.
A) Refresh the data model.
B) Run the Best Practices analyzer in Tabular Editor.
C) Use Session Diagnostics from the Power Query Editor.
**D) Use the Performance analyzer.
**
```
The Performance analyzer will show the query timings for each object on a report page. Session diagnostics measures Power Query query performance as it relates to refresh times. It is unrelated to measuring DAX performance or report page query timings. The Best Practices analyzer reviews the model for best practices around things like model design, relationships, field naming conventions, and measures. But is unrelated to any query timings for report page visuals.
```
26
You decide to start using variables when creating DAX formulas.
What are two benefits of using variables in DAX measures over using original expressions? Each correct answer presents a complete solution.
Select all answers that apply.
A) allows users to change the data source connection in the DAX measure
B) has additional functions that can be used in the DAX measure
C) improves the overall performance of the resulting DAX measure
D) improves the overall readability of the resulting DAX measure
A) allows users to change the data source connection in the DAX measure
B) has additional functions that can be used in the DAX measure
**C) improves the overall performance of the resulting DAX measure
D) improves the overall readability of the resulting DAX measure**
```
Variable names are often shorter than the original expressions, and the final variable returned at the end of the measure will be more readable with variable names included. Variables cache the defined calculation, allowing it to be referenced multiple times without additional impacts from recalculations. The functions in DAX are universal, and there are no specific functions that can only be used within variables. The data source connection is set in the model and cannot be changed from within a DAX measure.
```
27
You have a Power BI Desktop PBIX file that contains a single page report with multiple visuals.
You plan to use Performance Analyzer to evaluate the performance of the visuals.
You need to eliminate the impact of visual caching during the evaluation.
What should you do first?
Select only one answer.
A) Add a blank page to the PBIX file.
B) Connect DAX Studio to the data model.
C) Reopen the PBIX file.
D) Start recording.
**A) Add a blank page to the PBIX file.**
B) Connect DAX Studio to the data model.
C) Reopen the PBIX file.
D) Start recording.
```
To eliminate the impact of visual caching during a performance evaluation when using Performance Analyzer to evaluate the visuals, you must first add a blank page to the report, select that page, and then reopen the PBIX file. Connecting DAX Studio to the data model is the first step to clear the data engine cache. Recording should not be started until both the visual cache and the data engine cache are cleared.
```
28
You have a Power BI Desktop dataset based on a star schema data source.
You need to use Data Analysis Expression (DAX) to create a date table in the dataset and populate the table with a range of dates based on the earliest and latest date within the dataset.
Which function should you use?
Select only one answer.
A) CALENDAR
B) CALENDARAUTO
C) DATE
D) DATEDIFF
A) CALENDAR
**B) CALENDARAUTO**
C) DATE
D) DATEDIFF
```
The CALENDARAUTO function generates a range of dates based on the earliest and latest date within the dataset. The CALENDAR function generates a range of dates, but it requires providing the start and end date. The DATE function returns the specified date in the datetime format. The DATEDIFF function returns an interval between two dates.
```
29
you are creating a report in a Power BI Desktop by using a dataset that contains sales data.
You need to create a measure that always provides the value of total sales for the year 2022, regardless of which year is selected in any visual in the same report.
Which DAX function should you use in combination with the SUM function to override the context and provide the result?
Select only one answer.
A) CALCULATE
B) FILTER
C) IGNORE
D) SUMX
**A) CALCULATE**
B) FILTER
C) IGNORE
D) SUMX
```
The CALCULATE function provides the result of the calculation with the ability to override the context. The IGNORE function modifies the behavior of the SUMMARIZECOLUMNS function by omitting specific expressions from the BLANK/NULL evaluation. The FILTER function returns a table that represents a subset of another table or expression. The SUMX function returns the sum of an expression evaluated for each row in a table.
```
30
You plan to create a report in Power BI Desktop.
You need to create a visualization to display a running total. The solution must meet the following requirements:
* The initial and the final value columns must start on the horizontal axis.
* The intermediate values must be floating columns.
Which type of visualization should you use?
Select only one answer.
A) combo
B) funnel
C) scatter
D) waterfall
A) combo
B) funnel
C) scatter
**D) waterfall**
```
A waterfall visualization is a chart that displays a running total, with the initial and the final value columns starting on the horizontal axis while the intermediate values are floating columns. A combo visualization is a chart that combines a column chart and a line chart and can have one or two Y axes. A funnel visualization is a chart that has sequential connected stages, where items flow sequentially from one stage to the next. A scatter visualization is a chart with two value axes, with one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis.
```
[Design Power BI reports - Training | Microsoft Learn ](https://learn.microsoft.com/en-us/training/modules/power-bi-effective-reports/)
31
You plan to create a report in Power BI Desktop.
You need to identify the type of visualization that displays data as a set of nested rectangles.
Which visualization should you use?
Select only one answer.
A) bar chart
B) column chart
C) slicer
D) treemap
A) bar chart
B) column chart
C) slicer
**D) treemap**
```
A treemap visualization displays data as a set of nested rectangles. A slicer visualization is available in different formats, including list, drop-down, and buttons, but not nested rectangles. A bar chart visualization presents data as horizontal bars. A column chart presents data as vertical columns.
```
32
You need to create a custom R visual by using Power BI Desktop.
What do you need to do first?
Select only one answer.
A) Configure global R scripting options in Power BI Desktop.
B) Enable preview features in Power BI Desktop.
C) Enable the script visuals option in the Visualization pane of Power BI Desktop.
D) Install R on your computer.
A) Configure global R scripting options in Power BI Desktop.
B) Enable preview features in Power BI Desktop.
C) Enable the script visuals option in the Visualization pane of Power BI Desktop.
D) Install R on your computer.
33
You are editing a report in Power BI Desktop.
You need to adjust the behavior of the report by editing interactions.
Which two types of interaction behavior can you change between visuals? Each correct answer presents a complete solution.
Select all answers that apply.
A) drillthrough
B) expand
C) filter
D) highlight
A) drillthrough
B) expand
**C) filter
D) highlight**
```
A filter will show you the filtered data in this visual. Highlight is the default interaction between visuals. It shows you both the unfiltered and filtered values in the visual, for comparison purposes. Drillthrough is a page navigation experience that takes you from one page to another plus applies a set of filters to page navigated to. Expand is a way to navigate down a level using the hierarchy controls.
```
34
You are modifying a report in Power BI Desktop. The report contains a single report page that has three card visuals and one clustered bar chart.
You need to create a bookmark that displays only the clustered bar chart and hides the cards. The solution must minimize development effort.
What should you do first?
Select only one answer.
A) Add a bookmark in the Bookmarks Pane.
B) Hide the three cards in the Selection Pane.
c) Publish the report to the Power BI Service.
D) Select the Spotlight option on the clustered bar chart.
A) Add a bookmark in the Bookmarks Pane.
**B) Hide the three cards in the Selection Pane.**
c) Publish the report to the Power BI Service.
D) Select the Spotlight option on the clustered bar chart.
```Before you create a bookmark, you need to configure the report page to show the state you want to capture in the bookmark. Visuals are visible by default, therefore, you must mark them as hidden. To add a bookmark, you first need to update the bookmark after hiding the visuals. Bookmarks can be created in Power BI without publishing to the Power BI service. While spotlight does focus on the clustered bar chart, it does not completely hide the cards.
```
[Enhance Power BI report designs for the user experience - Training | Microsoft Learn](https://learn.microsoft.com/en-us/training/modules/power-bi-effective-user-experience/)
35
From Power BI Desktop, you open a Power BI report that contains three pages named Main, Error Rate, and On-time Rate.
You add a button to the Main page for navigation.
You need to implement a solution that meets the following requirements:
* The navigation destination must change based on the output of a DAX measure named [Error Rate].
* If [Error Rate] is greater than 5%, the button must display the text “Error Rate” and navigate to the Error Rate page.
* Otherwise, the button must display the text “On-time Rate” and navigate to the On-Time Rate page.
What three actions should you perform? Each correct answer presents part of the solution.
Select all answers that apply.
A) Create a DAX measure that outputs the correct page name based on the value of [Error Rate].
B) Set the button type to Page Navigation and then use conditional formatting to specify the destination.
C) Set the button type to Bookmark and then use conditional formatting to specify the destination.
D) Set the navigation destination to the Error Rate page.
E) Use conditional formatting to set the button text.
**A) Create a DAX measure that outputs the correct page name based on the value of [Error Rate].
B) Set the button type to Page Navigation and then use conditional formatting to specify the destination.**
C) Set the button type to Bookmark and then use conditional formatting to specify the destination.
D) Set the navigation destination to the Error Rate page.
**E) Use conditional formatting to set the button text.**
```To configure a button for conditional page navigation, you need to create a DAX measure that outputs the correct destination page name. Then configure the button to use page navigation and use the newly created DAX measure to specify the navigation destination. To change the button text to match the page name, conditional formatting must be used to set the text to equal the newly created DAX measure. No bookmarks are necessary. It is not necessary to set the destination to a specific page since conditional formatting is used to specify the destination.
```
36
You plan to build a Power BI report and set up conditional formatting of data fields.
You need to identify two visuals that support the conditional formatting functionality.
Which two types of visuals should you identify? Each correct answer presents a complete solution.
Select all answers that apply.
A) gauge
B) matrix
C) scatter chart
D) table
C) treemap
A) gauge
**B) matrix**
C) scatter chart
**D) table**
C) treemap
```Matrix and table visuals support conditional formatting. Gauge chart, scatter chart, and treemap do not support conditional formatting.```
37
You have a bar chart and column chart visual on a report page. Selecting any column from the bar chart visual filters the column chart data to less than 1% of its unfiltered value.
Which type of visual interaction should be used when the bar chart is filtering the column chart to ensure that you can easily see the data?
Select only one answer.
A) expand
B) drillthrough
C) filter
D) highlight
A) expand
B) drillthrough
**C) filter**
D) highlight
```
Filter will show you the filtered data in this visual. So even when showing filtered data that is less than 1% of the unfiltered value, it will still display well in the column visual. Highlight shows you both the unfiltered and filtered values in the visual, for comparison purposes. Drillthrough is a page navigation experience that takes you from one page to another plus applies a set of filters to page navigated to. Expand is a way to navigate down a level using the hierarchy controls.
```
38
You have a visual that is being cross-highlighted.
By default, what data will be displayed in a report tooltip?
Select only one answer.
A) a report page tooltip with cross-highlighted data
B) both the un-filtered and filtered (cross-highlighted) data
C) the filtered (cross-highlighted) data
D) the un-filtered (non-cross-highlighted) total data
A) a report page tooltip with cross-highlighted data
B) both the un-filtered and filtered (cross-highlighted) data
**C) the filtered (cross-highlighted) data**
D) the un-filtered (non-cross-highlighted) total data
```
By default, report tooltips will apply the filter from the cross-highlighted data into the tooltip. Report page tooltips need to be manually created and are not assigned to a visual by default.
```
39
You plan to use Power BI Desktop to analyze sales data of your company.
You need to identify two types of data you will be able to use for creating bins that group the sales data.
Which two data types should you identify? Each correct answer presents a complete solution.
Select all answers that apply.
A) Binary
B) Date/time
C) Numeric
D) Text
E) True/false
A) Binary
**B) Date/time
C) Numeric**
D) Text
E) True/false
```
Date/time and numeric data types support bins-based grouping. Binary, Boolean, and text data types do not support bins-based grouping.
```
40
You need to create a report in Power BI Desktop that will display the sales data of your company such that customers of a similar age will be grouped into clusters.
Which visual should you add to the report?
Select only one answer.
A) card
B) gauge
C) scatter
D) treemap
A) card
B) gauge
**C) scatter**
D) treemap
```
Creating a scatter visual is the first step of applying the clustering technique that groups data into clusters. Card, gauge, and treemap visuals do not support clustering.
```
41
You need to create a histogram that will display ranges of integers in groups.
Which two resources do you need to create the histogram? Each correct answer presents part of the solution.
Select all answers that apply.
A) a Bin group type
B) a Date/time column
C) a List group type
D) a Numerical column
**A) a Bin group type**
B) a Date/time column
C) a List group type
**D) a Numerical column**
The group is created against a numerical column using bins.
The Bin group type is an auto grouping of items into bucketed bins (groups). It will display well as a histogram. A DateTime column isn’t required to display histogram type data against a numerical column. A List group type is a manual grouping of items into new group names/categories. It doesn’t create auto (binned) groups.
[Explore statistical summary - Training | Microsoft Learn](https://learn.microsoft.com/en-us/training/modules/perform-analytics-power-bi/2-statistical-summary)
42
Question 41 of 50
Which native AI visual helps explain correlations for a metric within the dataset?
Select only one answer.
A) Decomposition Tree visual
B) Key influencers visual
C) Q&A visual
D) Smart Narrative visual
A) Decomposition Tree visual
**B) Key influencers visual**
C) Q&A visual
D) Smart Narrative visual
```
The Key influencers visual helps you understand correlated factors impacting a particular metric. The Q&A visual allows end-users to ask natural language questions to create AI generated charts based on the questions.
The Decomposition Tree visual lets you visualize data between multiple dimensions and drill down in any order. The Smart Narrative visual lets you combine natural language text with metrics from your model in sentence forms.
```
43
You plan to use Power BI Desktop to analyze sales data for products sold by your company.
You need to create a DAX formula that will list 10 best-selling products sorted by their total sales.
Which DAX function should you use?
Select only one answer.
A) MAXA
B) MAXX
C) RANKX
D) TOPN
A) MAXA
B) MAXX
C) RANKX
**D) TOPN**
```
The TOPN function returns Top N rows of the specified table, such as, for example, top 10 best-selling products sorted by their total sales. The MAXA function returns the largest value in a column. The MAXX function evaluates an expression for each row and returns the largest value. The RANKX function returns ranking of a number in a list of numbers for each row of a target table.
```
44
You need to create a Power BI dashboard.
Which tool should you use?
Select only one answer.
A) Power BI Desktop
B) Power Query Editor
C) the Power BI mobile app
D) the Power BI service
A) Power BI Desktop
B) Power Query Editor
C) the Power BI mobile app
**D) the Power BI service**
```
The Power BI service provides support for creating Power BI dashboards. The Power BI mobile app can be used to view dashboards, but not to create them. Power BI Desktop does not provide support for creating Power BI dashboards. Power Query is a Microsoft Excel tool that is used for importing data, but not for creating dashboards.
```
[Introduction to dashboards - Training | Microsoft Learn](https://learn.microsoft.com/en-us/training/modules/create-dashboards-power-bi/1-introduction)
45
You are evaluating whether you need to create a dashboard in Power BI.
In which scenario do you need a dashboard instead of a report in Power BI?
Select only one answer.
A) You need to add filters.
B) You need to add slicers.
C) You need to display visuals on multiple pages.
D) You need to display visuals that use different datasets.
A) You need to add filters.
B) You need to add slicers.
C) You need to display visuals on multiple pages.
**D) You need to display visuals that use different datasets.**
```
The ability to combine data from multiple datasets is one of the features that is available in dashboards but not supported in reports. Dashboards do not include the Filter, Visualization, and Fields panes that are available in Power BI Desktop when working with dashboards. Dashboards, unlike reports, contain only a single page.
```
46
You are creating a Power BI dashboard.
You need to apply a custom theme to the dashboard from another Power BI dashboard theme.
Which type of file should you use?
Select only one answer.
A) CSV
B) JSON
C) XML
D) YAML
A) CSV
**B) JSON**
C) XML
D) YAML
```
To copy themes between workspaces, you can download and upload them as JSON files. Themes use the JSON file format, not CSV, YAML, or XML.
```
47
You manage a Power BI workspace in shared capacity. The workspace contains a report that uses a dataset named DS1.
You need to implement an incremental refresh of DS1.
What should you do first?
Select only one answer.
A) In Power BI Desktop, define filter parameters.
B) In Power BI Desktop, define the incremental refresh policy.
C) Publish the dataset to the Power BI service.
D) Upgrade the Power BI workspace to the Premium SKU.
**A) In Power BI Desktop, define filter parameters.**
B) In Power BI Desktop, define the incremental refresh policy.
C) Publish the dataset to the Power BI service.
D) Upgrade the Power BI workspace to the Premium SKU.
```
To implement an incremental refresh of the dataset, you first need to define an incremental refresh policy, which, in turn, requires defining filter parameters. An incremental refresh policy does not require upgrading to a Premium SKU. Publishing the dataset to the Power BI service is required for the incremental refresh policy to take effect, so it's the last step of setting up an incremental refresh.
```
[Configure incremental refresh settings - Training | Microsoft Learn](https://learn.microsoft.com/en-us/training/modules/manage-datasets-power-bi/6-incremental-refresh)
48
You manage a Power BI workspace that includes a dataset with your company's sales data. You create a report that displays the sales data grouped by department.
You need to use row-level security to ensure that, once the report is published, employees in each department can only see the sales data for their department.
What should you do first?
Select only one answer.
A) Deploy the report to the Power BI service.
B) In Power BI Desktop, create a role.
C) In Power BI Desktop, define filter parameters.
D) Upgrade the Power BI workspace to the Premium SKU.
A) Deploy the report to the Power BI service.
**B) In Power BI Desktop, create a role.**
C) In Power BI Desktop, define filter parameters.
D) Upgrade the Power BI workspace to the Premium SKU.
```
To use row-level security to ensure that, once the report is published, employees in each department can only see the sales data for that department, you first need to create a role and a corresponding DAX expression. Filter parameters are used for other purposes, such as incremental refresh policy, not row-level security. Deploying the report to the Power BI service is required for the row-level security to take effect, so it takes place after creating the relevant roles. Row-level security does not require upgrading to the Premium SKU.
```
[Configure row-level security with the static method - Training | Microsoft Learn](https://learn.microsoft.com/en-us/training/modules/row-level-security-power-bi/2-static-method)
49
You have a collection of datasets and reports.
You need to share the datasets and report together. This solution must NOT send any email notifications to internal users after sharing.
What should you create in the Power BI Service?
Select only one answer.
A) a deployment pipeline
B) a workspace
C) an app
D) metrics
A) a deployment pipeline
B) a workspace
**C) an app**
D) metrics
```
Workspace apps can be installed automatically for any user in an organization, and without requiring notifications of installation. Deployment pipelines are used for moving artifacts between test, development, and production environments. Metrics are where you can create goals based off existing datasets. You can add members to a workspace, but they receive a notification that they’ve been added to the workspace.
```
[Distribute a report or dashboard - Training | Microsoft Learn](https://learn.microsoft.com/en-us/training/modules/create-manage-workspaces-power-bi/2-distribute-report-dashboard)
50
You have a Power BI Premium per user workspace.
What is the maximum number of refreshes that can be scheduled each day?
Select only one answer.
A) 1
B) 8
C) 16
D) 48
A) 1
B) 8
C) 16
**D) 48**
```
In a Premium per user workspace the limit is 48 refreshes per day for a dataset.
```
[Configure a dataset scheduled refresh - Training | Microsoft Learn](https://learn.microsoft.com/en-us/training/modules/manage-datasets-power-bi/5-dataset-refresh)
51
You have several on-premises Microsoft SQL Server databases.
You need to provide Power BI Service users access to the data sources without exposing the database servers directly to the internet.
The solution must minimize the configurations that must be performed by each user.
What should you deploy?
Select only one answer.
A) a virtual network data gateway
B) an ExpressRoute connection
C) an on-premises data gateway
D) an on-premises data gateway (personal mode)
A) a virtual network data gateway
B) an ExpressRoute connection
**C) an on-premises data gateway**
D) an on-premises data gateway (personal mode)
```
An on-premises gateway is designed to allow multiple users to access multiple data sources. An on-premises data gateway only allows one user to access multiple data sources. A virtual network data gateway is designed to allow multiple users to access multiple online data sources. However, it isn’t installed locally and only works with data sources secured by virtual networks.
```
[Use a Power BI gateway to connect to on-premises data sources - Training | Microsoft Learn](https://learn.microsoft.com/en-us/training/modules/manage-datasets-power-bi/4-power-bi-gateway)
[On-premises data gateway - Power BI | Microsoft Learn](https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem)
52
You use Power BI with Premium capacity assigned. You have a dataset containing employee key performance indicators (KPIs)
You create a Power BI report with a visual that shows employees with low-scoring Pls. You pin the visual to a dashboard and share the dashboard with users in Human Resources (HR).
HR users need to be able to generate a list of employees to investigate for poor performance and import that list into their HR syster
What should you do?
Choose the correct answer
A) Apply a sensitivity label in the dashboard settings.
B) Configure Cloud App Security.
C) Grant HR users the Build permission on the dataset.
D) Grant HR users the Reshare permission on the dataset.
A) Apply a sensitivity label in the dashboard settings.
B) Configure Cloud App Security.
C) Grant HR users the Build permission on the dataset.
D) Grant HR users the Reshare permission on the dataset.
```
You should grant HR users the Build permission on the dataset. You can export data from a visual in a dashboard to a CSV file. If you have filtered the visualization, then the .csv export will also be filtered. Users require the Build permission to export the underlying data of the visual to work with it outside of Power Bl. If a user has the Read permission on a workspace and dataset, then they can ex the data. The Build permission allows you to control whether users can download data from visuals without having to give access to the workspace.
You should not apply a sensitivity label in the dashboard settings. Sensitivity labels do not affect access to content within Power BI. Sensitivity labels are not applied to data exported to CSV, but only to Excel, PowerPoint, and PDF files.
You should not grant HR users the Reshare permission on the dataset. Reshare allows users to share a dashboard or a reportes Reshare does not allow you to export data from Power Bl.
You should not configure Cloud App Security. Cloud App Security allows you to monitor Power BI for user access and activity. Cloud App Security will prevent data from being exported to devices that do not meet your Azure AD Conditional Access policies. Cloud App Security will not enable HR users to download data from a Power Bl visual or disable them from doing so.
```
References
Export the data that was used to create a visualization
Build permission for shared datasets
How to apply sensitivity labels in Power BI
53
You create a new workspace named Department and publish your Power BI report to this workspace.
You need to distribute a report among the executives without giving them direct access to the workspace..
Which four options are essential for an app to be published for the first time? Each correct answer presents part of the solution.
Choose the correct answers
A) Click the Update app button.
B) Under the Permissions tab, specify users who can view the app.
C) Under the Navigation tab, provide the report name.
D) Click the Publish app button.
E) Under the Setup tab, provide the App name and description.
F) Select the department workspace
------
A) Click the Update app button.
B) Under the Permissions tab, specify users who can view the app.
C) Under the Navigation tab, provide the report name.
D) Click the Publish app button.
E) Under the Setup tab, provide the App name and description.
F) Select the department workspace
```
You should perform the following actions:
F) Select the department workspace
D) Click the Publish app button.
E) Under the Setup tab, provide the App name and description.
B) Under the Permissions tab, specify users who can view the app.
The workspace is newly created and no one is assigned any permissions for this workspace. The workspace needs to have content, as only then will it show the Publish app button.
You should first select the workspace named Department and click the Publish app button. If you have enabled the new look of the Power BI Service, you will be able to see the Create app button. If not, you will see the Publish app button.
You also need to provide an App name and description in the Setup tab. You do not need to provide anything in the Navigation tab because the report name is already filled in.
In the Permissions tab you should provide the email addresses of the users who you want to share this app with.
You should not click the Update app button. This button will only appear if you have already published the app. As mentioned previously, since we are publishing an app for the first time, we can only see the Publish app button. The Update app button allows you to update the content of an already published app.
You should not provide the report name under the Navigation tab. By default, the Navigation tab picks a name that is same as your report name in the workspace. This step is not essential. You can change this name if you want; however, this is an optional step.
```
54
You are the administrator for your company's Power BI tenant. You are using Power BI Premium Capacity in this tenant.
Some users are complaining that some datasets are slow to load or write.
You identified the following datasets that users are complaining about the most:
DatasetA: dataset used in operational reports with a data volume of 8 GB and growing.
DatasetB: dataset used in dashboards with summarized data from the last 12 months. It has a constant data volume of 150 MB and low usage.
DatasetC: dataset used by data scientists for experimentation with third-party tools. It has a constant data volume of 100 MB and a Read Write XMLA endpoint.
You need to determine which datasets you need to configure as a large dataset in order to improve overall performance. You should minimize costs.
Which datasets should you configure?
A) DatasetA and DatasetB only
B) DatasetA only
C) DatasetA and DatasetC only
D) DatasetA, DatasetB, and DatasetC
E) DatasetB only
A) DatasetA and DatasetB only
B) DatasetA only
**C) DatasetA and DatasetC only**
D) DatasetA, DatasetB, and DatasetC
E) DatasetB only
```
Large dataset is a feature from Power BI Premium that allows you to have Power BI models with sizes of up to 10 GB.
You should configure DatasetA as a large dataset. Based on the dataset size, you can improve overall performance by using the large dataset format. Since this dataset is growing, it may reach 10 GB soon, which is the maximum size for the small dataset storage format.
You should also configure DatasetC as a large dataset. Even though the dataset volume is small, using the large dataset storage format greatly improves the write performance that might be required for third-party tools that are using XMLA endpoints.
You should not configure DatasetB as a large dataset. This dataset volume is small and it has low usage. To minimize costs, you should investigate other causes that might be affecting the performance of this dataset.
```
55
You create a Power BI workspace in the new workspace experience.
You need to permit the following groups of users to access the workspace to perform specific actions on workspace content.
You must use the principle of least privilege.
Users in GroupA must be able to publish Power BI apps.
Users in GroupB must be able to publish Power BI reports.
UserC must be able to build reports using the workspace datasets in different workspaces without any additional configuration.
Which workspace role should you assign to the users?
To answer, drag the appropriate role to each user or user group. A role may be used once, more than once, or not at all.
Group A Contributor Member Admin Viewer
Group B Contributor Member Admin Viewer
User C Contributor Member Admin Viewer
Group A Contributor **Member** Admin Viewer
Group B **Contributor** Member Admin Viewer
User C **Contributor** Member Admin Viewer
```A user with the Member role can publish and update an app. The Contributor role cannot publish an app. A user with the Contributor role can create, update, and publish content including reports within a workspace. The Member role also has these privileges, but the Member role has additional privileges that are not required to publish a report.
Users in a workspace with the Contributor role automatically have Build permission for datasets in the workspace. The Build permission means that they can build new content, such as a report, on the dataset outside of the workspace.
You should not assign any of the users the Admin role. Users with the Admin role have full privileges on the workspace. The principle of least privilege means that if there is a role with fewer privileges that fulfils the requirements, that role should be used instead.
You should not assign any of the users the Viewer role. The Viewer role provides read access to the content in the workspace. A user with the Viewer role cannot create content or publish content in the workspace.
```
Distribute a report or dashboardWorkspaces in Power BI
Build permission for shared datasets
56
You need to configure data alerts for a dashboard. Which three visuals can you configure data alerts for? Each correct answer presents a complete solution.
A) Card visual
B) Gauge visual
C) Line visual
D) Matrix visual
E) KPI visual
**A) Card visual
B) Gauge visual**
C) Line visual
D) Matrix visual
**E) KPI visual**
```
You can configure data alerts for card, gauge, and KPI visuals. Data alerts are only available from the Power BI service and they can be configured for these three visuals. Data alerts allow you to send notifications when a certain limit is reached. For example, you can create an alert to send a notification when sales reach one million. You can also set alerts to send notifications if growth is negative.
Card visuals allow you to represent a single value, either text or number. They are used to highlight the importance of that attribute, like total sales in your report.
The Gauge visual allows you to track progress against a measurable goal. It can be used to visualize sales against the yearly target. It shows a dial that represents the progress made and a pointer that represents the target value.
The KPI visual allows you to track progress against a measurable goal. It can be used to visualize sales against monthly targets.You cannot configure data alerts for line or matrix visuals. A line chart plots a series of data points connected through a line. The Matrix visual allows you to show aggregated results in tabular form.
```
ReferencesConfigure data alertsData alerts in the Power BI service
57
You create multiple Power BI dashboards. You define the data classifications and tags. You need to show users how the data in the dashboards is classified. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Data classifications are defined at the tenant level. (Yes/No)
Access to dashboards with data classification configured is controlled by Azure Active Directory (AD) security groups. (Yes/No)
The data classification for a dashboard is always displayed. (Yes/No)
Data classifications are defined at the tenant level. (**Yes**/No)
Access to dashboards with data classification configured is controlled by Azure Active Directory (AD) security groups. (Yes/**No**)
The data classification for a dashboard is always displayed. (Yes/**No**)
```
Data classifications are defined at the tenant level. Data classification must be enabled for the tenant in the Admin Portal. Once you enable this feature, you can define the data classifications. One of the classifications must be set as the default classification. All existing dashboards will have the default classification defined.
Access to dashboards with data classification configured is not controlled by Azure Active Directory (AD) security groups. Data classifications apply to the entire organization and cannot be limited to specific groups. Users and security groups can apply data classification labels to Power BI content such as reports and dashboards. You cannot restrict a dashboard containing data classification labels based on membership of an Azure AD security group. All members of the organization will be able to see those labels.
The data classification for a dashboard is not always displayed. The data classification for a dashboard is only displayed if the administrator has checked the Show Tag option for the classification that the dashboard has been assigned to. If the Show Tag option is not checked, data classification will not be visible to users of the dashboard.
```
References
Configure data classification
Enable sensitivity labels in Power BI
How to apply sensitivity labels in Power BI
About the Admin portal
58
You implement a security role named EmployeeAddress to filter employees based on their login account in the Power BI service.
You need to add 100 users to this role so that they can view a report based on row-level security settings.
Which two actions should you perform? Each correct answer presents part of the solution.
A) Create a group in Power BI and assign users to this group.
B) Add the newly created security group to the EmployeeAddress security role.
C) Create a security group in Active Directory and assign users to this group.
D) Add the newly created Power BI group to the EmployeeAddress security role.
A) Create a group in Power BI and assign users to this group.
**B) Add the newly created security group to the EmployeeAddress security role.
C) Create a security group in Active Directory and assign users to this group.**
D) Add the newly created Power BI group to the EmployeeAddress security role.
```
You should create a security group in Active Directory and assign users to this group. Once the security group is created, you should add that security group to the EmployeeAddress security role. You can validate row-level security using the Test as role option. You can provide another user's email address to verify what they can see in the dashboard.
You should not create a group in Power BI. When you create a workspace, Power BI creates a group in Microsoft 365. You can assign users to these groups, but these groups are not supported for row-level security (RLS) role assignment.
```
59
You are a data analyst with a Contributor role in your company's workspace. You do not have an Administrator role or any other permissions at your company's Power BI tenant. You create a new report in Power BI Desktop.
The company's Power BI administrator enables content certification in your company's Power BI tenant.
You need to certify the report in your company's workspace. You should minimize the number of requests to the tenant administrator.
Which two actions should you perform? Each correct answer presents part of the solution.
A) Request that the Power BI administrator endorses the report as certified.
B) From Power BI Desktop, publish the report.
C) From the report settings, set the endorsement as certified.
D) Request that the Power BI administrator endorses the report as promoted.
E) From the report settings, set the endorsement as promoted.
**A) Request that the Power BI administrator endorses the report as certified.**
**B) From Power BI Desktop, publish the report.**
C) From the report settings, set the endorsement as certified.
D) Request that the Power BI administrator endorses the report as promoted.
E) From the report settings, set the endorsement as promoted.
```You should publish the report from the Power BI Desktop. You can only endorse content such as reports, datasets, dataflows, and apps that are already published to the Power BI service.
Then, you should request that the Power BI administrator endorses the report as certified. Endorsing content as certified means that the content meets the company's quality standards and that it can be considered reliable and ready to use across the organization. Only the tenant administrator or authorized reviewers should be able to certify content.
You should not set the endorsement as promoted from the report settings. Endorsing content as promoted allows you to communicate with your coworkers that the report is good enough to be used across the organization. You need at least the Contributor role in the workspace to endorse content as promoted.
You should not set the endorsement as certified from the report settings. Your current permission does not allow you to certify content in your company tenant by yourself.
You should not request that the Power BI administrator endorses the report as promoted. Your current permission in the workspace allows you to endorse the report as promoted without having to request this from the tenant administrator.
```
References
Endorse your content
Enable content certification
Roles in workspaces in Power BI
60
You need to assign the appropriate workspace roles to co-workers to perform certain tasks. You must use the lowest permission level necessary to accomplish the tasks. Which roles should you use? To answer, select the appropriate options from the drop-down menus.
To read workspace reports: Contributor Member Viewer
To publish content to the workspace: Contributor Member Viewer
To publish apps: Contributor Member Viewer
To read workspace reports: Contributor Member **Viewer**
To publish content to the workspace: **Contributor** Member Viewer
To publish apps: Contributor **Member** Viewer
```
You should assign the Viewer role to users to provide read-only access to reports. The Viewer role allows read-only access to the workspace.
You should assign the Contributor role to users so they are able to publish content to the workspace. The Contributor role allows you to create and edit content in the workspace and publish content to the workspace.
You should assign the Member role to users so they are able to publish apps. The Member role allows you to publish or update an app.
You should not assign the Admin role to users so they can publish content or apps. The Admin role allows you to publish or update an app with additional privileges to delete the workspace.
```
References
Distribute a report or dashboardWorkspaces in Power BI
61
You manage the Power BI admin portal. Company policy states that only specific people can create new workspaces. You have a security group named WorkspaceCreator. Some new users complain that they are unable to create new workspace. These users have already been added to the WorkspaceCreator security group.
You need to allow these users to create new workspaces within the stated guidelines. Which four actions should you perform in sequence in the Power BI admin portal? To answer, move the appropriate actions from the list of possible actions to the answer area and arrange them in the correct order.
Choose Workspace settings and select Block classic workspace creation.
Go to Power BI admin portal and navigate to Tenant settings.
Choose Workspace settings and select
Create workspaces (new workspace experience).
Under Apply to, choose Specific security groups, and add the WorkspaceCreator security group.
Click Apply.
You should perform the following actions in order:
**Go to Power BI admin portal and navigate to Tenant settings.
Choose Workspace settings and select Create workspaces (new workspace experience).
Under Apply to, choose Specific security groups, and add the WorkspaceCreator security group.
Click Apply.**
From the Power BI admin portal you can navigate to the Tenant settings page. There, choose Workspace settings and select the Create workspaces (new workspace experience) option. You can enable new workspace creation for the entire organization or only for specific users through security groups. The scenario states that you only need to allow specific users to create workspaces.
Under the Apply to option, choose specific security groups, and add the WorkspaceCreator security group. These new users are part of the WorkspaceCreator security group. Adding this group will give users permission to create workspaces.
Finally, click Apply to save and apply the tenant level changes.
Choose Workspace settings and select Block classic workspace creation. This option is used to restrict the creation of classic workspaces. If it is enabled, users will not be able to create a workspace using the classic experience. By default this option is disabled, allowing users to choose between classic and new workspace creation.
62
You have a dashboard tile that shows the manufacturing efficiency using a card visual. The manufacturing efficiency measure is formatted as a percentage. Your company requires a notification to be sent when efficiency drops below 70%.
You need to configure email alerts to meet this requirement.
Which three actions should you perform? Each correct answer presents part of the solution.
Choose Below in the Condition field and set the Threshold value to 70.
Use Microsoft Power Automate to trigger additional actions.
Choose Below in the Condition field and set the Threshold value to 0.7.
Choose More options on the Manufacturing efficiency card visual and click on Manage alerts.
Click the + Add alert rule button.
You should perform the following actions:
Choose More options on the Manufacturing efficiency card visual and click on Manage alerts
Click the + Add alert rule button
Choose Below in the Condition field and set the Threshold value to 0.7
You should perform the following actions:
**Choose More options on the Manufacturing efficiency card visual and click on Manage alerts
Click the + Add alert rule button
Choose Below in the Condition field and set the Threshold value to 0.7**
```
You can configure data alerts on a card visual using the Manage alerts option. You can add an alert rule button to define a rule for the alerts. You can choose the condition as Above or Below depending on the requirement, although in this scenario you should choose Below and set the threshold value to 0.7 because this is a percentage value. The Check the Send me email too checkbox is enabled by default and so the alert will send an email when the threshold is breached. You should not set the threshold value to 70. If you set the threshold value to 70, you would receive a notification when efficiency drops below 7000% and not 70% as indicated in this scenario.You should not use Microsoft Power Automate to trigger additional actions. You do not need to use Power Automate to send an email; the Power BI alerts include the capability to send emails.
```
References
Configure data alerts
Data alerts in the Power BI service
Integrate Power BI data alerts with Power Automate
63
You use Power BI Desktop to prepare data. You examine data quality in Power Query. You need to discover anomalies in the data. Which two options should you use? Each correct answer presents a complete solution.
A) Data connectivity mode
B) Column distribution
C) Column quality
D) Column profile
A) Data connectivity mode
**B) Column distribution**
C) Column quality
**D) Column profile**
You should use Column distribution. Data anomalies are outliers in the data. Finding the anomalies helps you identify what the normal distribution of the data looks like and it identifies data that should be investigated. The Column distribution option in Power Query shows the distribution of data, which allows you to find the anomalies.
You should also use Column profile. Column profile is an option in Power Query that shows the statistics and distribution of data in a column.
Column quality is an option in Power Query that shows the number and percentage of valid, error, and empty values in a column. Column quality does not assist in identifying anomalies.
The Data connectivity mode is the option you can use when connecting to data to set the storage mode as Import or Direct Query. The Data connectivity mode does not assist in helping find anomalies.
References
Profile data in Power BI
Using the data profiling tools
Manage storage mode in Power BI Desktop
64
You import an HR dataset into Power BI Desktop. You need to find distinct and unique rows for each column in a dataset appearing in a single view, as shown in the exhibit. Which data quality option should you use?
A) Column quality
B) Custom column
C) Column distribution
D) Column profile
A) Column quality
B) Custom column
**C) Column distribution**
D) Column profile
```
You should use the Column distribution option to check distinct and unique rows for each column in a dataset. Column distribution allows you to show distinct and unique values for each column in a single view. You should not use the Column profile option to check distinct and unique rows. Column profile allows you to analyze value distribution along with distinct and unique values for the selected column. You should not use the Column quality option to check distinct and unique rows. Column quality allows you to analyze valid, error, or empty values for all columns in a single view. You should not use the Custom column option to check distinct and unique rows. The Custom column option allows you to create a new column from Power Query editor, either by using an example or providing a column formula.
```
References
Profile data in Power BI
Data Profiling, Quality & Distribution in Power BI / Power Query
Add a custom column in Power BI Desktop
65
You import sales data using Power Query to apply a series of transformation steps after the query has been executed. There are errors, as shown in the exhibit named Rename Column step error and the exhibit named Cell error. You need to resolve the errors without losing any data. How should you resolve the errors? To answer, select the appropriate options from the drop-down menus.
Step-Level Error - Change the Data source settings. Remove the step from Query Settings. Use the Remove Errors feature. Use the Replace Errors feature.
Cell-Level Error - Change the Data source settings. Remove the step from Query Settings. Use the Remove Errors feature. Use the Replace Errors feature.
Step-Level Error - Change the Data source settings.** Remove the step from Query Settings. **Use the Remove Errors feature. Use the Replace Errors feature.
Cell-Level Error - Change the Data source settings. Remove the step from Query Settings. Use the Remove Errors feature.** Use the Replace Errors feature.**
You should remove the step from Query Settings. The error is probably caused by the column containing the error is no longer included within the data. The column has either been removed or renamed. By deleting the step, you can let the other transformations be applied.
You should not use the Remove Errors feature to fix the step-level error. This feature removes rows with errors. It does not solve an error in a step.
You should not change the Data source settings to fix the step-level error. Data source settings contain the data source type, its location, and credentials for accessing the data. Changing the data source settings will not resolve the step error. You should use the Replace Errors option to fix the cell-level error. This allows you to specify a replacement value for the cells in error. The data in the cell could not be converted to a numeric value. This is because the value contains alpha characters. Only one cell is affected, so this is not an operation error. You should not remove the column to fix the cell-level error. Removing the column will resolve the error, but you will lose all the data for that column.
You should not use the Remove Errors feature to fix the cell-level error. Remove Errors removes entire rows with errors in the selected column. This will resolve the error, but you will lose all the data for those rows.
References
Resolve data import errors
Error handling
Dealing with errors in Power Query
Error handling
Connect to data sources in Power BI Desktop
66
You are analyzing data quality for a dataset in Power BI. You use Power Query to preview the data.You need to examine the quality of the data.For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Using Column profile in Data Preview, you can gain an insight into only the first 1,000 rows in the dataset. (Yes / No)
You can use Column quality in Data Preview to analyze the entire dataset. (Yes / No)
You should enable Power Query background refresh to ensure that the preview data is up to date. (Yes / No)
Using Column profile in Data Preview, you can gain an insight into only the first 1,000 rows in the dataset. (Yes / **No**)
You can use Column quality in Data Preview to analyze the entire dataset. (**Yes** / No)
You should enable Power Query background refresh to ensure that the preview data is up to date. (Yes / **No**)
```
By default, you can use Power Query to examine the first 1,000 rows of your dataset, but you can change this configuration to analyze the whole dataset instead. This applies to the Column profile, Column distribution, and Column quality options in Data Preview.You can use Column quality in Data Preview to analyze the entire dataset. You can change the data preview to analyze the entire dataset. To change the number of rows analyzed, select the profiling status in the status bar and select Column profiling based on the entire data set.You should not enable Power Query background refreshto ensure that the preview data is up to date. This can result in preview data becoming out of date. The preview data is cached and not updated when the dataset is refreshed. You should disable background refresh by unchecking the Allow data preview to download in the background option in the Power BI Desktop options.
```
References
Profile data in Power BI
Data Profiling, Quality Distribution in Power BI / Power Query
Disable Power Query background refresh
67
Unique Vs Distinct
Unique values are the number of values that appear ONLY once.
Distinct values are the number of individual values without including the duplicates.
e.g.
```
a
b
b
c
c
```
Unique Count
One. There is only one value without duplicates.
Distinct Count
Three. There are three distinct (a, b, c).
68
You create a Power BI dataset from your organization's data warehouse using DirectQuery with the tables shown below:
```
Table Name Column name Data Type
Sales Order ID Whole number
Sales Order Date Date/time
Sales Customer ID Whole number
Sales Amount Decimal number
Sales Product ID Whole number
Customer Customer ID Whole number
Customer Name Text
Customer Segment Text
Customer Country Name Text
Product Product ID Whole number
Product Product Name Text
Product Product Type ID Whole number
Product Type Product Type ID Whole number
Product Type Product Type Name Text
```
You create a calculated table named Country from the dataset for unique values of country in the table named Customer. You generate visualizations for the sales data including showing sales by product manager. The product manager data is not in the data warehouse.
The product manager data is in an Excel workbook on your local computer as shown below:
```
Table Name Column name Data Type
Product Manager Product Name Text
Product Manager Product Manager Text
Product Manager Product Department Text
```
You do not have the Power BI on-premises gateway installed.You need to explain to a user when the data in the visualizations was last refreshed.When was the data in visualizations refreshed?
Visuals referring to the table named Country show show the values from (the latest values in the data warehouse.when the dataset was last refreshed.when the table was created.when the user pressed F5.when the user selected Refresh dashboard tiles.
when the dataset was last refreshed.)
Visuals referring to the Sales table show the values from (the latest values in the data warehouse.when the dataset was last refreshed.when the table was created.when the user pressed F5.when the user selected Refresh dashboard tiles.
when the dataset was last refreshed.)
Visuals referring to the Product Managers table show the values from (the latest values in the data warehouse.when the dataset was last refreshed.when the table was created.when the user pressed F5.when the user selected Refresh dashboard tiles.
when the dataset was last refreshed.)
Visuals referring to the table named Country show the values from when the dataset was last refreshed. Country is a calculated table based on the Sales table. Calculated tables are always imported and show the data when the dataset was last refreshed, even if the calculated table refers to a DirectQuery table.
Visuals referring to the Sales table show the values from the latest values in the data warehouse. The Sales table uses DirectQuery. DirectQuery always shows the latest data from the source data.
Visuals referring to the Product Managers table show the values from when the workbook was last loaded.Refresh is not supported for Excel workbooks imported from a local drive. If you need Excel data to be updated when the dataset is refreshed, you should move the worksheet to OneDrive for Business or install the Power BI on-premises gateway.
ReferencesUse composite models in Power BI DesktopData refresh in Power BIRefresh a dataset created from an Excel workbook on a local drive
69
Your company has a dataset that contains 5 million rows. The datasetcontains relevant information for stock movement prediction from portfolio analysis and historical stock prices for blue-chip companies. A few of these companies are your customers.
Your dataset should meet the following requirements:
The data source should be restricted to users who have authorized access.
Data should not be folded into other private data sources within the organization.
Data should not be folded into other data sources within the organization, including private data sources as well.
You need to assign the correct privacy level to the data in Power BI Desktop.Which privacy level should you apply?
A) Private
B) Organizational
C) None
D) Public
You should apply the Private privacy level setting to the data in Power BI Desktop. You can specify isolation levels for your dataset based on specific use case requirements. By selecting the Private setting, the data source will be restricted to users who have authorized access, and the data from this data source will not be folded into other private data sources within the organization. Additionally, this data will not be folded into other data sources within the organization, including private data sources. You can also use the Private privacy level when you work with specific organizational data, or private information that is important for your organization.You should not apply the Public privacy level setting. With this privacy level setting, the data source will be accessible by other data sources, and data can be folded into other data sources. Information that is publicly available, such as internet data sources, Wikipedia information, and other such relevant data, can be set toPublic. Another example would be free data from the Azure Marketplace. In this scenario, since the dataset contains important stock information data for some of the customers, you should not set it to Public.You should not apply the Organizational privacy level setting.Data sources set toOrganizationalcan fold in to private and other organizational data sources. Additionally,visibility is set to a trusted group of users, therefore this solution does not meet the scenario requirements.You should not use None. Data sources set to None means that no privacy level setting is assigned to this data source. This is not recommended for an important data set. In this scenario, this would be a ineffective privacy level setting.
References
Power BI Desktop privacy levels
This functionality is not implemented for this question.
**A) Private**
B) Organizational
C) None
D) Public
```You should apply the Private privacy level setting to the data in Power BI Desktop. You can specify isolation levels for your dataset based on specific use case requirements. By selecting the Private setting, the data source will be restricted to users who have authorized access, and the data from this data source will not be folded into other private data sources within the organization. Additionally, this data will not be folded into other data sources within the organization, including private data sources. You can also use the Private privacy level when you work with specific organizational data, or private information that is important for your organization.You should not apply the Public privacy level setting. With this privacy level setting, the data source will be accessible by other data sources, and data can be folded into other data sources. Information that is publicly available, such as internet data sources, Wikipedia information, and other such relevant data, can be set toPublic. Another example would be free data from the Azure Marketplace. In this scenario, since the dataset contains important stock information data for some of the customers, you should not set it to Public.You should not apply the Organizational privacy level setting.Data sources set toOrganizationalcan fold in to private and other organizational data sources. Additionally,visibility is set to a trusted group of users, therefore this solution does not meet the scenario requirements.You should not use None. Data sources set to None means that no privacy level setting is assigned to this data source. This is not recommended for an important data set. In this scenario, this would be a ineffective privacy level setting.
```
References
Power BI Desktop privacy levels
70
You are configuring row-level security (RLS) roles for a Power BI report.
You need to define which rows are available when creating a role.
What should you create?
A) DAX expression
B) Measure
C) M formula
D) Parameter
You should create a DAX expression to use as a filter for the RLS role. The expression will return true or false for records, and this determines which rows in the dataset are displayed for the user's role.You should not use Power Query and create an M expression. The M language is the data transformation language of Power Query. M is not used with RLS roles.You should not use measures. Measures are aggregations of data values and are often used as Key Performance Indicators (KPIs). Measures are not created when defining RLS roles.You should not use parameters. Parameters are used as query parameters with datasets or as what-if variables on reports. Parameters are not created when defining RLS roles.
References
Row-level security (RLS) with Power BI
Row-level security (RLS) guidance in Power BI Desktop
What is Power Query?
Create measures for data analysis in Power BI Desktop
Create and use parameters to visualize variables in Power BI Desktop
Edit parameter settings in the Power BI service
This functionality is not implemented for this question.
**A) DAX expression**
B) Measure
C) M formula
D) Parameter
```
You should create a DAX expression to use as a filter for the RLS role. The expression will return true or false for records, and this determines which rows in the dataset are displayed for the user's role.You should not use Power Query and create an M expression. The M language is the data transformation language of Power Query. M is not used with RLS roles.You should not use measures. Measures are aggregations of data values and are often used as Key Performance Indicators (KPIs). Measures are not created when defining RLS roles.You should not use parameters. Parameters are used as query parameters with datasets or as what-if variables on reports. Parameters are not created when defining RLS roles.
```
References
Row-level security (RLS) with Power BI
Row-level security (RLS) guidance in Power BI Desktop
What is Power Query?
Create measures for data analysis in Power BI Desktop
Create and use parameters to visualize variables in Power BI Desktop
Edit parameter settings in the Power BI service
71
You are a data analyst using Visual Studio Data Tools (VSDT).You create a new Power BI organization and a premium workspace named workspace1 for a new customer.
You plan to connect and deploy a tabular model project in workspace1.
What should you do first?
A) From Visual Studio Data Tools (VSDT), deploy the tabular model.
B) From Visual Studio Data Tools (VSDT), update the tabular model compatibility level to 1500.
C) From the Power BI Admin portal, configure the XMLA endpoint as Read Write.
D) From the Power BI Admin portal, configure the XMLA endpoint as None.
A) From Visual Studio Data Tools (VSDT), deploy the tabular model.
B) From Visual Studio Data Tools (VSDT), update the tabular model compatibility level to 1500.
**C) From the Power BI Admin portal, configure the XMLA endpoint as Read Write.**
D) From the Power BI Admin portal, configure the XMLA endpoint as None.
```
You should first configure the XMLA endpoint as Read Write from the Power BI Admin portal. By default, a premium workspace has the XMLA endpoint enabled as Read only. Before trying to deploy the tabular model from Visual Studio Data Tools (VSDT), you need to change the XMLA endpoint to Read Write.You should not update the tabular model compatibility level to 1500 from VSDT as a first step. After you have the XMLA endpoint enabled as Read Write, this may be the next step before deploying the tabular model. Power BI datasets require the tabular model compatibility level to be set as 1500 or greater.You should not deploy the tabular model from VSDT as a first step. You should deploy the model to Power BI only after configuring the XMLA endpoint as Read Write and after updating the tabular model compatibility level.You should not configure the XMLA endpoint as None from the Power BI Admin portal. This would disable the XMLA endpoint and you would not be able to connect to your Power BI workspace from VSDT.
```
References
Dataset connectivity with the XMLA endpoint
Troubleshoot XMLA endpoint connectivity
72
You use Power BI Desktop to prepare data.You import a set of data using Power Query.You need to identify whether a column contains only unique values.Which two Data preview options can you use to meet your goal? Each correct answer presents a complete solution.
A) Monospaced
B) Column quality
C) Column distribution
D) Column profile
A) Monospaced
B) Column quality
**C) Column distribution
D) Column profile**
```
You can use either Column distribution or Column profile to show if the values in a column are unique. Column distribution shows the distribution of data for all columns. Column profile shows statistics and the distribution of data for a column. The statistics include the number of unique values. You should be aware that the preview is based on the first 1,000 rows. You should select the Column profiling based on the entire data set to verify that the column contains unique values.Column quality shows the number and percentage of valid, error, and empty values in a column. Column quality does not show if the values are unique.Monospaced shows text with the same spacing and makes it easier to read values. Monospaced does not show if the values are unique.
```
References
Profile data in Power BI
Using the data profiling tools
Display Preview contents using a monspaced font in Power BI
73
You are a business intelligence developer. You need to use data contained in Azure Analysis Services to build your report. You need to connect this data source.
What two solutions can you use to achieve this goal?
A) Import
B) DirectQuery
C) Dual
D) Connect live
**A) Import**
B) DirectQuery
C) Dual
**D) Connect live**
```
You can use Connect live. It is used when connecting to multidimensional data sources, such as Analysis Services. Connect live is one of the two solutions available when connecting to Azure Analysis Services in Power BI Desktop.
You can also use Import. Connect live is preferred because there are some limitations with Import mode. Besides, Connect live will also refresh the data from Analysis Services automatically.
You should not use DirectQuery. This storage mode is not available for Analysis Services. You use DirectQuery with relational data sources such as SQL Server.
You should not use Dual mode. Dual mode can improve performance using either caching with the Import storage mode, or executing a join relationship with the DirectQuery storage mode.
Because DirectQuery is not supported, Dual is not supported for Analysis Services.
```
References
Get data from Azure Analysis Services
Connect with Power BI
Manage storage mode in Power BI Desktop
74
You are authoring a new report in Power BI Desktop.You notice that a visual using a specific table is not performing as quickly as expected.You need to log the duration of each step during the Power Query transformations for this table and the queries that Power BI sends to the underlying table data sources.Which tool should you use?
A) Session Diagnostics in Query Diagnostics
B) Step Diagnostics in Query Diagnostics
C) Data profiling tools
D) Performance Analyzer
**A) Session Diagnostics in Query Diagnostics**
B) Step Diagnostics in Query Diagnostics
C) Data profiling tools
D)Performance Analyzer
You should use Session Diagnostics in Query Diagnostics. You can use Session Diagnostics to record how Power BI interacts with your data source during the Power Query transformations. In Query Diagnostics, the results are presented as a table that you can query in Power BI to gather insights like which queries were sent to the data source, and how long each transformation step took to complete.You should not use Step Diagnostics in Query Diagnostics. You can use Step Diagnostics to evaluate how a single step works in Power Query. This is useful for a more detailed debugging of a given step.You should not use Performance Analyzer. You can use Performance Analyzer to analyze the performance of the elements in a report, such as visuals and DAX expressions.You should not use Data profiling tools. You can use Data profiling tools to preview the data quality of your table, such as the distribution of unique values on each column, or if you have a lot of null values or import errors in a column.
References
Query Diagnostics
Use Performance Analyzer to examine report element performance in Power BI Desktop
Using the data profiling tools
74
You are a business intelligence analyst for a worldwide organization. You create a Power BI report that shows sales for your organization. You need to provide a version of the report that filters the data for a single country.
Solution:
Add a report-level filter.
Share the report.
Check the Include my changes option.
Does this solution meet the goal?
No
Yes
No
**Yes**
```
This solution meets the goal. The Include my change option will share the filtered version of the report. This sharing option creates a bookmark to filter the report data. The URL emailed when you share the report includes the bookmark.The user will have access to the underlying dataset and so may be able to view data for other countries. If you need to restrict access to data from other countries, you should implement row-level security (RLS).
```
References
Share a filtered Power BI report
74
You are a business intelligence analyst for a worldwide organization. You create a Power BI report that shows sales for your organization. You need to provide a version of the report that filters the data for a single country.
Solution:
Add a parameter to the dataset for a country.
Add a query parameter specifying the parameter and country.
Does this solution meet the goal?
No
Yes
No
**Yes**
This solution meets the goal. You can define parameters in the dataset and define a country as a parameter. The report will show the data filtered by the parameter.You can specify the parameter to be a single country. In the data sources you can use the parameter to filter the data by country. The dataset, and the report, will only include data for that country.
References
Edit parameter settings in the Power BI service
Deep Dive into Query Parameters and Power BI Templates
74
74
You are a business intelligence analyst for a worldwide organization.You create a Power BI report that shows sales for your organization.You need to provide a version of the report that filters the data for a single country.
Solution: Add a query string parameter specifying the table/field and country.
Does this solution meet the goal?
No
Yes
No
**Yes**
```
This solution meets the goal. You can pass parameters in the URL as a query string. The report will show the data filtered by the parameters in the query string.Each report page has its own URL. Adding query string parameters to the URL will pre-filter the report. You can specify the table and fields in the query string and restrict the data based on the name of the country.The user will have access to the underlying dataset and so may be able to view data for other countries by editing the URL. If you need to restrict access to data from other countries, you should implement Row Level Security (RLS).
```
References
Filter a report using query string parameters in the URL
75
Cardinality
Cardinality is a term that is used to describe the uniqueness of the values in a column. Cardinality is also used in the context of the relationships between two tables, where it describes the direction of the relationship.
76
The Column distribution option on the View tab displayed statistics on...
Previously, when you used Power Query Editor to analyze the metadata, the Column distribution option on the View tab displayed statistics on how many distinct and unique items were in each column in the data.
Distinct values count - The total number of different values found in a given column.
Unique values count - The total number of values that only appear once in a given column.
77
Column Quality
Tells you: valid count, error count and empty count
78
Column Distribution
Distinct and Unique Counts
79
Column Profile
More details and statistics: You can see distribution info and quality info, but you also see values (and other statistics) not just counts.
80
You have a table of Purchase Orders (POs), a sample of which is shown in the exhibit. There are relationships with other tables on the PO Number, PO Date, and Vendor columns.You need to optimize model performance.
Which two actions should you perform? Each correct answer presents part of the solution.
A) Add a new column to the Purchase Order table and perform a lookup to set the Vendor Id from Vendor column.
B) Change the format of the PO Amount column to Currency.
C) Remove the PO prefix from the PO Number column and change the data type to Whole Number.
D) Mark the Purchase Orders table as the date table.
**A) Add a new column to the Purchase Order table and perform a lookup to set the Vendor Id from Vendor column.**
B) Change the format of the PO Amount column to Currency.
**C) Remove the PO prefix from the PO Number column and change the data type to Whole Number.**
D) Mark the Purchase Orders table as the date table.
```
You should remove the PO prefix from the PO Number column and change the data type to Whole Number. **The model will achieve the highest optimizations with numeric column data, which uses value encoding. Text columns use hash encoding that will adversely affect performance.**
You should also add a new column to the Purchase Order table and perform a lookup to set the Vendor Id from Vendor column. The column should use the following function:Vendor Id = LOOKUPVALUE(Vendor[Vendor Id],Vendor[Vendor],'Purchase Order'[Vendor]).You should then recreate the relationship using the Vendor ID and not the Vendor name. **Using numeric values in relationships instead of text will improve the model performance.**
You should not change the format of the PO Amount column. The format does not affect the performance of the model.
You should not make the Purchase Orders table the date table. A date table requires contiguous and unique dates. The Purchase Orders table does not meet either of these requirements. You should create a Date table separately.
```
References
Reduce cardinality
Data reduction techniques for Import modeling
Create date tables in Power BI Desktop
81
Cross Filter Directions
You should configure the cross-filter direction as Both. Using both for the cross-filter direction allows you to show the aggregate sales by territory when analyzing the data with other filters and labels.
The single cross-filter direction is used when the values at the many end of the relationship are being aggregated. Using single for the cross-filter direction will only allow you to filter by territory. You will not be able to filter on other values from the Customer and Sales tables and show aggregate sales by territory
82
Row-level security (RLS)
Row-level security (RLS) allows you to create a single or a set of reports that targets data for a specific user. It can be configured by using a static method or a dynamic method.
Note: Microsoft Power BI can help you secure reports and workspaces by allowing you to share them to active directory users and groups. You can also share a single report but have users see different data according to their job role.
Row-level security (RLS) uses a DAX filter as the core logic mechanism.
83
RLS involves several configuration steps, which should be completed in the following order:
* Create a report in Microsoft Power BI Desktop.
* Import the data.
* Confirm the semantic model between both tables.
* Create the report visuals.
* Create RLS roles in Power BI Desktop by using DAX.
* Test the roles in Power BI Desktop.
* Deploy the report to Microsoft Power BI service.
* Add members to the role in Power BI service.
* Test the roles in Power BI service.
84
Create Roles
To create RLS roles in Power BI Desktop, select the Modeling tab, and then select Manage Roles.
85
Should the RLS filter be applied to the dimension table or the fact table?
Notice how the DAX filter is applied on the dimension table. Row-level security performs better when the data is organized in a star schema. Apply the DAX filter to a dimension table, as was done with the Products table.
86
How do you add members to their role in Power BI service?
To add members to the role in Power BI service, go to your workspace in Power BI service. Find the semantic model that you created with the same name as your report. Select the ellipsis (...) button and then select Security.
Screenshot of the security button on the semantic model.
In the Row-Level Security screen, you can add Microsoft Entra ID users and security groups to the security role. When members are added to this role, the DAX filter that you previously defined will be applied to them. If members are not added to the role, but they have access to the report, RLS will not apply to them. You can add the three people in the Game department to the Game role. Now, when those members sign in, they will only see the report with data that applies to them.
87
userprincipalname
The userprincipalname() function will compare the email address from the Employees table with the email that the user entered when signing in to Power BI service. If Russel King uses the email address russel@tailwindtraders.com to sign in to Power BI service, the system will compare that value to the email address in the Employees table. Assuming that a relationship has been created between Employees and Sales, Russel will only see his four sales.
88
Differenced between Dashboards and Reports
**Dashboards
**Create only in service
Single page
Static tiles
Read-only tiles
**Reports
**Create in Power BI Desktop (limited in service)
Multiple pages
Interactive visuals
Filters pane
Dashboards are created by pinning report visuals, and are then called tiles within reports. When you make changes to the visuals in the report, and then republish to Power BI Service, changes are reflected on the dashboard.
89
What are data alerts?
Data alerts can notify you or a user that a specific data point is above, below, or at a specific threshold that you can set.
They are features that are only available on Power BI service and they're available on such report elements such as **KPI visuals, gauges,** and **cards**.
90
Quick insights
The Quick insights feature in Power BI uses machine learning algorithms to go over your entire semantic model and produce insights (results) for you quickly. This feature is a great way to build dashboards when you don't know where to start.
91
pin live report pages
Power BI allows you to pin live report pages to dashboards, ensuring that your visuals reflect real-time changes.
Pinning a report page is a simple way to pin all visuals at once. All slicers and filters still work and that the visuals have the same data as in the report. The visuals appear as a page, so there are no reformatting options.
Any changes that you make to the underlying report automatically show on the dashboard when the page is refreshed.
To pin an entire page, select the ellipsis (...) on the navigation bar of the report and then select Pin to a dashboard > (Select dashboard) > Pin live.
92
Promotion
Promotion - Promote your semantic models when they're ready for broad usage.
To promote content, you must have write permissions on the workspace where the content you want to promote is located.
To promote a semantic model, go to the workspace in Power BI service, and then open the settings page for the semantic model that you want to promote. In this example, you want to promote the Tailwind Traders semantic model.
Select the Endorsement setting.
93
Request certification
Certification - Request certification for a promoted semantic model. Certification can be a highly selective process, so only the truly reliable and authoritative semantic models are used across the organization.
94
Query Caching
Query Caching is a local caching feature that maintains results on a user and report basis. Query caching reduces load time and increases query speed, especially for semantic models that aren't refreshed often and are accessed frequently. This service is only available to users with Power BI Premium or Power BI Embedded.
95
What's a workspace in Power BI?
A workspace in Power BI is where you can house your reports in one location, make them shareable, collaborate with other teams, and update reports.
96
What are the Power BI workspace roles?
There are four roles for workspaces, and it's advised that you grant the minimum access necessary to collaborators. For consumers, skip workspace role assignment, and provide access through the app instead in the next section.
**Admin**
Update and delete the workspace
Add or remove people, including other admins
**Member**
Add members or others with lower permissions
Publish, unpublish, and change permissions for an app
**Contributor**
Create, edit, and delete content, such as reports, in the workspace
Publish reports to the workspace
**Viewer**
View and interact with an item
Read data that's stored in workspace dataflows
*Note*: If the workspace is backed by a Premium capacity, a non-Pro user can view content within the workspace under the Viewer role.
97
