Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 281:

  HOTSPOT

  You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.

  

  You need to add a new column that contains the data in the format of nnn-nnn-nnnn.

  How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  References: https://docs.microsoft.com/en-us/powerquery-m/text-replace https://docs.microsoft.com/en-us/powerquery-m/text-end

• Question 282:

  HOTSPOT

  You have a power BI tenant that hosts the datasets shown in the following table.

  

  You have the following requirements:

  1.

  The export of reports that contain Personally Identifiable Information (Pll) must be prevented.

  2.

  Data used for financial decisions must be reviewed and approved before use.

  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:

  

• Question 283:

  HOTSPOT

  You have a column named UnitsInStock as shown in the following exhibit.

  

  UnitsInStock has 75 non-null values, of which 51 are unique.

  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: 75

  Box 2: reduce

  They reduce from the number of values (75), to the number of unique values (51).

  Reference:

  https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data

• Question 284:

  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.

  Hot Area:

  

  Correct Answer:

  

  Box 1: CONTOSO BIKES report

  Box 2: three datasets

  Images, tweets and the Contoso datasets.

• Question 285:

  HOTSPOT

  You are building a financial report by using Power BI.

  You have a table named financials that contains a column named Date and a column named Sales.

  You need to create a measure that calculates the relative change in sales as compared to the previous quarter.

  How should you complete the measure? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: CALCULATE

  Box 2: DATEADD

  Box 3: DIVIDE

  Example:

  NET_SALES QoQ% =

  IF(

  ISFILTERED('Calendar'[Date]),

  ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),

  VAR __PREV_QUARTER =

  CALCULATE(

  SUM('research ra_qtr_template'[NET_SALES]),

  DATEADD('Calendar'[Date].[Date], -1, QUARTER)

  )

  RETURN

  DIVIDE(

  SUM('research ra_qtr_template'[NET_SALES]) - __PREV_QUARTER,

  __PREV_QUARTER

  )

  )

  Reference:

  https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/m-p/547054

• Question 286:

  HOTSPOT

  You are creating a Microsoft Power BI imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.

  You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

  

  The related dimension tables are imported into the model. Sales contains the data shown in the following table.

  

  You are evaluating how to optimize the model.

  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:

  

  Reference: https://finance-bi.com/power-bi-basket-analysis/

• Question 287:

  HOTSPOT

  You are enhancing a Power BI model that has DAX calculations.

  You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.

  Which DAX functions should you use? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Reference: https://www.kasperonbi.com/get-the-ytd-of-the-same-period-last-year/

• Question 288:

  HOTSPOT

  You have a Power BI report.

  You need to create a calculated table to return the 100 highest spending customers.

  How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: TOPN

  TOPN returns the top N rows of the specified table.

  Box 2: SUMMARIZE

  SUMMARIZE returns a summary table for the requested totals over a set of groups.

  Box 3: DESC

  Sort in descending order.

  It is last in the TOPN command.

  TOPN syntax:

  TOPN(,

  , , [[, , []]...])

  Question 289:

  HOTSPOT

  You have the Power BI data model 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 290:

  HOTSPOT

  You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:

  1.

  CustomerID

  2.

  Customer City

  3.

  Customer State

  4.

  Customer Name

  5.

  Customer Address 1

  6.

  Customer Address 2

  7.

  Customer Postal Code

  The Invoice table contains the following fields:

  1.

  Order ID

  2.

  Invoice ID

  3.

  Invoice Date

  4.

  Customer ID

  5.

  Total Amount

  6.

  Total Item Count

  The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.

  The Power BI model must provide the following information:

  The number of customers invoiced in each state last month

  The average invoice amount per customer in each postal code

  You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.

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

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: One-to-many

  A customer can have many invoices within one month.

  Box 2: Single

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

  Single cross filter direction means "single direction", and Both means "both directions". A relationship that filters in both directions is commonly described as bi-directional.

  • 1
  • 2
  • ...
  • 28
  • 29
  • 30
  • 31
  • ...
  • 34
  • 35

  Related Exams:

  • 62-193

    Technology Literacy for Educators

  • 70-243

    Administering and Deploying System Center 2012 Configuration Manager

  • 70-355

    Universal Windows Platform – App Data, Services, and Coding Patterns

  • 77-420

    Excel 2013

  • 77-427

    Excel 2013 Expert Part One

  • 77-725

    Word 2016 Core Document Creation, Collaboration and Communication

  • 77-726

    Word 2016 Expert Creating Documents for Effective Communication

  • 77-727

    Excel 2016 Core Data Analysis, Manipulation, and Presentation

  • 77-728

    Excel 2016 Expert: Interpreting Data for Insights

  • 77-731

    Outlook 2016 Core Communication, Collaboration and Email Skills

  Tips on How to Prepare for the Exams

  Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Microsoft exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your PL-300 exam preparations and Microsoft certification application, do not hesitate to visit our Vcedump.com to find your solutions here.