DRAG DROP

You have the following two tables:

• Subscriber (SubscriberlD, Enroll mentDate, ServicePlan)

• Date (Date, Month, Week, Year)

There is a relationship between Subscriber [EnrollmentDate] and Date[Date].

You plan to create a KPI for the number of subscribers enrolled in the current year.

You need to create a goal that is five percent more than the number of subscribers enrolled during the previous calendar year.

How should you complete the DAX formula? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You 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:

References:

https://msdn.microsoft.com/en-us/library/hh272049(v=sql.110).aspx

https://msdn.microsoft.com/en-us/library/ee634770.aspx

You have a Power BI report that is configured to use row-level security (RLS).

You have the following roles:

– A manager role that limits managers to see only the sales data from the stores they manage.

– A region role that limits users to see only the data from their respective region

You plan to use Power BU Embedded to embed the report into an application. The application will authenticate the users.

You need to ensure that RLS is enforced when accessing the embedded report.

What should you do?

Reveal Solution Hide Solution

You have a Power BI report in an app workspace.

You plan to embed a report from the app workspace into a line-of-business application by using Power BI Embedded.

Which information should you provide to the application developers?

Reveal Solution Hide Solution

HOTSPOT

You have a Power BI model that has the following tables:

– Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)

– Salesperson (Salesperson_id, Salesperson_name, address)

– Product (Product_id, Product_Name)

You need to create the following relationships:

– Sales to Product

– Sales to Sales person

You need to ensure that you can create a report that displays the count of products sold by each salesperson.

How should you configure the relationships? To answer, drag the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

References: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

You have a power BI model that contains the following tables:

– Assets( AssetsID, AssetName, Purchase_DateID, Value)

– Date( DateID, Date, Month, Week, Year)

The tables have relationship. Date is marked as a date table in the Power BI model.

You need to create a measure to calculate the percentage that the total assets value increased since one year ago.

Which DAX formula should you use?

Reveal Solution Hide Solution

DRAG DROP

From Power BI Desktop, you publish an app that contains one dashboard and one report. Q&A is enabled on the dashboard.

In Q&A, a user types the query count of clients and fails to receive any results. The user then types the query count of subscribers and received the expected results.

You need to ensure that the user can use both queries to receive the same results.

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

Reveal Solution Hide Solution

Correct Answer:

You have a Power BI model for sales data.

You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period.

Which DAX function should you use?

Reveal Solution Hide Solution

HOTSPOT

You have the following tables.

You need to create a measure to calculate a running total of TransactionQuantity.

How should you complete the DAX formula? 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:

References: http://www.daxpatterns.com/cumulative-total/

Your organization has a Microsoft Office 365 subscription.

When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit. (Click the Exhibit button.)

You need to ensure that all the users can access the Power BI service.

What should you do first?

Reveal Solution Hide Solution