PL-300 Free Practice Questions — Page 12

Question 102

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 add an index key and normalize casing in the data source. Does this meet the goal?

Question 103

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 implicitly convert the values into the required type. Does this meet the goal?

Question 104

You create a report by using Microsoft Power BI Desktop. The report uses data from a Microsoft SQL Server Analysis Services (SSAS) tabular model 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 tabular model?

Question 105

HOTSPOT - You have an organization dimension named DimOrganizations. You have four related tables 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.

Question 106

You are configuring a Power BI report for accessibility as shown in the following table. You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency. Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Question 107

You have a Power BI semantic model that connects to a streaming data source. The data source is updated frequently. You need to create a Power BI report that meets the following requirements: • Supports real-time analytics • Minimizes performance impact on the data source • Displays the most recent data without performing a data refresh Which connectivity mode should you use for the dataset?

Question 108

You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power BI semantic model. You need to ensure that the semantic model 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.

Question 109

HOTSPOT - You have a Power BI semantic model that contains two tables 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.

Question 110

HOTSPOT - You have a Power BI semantic model that contains a table named Opportunity. The Opportunity table contains a column named Qualification. The Qualification column contains values between 0 and 1. You need to build a new measure to score the opportunities on a scale of low. medium, and high. How should you complete the DAX formula? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 111

You have a Power BI semantic model that contains four queries named Query 1, Query2. Query3, and Query4. Query1 loads customer data into the model and is referenced by the other three queries. You discover that data refresh for the model is slow. You need to improve the data refresh time. The solution must minimize costs. What should you do?