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 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: You modify the source step of the queries to use DataSourceExcel as the file path.
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: You modify the source step of the queries to use DataSourceExcel as the file path.
Does this meet the goal?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have the Power Bl data model shown in the following exhibit.
You need to create a measure to count the number of product categories that had products sold during a selected period. How should you complete the DAX expression? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.
You need to create a measure to count the number of product categories that had products sold during a selected period. How should you complete the DAX expression? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.
正解：
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、D
解答を投票する
You have a source that contains a comumn. The column contains case sensitive date. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue.
Solution: You add an index key and normalize casing in the data source.
Does this meet the goal?
Solution: You add an index key and normalize casing in the data source.
Does this meet the goal?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a Power Bl semantic model named Model! that contains two fields named Sales and Quarter. Model 1 contains a DAX measure that sums the Sales column.
You need to create a report that will contain the visual shown in the following exhibit.
The solution must NOT require additional DAX measures.
Which type of visual should you use?
You need to create a report that will contain the visual shown in the following exhibit.
The solution must NOT require additional DAX measures.
Which type of visual should you use?
正解：C
解答を投票する
You have a table named DiMCountries that contains a column named Country as shown in the following table.
You plan to use DiMCountnes as a dimension m a report.
You new to ensure that the Country column in DiMCountnes lists each country only once.
Which two actions should you perform on the Country column? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
You plan to use DiMCountnes as a dimension m a report.
You new to ensure that the Country column in DiMCountnes lists each country only once.
Which two actions should you perform on the Country column? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
正解：B、C
解答を投票する
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?
正解：B
解答を投票する
You have a Power Bl model that contains the following data.
The Date table relates to the Sales table by using the Date columns.
The model contains the following DAX measure.
Total Sales = SUM(Sales[Sale])
You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.
Which DAX calculation should you use?
The Date table relates to the Sales table by using the Date columns.
The model contains the following DAX measure.
Total Sales = SUM(Sales[Sale])
You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.
Which DAX calculation should you use?
正解：B
解答を投票する
Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.
You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.
What should you recommend?
You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.
What should you recommend?
正解：D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have the following three versions of an Azure SQL database:
Test
Production
Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?
Test
Production
Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?
正解：D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product.
The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?
The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You publish a semantic model to the Power Bl service. The semantic model contains a connection to an on-premises Microsoft SQL Server database.
You attempt to configure a scheduled refresh but cannot select the appropriate on-premises data gateway.
You confirm the following with the administrator of the gateway:
* You have the appropriate permissions to use the gateway.
* The data source was created on the gateway.
* The gateway has a status of Running.
What is the most likely reason the gateway is unavailable?
You attempt to configure a scheduled refresh but cannot select the appropriate on-premises data gateway.
You confirm the following with the administrator of the gateway:
* You have the appropriate permissions to use the gateway.
* The data source was created on the gateway.
* The gateway has a status of Running.
What is the most likely reason the gateway is unavailable?
正解：C
解答を投票する