ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-500 All Questions

View all questions & answers for the DP-500 exam
Go to Exam

Exam DP-500 topic 1 question 87 discussion

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

You have a 2-GB Power BI 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.

  • A. Enable service principal authentication for read-only admin APIs.
  • B. Connect the target workspace to an Azure Data Lake Storage Gen2 account.
  • C. Turn on Large dataset storage format.
  • D. Enable XMLA read-write.
Show Suggested Answer Hide Answer
Suggested Answer: CD 🗳️
by Saffar at Jan. 11, 2023, 6:42 a.m.

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
Submit Cancel
hoss29
1 year, 5 months ago
Selected Answer: CD
Enable XMLA read-write to connect the dataset to Tabular Editor Enable the large dataset format to get better performance, as this is recommended even for datasets that do not qualify as large (10GB) https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools
upvoted 1 times
...
Eltooth
1 year, 10 months ago
Selected Answer: CD
C and D are correct answers.
upvoted 3 times
...
ThariCD
2 years, 2 months ago
You need XMLA read-write for Tabular Editor for metadata operations: https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools And as pointed out below, you need to enable the Large dataset storage format when using XMLA endpoint write operations
upvoted 3 times
...
Saffar
2 years, 3 months ago
correct https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-large-models
upvoted 3 times
stfglv
2 years, 3 months ago
The part after "even" from that link removes all doubt considering that the dataset in question is only 2GB: While required for datasets to grow beyond 10 GB, enabling the Large dataset storage format setting has other benefits. If you're planning to use XMLA endpoint-based tools for dataset write operations, be sure to enable the setting, even for datasets that you wouldn't necessarily characterize as a large dataset. When enabled, the large dataset storage format can improve XMLA write operations performance.
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago