Microsoft PL-300 Exam Prep Guide: Prep guide for the PL-300 Exam
2024 New Preparation Guide of Microsoft PL-300 Exam
NEW QUESTION # 181
You are using Power Bi Desktop to connect to an Azure SQL database The connection is configured 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 solution is worth one point
Answer:
Explanation:
Explanation:
https://docs.microsoft.com/en-us/power-query/connectors/azuresqldatabase The following table lists all of the advanced options you can set in Power Query Desktop and Power Query Online.
Advanced option
Description
Command timeout in minutes
If your connection lasts longer than 10 minutes (the default timeout), you can enter another value in minutes to keep the connection open longer. This option is only available in Power Query Desktop.
SQL statement
For information, go to Import data from a database using native database query.
Include relationship columns
If checked, includes columns that might have relationships to other tables. If this box is cleared, you won't see those columns.
Navigate using full hierarchy
If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data.
Enable SQL Server Failover support
If checked, when a node in the Azure SQL failover group isn't available, Power Query moves from that node to another when failover occurs. If cleared, no failover occurs.
NEW QUESTION # 182
You build a report about warehouse inventory data. The dataset has more than 10 million product records from
200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.
Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
Which three 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
NEW QUESTION # 183
You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions.
Which three 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:
NEW QUESTION # 184
You have the Power BI data model shown in the following exhibit.
Select the appropriate yes or no.
Answer:
Explanation:
NEW QUESTION # 185
The table has the following columns.
You need to add a column that will be used to sort the Year Month column chronologically.
- A. Option D
- B. Option B
- C. Option A
- D. Option C
Answer: A,C
Explanation:
Answer as.
You publish a dataset that contains data from an on-premises Microsoft SQL Server database.
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
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
You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.
A one-to-many relationship exists between the tables.
The auto date/time option for the data model enabled.
You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.
Which two actions should you perform?
NEW QUESTION # 186
For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel We located in a Microsoft SharePoint folder The data model contains several measures You need to create a Power Bl report from the existing dat a. The solution must minimize development effort. Which type ol data source should you use?
- A. an Excel workbook
- B. a SharePoint folder
- C. Power Bl dataset
- D. Power Bl dataflows
Answer: C
Explanation:
case states there is already a report published and the datamodel contains measures. therefore and to be able to use the measures in the datamodel you should connect to the existing dataset (which was created when you plublished the report) instead of starting from scratch with the files in the SharePoint folder.
NEW QUESTION # 187
You have a report in Power BI Desktop.
You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.)
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 # 188
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 lo view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation:
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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You assign all the users the Viewer role to the workspace.
Does this meet the goal?
- A. Yes
- B. No
Answer: B
Explanation:
"You have five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports"
NEW QUESTION # 190
Your organization has a team of power users who recently created 20 Power BI dashboards.
The power users share the dashboards with other users in the organization.
When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)
You need to ensure that all the users can access the dashboards.
What should you do first?
- A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
- B. Instruct each user to install Microsoft Office 2016.
- C. From the Power BI Admin portal, modify the Privacy Settings.
- D. From the properties of each dashboard, modify the Share dashboard settings.
Answer: A
Explanation:
References:
http://www.nubo.eu/en/blog/2016/12/Enable-PowerBI-On-Office-365/
NEW QUESTION # 191
You use Power Bi Desktop to create a Power Bl data model and a blank report You need to add the Word Cloud visual shown in the following exhibit to the report.
The solution must minimize development effort
Which three 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:
NEW QUESTION # 192
You are using Power Bi Desktop to connect to an Azure SQL database The connection is configured 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 solution is worth one point
Answer:
Explanation:
Explanation:
https://docs.microsoft.com/en-us/power-query/connectors/azuresqldatabase The following table lists all of the advanced options you can set in Power Query Desktop and Power Query Online.
Advanced option
Description
Command timeout in minutes
If your connection lasts longer than 10 minutes (the default timeout), you can enter another value in minutes to keep the connection open longer. This option is only available in Power Query Desktop.
SQL statement
For information, go to Import data from a database using native database query.
Include relationship columns
If checked, includes columns that might have relationships to other tables. If this box is cleared, you won't see those columns.
Navigate using full hierarchy
If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data.
Enable SQL Server Failover support
If checked, when a node in the Azure SQL failover group isn't available, Power Query moves from that node to another when failover occurs. If cleared, no failover occurs.
NEW QUESTION # 193
You publish a dataset that contains data from an on-premises Microsoft SQL Server database.
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
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
Answer:
Explanation:
Explanation:
NEW QUESTION # 194
You need to create a visualization to meet the reporting requirements of the sales managers.
HOW Should create the Visualization? TO answer, select the appropriate options in the answer are a.
Answer:
Explanation:
NEW QUESTION # 195
You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR.
You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements:
* Create reports that use the HR dataset.
* Publish the reports to WorkspaceB.
* Prevent the ability to modify the HR dataset.
* Prevent the ability to add users to WorkspaceB.
Answer:
Explanation:
NEW QUESTION # 196
You are modifying a Power Bi model by using Power Bl Desktop.
You have a table named Sales that contains the following fields.
You have a table named Transaction Size that contains the following data.
Answer:
Explanation:
NEW QUESTION # 197
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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You publish an app to the entire organization.
Does this meet the goal?
- A. Yes
- B. No
Answer: B
Explanation:
Explanation
https://docs.microsoft.com/es-es/power-bi/collaborate-share/service-create-distribute-apps
NEW QUESTION # 198
You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions.
The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend. Which type of visual should you use?
- A. key influences
- B. Q&A
- C. decomposition tree
- D. smart narrative
Answer: A
NEW QUESTION # 199
......
Latest Questions PL-300 Guide to Prepare Free Practice Tests: https://examsboost.actualpdf.com/PL-300-real-questions.html
