Exam DP-500 topic 1 question 179 discussion

Actual exam question from Microsoft's DP-500

Question #: 179
Topic #: 1

You have a Power BI dataflow named DF1 that contains the following columns:

• OrderID
• SaleDate
• ProductID
• SalesAmount
• ProductCategory

You create a Power BI dataset named DS1 that uses DF1 as a data source. DS1 creates an aggregated view of the data in DF1. The view contains the following columns:

• SaleMonth
• SalesAmount
• ProductCategory

You need to minimize how long it takes to refresh DS1.

What should you do first?

A. Add a computed entity to DF1.
B. Create a custom function in DS1.
C. Create a linked entity in DF1.
D. Add a computed column to DS1.

Show Suggested Answer

Suggested Answer: A 🗳️

by Qordata at Dec. 10, 2023, 4:25 p.m.

Comments

Submit Cancel

MaryemSB

1 year, 6 months ago

Selected Answer: A

"To perform in-storage computations, you first must create the dataflow and bring data into that Power BI dataflow storage. After you have a dataflow that contains data, you can create computed tables, which are tables that do in-storage computations." https://learn.microsoft.com/en-us/power-query/dataflows/computed-tables

upvoted 3 times

...