Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 301:

  You have a Power BI tenant that contains a workspace named WS1. WS1 contains the following items:

  1. A semantic model named SM1.

  2. A report named RPT1 that is connected to SM1.

  3. A report named RPT2 that is connected to SM1.

  4. A report named RPT3 that is connected to SM1.

  5. A dashboard named DB1 that contains content from RPT1 and RPT2.

  You need to grant workspace access to a group named Group1. The solution must meet the following requirements:

  1. Group1 must be able to view RPT1, RPT2, and DB1.

  2. Group1 must be prevented from viewing RPT3.

  3. Group1 must be prevented from creating new reports and dashboards by using SM1.

  4. Group1 must be prevented from sharing the reports and dashboards to other users.

  5. Administrative effort must be minimized.

  What should you do?

  A. Publish an app.
  B. Assign Group1 the Viewer role for WS1.
  C. Store PBIX files in a shared folder in Microsoft OneDrive.
  D. Share each item individually.
  A. Publish an app.

• Question 302:

  HOTSPOT

  You have a semantic model that has the permissions shown in the following exhibit.

  

  Use the drop-down menus to select the answer choice the that completes each statement based on the information presented in the graphic.

  NOTE: Each correct selection is worth one point.

  

  

• Question 303:

  You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant 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. Change the data type of the Logged column to Date.
  B. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
  C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
  D. Apply a transform to extract the first 11 characters of the Logged column.
  C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.

• Question 304:

  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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

  You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

  Solution: You modify the source step of the queries to use DataSourceExcel as the file path.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

  ---

  Explanation

  Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.

  https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

• Question 305:

  DRAG DROP

  Exhibit:

  

  You need to create a report that meets the requirements:

  1. Visualizes the Sales value over a period of years and months

  2. Adds a Slicer for the month

  3. Adds a Slicer for the year

  Which three actions Should you perform in sequence?

  Select and Place:

  

  

• Question 306:

  In Power BI Desktop, you have a dataset that contains a table.

  You create a table visual on a Power BI report page as shown in the following exhibit

  

  You need to configure the visual to display the referenced image instead of the URL in the Plant Image column.

  What should you do?

  A. Set the Data category of the Plant Image field to Image URL
  B. Set the Data type of the Plant Image field to Binary.
  C. Set the Data category of the Plant Image field to Web URL.
  D. From the Formatting tab. select Values, and then set URL icons to On for the table.
  A. Set the Data category of the Plant Image field to Image URL

• Question 307:

  HOTSPOT

  You have a Power BI semantic model that contains the following tables.

  

  All the tables use the same data source.

  You need to reduce the number of limited relationships in the model by changing the storage mode of certain tables. The solution must NOT affect the latency of the data.

  Which storage mode should you select for the Customer and Geography tables? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 308:

  You have a Power Bl semantic model named Model! that contains two fields named Sales and Quarter. Model 1 contains a DAX measure that sums the Sales column.

  You need to create a report that will contain the visual shown in the following exhibit.

  

  The solution must NOT require additional DAX measures.

  Which type of visual should you use?

  A. ribbon chart
  B. line chart
  C. 100% stacked area chart
  D. area chart
  D. area chart

• Question 309:

  You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product.

  The Sales table contains purchase and ship dates.

  Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.

  You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.

  Which data modeling design should you use?

  A. Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
  B. Duplicate the Date query in Power Query and use active relationships between both Date tables.
  C. On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
  D. Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.
  D. Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

  ---

  Explanation

  Only one relationship can be active.

  Note: If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality, Cross filter direction, and Make this relationship active are automatically set.

  https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

• Question 310:

  HOTSPOT

  You are creating a Microsoft Power BI data model that has the tables shown in the following table.

  

  The Products table is related to the ProductCategory table through the ProductCategoryID column.

  You need to ensure that you can analyze sales by product category.

  How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: One-to-many

  Box 2: Both

  For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the "many" side (bi-directional).

  Note:

  

  https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand