Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 271:

  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 and 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.

  Hot Area:

  

  Correct Answer:

  

  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.

• Question 272:

  HOTSPOT

  You have the Power Bi dashboard shown in the Dashboard exhibit (Click the Dashboard tab.)

  

  You need to ensure that when users view the dashboard on a mobile device, the dashboard appears as shown in the Mobile exhibit. (Click the Mobile tab.)

  

  What should you do? To answer, select the appropriate options m the answer area NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 273:

  HOTSPOT

  You have a Power Bl visual that uses indicators to show values that are out of range 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 selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: a line Incorrect:

  * not line and clustered column

  The Line and Clustered Column Chart is a combo charts that combines the Line chart and Column chart together in one visual. By combining these two visuals together, you can make a very quick comparison between two sets of measures.

  

  Box 2: anomaly detection Anomaly detection helps you enhance your line charts by automatically detecting anomalies in your time series data. It also provides explanations for the anomalies to help with root cause analysis. With just a couple of clicks, you can easily

  find insights without slicing and dicing the data.

  Example:

  

  Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-anomaly-detection

• Question 274:

  HOTSPOT

  You are creating reports in Power BI Desktop. The model has the following tables.

  

  There is a relationship between the tables.

  You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name.

  You need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the dataset that is published.

  How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 275:

  HOTSPOT

  You have a Power BI model that has the following tables:

  Product (Product_id, Product_Name)

  Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount) Salesperson (Salesperson_id, Salesperson_name, address)

  You plan to create the following measure.

  Measure1 = DISTINCTCOUNT(Sales[ProductID])

  You need to create the following relationships:

  1.

  Sales to Product

  2.

  Sales to Salesperson

  The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.

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

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 276:

  HOTSPOT

  You have a report in Power BI Desktop 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 selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 277:

  HOTSPOT

  You are profiling data by using Power Query Editor.

  The AddressLine2 column in a table named Address is 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.

  Hot Area:

  

  Correct Answer:

  

• Question 278:

  HOTSPOT

  You open powerbi.com 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 selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  References: https://docs.microsoft.com/en-us/power-bi/service-data-classification

• Question 279:

  HOTSPOT

  You are creating a line chart in a Power BI report 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 selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane https://sqldusty.com/2015/10/14/drill-down-with-power-bi-visualizations/

• Question 280:

  HOTSPOT

  Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:

  1.

  Access a published Power BI app

  2.

  Modify reports in an app workspace

  3.

  Share dashboards created in My Workspace

  You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.

  Which license should you identify for each task? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer: