web analytics

You need to compare the year-to-date sales with the previous year for the same time period. Which DAX function should you use?

You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for

Solution: From the Office 365 Admin center, you remove the Power BI license from User1. Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Solution: From the Power BI Admin portal, you modify the Dashboard settings. Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Solution: From the properties of each dashboard, you modify the Share settings. Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

What should you do in the model before you create the relationship?

You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart. The date value in

You need to ensure that the report published to the Power BI service will access the current data in SalesDB. What should you do?

You plan to use Power BI Desktop to create a report. The report will consume data from an on-premises tabular database named SalesDB in Microsoft SQL Server Analysis Services (SSAS).

You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source?

You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be

Which three types of visualizations should you include in the report? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server. You need to

You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source?

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your

When you publish the Power BI Desktop project to the Power BI service, the visualizations cannot display the data. What should you do to resolve the issue?

You have a Power BI Desktop project that uses DirectQuery to access an on-premises Microsoft SQL Server database. From Power BI Desktop, you can query the database. When you publish

You need to recommend a solution to ensure that the company adheres to the security policy. What should you include in the recommendation?

Your company has a security policy stating that proprietary data must not be transferred over the Internet. During a security audit, auditors discover that executives use the Power BI service

You need to ensure that RLS is enforced when accessing the embedded report. What should you do?

You have a Power BI report that is configured to use row-level security (RLS). You have the following roles: A manager role that limits managers to see only the sales

You need to create a custom visualization for Power BI. What should you install first?

You need to create a custom visualization for Power BI. What should you install first? A. jQuery B. Node.js C. Microsoft Azure PowerShell D. Microsoft.NET Answer: B

You need to compare the year-to-date sales with the previous year for the same time period. Which DAX function should you use?

You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for

Solution: From Query Editor, select the CustomerID column and click Remove Errors. Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

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?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

You need to ensure that the developers can push the data from SalesApp to the Power BI service. What should you do?

Your company has a custom line-of-business application named SalesApp. The developers of SalesApp want to push data into the Power BI service to create several visualizations. You need to ensure

You need to create a dashboard in the Power BI service to display data from a PubNub source. What should you do?

You need to create a dashboard in the Power BI service to display data from a PubNub source. What should you do? A. Add a Microsoft SQL Server Analysis Services

You need to create a measure to calculate the percentage that the total assets value increased since one year ago. Which DAX formula should you use?

You have a Power BI model that contains the following two tables: Assets (AssetID, AssetName, Purchase_DateID, Value) Date (DateID, Date, Month, Week, Year) The tables have a relationship. Date is

You need to ensure that User1 can view the report from SharePoint Online. What should you do?

You embed a Power BI report in a Microsoft SharePoint Online page. A user named User1 can access the SharePoint Online page, but the Power BI web part displays the

You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards. What should you do?

In the Power BI service, you create an app workspace that contains several dashboards. You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards.

You need to ensure that the report in the blog post will be updated as the data is refreshed. What should you do in the Power BI service?

You create a report in the Power BI service. You plan to provide external users with access to the report by publishing the report to a public blog. You need

You need to delete dataset2 from the app workspace. What should you do first?

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

You need to prevent the visualizations from being published to the blog. What should you do?

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

You need to create a dashboard that contains visualizations. The solution must ensure that you can use the slicer to filter the data by year. What should you do?

You have a sales report in an app workspace. The report displays a map of sales by location and a bar chart of sales by year. The report has a

You need to ensure that User1 sees App1 from the My organization AppSource. What should you do?

You have a Power BI app named App1. The privacy for the App1 app workspace is set to Private. A user named User1 reports that App1 does not appear in

You need to create a slide show that can be viewed from the Power BI service. Each slide must display the charts filtered for a different year. What should you do before you publish the report?

You are creating a Power BI Desktop report that has several bar charts and a date slicer. You need to create a slide show that can be viewed from the

You need to combine the data from SMB_Customers and Enterprise_Customers. Which command should you use?

You have the following two queries in Power BI Desktop: A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database A query named Query2

You need to import the CSV files into one table. The solution must minimize administrative effort. What should you do?

You plan to use Power BI Desktop to import 100 CSV files. The files contain data from different stores. The files have the same structure and are stored in a

You need to change the sort order of the visualization. What should you do first?

You create a KPI visualization in Power BI Desktop that uses the month as the trend axis. You discover that the data is not sorted by month. You need to

You need to modify the query to ensure that the data appears correctly. What should you do?

You are importing sales data from a Microsoft Excel file named Sales.xlsx into Power BI Desktop. You need to create a bar chart showing the total sales amount by region.

Which three operations can the developers achieve by using the API? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Your company has several developers who plan to create custom solutions that will interact with the API for the Power BI service. Which three operations can the developers achieve by

Solution: From the Power BI service, get the data from SharePoint Online, and then click Import. Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Solution: From Excel, click Publish to Power BI, and then click Export. Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Solution: Purchase Power BI Premium P1, and then configure the app workspace to run in a dedicated capacity. Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Solution: Configure the app workspace to be read-only for members and to run in a shared capacity. Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Solution: From Publish to web, generate an iFrame. Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

You need to connect the model to the tables in SQLProd. The solution must minimize administrative effort. What should you do from Query Editor before you publish the model?

You have two Microsoft SQL Server database servers named SQLProd and SQLDev. SQLDev contains the same tables as SQLProd, but only a subset of the data in SQLProd. You create

You need to ensure that when you select a year on the bar chart, the donut chart remains unchanged. What should you do?

You have a Power BI report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the

You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?

You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the

You need to create a measure to calculate the sales for same period from the previous year. Which DAX formula should you use?

You have a Power BI model that contains the following two tables: Sales (Sales_ID, DateID, sales_amount) Date(DateID, Date, Month, Week, Year) The tables have a relationship. You need to create

You need to ensure that you can generate a report that displays the count of products sold by each salesperson. What should you do before you create the report?

You have a Microsoft Excel 2016 workbook that has a Power Pivot model. The model contains the following tables: Product (Product_id, Product_Name) Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount) Salesperson (Salesperson_id,

You need to ensure that dashboard data can be updated every 30 minutes. What should you do?

You plan to deploy a Power BI app workspace that will be viewed by 10,000 users. You need to ensure that dashboard data can be updated every 30 minutes. What

You need to ensure that all the sales users can view the report from the Sales site. What should you do?

You have a Microsoft SharePoint Online site named Sales. Your company has 1,000 sales users. All the sales users can access Sales. You create a report in an app workspace

You need to create a measure to rank the customers based on their total sales amount. Which DAX formula should you use?

You have a Power BI model that contains the following two tables: Sales(Sales_ID, sales_date, sales_amount, CustomerID) Customer(CustomerID, First_name, Last_name) There is a relationship between Sales and Customer. You need to

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You use Power BI Desktop to create a visualization for a Microsoft SQL Server data source. You need to ensure that you can use R visualization. Which two actions should

You need to add the Sales table to a Power BI dashboard as a tile. How should you configure the tile?

You have a Microsoft Excel spreadsheet that contains a table named Sales. You need to add the Sales table to a Power BI dashboard as a tile. How should you

You need to manage the members that have access to the app workspace using the least amount of administrative effort. What should you do?

You have an app workspace named Retail Store Analysis in the Power BI service. You need to manage the members that have access to the app workspace using the least

You need to receive an alert when the total number of customers reaches 10,000. What should you do first?

You create a report in the Power BI service that displays the following visualizations: A KPI that displays the count of customers A table that displays the count of customers

You need to ensure that a sales team can view only data that has a CountryRegionName value of Unites States and a ProductCategory value of Clothing. What should you do from Power BI Desktop?

You manage a Power BI model that has two tables named Sales and Product. You need to ensure that a sales team can view only data that has a CountryRegionName