Microsoft Power BI Certification (PL-300) Practice Test 12

E-commerce analytics races the promotion calendar. Analysts cannot wait a week to learn that a landing page failed or that returns erased the margin. Power BI joins web, order, and inventory data into a report merchandisers can filter by campaign or region. Data scientists add propensity context so the dashboard explains who may buy again, not only who bought yesterday. PL-300 tells hiring teams you can productionize that view. Certification benefits include a Microsoft-backed signal and a better shot at roles that list BI certification as a plus. Run this Free Microsoft Power BI Data Analyst Associate Certification (PL-300) Practice Test 12 as a timed set so exam day is not your first full sitting. Retailers such as Target, Home Depot, and eBay hire analysts for this work. U.S. base pay varies by city and industry: junior data analysts often earn $58,000–$75,000, mid-level analysts commonly earn $78,000–$108,000, and senior data analysts frequently reach $112,000–$145,000. Synergisticit JOPP helps jobseekers get certified, prepared, and hired at top tech companies through our Job Placement programs—Java DevOps Full Stack JOPP and Data Science JOPP.

If you want to learn how to get hired as a Power BI Data Analyst, Data Scientist, Data Engineer, AI or ML engineer, Java developer, or software engineer, contact Synergisticit for expert upskilling and marketing connections to companies. Visit Synergisticit Contact Us and Synergisticit JOPP.

Welcome to your Microsoft Power BI - Test-12

Name

Phone

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

Select 1 option(s):

Buttons

Selection pane

Bookmarks

Comments

Q2. 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?

Select 1 option(s):

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.

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

Select 1 option(s):

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

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

Select 1 option(s):

Buttons

Bookmarks

Q5. 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?

Select 1 option(s):

Yes

Q6. 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?

Select 1 option(s):

Yes

Q7. 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?

Select 1 option(s):

Yes

Q8. 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?

Select 1 option(s):

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

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

Select 1 option(s):

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

Q10. 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?

Select 1 option(s):

Scatter chart

Chord

Key influencers

Decomposition Tree

Q11. 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?

Select 1 option(s):

Key influencers

Q&A

KPI

Decomposition Tree

Q12. 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?

Select 1 option(s):

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.

Q13. 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?

Select 1 option(s):

Yes

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

Select 1 option(s):

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

Q15. 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?

Select 1 option(s):

FORMAT( [RegistrationDate], "MM yyyy")

FORMAT( [RegistrationDate], "mm yyyy")

FORMAT( [RegistrationDate], "MMM yyyy")

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

Select 2 option(s):

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

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

Select 2 option(s):

Explain by > Payment Method

Explain by > Product Line

Analyze > Payment Method

Analyze > Product Line

Explain by > Sales

Analyze > Sales

Q18. 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?

Select 1 option(s):

Key influencers

Treemap

Waterfall

Decomposition tree

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

Select 2 option(s):

Modeling > Ask Question

Double Click on Report View

Home > Ask Question

Q20. 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?

Select 1 option(s):

Yes

Q21. 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?

Select 1 option(s):

Yes

Q22. 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?

Select 2 option(s):

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.

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

Select 2 option(s):

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.

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

Select 1 option(s):

Column names

Data model size

Row count

DAX Formulas

Q25. What is true about using variables in DAX?

Select 1 option(s):

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.

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

Select 3 option(s):

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

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

Select 2 option(s):

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.

Q28. 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?

Select 1 option(s):

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

Q29. You have a table that contains details for your product sales as shown in the below exhibit.

The salesperson is recorded on each sale. You have 1000 products with data spanning 30 years.
You create a Power Bl report with visuals that contain aggregations with the following visuals:
• a column chart with products in the axis, but there are too many product columns displayed
• a bar chart with the year of order in the axis, but there are too many bars displayed
• a pie chart with the quantity of products per order as the legend but, there are too many slices
You need to combine the data to make the visual more readable.
How should you combine the data? To answer, select the appropriate option for each action.

Select 1 option(s):

1. List 2. List 3. List

1. List 2. List 3. Bin

1. Bin 2. Bin 3. Bin

1. List 2. Bin 3. List

1. Bin 2. List 3. List

1. List 2. Bin 3. Bin

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

Select 3 option(s):

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

Q31. 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?

Select 1 option(s):

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.

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

Select 1 option(s):

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

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

Select 1 option(s):

Streaming Datasets

Push Datasets

Hybrid Datasets

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

Select 1 option(s):

Member

Contributor

Viewer

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

Select 1 option(s):

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.

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

Select 4 option(s):

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.

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

Select 1 option(s):

Member

Viewer

Admin

Contributor

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

Select 1 option(s):

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

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

Select 1 option(s):

Featured

Certified

Promoted

Data Classification

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

Select 1 option(s):

Viewer

Contributor

Admin

Member

Q41. 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?

Select 1 option(s):

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.

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

Select 1 option(s):

Member

Viewer

Contributor

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

Select 1 option(s):

Import

Live Connect

DirectQuery

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

Select 1 option(s):

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.

Q45. You create a Power Bl workspace in the new workspace experience.

Admin

Contributor

Member

Viewer

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

Select 2 option(s):

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.

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

Select 1 option(s):

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

Q48. 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?

Select 1 option(s):

Use the Lineage view feature.

Download the PBIX file for the report.

Analyze in Excel.

View the usage metrics report.

Q49. 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?

Select 1 option(s):

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

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

Select 1 option(s):

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

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

Select 1 option(s):

Q52. 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?

Select 1 option(s):

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.

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

Select 1 option(s):

Certified

Featured

Promoted

Data Classification

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

Select 2 option(s):

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.

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

Select 1 option(s):

Power BI Desktop

Power BI Service

Power BI Mobile

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

Select 1 option(s):

Contributor

Admin

Member

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

Select 2 option(s):

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.

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

Select 1 option(s):

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

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

Select 1 option(s):

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

Q60. To complete the sentence below, select the appropriate option.

Select 1 option(s):

Promoted

Certified

Q61. 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?

Select 1 option(s):

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.

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

Select 1 option(s):

Data Classification

Certified

Promoted

Featured

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

Select 1 option(s):

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.

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.