← Back to exam page

DP-500 – Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI

Loading demo links...

Showing 4–6 of 10 questions

Question 4 (Misc. Questions)

You are configuring an aggregation table as shown in the following exhibit.

C:\Users\wk\Desktop\mudassar\Untitled.jpg

The detail table is named FactSales and the aggregation table is named FactSales(Agg).

You need to aggregate SalesAmount for each store.

Which type of summarization should you use for SalesAmount and StoreKey? To answer, select the appropriate options in the answer area,

NOTE: Each correct selection is worth one point.

C:\Users\wk\Desktop\mudassar\Untitled.jpg

Answer is in the explanation below.

Question 5 (Misc. Questions)

You have a Power Bl dataset that uses DirectQuery against an Azure SQL database.

Multiple reports use the dataset.

A database administrator reports that too many queries are being sent from Power Bl to the database.

You need to reduce the number of queries sent to the database. The solution must meet the following requirements:

• DirectQuery must continue to be used.

• Visual interactions in all the reports must remain as they are configured currently.

• Consumers of the reports must only be allowed to apply filters from the Filter pane.

Which two settings should you select? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    Disabling cross highlighting/filtering by default
  • ○

    Add a single Apply button to the filter pane to apply changes at once
  • ○

    Add an Apply button to each slicer to apply changes when you're ready
  • ○

    Add Apply buttons to all basic filters to apply changes when you're ready
  • ○

    Ignore the Privacy Levels and potentially improve performance
Question 6 (Misc. Questions)

You have a 2-GB Power Bl dataset.

You need to ensure that you can redeploy the dataset by using Tabular Editor. The solution must minimize how long it will take to apply changes to the dataset from powerbi.com.

Which two actions should you perform in powerbi.com? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point

Select all that apply, then click Submit answer.

  • ○

    Enable service principal authentication for read-only admin APIs.
  • ○

    Turn on Large dataset storage format.
  • ○

    Connect the target workspace to an Azure Data Lake Storage Gen2 account.
  • ○

    Enable XMLA read-write.