PL-300: Microsoft Power BI Data Analyst

Question #: 65
Topic #: 4
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 report. 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 or Report Server Export data option for the report.
D. Select the Don’t allow end users to export any data from the service or Report Server Export data option for the report.

Selected Answer: D

Question #: 66
Topic #: 3
You have a report that contains four pages. Each page contains slicers for the same four fields.
Users report that when they select values in a slicer on one page, the selections are not persisted on other pages.
You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages.
What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Create a bookmark for each slicer value.
B. Replace the slicers with report-level filters.
C. Sync the slicers across the pages.
D. Replace the slicers with page-level filters.
E. Replace the slicers with visual-level filters.

Selected Answer: BC

Question #: 68
Topic #: 1
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?

A. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
B. Change the data type of the Logged column to Date.
C. Split the Logged column by using at as the delimiter.
D. Apply a transformation to extract the first 11 characters of the Logged column.

Selected Answer: C

Question #: 69
Topic #: 4
In Power BI Desktop, you are creating visualizations in a report based on an imported dataset.
You need to allow Power BI users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data.
What should you do?

A. From the Power BI service, configure the dataset permissions.
B. From Power BI Desktop, configure the Data Load settings for the current file.
C. From Power BI Desktop, modify the data source permissions.
D. From Power BI Desktop, configure the Report settings for the current file.

Selected Answer: D

Question #: 70
Topic #: 3
You have a report that includes a card visualization.
You need to apply the following conditional formatting to the card while minimizing design effort:
✑ For values that are greater than or equal to 100, the font of the data label must be dark red.
✑ For values that are less than 100, the font of the data label must be dark gray.
Which type of format should you use?

A. Color scale
B. Rules
C. Field value

Selected Answer: B

Question #: 73
Topic #: 1
You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power BI dataset.
You need to ensure that the dataset can be refreshed in powerbi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Excel Workbook
B. Text/CSV
C. Folder
D. SharePoint folder
E. Web

Selected Answer: DE

Question #: 74
Topic #: 4
You have a Power BI report that uses row-level security (RLS).
You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets, or dashboards.
What should you do?

A. Grant the Read and Build permissions for the Power BI datasets to the Azure network security team.
B. Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team.
C. Instruct the Azure network security team to create security groups. Configure RLS to use the groups.
D. Add the Azure network security team as members of the RLS role.

Selected Answer: C

Question #: 77
Topic #: 4
You have four sales regions. Each region has multiple sales managers.
You implement row-level security (RLS) in a data model. You assign the relevant mail-enabled security group to each role.
You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.
A sales manager changes to a different region.
You need to ensure that the sales manager can see the correct sales data.
What should you do?

A. Change the Microsoft Power BI license type of the sales manager.
B. From Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports.
C. Manage the permissions of the underlying dataset.
D. Request that the sales manager be added to the correct Azure Active Directory group.

Selected Answer: D

Question #: 78
Topic #: 3
You are creating a dashboard by using the Power BI service.
You have an existing report page that contains three charts.
You need to add the charts to the dashboard while maintaining the interactivity between the charts.
What should you do?

A. Edit interactions in the report and set all interactions to Filter.
B. Pin each chart as a tile.
C. Edit the dashboard theme and pin each chart as a tile.
D. Pin the report page as a live tile.

Selected Answer: D

Question #: 81
Topic #: 4
You have more than 100 published datasets.
Ten of the datasets were verified to meet your corporate quality standards.
You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets.
What should you do?

A. Promote the datasets.
B. Certify the datasets.
C. Feature the dataset on the home page.
D. Publish the datasets in an app.

Selected Answer: B

Question #: 82
Topic #: 2
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.
What should you recommend?

A. Change any DAX measures to use iterator functions.
B. Enable visual interactions.
C. Replace the default visuals with AppSource visuals.
D. Split the visuals onto multiple pages.

Selected Answer: D

Question #: 86
Topic #: 1
You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?

A. Add a SQL statement.
B. Set the Command timeout in minutes setting.
C. Set Data Connectivity mode to Import.
D. Set Data Connectivity mode to DirectQuery.

Selected Answer: D

Question #: 88
Topic #: 2
You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and
Orders and between City and Orders.
The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.
City[State Province] = “Kentucky”
Role2 contains the following filter.

Date[Calendar Year] = 2020 –
If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

A. The user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020.
B. The user will receive an error and will not be able to see the data in the report.
C. The user will only see data for which the State Province value is Kentucky.
D. The user will only see data for which the State Province value is Kentucky and the Calendar Year is 2020.

Selected Answer: A

Question #: 89
Topic #: 4
You create a dashboard by using the Microsoft Power BI Service. The dashboard contains a card visual that shows total sales from the current year.
You grant users access to the dashboard by using the Viewer role on the workspace.
A user wants to receive daily notifications of the number shown on the card visual.
You need to automate the notifications.
What should you do?

A. Create a subscription.
B. Create a data alert.
C. Share the dashboard to the user.
D. Tag the user in a comment.

Selected Answer: A

Question #: 90
Topic #: 3
You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

A. Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.INC (Sales,sales[Total Sales],0.40)
B. Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.EXC (Sales,sales[Total Sales],0.40)
C. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
D. Create a horizontal line that has a fixed value of 24,000.

Selected Answer: A

Question #: 91
Topic #: 2
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: From Power Query Editor, you import the table and then add a filter step to the query.
Does this meet the goal?

A. Yes
B. No

Selected Answer: B

Question #: 92
Topic #: 1
A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The
Enhanced Dataflows Compute Engine is turned on for the dataflow.
You need to use the dataflow in a report. The solution must meet the following requirements:
✑ Minimize online processing operations.
✑ Minimize calculation times and render times for visuals.
✑ Include data from the current year, up to and including the previous day.
What should you do?

A. Create a dataflows connection that has DirectQuery mode selected.
B. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset.
C. Create a dataflows connection that has Import mode selected and schedule a daily refresh.
D. Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.

Selected Answer: C

Question #: 93
Topic #: 3
You are building a Power BI report.
Users will view the report by using their mobile device.
You need to configure the report to display data based on each user’s location.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. From Power Query Editor, detect the data types of the relevant columns.
B. In Data Category, set the geographic data category for the relevant columns.
C. Create a hierarchy for columns of the geography data type.
D. Use the columns of the geography data type in all visuals.
E. For the relevant columns, set synonyms to match common geographical terms.

Selected Answer: BD

Question #: 94
Topic #: 4
You have a Power BI workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1.
A user wants to create a report by using the data in DS1 and publish the report to another workspace.
You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.
What should you do?

A. Add the user as a Viewer of Workspace1.
B. Grant the Build permission for DS1 to the user.
C. Share RPT1 with the user.
D. Add the user as a member of Workspace1.

Selected Answer: B

Question #: 96
Topic #: 4
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have five reports and two dashboards in a workspace.
You need to grant all organizational users read access to one dashboard and three reports.
Solution: You publish an app to the entire organization.
Does this meet the goal?

A. Yes
B. No

Selected Answer: B

Question #: 97
Topic #: 2
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You write a DAX expression that uses the FILTER function.
Does this meet the goal?

A. Yes
B. No

Selected Answer: B

Question #: 98
Topic #: 3
You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings.
You need to modify the report so that when you select a column in the column chart, the donut chart redraws by using the data from the selected column.
What should you do?

A. Select the donut chart and set the column chart interaction to Filter.
B. Select the column chart and set the donut chart interaction to Filter.
C. Select the donut chart and set the column chart interaction to None.
D. Select the column chart and set the donut chart interaction to None.

Selected Answer: B

Question #: 100
Topic #: 1
You attempt to connect Power BI Desktop to a Cassandra database.

From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.

You need to select an alternate data connector that will connect to the database.

Which type of connector should you choose?

A. Microsoft SQL Server database
B. ODBC
C. OLE DB
D. OData

Selected Answer: B

Question #: 101
Topic #: 2
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a WHERE clause to the SQL statement.
Does this meet the goal?

A. Yes
B. No

Selected Answer: A

Question #: 102
Topic #: 4
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have five reports and two dashboards in a workspace.
You need to grant all organizational users read access to one dashboard and three reports.
Solution: You enable included in app for all assets.
Does this meet the goal?

A. Yes
B. No

Selected Answer: B

Question #: 105
Topic #: 4
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have five reports and two dashboards in a workspace.
You need to grant all organizational users read access to one dashboard and three reports.
Solution: You assign all the users the Viewer role to the workspace.
Does this meet the goal?

A. Yes
B. No

Selected Answer: B

Question #: 106
Topic #: 3
You are creating a Power BI report by using Power BI Desktop.
You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals.
Which type of visual should you use?

A. Q&A
B. smart narrative
C. key influencers
D. decomposition tree

Selected Answer: A

Question #: 109
Topic #: 4
From Power BI Desktop, you publish a new dataset and report to a Power BI workspace. The dataset has a row-level security (RLS) role named HR.
You need to ensure that the HR team members have RLS applied when they view reports based on the dataset.
What should you do?

A. From powerbi.com, add users to the HR role for the dataset.
B. From powerbi.com, share the dataset to the HR team members.
C. From Power BI Desktop, change the Row-Level Security settings.
D. From Power BI Desktop, import a table that contains the HR team members.

Selected Answer: A

Question #: 110
Topic #: 3
In Power BI Desktop, you have a dataset that contains a table.
You create a table visual on a Power BI report page as shown in the following exhibit.

You need to configure the visual to display the referenced image instead of the URL in the Plant Image column.
What should you do?

A. From the Formatting tab, select Values, and then set URL icons to On for the table.
B. Set the Data category of the Plant Image field to Web URL.
C. Set the Data type of the Plant Image field to Binary.
D. Set the Data category of the Plant Image field to Image URL.

Selected Answer: D

Question #: 114
Topic #: 4
You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:
✑ A line chart that shows the number of defective products manufactured by day
✑ A KPI visual that shows the current daily percentage of defective products manufactured
You need to be notified when the daily percentage of defective products manufactured exceeds 3%.
What should you create?

A. a subscription
B. an alert
C. a smart narrative visual
D. a Q&A visual

Selected Answer: B

Question #: 115
Topic #: 2
You have the Power BI model shown in the following exhibit.

There are four departments in the Departments table.
You need to ensure that users can see the data of their respective department only.
What should you do?

A. Create a slicer that filters Departments based on DepartmentID.
B. Create a row-level security (RLS) role for each department, and then define the membership of the role.
C. Create a DepartmentID parameter to filter the Departments table.
D. To the ConfidentialData table, add a calculated measure that uses the CURRENTGROUP DAX function.

Selected Answer: B

Question #: 116
Topic #: 4
You create a report by using Microsoft Power BI Desktop.
The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company’s internal network.
You plan to publish the report to the Power BI Service.
What should you implement to ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

A. an OData feed
B. an On-premises data gateway
C. a subscription
D. a scheduled refresh of the dataset

Selected Answer: B

Question #: 117
Topic #: 1
You are creating a query to be used as a Country dimension in a star schema.

A snapshot of the source data is shown in the following table.

You need to create the dimension. The dimension must contain a list of unique countries.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. Delete the Country column.
B. Remove duplicates from the table.
C. Remove duplicates from the City column.
D. Delete the City column.
E. Remove duplicates from the Country column.

Selected Answer: DE

Question #: 118
Topic #: 3
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a constant line and set the value to .5.
Does this meet the goal?

A. Yes
B. No

Selected Answer: B

Question #: 120
Topic #: 4
You have five sales regions. Each region is assigned a single salesperson.
You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.
Salespeople must see only the data from their region.
You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
A salesperson reports that she believes she should see more data.
You need to verify what data the salesperson currently sees.
What should you do?

A. Use the Test as role option to view data as the salesperson’s user account.
B. Use the Test as role option to view data as the Sales role.
C. Instruct the salesperson to open the report in Microsoft Power BI Desktop.
D. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

Selected Answer: A

Question #: 121
Topic #: 2
In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.
You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.
What should you do?

A. Create an inactive relationship between the tables and select Apply security filter in both directions.
B. Create an active relationship between the tables and select Apply security filter in both directions.
C. Create an inactive relationship between the tables and select Assume referential integrity.
D. Create an active relationship between the tables and select Assume referential integrity.

Selected Answer: B

Question #: 122
Topic #: 3
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create an average line by using the Salary measure.
Does this meet the goal?

A. Yes
B. No

Selected Answer: B

Question #: 125
Topic #: 3
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.
Does this meet the goal?

A. Yes
B. No

Selected Answer: A

Question #: 126
Topic #: 4
You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable
Information (PII). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?

A. Microsoft Information Protection sensitivity labels
B. tiles
C. comments
D. Active Directory groups

Selected Answer: A

Question #: 130
Topic #: 1
From Power Query Editor, you attempt to execute a query and receive the following error message.

Datasource.Error: Could not find file.

What are two possible causes of the error? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A. You do not have permissions to the file.
B. An incorrect privacy level was used for the data source.
C. The file is locked.
D. The referenced file was moved to a new location.

Selected Answer: AD

Question #: 131
Topic #: 3
You have a Power BI report hosted on powerbi.com that displays expenses by department for department managers.
The report contains a line chart that shows expenses by month.
You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort.
What should you do?

A. Enable report readers to personalize visuals.
B. Create a separate report page for users to view the column chart.
C. Add a column chart, a bookmark, and a button for users to choose a visual.
D. Create a mobile report that contains a column chart.

Selected Answer: A

Question #: 132
Topic #: 2
You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
✑ Present ad impression counts for the day, campaign, and site_name. The analytics for the last year are required.
Minimize the data model size.

Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Create one-to-many relationships between the tables.
B. Group the Impressions query in Power Query by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function.
C. Create a calculated table that contains Ad_id, Site_name, and Impression_date.
D. Create a calculated measure that aggregates by using the COUNTROWS function.

Selected Answer: AB

Question #: 133
Topic #: 1
You have data in a Microsoft Excel worksheet as shown in the following table.

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

• If the discount column returns an error, a discount of 0.05 must be used.
• All the rows of data must be maintained.
• Administrative effort must be minimized.

What should you do in Power Query Editor?

A. Select Replace Errors.
B. Edit the query in the Query Errors group.
C. Select Remove Errors.
D. Select Keep Errors.

Selected Answer: A

Question #: 134
Topic #: 4
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have five reports and two dashboards in a workspace.
You need to grant all organizational users read access to one dashboard and three reports.
Solution: You create an Azure Active Directory group that contains all the users. You share each selected report and the one dashboard to the group.
Does this meet the goal?

A. Yes
B. No

Selected Answer: A

Question #: 137
Topic #: 1
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?

A. Apply the Parse function from the Data transformations options to the Logged column.
B. Change the data type of the Logged column to Date.
C. Split the Logged column by using at as the delimiter.
D. Create a column by example that starts with 2018-12-31.

Selected Answer: C

Question #: 138
Topic #: 3
You have two Power BI reports named ReportA and ReportB that each uses a distinct color palette.
You are creating a Power BI dashboard that will include two visuals from each report.
You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Upload a snapshot.
B. For the browser, set the color preference to dark mode.
C. When pinning visuals to the dashboard, select Use destination theme.
D. Select the dark dashboard theme.
E. Turn on tile flow.

Selected Answer: CD

Question #: 141
Topic #: 2
You import a Power BI dataset that contains the following tables:
✑ Date
✑ Product
✑ Product Inventory
The Product Inventory table contains 25 million rows. A sample of the data is shown in the following table.

The Product Inventory table relates to the Date table by using the DateKey column. The Product Inventory table relates to the Product table by using the
ProductKey column.
You need to reduce the size of the data model without losing information.
What should you do?

A. Change Summarization for DateKey to Don’t Summarize.
B. Remove the relationship between Date and Product Inventory
C. Change the data type of UnitCost to Integer.
D. Remove MovementDate.

Selected Answer: D

Question #: 142
Topic #: 4
You publish a dataset to the Power BI service. The dataset contains a connection to an on-premises Microsoft SQL Server database.

You attempt to configure a scheduled refresh but cannot select the appropriate on-premises data gateway.

You confirm the following with the administrator of the gateway:

• You have the appropriate permissions to use the gateway.
• The data source was created on the gateway.
• The gateway has a status of Running.

What is the most likely reason the gateway is unavailable?

A. The type of data source is not supported by the on-premises data gateway.
B. The server name in the PBIX file does not match the data source name in the gateway.
C. The credentials for the data source are invalid.
D. The data source is configured to use single sign-on (SSO).

Selected Answer: B