image


PL-300 Dumps

PL-300 Braindumps

PL-300 Real Questions PL-300 Practice Test

PL-300 Actual Questions


Microsoft


PL-300


Microsoft Power BI Data Analyst


https://killexams.com/pass4sure/exam-detail/PL-300


Question: 68


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.


image


Answer:

image


Explanation:

Graphical user interface, text


Description automatically generated with medium confidence 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.


Reference: https://docs.microsoft.com/en-us/power-query/append-queries


Question: 69


HOTSPOT


You are creating a column chart visualization.


You configure groups as shown in the Groups exhibit. {Click the Groups tab.)


image


The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)

image


For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.


image


Answer:

image


Question: 70


HOTSPOT


How should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.


image


Answer:

image


Explanation:


Box 1: Using a workspace membership Scenario:

The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.


Note: Workspace is a shared environment for a group of people. You can have multiple Power BI content in a workspace. One workspace can have hundreds of dashboards, reports, and datasets in it.


Box 2: A mail-enabled security group Scenario: Security Requirements

The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.


Question: 71

You need to minimize me size of the dataset. The solution must meet the report requirements.


What should you do?

  1. Change lite OrderlD column in the Orders table to the text data type.

  2. Filter out discontinued products while importing the Product table.

  3. Remove the QuantityPerUnit column from the Products table

  4. Group the Categories table by the CategorylD column.


Answer: D


Question: 72


You have five sales regions. Each region is assigned a single salesperson.


You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.


Salespeople must see only the data from their region.


You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.

A salesperson reports that she believes she should see more data. You need to verify what data the salesperson currently sees. What should you do?

  1. Use the Test as role option to view data as the salesperson’s user account.

  2. Use the Test as role option to view data as the Sales role.

  3. Instruct the salesperson to open the report in Microsoft Power Bl Desktop.

  4. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.


Answer: B Explanation:

Validate the roles within Power BI Desktop


image

After you’ve created your roles, test the results of the roles within Power BI Desktop. From the Modeling tab, select View as.


A picture containing application Description automatically generated

The View as roles window appears, where you see the roles you’ve created.


image


Graphical user interface, text, application Description automatically generated

Select a role you created, and then select OK to apply that role. The report renders the data relevant for that role. You can also select Other user and supply a given user. Graphical user interface, application

Description automatically generated


Select OK. The report renders based on what that user can see.


Reference: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls


Question: 73


Which DAX expression should you use to get the ending balances in the balance sheet reports?

  1. CALCULATE (

    SUM( BalanceSheet [BalanceAmount] ), DATESQTD( ‘Date'[Date] )

    )

  2. CALCULATE (

    SUM( BalanceSheet [BalanceAmount] ), LASTDATE( ‘Date'[Date] )

    )

  3. FIRSTNONBLANK ( ‘Date’ [Date]

    SUM( BalanceSheet[BalanceAmount] )

    )

  4. CALCULATE (

MAX( BalanceSheet[BalanceAmount] ), LASTDATE( ‘Date’ [Date] )

)

Answer: A Explanation:

Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter. DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context.


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


Question: 74


You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success .


Which type of visualization should you use?

  1. Key influences

  2. Funnel chart

  3. Q&A

  4. Line and clustered column chart


Answer: A Explanation:

The key influencers visual helps you understand the factors that drive a metric you’re interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers.

The key influencers visual is a great choice if you want to:


Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers


Question: 75


HOTSPOT


You are creating a quick measure as shown in the following exhibit.

image


You need to create a monthly rolling average measure for Sales over time.


How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

image


Answer:

image


Explanation:

Box 1: Total Sales


We select the field Total Sales Box 2: Date

Select a date field. Box 3: Month Monthly periods.

Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures


Question: 76


You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.

You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions. What should you recommend?

  1. Merge tables by using Power Query.

  2. Hide unused columns in the model.

  3. Split the model into multiple models.

  4. Transpose.


Answer: A Explanation:

Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.


When you have one or more columns that you’d like to add to another query, you merge the queries.


Note: The RELATEDTABLE function is a shortcut for CALCULATETABLE function with no logical expression. CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values. Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

Question: 77


You have a collection of reports for the HR department of your company.


You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.


Which type of visualization should you use?

  1. scatter chart

  2. ribbon chart

  3. line chart

  4. key influences


Answer: C Explanation:

The best data for forecasting is time series data or uniformly increasing whole numbers. The line chart has to have only one line.


Try forecasting: Try the new forecasting capabilities of Power View today on your own data or with the sample report available as part of the Power BI report samples. To view your own data, upload a workbook with a Power View time series line chart to Power BI for Office 365.


Reference: https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for- office-365


Question: 78


HOTSPOT


You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.


For each of the following statement, select Yes if the statement is true, Otherwise, select No. NOTE: Each correct selection is worth one point.


image


Answer:

image


image

6$03/( 48(67,216


7KHVH TXHVWLRQV DUH IRU GHPR SXUSRVH RQO\ )XOO YHUVLRQ LV XS WR GDWH DQG FRQWDLQV DFWXDO TXHVWLRQV DQG DQVZHUV


.LOOH[DPV FRP LV DQ RQOLQH SODWIRUP WKDW RIIHUV D ZLGH UDQJH RI VHUYLFHV UHODWHG WR FHUWLILFDWLRQ H[DP SUHSDUDWLRQ 7KH SODWIRUP SURYLGHV DFWXDO TXHVWLRQV H[DP GXPSV DQG SUDFWLFH WHVWV WR KHOS LQGLYLGXDOV SUHSDUH IRU YDULRXV FHUWLILFDWLRQ H[DPV ZLWK FRQILGHQFH +HUH DUH VRPH NH\ IHDWXUHV DQG VHUYLFHV RIIHUHG E\ .LOOH[DPV FRP


$FWXDO ([DP 4XHVWLRQV .LOOH[DPV FRP SURYLGHV DFWXDO H[DP TXHVWLRQV WKDW DUH H[SHULHQFHG LQ WHVW FHQWHUV 7KHVH TXHVWLRQV DUH XSGDWHG UHJXODUO\ WR HQVXUH WKH\ DUH XS WR GDWH DQG UHOHYDQW WR WKH ODWHVW H[DP V\OODEXV %\ VWXG\LQJ WKHVH DFWXDO TXHVWLRQV FDQGLGDWHV FDQ IDPLOLDUL]H WKHPVHOYHV ZLWK WKH FRQWHQW DQG IRUPDW RI WKH UHDO H[DP


([DP 'XPSV .LOOH[DPV FRP RIIHUV H[DP GXPSV LQ 3') IRUPDW 7KHVH GXPSV FRQWDLQ D FRPSUHKHQVLYH FROOHFWLRQ RI TXHVWLRQV DQG DQVZHUV WKDW FRYHU WKH H[DP WRSLFV %\ XVLQJ WKHVH GXPSV FDQGLGDWHV FDQ HQKDQFH WKHLU NQRZOHGJH DQG LPSURYH WKHLU FKDQFHV RI VXFFHVV LQ WKH FHUWLILFDWLRQ H[DP


3UDFWLFH 7HVWV .LOOH[DPV FRP SURYLGHV SUDFWLFH WHVWV WKURXJK WKHLU GHVNWRS 9&( H[DP VLPXODWRU DQG RQOLQH WHVW HQJLQH 7KHVH SUDFWLFH WHVWV VLPXODWH WKH UHDO H[DP HQYLURQPHQW DQG KHOS FDQGLGDWHV DVVHVV WKHLU UHDGLQHVV IRU WKH DFWXDO H[DP 7KH SUDFWLFH WHVWV FRYHU D ZLGH UDQJH RI TXHVWLRQV DQG HQDEOH FDQGLGDWHV WR LGHQWLI\ WKHLU VWUHQJWKV DQG ZHDNQHVVHV


*XDUDQWHHG 6XFFHVV .LOOH[DPV FRP RIIHUV D VXFFHVV JXDUDQWHH ZLWK WKHLU H[DP GXPSV 7KH\ FODLP WKDW E\ XVLQJ WKHLU PDWHULDOV FDQGLGDWHV ZLOO SDVV WKHLU H[DPV RQ WKH ILUVW DWWHPSW RU WKH\ ZLOO UHIXQG WKH SXUFKDVH SULFH 7KLV JXDUDQWHH SURYLGHV DVVXUDQFH DQG FRQILGHQFH WR LQGLYLGXDOV SUHSDULQJ IRU FHUWLILFDWLRQ H[DPV


8SGDWHG &RQWHQW .LOOH[DPV FRP UHJXODUO\ XSGDWHV LWV TXHVWLRQ EDQN DQG H[DP GXPSV WR HQVXUH WKDW WKH\ DUH FXUUHQW DQG UHIOHFW WKH ODWHVW FKDQJHV LQ WKH H[DP V\OODEXV 7KLV KHOSV FDQGLGDWHV VWD\ XS WR GDWH ZLWK WKH H[DP FRQWHQW DQG LQFUHDVHV WKHLU FKDQFHV RI VXFFHVV


7HFKQLFDO 6XSSRUW .LOOH[DPV FRP SURYLGHV IUHH [ WHFKQLFDO VXSSRUW WR DVVLVW FDQGLGDWHV ZLWK DQ\ TXHULHV RU LVVXHV WKH\ PD\ HQFRXQWHU ZKLOH XVLQJ WKHLU VHUYLFHV 7KHLU FHUWLILHG H[SHUWV DUH DYDLODEOH WR SURYLGH JXLGDQFH DQG KHOS FDQGLGDWHV WKURXJKRXW WKHLU H[DP SUHSDUDWLRQ MRXUQH\


'PS .PSF FYBNT WJTJU IUUQT LJMMFYBNT DPN WFOEPST FYBN MJTU

.LOO \RXU H[DP DW )LUVW $WWHPSW *XDUDQWHHG