Question 1 of 30
In a corporate environment, a data analyst is tasked with creating a Power BI report that integrates data from multiple sources, including Azure SQL Database, Excel files, and SharePoint lists. The report needs to be shared with various stakeholders who require different levels of access. What is the most effective way to manage permissions and ensure that the report is securely shared while maintaining data integrity?
Utilize Power BI's built-in Row-Level Security (RLS) to restrict data access based on user roles and publish the report to the Power BI Service with appropriate sharing settings.
Share the report link directly with all stakeholders and rely on the default permissions set in Power BI.
Export the report to PDF format and distribute it via email to ensure that everyone has access to the same data.
Create separate reports for each stakeholder group to manage permissions manually.

Preparing for Microsoft DP-500 Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free