PL-300 試験問題を無料オンラインアクセス

You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh.
From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity.
You discover that the dataset refresh fails after the refresh runs out of resources.
What is a possible cause of the issue?

• A.A filter is missing on the report.
• B.The data type of the column used to partition the data changed.
• C.Query folding is not occurring.
• D.You selected Only refresh complete periods.

You are profiling data by using Power Query Editor.
The AddressLine2 column in a table named Address is shown in the following exhibit.

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.

正解：

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.

正解：

.
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax

You have an API that returns more than 100 columns. The following is a sample of column names.
client_notified_timestamp
client_notified_source
client_notified_sourceid
client_notified_value
client_responded_timestamp
client_responded_source
client_responded_sourceid
client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

You have a Power B1 semantic model that contains two tables named Sales and Forecast. Both tables contain a date column.
You need to create a calculated table that will cover the range of dates in both tables.
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.

正解：