PL-300 무료 덤프문제 온라인 액세스

In Power Query Editor, you have a query named Sales Data that contains the following columns.

You need to create two queries named Product Dimension and Sales Fact based on the Sales Data query. The solution must minimize maintenance effort and the size of the dataset.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Disable the load for the Sales Data query.
• B.Clear Include in report refresh for the Sales Data query.
• C.Reference the Sales Data query to create the new queries.
• D.Disable the load for the Sales Fact query.
• E.Duplicate the Sales Data query to create the new queries.

You have the visual shown in the Original exhibit.

You need to configure the visual as shown in the Modified exhibit.

What should you add to the visual?

• A.a forecast
• B.a trendline
• C.an Average line
• D.a measure

Hotspot Question
You use Power Query Editor to review a query that contains a column named Country.
You need to view the following information in the Data preview view for the Country column:
- The percentage of values that contain errors.
- The count of empty values.
What should you enable? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

정답:

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?

• A.Yes
• B.No

You have a Power BI Desktop project that uses DirectQuery to access an on-premises Microsoft SQL Server database.
From Power BI Desktop, you can query the database.
When you publish the Power BI Desktop project to the Power BI service, the visualizations cannot display the data.
What should you do to resolve the issue?

• A.Locate the published dataset for the project in the Power BI service and configure the data source credentials.
• B.Install the on-premises data gateway and configure a data source.
• C.Configure a Microsoft Azure ExpressRoute connection between the on-premises network and the Power BI service.
• D.Install the on-premises data gateway (personal mode) and republish the project.