Microsoft Power BI Test – 12

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”

Select 1 option(s):

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?

Select 1 option(s):

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.

Select 1 option(s):

You need to improve report navigation.
Which options should you use for the stated task?
“Preserve slicer selection of a specific report page”

Select 1 option(s):

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?

Select 1 option(s):

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?

Select 1 option(s):

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?

Select 1 option(s):

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?

Select 1 option(s):

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.

Select 1 option(s):

You need to add a visual that enables users to easily identify the outliers in the data. Which type of visual should you add?

Select 1 option(s):

The department needs a visualization to assist in identifying the factors that affect vendor performance. Which type of visualization should you add?

Select 1 option(s):

You need to show how the relationship between costs and sales changes over the months in the year.
What should you do?

Select 1 option(s):

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?

Select 1 option(s):

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.

Select 1 option(s):

Which DAX expression should you use?

Select 1 option(s):

You need to allow users to perform root cause analysis.
Which visual should you use?

Select 1 option(s):

Select 2 option(s):

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?

Select 1 option(s):

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?

Select 1 option(s):

Select 2 option(s):

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.

Select 2 option(s):

Select 1 option(s):

Select 1 option(s):

Select 3 option(s):

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.

Select 2 option(s):

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

Exhibit 2
What should you do?

Select 1 option(s):

You need to allow users to add new visuals to Power Bl dashboards with minimal configuration.
What should you do?

Select 1 option(s):

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.

Select 1 option(s):

Select 1 option(s):

Which roles should you use? To answer, select the appropriate option.
“To publish apps”

Select 1 option(s):

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.

Select 1 option(s):

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.

Select 4 option(s):

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”

Select 1 option(s):

Select 1 option(s):

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”

Select 1 option(s):

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”

Select 1 option(s):

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?

Select 1 option(s):

Which roles should you use? To answer, select the appropriate option.
“To read workspace reports”

Select 1 option(s):

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

Select 1 option(s):

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.

Select 1 option(s):

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”

Select 1 option(s):

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.

Select 2 option(s):

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.

Select 1 option(s):

You need to discover which data source has stale data.
What should you do?

Select 1 option(s):

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?

Select 1 option(s):

An Office 365 Group which triggers the creation of a SharePoint team site

Select 1 option(s):

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

Select 1 option(s):

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?

Select 1 option(s):

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”

Select 1 option(s):

What are two possible ways to achieve this goal? Each correct answer presents a complete solution.

Select 2 option(s):

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

Select 1 option(s):

Which roles should you use? To answer, select the appropriate option.
“To publish content to the workspace”

Select 1 option(s):

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.

Select 2 option(s):

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.

Select 1 option(s):

Select 1 option(s):

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?

Select 1 option(s):

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”

Select 1 option(s):

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.

Select 1 option(s):