Microsoft Certified Azure Enterprise Data Analyst Associate · Free Practice Question Hard
Question 14
What storage mode should be used to achieve optimal response time for each user group in a reporting solution with the following requirements:
- External customer reports, which require support for 500 concurrent requests and access to approximately 7 GB of data stored in Azure Synapse Analytics.
- Security team reports, which require local security rules applied at the database level to restrict access to 2 GB of data being reviewed.
- A Import data for external customers and use DirectQuery for the security team.
- B Use DirectQuery for external customers and import data for the security team.
- C Use DirectQuery for both external customers and the security team.
- D Import data for both external customers and the security team.
Reveal correct answer
Correct answer: A
Explanation
The best storage mode for each group of users in this scenario is to use Import mode for the external customers and DirectQuery mode for the security team. Import mode is suitable for the external customers because it provides the best response time for large datasets like the 7 GB data stored in Azure Synapse Analytics. By importing the data into Power BI, the reports can be optimized for performance and handle the 500 concurrent requests efficiently. On the other hand, DirectQuery mode is ideal for the security team because it allows local security rules to be applied at the database level, ensuring restricted access to the 2 GB of data being reviewed. DirectQuery mode enables real-time access to the data source, ensuring that the security rules are enforced and providing the necessary level of control for the security team.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
