Practice Free DP-500 Exam Online Questions

DRAG DROP

You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset is used by one report.

You need to prevent project managers from accessing the data in two columns in Table1 named Budget and Forecast.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: From Power BI Desktop, create a role named Project Managers.

Create roles

You can define roles within Power BI Desktop.

Step 2: Open Tabular Editor

Under Tables, select the table to which you want to apply a DAX rule.

In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = “Value”.

Step 3: From Power BI Desktop, add a DAX filter to the Project Managers role.

Step 4: For Table1, the Budget and Forecast columns, set the permissions to None.

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

You have a Power Bl report that contains one visual.

You need to provide users with the ability to change the visual type without affecting the view for other users.

What should you do?

Reveal Solution Hide Solution

DRAG DROP

You are using DAX Studio to query an XMLA endpoint.

How should you complete the DAX expression? To answer, drag the appropriate values to the targets. Each value may be used once, more than once. may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: CALCULATE

Box 2: CURRENTGROUP

CURRENTGROUP returns a set of rows from the table argument of a GROUPBY expression that belong to the current row of the GROUPBY result.

Remarks

This function can only be used within a GROUPBY expression.

This function takes no arguments and is only supported as the first argument to one of the following aggregation functions: AVERAGEX, COUNTAX, COUNTX, GEOMEANX, MAXX, MINX, PRODUCTX,

STDEVX.S, STDEVX.P, SUMX, VARX.S, VARX.P.

Note: COUNTX counts the number of rows that contain a non-blank value or an expression that evaluates to a non-blank value, when evaluating an expression over a table.

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

DRAG DROP

You plan to create a Power Bl report that will use an OData feed as the data source. You will retrieve all the entities from two different collections by using the same service root

The OData feed is still in development. The location of the feed will change once development is complete.

The report will be published before the OData feed development is complete.

You need to minimize development effort to change the data source once the location changes.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Create a parameter that contains the service root URI

Step 2: Get data from OData feed source and use the parameter to populate the first part of the URL.

The URI is in the first part of the query.

Example: let

Source = OData.Feed ("https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/WorkItemSnapshot? "

&"$apply=filter( "

&"WorkItemType eq ‘Bug’ "

&"and StateCategory ne ‘Completed’ "

&"and startswith(Area/AreaPath,'{areapath}’) "

&"and DateValue ge {startdate} "

&") "

&"/groupby( "

&"(DateValue,State,WorkItemType,Priority,Severity,Area/AreaPath,Iteration/IterationPath,AreaSK), "

&"aggregate($count as Count) "

&") "

,null, [Implementation="2.0",OmitValues = ODataOmitValues.Nulls,ODataVersion = 4])

in

Source

Box 3: From Advanced Editor, duplicate the query and change the resource path in the URL.

Choose Get Data, and then Blank Query.

From the Power BI Query editor, choose Advanced Editor.

The Advanced Editor window opens.

Edit the query.

Etc.

Reference: https://docs.microsoft.com/en-us/azure/devops/report/powerbi/odataquery-connect

You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to score the dataset to identify the likelihood of an engine failure.

Which function should you use in the query?

Reveal Solution Hide Solution

HOTSPOT

You have an Azure Synapse notebook.

You need to create the visual shown in the following exhibit.

How should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: fill_between

atplotlib.pyplot.fill_between fills the area between two horizontal curves.

The curves are defined by the points (x, y1) and (x, y2). This creates one or multiple polygons describing the filled area.

Box 2: suptitle

Set the title of the visual.

suptitle adds a centred title to the figure.

Reference:

https://matplotlib.org/3.1.1/api/_as_gen/matplotlib.pyplot.fill_between.html#matplotlib.pyplot.fill_between

https://matplotlib.org/3.1.1/api/_as_gen/matplotlib.pyplot.suptitle.html#matplotlib.pyplot.suptitle

Topic 4, Misc. Questions

You develop a solution that uses a Power Bl Premium capacity. The capacity contains a dataset that is expected to consume 50 GB of memory.

Which two actions should you perform to ensure that you can publish the model successfully to the Power Bl service? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

You need to recommend a solution for the analysts in the Finance and Accounting business unit to mitigate the increase in maintenance of their assets in the Power Bl tenant.

Which two actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

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 se 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 have a Power Query query in a Power Bl report. The query maps source database columns to the input columns of a time series machine learning model.

You discover that the model fails to process a source time field.

You need to ensure that the model processes the field.

Solution: You add a Power Query step to convert the time column into an integer column that represents the number of minutes.

Does this meet the requirement?

Reveal Solution Hide Solution

You have an Azure Synapse Analytics notebook.

You run the xxsq1 magic command to render data into an Apache Spark DataFrame named df1, and

then you run the following code.

display (df1, summary = true)

Which three attributes will be returned by the command? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution