Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Power BI — Question 100

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?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer, A, suggests using Import for external customers, which allows better performance for handling multiple concurrent requests due to preloaded data. DirectQuery for the security team is appropriate as it can enforce local security rules directly on the database, ensuring data access restrictions are maintained. The other options either compromise performance for external customers or do not enforce security protocols correctly.