Microsoft PL-300 시험

Question No : 1

You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"})
A row has a value of 21318 Lasalle Street in the AddressLine1 column .
What will the value be when the step is applied?

• A.1318
• B.1319
• C.21318 Lasalle Street
• D.21319 Lasalle Street

답을 확인하기

정답:
Explanation:
Example:
Replace the text "ur" with the text "or" in the table.



Reference: https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue

Question No : 2

HOTSPOT
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.

답을 확인하기

정답:


Explanation:
Graphical user interface, text, application
Description automatically generated
Box 1: Yes
The four columns used in the 2018 transactions are already displayed.
Box 2: Yes
The columns used are based on the entire dataset. The additional columns in the 2019 files will be detected.
Box 3: Yes
Note: Under the hoods, Power BI will automatically detect which delimiter to use, and may even promote the first row as headers. You can manually change the delimiter, or define how Power BI should handle data types. You can set it to automatically detect data types based on first 200 rows, or the entire dataset or you can even opt out the detection of data types.

Question No : 3

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to load only the manufacturing reports to a table for analysis.
What should you do in Microsoft Power Bl Desktop?

• A.Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load .
• B.Get data from a SharePoint Online list and enter the site UR
• C.Edit the query and filter by the path to the manufacturing reports library.
• D.Get data from a SharePoint Online folder and enter the site UR
• E.Edit the query and filter by the path to the manufacturing reports library.
• F.Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.

답을 확인하기

정답:
Explanation:
Example:
My SharePoint site root url is https://powerbipanama.sharepoint.com/, but all of my files are actually in another site that starts with https://powerbipanama.sharepoint.com/sites/externalsales/ URL.
In order to use the correct URL, we need to be in the folder of the data that we’re trying to get and check the url that our browser shows. If it has the if it starts with the format of https://<site address>/sites/<sitename>/ then we need to use that url, otherwise we use the much simpler https://<site address>
In my own case, I’ll be using the https://powerbipanama.sharepoint.com/sites/externalsales url in order to connect to my site.
Reference: https://powerbi.microsoft.com/sv-se/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

Question No : 4

HOTSPOT
You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

답을 확인하기

정답:


Explanation:
Graphical user interface, text
Description automatically generated with medium confidence
Box 1: Append Queries as New.
There are two primary ways of combining queries: merging and appending.
✑ When you have one or more columns that you’d like to add to another query, you merge the queries.
✑ When you have additional rows of data that you’d like to add to an existing query, you append the query.
Box 2: Disable loading the query to the data model
For every query that loads into model memory will be consumed. and Memory is our asset in the Model, less memory consumption leads to better performance in most of the cases. The best approach is to disable loading.
Reference: https://docs.microsoft.com/en-us/power-query/append-queries

Question No : 5

You have a Microsoft Power Bl dashboard.
You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.
What should you use?

• A.Feedback
• B.Subscribe
• C.Comments
• D.Mark as favorite

답을 확인하기

정답:
Explanation:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment

Question No : 6

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization .
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A.Add the same slicer to each page and configure Sync slicers.
• B.Edit the interactions of the KPI visualization.
• C.Configure a page-level filter.
• D.Edit the interactions of the slicer that is on the same page as the KPI visualization.
• E.Configure a report-level filter.

답을 확인하기

정답:
Explanation:
Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations.
By default, slicers on report pages affect all the other visualizations on that page, including each other. Use visual interactions to exclude some page visualizations from being affected by others.
Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

Question No : 7

You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company.
You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data.
Which report setting should you configure?

• A.Don't allow end user to save filters on this report.
• B.Change default visual interaction from cross highlighting to cross filtering.
• C.Enable the updated filter pane, and show filters in the visual header for this report.
• D.Allow users to add comments to this report.
• E.Choose the type of data you allow your end users to export.

답을 확인하기

정답:
Explanation:
https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/

Question No : 8

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 (Pll). The solution must minimize
configuration effort and impact on the dashboard design.
What should you use?

• A.Active Directory groups
• B.tiles
• C.data classifications
• D.comments

답을 확인하기

정답:

Question No : 9

You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications .
What should you do?

• A.Share the dashboard to the user.
• B.Create a subscription.
• C.Create a data alert.
• D.Tag the user in a comment.

답을 확인하기

정답:
Explanation:
You can subscribe yourself and your colleagues to the report pages, dashboards, and paginated reports that matter most to you.
Power BI e-mail subscriptions allow you to:
✑ Decide how often you want to receive the emails: daily, weekly, hourly, monthly, or once a day after the initial data refresh.
✑ Choose the time you want to receive the email, if you choose daily, weekly, hourly, or monthly.
Note: Email subscriptions don't support most custom visuals. The one exception is those custom visuals that have been certified.
Email subscriptions don't support R-powered custom visuals at this time.
Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe
https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

Question No : 10

You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order .
What should you configure in Microsoft Power Bl Desktop?

• A.the bookmark order
• B.the layer order
• C.the tab order
• D.the X position

답을 확인하기

정답:
Explanation:
If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should contact the report author. Report authors can set the tab order for objects and visuals.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools

Question No : 11

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages .
What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

• A.Sync the slicers across the pages.
• B.Replace the slicers with page-level filters.
• C.Replace the slicers with visual-level filters.
• D.Create a bookmark for each slicer value.
• E.Replace the slicers with report-level filters.

답을 확인하기

정답:
Explanation:
Add a report-level filter to filter an entire report.
The visuals on the active page, and on all pages in the report, change to reflect the new filter.
You can sync a slicer and use it on any or all pages in a report.

Question No : 12

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source.
The dashboard is shown in the exhibit. (Click the Exhibit tab.)



What occurred at 12:03:06 PM?

• A.A user pressed F5
• B.A new transaction was added to the data source.
• C.A user added a comment to a tile.
• D.The dashboard tile cache refreshed.

답을 확인하기

정답:
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

Question No : 13

You are creating a visual to show the ranking of product categories by sales revenue.
Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant
Which approach provides the widest variety of visuals while adhering to the security policy?

• A.Use default visuals or custom visuals uploaded from a .pbiviz file.
• B.Use only default visuals.
• C.Use default or any custom visuals from the marketplace.
• D.Use default or certified custom visuals.

답을 확인하기

정답:

Question No : 14

HOTSPOT
You have a report page that contains the visuals 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:
Box 1: cross-filter
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.
Box 2: cross-highlight
Example:
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.

Question No : 15

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl.
You need to recommend an application lifecycle strategy. The solution must minimize maintenance to update access and prevent end users from viewing the development assets.
What should you recommend?

• A.Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.
• B.In the same workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.
• C.Create separate workspaces for development and production. Grant the end users access to the production workspace.
• D.Create one workspace for development. From the workspace, publish an app for production.

답을 확인하기

정답: