[2023年07月04日] 無料Microsoft PL-300試験問題と解答
検証済みPL-300問題集と解答は最新PL-300をダウンロード
Microsoft Power BI Data Analystの認定を取得することは、データ分析の分野でキャリアを進めたい専門家にとって貴重な資産になることがあります。組織が情報を得てビジネス上の意思決定をするためにデータにますます依存するようになる中、効果的なデータソリューションを設計・実装する能力は、高く求められるスキルの一つになるでしょう。Microsoft PL-300試験に合格することは、Power BIの分野で認められた専門家になるための重要な一歩となります。
質問 # 85
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
質問 # 86
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions." You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 87
In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.
Every Product has a ProductSubCategory.
Not every ProductsubCategory has a parent ProductCategory.
You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.
How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type 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.
正解：
解説：
質問 # 88
You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?
- A. tiles
- B. Active Directory groups
- C. Microsoft Information Protection sensitivity labels
- D. comments
正解：C
解説：
Explanation
Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical content in Power BI without compromising productivity or the ability to collaborate.
Sensitivity labels can be applied to datasets, reports, dashboards, and dataflows.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-security-sensitivity-label-overview
質問 # 89
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.
The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Monthly_returns table and Date[Date_ID].
What should you do before you create the relationship?
- A. In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.
- B. To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
- C. In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.
- D. To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.
正解：A
解説：
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
質問 # 90
What should you create to meet the reporting requirements of the sales department?
- A. Option D
- B. Option A
- C. Option B
- D. option C
正解：D
質問 # 91
You have a report in Power BI Desktop as 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.
正解：
解説：
質問 # 92
You are profiling data by using Power Query Editor.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.
正解：
解説：
質問 # 93
You have a PBiX file that imports several tables from an Azure SQL database.
The data will be migrated to another Azure SQL database.
You need to change the connections in the PBIX file. The solution must minimize administrative effort.
What should you do?
- A. From Power Query Editor, modify the source of each query.
- B. From Power Query Editor, create new queries.
- C. Create a PBiT file, open the file, and change the data sources when prompted
- D. Modify the Data source settings.
正解：D
質問 # 94
You have the tables shown in the following table.
The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Group the impressions by Ad_id, Site_name, and Impression_date.
Aggregate by using the CountRows function. - B. Create a calculated measure that aggregates by using the COUNTROWS function.
- C. Create one-to-many relationships between the tables.
- D. Create a calculated table that contains Ad_id, Site_name, and Impression_date.
正解：B、C
質問 # 95
You have five sales regions. Each region is assigned a single salesperson.
You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.
Salespeople must see only the data from their region.
You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
A salesperson reports that she believes she should see more data.
You need to verify what data the salesperson currently sees.
What should you do?
- A. Use the Test as role option to view data as the salesperson's user account.
- B. Instruct the salesperson to open the report in Microsoft Power Bl Desktop.
- C. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.
- D. Use the Test as role option to view data as the Sales role.
正解：D
解説：
Validate the roles within Power BI Desktop
After you've created your roles, test the results of the roles within Power BI Desktop. From the Modeling tab, select View as.
Select a role you created, and then select OK to apply that role. The report renders the data relevant for that role.
Select OK. The report renders based on what that user can see.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
質問 # 96
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
質問 # 97
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions." You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 98
You have a table that contains the following three columns:
City
Total Sales
Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)
How should you configure the visualization? 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/power-bi/visuals/power-bi-visualization-influencers
質問 # 99
You have a dataset named Pens that contains the following columns:
Unit Price
Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
Which type of visualization and which feature should you use? 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/power-bi/visuals/power-bi-visualization-scatter
質問 # 100
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.
正解：
解説：
Answer as below
質問 # 101
You have a dataset named Pens that contains the following columns:
Unit Price
Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
Which type of visualization and which feature should you use? 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/power-bi/visuals/power-bi-visualization-scatter
質問 # 102
You are creating a Power Bi model and report.
You have a single table in a data mode) named Product Product contains the following fields:
* ID
* Name
* Color
* Category
* Total Sales
You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.
How should you complete the DAX expression? To answer, drag the appropriate values to the coned targets. 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.
正解：
解説：
質問 # 103
You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.
正解：
解説：
Reference:
https://docs.microsoft.com/en-us/dax/endofquarter-function-dax
Topic 2, Litware, Inc.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
* Executives require a visual that shows sales by region.
* Regional managers require a visual to analyze weekly sales and returns.
* Sales managers must be able to see the sales data of their respective region only.
* The sales managers require a visual to analyze sales performance versus sales targets.
* The sale department requires reports that contain the number of sales transactions.
* Users must be able to see the month in reports as shown in the following example: Feb 2020.
* The customer service department requires a visual that can be filtered by both sales month and ship month independently.
質問 # 104
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.
Sales contains only the data shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
正解：
解説：
Reference:
https://docs.microsoft.com/en-us/dax/related-function-dax
https://docs.microsoft.com/en-us/dax/calculate-function-dax
質問 # 105
You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.
You need to add a new column that contains the data in the format of nnn-nnn-nnnn.
How should you complete the Query Editor formula? 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/powerquery-m/text-replace
https://docs.microsoft.com/en-us/powerquery-m/text-end
質問 # 106
What should you do to address the existing environment data concerns?
- A. a measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])
- B. a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))
- C. a measure that uses the following formula: SUM(Sales[sales_amount])
- D. a calculated column that uses the following formula: ABS(Sales[sales_amount])
正解：A
質問 # 107
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
D18912E1457D5D1DDCBD40AB3BF70D5D
What should you do?
- A. Change the data type of the Logged column to Date.
- B. Apply a transform to extract the first 11 characters of the Logged column.
- C. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
- D. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
正解：D
質問 # 108
You need to grant access to the business unit analysts.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Reference:
https://www.nickyvv.com/2019/08/the-new-power-bi-workspace-viewer-role-explained.html
質問 # 109
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)
The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 110
......
Microsoft PL-300 試験は、複数の選択肢の問題とシナリオから構成されており、候補者は Power BI の知識を実際のシチュエーションに適用する必要があります。この試験は、データ分析と可視化の異なる側面に焦点を当てたいくつかのセクションに分かれています。これらのセクションには、データモデリング、ダッシュボード作成、データの準備、レポート作成が含まれています。候補者は、試験に合格するために、これらのすべての分野での熟練度を示す必要があります。
リアル問題集を使おう 100%無料PL-300試験問題集：https://jp.fast2test.com/PL-300-premium-file.html
更新された100%カバー率リアルPL-300試験問題で100%合格保証：https://drive.google.com/open?id=1Q_ys8PDlTuIiLgmzoVktCHnpHjhmvfPn