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.
Hotspot Question
You need to create a KPI visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

정답:

Explanation:
Scenario: The sales managers require a visual to analyze sales performance versus sales targets.
Box 1: Sales[sales_amount]
Box 2: Date[month]
Time > FiscalMonth. This value will represent the trend.
Box 3: Targets[sales_target]
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 custom visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?

• A.Increase the number of times that the dataset is refreshed.
• B.Implement row-level security (RLS).
• C.Replace the default visuals with custom visuals.
• D.Split the visuals onto multiple pages.

Hotspot Question
You open powerbi.com 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.

정답:

Explanation:
https://docs.microsoft.com/en-us/power-bi/service-data-classification

Hotspot Question
You have a semantic model that has the permissions 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.

정답:

You are creating a new semantic model in Microsoft Power BI Desktop.
You connect to a recently used data source and receive an error message indicating that the password is expired.
You need to update the credentials for the data source.
What should you do?

• A.From the Modeling tab, select Manage Roles, and then add a role.
• B.From Data Source settings, select the data source, and then select Edit Permissions.
• C.From Power Query Editor, select Refresh Preview.
• D.From Options, select Data Load, and then select Clear Cache.