CertBlaze

Microsoft

PL-300 Free Practice Questions — Page 8

Question 74

HOTSPOT - You are designing the data model for a Power BI semantic model. You have the following tables in the star schema. Which table is the fact table of the star schema, and which column in the Patient table is the surrogate key of the star schema? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Illustration for PL-300 question 74 Illustration for PL-300 question 74
Show Answer
Correct Answer: Fact table: Test Result Surrogate key: Patient key
Explanation:
The fact table stores transactional/measurable data and foreign keys; Test Result records each administered test with a result value and links to date, patient, and test. A surrogate key is an internal unique identifier; the Patient key uniquely identifies each patient and is used in the fact table.

Question 75

HOTSPOT - You have a Power BI semantic model named ModelA that contains the following columns: All of the columns use the Text data type. Based on the model, you create a report named ReportA that contains the following columns: • OrderID • OrderDate • CustomerID • ShippingAddress ReportA is the only report connected to ModelA. You discover that ReportA has performance issues caused by the size of ModelA. What should you do to optimize and reduce the size of ModelA? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Illustration for PL-300 question 75 Illustration for PL-300 question 75
Show Answer
Correct Answer: Optimize: Change Data Type of OrderID to Whole Number. Reduce the size: Delete the OrderTitle and OrderDescription columns.
Explanation:
Using a numeric data type improves compression and query performance compared to text. Removing unused text columns directly reduces the semantic model size, improving performance.

Question 76

You use Power Query Editor to preview a column named Date as shown in the following exhibit. You need to change the Date column to contain only the year. The solution must minimize administrative effort. What should you do?

A. Split the column by delimiter.
B. Split the column by number of characters.
C. Extract the text after the delimiter.
D. Transform the column to contain only the year.
Show Answer
Correct Answer: D
Explanation:
The Date column is already of Date/DateTime type, so Power Query provides a built-in transformation to extract the year directly (Transform Date Year). This requires the fewest steps and avoids unnecessary text splitting or parsing, thereby minimizing administrative effort.

Question 77

You have a Power BI app that contains a report named Report1. You add a new page to Report1. You need to ensure that users can view the new page. The solution must minimize administrative effort. What should you do?

A. Update the audience in the app.
B. Update the app.
C. Update the contact information in the app.
D. Unpublish and create a new app.
Show Answer
Correct Answer: B
Explanation:
When you add a new page to an existing report in a Power BI workspace, app users will not see the change until the app is updated. Updating (republishing) the app includes the new report page and makes it visible to users with minimal administrative effort. Changing audiences or contact info does not affect report content, and unpublishing/recreating the app is unnecessary.

Question 78

You have a Power BI report that contains the visual shown in the following exhibit. You need to make the visual more accessible to users who have color vision deficiency. What should you do?

A. Change the font color of values in the Sales column to white.
B. Change the red background color to orange.
C. Add additional measures to the table values.
D. Add icons to represent the sales status of each product.
Show Answer
Correct Answer: D
Explanation:
To improve accessibility for users with color vision deficiency, the visual should not rely on color alone to convey meaning. Adding icons (such as arrows, checkmarks, or warning symbols) provides a non-color visual cue to represent sales status, making the information understandable regardless of color perception. Changing colors or font colors still relies on color differentiation and does not address accessibility best practices.

Question 79

HOTSPOT - You use Power Query Editor to preview the data in a column named Resource Location. The column statistics and value distributions of Resource Location appear as shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

Illustration for PL-300 question 79 Illustration for PL-300 question 79
Show Answer
Correct Answer: 0 US East
Explanation:
The column statistics show Unique = 0, meaning no values occur only once. The value distribution chart shows US East with the largest bar, indicating it occurs most frequently.

Question 80

You publish a semantic model to the Power BI service. The semantic model contains data from the following data sources: • Source1: A Microsoft Excel file stored in Microsoft OneDrive for Business • Source2: An Azure SQL database on a virtual network • Source3: A public website Which data sources require an on-premises data gateway?

A. Source1 only
B. Source2 only
C. Source3 only
D. Source1 and Source2 only
E. Source2 and Source3 only
F. Source1, Source2, and Source3
Show Answer
Correct Answer: B
Explanation:
Only Source2 requires a gateway. An Azure SQL database placed inside a virtual network is not directly accessible from the Power BI service and therefore needs a data gateway (on-premises or VNet data gateway). Source1 (Excel in OneDrive for Business) is cloud-hosted and can be accessed directly by Power BI. Source3 is a public website and does not require a gateway.

Question 81

HOTSPOT - You have a Power BI workspace that contains a semantic model and a report named Sales report. All users in the sales department are assigned the Viewer role for the workspace. The Sales report is configured as shown in the Sales report exhibit. (Click the Sales report tab.) From Power BI Desktop, you configure the Report settings as shown in the Report settings exhibit. (Click the Report settings tab.) For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Illustration for PL-300 question 81 Illustration for PL-300 question 81 Illustration for PL-300 question 81
Show Answer
Correct Answer: Yes No No
Explanation:
Personalize visuals is enabled, so viewers can change a visual type (for example, bar to pie) for their own view. Viewers cannot reshare reports or personalizations with others outside the workspace. Creating new quick measures requires edit permissions on the semantic model, which viewers do not have.

Question 82

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 data source that contains a column. The column contains case sensitive data. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. Solution: You normalize casing in the source query or Power Query Editor. Does this meet the goal?

A. Yes
B. No
Show Answer
Correct Answer: A
Explanation:
Yes. In DirectQuery mode, Power BI’s engine is case-insensitive, which can lead to undefined results and errors when the source is case-sensitive and contains values differing only by case. Normalizing casing in the source query or in Power Query Editor eliminates these case-only duplicates and resolves the undefined values issue, as documented by Microsoft.

Question 83

You have a Power BI report that contains the table shown in the following exhibit. The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?

A. Move the conditional formatting icons to a tooltip report.
B. Add alt text that lists the values in the table.
C. Change the icons to use a different shape for each color.
D. Remove the icons and use red, yellow, and green background colors instead.
Show Answer
Correct Answer: C
Explanation:
For users with color vision deficiency, relying on color alone is not accessible. Using different shapes for each conditional formatting icon provides a non-color visual cue that can be distinguished regardless of color perception. Tooltips, alt text, or background colors alone do not adequately address color vision deficiencies in this scenario.

$19

Get all 356 questions with detailed answers and explanations

  • Instant download HTML + PDF delivered the moment payment clears.
  • Secure Stripe checkout we never see or store your card details.
  • 7-day refund if files are defective see our refund policy.

Full PL-300 study guide →