Week 6

Question 1

EASY Q1: 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 read workspace reports

Answer 1

Viewer

Question 2

Easy Q2: You need to create a row level security (RLS) role for a dataset. What should you do first?

Answer 2

In Power BI Desktop, open Manage roles

Question 3

Easy Q3: You manage a Power BI workspace in a shared capacity. The workspace contains a dataset named DS1. You plan to schedule the refresh of DS1. What is the maximum number of refreshes per day?

Answer 3

8 (NEEDS EXPLANATION)

Question 4

Easy Q4: You manage a Power BI premium per user workspace. What is the maximum number of data refreshes that can be scheduled each day?

Answer 4

48 (NEEDS EXPLANATION)

Question 5

Easy Q5: You are evaluating whether you need to create a dashboard in Power BI. In which scenario do you need a dashboard instead of a report in Power BI?

Answer 5

You need to display visuals that use different datasets

Question 6

Easy Q6: Your company has a SharePoint server located in a data center in Montreal. You plan to create a report in the Power BI service that will use Microsoft Excel files stored on the Sharepoint server. You need to recommend a solution to ensure that the dataset for the report can automatically refresh daily. What should you include in the recommendation?

Answer 6

An on-premises data gateway

Question 7

Easy Q7: 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 publish content to the workspace

Answer 7

Contributor

Question 8

Easy Q8: 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 publish apps

Answer 8

Member

Question 9

Easy Q9: Which of the following is true with respect to creating a dashboard in Power BI?

Answer 9

A dashboard can have only a single page

Question 10

Easy Q10: You manage a Power BI workspace in a shared capacity. The workspace contains a dataset named DS1. You need to implement an incremental refresh of DS1. What should you do first?

Answer 10

In Power BI desktop, define filter parameters

Question 11

Med Q1: You manage a Power BI workspace in shared capacity. The workspace contains a dataset named DS1. You plan to schedule the refresh of DS1. What is the number of consecutive refresh failures of DS1 that automatically disable the refresh schedule?

Answer 11

B. 4. If there are 4 consecutive data set refresh failures, the refresh schedule will be automatically disabled

Question 12

Med Q2: You create multiple reports on the company’s last quarter financial information. You would like to share these reports with the C-level executives of the company. How would you share the reports?

Answer 12

B. Publish an app

Question 13

Med Q3: Below is a line chart that plots Apple stock’s daily closing price for the past five years and the 200-Day Simple Moving Average (200 DMA). Some traders use 200 DMA to enter/exit positions in a stock. As a trader, if Apple’s stock price goes above 200 DMA, you enter a position. If Apple’s stock goes below 200 DMA, you exit a position. Accordingly, you want Power BI to notify you of such price movements. What would you do?

Answer 13

D.
It is not possible to achieve the goal with these 3 options

Question 14

Med Q4: You have Power BI Premium with allotted capacity. You import data into Power BI from a webpage and create a Power BI report You need to ensure that the data for your visuals that is extracted from the webpage is up to date. You decide to automate the updating process from the data source. How should you configure the dataset to meet the requirements? Select the right option based on the tool where the refresh schedule is configured.

Answer 14

B. Power BI Service

Question 15

Med Q5: You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report.

Answer 15

D. Split the Visuals onto multiple pages.

Question 16

Med Q6: You have Power BI Premium with allotted capacity. You import data into Power BI from a webpage and create a Power BI report. You need to ensure that the data for your visuals that is extracted from the webpage is up to date. You decide to automate the updating process from the data source. How should you configure the dataset to meet the requirements? Select the right option based on the storage mode that requires a refresh schedule to be configured

Answer 16

A. Import

Question 17

Med Q7: You have several reports and dashboards in a workspace. You need to grant all organisational users read access to a dashboard and several reports. Solution: You assign all the users the Viewer role to the workspace. Does this meet the goal?

Answer 17

B. Yes

Question 18

Med Q8: You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

Answer 18

A. Publish the reports to a different workspace other than the one hosting the datasets.

Question 19

Med Q9: You are managing a dashboard for a retail store. The store wants to be notified if the Order Quantity per day metric on the Orders dashboard has exceeded 150. You are creating an alert for the same. What should be the maximum notification frequency for this scenario?

Answer 19

At most once every 24 hrs

Question 20

Med Q10: A workspsace owner can endorse a dataset as ______ for organizational use without needing verification by the tenant admin

Answer 20

A. Promoted

Question 21

Hard Q1: You are the administrator for your company’s Power BI tenant. You are using Power BI Premium Capacity in this tenant.
Some users are complaining that some datasets are slow to load or write. You identified the following datasets that users are complaining about the most:
* DatasetA: dataset used in operational reports with a data volume of 8 GB and growing.
* DatasetB: dataset used in dashboards with summarized data from the last 12 months. It has a constant data volume of 150 MB and low usage.
* DatasetC: dataset used by data scientists for experimentation with third-party tools. It has a constant data volume of 100 MB and a Read Write XMLA endpoint. You need to determine which datasets you need to configure as a large dataset in order to improve overall performance. You should minimize costs. Which datasets should you configure?

Answer 21

Dataset A and Dataset C

Question 22

Hard Q2: You need to configure data alerts for a dashboard. Which three visuals can you configure data alerts for? Each answer presents a complete solution.

Answer 22

-KPI visual
-Gauge visual
-Card visual

Question 23

Hard Q3: You create a Power BI 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 BI apps.
* Users in GroupB must be able to publish Power BI 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?

Answer 23

Group A - Member, Group B - Contributor, Group C - Contributor

Question 24

Hard Q4: You are the Power BI administrator for your company. The human resources department uses a dataset with personally identifiable information (PII) about all employees. You create a new report to be exported as an Excel spreadsheet from the Power BI service. You need to ensure that the spreadsheets are encrypted after being exported. What should you use?

Answer 24

Sensitivity Labels

Question 25

Hard Q5: You need to create Power BI 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?

Answer 25

Use the Lineage view feature

Question 26

Hard Q6: You have a dashboard in the Power BI Service in your company’s workspace. You have pinned a card visual with the total sales from the current quarter on this dashboard. The sales manager wants to automatically receive a weekly email with the total sales. You need to meet the managers’ requirements. What should you do?

Answer 26

Create a subscription

Question 27

Hard Q7: Your manager has a folder of 15 Excel spreadsheets and wants the data combined, sorted, grouped and aggregated. Your manager wants you to minimize administrative overhead and costs. You need to show the results on one screen. The results should be accessed from an internet browser. Which five actions should you perform?

Answer 27

-To get data, Navigate to File > Folder.
-Publish the report using Power BI Desktop.
-Pin tiles using Power BI Service.
-Create a dashboard using a Shared Capacity workspace.
-Transform data using Power Query.

Question 28

Hard Q8: You have a dashboard tile that shows the manufacturing efficiency using a card visual. The manufacturing efficiency measure is formatted as a percentage. Your company requires a notification to be sent when efficiency drops below 70%. You need to configure email alerts to meet this requirement. Which three actions should you perform? Each correct answer presents part of the solution.

A. Choose Below in the Condition field and set the Threshold value to 70.
B. Choose Below in the Condition field and set the Threshold value to 0.7.
C. Click the + Add alert rule button.
D. Use Microsoft Power Automate to trigger additional actions.
E. Choose More options on the Manufacturing efficiency card visual and click on Manage alerts.

Answer 28

-Choose Below in the Condition field and set the Threshold value to 0.7.
-Click the + Add alert rule button.
-Choose More options on the Manufacturing efficiency card visual and click on Manage alerts.

Question 29

Hard Q9: You use Power BI with Premium capacity assigned. You have a dataset containing employee key performance indicators (KPIs). You create a Power BI report with a visual that shows employees with low-scoring KPIs. You pin the visual to a dashboard and share the dashboard with users in Human Resources (HR). HR users need to be able to generate a list of employees to investigate for poor performance and import that list into their HR system. What should you do?

A. Configure Cloud App Security.
B. Grant HR users the Reshare permission on the dataset.
C. Grant HR users the Build permission on the dataset.
D. Apply a sensitivity label in the dashboard settings.

Answer 29

Grant HR users the Build permission on the dataset.

Question 30

Hard Q10: You have two dashboards in the same workspace named Production and Manufacturing. Your company’s Power BI administrator creates the following two dashboard data classifications:
* Medium Impact (MEDI) as default
*High Impact (HIGH)
You need to use the newly-created classifications in the dashboards. The Production dashboard should be classified as Medium Impact. The Manufacturing dashboard should be classified as High Impact. Which two actions should you perform? Each correct answer presents part of the solution.

A. Set Data classification as Medium Impact.
B. Go to Settings from Manufacturing dashboard.
C. Set Data classification as High Impact.
D. Go to Settings from Production dashboard.

Answer 30

-Go to Settings from the Manufacturing dashboard.
-Set Data classification as High Impact.