PL-300: Microsoft Power BI Data Analyst part 4

USERPRINCIPALNAME Dynamic roles allow you to define filtered views for a specific list of users with the DAX functions USERNAME or USERPRINCIPALNAME.

Which of the following functions allows you to define filtered views for a specific list of users? USER USERPRINCIPALNAME ROLE USERELATIONSHIP

From the Power BI settings, delete the embedded codes. "You discover that some of the visualizations contain data..." Remove the embedded code of the visualizations.

A data analyst publishes several Power BI visualizations to a blog. You discover that some of the visualizations contain data that is considered private by your company. You need to prevent the visualizations from being published to the blog. What should you do? From the Power BI Admin portal, disable the Publish to web setting. From the Power BI settings, delete the embedded codes. From the Power BI Admin portal, disable the Share content with external users setting. From the dashboard settings, modify the Share dashboard settings.

Yes The WHERE clause has its effects before the data is imported.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table. Solution: You add a WHERE clause to the SQL statement. Does this meet the goal?

Flat files Query folding is the ability for Power Query to generate a single query statement to retrieve and transform source data to improve the efficiency of the Power Query engines. Unfortunately, flat files do not support query folding.

If you wanted to implement incremental refresh for your company data, which of the following data sources must be avoided as it doesn't support query folding? Relational Databases Flat files SharePoint Lists Azure Active Directory

Yes, the roles will be combined for the user If a user is part of two roles, the RLS roles are combined for the individual.

Is it possible for a user to be a part of two RLS roles? Yes, the roles will be combined for the user Yes, but roles will need to access one at a time Yes, this is known as dynamic row level security No

Viewer Once RLS rules have been defined in Power BI Desktop, they can be applied to users who you've shared reports with or have Viewer permissions in Power BI Service.

RLS rules can be applied to users with which permission level? Admin Member Contributor Viewer

Roles filter data out of the model and limit what the audience can access Static roles allow you to define filtered views for specific audiences using simple DAX statements; they are not the same as bookmarks or pre-filtered views, as roles filter data out of your model and limit what audiences can access.

What is the main difference between a static role and a bookmark? Bookmarks filter data out of the model and limit what the audience can access Roles filter data out of the model and limit what the audience can access Bookmarks are only available in Power BI Service Roles are pre-filtered views of a report

Both Power BI Desktop and Power BI Service

Where can you test RLS by using different security roles? Power BI Desktop only Power BI Service only Both Power BI Desktop and Power BI Service

USERPRINCIPALNAME()

Which function will tell you the logged on username in the Power BI Service? LOOKUPVALUE() USERPRINCIPALNAME() USEROBJECTID()

All of the above Incremental Refresh is the process of reloading only the part of a dataset that may change over time and adding it to the rest of the data set that no longer changes, which includes all 3 of these benefits.

Which of the following is a benefit of incremental refresh? Faster refresh times More reliable Reduced resource usage All of the above

Scheduled refresh Scheduled refresh allows you to keep your Power BI reports up to date by automatically refreshing datasets based on a given frequency & time of day.

Which of the following options allows you to keep reports up to date by automatically refreshing datasets based on a frequency & time of day? Incremental refresh Scheduled refresh Data gateway Row level security

No Almost, but Remove Errors will not work. Needs to replace values.

You have a query for a table named Sales. Sales has a column named CustomerID. The Data Type of CustomerID is Whole Number. You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values. You need to ensure that nonnumeric values in the CustomerID column are set to 0. Solution: From Query Editor, select the CustomerID column and click Remove Errors. Does this meet the goal? Yes No

No Does not remove existing rights, just ability to gain new ones. You should prevent users to export data from here; Power Bi Admin Portal -> Tenant Settings -> Export data

You have a user named User1. User1 is a member of a security group named Contoso PowerBI. User1 has access to a workspace named Contoso Workspace. You need to prevent User1 from exporting data from the visualizations in Contoso Workspace. Solution: From the Microsoft Office 365 Admin center, you remove User1 from the All Users security group. Does this meet the goal? Yes No

No Developer settings are only for Apps and APIs. Therefore does not meet the goal.

You have a user named User1. User1 is a member of a security group named Contoso PowerBI. User1 has access to a workspace named Contoso Workspace. You need to prevent User1 from exporting data from the visualizations in Contoso Workspace. Solution: From the PowerBI setting, you modify the Developer Settings. Does this meet the goal? Yes No

Yes From the data security perspective, premium capacity could share to anyone (free end user), and assign role as "Viewer only".

You have an app workspace that contains a report. The report contains sensitive data. You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses. Solution: Purchase Power BI Premium P1, and then configure the app workspace to run in a dedicated capacity. Does this meet the goal? Yes No

No Workspace where users do not have access to MS Azure AD is a no.

You have an app workspace that contains a report. The report contains sensitive data. You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses. Solution: Configure the app workspace to be read-only for members and to run in a shared capacity. Does this meet the goal? Yes No

No IFrames can only be embedded into internal pages and need authentication, while the question wants to address external users.

You have an app workspace that contains a report. The report contains sensitive data. You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses. Solution: From Publish to web, generate an iFrame. Does this meet the goal?

Open the report b using Power BI Desktop. Edit the synonyms. Publish the report to App Workspaces. Update the app from powerbi.com Open->Edit->Publish->Update Workspace is where powerbi.com will pick up the edits.

From Power BI service, you publish an app that contains one dashboard and one report. Q&A is enabled on the dashboard. In Q&A, a user types the query count of clients and fails to receive any results. The user then types the query count of subscribers and receives the expected results. You need to ensure that the user can use both queries to receive the same results. Which four actions should you perform in sequence? Actions: Edit the dashboard settings from powerbi.com Enable and configure Data classification for dashboards Publish the report to App Workspaces. Update the app from powerbi.com Edit the synonyms. Open the report b using Power BI Desktop. Delete and publish the app.

No The filter is applied after the data is imported. Instead add a WHERE clause to the SQL statement.

You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table. Solution: From Power Query Editor, you import the table and then add a filter step to the query. Does this meet the goal? Yes No

No The filter is applied after the data is imported. Instead add a WHERE clause to the SQL statement.

You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table. Solution: You write a DAX expression that uses the FILTER function. Does this meet the goal? Yes No

No The filter is applied after the data is imported. Instead add a WHERE clause to the SQL statement.

You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table. Solution: You add a report-level filter that filters based on the order date. Does this meet the goal? Yes No

Create a blank query as a data source. Specify the following query, then close and apply. -Table.Profile(#"SalesDetail") Create a visual for the query table.

You are modeling data in a table named SalesDetail by using Microsoft Power BI. You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions. Which three actions should you perform? Actions: Create a blank query as a data source. Specify the following query, then close and apply. -Table.Distinct(#"SalesDetail") Create a visual for the query table. Create a parameter that uses a query for the suggested values. Create a query that uses Common Data Service as a data source. Specify the following query, then close and apply. -Table.Profile(#"SalesDetail")

Transpose the table Unpivot all the columns other than Measure Rename the Measure column as Year Change the data type of the Year column to Date

You are preparing a financial report in Power BI. You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit (see image). You need to prepare the data to support the following: - Visualizations that include all measures in the data over time - Year-over-year calculations for all the measures Which four actions should you perform in sequence? Actions: Rename the Attribute column as Year Rename the Measure column as Year Use the first row as headers Use headers as the first row Unpivot all the columns other than Measure Transpose the table Change the data type of the Year column to Date

Open the dashboard. Chage the dashboard view to Phone view. Pin items from the reports to the dashboard. Rearrange, resize, or remove items from the phone view.

You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones. You need to build the dashboard. Which four actions should you perform in sequence? Actions: Pin items from the reports to the dashboard. Rearrange, resize, or remove items from the phone view. Chage the dashboard view to Phone view. Open the dashboard. Create a phone layout for the existing reports.

Query folding is not occurring. "The dataset uses incremental refresh." Query folding cannot take place when using incremental refresh.

You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh. From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity. You discover that the dataset refresh fails after the refresh runs out of resources. What is a possible cause of the issue? Query folding is not occurring. You selected Only refresh complete periods. The data type of the column used to partition the data changed. A filter is missing on the report.

No Instead modify the source step of the queries to use DataSourceExcel as the file path. Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.

You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source. You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition. Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel. Does this meet the goal? Yes No

No Instead modify the source step of the queries to use DataSourceExcel as the file path. Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns. Same logic for WHERE clause. Modify = WHERE.

You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source. You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition. Solution: You create a new query that references DataSourceExcel. Does this meet the goal? Yes No

Yes Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.

You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source. You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition. Solution: You modify the source step of the queries to use DataSourceExcel as the file path. Does this meet the goal? Yes No

an On-premises data gateway When you've created dynamic reports in Power BI Desktop, you can share them by publishing to your Power BI site. When you publish a Power BI Desktop file with a live connection to a tabular model to your Power BI site, an on-premises data gateway must be installed and configured by an administrator.

You create a report by using Microsoft Power BI Desktop. The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company's internal network. You plan to publish the report to the Power BI Service. What should you implement to ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube? a subscription a scheduled refresh of the dataset an OData feed an On-premises data gateway

Publish the report to the Power BI service. Obtain an embed link for SharePoint. Add a webpart to a page. Publish->Obtain link->Add webpart

You create a report in Power BI Desktop. You need to embed the report into a Microsoft SharePoint Online site. Which three actions should you perform in sequence? Actions: Add a webpart to a page. Pin a visualization. Pin a live page. Obtain an embed link for SharePoint. Publish the report to the Power BI service.

Download and install an on-premises data gateway (personal). Configure the Gateway Connection settings for the dataset. Configure the Schedule Refresh settings for the dataset.

You have a Microsoft Excel workbook that contains two tables. From Power BI, you create a dashboard that displays data from the tables. You update the tables each day. You need to ensure that the visualizations in the dashboard are updated daily. Which three actions should you perform in sequence? Actions: Download and install an on-premises data gateway (personal). Configure the Gateway Connection settings for the dataset. Add subscriptions for the reports. Download and install Power BI Desktop. Configure the Schedule Refresh settings for the dataset.

Yes Aim is to have Power View sheets shown as Reports. That's done via Publish -> Export. Export workbook data to Power BI When you choose the Export option, any supported data in tables and/or a data model are exported into a new dataset in Power BI. Any Power View sheets in the workbook are re-created in Power BI as reports.

You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets. You need to recreate the Power View sheets as reports in the Power BI service. Solution: From Excel, click Publish to Power BI, and then click Export. Does this meet the goal? Yes No

Yes 1. Excel workbook -> publish -> "upload' -> PowerBI.com "connect" (view only in powerBI, only editable in Excel workbook) 2. Excel workbook -> publish -> "export' -> PowerBI.com "import" (sync both side, editable both side and updated both side)

You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets. You need to recreate the Power View sheets as reports in the Power BI service. Solution: From the Power BI service, get the data from SharePoint Online, and then click Import. Does this meet the goal? Yes No

The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020. When a report user is assigned to multiple roles, RLS filters become additive. It means report users can see table rows that represent the union of those filters.

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders. The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. City[State Province] = "Kentucky" Role2 contains the following filter. Date[Calendar Year] = 2020 If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model? The user will see data for which the State Province value is Kentucky and the Calendar Year is 2020. The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020. The user will see only data for which the State Province value is Kentucky. The user will receive an error and will not be able to see the data in the report.

DIVIDE When using the DIVIDE function, you must pass in numerator and denominator expressions. Keyword "Percentage" CALCULATE CALCULATE evaluates an expression in a modified filter context. ALLSELECTED ALLSELECTED removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.

You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date. The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table. You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent (see image).

User 1: Member User 2: Contributor

You have a Microsoft Power BI workspace. You need to grant the user capabilities shown in the following table (see image). The solution must use the principle of least privilege. Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. Roles Admin Member Contributor Viewer Answer Area User 1: User2:

Yes

You have a query for a table named Sales. Sales has a column named CustomerID. The Data Type of CustomerID is Whole Number. You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values. You need to ensure that nonnumeric values in the CustomerID column are set to 0. Solution: From Query Editor, select the CustomerID column. Click Replace Errors"¦ and enter a value of 0 Does this meet the goal? Yes No

From DashboardA, select the TileA options, and then select View Insights. From Focus mode, review the generated visuals. From Focus mode, pin the relevant visuals to DashboardA.

You have a Power BI dashboard named DashboardA that contains a tile named TileA. TileA contains a treemap visual from a report named ReportA. You need to provide the users of DashboardA with additional tiles that relate to the contents of TileA. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place: From Focus mode, pin the relevant visuals to DashboardA. From Focus mode, review the generated visuals. From DashboardA, select the TileA options, and then select View Insights. From ReportA, select the treemap visual options, and then select Spotlight. From ReportA, select Get Insights. From DashboardA, select TileA to open ReportA.

Datasets You modify the dataset to allow featured questions to show as suggested Q&As.

You have a Power BI dashboard that displays different visualizations of company sales. You enable Q&A on the dashboard. You need to provide users with sample questions that they can ask when using Q&A. Which settings should you modify form the Power BI Settings? Subscriptions Workbooks Dashboards Datasets

Yes This formula will achieve the target: CALCULATE( COUNT(Sales[ShipDate]), FILTER(Sales, NOT(ISBLANK(Sales[ShipDate])) ) )

You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date. The tables have the following relationships: - Sales[DueDate] and Date[Date] - Sales[ShipDate] and Date[Date] - Sales[OrderDate] and Date[Date] The active relationship is on Sales[DueDate]. You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data. Solution: You create measures that use the CALCULATE, COUNT, and FILTER DAX functions. Does this meet the goal? Yes No

No Goal is "without duplicating"

You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date. The tables have the following relationships: - Sales[DueDate] and Date[Date] - Sales[ShipDate] and Date[Date] - Sales[OrderDate] and Date[Date] The active relationship is on Sales[DueDate]. You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data. Solution: You create two copies of the Date table named ShipDate and OrderDateGet. You create a measure that uses the new tables. Does this meet the goal? Yes No

No The goal was to not duplicate data or load additional data and you created a calculated table.

You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date. The tables have the following relationships: - Sales[DueDate] and Date[Date] - Sales[ShipDate] and Date[Date] - Sales[OrderDate] and Date[Date] The active relationship is on Sales[DueDate]. You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data. Solution: You create a calculated table. You create a measure that uses the new table. Does this meet the goal? Yes No

sensitivity labels

You have a Power BI tenant. You have reports that use financial datasets and are exported as PDF files. You need to ensure that the reports are encrypted. What should you implement? dataset certifications row-level security (RLS) sensitivity labels Microsoft Intune policies

No Instead create a percentile line by using the Salary measure and set the percentile to 50%. Note: The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a constant line and set the value to .5. Does this meet the goal?

Yes The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a percentile line by using the Salary measure and set the percentile to 50%. Does this meet the goal? Yes No

No Instead create a percentile line by using the Salary measure and set the percentile to 50%. Note: The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create an average line by using the Salary measure. Does this meet the goal? Yes No

Yes The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a median line by using the Salary measure. Does this meet the goal? Yes No

Text.Replace Text.Start "...hides the first three digits of the SSN." Text.Replace([SSN],Text.Start([SSN],4), "xxx-")

You have a customer table in Power BI Desktop. The customer table contains the columns as shown in the following table (see image). You need to create a custom column that hides the first three digits of the SSN. The values in the new column must have the xxx-99-9999 format. How should you complete the Query Editor formula? Values: Text.End Text.Range Text.Start Text.Insert Text.Replace Answer Area [Value]([SSN], [VALUE]([SSN], 4), "xxx-")

No Advanced Editor, missing 'let' and 'in'.

You have a query for a table named Sales. Sales has a column named CustomerID. The Data Type of CustomerID is Whole Number. You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values. You need to ensure that nonnumeric values in the CustomerID column are set to 0. Solution: From Query Editor, open Advanced Editor and add the following query step. #"Replaced Errors"=Table.ReplaceErrorValues(#"Changed Type",{{"CustomerID",0}}) Does this meet the goal? Yes No

Duplicate the Customer query and name the new query CustomerGrouped. Group the CustomerGrouped query by Customer ID and output the max Modified Date value into a column named Modified Date. Merge the two queries basd on Customer ID and Modified Date by using an inner join. Duplicate->Group-Merge w/ Inner Join

You have a query named Customer that imports CSV files from a data lake. The query contains 50,000 rows as shown in the exhibit (see image). Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID. You need to keep only the last modified row for each customer ID. Which three actions should you perform in sequence? Actions: Filter the Customer query on Modified Date is Latest. Merge the CustomerGrouped query into the Customer query based on Customer ID and Modified Date by using a left outer join. Remove duplicates in the Customer ID column. Duplicate the Customer query and name the new query CustomerGrouped. Group the CustomerGrouped query by Customer ID and output the max Modified Date value into a column named Modified Date. Merge the two queries basd on Customer ID and Modified Date by using an inner join.

Yes You can change level of access by editing the workspace properties. User 1 doesn't need to be removed, all you have to do is change their role i.e editing the workspace.

You have a user named User1. User1 is a member of a security group named Contoso PowerBI. User1 has access to a workspace named Contoso Workspace. You need to prevent User1 from exporting data from the visualizations in Contoso Workspace. Solution: From the Microsoft Office 365 Admin center, you modify the properties of Contoso PowerBI. Does this meet the goal? Yes No

Unpublish the app. Dataset1 and Dataset2 are both contained in the app, therefore for you to be able to delete dataset2 you need to first unpublish the app , delete the unwanted dataset and then republish the app.

You have an app workspace that contains two datasets named dataset1 and dataset2. Dataset1 connects to a Microsoft Azure SQL database. Dataset2 connects to a Microsoft Excel file stored in Microsoft OneDrive for Business. You create a report named Report1 that uses dataset1. You pin Report1 to a dashboard named Dashboard1. You publish the app workspace to all the users in your organization. You need to delete dataset2 from the app workspace. What should you do first? Delete Dashboard1. Delete Report1. Unpublish the app. Configure the refresh settings for Dataset2.

Request that the sales manager be added to the correct Azure Active Directory group.

You have four sales regions. Each region has multiple sales managers.You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role. You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions. A sales manager changes to a different region. You need to ensure that the sales manager can see the correct sales data. What should you do? Change the Microsoft Power BI license type of the sales manager. From Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports. Request that the sales manager be added to the correct Azure Active Directory group. Manage the permissions of the underlying dataset.

Yes The Viewer role gives a read-only experience to its users. They can view dashboards, reports, or workbooks in the workspace, but can't browse the datasets or dataflows. Use the Viewer role wherever you would previously use a classic workspace set to Members can only view Power BI content.

You have several reports and dashboards in a workspace. You need to grant all organizational users read access to a dashboard and several reports. Solution: You assign all the users the Viewer role to the workspace. Does this meet the goal? Yes No

Yes Sharing each report and dashboard will work since requirement is for read access to a specific dashboard and several reports.

You have several reports and dashboards in a workspace. You need to grant all organizational users read access to a dashboard and several reports. Solution: You create an Azure Active Directory group that contains all the users. You share each report and dashboard to the group. Does this meet the goal? Yes No

No Enabling does not update.

You have several reports and dashboards in a workspace. You need to grant all organizational users read access to a dashboard and several reports. Solution: You enable included in app for all assets. Does this meet the goal? Yes No

Yes

You have several reports and dashboards in a workspace. You need to grant all organizational users read access to a dashboard and several reports. Solution: You publish an app to the entire organization. Does this meet the goal? Yes No

Select the line chart. From the Analytics pane, add an Average line. Turn on the data labels for the new line.

You have the line chart shown in the exhibit (see image). You need to modify the chart to meet the following requirements: - Identify months that have order counts above the mean. - Display the mean monthly order count. Which three actions should you perform in sequence? Actions: Create a 12-month rolling average quick measure and add the measure to the line chart value. From the Analytics pane, add a Median line. Select the line chart. From the Analytics pane, add an Average line. Turn on the data labels for the new line.

Change the Cross filter direction to Both. "You need to ensure that the district managers can see items for the stores they manage only."

You plan to create a Power BI report. You have the schema model shown in the exhibit (see image). The model has the following relationships: - Store to District based on DistrictID - Sales to Store based on LocationID - Sales to Date based on PeriodID - Sales to Item based on ItemID You configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage. When the district managers view the Store by Items report, they see items for all the stores. You need to ensure that the district managers can see items for the stores they manage only. How should you configure the relationship from Sales to Item? Select Assume Referential Integrity. Change the Cardinality to One to Many (1:*). Change the Cross filter direction to Both. Change the Cardinality to One to one (1:1).

DIVIDE ALL ProductCategory ProductSubcategory Measure1 = DIVIDE([TotalSales], CALCULATE([TotalSales],ALL(Sales[ProductCategory], Sales[ProductSubcategory])))

You plan to create a report in Power BI Desktop. You have the following tables. You have a measure that uses the following DAX formula. Total Sales = SUM('Sales'[SalesAmount]) You plan to create a report to display TotalSales by ProductCategory and ProductSubCategory. You need to create a measure to calculate the percentage of TotalSales for each ProductCategory. How should you complete the DAX formula? Values: ALL ALLEXCEPT ALLSELECTED CALCULATE DIVIDE Product ProductCategory ProductSubcategory Answer Area Measure1 = [VALUE]([TotalSales], CALCULATE([TotaleSales], [VALUE](Sales[VALUE], Sales[VALUE])))

Configure the dataset to use the existing On-premises data gateway. Set the refresh frequency to Daily. "The dataset appends data from an on-premises Oracle database..."

You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query. You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured. You need to ensure that the data is updated every morning. The solution must minimize configuration effort. Which two actions should you perform when you configure scheduled refresh? Configure the dataset to use the existing On-premises data gateway. Deploy an On-premises data gateway in personal mode. Set the refresh frequency to Daily. Configure the dataset to use the personal gateway.