Exam Dumps PL-300 Practice Free Latest Microsoft Practice Tests
PL-300 Exam Questions | Real PL-300 Practice Dumps
NEW QUESTION # 176
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 and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
- B. Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
- C. Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
- D. Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.
Answer: A
Explanation:
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/
NEW QUESTION # 177
You have an API that returns more than 100 columns. The following is a sample of column names.
client_notified_timestamp
client_notified_source
client_notified_sourceid
client_notified_value
client_responded_timestamp
client_responded_source
client_responded_sourceid
client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 178
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.
The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users.
Each role 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.
Answer:
Explanation:
Explanation
User 1 = Member
User 2 = Contributor
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces
NEW QUESTION # 179
You have a Power BI model that contains a table named Sales. Sales has the following three measures:
A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.
A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.
A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] - Sales[This Year].
You need to create the following visualization.
How should you configure the visualization? To answer, drag the appropriate measures to the correct fields.
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.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Diagram, table Description automatically generated
References:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
NEW QUESTION # 180
You are creating a dashboard by using the Power Bl service.
You have an existing report page that contains three charts.
You need to add the charts to the dashboard while maintaining the interactivity between the charts.
What should you do?
- A. Edit interactions in the report and set all interactions to Filter
- B. Pin the report page as a live tile.
- C. Pin each chart as a tile.
- D. Edit the dashboard theme and pin each chart as a file.
Answer: B
NEW QUESTION # 181
You have a dataset 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.
Answer:
Explanation:
NEW QUESTION # 182
You need to address the data concerns before creating the data model. What should you do in Power Query Editor?
- A. Select Column profile, and then select the sales_amount column.
- B. Select Column distribution.
- C. Select the sales_amount column and apply a number filter.
- D. Transform the sales_amount column to replace negative values with 0.
Answer: A
NEW QUESTION # 183
You have four sales regions. Each region has multiple sales managers.
You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.
You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.
A sales manager changes to a different region.
You need to ensure that the sales manager can see the correct sales data.
What should you do?
- A. Change the Microsoft Power Bl license type of the sales manager.
- B. Manage the permissions of the underlying dataset
- C. Request that the sales manager be added to the correct Azure Active Directory group.
- D. From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.
Answer: C
Explanation:
Using AD Security Groups, you no longer need to maintain a long list of users.
All that you will need to do is to put in the AD Security group with the required permissions and Power BI will do the REST! This means a small and simple security file with the permissions and AD Security group.
Note: Configure role mappings
Once published to Power BI, you must map members to dataset roles.
Members can be user accounts or security groups. Whenever possible, we recommend you map security groups to dataset roles. It involves managing security group memberships in Azure Active Directory. Possibly, it delegates the task to your network administrators.
Reference:
https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-groups/
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance
NEW QUESTION # 184
You have a Power Bl report named Orders that supports the following analysis:
* Total sales over time
* The count of orders over time
* New and repeat customer counts
The data model size is nearing the limit for a dataset in shared capacity. The model view for the dataset is shown in the following exhibit.
Answer:
Explanation:
Explanation:
NEW QUESTION # 185
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
Explanation:
1. Pin items from report to Dashboard.
2. Open Dashboard.
3. Change the dashboard view to Phone view.
4. Rearrange, resize the visuals.
NEW QUESTION # 186
You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales You need to create a measure that calculates the total sales from the equivalent month of the previous year.
How should you complete the calculation? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation:
NEW QUESTION # 187
You are creating reports in Power BI Desktop. The model has the following tables.
There is a relationship between the tables.
You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name.
You need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the dataset that is published.
How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Table Description automatically generated
NEW QUESTION # 188
You have the Power Bi dashboard shown in the Dashboard exhibit (Click the Dashboard tab.) You need to ensure that when users view the dashboard on a mobile device, the dashboard appears as shown in the Mobile exhibit.
(Click the Mobile tab.) What should you do?
To answer, select the appropriate options m the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
see the explanation for the answer.
Explanation:
Answer as selected
NEW QUESTION # 189
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: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.
Does this meet the goal?
- A. Yes
- B. No
Answer: A
NEW QUESTION # 190
You are creating a report in Power BI Desktop.
You load a data extract that includes a free text field named coll.
You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.
What should you do?
- A. From Power Query Editor, change the distribution for the Column profile to group by length for col1
- B. In the report, add a DAX function that calculates the average length of col1
- C. In the report, add a DAX calculated column that calculates the length of col1
- D. From Power Query Editor, add a column that calculates the length of col1
Answer: C
Explanation:
From Power Query.. highlight the column.. from the tab view select Column Profile Option.. in the Value distribution section that appears below, from the 3dots.. you can change to group by text length distribution
NEW QUESTION # 191
Note: This question is a part of a series of questions that present 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 exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You need to add a new column to the Product Subcategory table that uses the following formula.
=if [Subcategory] =null then "NA" else [Subcategory]
Which command should you use in Query Editor?
- A. Conditional Column
- B. Invoke Custom Function
- C. Custom Column
- D. Column From Examples
Answer: A
Explanation:
References:
http://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999
NEW QUESTION # 192
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:
Explanation:
NEW QUESTION # 193
You are creating a quick measure as shown in the following exhibit.
You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
NEW QUESTION # 194
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 have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
Due Date
Order Date
Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.
Does this meet the goal?
- A. Yes
- B. No
Answer: A
NEW QUESTION # 195
You need to create a visual as shown in the following exhibit.
The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
NEW QUESTION # 196
......
Verified PL-300 Exam Dumps Q&As - Provide PL-300 with Correct Answers: https://www.braindumpspass.com/Microsoft/PL-300-practice-exam-dumps.html
Pass Your PL-300 Dumps Free Latest Microsoft Practice Tests: https://drive.google.com/open?id=1AfE9MDEql-4PcZRb9QhC88_ioySDNy36
