Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 391:

  You plan to embed multiple visualization in a public website.

  Your Power BI infrastructure contains the visualizations configured as shown in the following table.

  

  Which two visualizations can you embed into the website? Each correct answer presents a complete the solution.

  NOTE: Each correct selection is worth one point.

  A. Visual1
  B. Visual2
  C. Visual3
  D. Visual4
  E. Visual5
  B. Visual2
  D. Visual4

  ---

  Explanation

  References:

  https://docs.microsoft.com/en-us/power-bi/service-publish-to-web

• Question 392:

  HOTSPOT

  You have two Azure SQL databases that contain the same tables and columns.

  For each database, you create a query that retrieves data from a table named Customer.

  You need to determine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.

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

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: Append Queries as New.

  There are two primary ways of combining queries: merging and appending.

  1. When you have one or more columns that you'd like to add to another query, you merge the queries.

  2. When you have additional rows of data that you'd like to add to an existing query, you append the query.

  Box 2: Disable loading the query to the data model

  For every query that loads into model memory will be consumed. and Memory is our asset in the Model, less memory consumption leads to better performance in most of the cases. The best approach is to disable loading.

  https://docs.microsoft.com/en-us/power-query/append-queries

• Question 393:

  You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.

  You need to ensure that the users will see the current data when they view the dashboard.

  How should you configure the connection to the data source?

  A. Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.
  B. Deploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode.
  C. Deploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode.
  D. Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.
  D. Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.

  ---

  Explanation

  References:

  https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#power-bi-connectivity-modes

• Question 394:

  DRAG DROP

  You have a folder that contains 100 CSV files.

  You need to make the file metadata available as a single dataset by using Power Bi The solution must NOT store the data of the CSV files.

  Which three actions should you perform in sequence. To answer, mow the appropriate actions from the list of actions to the answer area and arrange them m the correct order.

  NOTE; More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

  Select and Place:

  

  

• Question 395:

  You create a report by using Microsoft Power BI Desktop.

  The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company's internal network.

  You plan to publish the report to the Power BI Service.

  What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

  A. a subscription
  B. a scheduled refresh of the dataset
  C. an OData feed
  D. an On-premises data gateway
  D. an On-premises data gateway

  ---

  Explanation

  When you've created dynamic reports in Power BI Desktop, you can share them by publishing to your Power BI site. When you publish a Power BI Desktop file with a live connection to a tabular model to your Power BI site, an on-premises data gateway must be installed and configured by an administrator.

• Question 396:

  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 have a Rawer Bl report.

  That imports a dace table and a sales table from an Azure SQL database data source.

  The sales table has the following date foreign keys:

  1. Due Date

  2. Order Date

  3. Delivery Date

  You need to support the analysis of sales over time based on all three dates at the same time.

  Solution:

  1. From the Fields pane, you rename the date table as Due Date.

  2. You use a DAX expression to create Order Date and Delivery Date as calculated tables.

  3. You create active relationships between the sales table and each date table.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

  ---

  Explanation

  Renaming the date table and creating calculated tables for "Order Date" and "Delivery Date" with DAX expressions would not fully meet the goal. Power BI only allows one active relationship between two tables at a time. Therefore, you cannot have active relationships between the sales table and all three date tables simultaneously. Instead, you would typically create one active relationship (e.g., with "Order Date") and use DAX functions like USERELATIONSHIP to switch between different relationships when needed for analysis. Alternatively, you could use a single date table and create multiple relationships, using inactive relationships and the USERELATIONSHIP function to activate them in specific measures.

• Question 397:

  HOTSPOT

  You have the Performance analyzer results 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.

  

  

• Question 398:

  Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

  Start of repeated scenario

  You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

  

  You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

  

  You plan to use Power BI to import data from 2013 to 2015. Product Subcategory [Subcategory] contains NULL values.

  End of repeated scenario.

  You implement the Power BI model.

  You add another table named Territory to the model. A sample of the data is shown in the following table.

  

  You need to create a relationship between the Territory table and the Sales table.

  Which function should you use in the query for Territory before you create the relationship?

  A. Table.RemoveMatchingRows
  B. Table.Distinct
  C. Table.InDistinct
  D. Table.ReplaceMatchingRows
  B. Table.Distinct

  ---

  Explanation

  References:

  https://msdn.microsoft.com/en-us/library/mt260775.aspx

• Question 399:

  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 employee.
  B. Create a new group on the state column and set the Group type to List.
  C. Create a new group on the state column and set the Group type to Bin.
  D. Create a new aggregation that summarizes by state.
  B. Create a new group on the state column and set the Group type to List.

  ---

  Explanation

  https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/

• Question 400:

  HOTSPOT

  You have a folder of monthly transaction extracts.

  You plan to create a report to analyze the transaction data.

  You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions."

  You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

  

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

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: Yes

  The four columns used in the 2018 transactions are already displayed.

  Box 2: Yes

  The columns used are based on the entire dataset. The additional columns in the 2019 files will be detected.

  Box 3: Yes

  Note: Under the hoods, Power BI will automatically detect which delimiter to use, and may even promote the first row as headers. You can manually change the delimiter, or define how Power BI should handle data types. You can set it to automatically detect data types based on first 200 rows, or the entire dataset or you can even opt out the detection of data types.