PL-300 Exam Question 61

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?
  • PL-300 Exam Question 62

    You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?
  • PL-300 Exam Question 63

    You are using Power Bi Desktop to connect to an Azure SQL database The connection is configured as shown in the following exhibit.


    Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic NOTE: Each correct solution is worth one point

    PL-300 Exam Question 64

    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. Some question sets might have more than one correct solution, while others might not have a correct solution.
    After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    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?
  • PL-300 Exam Question 65

    You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette.
    You are creating a Power Bl dashboard that will include two visuals from each report You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports.
    Which two actions should you perform? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.