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?
Answer(s): B
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 change the semantic model mode.Does this meet the goal?
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?
Answer(s): A
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?
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.
Answer(s): A,E
Share your comments for Microsoft PL-300 exam with other users:
cannot evaluate yet
good so far
good questions with simple explanation
nice data dumps
great case study
help so much
very helpfull
some of the answers seem to be inaccurate. q10 for example shouldnt it be an m custom column?
its intresting, i would like to learn more abouth this