Question 19 (T4):

You have a report in Power BI named report1 that is based on a shared dataset. You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected. What should you do?

• A. Clear “Allow recipients to share your dashboard” and “Allow users to build new content using the underlying datasets” for the dataset.
• B. Apply row-level security (RLS) to the shared dataset.
• C. Select the “Allow end users to export both summarized and underlying data from the service…” option for the report.
• D. Select the “Don’t allow end users to export any data from the service…” option for the report.

Show Answer

Answer: D
To prevent data exfiltration from a specific report, you should configure the settings for that individual report. Setting the “Export data” option to “Don’t allow…” in the report’s settings (either in Desktop before publishing or in the service after) will disable all data export capabilities for that report only, without affecting other reports that use the same dataset.

Question 20 (T4):

DRAG DROP – You have a Power BI workspace that contains a single-page report named Sales. You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard. Which three actions should you perform in sequence?

To see the actual exam question with images, please Download the Questions PDF.

Show Answer

Answer: The correct sequence of actions is:

1. From the Sales report, click the ellipsis (…) on the top menu bar.
2. Select Pin to a dashboard.
3. In the “Pin to dashboard” dialog box, select the option for Pin live page and click “Pin live”.

Question 21 (T4):

You have a Power BI workspace that contains several reports. You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What should you do?

• A. Create a row-level security (RLS) role and add the user to the role.
• B. Share the reports with the user.
• C. Grant the Read permission for the datasets to the user.
• D. Add the user as a member of the workspace.

Show Answer

Answer: D
To create a dashboard within a workspace and pin visuals from reports in that same workspace, a user needs permissions to both view the reports and create/edit content. The Member role grants these permissions. Viewer is read-only, and sharing individual reports doesn’t grant dashboard creation rights in the workspace.

Question 22 (T4):

You have a dataset that is used infrequently and refreshes every hour. You receive a notification that the refresh was disabled due to inactivity. Which two actions will cause the scheduled refresh schedule to resume?

• A. Enable query caching for the dataset.
• B. Import the dataset to Microsoft Excel.
• C. From the Power BI service, open a dashboard that uses the dataset.
• D. From the Power BI service, open a report that uses the dataset.
• E. From PowerShell, run the get-powerbireport cmdlet.

Show Answer

Answer: C, D
Power BI pauses the scheduled refresh for datasets that have not been accessed for two months. Any user activity on a report or dashboard connected to the dataset signals to the service that the dataset is still in use, which will automatically resume the scheduled refresh.

Question 23 (T4):

You have a Power BI workspace where various user groups (External, Managers, Employees) access a dashboard. You need all users, including external ones, to be able to tag workspace administrators if they find an issue, ensuring other users see the issues raised. What should you use?

• A. comments
• B. chat in Microsoft Teams
• C. alerts
• D. subscriptions

Show Answer

Answer: A
The “comments” feature on dashboards and reports is designed for this type of collaboration. Users can add comments, use the “@” symbol to tag specific colleagues (like workspace admins), and all users with access to the dashboard can see the comment thread.

Question 24 (T4):

You have a Microsoft Excel file on a file server. You create a Power BI report by importing a table from the file and publish it. You need to ensure the data refreshes every four hours. What should you do first?

• A. Upload the Excel file to a Power BI workspace.
• B. Create a subscription to the report.
• C. Deploy an on-premises data gateway.
• D. Edit the data source credentials.

Show Answer

Answer: C
A “file server” is an on-premises data source. For the Power BI service (a cloud service) to access and refresh data from an on-premises source, an on-premises data gateway must be installed on the local network to act as a secure bridge. This is the first prerequisite for enabling a scheduled refresh.

Question 25 (T4):

You have a Power BI tenant. You have reports that use financial datasets and are exported as PDF files. You need to ensure the reports are encrypted. What should you implement?

• A. Microsoft Intune policies
• B. row-level security (RLS)
• C. sensitivity labels
• D. dataset certifications

Show Answer

Answer: C
Sensitivity labels from Microsoft Purview Information Protection are the designated feature for classifying and protecting data. When a sensitivity label configured with encryption is applied to a Power BI report, any exported files (like PDF, Excel, etc.) will automatically inherit that label and its encryption settings.

Question 26 (T4):

HOTSPOT – You have a Power BI tenant that hosts several datasets. Your requirements are: prevent export of reports with Personally Identifiable Information (PII), and ensure data for financial decisions is reviewed and approved. For each statement, select Yes or No.

To see the actual exam question with images, please Download the Questions PDF.

• The Sales dataset (contains salary PII) requires a sensitivity label.
• The Operations dataset (environmental sensor data) requires a sensitivity label and must be certified.
• The Finance dataset (financial transactions) requires a sensitivity label and must be certified.

Show Answer

Answer:

• The Sales dataset…: Yes (Sensitivity labels are used to classify and protect PII).
• The Operations dataset…: No (Sensor data is typically not PII or financially critical, so it wouldn’t require these governance features).
• The Finance dataset…: Yes (Financial data is sensitive and requires a label. As it’s used for critical decisions, it should also be certified to mark it as authoritative and trustworthy).

Question 1 (CS1):

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection?

• A. import that uses a Microsoft account
• B. DirectQuery that uses the end-user’s credentials
• C. DirectQuery that uses a database credential
• D. Import that uses a database credential

Show Answer

Answer: B
The requirement for “Sales managers must be able to see the sales data of their respective region only” points towards row-level security. While RLS can be implemented in Power BI, using DirectQuery with end-user credentials (Single Sign-On) allows for leveraging RLS already defined at the database level, which is a common and scalable enterprise pattern.

Question 2 (CS1):

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

• A. In the Weekly_Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.
• B. Add the Weekly_Returns data to the Sales table by using related DAX functions.
• C. Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.

Show Answer

Answer: A
The core problem is the mismatch in key formats (`yyyyww` in Weekly_Returns and `yyyymmdd` in Date). The solution is to create a new column in one of the tables that matches the format of the other to establish a valid relationship. Creating a date-id column in the `Weekly_Returns` table (e.g., by taking the first day of that week) is a standard data modeling practice to resolve this.

Question 3 (CS1):

You need to create a calculated column to display the month based on the reporting requirements. The required format is “Feb 2020”. Which DAX expression should you use?

• A. FORMAT(‘Date'[date], “MMM YYYY”)
• B. FORMAT(‘Date'[date], “M YY”)
• C. FORMAT(‘Date'[date_id], “MMM”) & “” & FORMAT(‘Date'[year], “#”)
• D. FORMAT(‘Date'[date_id], “MMM YYYY”)

Show Answer

Answer: A
The DAX `FORMAT` function is used to convert a value to text in a specified format. The format string “MMM YYYY” correctly produces the three-letter month abbreviation followed by the full four-digit year (e.g., “Feb 2020”).

Question 4 (CS1):

HOTSPOT – You publish the semantic model to powerbi.com. For each of the following statements, select Yes if the statement is true. Otherwise, select No.

To see the actual exam question with images, please Download the Questions PDF.

• You can connect to the Sales table by using DirectQuery.
• You can create a one-to-many relationship from the Sales table to the Date table.
• You can configure dynamic row-level security (RLS) based on the sales manager.

Show Answer

Answer:

• You can connect to the Sales table by using DirectQuery: Yes (The source is SQL Server, which supports DirectQuery).
• You can create a one-to-many relationship from the Sales table to the Date table: No (The relationship should be from the ‘one’ side, Date, to the ‘many’ side, Sales).
• You can configure dynamic row-level security (RLS) based on the sales manager: Yes (This is a key requirement of the case study and a standard feature of Power BI).

Question 5 (CS1):

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?

• A. Apply row-level security (RLS) to the Region table based on the sales manager username.
• B. Configure a bi-directional relationship between Region and Sales.Region.
• C. Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.
• D. In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

Show Answer

Answer: D
After creating a denormalized Region dimension table, a logical next step to support executive reporting is to create a hierarchy (e.g., Manager -> Sales Manager). This enables intuitive drill-down capabilities within visuals, which is a common requirement for high-level analysis.

Question 6 (CS1):

You need to address the data concerns before creating the data model. The concern is about negative sales amounts. What should you do in Power Query Editor?

• A. Select Column distribution.
• B. Select the sales_amount column and apply a number filter.
• C. Select Column profile, and then select the sales_amount column.
• D. Transform the sales_amount column to replace negative values with 0.

Show Answer

Answer: C
The “Column profile” feature in Power Query is the primary tool for data exploration and quality assessment. It provides statistics for a selected column, including count, min, max, average, etc. Viewing the profile for the `sales_amount` column would immediately show a negative value in the ‘min’ statistic, verifying the data concern.

Question 7 (CS1):

You need to create a visualization to meet the reporting requirements of the sales managers, which is to analyze sales performance versus sales targets. How should you create the visualization?

To see the actual exam question with images, please Download the Questions PDF.

• Visual Type: [Option]
• Value field: [Option]
• Target value field: [Option]

Show Answer

Answer:

• Visual Type: Gauge
• Value field: Actual Sales Amount
• Target value field: Sales Target Amount

Question 8 (CS1):

You need to create relationships to meet the reporting requirements of the customer service department, which requires a visual that can be filtered by both sales month and ship month independently. What should you create?

• A. an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
• B. an additional date table named ShipDate, a many-to-many relationship…
• C. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
• D. a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]

Show Answer

Answer: A
This scenario describes a classic “role-playing dimension”. To filter by two different date fields independently, you need two separate, independent date tables in your model. One date table (e.g., ‘Date’) connects to the sales date key, and the second date table (‘ShipDate’) connects to the ship date key. Note that the relationship should be from the ‘one’ side (Date/ShipDate) to the ‘many’ side (Sales), but the option text has it reversed; however, it’s the only option that correctly identifies the need for two separate date tables.

Question 9 (CS1):

You need to provide a solution to provide the sales managers with the required access (view their region only). What should you include in the solution?

• A. Create a security role that has a table filter on the Sales_Manager table where username = UserName()
• B. Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().
• C. Create a security role that has a table filter on the Sales_Manager table where name = UserName().
• D. Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

Show Answer

Answer: A
This describes a standard dynamic row-level security (RLS) pattern. You create a role that filters the `Sales_Manager` dimension table. The filter compares a column containing the user’s login ID (`username`) with the result of the `USERNAME()` or `USERPRINCIPALNAME()` DAX function, which returns the identity of the person viewing the report. This filter then propagates through the model to the fact tables.

Question 10 (CS1):

What should you create to meet the reporting requirements of the sales department, which requires reports that contain the number of sales transactions?

• A. a measure that uses a formula of SUM(Sales[sales_id])
• B. a calculated column that use a formula of COUNTA(sales[sales_id])
• C. a measure that uses a formula of COUNTROWS(Sales)
• D. a calculated column that uses a formula of SUM(Sales[sales_id])

Show Answer

Answer: C
Assuming each row in the Sales table represents a single sales transaction line, the most direct and performant way to count the total number of transactions is to use the `COUNTROWS(Sales)` function in a DAX measure. This simply counts the total number of rows in the table within the current filter context.

Question 1 (CS2):

You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals. What should you set as the relationship cardinality?

• A. One to one
• B. Many to one
• C. One to many
• D. Many to many

Show Answer

Answer: C
The product list is a dimension table where each product appears once. The revenue results is a fact table where a product can appear many times. Therefore, the relationship from the product list (the ‘one’ side) to the revenue results (the ‘many’ side) is one-to-many. This is the standard and most performant relationship type in a star schema.

Question 2 (CS2):

You need to ensure that the data is updated to meet the report requirements (by 5 AM each day). The solution must minimize configuration effort. What should you do?

• A. From each report in powerbi.com, select Refresh visuals.
• B. From Power BI Desktop, download the PBIX file and refresh the data.
• C. Configure a scheduled refresh without using an on-premises data gateway.
• D. Configure a scheduled refresh by using an on-premises data gateway.

Show Answer

Answer: C
The data sources are Azure SQL Database and SharePoint Online, which are both cloud sources. The Power BI service can connect to these sources directly without needing an on-premises data gateway. Therefore, you can simply configure a scheduled refresh in the dataset settings in the Power BI service.

Question 3 (CS2):

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use?

To see the actual exam question with images, please Download the Questions PDF.

• Calculation Type: [Option]
• Formula: [Option]

Show Answer

Answer:

• Calculation Type: A DAX Calculated column
• Formula: ENDOFMONTH(‘BalanceSheet'[Date])

Note: There appears to be a discrepancy in the provided answer key in the source document, which lists `ENDOFQUARTER`. Based on the question’s requirement to relate based on the “last day of the month,” the correct DAX function is `ENDOFMONTH`. A calculated column is needed to create a physical key for the relationship.

Question 4 (CS2):

DRAG DROP – You need to create a DAX measure that only allows users to see projections at the appropriate levels of granularity (monthly or quarterly, but not daily). How should you complete the measure?

To see the actual exam question with images, please Download the Questions PDF.

[Function1]( [Function2]('Date'[Day]), BLANK(), [Function3]('Projections'[Revenue Projection]) )

Show Answer

Answer: The reconstructed DAX expression is:

• Function1: IF
• Function2: ISFILTERED
• Function3: SUM

The logic `IF(ISFILTERED(‘Date'[Day]), BLANK(), …)` checks if the user has drilled down to the day level. If they have, it returns blank; otherwise, it calculates the sum of the projection.

Question 5 (CS2):

How should you distribute the reports to the board?

To see the actual exam question with images, please Download the Questions PDF.

• Distribution Method: [Option]
• Audience: [Option]

Show Answer

Answer:

• Distribution Method: Publish an app
• Audience: A mail-enabled security group

Note: A Power BI App is the best practice for distributing a package of content with custom navigation to a consumer audience. You would then grant access to the app to the board’s mail-enabled security group.

Question 6 (CS2):

DRAG DROP – Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data?

To see the actual exam question with images, please Download the Questions PDF.

Show Answer

Answer: The correct sequence for setting up RLS is:

1. In Power BI Desktop, create a new role for each business unit with a DAX filter expression.
2. Publish the PBIX file to the Power BI service.
3. In the Power BI service, navigate to the security settings for the dataset.
4. Add the analyst security group as a member of the corresponding role.

Question 7 (CS2):

You need to grant access to the business unit analysts. What should you configure?

To see the actual exam question with images, please Download the Questions PDF.

• Workspace Role: [Option]
• Dataset Permission: [Option]

Show Answer

Answer:

• Workspace Role: Viewer (This gives them read-only access to the published reports in the app/workspace, preventing them from sharing).
• Dataset Permission: Build (This is the specific permission required to create new reports from the profit and loss dataset).