Free PL-300 Sample Questions — Microsoft Power BI Data Analyst

You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month. You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment. How should the visual interactions be set on the column chart when the bar chart is selected?

• A. highlight
• B. filter
• C. no impact

You have a Power BI workspace named Workspace1 and a group named Group1. You need to ensure that the members of Group1 are notified when there are issues in Workspace1. The solution must follow the principle of least privilege. What should you do?

• A. Assign Group1 the Admin role
• B. Update the contact list to include Group1
• C. Assign Group1 the Contributor role for Workspace1
• D. Assign Group1 the Member role for Workspace1

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

• A. Apply the Parse function from the Data transformations options to the Logged column
• B. Change the data type of the Logged column to Date
• C. Split the Logged column by using at as the delimiter
• D. Create a column by example that starts with 2018-12-31

Which DAX expression should you use to get the ending balances in the balance sheet reports?

• A. CALCULATE ( SUM( BalanceSheet[BalanceAmount] ), LASTDATE ( 'Date'[Date] ) )
• B. CALCULATE ( SUM( BalanceSheet[BalanceAmount] ), DATESQTD('Date'[Date]) )
• C. FIRSTNONBLANK ('Date'[Date] SUM( BalanceSheet[BalanceAmount] ) )
• D. CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE ('Date'[Date] ))

You plan to create a Power BI report that will be connected to multiple data sources. One of the data sources contains tax records. You need to ensure that other queries cannot access the tax record information. To what should you set Privacy Level for the data source?

• A. None
• B. Organizational
• C. Private
• D. Public

You are reviewing a Power BI data model. You have a calculated table that has the following definition. ProductList = INTERSECT ( ProductsGroupA, ProductsGroupB ) You need to identify the results of the DAX expression. Which rows will be returned in ProductList?

• A. all the rows in ProductsGroupB that have a matching row in ProductsGroupA
• B. all the rows in both tables
• C. all the rows in ProductsGroupA that have a matching row in ProductsGroupB
• D. all the rows in ProductsGroupA that have no matching row in ProductsGroupB

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?

• A. The user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020
• B. The user will receive an error and will not be able to see the data in the report
• C. The user will only see data for which the State Province value is Kentucky
• D. The user will only see data for which the State Province value is Kentucky and the Calendar Year is 2020

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection?

• A. Import that uses a Microsoft account
• B. Import that uses a database credential
• C. DirectQuery that uses a database credential
• D. DirectQuery that uses the end-user's credentials

You have a Power BI semantic model that contains four queries named Query 1, Query2. Query3, and Query4. Query1 loads customer data into the model and is referenced by the other three queries. You discover that data refresh for the model is slow. You need to improve the data refresh time. The solution must minimize costs. What should you do?

• A. Run the Table.buffer function in Query1
• B. Duplicate Query1 to all the other queries
• C. Reconfigure Query1 as a dataflow entity
• D. From the Power BI Admin portal, increase the Capacity settings

You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?

• A. Create a security role that has a table filter on the Sales Manager table where username = UserName()
• B. Create a security role that has a table filter on the Sales Manager table where username = sales_manager_id
• C. Create a security role that has a table filter on the Region Manager table where sales_manager_id = UserPrincipalName()
• D. Create a security role that has a table filter on the Sales_Manager table where name = UserName()

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps. You need to create a Power BI report that connects to the project management app. Which connector should you select?

• A. Microsoft Teams Personal Analytics
• B. SQL Server database
• C. Dataverse
• D. Dataflows

You have a Power BI workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1. A user wants to create a report by using the data in DS1 and publish the report to another workspace. You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user. What should you do?

• A. Add the user as a Viewer of Workspace1
• B. Grant the Build permission for DS1 to the user
• C. Share RPT1 with the user
• D. Add the user as a member of Workspace1

You need to create the dataset. Which dataset mode should you use?

• A. Import
• B. DirectQuery
• C. Composite
• D. live connection

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 mail-enabled security group 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?

• A. Change the Microsoft Power BI license type of the sales manager
• B. From Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports
• C. Manage the permissions of the underlying dataset
• D. Request that the sales manager be added to the correct Azure Active Directory group

You are creating a visual in a Power BI report. The associated semantic model contains sales from the last four years for three products. You need to display the total sales by quarter categorized by product. The visual must display trends in both total sales and individual product sales. Which type of visual should you use?

• A. area chart
• B. clustered column chart
• C. stacked area chart
• D. line chart

You have a PBIX file that imports data from a Microsoft Excel data source stored in a file share on a local network. You are notified that the Excel data source was moved to a new location. You need to update the PBIX file to use the new location. What are three ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

• A. From the Datasets settings of the Power BI service, configure the data source credentials
• B. From the Data source settings in Power BI Desktop, configure the file path
• C. From Current File in Power BI Desktop, configure the Data Load settings
• D. From Power Query Editor, use the formula bar to configure the file path for the applied step
• E. From Advanced Editor in Power Query Editor, configure the file path in the M code

You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals. What should you set as the relationship cardinality?

• A. One to one
• B. Many to many
• C. Many to one
• D. One to many

You create a dashboard by using the Microsoft Power BI Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the Viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?

• A. Create a subscription
• B. Create a data alert
• C. Share the dashboard to the user
• D. Tag the user in a comment

Your company has employees in 10 states. The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains employee information by state. The model does NOT include region information. You have a report that shows the employees by state. You need to view the employees by region as quickly as possible. What should you do?

• A. Create a new aggregation that summarizes by state
• B. Create a new aggregation that summarizes by employee
• C. Create a new group on the state column and set the Group type to List
• D. Create a new group on the state column and set the Group type to Bin

You have a Power BI report that contains a stacked bar chart. You need to add a new field to the legend. The field must combine information from separate columns. What should you create?

• A. a calculated column
• B. a dynamic format string
• C. a measure
• D. a calculation group