最新的Microsoft Power BI Data Analyst - PL-300免費考試真題
You have a Power BI data model that contains a table named Employees. The table has the following columns:
; Employee Name
; Email Address
; Start Date
; Job Title
You are implementing dynamic row-level security (RLS).
You need to create a table filter to meet the following requirements:
; Users must see only their own employee data
; The DAX expression must work in both Power BI Desktop and the Power BI service.
Which expression should you use?
; Employee Name
; Email Address
; Start Date
; Job Title
You are implementing dynamic row-level security (RLS).
You need to create a table filter to meet the following requirements:
; Users must see only their own employee data
; The DAX expression must work in both Power BI Desktop and the Power BI service.
Which expression should you use?
正確答案: A
說明：（僅 Fast2test 成員可見）
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
說明：（僅 Fast2test 成員可見）
You have a Power BI 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?
You need to define a relationship from FactSales to DimProduct. The solution must ensure the fastest DAX query performance.
Which cardinality should you use?
正確答案: B
說明：（僅 Fast2test 成員可見）
You have a sales system that contains the tables shown in the following table.
The Date table is marked as a date table.
DatelD is the date data type. You need to create an annual sales growth percentage measure.
Which DAX expression should you use?
The Date table is marked as a date table.
DatelD is the date data type. You need to create an annual sales growth percentage measure.
Which DAX expression should you use?
正確答案: D
說明：（僅 Fast2test 成員可見）
You have a Power BI report that contains a table visual with a measure named Revenue. The Revenue measure returns values within a range of 0 to S. You need to formal the visual so that the Revenue column displays a specific background color based on the value range shown in the following table.
Which three actions should you perform in sequence in Power B) Desktop? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Which three actions should you perform in sequence in Power B) Desktop? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正確答案:
Explanation:
The key constraint is to formal the visual so that the Revenue column displays a specific background color based on the value range shown in the following table. The completed mapping shown in the answer area is correct. Manual colors or an unrelated rule cannot scale with the measure values and would not provide the requested magnitude cue across all rows. Data bars encode magnitude as length, allow rapid comparison without reading every number, and can be configured to show the bar only. That meets all stated formatting requirements with one rule. The current skills outline describes this competency as " Apply conditional formatting " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization- conditional-formatting | PL-300 objective: " Apply conditional formatting " | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.
Which role should you assign to the user?
Which role should you assign to the user?
正確答案: C
說明：（僅 Fast2test 成員可見）
You create a Power BI report1 named Summary1 You discover that Summary1 is slow.
You run Performance analyzer to identify performance metrics for Summary1 Which two metrics display the execution duration in Performance analyzer* Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.
You run Performance analyzer to identify performance metrics for Summary1 Which two metrics display the execution duration in Performance analyzer* Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.
正確答案: A,C
說明：（僅 Fast2test 成員可見）
You have a Power BI tenant.
You have reports that use financial semantic models and are exported as PDF files.
You need to ensure that the reports are encrypted.
What should you implement?
You have reports that use financial semantic models and are exported as PDF files.
You need to ensure that the reports are encrypted.
What should you implement?
正確答案: A
說明：（僅 Fast2test 成員可見）
You use Power Query Editor to preview the data shown in the following exhibit
You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.
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 clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.
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:
The required outcome is to replace Discount errors with 0.05 while retaining every source row and minimizing administration. The completed mapping shown in the answer area is correct. Removing error rows can conceal the symptom but does not correct an invalid path, credential, conversion, or source value that caused the refresh failure. Power Query errors should be diagnosed from the failing source or transformation step. File location, credentials, data types, and row-level conversion errors have different causes, so the selected action addresses the error described in the question rather than hiding it. The current skills outline describes this competency as " Resolve data import errors " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/dealing-with-errors | PL-300 objective: " Resolve data import errors " | Study guide: https://learn.microsoft.com/en-us/credentials
/certifications/resources/study-guides/pl-300
You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?
正確答案: A
說明：（僅 Fast2test 成員可見）
You have a Power BI report that uses a semantic model based on an Azure Analysis Services live connection.
You need to ensure that users can use Q & A from the Power BI service for the semantic model.
What should you do?
You need to ensure that users can use Q & A from the Power BI service for the semantic model.
What should you do?
正確答案: B
說明：（僅 Fast2test 成員可見）
You have a report in Power BI named report1 that is based on a shared semantic model.
You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected.
What should you do?
You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected.
What should you do?
正確答案: B
說明：（僅 Fast2test 成員可見）
You have a Power BI report that contains the table visual shown in the following exhibit.
正確答案:
Explanation:
The case is framed around this condition: you have a power bi report that contains the table visual shown in the following exhibit. The completed mapping shown in the answer area is correct. The other visual or configuration choices encode a different task, lose the required interaction, or fail one of the stated display constraints. Each Power BI visual encodes a different relationship. The field wells, filters, and formatting must preserve the intended comparison, trend, hierarchy, or composition without implying a conclusion the data does not support. The current skills outline describes this competency as " Select an appropriate visual " .
The result remains understandable to report consumers and responds correctly to the interaction or filtering behavior described in the question.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualizations- overview | PL-300 objective: " Select an appropriate visual " | Study guide: https://learn.microsoft.com/en-us
/credentials/certifications/resources/study-guides/pl-300