Practice Free PL-300 Exam Online Questions
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.
From Power Query Editor, you profile the data shown in the following exhibit.
The IoT GUID and IoT ID columns are unique to each row in query.
You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You split the loT DateTime column into a column named Date and a column named Time.
Does this meet the goal?
- A . Yes
- B . No
HOTSPOT
You publish the semantic model to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
DRAG DROP
Exhibit:
You need to create a report that meets the requirements:
• Visualizes the Sales value over a period of years and months
• Adds a Slicer for the month
• Adds a Slicer for the year
Which three actions Should you perform in sequence?
DRAG DROP
You receive annual sales data that must be included in Power Bl reports.
From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.
You need to create a report that meets the following requirements:
• Visualizes the Sales value over a period of years and months
• Adds a slicer for the month
• Adds a slicer for the year
HOTSPOT
You have a Fabric tenant that hosts the semantic models shown in the following table.
You have the following requirements:
The export of reports that contain Personally Identifiable Information (PII) must be prevented.
Data used for financial decisions must be reviewed and approved before use.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
You build a Power Bl report that displays 10T temperature data streaming from a refrigerator.
You publish the report to the Bl service.
You need to be notified when the temperature rises above four degrees Celsius.
What should you do?
- A . Pin a report page to a dashboard and set an alert on the page.
- B . Set an alert on a KPI visual in the report.
- C . Pin a card visual to a dashboard and set an alert on the tile.
- D . Pin a card visual to a dashboard and create a subscription.
You have a Power Bl semantic model that contains the following tables.
You need to define a relationship from FactSales to DimProduct. The solution must ensure the fastest DAX query performance.
Which cardinality should you use?
- A . one-to-one
- B . many-to-many
- C . many-to-one
- D . one-to-many
You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company.
The reports display the data configured as shown in the following table.
You need to ensure that the users of the reports can locate the correct report by using natural language queries.
What should you do?
- A . From the properties of the dataset, create four Featured Q&A Questions.
- B . From the Format settings of the reports, modify the Page Information.
- C . From the properties of the dataset, modify the Q&A and Cortana settings.
- D . From the properties of the workspace, modify the Language Settings.
C
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview