You discover a poorly performing measure in a Power BI data model. You need to review the query plan to analyze the amount of time spent in the storage engine and the formula engine. What should you use?
It is 100% Dax Studio. Although Vertipaq Analyzer is part of DAX Stuidio, Vertipaq Analyzer only shows details about the tables and columns, not the time it took for each engine to execute the query.
It is confusing, but it is OK = D
Performance Analyzer can find out how each of your report elements, such as visuals and DAX formulas are performing.
Link: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer
I agree that it may be confusing that the Vertipaq is technically integrated into DAX studio BUT the Server Timings in DAX definitely show the information re. function and storage engine consumption (even visually with blue and yellow if that jogs your memory) whereas the information in Vertipaq analyzer are separated into tabs such as Table Tab, Relationship Tab and so on and do not mention the wanted information.
Weird question, Vertipaq Analyser is correct, but that is a feature in both DAX studio and Tabular Editor 3. I would pick B, but C and A could also be considered correct.
In DAX Studio this can be seen.. seems wrong answer
upvoted 2 times
...
This section is not available anymore. Please use the main Exam Page.DP-500 Exam Questions
Log in to ExamTopics
Sign in:
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.
cherious
Highly Voted 2 years, 6 months agojeroen12345
2 years, 6 months agosalvalcaraz
Most Recent 1 year, 6 months agoSamuComqi
1 year, 10 months agoDarioReymago
2 years, 2 months agosolref
2 years, 3 months agostfglv
2 years, 5 months agostfglv
2 years, 5 months agolouisaok
2 years, 5 months agojeroen12345
2 years, 6 months agojeroen12345
2 years, 6 months agoRamiel
2 years, 6 months agoMM_GG
2 years, 6 months ago