Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 51:

  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 in 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. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

  B. Change the data type of the Logged column to Date.

  C. Split the Logged column by using at as the delimiter.

  D. Apply a transformation to extract the first 11 characters of the Logged column.

  Correct Answer: C

  Simply create a custom table in Power Query, enter the date shown in the question into a column called Date, and then Split it by a delimiter. No need for spaces on either side of "at" Power BI takes care of the rest:

  = Table.SplitColumn(#"Changed Type", "Date", Splitter.SplitTextByDelimiter("at", QuoteStyle.Csv), {"Date.1", "Date.2"})

  It will even automatically change the type to Date:

  = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Date.1", type date}, {"Date.2", type time}})

• Question 52:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

  During the development process, you need to import a sample of the data from the Order table.

  Solution: You add a report-level filter that filters based on the order date.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  The filter is applied after the data is imported. Instead add a WHERE clause to the SQL statement.

  Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

• Question 53:

  You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique.

  In powerbi.com, when users load the visual, they only see some of the customers.

  What is the cause of the issue?

  A. The visual was built by using a different version of R.

  B. The data comes from a Microsoft SQL Server source.

  C. The data is deduplicated.

  D. Too many records were sent to the visual.

  Correct Answer: D

  R visuals in the Power BI service have a few limitations including:

  Data size limitations ?data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image. Additionally, the input data has a

  limit of 250 MB.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals

• Question 54:

  A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow. You need to use the dataflow in a report. The solution must meet the following requirements:

  1.

  Minimize online processing operations.

  2.

  Minimize calculation times and render times for visuals.

  3.

  include data from the current year, up to and including the previous day. What should you do?

  A. Create a dataflows connection that has Import mode selected and schedule a dairy refresh.

  B. Create a dataflows connection that has DirectQuery mode selected.

  C. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset

  D. Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.

  Correct Answer: A

• Question 55:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

  You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

  Solution: You create a new query that references DataSourceExcel.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  Instead modify the source step of the queries to use DataSourceExcel as the file path.

  Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.

  Reference:

  https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

• Question 56:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen,

  You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

  You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

  Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

  Instead modify the source step of the queries to use DataSourceExcel as the file path.

  Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.

  Reference:

  https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

• Question 57:

  You have a sales system that contains the tables shown in the following table.

  

  The Date table is marked as a date table.

  DatelD is the date data type. You need to create an annual sales growth percentage measure.

  Which DAX expression should you use?

  A. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])

  B. (SUM(`Sales'[sales_amount]) - CALCULATE(SUM(`Sales'[sales_amount]), SAMEPERIODLASTYEAR(`Date'[DateID]))) / CALCULATE(SUM(`Sales'[sales_amount]), SAMEPERIODLASTYEAR(`Date'[DateID]))

  C. CALCULATE(SUM(sales[sales_amount]), DATESYTD(`Date'[DateID]))

  D. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(`Date'[DateID]))

  Correct Answer: B

  SAMEPERIODLASTYEAR returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.

  Reference: https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

• Question 58:

  From Power 61 Desktop, you publish a new dataset and report lo a Power Bl workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset. What should you do?

  A. From Power Bl Desktop, change the Row-Level Security settings.

  B. From Power Bl Desktop, import a table that contains the HR team members

  C. From powerbi.com.add users to the HR role for the dataset.

  D. From powerbi.com, share the dataset to the HR team members.

  Correct Answer: C

• Question 59:

  You have a Microsoft Power Bl dashboard.

  You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.

  What should you use?

  A. Feedback

  B. Subscribe

  C. Comments

  D. Mark as favorite

  Correct Answer: C

  https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment

• Question 60:

  You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting. What should you do?

  A. From Power Bl Desktop, customize the current theme,

  B. From power Bl Desktop, use a built in report theme.

  C. Create a theme as a JSON file and import the theme into Power Bl Desktop.

  D. Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop.

  Correct Answer: B