Microsoft Power Platform Fundamentals v1.0 (PL-900)

Page:    1 / 19   
Total 286 questions

HOTSPOT -
You create reports within Power BI to report on the status of a project. A manager asks you to share the reports with other team members. You decide to create a published app and set permissions to allow other team members to view the reports.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:



Answer :

Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps

DRAG DROP -
A company plans to create an information portal that managers can use to view critical information about their teams.
You need to recommend the type of Power BI components that the company should use.
What should you recommend? To answer, drag the appropriate component types to the correct requirements. Each component type 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.
Select and Place:



Answer :

Box 1: Report -
Reports are more detailed data displayed in many formats like chart, graphs list and in tabular, etc.

Box 2: Dashboard -
Dashboards are a business key performance indicator view where it displays key values that can change business profits and can be glanced at one screen.

Box 3: Report -
Power BI dashboards cannot slice and dice, but reports have many ways to filter and slice.
Note: Power BI dashboards are one placeholder to display the most important decision-making facts to run a business. But reports are more detailed data displayed in many formats like chart, graphs list and in tabular, etc. Reports are based on one dataset or one business unit data for example reports of a store belonging to California.
Reference:
https://www.educba.com/power-bi-dashboard-vs-report/

HOTSPOT -
You have a Power BI report.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:



Answer :

Box 1: Yes -
If you'd like to see the data that Power BI uses to create a visualization, you can display that data in Power BI. You can also export that data to Excel as an .xlsx or
.csv file. The option to export the data requires a Pro or Premium license and edit permissions to the dataset and report.
Note: Export data from a Power BI dashboard
1. Select the ellipsis in the upper-right corner of the visualization.
2. Choose the Export data icon.
3. Power BI exports the data to a .csv file. If you've filtered the visualization, then the app will filter the downloaded data.
4. Your browser will prompt you to save the file. Once saved, open the .csv file in Excel.

Box 2: No -
Underlying data: Select this option if you want to see the data in the visual and additional data from the model (see chart below for details). If your visualization has an aggregate, selecting Underlying data removes the aggregate. When you select Export, Power BI exports the data to an .xlsx file and your browser prompts you to save the file. Once saved, open the file in Excel.

Box 3: Yes -
A KPI dataset needs to contain goal values for a KPI. If your dataset doesn't contain goal values, you can create them by adding an Excel sheet with goals to your data model or PBIX file.
Note: A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

You create a Power BI dashboard that displays data from Dynamics 365 Customer Engagement.
You need to share the Power BI dashboard with coworkers.
What are three possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  • A. Create a Power BI workspace and grant coworkers permissions.
  • B. Publish the dashboard as an app to your coworkers.
  • C. Export the data into Common Data Service for others to manipulate in Power BI.
  • D. Export the data to Microsoft Excel for coworkers to import and view in Power BI.
  • E. Embed reports in your company's internal web portal.


Answer : ABE

A: Basic Sharing for Dashboards and Reports through a workspace is the most common way of sharing the Power BI content. Basic Sharing is very simple and easy to use method. You can simply click on the Share button in the dashboard or report, and then share it with other users.


B: Apps are great sharing method for multiple environment, and best way of sharing for users in production environment.
Power BI App is the solution for multiple environment approach. With Power BI App, your development environment (workspace), and user environment (App) are isolated from each other.
Note: If you are using SharePoint online as a portal for document management and some other reasons already, then consider using Embed in SharePoint Online feature of Power BI reports. This method is secure and you can share the report only with Power BI users you want.
E: Sometimes, you donג€™t need a secure way of sharing, you may search for an easy and free way of sharing, and your content is not confidential or sensitive.
Publish to web is your friend in such situation. This is the only free way of sharing in Power BI, but be aware that this method is not secure.
Publish to web method, gives you an embed code, which you can use in any web pages to embed the Power BI report in it
Reference:
https://radacad.com/power-bi-sharing-methods-comparison-all-in-one-review

Your company has an on-premises Microsoft SQL Server database that contains legacy sales data. You must display information from the database in a new
Power Apps app.
You need to establish a secure connection between the database and the app.
What should you use?

  • A. Data source
  • B. App
  • C. Data gateway
  • D. Power Automate


Answer : C

For an on-premises database, identify a data gateway that was shared with you (or create one).
Specify Connect using on-premises data gateway, type or paste the server name, the database name, the user name, and the password for the database that you want to use, and specify the authentication type and the gateway.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldatabase

A recent update has been made to a canvas app.
The update causes usability issues.
You need to roll back the app to a previous version.
What should you do?

  • A. Restore the previous version of the app.
  • B. Uninstall the app for all users and reinstall by using the package from a previous version.
  • C. Deactivate the live app, import the previous version of the app, and then activate the app.
  • D. Delete the app and create a new app based on the previous version.


Answer : A

Restore a canvas app to a previous version in PowerApps.
Restore an app from your account
1. Open powerapps.com, and then click or tap Apps in the left navigation bar.
2. Near the right edge, click or tap the info icon for the app that you want to restore.
3. Click or tap the Versions tab, and then click or tap Restore for the version that you want to restore.
4. In the confirmation dialog box, click or tap Restore.
A new version is added to your list.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/restore-an-app

You are a district manager for a large retail organization. You train each store manager to use Power BI to track sales and daily sales targets.
A store manager remembers learning about the Analyze in Excel option but cannot find the option in their Power BI dashboard.
You need to help the user resolve the issue.
How should you advise the user?

  • A. Install the Power BI Desktop app.
  • B. Select the Spotlight button on the dashboard tile.
  • C. Subscribe to the dashboard and follow the email link.
  • D. Navigate to the report used by the dashboard.


Answer : D

Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

DRAG DROP -
You are a district manager for a large retail company. You want to provide sales managers with deeper sales insights to ensure that they can make more informed decisions for their stores.
Store managers must be able to view data in near real-time.
You need to create and share a Power BI dashboard that can be used by the store managers.
Which tools can you use? To answer, drag the appropriate reporting types to the correct requirements. Each reporting type 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.
Select and Place:



Answer :

Reference:
https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started

DRAG DROP -
A company uses Microsoft Excel workbooks to store consolidated sales data. Workbooks are stored on OneDrive for Business.
Match each Power BI feature to its requirement. To answer, drag the appropriate features from the column on the left to its requirement on the right. Each option may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:



Answer :

Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/mobile/mobile-reports-in-the-mobile-apps

DRAG DROP -
A company plans to display support call metrics on a screen that is visible to all call center staff.
You need to recommend solutions to meet the company's requirements.
What should you recommend? To answer, drag the appropriate components to the correct requirements. Each component 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.
Select and Place:



Answer :

Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-tiles https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-treemaps

You create a Power BI dashboard that displays Common Data Model data.
You need to share the Power BI dashboard with coworkers and allow the coworkers to collaborate.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  • A. Create a Power BI workspace and grant coworkers permissions.
  • B. Publish the dashboard as an app to your coworkers.
  • C. Export the data to Microsoft Excel. Make required changes and then re-import the data.
  • D. Create a Power Automate flow to export the data into a SQL Server database.


Answer : AB

Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-the-new-workspaces

You are using Dynamics 365 Sales.
You need to create a Power BI report that includes customer office locations. The City and State columns must be combined to form one column on the report.
What should you do?

  • A. Use Power Query Editor to merge columns.
  • B. Import the data.
  • C. Export data to Microsoft Excel.
  • D. Create a view.


Answer : A

Reference:
https://support.microsoft.com/en-us/office/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8d

DRAG DROP -
A company needs to create a series of mobile applications to empower their field engineers to accomplish several tasks with varying degrees of complexity.
Match each app type to its definition. To answer, drag the appropriate app type from the column on the left to its definition on the right. Each app type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:



Answer :

Box 1: model-driven -
Both model-driven and canvas apps allow you to easily build business apps. They both share access to the Common Data Service providing standard and custom entities. Model-driven apps start with your data model ג€" building up from the shape of your core business data and processes in the Common Data
Service to model forms, views, and other components. Model-driven apps automatically generate great UI that is responsive across devices.

Box 2: canvas -
Canvas apps start with your user experience, crafting a highly tailored interface with the power of a blank canvas and connecting it to 200 data sources. Canvas apps can be built for web, mobile, and tablet applications.
Reference:
https://powerapps.microsoft.com/sv-se/blog/introducing-model-driven-apps/

HOTSPOT -
A user is starting to learn about Power Apps.
Which objects should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:



Answer :

Reference:
https://docs.microsoft.com/en-us/powerapps/powerapps-overview https://docs.microsoft.com/en-us/power-automate/getting-started

What is a benefit of deploying Microsoft 365 and Dynamics 365 apps in the same tenant?

  • A. You do not need to manually back up data.
  • B. Both will use the same time zone.
  • C. You can use Power BI to display data that comes from both environments.
  • D. You can implement Single Sign-On (SSO).


Answer : C

Reference:
https://docs.microsoft.com/en-us/power-platform/admin/use-power-bi

Page:    1 / 19   
Total 286 questions