Microsoft Certified Azure Enterprise Data Analyst Associate · Free Practice Question Medium
Question 21
Company Profile -
Contoso, Ltd. is a firm that provides enriched financial data to a diverse range of external clients. Contoso operates a main office in Los Angeles and two branch offices in New York and Seattle.
Current Environment -
Data Infrastructure -
Contoso operates a 50-TB data warehouse on an instance of SQL Server on Azure Virtual Machines. This data warehouse feeds an Azure Synapse Analytics workspace accessed by external clients, who currently have access to all data. Contoso has a single Power BI workspace named FinData, which contains one dataset comprising global financial data. This workspace is utilized by 10 internal users and one external client. The dataset sources data from the data warehouse and the Synapse Analytics serverless SQL pool. Users frequently execute Transact-SQL queries on the Synapse Analytics workspace.
User Challenges -
Contoso has identified the following user issues:
Some users report slow rendering of visuals in Power BI reports when applying filter selections.
Users report occasional query failures against the serverless SQL pool due to exceeding the size of tempdb.
Users report outdated data in Power BI reports, with the refresh process of the Power BI model occasionally timing out.
Proposed Changes -
Contoso plans to implement the following changes:
Integrate an external JSON data source accessible via the REST API into the existing Power BI dataset.
Construct a new dataset in the FinData workspace using data from the Synapse Analytics dedicated SQL pool.
Provide each client with their own Power BI workspace for creating their own reports, each using the new dataset in the FinData workspace.
Implement subscription levels for clients, with each subscription level providing access to specific rows of financial data.
Deploy prebuilt datasets to Power BI to streamline the query experience for clients.
Enable internal users to incorporate machine learning models loaded to the dedicated SQL pool.
You are tasked with recommending a solution for the client workspace to support the planned changes.
Which two configurations should be included in your recommendation? Each correct answer forms part of the solution.
NOTE: Each correct selection is worth one point.
- A Share the financial data on the internet.
- B Set up the FinData workspace to utilize a Power BI Premium capacity.
- C Provide the Build authorization for the financial data to every customer.
- D Enable the Use datasets across workspaces setting.
Reveal correct answers
Correct answers: C, D
Explanation
To support the planned changes and provide customers with their own Power BI workspace to create their own reports, two configurations should be included in the recommendation. First, granting the Build permission for the financial data to each customer is necessary to allow them access to the underlying dataset and create their own reports. This ensures that customers have the necessary permissions to work with the data and build their own visualizations. Second, enabling the ""Use datasets across workspaces"" setting is important to allow customers to utilize the new dataset in the FinData workspace. This configuration enables customers to access and use the dataset from their own workspaces, providing them with the necessary data for their reports. These two configurations together provide the required access and functionality for customers to create their own reports using the new dataset.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.
