PL-300 Exam – Practice 12

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”

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?

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

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”

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?

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?

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?

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?

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.

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?

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?

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?

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?

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 Desktop
2. The Key Influencers visual requires a Power BI premium subscription
3. You can create your own machine learning models and invoke the models from Power Bl Desktop.

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?

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.

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 cash

Payment method is credit card

Payment method is e-wallet
How should you configure the visual? To answer, select the appropriate options for the setup screen menus.

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?

How to create a chart by “Asking Question” feature?

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?

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?

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?

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.

When you optimize a data model for Q&A, which factor is the most important?

What is true about using variables in DAX?

What are the reasons for which you might use calculated tables?

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.

You create a Power Bl report containing a line chart that shows sales by month as shown in Exhibit 1 below.

Exhibit 1
You need to configure the visual as shown in Exhibit 2 below.

Exhibit 2
What should you do?

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.

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?

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.

Which of the following types of real-time datasets in Power Bl always store their data in Azure SQL Database?

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”

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.

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.

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”

Which of the following resources are automatically provisioned when you create a new app workspace in the Power Bl Service?

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”

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”

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 Server
SharePoint lists
JSON files
Zendesk
Report 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?

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”

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..”

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.

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”

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.

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.

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?

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 Server
SharePoint lists
JSON files
Zendesk
Report 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?

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

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..”

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 Server
SharePoint lists
JSON files
Zendesk
Report 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?

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”

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.

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..”

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”

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 Server
SharePoint lists
JSON files
Zendesk
Report 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.

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.

How would you specify title of a tile visual on a dashboard?

To complete the sentence below, select the appropriate option.

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?

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”

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.