Microsoft Power BI Data Analyst - PL-300무료 덤프문제 풀어보기
You have a Power BI semantic model.
You need to create a column that will contain year over year (YOY) revenue. The column must contain a ratio of change factor compared to the previous year ' s monthly revenue.
How should you complete the OAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to create a column that will contain year over year (YOY) revenue. The column must contain a ratio of change factor compared to the previous year ' s monthly revenue.
How should you complete the OAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
정답:
Explanation:
The completed mapping shown in the answer area is correct. The required outcome is to create a column that will contain year over year (YOY) revenue. The column must contain a ratio of change factor compared to the previous year ' s monthly revenue. Cardinality describes uniqueness on each side of a relationship; cross-filter direction controls how filters travel. Both settings must match the model grain or totals and security filtering can become unreliable. This directly matches the current study-guide objective " Define a relationship ' s cardinality and cross-filter direction " . The opposite cardinality or unnecessary bidirectional filtering can duplicate results, block propagation, or create ambiguity rather than solve the stated model path.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop- relationships-understand | PL-300 objective: " Define a relationship ' s cardinality and cross-filter direction "
| Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
You build a Power BI 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?
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?
정답: C
설명: (Fast2test 회원만 볼 수 있음)
The tables have the following relationships.
You have 100 salespeople in 10,000 cities. Each salesperson sells in multiple cities.
You import one million rows into the Sales table.
You need to reduce the size of Model1. The solution must ensure that you can analyze the total number of sales by salesperson per city.
Solution: You remove the CityID column from the Sales table.
Does this meet the goal?
You have 100 salespeople in 10,000 cities. Each salesperson sells in multiple cities.
You import one million rows into the Sales table.
You need to reduce the size of Model1. The solution must ensure that you can analyze the total number of sales by salesperson per city.
Solution: You remove the CityID column from the Sales table.
Does this meet the goal?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
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: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.
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 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: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.
Does this meet the goal?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
You publish a semantic model that contains data from an on-premises Microsoft SQL Server database.
The semantic model must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the semantic model.
Which four 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
The semantic model must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the semantic model.
Which four 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
정답:
Explanation:
The required outcome is to ensure that the Power BI service can connect to the database and refresh the semantic model. The completed mapping shown in the answer area is correct. A broader role would grant unnecessary authoring or administration, while Viewer cannot create or publish workspace content.
Workspace access is role based. Viewer is read-only, Contributor can create and publish content, Member adds broader collaboration rights, and Admin can manage the workspace and its users. The current skills outline describes this competency as " Identify when a gateway is required " . This keeps service access and operational behavior within the scope requested instead of granting or changing unrelated capabilities.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new- workspaces | PL-300 objective: " Identify when a gateway is required " | Study guide: https://learn.microsoft.
com/en-us/credentials/certifications/resources/study-guides/pl-300
You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.
A one-to-many relationship exists between the tables.
The auto date/time option for the data model enabled.
You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.
Which two actions should you perform?
A one-to-many relationship exists between the tables.
The auto date/time option for the data model enabled.
You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.
Which two actions should you perform?
정답: A,C
설명: (Fast2test 회원만 볼 수 있음)
You need to create a relationship in the semantic model 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:
Cardinality: One-to-many; Table on the many side: Orders
Relationship type
One-to-many
Related table
Orders table
What determines the answer is the need to configure a relationship that propagates the RLS filter from the lookup table to Orders. Cardinality describes uniqueness on each side of a relationship; cross-filter direction controls how filters travel. Both settings must match the model grain or totals and security filtering can become unreliable. The supported result is Cardinality: One-to-many; Table on the many side: Orders. The opposite cardinality or unnecessary bidirectional filtering can duplicate results, block propagation, or create ambiguity rather than solve the stated model path. Microsoft lists this skill in the current PL-300 outline as " Define a relationship ' s cardinality and cross-filter direction " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop- relationships-understand | PL-300 objective: " Define a relationship ' s cardinality and cross-filter direction "
| Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
You have a Power BI semantic model that contains tour queries named Query 1, Query2, Query3, and Query4, Query1 loads customer data Into the model and is referenced by the other three queries. You discover that data refresh for the model is slow.
You need to improve the data refresh time. The solution must minimi2e costs. What should you do?
You need to improve the data refresh time. The solution must minimi2e costs. What should you do?
정답: C
설명: (Fast2test 회원만 볼 수 있음)
You have the CSV file shown in the following table.
You use Power Query Editor to preview the data in the file.
You need to transform the data to meet the following requirements:
; The first column must contain the month.
; The second column must contain the year.
; The third column must contain the order amount for the month and year.
Which transformation should you use first?
You use Power Query Editor to preview the data in the file.
You need to transform the data to meet the following requirements:
; The first column must contain the month.
; The second column must contain the year.
; The third column must contain the order amount for the month and year.
Which transformation should you use first?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
You create a Power BI report named RPT1 that contains sales data. The data contains 10 million rows. RPT1 contains 15 different visuals.
Users state that RPT1 is slow to load.
You need to investigate the cause of the issue.
What should you use?
Users state that RPT1 is slow to load.
You need to investigate the cause of the issue.
What should you use?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.
You need to develop a measure to support the visual.
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 build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.
You need to develop a measure to support the visual.
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.
정답:
Explanation:
The retained answer area specifies 1) CALCULATE; 2) SUM; 3) TOPN; 4) [TransactionDate]. The verified expression produces the requested scalar result under report filtering. It uses model relationships and DAX context semantics instead of shifting a dynamic calculation into a static source or calculated column. The technical decision turns on how to develop a measure to support the visual. An alternative that changes the source or creates a stored column either ignores filter context or increases model size without meeting a dynamic measure requirement. For exam alignment, this is assessed under " Create single aggregation measures " in the current study guide.
Microsoft Learn reference: https://learn.microsoft.com/en-us/dax/ | PL-300 objective: " Create single aggregation measures " | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources
/study-guides/pl-300
You use Power Query Editor to preview the data shown in the following exhibit.
정답:
Explanation:
The M transformation belongs in the query pipeline, where source values can be cleaned, split, filled, renamed, or typed consistently. A report visual or DAX measure would operate too late in the process. Use the selections preserved in the answer exhibit as the supported configuration. The relevant context is that you use power query editor to preview the data shown in the following exhibit. A visual, measure, or model relationship cannot repair the incoming tabular shape; those features operate after the query result has already been loaded. This rationale is anchored to the PL-300 objective " Create and transform columns " . This keeps the query output reproducible at refresh and leaves the semantic model with the grain and schema required by the report.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/best-practices | PL-300 objective: " Create and transform columns " | Study guide: https://learn.microsoft.com/en-us/credentials/certifications
/resources/study-guides/pl-300
You have a Power BI report. The report contains a single report page that uses the detault theme.
You need to configure the report page to match the formatting shown in the following exhibit.
What should you change on the report page?
You need to configure the report page to match the formatting shown in the following exhibit.
What should you change on the report page?
정답: A
설명: (Fast2test 회원만 볼 수 있음)