Microsoft PL-300 - Microsoft Power BI Data Analyst
You need to create the semantic model.
Which storage mode should you use for the tables in the semantic model?
You need to create the dataset. Which dataset mode should you use?
You need to minimize the size of the semantic model. The solution must meet the report requirements.
What should you do?
You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.
You need to combine the tables into a single query that contains the unique columns of each table.
What should you select in Power Query Editor?
You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?
You use Microsoft Power B1 Desktop to review the data shown in the following exhibit.
You have the Power Bl data model shown in the following exhibit.
You need to create a measure to count the number of product categories that had products sold during a selected period. 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.
You have a Power Bl model that contains the following data.
The Date table relates to the Sales table by using the Date columns.
The model contains the following DAX measure.
Total Sales = SUM(Sales[Sale])
You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.
Which DAX calculation should you use?
Each Region value appears only on the tow where it first occurred. Each subsequent occurrence of the Region value is blank.
You need to ensure that every row contains the connect non-blank value The solution must minimize development effort.
Which column should you select, and which action should you perform on the column? To answer, select the appropriate options in the answer area. NOTE; Each connect selection is worth one point.
Your company has training videos that are published to Microsoft Stream.
You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?