Exam Name: | Microsoft Power BI Data Analyst | ||
Exam Code: | PL-300 Dumps | ||
Vendor: | Microsoft | Certification: | Microsoft Certified: Power BI Data Analyst Associate |
Questions: | 459 Q&A's | Shared By: | elissa |
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.
You have a Power BI data model that contains a table named Employees. The table has the following columns:
• Employee Name
• Email Address
• Start Date
• Job Title
You are implementing dynamic row-level security (RLS).
You need to create a table filter to meet the following requirements:
• Users must see only their own employee data
• The DAX expression must work in both Power 81 Desktop and the Power BI service.
Which expression should you use?
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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You add a Power Apps custom visual to the report.
Does this meet the goal?
You plan to create a Power B1 semantic model named Model1 that will contain data from an Azure SQL database. Model! will have the following tables.
You create DimDate and DimProduct by using Import storage mode.
You need to configure the storage mode for each remaining table. The solution must meet the following requirements:
• The data in FactSales must be available within five minutes of being available in the source data.
• The query response time for reports connected to the model must be minimized.
Which storage mode should you configure for each table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.