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: | sasha |
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 Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
Due Date
Order Date
Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and
Delivery Date.
Does this meet the goal?
You are creating a quick measure as shown in the following exhibit.
You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a PBIX file that contains sensitive Information.
You need to secure the information to meet the following requirements:
• Only internal users must be able to open the file If the file Is shared via email.
• Once the file Is published, only Internal users must be able to open the semantic model and the report downloaded from the Power B1 service.
What should you do?
You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?