Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 191:

  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 Region_Manager table where sales_manager_id = UserPrincipalName().

  C. Create a security role that has a table filter on the Sales_Manager table where name = UserName().

  D. Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

  Correct Answer: A

  Scenario: The region_id column can be managed by only one sales manager.

  You can use Username() or userprincipalname() in DAX with Row-Level Security.

  Within Power BI Desktop, username() will return a user in the format of DOMAIN\User and userprincipalname() will return a user in the format of [email protected].

  Incorrect Answers:

  B: sales_manager_id is an integer and cannot be converted to a string datatype.

  Reference: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

• Question 192:

  You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

  A. Change the data type of Sales[region_id] to Whole Number.

  B. Change the data type of Sales[region_id] to Decimal Number.

  C. Change the data type of Sales[sales_id] to Text.

  D. In the Sales table, add a measure for Sum(sales_amount).

  Correct Answer: A

  Scenario: Executives require a visual that shows sales by region.

  Need to change the sales_id column from Varchar to Whole Number (Integer).

• Question 193:

  HOTSPOT

  You need to create a measure that will return the percentage of late orders.

  How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: CALCULATE

  CALCULATE evaluates an expression in a modified filter context.

  Syntax: CALCULATE([, [, [, …]]])

  Expression - The expression to be evaluated.

  filter1, filter2,… (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions.

  Box 2: FILTER

  FILTER returns a table that represents a subset of another table or expression.

  Syntax: FILTER(

  ,)

  Table- The table to be filtered. The table can also be an expression that results in a table.

  Filter - A Boolean expression that is to be evaluated for each row of the table. For example, [Amount] > 0 or [Region] = "France"

  Box 3: Orders[ShippedDate]> Orders[RequiredDate]

  Northwind Traders defines late orders as those shipped after the required shipping date.

  Reference:

  https://docs.microsoft.com/en-us/dax/calculate-function-dax

  https://docs.microsoft.com/en-us/dax/filter-function-dax

  Question 194:

  HOTSPOT

  How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Using a workspace membership

  Scenario:

  The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.

  Note: Workspace is a shared environment for a group of people. You can have multiple Power BI content in a workspace. One workspace can have hundreds of dashboards,reports, and datasets in it.

  Box 2: A mail-enabled Azure-Active Directory group

  Scenario: Security Requirements

  The reports must be made available to the board from powerbi.com. A mail-enabled Azure-Active Directory (security)group will be used to share information with the board.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#using-rls-with-workspaces-in-power-bi

  Question 195:

  HOTSPOT

  You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table.

  Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: A DAX Calculated measure

  Box 2: Date.EndofQuarter(#date([Year],[Mont],1))

  ENDOFQUARTER returns the last date of the quarter in the current context for the specified column of dates.

  The following sample formula creates a measure that returns the end of the quarter, for the current context.

  = ENDOFQUARTER(DateTime[DateKey])

  Reference:

  https://docs.microsoft.com/en-us/dax/endofquarter-function-dax

  Question 196:

  HOTSPOT

  You need to grant access to the business unit analysts.

  What should you configure? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: The Viewer role to the workspace 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”.

  

  Box 2: Build

  The analysts must be able to build new reports from the dataset that contains the profit and loss data.

  Scenario: The reports must be made available to the board from powerbi.com.

  The analysts responsible for each business unit must see all the data the board sees,except the profit and loss data, which must be restricted to only their business unit's data.

  The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share

  the quarterly reports with anyone.

  Question 197:

  HOTSPOT

  You need to create a visualization to meet the reporting requirements of the sales managers.

  How should you create the visualization? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Scenario: The sales managers require a visual to analyze sales performance versus sales targets.

  Box 1: KPI

  A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.

  Box 2: Sales[sales_amount]

  Box 3: Date[month]

  Time > FiscalMonth. This value will represent the trend.

  Box 4: Targets[sales_target]

  Reference:

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

  Question 198:

  DRAG DROP You use Power Query Editor to preview the data shown in the following exhibit

  

  You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort. 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:

  

  Correct Answer:

  

  Question 199:

  HOTSPOT

  You publish the dataset to powerbi.com.

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

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Question 200:

  HOTSPOT

  You need to create a KPI visualization to meet the reporting requirements of the sales managers.

  How should you create the visualization? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Scenario: The sales managers require a visual to analyze sales performance versus sales targets.

  Box 1: Sales[sales_amount]

  Box 2: Date[month]

  Time > FiscalMonth. This value will represent the trend.

  Box 3: Targets[sales_target]

  Reference:

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

  • 1
  • 2
  • ...
  • 19
  • 20
  • 21
  • 22
  • ...
  • 34
  • 35

  Related Exams:

  • 62-193

    Technology Literacy for Educators

  • 70-243

    Administering and Deploying System Center 2012 Configuration Manager

  • 70-355

    Universal Windows Platform – App Data, Services, and Coding Patterns

  • 77-420

    Excel 2013

  • 77-427

    Excel 2013 Expert Part One

  • 77-725

    Word 2016 Core Document Creation, Collaboration and Communication

  • 77-726

    Word 2016 Expert Creating Documents for Effective Communication

  • 77-727

    Excel 2016 Core Data Analysis, Manipulation, and Presentation

  • 77-728

    Excel 2016 Expert: Interpreting Data for Insights

  • 77-731

    Outlook 2016 Core Communication, Collaboration and Email Skills

  Tips on How to Prepare for the Exams

  Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Microsoft exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your PL-300 exam preparations and Microsoft certification application, do not hesitate to visit our Vcedump.com to find your solutions here.