PL-300試験無料問題集「Microsoft Power BI Data Analyst 認定」
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?
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?
正解：B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have a Power BI report that contains four pages.
All the pages contain a slicer for a field named Country,
You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3.
The solution must prevent page 4 from being affected by
selections on the other pages,
What should you do?
All the pages contain a slicer for a field named Country,
You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3.
The solution must prevent page 4 from being affected by
selections on the other pages,
What should you do?
正解：C
解答を投票する
You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)
You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)
What should you do?
You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)
What should you do?
正解：B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have the Power BI data model shown in the following exhibit.
Select the appropriate yes or no.
Select the appropriate yes or no.
正解：
Explanation:
You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.
You need to ensure that the users will see the current data when they view the dashboard.
How should you configure the connection to the data source?
You need to ensure that the users will see the current data when they view the dashboard.
How should you configure the connection to the data source?
正解：C
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have a Power Bl semantic model that contains the data sources shown in the following table.
You need to configure the privacy levels of the data sources.
What should you configure (01 each data source? To answer, select (he appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
You need to configure the privacy levels of the data sources.
What should you configure (01 each data source? To answer, select (he appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
正解：
Explanation:
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 combine the tables into a single query that contains the unique columns of each table.
What should you select in Power Query Editor?
正解：C
解答を投票する
You view a query named Transactions as shown in the following exhibit.
The query gets CSV files from a folder.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
The query gets CSV files from a folder.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
正解：
Explanation:
Box 1: 9
9 distinct CSV files.
Box 2: 10
10 distinct dates.
https://pediaa.com/what-is-the-difference-between-unique-and-distinct-in-sql/#:~:text=Unique%20and%
20Distinct%20are%20two%20SQL%20constraints.,the%20records%20from%20a%20table.
You need to create a relationship in the dataset for RLS.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
Explanation:
Box 1: many-to-one
Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.
The Suppliers table has a Region column.
Box 2: Suppliers table
You are creating a Power Bi model in Power BI Desktop
You need to create a calculated table named Numbers that will contain all the integers from -100 to 100. How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.
NOTE Each correct selection is worth one point.
You need to create a calculated table named Numbers that will contain all the integers from -100 to 100. How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.
NOTE Each correct selection is worth one point.
正解：
Explanation:
You have a Power BI model that contains a table named Sales. Sales has the following three measures:
* A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.
* A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.
* A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] - Sales[This Year].
You need to create the following visualization.
How should you configure the visualization? To answer, drag the appropriate measures to the correct fields.
Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
* A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.
* A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.
* A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] - Sales[This Year].
You need to create the following visualization.
How should you configure the visualization? To answer, drag the appropriate measures to the correct fields.
Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
正解：
Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
You have a Power BI workspace that contains a single report named Sales.
You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visual added to the page area added automatically to the dashboard.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visual added to the page area added automatically to the dashboard.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
Explanation:
