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 97 discussion

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

You are implementing a reporting solution that has the following requirements:
Reports for external customers must support 500 concurrent requests. The data for these reports is approximately 7 GB and is stored in Azure Synapse Analytics.
Reports for the security team use data that must have local security rules applied at the database level to restrict access. The data being reviewed is 2 GB.
Which storage mode provides the best response time for each group of users?

  • A. Import for the external customers and DirectQuery for the security team.
  • B. DirectQuery for the external customers and import for the security team.
  • C. DirectQuery for the external customers and DirectQuery for the security team.
  • D. Import for the external customers and import for the security team.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by stfglv at Jan. 16, 2023, 1:46 p.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
louisaok
Highly Voted 2 years, 5 months ago
Selected Answer: A
Agree that A is correct. Thanks for your links.
upvoted 7 times
...
QuangTrinh
Highly Voted 2 years, 5 months ago
Selected Answer: A
A should be correct answer
upvoted 5 times
...
SamuComqi
Most Recent 1 year, 10 months ago
Selected Answer: A
I took the exam a few days ago (14/8/2023) and I passed the exam with a score of 915. My answer was: - Import for the external customers and DirectQuery for the security team.
upvoted 1 times
...
DarioReymago
2 years, 2 months ago
Selected Answer: A
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#the-underlying-source-defines-security-rules
upvoted 4 times
...
stfglv
2 years, 5 months ago
A is the correct answer. The external users problem is solved by Import mode, as explained here https://community.powerbi.com/t5/Service/One-report-for-multiple-users-simultaneously/m-p/1749731#M124530. And the security team requirements involves security at the data source level which can only be achieved through DirectQuery as explained under DirectQuery use cases on this link https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about.
upvoted 5 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