Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 291:

  HOTSPOT

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

  How should create the Visualization? TO answer, select the appropriate options in the answer area.

  

  

• Question 292:

  You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

  

  You import the tables.

  Which relationship should you use to link the tables?

  A. one-to-many from Customer to Transaction
  B. one-to-one between Customer and Transaction
  C. one-to-many from Transaction to Customer
  D. many-to-many between Customer and Transaction
  A. one-to-many from Customer to Transaction

  ---

  Explanation

  Each customer can have many transactions.

  For each transaction there is exactly one customer.

• Question 293:

  You attempt to open a PBIX file in Microsoft Power BI Desktop and receive the following error message in Power Query Editor.

  DataSource.Error: Could not find file D:\Data.txt.

  How should you resolve the issue?

  A. Update the Microsoft OLE DB Provider client libraries on your client computer.
  B. Change the file path of Data.txt.
  C. Change the file format to CSV.
  D. Use an on-premises data gateway.
  B. Change the file path of Data.txt.

• Question 294:

  DRAG DROP

  You have the Power BI data model shown in the following exhibit.

  

  Select and Place:

  

  

• Question 295:

  You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh.

  From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity.

  You discover that the dataset refresh fails after the refresh runs out of resources.

  What is a possible cause of the issue?

  A. Query folding is not occurring.
  B. You selected Only refresh complete periods.
  C. The data type of the column used to partition the data changed.
  D. A filter is missing on the report.
  A. Query folding is not occurring.

  ---

  Explanation

  The Power BI service partitions data based on date range. This is what enables only certain partitions to be refreshed incrementally. To make this work, the partition filter conditions are pushed down to the source system by including them in the queries. Using Power Query terminology, this is called "query folding". It is not recommended that incremental refresh is used when the required query folding cannot take place.

  https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/

• Question 296:

  You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns:

  1. Customer_Name

  2. Customer ID

  3. Website

  The Contacts table contains the following columns:

  1. Contact ID

  2. Contact Email

  3. Contact Name

  4. Customer Name

  A web-based contact form is used to fill the Contacts table. The data is not sanitized.

  You need to create a merge for the Customer and Contacts tables.

  What should you do?

  A. Disable fuzzy matching.
  B. Enable fuzzy matching.
  C. Set Join Kind to Left Outer.
  D. Set Join Kind to Full Outer
  B. Enable fuzzy matching.

• Question 297:

  HOTSPOT

  You have the data lineage 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 selection is worth one point.

  

  

  ---

  Box 1: CONTOSO BIKES report

  Box 2: three datasets

  Images, tweets and the Contoso datasets.

• Question 298:

  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.
  C. all the rows in ProductsGroupA that have a matching row in ProductsGroupB

• Question 299:

  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.

  

  

  ---

  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]

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

• Question 300:

  You have multiple dashboards.

  You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.

  What should you use?

  A. comments
  B. tiles
  C. Microsoft Information Protection sensitivity labels
  D. Active Directory groups
  C. Microsoft Information Protection sensitivity labels

  ---

  Explanation

  Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied to datasets, reports, dashboards, and dataflows.

  https://docs.microsoft.com/en-us/power-bi/admin/service-security-sensitivity-label-overview