最新的Microsoft Power BI Data Analyst - PL-300免費考試真題
Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
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.
- The maximum allowed latency to include transactions in reports is
five minutes.
You need to get data from the Microsoft SQL Server tables.
What should you use to configure the connection?
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
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.
- The maximum allowed latency to include transactions in reports is
five minutes.
You need to get data from the Microsoft SQL Server tables.
What should you use to configure the connection?
正確答案: B
說明：（僅 Fast2test 成員可見）
Hotspot Question
You create a Power BI dataset that contains the table shown in the following exhibit.
You need to make the table available as an organizational data type in Microsoft Excel.
How should you configure the properties of the table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You create a Power BI dataset that contains the table shown in the following exhibit.
You need to make the table available as an organizational data type in Microsoft Excel.
How should you configure the properties of the table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正確答案:
Explanation:
Box 1: Name
Name of the Business Unit should be a Row Label.
Box 2: ID
The Key column field value provides the unique ID for the row. This value enables Excel to link a cell to a specific row in the table.
Box 3: Yes
In the Data Types Gallery in Excel, your users can find data from featured tables in your Power BI datasets.
Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-excel-featured-tables
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?
正確答案: C
說明：（僅 Fast2test 成員可見）
You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power BI semantic model.
You need to ensure that the semantic model can be refreshed in PowerBi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
The file must be imported to a Power BI semantic model.
You need to ensure that the semantic model can be refreshed in PowerBi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
正確答案: B,E
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
說明：（僅 Fast2test 成員可見）
You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard.
You need to add an additional tile to the dashboard. The tile must show inventory by location.
This information is NOT visualized in the report. The solution must minimize the impact on the report.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to add an additional tile to the dashboard. The tile must show inventory by location.
This information is NOT visualized in the report. The solution must minimize the impact on the report.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
正確答案: C,E
說明：（僅 Fast2test 成員可見）
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 are modifying the model to report on the number of orders.
You need to calculate the number of orders.
What should you do?
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 are modifying the model to report on the number of orders.
You need to calculate the number of orders.
What should you do?
正確答案: D
You have the Power BI model shown in the following exhibit.
A manager can represent only a single country.
You need to use row-level security (RLS) to meet the following requirements:
- The managers must only see the data of their respective country.
- The number of RLS roles must be minimized.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A manager can represent only a single country.
You need to use row-level security (RLS) to meet the following requirements:
- The managers must only see the data of their respective country.
- The number of RLS roles must be minimized.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
正確答案: C,E
說明：（僅 Fast2test 成員可見）
Drag and Drop Question
You have a Power BI report that contains five bookmarks.
You need to add an object to the report from which users can navigate between three specific bookmarks.
How should you complete the task? To answer, drag the appropriate actions to the correct steps.
Each action 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.
You have a Power BI report that contains five bookmarks.
You need to add an object to the report from which users can navigate between three specific bookmarks.
How should you complete the task? To answer, drag the appropriate actions to the correct steps.
Each action 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.
正確答案:
