DA-100 Exam Prep - Topic 5

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have several reports and dashboards in a workspace. You need to grant all organizational users read access to a dashboard and several reports. Solution: You publish an app to the entire organization. Does this meet the goal?
A. Yes
B. No
Click the card to flip 👆
1 / 13
Terms in this set (13)
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have several reports and dashboards in a workspace. You need to grant all organizational users read access to a dashboard and several reports. Solution: You publish an app to the entire organization. Does this meet the goal?
A. Yes
B. No
B. No
You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design. What should you use?
A. comments
B. tiles
C. Microsoft Information Protection sensitivity labels
D. Active Directory groups
C. Microsoft Information Protection sensitivity labels
You have a Power BI tenant. You have reports that use financial datasets and are exported as PDF files. You need to ensure that the reports are encrypted. What should you implement?
A. dataset certifications
B. row-level security (RLS)
C. sensitivity labels
D. Microsoft Intune policies
C. sensitivity labels
Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI. You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.
What should you recommend?

A. Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.
B. Create one workspace for development. From the new workspace, publish an app for production.
C. Create a workspace for development and a workspace for production. From the production workspace, publish an app.
D. In one workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.
C. Create a workspace for development and a workspace for production. From the production workspace, publish an app.
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager.
You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.
How should you provision access to the reports for the HR managers?

A. Publish the reports to a different workspace other than the one hosting the datasets.
B. Publish the reports in an app and grant the HR managers access permission.
C. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.
D. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
B. Publish the reports in an app and grant the HR managers access permission.
You create a report by using Microsoft Power BI Desktop. The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your companyג€™s internal network. You plan to publish the report to the Power BI Service. What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?
A. a subscription
B. a scheduled refresh of the dataset
C. an OData feed
D. an On-premises data gateway
D. an On-premises data gateway
You have several reports and dashboards in a workspace. You need to grant all organizational users read access to a dashboard and several reports. Solution: You create an Azure Active Directory group that contains all the users. You share each report and dashboard to the group. Does this meet the goal?
A. Yes
B. No
A. Yes
You have several reports and dashboards in a workspace. You need to grant all organizational users read access to a dashboard and several reports. Solution: You assign all the users the Viewer role to the workspace. Does this meet the goal?
A. Yes
B. No
B. No
You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query. You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured. You need to ensure that the data is updated every morning. The solution must minimize configuration effort. Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A. Configure the dataset to use the existing On-premises data gateway.
B. Deploy an On-premises data gateway in personal mode.
C. Set the refresh frequency to Daily.
D. Configure the dataset to use the personal gateway.
A. Configure the dataset to use the existing On-premises data gateway.
C. Set the refresh frequency to Daily.
You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user?
A. Viewer
B. Contributor
C. Member
D. Admin
C. Member
DRAG DROP -You have a Microsoft Power BI workspace. You need to grant the user capabilities shown in the following table. The solution must use the principle of least privilege. Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:Member ContributorYou create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh. From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity. You discover that the dataset refresh fails after the refresh runs out of resources. What is a possible cause of the issue? A. Query folding is not occurring. B. You selected Only refresh complete periods. C. The data type of the column used to partition the data changed. D. A filter is missing on the report.A. Query folding is not occurring.You have several reports and dashboards in a workspace. You need to grant all organizational users read access to a dashboard and several reports. Solution: You enable included in app for all assets. Does this meet the goal? A. Yes B. NoB. No