Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 101:

  HOTSPOT

  You plan to use Power Query Editor to get data from an API.

  The API returns a JSON response.

  You have a username and password tor the API.

  Which data source and authentication method should you use to connect to the API? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 102:

  You are building a Power Bl report.

  Users will view the report by using their mobile device.

  You need to configure the report to display data based on each user s location.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. For the relevant columns, set synonyms to match common geographical terms.
  B. From Power Query Editor, detect the data types of the relevant columns.
  C. Use the columns of the geography data type in all visuals.
  D. Create a hierarchy for columns of the geography data type.
  E. In Data Category, set the geographic data category for the relevant columns.
  C. Use the columns of the geography data type in all visuals.
  E. In Data Category, set the geographic data category for the relevant columns.

• Question 103:

  You have the tables shown in the following table.

  

  The Impressions table contains approximately 30 million records per month.

  You need to create an ad analytics system to meet the following requirements:

  1. Present ad impression counts for the day, campaign, and Site_name.

  2. The analytics for the last year are required.

  3. Minimize the data model size.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Group the impressions by Ad_id, Site_name, and Impression_date.Aggregate by using the CountRows function.
  B. Create one-to-many relationships between the tables.
  C. Create a calculated measure that aggregates by using the COUNTROWS function.
  D. Create a calculated table that contains Ad_id, Site_name, and Impression_date.
  A. Group the impressions by Ad_id, Site_name, and Impression_date.Aggregate by using the CountRows function.
  B. Create one-to-many relationships between the tables.

  ---

  Explanation

  Grouping in power query reduces the number of rows in the impression table that is gonna be loaded in the model. Creating relationships doesn't increase the size of the model.

• Question 104:

  HOTSPOT

  You have a Power BI semantic model.

  You discover that he semantic model contains values that display as errors.

  You need to use data profiling feature in Power Query to preview the date and identify the issues.

  What should you select to gain into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area.

  NOTE: Each correct answer is worth one point.

  

  

• Question 105:

  You have a Power BI semantic model named Model1 that contains two fields named Sales and Quarter. Model1 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
  C. 100% stacked area chart

• Question 106:

  DRAG DROP

  You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.

  You need to build the dashboard.

  Which four 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:

  

  

  ---

  When you view dashboards in portrait mode on a phone, you notice the dashboard tiles are laid out one after another, all the same size. In the Power BI service, you can create a customized view of a dashboard, specifically for portrait mode on phones.

  Step 1: Open the Dashboard.

  Step 2: Change the dashboard view to Phone view

  Step 3: Pin items from the reports to the dashboard.

  Step 4: Rearrange, resize, or remote items from the Phone view.

  Create a phone view of a dashboard 1. In the Power BI service, open a dashboard (Step 1)

  2. Select the arrow next to Web view in the upper-right corner > select Phone view. (Step2)

  

  The phone dashboard edit view opens. Here you can unpin, resize, and rearrange tiles to fit the phone view. The web version of the dashboard doesn't change.

  3. Select a tile to drag, resize, or unpin it. You notice the other tiles move out of the way as you drag a tile.

  The unpinned tiles go in the Unpinned tiles pane, where they stay unless you add them back.

  4. If you change your mind, select Reset tiles to put them back in the size and order they were before.

  5. When you're satisfied with the phone dashboard layout, select the arrow next to Phone view in the upper-right corner > select Web view.

  Power BI saves the phone layout automatically.

• Question 107:

  You have a semantic model named Model1 that contains sales data.

  You need to ensure that Modell is refreshed on the first day of each month to include last month's sales data.

  What should you configure?

  A. an on-premises data gateway
  B. a Microsoft Rower Automate flow
  C. an incremental refresh
  D. a scheduled refresh
  D. a scheduled refresh

• Question 108:

  You attempt to connect Purer 81 Desktop to a Cassandra database.

  From the Get Data connector list you discover that there is no specific connector for the Cassandra database, You need to select an alternate data connector that will connect to the database.

  Which of connector should you choose?

  A. Microsoft SQL Server database
  B. ODBC
  C. OData
  D. OLE DB
  B. ODBC

• Question 109:

  HOTSPOT

  You plan to create a Power Bl dataset to analyze attendance at a school. Data will come from two separate views named View1 and View? in an Azure SQL database. View1 contains the columns shown in the following table.

  

  View2 contains the columns shown in the following table.

  

  The views can be related based on the Class ID column.

  Class ID is the unique identifier for the specified class, period, teacher, and school year. For example, the same class can be taught by the same teacher during two different periods, but the class will have a different class ID.

  You need to design a star schema data model by using the data in both views. The solution must facilitate the following analysis:

  1. The count of classes that occur by period

  2. The count of students in attendance by period by day

  3. The average number of students attending a class each month

  In which table should you include the Teacher First Name and Period Number fields? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 110:

  You build a Power Bi report that displays loT temperature data streaming from a refrigerator.

  You publish the report to the Power BI service.

  You need to be notified when the temperature rises above four degrees Celsius.

  What should you do?

  A. Set an alert on a KPI visual in the report.
  B. Pin a card visual to a dashboard and create a subscription.
  C. Pin a card visual to a dashboard and set an alert on the tile.
  D. Pin a report page to a dashboard and set an alert on the page.
  C. Pin a card visual to a dashboard and set an alert on the tile.