Microsoft PL-300 Practice Test - Questions Answers, Page 36
List of questions
Question 351
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have a source that contains a comumn. The column contains case sensitive date. 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?
Question 352
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source.
You attempt to refresh the data and receive the following error message.
Expression.Error: The Colum 'cost' of the table wasn't found.
What is a possible cause of the error?
Question 353
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Question 354
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
HOTSPOT
You are profiting data by using Power Query Editor.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.
Question 355
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
DRAG DROP
You have a Power BI workspace that contains a single report named Sales.
You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visual added to the page area added automatically to the dashboard.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Question 356
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have a data source that contain 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 types.
Does this meet the goal?
Question 357
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You create a Power Bl report1 named Summary1 You discover that Summary1 is slow.
You run Performance analyzer to identify performance metrics for Summary1
Which two metrics display the execution duration in Performance analyzer* Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.
Question 358
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
HOTSPOT
You have a Power Bl semantic model that contains a table named Opportunity.
The Opportunity table contains a column named Qualification
The Qualification column contains values between 0 and V
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 359
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
HOTSPOT
You have a Power BI semantic model.
You discover that he semantic model contains values that display as errors.
You need to use data profiling feature in Power Query to preview the date and identify the issues.
What should you select to gain into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
Question 360
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
HOTSPOT
You have a Power BI semantic model named Model1.
You need to create a measure that will display the sales result for all units. The solution must maintain the existing filter.
How should you complete the DAX expression? TO answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question