Question 56
PL-300: Microsoft Power BI Data Analyst
PL-300: Microsoft Power BI Data Analyst practice questions, page 12 of 17, with answer review and explanations.
Question 57
You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns: • Customer_Name • Customer ID • Website The Contacts table contains the following columns: • Contact ID • Contact Email • Contact Name • Customer Name A web-based contact form is used to fill the Contacts table. The data is not sanitized. You need to create a merge for the Customer and Contacts tables. What should you do?
- Set Join Kind to Full Outer.
- Disable fuzzy matching.
- Set Join Kind to Left Outer.
- Enable fuzzy matching.
Question 58
You have a Power BI semantic model that imports data from a Microsoft SQL Server database and an Oracle database. The semantic model is deployed to the Power BI service. Parameters are already used for the SQL Server data source. You are planning to make change to the semantic model that will ensure consistent behavior across all the data sources. You need to enable parameterization for the Oracle data source. The solution must minimize changes to the existing model. What should you do?
- From Power BI Desktop, modify the Oracle data source to use a parameter, and then republish the model to the Power BI service.
- From the Power BI service, modify the parameters of the SQL Server data source.
- From the Power BI service, create a new semantic model that uses the existing model as a data source, and then parameterize the new model.
- From the Power BI service, set a parameter value for the model.
Question 59
You have a Power BI Desktop file that loads a CSV file into a query named Sales by using Power Query. Sales includes a column named SaleDate. You discover that SaleDate contains unexpected and null values. You need to ensure that the Sales query performs data profiling over the entire dataset and returns a summary table that counts Valid, Error, and Empty values for SaleDate. How should you complete the Power Query M code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Question 60