exam questions

Exam DP-500 All Questions

View all questions & answers for the DP-500 exam

Exam DP-500 topic 1 question 52 discussion

Actual exam question from Microsoft's DP-500
Question #: 52
Topic #: 1
[All DP-500 Questions]

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 sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this question, 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 BI dataset named Dataset1.
In Dataset1, you currently have 50 measures that use the same time intelligence logic.
You need to reduce the number of measures, while maintaining the current functionality.
Solution: From DAX Studio, you write a query that uses grouping sets.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
nbagchi
Highly Voted 2 years, 6 months ago
Selected Answer: B
Answer is No
upvoted 8 times
...
JasonVu
Highly Voted 2 years, 6 months ago
Answer should be No
upvoted 5 times
...
Alborz
Most Recent 1 year, 11 months ago
Selected Answer: B
Using grouping sets in DAX Studio allows you to create groups of measures, but it does not reduce the number of measures in the dataset. Grouping sets are used to aggregate data across multiple dimensions in a query result, but they do not help in reducing the number of individual measures.
upvoted 2 times
...
Eltooth
2 years ago
Selected Answer: B
B is correct answer. CG needed.
upvoted 1 times
...
DarioReymago
2 years, 3 months ago
Selected Answer: B
dax studio has no grouping set and calculation groups neither
upvoted 3 times
...
solref
2 years, 3 months ago
Selected Answer: B
Grouping set doesnt exist on DAX STUDIO https://community.powerbi.com/t5/Desktop/DAX-Grouping-Sets/m-p/2079648#M774276
upvoted 3 times
...
Madiba_kaka
2 years, 5 months ago
DAX has no grouping set: https://community.powerbi.com/t5/Desktop/DAX-Grouping-Sets/td-p/2078121
upvoted 2 times
...
ivanb94
2 years, 5 months ago
According to this: https://community.powerbi.com/t5/Desktop/DAX-Grouping-Sets/td-p/2078121, there is no such thing as a grouping set in DAX so the answer has to be no
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...