Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 311:

  You have a Power Bi model mat contains a table named Date. The Date table contains the following columns:

  1.

  Date

  2.

  Fiscal year

  3.

  Fiscal Quartet

  4.

  Month Name

  5.

  Calendar Year

  6.

  Week Number

  7.

  Month Number

  8.

  Calendar Quarter

  You need to create a calculated table based on the Date table. The calculated tab*e must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month. Which DAX function should you include in the table deflation?

  A. DATATABLE

  B. ADDCOLUMS

  C. SUMMARIZE

  D. CALCULATE

  Correct Answer: C

• Question 312:

  You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at 08:59.

  You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

  What should you do?

  A. Create a column by example that starts with 2018-12-31.

  B. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date

  C. Apply the parse function from the Date transformations options to the Logged column.

  D. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.

  Correct Answer: D

• Question 313:

  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.

  Correct Answer: CE

• Question 314:

  You are building a data model for a Power Bl report. You have data formatted as shown in the following table.

  

  You need to create a clustered bar chart as shown in the following exhibit.

  

  What should you do?

  A. From Power Query Editor, split the Machine-User column by using a delimiter.

  B. In a DAX function, create two calculated columns named Machine and User by using the substitute function.

  C. From Power Query Editor, create a column that contains the last three digits of the Machine-User column.

  D. in a DAX function, create two measures named Machine and User by using the substitute function.

  Correct Answer: A

• Question 315:

  You have a Power B1 report named ReportA.

  You have a Power B1 tenant that allows users to export data.

  You need to ensure that consumers of ReportA cannot effort any data from visuals.

  Which two actions should you perform? Each correct answer presents a complete solution.

  NOTE Each correct selection is worth one point.

  A. From Power B1 Desktop, modify the Data Load settings

  B. From the answer B1 service modify the Report settings.

  C. From Power B1 Desktop modify the Report settings

  D. From the Power B1 service, modify the dataset permissions.

  Correct Answer: BD

• Question 316:

  In Power BI Desktop, you have a dataset that contains a table.

  You create a table visual on a Power BI report page as shown in the following exhibit

  

  You need to configure the visual to display the referenced image instead of the URL in the Plant Image column. What should you do?

  A. Set the Data category of the Plant Image field to Image URL

  B. Set the Data type of the Plant Image field to Binary.

  C. Set the Data category of the Plant Image field to Web URL.

  D. From the Formatting tab. select Values, and then set URL icons to On for the table.

  Correct Answer: A

• Question 317:

  You have a Power Bl model that contains the following data.

  

  The Date table relates to the Sales table by using the Date columns.

  The model contains the following DAX measure.

  Total Sales = SUM(Sales[Sale])

  You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.

  Which DAX calculation should you use?

  A. CALCULATE < [Total Sales], OATEADD (Date[Date], -1, QUARTER))

  B. CALCULATE ([Total Sales], DATESQTD (Date[Date]))

  C. TOTALQTD ([Total Sales], Date[Date])

  D. CALCULATE < [Total Sales], PARALLELPERIOO (Date[Date], 1, QUARTER))

  Correct Answer: A

• Question 318:

  You have a Power BI model that contains a table named Sales. The Sales table contains the following columns:

  Order Line ID Product ID Unit Price Order ID

  Quantity

  Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within an order contains a different product ID.

  You need to write a DAX measure that counts the number of orders.

  Which formula should you use?

  A. CountRows('Sales')

  B. Count ('Sales'(Order ID])

  C. CountA (Sale** (Order ID])

  D. DistinctCount (sales'[Order ID])

  Correct Answer: D

• Question 319:

  You plan to use Power B1 to create sales invoices for customers. The solution must meet the following requirements:

  Sales invoices must be exported in a PDF format

  The PDF exports must show all columns and rows clearly.

  What should you create?

  A. a paginated report that contains a table

  B. an interactive report that contains a matrix

  C. a dashboard that contains a table

  D. an inlet active report that contains a table

  Correct Answer: A

• Question 320:

  You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

  Due Date

  Order Date

  Delivery Date

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

  Solution: You create measures that use the uSEREIATIOHSHIP DAX function to filter sales on the inactive relationships between the sales table and the date table.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B