PL-300: Microsoft Power BI Data AnalystDemo

You have a Power BI workspace called Workspace1 that contains a dataset named DS1 and a report named RPT1.

A user wants to create a report using the data in DS1 and publish that report to a different workspace.

You need to give the user the appropriate access while minimizing the number of permissions granted.

What should you do?

You have a Power BI dashboard that monitors manufacturing-process quality. The dashboard includes the following elements:

• A line chart showing the number of defective products manufactured each day
• A KPI visual showing the current daily percentage of defective products manufactured

You need to receive a notification when the daily percentage of defective products manufactured exceeds 3%.

What should you create?

You have two CSV files named Products and Categories.

The Products file has these columns:

• ProductID
• ProductName
• SupplierID
• CategoryID

The Categories file has these columns:

• CategoryID
• CategoryName
• CategoryDescription

From Power BI Desktop, import both files into Power Query Editor.

You need to create a Power BI dataset containing one table named Product. The Product table must include these columns:

• ProductID
• ProductName
• SupplierID
• CategoryID
• CategoryName
• CategoryDescription

How should the queries be combined, and what action should be taken on the Categories query?

You have a Power BI semantic model named Model1 that uses Import storage mode.

You need to decrease the size of Model1. The solution must NOT increase report query response times.

What should you do?

You have a report containing four pages. Each page has slicers for the same four fields.

Users report that when they choose values in a slicer on one page, those selections do not persist on the other pages.

You need to recommend a solution that lets users select a value once and filter results across all pages. What are two possible recommendations to meet this goal? Each correct answer provides a complete solution.

NOTE: Each correct selection is worth one point.

You have a PBIX file that imports data from a Microsoft Excel data source located on a file share in a local network.

You are informed that the Excel data source has been moved to a different location.

You need to update the PBIX file so that it uses the new location.

What are three ways to accomplish this goal? Each correct answer provides a complete solution.

NOTE: Each correct selection is worth one point.

You have a Power BI semantic model containing a table named Table1. Table1 uses Import storage mode.

You need to update the model so that Table1 uses DirectQuery storage mode.

What action should you take?

You need to establish relationships that satisfy the customer service department's reporting requirements.

What should you create?

You have a Power BI report named Orders that supports the following analysis:

• Total sales over time
• The count of orders over time
• New and repeat customer counts

The data model size is nearing the limit for a dataset in shared capacity. The model view for the dataset is shown in the following exhibit.

The data view for the Orders table is shown in the following exhibit.

The Orders table is related to the Customers table by using the CustomerID column. The Orders table is related to the Date table by using the OrderDate column.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

You have a Power BI report with one page. That page includes two line charts and one bar chart.

You need to ensure that users can perform the following actions for all three visuals:

• Switch the measures used in the visuals.
• Change the visualization type.
• Add a legend.

The solution must minimize development effort.

What should you do?

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

You need to create a monthly rolling average measure for Sales over time.

How should you configure the quick-measure calculation?

You have a Power BI report that includes a bar chart. The bar chart shows sales by country.

You need to ensure that a screen reader can access a summary of the data displayed on the bar chart.

What should you configure on the bar chart?

You have a Power BI semantic model.

You need to configure row-level security (RLS) to limit data access for users with Viewer permissions.

Which three actions should you take, in sequence?

You are reviewing a Power BI data model.

You have a calculated table with the following definition:

ProductList = INTERSECT ( ProductsGroupA, ProductsGroupB )  

You need to determine the result of the DAX expression.

Which rows are returned in ProductList?

You have a Power BI dataset containing quarterly sales performance data.

You need to allow managers to review the data in a format that meets these requirements:

• Is optimized for printing.
• Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.

What should you create?

You have a Power BI workspace.

You need to create two reports that meet these requirements:

• Report1: Optimized for printing and can be delivered to users through a scheduled email subscription
• Report2: Optimized for dynamic user interactivity

Which format should you use for each report?

HOTSPOT -

You plan to create a Power BI dataset to analyze school attendance. Data will come from two separate views, named View1 and View2, in an Azure SQL database.

View1 contains the columns shown in the following table.

View2 contains the columns shown in the following table.

The views can be related by using the Class ID column.

Class ID uniquely identifies the specified class, period, teacher, and school year. For example, the same class can be taught by the same teacher during two different periods, but the class will have a different Class ID.

You need to design a star-schema data model using data from both views. The solution must support the following analysis:

• The number of classes that occur by period
• The number of students in attendance by period and by day
• The average number of students attending a class each month

In which table should you include the Teacher First Name and Period Number fields?

You have four sales regions, each with multiple sales managers.

You implement row-level security (RLS) in a data model and assign the applicable mail-enabled security group to each role.

You have sales reports that allow analysis by region. Sales managers can view sales records for their own region, but are prevented from viewing records for other regions.

A sales manager moves to another region.

You need to ensure that the sales manager can view the correct sales data.

What should you do?

You need to create a dataset.

Which dataset mode should you use?

A Power Query Editor query contains customer data, as shown in the following exhibit.

You have a Power BI semantic model containing a table named Table1. Table1 has the following columns:

• WebsiteName
• URL

You need to create a report named Report1 that includes a table visual. The solution must meet these requirements:

• Display the website name.
• Allow users to navigate to the website's URL by selecting the website name.

What should you use?

You have a Power BI report for the procurement department. The report includes data from the following tables.

A one-to-many relationship exists from Suppliers to LineItems, using the ID and Supplier ID columns. The report includes the visuals shown in the following table.

You need to reduce the dataset size without affecting the visuals. What should you do?

You import a Microsoft Excel spreadsheet into Power Query Editor and name the query Sales_Spreadsheet.

Sales_Spreadsheet contains these columns:

• Customer ID
• Customer Name
• Date
• Total Sales Amount

You plan to use the Sales_Spreadsheet query to load two tables, named Customer and Sales, into the associated semantic model. The tables are related by the Customer ID column in each query. The solution must satisfy these requirements:

• The Customer query must include the Customer ID and Customer Name columns.
• The Sales query must include the Customer ID, Date, and Total Sales Amount columns.
• Power Query logic must be consolidated to prevent duplicated logic across the queries and ensure that updates occur in one location.

Identify how to create the Sales query and what to do with the Sales_Spreadsheet query before loading the model.

You have a Power BI semantic model containing a table named Opportunity.

The Opportunity table has a Qualification column whose values range from 0 to 1.

You need to create a measure that scores opportunities as low, medium, or high.

How should you complete the DAX formula?

Sales Qualification =

IF(

    'Opportunity'[Qualification] < 0.5,

    "Low",

    Select… (

        'Opportunity'[Qualification] > 0.7,

        Select…,

        Select…

    )

)