Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 261:

  HOTSPOT

  You have a Power Bl report.

  You have the following tables.

  

  You have the following DAX measure.

  Accounts :=

  CALCULATE (

  DISTINCTCOUNT (Balances[AccountID]),

  LASTDATE ('Date'[Date])

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

  It will show the total number of accounts that were live at the last day of the year only.

  Note:

  DISTINCTCOUNT counts the number of distinct values in a column.

  LASTDATE returns the last date in the current context for the specified column of dates.

  Box 2: No

  It will show the total number of accounts that were live at the last day of the month only.

  Box 3: Yes

  Reference:

  https://docs.microsoft.com/en-us/dax/distinctcount-function-dax https://docs.microsoft.com/en-us/dax/lastdate-function-dax

• Question 262:

  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.

  Hot Area:

  

  Correct Answer:

  

• Question 263:

  HOTSPOT

  You have a dataset that contains revenue data from the past year.

  You need to use anomaly detection in Power Bl to show anomalies in the dataset.

  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:

  

  Line Populate the axis with a date field

• Question 264:

  HOTSPOT

  You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR.

  You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements:

  1.

  Create reports that use the HR dataset.

  2.

  Publish the reports to WorkspaceB.

  3.

  Prevent the ability to modify the HR dataset.

  4.

  Prevent the ability to add users to WorkspaceB.

  Hot Area:

  

  Correct Answer:

  

• Question 265:

  HOTSPOT You are using Power Bi Desktop to connect to an Azure SQL database The connection is configured 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 solution is worth one point

  Hot Area:

  

  Correct Answer:

  

  https://docs.microsoft.com/en-us/power-query/connectors/azuresqldatabase The following table lists all of the advanced options you can set in Power Query Desktop and Power Query Online. Advanced option Description Command timeout in minutes If your connection lasts longer than 10 minutes (the default timeout), you can enter another value in minutes to keep the connection open longer. This option is only available in Power Query Desktop. SQL statement For information, go to Import data from a database using native database query. Include relationship columns If checked, includes columns that might have relationships to other tables. If this box is cleared, you won't see those columns. Navigate using full hierarchy If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data. Enable SQL Server Failover support If checked, when a node in the Azure SQL failover group isn't available, Power Query moves from that node to another when failover occurs. If cleared, no failover occurs.

• Question 266:

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

  You need to combine 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.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Append Queries as New.

  There are two primary ways of combining queries: merging and appending. When you have one or more columns that you'd like to add to another query, you merge the queries.

  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.

• Question 267:

  HOTSPOT

  You have two CSV files named Products and Categories. The Products file contains the following columns:

  1.

  ProductID

  2.

  ProduetName

  3.

  SupplierID

  4.

  CategoryID

  The Categories file contains the following columns:

  1.

  CategoryID

  2.

  CategoryName

  3.

  CategoryDescription

  From Power Bl Desktop, you import the files into Power Query Editor.

  You need to create a Power Bl dataset that will contain a single table named Product. The Product will table includes the following columns:

  1.

  ProductID

  2.

  ProductName

  3.

  SupplierID

  4.

  CategoryID

  5.

  CategoryName

  6.

  CategoryDescription

  How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 268:

  HOTSPOT

  You have a Power Bl report that contains a measure named Total Sales.

  You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. 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: TOTALYTD TOTALYTD evaluates the specified expression over the interval which begins on the first day of the year and ends with the last date in the specified date column after applying specified filters.

  Syntax: TOTALYTD (

  ,

  [, ]

  [, ]

  Expression - The expression to be evaluated.

  Dates - The name of a column containing dates or a one column table containing dates.

  Example:

  TOTALYTD ( -- 2007-01-01 : 2007-05-12

  [Sales Amount],

  'Date'[Date]

  Box 2: 'Date'[Date]

  Reference:

  https://dax.guide/totalytd/

• Question 269:

  HOTSPOT

  You have a dataset that has the permissions 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 270:

  HOTSPOT

  You are profiling data by using Power Query Editor.

  You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State 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:

  

  Box 1: 69

  69 distinct/different values.

  Note: Column Distribution allows you to get a sense for the overall distribution of values within a column in your data previews, including the count of distinct values (total number of different values found in a given column) and unique values

  (total number of values that only appear once in a given column).

  Box 2: 4

  Reference:

  https://systemmanagement.ro/2018/10/16/power-bi-data-profiling-distinct-vs-unique/