PL-300 Exam – Practice 12 Welcome to your PL-300 Exam - Practice 12 Question 1 You create several Power Bl report pages.You need to make the report pages more interactive for users.To answer, drag the appropriate Power Bl feature for the stated requirement.“Share feedback on visuals with other users” Buttons Selection pane Bookmarks Comments Question 2 You administer Power Bl for your organization.You prevent users from adding custom visuals from Microsoft AppSource by disabling the Allow visuals created using the Power Bl SDK option in the tenant settings of the Power Bl service.You need to provide a set of custom visuals for users to add to their reports in the Power Bl service.What should you do? Publish the custom visuals to the Partner Center. Apply an Active Directory Group Policy to set the EnableCustomMsuals registry key. Give users the .pbiviz files for the permitted custom visuals to import themselves. Add the permitted custom visuals to Organizational visuals. Question 3 You create a Power Bl dashboard for streaming data from Azure IOT devices.You need to configure Power Bl to visualize the IOT telemetry data. For each of the following statements, select Yes if the statement is true. Otherwise, select No.1. The streaming data is added in the data model in Power Bl Desktop.2. The real-time data visual is added directly to the dashboard.3. Azure Stream Analytics can supply streaming data for Power BI 1. Yes 2. Yes 3. Yes 1. No 2. Yes 3. Yes 1. Yes 2. No 3. No 1. No 2. No 3. Yes 1. Yes 2. Yes 3. No 1. No 2. Yes 3. No Question 4 You create a Power Bl report.You need to improve report navigation.Which options should you use for the stated task?“Preserve slicer selection of a specific report page” Buttons Bookmarks Question 5 You create a report page and pin the page to a dashboard in the Power BI service. You receive many enquiries from users asking you about the data and requesting additional visuals on the dashboard.You need to enable the Q&A feature that appears as “Ask a Question about your data” at the top of the dashboard above the visuals.How should you enable this feature?Solution: Enable the Q&A option in settings for the dashboard.Does this solution meet the goal? Yes No Question 6 You create a report page and pin the page to a dashboard in the Power BI service. You receive many enquiries from users asking you about the data and requesting additional visuals on the dashboard.You need to enable the Q&A feature that appears as “Ask a Question about your data” at the top of the dashboard above the visuals.How should you enable this feature?Solution: Add the Q&A visual to the report page.Does this solution meet the goal? Yes No Question 7 You create a report about product sales and customer churn rates.You need to restrict the visual to show the top five products with the highest churn rates.Solution: Use the Q&A Visual to find the top five products.Does this solution meet the goal? Yes No Question 8 Imagine you have created a query named Customers in a Power BI Desktop to append the rows from three external tables with customer data into a single output table named Customers.What would be the best approach to add a new fabricated ID column to the Customers table to ensure that every row in the Customers table contains a unique ID value? Modify the data model by extending the Customers table with an Index column Modify the data model by extending the Customers table with a Counter column Modify the Customers query by adding a Counter column Modify the Customers query by adding an Index column Question 9 You have a dataset that contains survey results for the percentage of internet access by year, age, and gender. The age of the respondents is between 15 and 85 years old.You need to create a bar chart showing the percentage of internet access for equal age ranges of 10 years. Which four actions should you perform in sequence? To answer, select the appropriate actions from the below listed options. 1. Set Group type to Bin. 2. Set the Bin type to Number of bins. 3. Set the Bin count to 7. 4. Set the Bin size to 7. 1. Right click on the Age column and select New Group. 2. Set Group type to List. 3. Set the Bin size to 7. 4. Set the Bin count to 10. 1. Right click on the Age column and select New Group. 2. Set Group type to Bin. 3. Set the Bin type to Number of bins. 4. Set the Bin count to 10. 1. Right click on the Age column and select New Group. 2. Set Group type to Bin. 3. Set the Bin type to Number of bins. 4. Set the Bin count to 7 Question 10 You build a Power Bl report showing vendor purchases. The dataset contains five hundred to a thousand rows.You need to add a visual that enables users to easily identify the outliers in the data. Which type of visual should you add? Scatter chart Chord Key influencers Decomposition Tree Question 11 You are creating a Power Bl report for products ordered from vendors for the purchasing department. The purchasing department monitors suppliers and their performance against a suite of metrics.The department needs a visualization to assist in identifying the factors that affect vendor performance. Which type of visualization should you add? Key influencers Q&A KPI Decomposition Tree Question 12 You create a Power Bl report that shows the visual in the below exhibit. You need to show how the relationship between costs and sales changes over the months in the year.What should you do? Add a relative date slicer to the page. Add the month column to the Play Axis option for the visual. Create a quick measure to calculate the month-over-month change of sales. Add a Ratio line in the Analytics pane. Question 13 You create a report about product sales and customer churn rates.You need to restrict the visual to show the top five products with the highest churn rates.Solution: Create a measure of the top five products using the RANKX DAX function.Does this solution meet the goal? Yes No Question 14 You have a Power BI Pro license.You want to use the Al features of Power BI to enhance your data.For each of the following statements, select Yes if the statement is true. Otherwise, select No.1. You can analyze text in your dataset for positive or negative sentiment in Power Bl Desktop2. The Key Influencers visual requires a Power BI premium subscription3. You can create your own machine learning models and invoke the models from Power Bl Desktop. 1. No 2. No 3. No 1. No 2. Yes 3. No 1. No 2. No 3. Yes 1. Yes 2. Yes 3. No 1. Yes 2. No 3. No 1. Yes 2. No 3. Yes Question 15 The marketing team needs a new dashboard to show the uptake of social users on the company’s corporate forum. The dashboard will contain one particular report that shows the total number of users that registered for the site in each of the months of the year. For this report you want to create a dataset with a calculated column that displays the date with the abbreviated month name followed by the four digit year e.g. Jan 2018.Which DAX expression should you use? FORMAT( [RegistrationDate], "MM yyyy") FORMAT( [RegistrationDate], "mm yyyy") FORMAT( [RegistrationDate], "MMM yyyy") Question 16 You are a data analyst for a retail organization.You need to show a histogram of the quantity of items in a basket by the size of the basket. A sample set of the data is shown in the below exhibit.You create a measure for the count of the quantity column.How should you create the histogram? Select the appropriate options for the visual fields. The visual to use: Matrix chart The axis on the visual: Quantity The visual to use: Clustered column chart The axis on the visual: Measure The axis on the visual: Group Question 17 You use the Key influencer visual to analyze which product lines influence customers’ decisions to choose certain payment methods.You need to create a key influencer visual, as shown in the exhibit.Payment method is cashPayment method is credit cardPayment method is e-walletHow should you configure the visual? To answer, select the appropriate options for the setup screen menus. Explain by > Payment Method Explain by > Product Line Analyze > Payment Method Analyze > Product Line Explain by > Sales Analyze > Sales Question 18 You are creating a Power Bl report for service requests received in your call center. The support department wants to be able to perform ad hoc analysis on calls against the company product range and determine the drivers behind incoming call volumes.You need to allow users to perform root cause analysis.Which visual should you use? Key influencers Treemap Waterfall Decomposition tree Question 19 How to create a chart by “Asking Question” feature? Modeling > Ask Question Double Click on Report View Home > Ask Question Question 20 You create a report about product sales and customer churn rates.You need to restrict the visual to show the top five products with the highest churn rates.Solution: Create a measure of the top five products using the TOPN DAX function.Does this solution meet the goal? Yes No Question 21 You create a report about product sales and customer churn rates.You need to restrict the visual to show the top five products with the highest churn rates.Solution: Apply Top N filter on Visual (Visual level filter)Does this solution meet the goal? Yes No Question 22 Which of the following strategies are recommended when designing the queries to import data from an OLTP-style database into a Power Bl Desktop project? Refactoring the imported tables into a multidimensional cube. Normalizing the data model to make it better suited for data analysis and reporting Refactoring the imported tables into a star schema. Denormalizing the data model to make it better suited for data analysis and reporting. Question 23 You create a Power Bl report. You want users to analyze a dataset containing time series data to identify patterns and trends.You need to configure the report using an animation to show data changes over time. What are two possible ways to achieve this goal? Each correct answer presents a complete solution. Add the Time Brush visual from AppSource. Add a Slicer to the report page and configure it as Relative Date. Add the Play Axis (Dynamic Slicer) visual from AppSource. Add a Scatter chart and set the Play Axis option. Add the date field to the X Axis and set the Type to Continuous. Question 24 When you optimize a data model for Q&A, which factor is the most important? Column names Data model size Row count DAX Formulas Question 25 What is true about using variables in DAX? Variables are created only one time in the current context Variables must be defined inside return Maximum of 5 variables can be created per formula. Question 26 What are the reasons for which you might use calculated tables? To union tables To create a table based on the result of a function or formula To improve the speed and performance of an existing table To perform different types of merge join Question 27 You are creating a Power Bl report for products ordered by customers. You create a bar chart showing the number of units sold by product.You need to configure the chart to show the average number of units sold per order.What are two possible ways to achieve this goal? Each correct answer presents a complete solution. Right click on the units sold column in Fields, add a new group, and set the bin size to 50. Create a measure using the AVERAGE DAX function and replace the number of units sold with the measure. Create a measure using the PERCENTILE DAX function at 50 percent and replace the number of units sold with the measure. Right click on the units sold in Values for the visual and change the summarization to Average. Right click on the units sold in Values for the visual and set show values as percent of grand total. Question 28 You create a Power Bl report containing a line chart that shows sales by month as shown in Exhibit 1 below.Exhibit 1You need to configure the visual as shown in Exhibit 2 below. Exhibit 2What should you do? Add a trend line in the Analytics pane. Add an Average line in the Analytics pane. Add a Play Axis to the visual Add a forecast in the Analytics pane Question 30 You use the Decomposition tree visual to analyze sales across different attributes, payment methods, and product lines, as shown in the below exhibit.You need to create the visual. How should you complete the configuration? To answer, select the appropriate options for the setup menu. Explain by (first field) > Sales Explain by (second field) > Sales Explain by (second field) > Product Line Explain by (second field) > Payment Method Explain by (first field) > Payment Method Analyze > Sales Question 31 You create a Power Bl report and dashboard.You need to allow users to add new visuals to Power Bl dashboards with minimal configuration.What should you do? Add the Q&A visual to a report page and pin the page as a new dashboard. Add the Q&A button to a report page and pin the page as a new dashboard. Use the View insights option from a visual on a dashboard. Enable the Q&A option in Page information on the report page. Question 32 You are building Power Bl dashboards using a dataset shared with you. The data is unfamiliar to you and you do not know which visualizations to create.You need to use the Quick Insights feature to help you build your report.For each of the following statements, select Yes if the statement is true. Otherwise, select No.1. The Quick insights feature is available in Power Bl Desktop.2. The Quick insights feature requires that the storage mode on the data source is set to DirectQuery.3. The Quick insights feature can discover the overall trends in a time series. 1. Yes 2. No 3. No 1. Yes 2. Yes 3. Yes 1. No 2. No 3. Yes 1. No 2. Yes 3. Yes 1. Yes 2. No 3. Yes 1. No 2. No 3. No Question 33 Which of the following types of real-time datasets in Power Bl always store their data in Azure SQL Database? Streaming Datasets Push Datasets Hybrid Datasets Question 34 You need to assign the appropriate workspace roles to co-workers to perform certain tasks. You must use the lowest permission level necessary to accomplish the tasks.Which roles should you use? To answer, select the appropriate option.“To publish apps” Member Contributor Viewer Question 35 You have a Power Bl dataset that consists of a fact table and the market dimension tables as shown in the exhibit. The fact table has 25,000 records. The market table has four records corresponding to business areas, MarketA, MarketB, MarketC, and MarketD.You create a Power Bl report containing visualizations for this data. You need to configure Power Bl so that users can only see the data for the business area they belong to.Which five actions should you perform in sequence? To answer, select the appropriate list of actions. 1. Select the dimension table. 2. Add a DAX expression to filter the data using market. 3. Create roles in Power Bl Desktop. 4. Publish to Power Bl service. 5. Assign each user to a role. 1. Create roles in Power Bl Desktop. 2. Select the dimension table. 3. Add a DAX expression to filter the data using userprincipalname. 4. Select the fact table. 5. Publish to Power Bl service. 1. Select the dimension table. 2. Add a DAX expression to filter the data using userprincipalname. 3. Select the fact table. 4. Assign each user to a role. 5. Publish to Power Bl service. 1. Create roles in Power Bl Desktop. 2. Select the dimension table. 3. Add a DAX expression to filter the data using market. 4. Publish to Power Bl service. 5. Assign each user to a role. Question 36 You create a new workspace named Department and publish your Power Bl report to this workspace.You need to distribute a report among the executives without giving them direct access to the workspace.Which four options are essential for an app to be published for the first time? Each correct answer presents part of the solution. Under the Setup tab, provide the App name and description. Select the Department workspace. Under the Permissions tab, specify users who can view the app. Under the Navigation tab, provide report name. Click the Publish App button. Click the Update App button. Question 37 You create a Power Bl workspace in the new workspace experience.You need to permit the following groups of users to access the workspace to perform specific actions on workspace content. You must use the principle of least privilege.• Users in GroupA must be able to publish Power Bl apps.• Users in GroupB must be able to publish Power Bl reports.• UserC must be able to build reports using the workspace datasets in different workspaces without any additional configuration.Which workspace role should you assign to the users? To answer, select the appropriate role to the below-stated user.“Users in GroupA” Member Viewer Admin Contributor Question 38 Which of the following resources are automatically provisioned when you create a new app workspace in the Power Bl Service? A storage container for Power Bl resources including datasets, reports and dashboards An Office 365 Group which triggers the creation of a SharePoint team site An Azure Active Directory user account to serve as the workspace identity A shared capacity which is used to host the workspace Question 39 You create datasets, reports, and dashboards in Power Bl.You need to make these assets easily available to other users and indicate how they should be used. You need to configure the assets to meet the requirements.To answer, select the appropriate option for the below requirement.“Configure a dashboard so that the sensitivity of its data is visible” Featured Certified Promoted Data Classification Question 40 You create a Power Bl workspace in the new workspace experience.You need to permit the following groups of users to access the workspace to perform specific actions on workspace content. You must use the principle of least privilege.• Users in GroupA must be able to publish Power Bl apps.• Users in GroupB must be able to publish Power Bl reports.• UserC must be able to build reports using the workspace datasets in different workspaces without any additional configuration.Which workspace role should you assign to the users? To answer, select the appropriate role for the below-stated user.“UserC” Viewer Contributor Admin Member Question 41 Overview:Company1 is a manufacturing company that is adopting Power BI for its analytics and insights requirements.Power Bl Desktop and Power Bl Service will be used to generate reports and dashboards for Operations, Human Resources, Sales, and Finance departments.Management are concerned over access to data and reports.You need to plan the setup, security and administration of the Power Bl environment.You will run a pilot with the Sales department to verify your proposed configuration before deploying the other departments.Existing environment:Company1 has Office 365 deployed.Company1 uses Azure AD Security groups for access control.Office 365 Groups are used for collaboration.Data Sources:Excel spreadsheets will be the source of data for the pilot.There are other data sources that will be used after the pilot:SQL ServerSharePoint listsJSON filesZendeskReport development:There is a team of business intelligence analysts who will create the reports and dashboards.This team will load, transform, and cleanse the data. They will then model the data and create datasets for use across the organization.Changes made by the developers should be automatically deployed to users.Security requirements:Developers should not have access to production data.Developers should not have access to reports and dashboards in production.Business users should not have access to developer data or assets.Board members must be able to access select reports and dashboards.Excel files used in reports should only be accessible from their workspace.Users must only have access to the data in their department.Users in the Sales department must only have access to data in their territory.The reports and dashboards for a department should only be accessible by business users in the same department.Business users should not be able to edit the reports and dashboards. Business users should not be able to create new reports or dashboards.Board members are not part of the company network.Requirement:How should you configure Power Bl workspaces to meet the security requirements for management of reports and dashboards? Create a workspace for development. Create a deployment pipeline and assign the development workspace to the development stage. Define data source rules, and deploy to test and production. Create separate workspaces for development and production Share the dataset from the developer workspace to the production workspace. Create the reports and dashboards in the production workspace. Create a single workspace. Publish an app for business users. Create a single workspace. Share the reports and dashboards with business users. Question 42 You need to assign the appropriate workspace roles to co-workers to perform certain tasks. You must use the lowest permission level necessary to accomplish the tasks.Which roles should you use? To answer, select the appropriate option.“To read workspace reports” Member Viewer Contributor Question 43 You have Power Bl Premium with allocated capacity.You import data into Power Bl from a webpage and create a Power Bl report. You need to ensure that the data for your visuals that is extracted from the web page is up to date.You decide to automate the updating process from the data source. How and where should you configure the dataset to meet the requirements?“The storage mode that requires a refresh schedule to be configured..” Import Live Connect DirectQuery Question 44 Data in your organization must be classified as either None, Personal, or Confidential.You need to protect confidential data in your Power BI reports within Power Bl and when data is exported from Power BI. Information protection has been enabled on your Power Bl tenant.Which three actions should you perform in sequence? To answer, select the appropriate list of actions. 1. Create and publish labels in Microsoft 365. 2. Open Tenant settings in Power Bl Admin Portal. 3. Select the sensitivity label. 1. Create and publish labels in Microsoft 365. 2. Open the settings pane on the Power Bl report. 3. Select the sensitivity label. 1. Open the settings pane on the Power Bl report. 2. Set Export data to None. 3. Add a data classification tag. 1. Open Tenant settings in Power Bl Admin Portal. 2. Select the sensitivity label. 3. Add a data classification tag. Question 45 You create a Power Bl workspace in the new workspace experience.You need to permit the following groups of users to access the workspace to perform specific actions on workspace content. You must use the principle of least privilege.• Users in GroupA must be able to publish Power Bl apps.• Users in GroupB must be able to publish Power Bl reports.• UserC must be able to build reports using the workspace datasets in different workspaces without any additional configuration.Which workspace role should you assign to the users? To answer, select the appropriate role to the below-stated user.“Users in GroupB” Admin Contributor Member Viewer Question 46 You implement a security role named EmployeeAddress to filter employees based on their login account in the Power Bl service.You need to add 100 users to this role so they can view a report based on row-level security settings.Which two actions should you perform? Each correct answer presents part of the solution. Add the newly created Power BI group to the EmployeeAddress security role. Add the newly created security group to the EmployeeAddress security role. Create a group in Power Bl and assign users to this group. Create a security group in Active Directory and assign users to this group. Question 47 You have a data model as shown in the below exhibit for sales opportunity data. Each salesperson has a sales manager. You create a Power Bl report for a sales team’s opportunities. Salespeople must only be able to see their own data. Sales managers must be able to see all data. You create a DAX measure to calculate the monthly commission amount on sales.You need to configure row-level security (RLS) and create two roles named SalesPerson and SalesManager. Salespeople are assigned to the SalesPerson role. Sales managers are assigned to the SalesManager role.For each of the following statements, select Yes if the statement is true. Otherwise, select No.1. Setting the DAX Filter expression on the SalesPerson role to [Email Address] = userprincipalname() allows salespeople to only view their own data.2. Salespeople will be able to see their commission amount.3. Setting the DAX Filter expression on the SalesManager role to FALSE() allows Sales managers to view all data. 1. Yes 2. Yes 3. Yes 1. Yes 2. No 3. No 1. Yes 2. Yes 3. No 1. No 2. No 3. No 1. Yes 2. No 3. Yes 1. No 2. No 3. Yes Question 48 You need to create Power Bl reports using multiple data sources. The reports are not up to date.You need to discover which data source has stale data.What should you do? Use the Lineage view feature. Download the PBIX file for the report. Analyze in Excel. View the usage metrics report. Question 49 Overview:Company1 is a manufacturing company that is adopting Power BI for its analytics and insights requirements.Power Bl Desktop and Power Bl Service will be used to generate reports and dashboards for Operations, Human Resources, Sales, and Finance departments.Management are concerned over access to data and reports.You need to plan the setup, security and administration of the Power Bl environment.You will run a pilot with the Sales department to verify your proposed configuration before deploying the other departments.Existing environment:Company1 has Office 365 deployed.Company1 uses Azure AD Security groups for access control.Office 365 Groups are used for collaboration.Data Sources:Excel spreadsheets will be the source of data for the pilot.There are other data sources that will be used after the pilot:SQL ServerSharePoint listsJSON filesZendeskReport development:There is a team of business intelligence analysts who will create the reports and dashboards.This team will load, transform, and cleanse the data. They will then model the data and create datasets for use across the organization.Changes made by the developers should be automatically deployed to users.Security requirements:Developers should not have access to production data.Developers should not have access to reports and dashboards in production.Business users should not have access to developer data or assets.Board members must be able to access select reports and dashboards.Excel files used in reports should only be accessible from their workspace.Users must only have access to the data in their department.Users in the Sales department must only have access to data in their territory.The reports and dashboards for a department should only be accessible by business users in the same department.Business users should not be able to edit the reports and dashboards. Business users should not be able to create new reports or dashboards.Board members are not part of the company network.Requirement:You need to create a workspace for report development.What should you add when creating the workspace? The pbix file containing the dataset The name of an Office 365 Group The name of an Azure AD Security group The URL of a OneDrive location Question 50 Which of the following resources are automatically provisioned when you create a new app workspace in the Power Bl Service?An Office 365 Group which triggers the creation of a SharePoint team site A shared capacity, which is used to host the workspace A storage container for Power Bl resources including datasets, reports, and dashboards An Azure Active Directory user account to serve as the workspace identity Question 51 You have Power Bl Premium with allocated capacity.You import data into Power Bl from a webpage and create a Power Bl report. You need to ensure that the data for your visuals that is extracted from the web page is up to date.You decide to automate the updating process from the data source. How and where should you configure the dataset to meet the requirements?“The number of time slots per day that can be configured in the refresh schedule..” 1 8 48 Question 52 Overview:Company1 is a manufacturing company that is adopting Power BI for its analytics and insights requirements.Power Bl Desktop and Power Bl Service will be used to generate reports and dashboards for Operations, Human Resources, Sales, and Finance departments.Management are concerned over access to data and reports.You need to plan the setup, security and administration of the Power Bl environment.You will run a pilot with the Sales department to verify your proposed configuration before deploying the other departments.Existing environment:Company1 has Office 365 deployed.Company1 uses Azure AD Security groups for access control.Office 365 Groups are used for collaboration.Data Sources:Excel spreadsheets will be the source of data for the pilot.There are other data sources that will be used after the pilot:SQL ServerSharePoint listsJSON filesZendeskReport development:There is a team of business intelligence analysts who will create the reports and dashboards.This team will load, transform, and cleanse the data. They will then model the data and create datasets for use across the organization.Changes made by the developers should be automatically deployed to users.Security requirements:Developers should not have access to production data.Developers should not have access to reports and dashboards in production.Business users should not have access to developer data or assets.Board members must be able to access select reports and dashboards.Excel files used in reports should only be accessible from their workspace.Users must only have access to the data in their department.Users in the Sales department must only have access to data in their territory.The reports and dashboards for a department should only be accessible by business users in the same department.Business users should not be able to edit the reports and dashboards. Business users should not be able to create new reports or dashboards.Board members are not part of the company network.Requirement:How should you provide access for Board members? Publish the reports to the web with Publish to web. Create an app and share it with the Board member email addresses. Add the Board members as users to Office 365 and add the users to the workspace. Add the Board members as guests in Azure AD B2B, create an app, and invite the guest users. Question 53 You create datasets, reports, and dashboards in Power Bl.You need to make these assets easily available to other users and indicate how they should be used. You need to configure the assets to meet the requirements.To answer, select the appropriate option for the below requirement.“List a report on the Power BI Home page” Certified Featured Promoted Data Classification Question 54 You are a data analyst at a company that uses Power Bl. The company has 12 departments. You have created a Power Bl report that shows data for the organization’s staff and training from the HR dataset. You have been asked to create the same report for each department.What are two possible ways to achieve this goal? Each correct answer presents a complete solution. Add a parameter to the report. Create a URL for each department to filter the report by the department. Create a dataset for each department, copy the report, and use the report with the department dataset. Create a workspace for each department and add the report to the workspace. Question 55 You have Power Bl Premium with allocated capacity.You import data into Power Bl from a webpage and create a Power Bl report. You need to ensure that the data for your visuals that is extracted from the web page is up to date.You decide to automate the updating process from the data source. How and where should you configure the dataset to meet the requirements?“The tool where the refresh schedule is configured..” Power BI Desktop Power BI Service Power BI Mobile Question 56 You need to assign the appropriate workspace roles to co-workers to perform certain tasks. You must use the lowest permission level necessary to accomplish the tasks.Which roles should you use? To answer, select the appropriate option.“To publish content to the workspace” Contributor Admin Member Question 57 Overview:Company1 is a manufacturing company that is adopting Power BI for its analytics and insights requirements.Power Bl Desktop and Power Bl Service will be used to generate reports and dashboards for Operations, Human Resources, Sales, and Finance departments.Management are concerned over access to data and reports.You need to plan the setup, security and administration of the Power Bl environment.You will run a pilot with the Sales department to verify your proposed configuration before deploying the other departments.Existing environment:Company1 has Office 365 deployed.Company1 uses Azure AD Security groups for access control.Office 365 Groups are used for collaboration.Data Sources:Excel spreadsheets will be the source of data for the pilot.There are other data sources that will be used after the pilot:SQL ServerSharePoint listsJSON filesZendeskReport development:There is a team of business intelligence analysts who will create the reports and dashboards.This team will load, transform, and cleanse the data. They will then model the data and create datasets for use across the organization.Changes made by the developers should be automatically deployed to users.Security requirements:Developers should not have access to production data.Developers should not have access to reports and dashboards in production.Business users should not have access to developer data or assets.Board members must be able to access select reports and dashboards.Excel files used in reports should only be accessible from their workspace.Users must only have access to the data in their department.Users in the Sales department must only have access to data in their territory.The reports and dashboards for a department should only be accessible by business users in the same department.Business users should not be able to edit the reports and dashboards. Business users should not be able to create new reports or dashboards.Board members are not part of the company network.Requirement:What are two possible ways to control access to data in the Sales department? Each correct answer presents a complete solution. Create workspaces for each territory and assign users in each territory the Member role. Publish the app from the Sales workspace and set Allow all users to connect to the app's underlying datasets using the Build permission. Publish the app from the Sales workspace and add the users in the Sales department to the app. Assign the Viewer role in the Sales workspace to the users in the Sales department. Question 58 You create a Power Bl report with a very large dataset. You want to improve the performance of the dataset refresh by using incremental refresh.For each of the following statements, select Yes if the statement is true. Otherwise, select No.1. The Incremental Refresh feature should only be used on data sources that support query folding.2. Two PowerQuery parameters named RangeStart and RangeEnd are required for an incremental refresh.3. A date field is required on a table in the dataset. 1. No 2. No 3. Yes 1. Yes 2. Yes 3. Yes 1. Yes 2. No 3. Yes 1. Yes 2. Yes 3. No 1. No 2. No 3. No 1. No 2. Yes 3. Yes Question 59 How would you specify title of a tile visual on a dashboard? Click the ellipses on the tile, select "Open in focus" mode, place the new value in the title box and click Apply Navigate to the report from which the tile was pinned, select Edit on the Menu bar, select the visual on which the tile is based, navigate to the format section beneath the Visualizations pane, change the title of the visual, and save the report Click the ellipses on the tile, select Edit details, place the new value in the title box. and click Apply Click the ellipses on the tile, select Edit details, place the new value in the subtitle box, and click Apply Question 60 To complete the sentence below, select the appropriate option. Promoted Certified Question 61 You create a Power Bl dataset and report for a multi-national organization. You configure row-level security (RLS) in the data model. Users are restricted to accessing rows only for their own country. You should follow the best practices for managing security.You create roles for each country. You add a DAX Filter expression for each role on the country table. You add the Azure Active Directory (Azure AD) security group for the country to each role. A new user starts in Country A.You need to ensure that the user can only view data for Country A. What should you do? Manage roles in Power Bl Desktop and change the DAX filter expression on the role for Country A. Add the user to the Azure AD security group for County A. Change Access in the Power BI workspace and add the user's email address with the Member role. Edit Security on the dataset in Power BI service and add the user's email address to the role for Country A. Question 62 You create datasets, reports, and dashboards in Power Bl.You need to make these assets easily available to other users and indicate how they should be used. You need to configure the assets to meet the requirements.To answer, select the appropriate option for the below requirement.“Make a dataset discoverable without requiring permission from the Power BI Admin” Data Classification Certified Promoted Featured Question 63 You manage the Power Bl admin portal. Company policy says that only specific people can create new workspaces. You have a security group named WorkspaceCreator. Some new users complain that they are unable to create a new workspace. These users are already added to WorkspaceCreator security group. You need to allow these users to create new workspaces within the stated guidelines.Which four actions should you perform in sequence in the Power Bl admin portal? To answer, move the appropriate actions from the list of possible actions to the answer area and arrange them in the correct order. 1. Go to Power Bl admin portal > Tenant settings. 2. Choose Workspace settings > Create workspaces (new workspace experience). 3. Under Apply to, choose Specific security groups, and add the WorkspaceCreator security group. 4. Click Apply. o 1. Choose Workspace settings > Create workspaces (new workspace experience). 2. Click Apply. 3. Go to Power Bl admin portal > Tenant settings. 4. Choose Workspace settings > Block classic workspace creation. 1. Go to Power Bl admin portal > Tenant settings. 2. Choose Workspace settings > Block classic workspace creation. 3. Under Apply to, choose Specific security groups, and add the WorkspaceCreator security group. 4. Click Apply. 1. Choose Workspace settings > Block classic workspace creation. 2. Go to Power Bl admin portal > Tenant settings. 3. Under Apply to, choose Specific security groups, and add the WorkspaceCreator security group. 4. Click Apply. Time's up Trần Quân PL-300 Exam – Practice 11 PL-300 Exam – Practice 13