You are building Power Apps apps that use both Dynamics 365 Sales and Microsoft 365. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - Dynamic 365 and Microsoft 365 must be in the same tenant to allow Single Sign-On (SSO) - You must download a product from AppSource to ensure SSO work with Dynamic 365 Sales and Microsoft 365

- Dynamic 365 and Microsoft 365 must be in the same tenant to allow Single Sign-On (SSO) -No - You must download a product from AppSource to ensure SSO work with Dynamic 365 Sales and Microsoft 365 -No

A company is evaluating ways to connect Power Platform apps to external services to perform complex activities. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - You can create a canvas app that scans and parses documents using Azure Cognitive Services and then adds the appropriate information to Dynamics 365 Sales. - You can create a canvas app that uses Azure Cognitive Services to read incident records and identify tickets that need to be escalated based on sentiment score.

- You can create a canvas app that scans and parses documents using Azure Cognitive Services and then adds the appropriate information to Dynamics 365 Sales. - Yes - You can create a canvas app that uses Azure Cognitive Services to read incident records and identify tickets that need to be escalated based on sentiment score. - Yes

v1 Flashcards by Exam Pass Catcher

This question requires that you evaluate the underlined text to determine if it is correct. You have a Power Apps app. You create a new version of the app and then publish the new version. A customer goes through the process of restoring the previous version of the app. In the Version tab for the app, you will see two versions of the app. Review the underlined text. If it makes the statement correct, select No change is needed. If the statement is incorrect, select the answer choice that makes the statement correct.

A. No change is needed.
B. one
C. three
D. four

C. three

How well did you know this?

Not at all

Perfectly

A company uses Dynamics 365 Sales. The company uses a browser-based app named Sales Hub. You need to ensure that users can access data from mobile devices. Which app should users install?

A. Dynamics 365 Remote Assist
B. Dynamics 365 Finance
C. Dynamics 365 Business Central
D. Dynamics 365 for Phones

D. Dynamics 365 for Phones

How well did you know this?

Not at all

Perfectly

You are a customer service manager. You need to implement a Power Apps portal that allows customers to submit cases. Which type of data source is used?

A. Dynamics 365 Connector
B. Microsoft SharePoint
C. Microsoft Azure Storage
D. Common Data Service

D. Common Data Service

How well did you know this?

Not at all

Perfectly

You create a user-owned custom entity by using Common Data Service. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

You can change the entity ownership from User to Organization-owned
You can create a business rule for a custom entity that can be used in a Flow

You can change the entity ownership from User to Organization-owned - No
You can create a business rule for a custom entity that can be used in a Flow - Yes

How well did you know this?

Not at all

Perfectly

You need to explain the major components of the Common Data Model (CDM) and their functions. Match each term to its definition. Instructions: To answer, drag the appropriate term from the column on the left to its definition on the right. Each term may be used once, more than once, or not at all. Each correct match is worth one point. NOTE: Each correct selection is worth one point.

Helps jumpstart application development by leveraging business logic, security, and integrations
A set of records used to store data

Helps jumpstart application development by leveraging business logic, security, and integrations - Common Data Service
A set of records used to store data - Entities

How well did you know this?

Not at all

Perfectly

A distribution company has multiple warehouses. Tax rates charged on sales orders need to be calculated based on locality and region. You need to recommend a cost-effective solution that can be implemented quickly. What should you recommend?

A. Check AppSource for a tax add-on.
B. Create alerts in Dynamics 365 Finance for tax table changes.
C. Implement the Common Data Model.
D. Run a Power BI report.
E. Write scripts and code tax updates.

D. Run a Power BI report.

How well did you know this?

Not at all

Perfectly

DRAG DROP - You manage the support team at a rapidly growing company. Customers and support technicians need a better experience when logging and responding to support requests. You need more visibility into what the support technicians are doing every week. You need to recommend tools to help the company’s needs. Which tools should you recommend? To answer, drag the appropriate tools to the correct requirements. Each tool 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:

Customer must able to submit support requests by using a website.
Support requests must be created and stored.
Support technicians must be notified when a new support request is entered
Support technicians must be able to enter a status report for work completed during the previous week by using a mobile app

Customer must able to submit support requests by using a website. - Power Apps Portal
Support requests must be created and stored. - CDS or Dataverse
Support technicians must be notified when a new support request is entered - Power Automate
Support technicians must be able to enter a status report for work completed during the previous week by using a mobile app - Power BI

How well did you know this?

Not at all

Perfectly

You are building Power Apps apps that use both Dynamics 365 Sales and Microsoft 365. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Dynamic 365 and Microsoft 365 must be in the same tenant to allow Single Sign-On (SSO)
You must download a product from AppSource to ensure SSO work with Dynamic 365 Sales and Microsoft 365

Dynamic 365 and Microsoft 365 must be in the same tenant to allow Single Sign-On (SSO) -No
You must download a product from AppSource to ensure SSO work with Dynamic 365 Sales and Microsoft 365 -No

How well did you know this?

Not at all

Perfectly

You need to implement Microsoft Business Applications along with the Microsoft Power platform. Which three Microsoft products are part of the Power platform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A. Microsoft Power Apps
B. Azure Active Directory
C. Power Automate
D. Azure Machine Learning
E. Microsoft Power BI

A. Microsoft Power Apps
C. Power Automate
E. Microsoft Power BI

How well did you know this?

Not at all

Perfectly

A company plans to implement Power Platform apps. The company does not plan to use any development tools or plug-ins. Which actions can you perform? For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

You can synchronize account information from Dynamic 365 Sales with a third-party database
You can create invoices from order and then send the invoive to the customer by using a power Automate flow

You can synchronize account information from Dynamic 365 Sales with a third-party database - Yes
You can create invoices from order and then send the invoive to the customer by using a power Automate flow - Yes

How well did you know this?

Not at all

Perfectly

A large retail company implements Power Apps, Microsoft Flow, and the Common Data Service. The board of directors is asking whether users are finding value in the technology. The company would like to measure and report usage of the software. You need to recommend a tool to determine software usage. What should you recommend?

A. Microsoft Intune
B. Azure Stream Analytics
C. Power Platform Analytics
D. Dynamics 365 Product Insights

C. Power Platform Analytics

How well did you know this?

Not at all

Perfectly

A company uses Power Apps. You need to perform administrative tasks for the company. Which admin centers should you use? To answer, drag the appropriate admin centers to the correct requirements. Each admin center may be used once, more than once, or not at all.

Create user accounts for Power Apps
Assign the Environment Maker role to a user

Create user accounts for Power Apps – Azure Active Directory

Assign the Environment Maker role to a user – Power Apps Admin center

How well did you know this?

Not at all

Perfectly

A rapidly growing company produces Office 365 licenses for all employees. The company wants to empower users to build apps, automate business processes, and analyze data without requiring an expertise or development skills and without increasing IT expenses and dependencies. You need to recommend tools so that users can accomplish specific tasks. Which tools should you recommend?

Build automatic workflows that access multiple data sources.
Create custom apps that address specific business needs.
Design insightful data visualizations.

Build automatic workflows that access multiple data sources. - Power Automate
Create custom apps that address specific business needs. - Power App
Design insightful data visualizations. - Power BI

How well did you know this?

Not at all

Perfectly

A company plans to use Power Platform to build apps which address specific business challenges. You need to recommend the appropriate types of Power Apps to use. What should you recommend? To answer, select the appropriate option in the answer area. NOTE: Each correct selection is worth one point.

Field technicians need a mobile app to capture the location and the image of defective products.
Sales representatives need to see different views and dashboards in the sales app.

Field technicians need a mobile app to capture the location and the image of defective products. - Canvas app
Sales representatives need to see different views and dashboards in the sales app. - Model-driven app

How well did you know this?

Not at all

Perfectly

A travel company plans to use the Power Platform to create tools that help travel agents book customer travel. You need to recommend solutions for the company. What should you recommend? To answer, drag the appropriate tools to the correct requirements. Each tool 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:

If a customer is travelling with a person under the age of 18. a field must display to collect date of birth for the under 18 traveler only.
Ensure that all travel agents use the same process with all customers.
Send a confirmation email to customers after reservations are complete.

If a customer is travelling with a person under the age of 18. a field must display to collect date of birth for the under 18 traveler only. - Business rule
Ensure that all travel agents use the same process with all customers. - Business process flow
Send a confirmation email to customers after reservations are complete. - Power Automate

How well did you know this?

Not at all

Perfectly

A company has locations in multiple regions. The company develops solutions based on Power Apps and Power Automate. You need to recommend features to support the implementation. Which Power Platform features should you recommend? To answer, drag the appropriate features to the correct requirements. Each feature 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:

Ensure fastest response times for each company location.
Create test and production copies of the data and apps.

Ensure fastest response times for each company location. - Enviroment
Create test and production copies of the data and apps. - Enviroment

How well did you know this?

Not at all

Perfectly

You have version 1.0.0.0 of a published Power Apps app. You create and publish version 2.0.0.0 of the app. A customer goes through the process of restoring the previous version of the app. How many versions of the app are displayed in the Version tab for the app? To answer, select the appropriate option in the answer area.

You will see ____ versions of the app

You will see 2 versions of the app

How well did you know this?

Not at all

Perfectly

A company is evaluating ways to connect Power Platform apps to external services to perform complex activities. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

You can create a canvas app that scans and parses documents using Azure Cognitive Services and then adds the appropriate information to Dynamics 365 Sales.
You can create a canvas app that uses Azure Cognitive Services to read incident records and identify tickets that need to be escalated based on sentiment score.

You can create a canvas app that scans and parses documents using Azure Cognitive Services and then adds the appropriate information to Dynamics 365 Sales. - Yes
You can create a canvas app that uses Azure Cognitive Services to read incident records and identify tickets that need to be escalated based on sentiment score. - Yes

How well did you know this?

Not at all

Perfectly

You create a business rule on contact entity to enforce the requirement that users must enter either a telephone number, fax number, or an email when creating a new record. The company decides to remove fax number from the condition. You need to update the business rule. What are two ways of achieving the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A. Save a copy of the rule and change the condition. Deactivate and delete the original rule.
B. Deactivate the business rule and change the condition.
C. Take a snapshot of the business rule and change the condition.
D. Change the condition and activate the change.

A. Save a copy of the rule and change the condition. Deactivate and delete the original rule.
B. Deactivate the business rule and change the condition.

How well did you know this?

Not at all

Perfectly

A co-worker is creating an app in Power Apps and needs to automatically synchronize data from an external source. The co-worker is unable to locate a suitable Microsoft approved connector template in AppSource. You need to recommend a solution for the co-worker. What should you recommend?

A. Create a custom connector.
B. Ask the outside source to send you the data once a week.
C. Use Microsoft Flow to connect to the database.
D. Open a ticket with Microsoft and request a new connector.
E. Use Microsoft Azure Service Bus.

A. Create a custom connector.

How well did you know this?

Not at all

Perfectly

A toy company creates a text classification model in AI Builder to monitor customer feedback for specific key words. When negative feedback is received for a toy, the company wants to proactively perform engineering reviews for the toy and schedule additional training sessions for workers who produce the toy. 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 canvas app.
B. Implement the Virtual Agent.
C. Build a Power Automate flow.
D. Use the Common Data Model.

A. Create a canvas app.

C. Build a Power Automate flow.

How well did you know this?

Not at all

Perfectly

A company plans to use Power BI to visualize data from business systems. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

You can display data aggregates and raw data in a Power BI report.
You can display related data from multiple sources in the same Power BI report.

You can display data aggregates and raw data in a Power BI report. - Yes
You can display related data from multiple sources in the same Power BI report. - Yes

How well did you know this?

Not at all

Perfectly

A company is evaluating ways that they can implement AI Builder. For which two scenarios can you use AI Builder? Each correct selection presents a complete solution. NOTE: Each correct selection is worth one point.

A. Send emails to all users who subscribe to a service.
B. Synchronize data from an external database.
C. Collect data from several data sources and display a dashboard that shows trending data.
D. Interpret images and perform an action on the image.
E. Detect patterns in data and predict outcomes.

D. Interpret images and perform an action on the image.

E. Detect patterns in data and predict outcomes.

How well did you know this?

Not at all

Perfectly

A company plans to create Power Platform apps that consume industry-standard and proprietary data sources. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Custom connector cannot be used if a standard connector for the service is available.
Custom connectors are supported in instant flows only.
Standard and custom connectors cannot be mixed within the same flow or app.

Custom connector cannot be used if a standard connector for the service is available. - No
Custom connectors are supported in instant flows only. - No
Standard and custom connectors cannot be mixed within the same flow or app. - No

How well did you know this?

Not at all

Perfectly

A company is evaluating Power Platform and has questions about the role that Common Data Service plays in using Power Apps and Power Automate. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - Model-driven apps require a Common Data Service database. - A flow instance can only access one Common Data Service database. - Canvas apps require a Common Data Service database.

- Model-driven apps require a Common Data Service database. - Yes - A flow instance can only access one Common Data Service database. - No - Canvas apps require a Common Data Service database. - No

A company plans to create a Common Data Service environment. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - You can create a Common Data Service environment in the Power Platform Admin center. - You must enable data encryption after you create a Common Data Service environment. - You can control security roles and privileges in a Common Data Service environment from the Power Apps Admin center.

- You can create a Common Data Service environment in the Power Platform Admin center. - Yes - You must enable data encryption after you create a Common Data Service environment. - No - You can control security roles and privileges in a Common Data Service environment from the Power Apps Admin center. - Yes

A company plans to use AI Builder to help improve business performance. You need to determine which AI Models are available for use. Which three types of models can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. ``` A. linear regression B. prediction C. object detection D. anomaly detection E. text classification ```

B. prediction C. object detection E. text classification

A company uses Microsoft 365 and Dynamics 365 Sales. The company does not have any developers on its staff. You need to explain to the executives the benefits of using Power Platform apps. What are two benefits? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. Users can send emails from Dynamics 365 Sales to their personal email addresses. B. Users can create Power Apps to create apps for different departments. C. Users can use Power Automate to share information between Microsoft 365 and Dynamics 365 Sales. D. The company can unify all the mobile devices to one vendor.

B. Users can create Power Apps to create apps for different departments. C. Users can use Power Automate to share information between Microsoft 365 and Dynamics 365 Sales.

A company needs to create several workflows and applications to help streamline their sales operations. You need to determine which applications are appropriate for given scenarios. Which applications should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. - Scenario Application Create no-code workflows that use different systems. - Build a no-code mobile application. - Build a mobile application by using Common Data Service.

- Scenario Application Create no-code workflows that use different systems. -Power Automare - Build a no-code mobile application. -Power Apps - Build a mobile application by using Common Data Service. -Power Apps

A company uses Dynamics 365 Supply Chain Management and Dynamics 365 Finance. User account data must be synchronized between the two systems. You need to ensure that the synchronized data is stored in one place. What should you use? A. Azure IoT Central B. Azure Active Directory C. SQL Server D. Common Data Service

D. Common Data Service

What is a benefit of deploying Microsoft 365 and Dynamics 365 apps in the same tenant? A. Use Common Data Services to connect to application data. B. You only need to set up groups in Microsoft 365 for permissions to all data. C. Users can access both Microsoft 365 and Dynamics 365 by using Single Sign-on (SSO).

A. Use Common Data Services to connect to application data.

You are creating a model-driven Power Apps app. You want to ensure that the app can be used by individuals who have vision impairments. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - Power Apps apps can be built with hot key Support and designed so they do not require a touch screen cr mouse. - Only model-driven Power Apps have support for using a screen reader without the need for a connector. - The accessibility checker can berm for your Power Apps app to provide notifications of accessibility violations as well as tips for making it even more user friendly.

- Power Apps apps can be built with ha key Support and designed so they do not require a touch screen cr mouse. - Yes - Only model-driven Power Apps have support for using a screen reader without the need for a connector. -No - The accessibility checker can berm for your Power Apps app to provide notifications of accessibility violations as well as tips for making it even more user friendly. -Yes

A bank uses Power Platform apps and flows to support business processes. The company would like to use historical client data to predict whether a client's loan application is likely to be approved or rejected. You need to use AI Builder to implement the solution. 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. Select and Place: - Train the model. - Use the model in PowerApps or Power Automate. - Export data into Al Builder. - Publish the model. - Import data into Common Data Service.

- Import data into Common Data Service. - Train the model. - Publish the model. - Use the model in PowerApps or Power Automate.

A company plans to implement solutions that use Common Data Service as a data storage. You need to recommend features to meet the company's needs. Which features should you recommend? To answer, drag the appropriate features to the correct requirements. Each feature 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: - Validate data across multiple fields and entities regardless of the app used to create data. - Create visual guides to ensure that users enter data and perform tasks in a consistent manner. - Accelerate development by using a standard set of entities for the most common scenarios.

- Validate data across multiple fields and entities regardless of the app used to create data. - Business rule - Create visual guides to ensure that users enter data and perform tasks in a consistent manner. - Business Process Flow - Accelerate development by using a standard set of entities for the most common scenarios. - Common data model

A manufacturing company is evaluating AI Builder. You need to select AI Builder models to address specified requirements. Which model types should you use? To answer, drag the appropriate model types to the correct requirements. - Identify products without labels or serial numbers. - Identify customers who might not pay their invoices on time.

- Identify products without labels or serial numbers. - Object detection - Identify customers who might not pay their invoices on time. - Prediction

You manage the support team at a rapidly growing company. Support technicians need a better experience when logging and responding to support requests. You need to recommend tools to help the company's needs. Which tools should you recommend? - Support technicians must be able to submit support requests by using an app. - Customer data must be stored and synchronized with Dynamics 365 Finance. - Support technicians must be notified when a new support request is entered.

- Support technicians must be able to submit support requests by using an app. - Power Apps - Customer data must be stored and synchronized with Dynamics 365 Finance. - Common Data Services - Support technicians must be notified when a new support request is entered. - Power Automate

A business is evaluating AI Builder. Which actions can you perform? For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - You can use a text classification model in Al Builder to retrieve text and perform sentiment analysist for ServiceNow incidents. - You can tag Instagram posts that mention your new product. - You can send results about the number of mentions of your new product in Instagram to Power BI for inclusion on a dashboard.

- You can use a text classification model in Al Builder to retrieve text and perform sentiment analysist for ServiceNow incidents. - Yes - You can tag Instagram posts that mention your new product. - Yes - You can send results about the number of mentions of your new product in Instagram to Power BI for inclusion on a dashboard. - Yes

Match each tool to its task. To answer, drag the appropriate tool from the column on the left to its task on the right. Each tool may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: - Automate workflows - Trigger an action from an event - Create a custom mobile data entry screen

- Automate workflows - Power Automate - Trigger an action from an event- Power Automate - Create a custom mobile data entry screen- Power Apps

You are a retail director for a large clothing company. Each week you use the corporate YouTube channel to create a video that highlights new initiatives, and goals for retail operations. You need to design a Power Apps app that streams the videos to internal users. Which objects should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. - Implement the Power Apps app- - Use drag and drop to add a video to the app.- - Apply consistent company colors to the app-

- Implement the Power Apps app- Canvas - Use drag and drop to add a video to the app.-Control - Apply consistent company colors to the app-Theme

You want to create a Power Apps app that allows you to define a custom Sitemap. What should you do? To answer, select the appropriate options in the answer area. - Navigate to the Power Apps portal and create

- Navigate to the Power Apps portal and create - a model-driven app

A company is building apps to support their business operations. The apps will use connectors to access data from several data sources and respond to a number of events generated by components. Which two operations can you use for connectors? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. Actions B. Plug-ins C. Gateways D. Triggers

A. Actions | D. Triggers

You are a sales manager for a large retail organization. You are creating a Power Apps app that will display customer product purchase information from your old point-of-sale (POS) system and need to link those sales to the customer accounts and product sales in Dynamics 365 Commerce. You need to use the appropriate component. What should you use? A. Common Data Service B. business process flow C. entity metadata D. business rule

A. Common Data Service

You create a Power Virtual Agents chatbot. You need to share the bot with other team members so that they can try out the bot before you share the bot with customers. What should you use? A. demo website B. live production website C. test chat feature

A. demo website

You are planning to use the Business Card Reader and Sentiment Analysis prebuilt AI models to build solutions. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - The BusinessCard Reader model can be used with both Power Automate and Power Apps. - The Sentiment Analysis model can be used Power Automate only

- The BusinessCard Reader model can be used with both Power Automate and Power Apps. - Yes - The Sentiment Analysis model can be used Power Automate only - No

A company plans to implement Power BI to analyze retail operations data. You need to recommend solutions for the company. Which Power BI components should the company use? To answer, drag the appropriate Power BI components to the correct requirements. Each Power BI 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: - Allow users to set and receive alerts when data changes beyond specified limits. - View and filter data and export data to Microsoft Excel for further manipulation and analysis.

- Allow users to set and receive alerts when data changes beyond specified limits. - Dashboards - View and filter data and export data to Microsoft Excel for further manipulation and analysis. - Reports

You create a set of dashboards and reports for a project team that combines data from different sources in Power BI. Some of the data is considered sensitive. You need to distribute the dashboards and reports securely to the team. What should you create? A. a custom data connector B. a published app C. a Microsoft flow D. a Power BI workspace

D. a Power BI workspace

You create a Power BI dashboard. Match each option to its function. To answer, drag the appropriate option from the column on the left to its function 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: - Ensure that coworkers can see the dashboard. - Display data from Microsoft Excel in the dashboard. - Add a report tile to the dashboard

- Ensure that coworkers can see the dashboard. - Share - Display data from Microsoft Excel in the dashboard. - Pin - Add a report tile to the dashboard - Pin

You are using Dynamics 365 Sales. You need to pull data into a Power BI report for your team. The City and State columns must be combined to form one column on the report. Which function would you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. Use Power Query to merge columns. B. Import the data. C. Export data to Microsoft Excel. D. Create a view.

A. Use Power Query to merge columns

A carpet cleaning company uses Dynamics 365 Sales. The process for entering customer information during onsite sales calls is very complicated. The company wants a simplified screen that allows salespeople to capture the customer name, phone number, and other information while speaking to the customer. You need to recommend a solution that works on various types of mobile devices. What should you recommend? ``` A. Common Data Service B. Power Automate C. AI Builder D. Canvas app E. Power BI ```

D. Canvas app

A company manages a chain of retail stores. The company stores a list of retail store names and numbers in one Power BI table. The company stores sales transaction data including a transaction ID in another table. The transaction ID includes the store number. You need to show the store name for all retail transactions in all Power BI reports. Which tool should you use? A. Query Editor B. Power BI Service C. Microsoft Excel D. Data Connector

A. Query Editor

A company is using Power BI to build visualizations. The company's IT support team needs to know when to install Power BI Desktop on users' computers and where the Power BI Service will suffice to perform tasks. You need to recommend solutions for the company. - Create dashboards. - Create reports. - Create calculated columns. - Configure security. - Configure sharing.

- Create dashboards.-Power BI Service only - Create reports.-Power BI Desktop or Power BI Service - Create calculated columns.-Power BI Desktop only - Configure security.-Power BI Desktop or Power BI Service - Configure sharing.-Power BI Service only

You need to display sales orders greater than a specific threshold in a Power BI report. What should you use? A. filter B. Power Query C. Common Data Service D. connector

A. filter

You are a sales representative. You create a Power BI report to visualize data from a Microsoft Excel workbook. Users need to be able to view and share the report. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. Pin the report to a dashboard. B. Export the data. C. Publish the dashboard. D. Share the dashboard

A. Pin the report to a dashboard. | D. Share the dashboard

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. - The Power Bl published app is stored within the Team site so that others can install it. - One of the other project managers installs and modifiers a dashboard within the Power Bl published app. The changes are automatically made into the original published app.

- The Power Bl published app is stored within the Team site so that others can install it. - No - One of the other project managers installs and modifiers a dashboard within the Power Bl published app. The changes are automatically made into the original published app. - No

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 -Display data from a Microsoft Excel work book that has multiple work sheets into one chart. -Display the top departmental goal metrics and alert users when specific thresholds targets are met. -Display Sales charts that can be filtered by region.

-Display data from a Microsoft Excel work book that has multiple work sheets into one chart. - Report -Display the top departmental goal metrics and alert users when specific thresholdstargets are met. - Dashboard -Display Sales charts that can be filtered by region. - Report

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. -You can export data from a visualization in a Power BI report. -You can show the data behind a visual report on your screen without exporting the data. -You can export data to view supporting data for a KP!.

-You can export data from a visualization in a Power BI report. -Yes -You can show the data behind a visual report on your screen without exporting the data. -Yes -You can export data to view supporting data for a KPI-Yes

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.

A. Create a Power BI workspace and grant coworkers permissions. B. Publish the dashboard as an app to your coworkers. E. Embed reports in your company's internal web portal.

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

C. Data gateway

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.

A. Restore the previous version of the 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.

D. Navigate to the report used by the dashboard.

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 - Create Power BI dashboards that contain a single store's sales information. - Share that dashboard with your retail managers

- Create Power BI dashboards that contain a single store's sales information. - Power BI Service only - Share that dashboard with your retail managers- Power BI Service only

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. - Enable user-friendly reporting on phones - Use natural language to query and aggregate data

Enable user-friendly reporting on phones - Mobile apps | Use natural language to query and aggregate data - Q&A

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. - Display a chart with incoming calls versus wait time and pin the chart to a dashboard. - Send a specific user a notification when the number of customer support calls waiting is over 20. - Display metrics from different datasets that have related data.

- Display a chart with incoming calls versus wait time and pin the chart to a dashboard.-Tile - Send a specific user a notification when the number of customer support calls waiting is over 20.-Alert - Display metrics from different datasets that have related data.-Page

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.

A. Create a Power BI workspace and grant coworkers permissions. B. Publish the dashboard as an app to your coworkers.

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.

A. Use Power Query Editor to merge columns.

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. - Quickly create apps for very complex business processes from data in Common Data Service with very little or no code. - Create simple apps with a highly customizable user interface layouts.

- Quickly create apps for very complex business processes from data in Common Data Service with very little or no code.-Model-driven - Create simple apps with a highly customizable user interface layouts. -Canvas

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. - A Power Apps app can call a - Actions and triggers are properties of a

- A Power Apps app can call a-connector | - Actions and triggers are properties of a-flow

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

C. You can use Power BI to display data that comes from both environments.

A company runs a call center to handle customer support inquires. The company tracks metrics including the number of incoming calls, call resolution rates, and escalations. The company wants to display the metrics on a shared screen that is visible to all call center staff. You need to recommend a visualization solution for the company. Which Power Platform feature should you recommend? A. AI Builder B. Power Automate C. Power Apps D. Power BI

D. Power BI

You are a regional sales manager for a large internet retailer. You create a series of Power BI reports and dashboards to help sales associates be more productive and increase sales. Sales are not increasing as expected. You need to determine if the new reports are being used and send emails to sales associates to provide guidance on how to use the reports and dashboards. Which features should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. - Send an email to the sales associates on a predetermined schedule. - Quantify the adoption usage from the sales associates.

- Send an email to the sales associates on a predetermined schedule.-Subscribe - Quantify the adoption usage from the sales associates.-Usage metrics

You are creating Power BI reports. You need to choose which filters you can use for reports. Which three types of filters can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. ``` A. drill-down B. automatic C. database D. manual E. external ```

A. drill-down B. automatic D. manual

You are building Power BI visualizations for a team. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - Power Bl can only retrieve data from up to two different sources for each dashboard. - Power Bl visualizations can be used in canvas apps and model driven apps. - Power Bl can display charts and list boxes on dashboards

- Power Bl can only retrieve data from up to two different sources for each dashboard.-No - Power Bl visualizations can be used in canvas apps and model driven apps.-Yes - Power Bl can display charts and list boxes on dashboards-Yes

A manufacturing company uses Internet of Things (IoT) devices to monitor the temperature in different parts of their warehouse. You need to view near-real time information from the IoT devices in Power BI Service dashboards. Which tool should you use? ``` A. Scheduled refresh dataset B. Streaming dataset C. Content Pack dataset D. Power BI dataflows E. Quick Insights ```

B. Streaming dataset

You have a Power BI report with a page named RevReceived. The page shows gross revenue received by your company. You want to create an almost identical page that shows net revenue instead of gross revenue. What should you do? To answer, select the appropriate option in the answer area You should-

You should-duplicate the RecReceived page and update the duplicate copy

A company has a Power Apps app that is used by most employees. The company is expanding to other countries/regions. You need to recommend a solution to translate text generated within the Power Apps app in near real-time. What should you recommend? A. Microsoft Azure Synapse Analytics B. Microsoft Azure Cognitive Services C. Common Data Service connector D. Power BI

B. Microsoft Azure Cognitive Services

A company plans to create a canvas app that connects to three databases with different proprietary database formats. What is the minimum number of connectors required? A. 0 B. 1 C. 2 D. 3

D. 3

A company plans to implement Power Apps in a Power Platform environment. You need to implement other required components. Match each option to its function. To answer, drag the appropriate option from the column on the left to its function on the right. Each option may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. - Implement user authentication. - Send data to a Microsoft OneNote notebook in the same tenant.

- Implement user authentication. -Custom connector | - Send data to a Microsoft OneNote notebook in the same tenant. -Microsoft Flow

A company plans to create canvas apps. What is the minimum number of connectors required? To answer, drag the appropriate number of connectors to the correct drop scenarios. Each number of connectors 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. - Synchronize data with three data sources that use different proprietary database formats. - Create three Power Apps apps that each display data from a Microsoft SharePoint list. - Create three Flows that each copy data to Microsoft Azure Data Lake on different schedules

- Synchronize data with three data sources that use different proprietary database formats.-3 - Create three Power Apps apps that each display data from a Microsoft SharePoint list.-1 - Create three Flows that each copy data to Microsoft Azure Data Lake on different schedules-1

You create a Power Apps canvas app. You need to ensure that your coworkers can run the app. What should you do? A. Share the app. B. Send the URL for the app to coworkers. C. Publish the app. D. Create a Flow for the app.

A. Share the app.

A company uses Microsoft 365, Power Platform, and Dynamics 365. You do not assign permissions to any licensed users. Users are able to create and edit Power Apps canvas apps. In which environment are users creating and editing the apps? A. Production B. Default C. Sandbox

B. Default

A company is creating a canvas app to display data from a legacy SQL Server database that is located on the company’s internal network. You need to connect to the data. What should you use? A. custom connector B. content pack C. data gateway D. Power BI

C. data gateway

You are creating a canvas app that uses one connector. Which two objects are provided by the connector? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. ``` A. customizations B. data sources C. actions D. tables E. triggers ```

C. actions | D. tables

A company is considering implementing PowerApps to help manage business processes. Users are trying to understand the purposes and benefits of PowerApps components. Match each benefit to its tool. To answer, drag the appropriate benefit from the column on the left to its tool on the right. Each benefit may be used once, more than once, or not at all. NOTE: Each correct selection is worth one point - Easy data integration - Low code/ no code acrossapplications - Easy to customize front end

- Easy data integration - Connectors - Low code/ no code acrossapplications - AI Builder - Easy to customize front end- Portals

A company plans to build new apps for the business to allow employees to work more efficiently. You need to recommend the appropriate types of Power Apps to meet the company’s requirements. What should you recommend? To answer, drag the appropriate app types to the correct requirements. Each app 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. - Build mobile apps that use cameras and location data. - Give external users secure access to your data. - Build a feature that detects objects in image

- Build mobile apps that use cameras and location data.-Canvas - Give external users secure access to your data. -Portals - Build a feature that detects objects in image-AI Builder

A company is considering implementing Power Platform. The company must minimize development costs. For which three scenarios should you consider implementing Power Apps Portals? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. a customer support website that includes knowledgebase search and support for document uploads B. a public website that supports multilingual communities with forums and blogs support C. a secure website for mobile users that is available only by using a VPN into the corporate network D. a secure website for vendors accessing data stored in Common Data Service E. an internal website for employees with limited access to Dynamics 365 Finance data

A. a customer support website that includes knowledgebase search and support for document uploads B. a public website that supports multilingual communities with forums and blogs support E. an internal website for employees with limited access to Dynamics 365 Finance data

A company is building a model-driven app. You need to create and configure the objects needed for the app. Which component categories should you use? To answer, drag the appropriate component categories to the correct objects. Each component category 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. - Relationship between applications - Entry forms - Business rule process - Views to review similar information

- Relationship between applications-Data - Entry forms-UI - Business rule process-Logic - Views to review similar information-UI

You are creating a canvas app that will be used in several countries/regions. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - Canvas app authoring environment will adapt to the language setting of the author. - When running a canvas app on a mobile device, the app adopts the app author's language. - Numbers and dates in Power Apps app automatically conform to the regional and language settings for a user's device.

- Canvas app authoring environment will adapt to the language setting of the author.-Yes - When running a canvas app on a mobile device, the app adopts the app author's language.-Yes - Numbers and dates in Power Apps app automatically conform to the regional and language settings for a user's device.-Yes

A company publishes e-books for independent authors. The company wants to implement a Power Apps portal solution to make announcements about upcoming books to the general public. You need to recommend features for the company. Which features should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. -Ensure that book authors can securely access their data. -Ensure consistent page design across the website. -Ensure that the public can access announcements about upcoming books.

-Ensure that book authors can securely access their data.-Authentic external users -Ensure consistent page design across the website.-Use page templates -Ensure that the public can access announcements about upcoming books.-Browser content anonymously

A company is building a Power Apps Portal. You need to select page components. Which components should you use? - Display a single record from Common Data Service. - Display a list of records from a Microsoft SharePoint list. - Display a list of records from Common Data Service.

- Display a single record from Common Data Service.-Form - Display a list of records from a Microsoft SharePoint list.-List - Display a list of records from Common Data Service.-List

A company plans to implement Power Apps. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - Building Power Apps apps requires proficiency in JavaScript programming. - You must select one of the app templates to create an app.

- Building Power Apps apps requires proficiency in JavaScript programming. -No - You must select one of the app templates to create an app. -No

You create a Power App portal. When a user signs into the portal the following error displays: User not found You confirm that the user's sign in information is correct. You need to determine the cause of the error. What should you do? A. Disable custom error messages. B. Create a custom error message. C. Enable diagnostic tools in Lifecycle Services. D. Enable Maintenance mode.

A. Disable custom error messages.

A company plans to build Power Apps portals. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - You must use standard templates for building portals. - You can test portals in non-prodcution environments and then migrate the portals into production environments. - When transitioning to the new version of a portal, you can display a customizable maintenance page until the new portal is ready to be used.

- You must use standard templates for building portals.-Yes - You can test portals in non-prodcution environments and then migrate the portals into production environments.-Yes - When transitioning to the new version of a portal, you can display a customizable maintenance page until the new portal is ready to be used.-Yes

A company is building a Power Apps portal. You need to select out-of-the-box portal types to meet the company's requirements. Which portal types should you use? To answer, drag the appropriate portal types to the correct requirements. Each portal 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. - Collaboratively onboard new suppliers and distributors. - Publish a blog post announcing new suppliers

-Collaboratively onboard new suppliers and distributors.-partner portal -Publish a blog post announcing new suppliers- community portal

A user is trying to understand the differences between the various ways apps can be built by using Power Apps. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - You can embed canvas apps in model-driven apps. - A Power Apps portal can use only one data source. - You must use Power BI to create reports in model-driven apps.

- You can embed canvas apps in model-driven apps. -Yes - A Power Apps portal can use only one data source. -No - You must use Power BI to create reports in model-driven apps.-No

A user is creating their first canvas app in Power Apps. The user does not know what types of controls they can include. You need to recommend solutions for the user. Which types of controls should you recommend using in Power Apps? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. - View the date, time, and location of upcoming internal meetings. - Create a meeting request from within the app. - Drill down into customer contact records in Dynamics 365 Sales to view a photo of a customer you are meeting.

- View the date, time, and location of upcoming internal meetings.-Gallery - Create a meeting request from within the app.-Meeting-screen template - Drill down into customer contact records in Dynamics 365 Sales to view a photo of a customer you are meeting.-Image

You are designing a Power Apps solution that allows users to upload a status report directly to the company Microsoft SharePoint project management site from their mobile device. For each of the following statements, select Yes it the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - You should build a model-driven app in Power Apps. - You should build a canvas app in Power Apps. - Users must download and run the Power Apps mobile application to use the solution.

- You should build a model-driven app in Power Apps.-No - You should build a canvas app in Power Apps.-Yes - Users must download and run the Power Apps mobile application to use the solution.-Yes

A company uses Dynamics 365 Supply Chain Management. The company wants to build customer user interfaces that add additional functionality. You need to recommend a solution for the company. What should you recommend? A. Power BI B. Power Apps canvas apps C. AI Builder D. Microsoft Flow

B. Power Apps canvas apps

Customer-facing applications must comply with Global Data Protection Regulations (GDPR). You need to recommend actions to help ensure GDPR compliance. Which two features should the company use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. Force a user to update security questions after a specific amount of time. B. Prompt a user for consent to use their personal data and record the date consented. C. Block users who are identified as minors. D. Automatically deactivate a user who has not used the portal in six months.

B. Prompt a user for consent to use their personal data and record the date consented. C. Block users who are identified as minors.

You need to create a mobile application which will allow sales associates to enter custom sales leads. 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. Create a new Power Apps app. Add componentsto the app. Save the app. Publish the app

Create a new Power Apps app. Add componentsto the app. Save the app. Publish the app

A company uses Power Apps canvas apps. When a user opens Power Apps Studio in a browser and selects Apps I can edit, they do not see an app that they need to modify. You need to determine why the user cannot see the app. What are three possible reasons? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. The user selected an incorrect Power Apps environment. B. The user has not been granted the System Customizer role. C. The user has not been set as the app co-owner. D. The app has not been shared with the user. E. The environment does not have a Common Data Service database.

A. The user selected an incorrect Power Apps environment. C. The user has not been set as the app co-owner. D. The app has not been shared with the user.

You create a model-driven app. The app is ready to be shared. You need to complete the process required to set the app up to be shared. How should you complete the process for setting up the app to be shared? To answer, drag the appropriate setting to the correct drop targets. Each source 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. 1. Select an App from the Power Apps List. 2. Select Share. 3. Select a User and choose the security role. 4. Select Share.

1. Select an App from the Power Apps List. 2. Select Share. 3. Select a User and choose the security role. 4. Select Share.

You are creating a model-driven app. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - To add entities to an app, entities are dragged ontothe app canvas from the componentsarea. - View definition is created in the component area of the app designer. - You must save, validate, and publishyour app for othersto see the changes.

- To add entities to an app, entities are dragged ontothe app canvas from the componentsarea.-No - View definition is created in the component area of the app designer.-Yes - You must save, validate, and publishyour app for othersto see the changes.-Yes

You create a canvas app that allows contractors to submit time they work against a project. Contractors must be able to use the canvas app to enter time. Contractors must not be able to perform any other actions in the app. You need to configure permissions for the contractors. Which type of permissions should you use? A. application-level B. task-level C. record-level D. field-level

D. field-level

You are creating a model-driven app to track requests for quotes. The app must use the following navigation structure: Sales - Sales Log, Request for Quotes, Projects, Settings, Customers, Product Lines, Sales Territories Administration - User Admin, Users, Roles You need to create the app navigation. Which sitemap component types should you use? To answer, drag the appropriate component types to the correct navigation elements. 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. - Administration - Sales log - Customers

- Administration -Group - Sales log -Subarea - Customers-Subarea

You have a Microsoft Excel workbook that contains a list of tasks for a project. You store the file in OneDrive for Business. You need to create a canvas app that allows team members to update the status of their tasks. What should you use? A. the Generate an app from data feature B. a custom action in Common Data Service C. Power Apps Checker D. the Open entity data in Excel feature

A. the Generate an app from data feature

You create a canvas app by using the Generate from data feature. The app connects to a Microsoft SharePoint list. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - A screen is generated that contains a browsable list of SharePoint list items. - A screen is generated that allows users to update SharePoint list items.

- A screen is generated that contains a browsable list of SharePoint list items.-Yes - A screen is generated that allows users to update SharePoint list items.-Yes

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point - Power Apps apps can run only mobile devices. - Power Apps can run only with Dynamic 365 products. - If a user runs a Power Apps app that accesses information to which the user does not have access, the app grants the user permissions.

- Power Apps apps can run only mobile devices. -No - Power Apps can run only with Dynamic 365 products. -No - If a user runs a Power Apps app that accesses information to which the user does not have access, the app grants the user permissions.-No

A company plans to synchronize data between Dynamics 365 Supply Chain management and Dynamics 365 Sales. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - You can implement a process-based integration by using the Data Integration feature. - You can use Microsoft Azure Data Migration to synchronize data between the apps.

- You can implement a process-based integration by using the Data Integration feature. -Yes - You can use Microsoft Azure Data Migration to synchronize data between the apps. -No

A company has a website. The website includes a form that allows the company to collect information about leads. You need to set up an automated workflow to create leads in Dynamics 365 Sales when leads are created on the company’s custom website. What should you create? A. Task Flow B. Power Automate flow C. Dynamics 365 workflow D. Business Process Flow

B. Power Automate flow

A company builds and sells residential apartments. The company uses Dynamics 365 Sales to manage sales opportunities. Management must receive notifications on their mobile devices when sales opportunities are created. You need to select recommend Power Platform components to address the requirements. Which two components should you recommend? Each correct answer presents part of the solution. NOTE: Each selection is worth one point. A. Common Data Service connector B. Power BI C. Power Automate D. AI Builder

A. Common Data Service connector | C. Power Automat

A company uses Microsoft 365, SharePoint Online, and Dynamics 365 Sales. You need to recommend tools to build a solution that meets the following requirements: Synchronize data daily - ✑ from an external Microsoft SQL Server instance. ✑ Send a report automatically to specific company executives. ✑ Ensure that opportunities over a specified amount are approved by a sales manager. Which two tools or components should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. ``` A. Microsoft Excel B. Microsoft Word C. Power BI D. Common Data Service E. Power Automate ```

D. Common Data Service | E. Power Automate

You plan to send an email notification to a user when a new file is placed in a specific folder in OneDrive for Business. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - You can create a flow without writing a single line of code and deploy the flow to a production environment. - You cannot add additional actions to the built-in Power Automate templates. - You can view the code that implements workflow actions and triggers without installing additional software.

- You can create a flow without writing a single line of code and deploy the flow to a production environment.-Yes - You cannot add additional actions to the built-in Power Automate templates.-No - You can view the code that implements workflow actions and triggers without installing additional software.-Yes

For which scenarios can you use Power Automate? For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - Notify team members when a response is recorded in a form in Microsoft Forms. - When email is received, save email attachments to OneDrive for Business. - Receive notifications when negative comments about the company are posted on Twitter.

- Notify team members when a response is recorded in a form in Microsoft Forms.-Yes - When email is received, save email attachments to OneDrive for Business.-Yes - Receive notifications when negative comments about the company are posted on Twitter.-Yes

A project deadline is approaching. The project manager reports that there are still a number of critical tasks that are not complete. You need to implement Power Automate to help streamline processes. - Ensure that all of the steps for completing tasks are consistently followed by all team members. - Allow users to send an email to the project lead whenever a task is completed. - Automatically send a list of completed tasks at the end of each week.

- Ensure that all of the steps for completing tasks are consistently followed by all team members.-business process - Allow users to send an email to the project lead whenever a task is completed.-automated - Automatically send a list of completed tasks at the end of each week.-scheduled

A company provides on-site architectural consulting services to residential and business customers. The company wants to implement a simple alert system where a consultant can press a button on their mobile device to send the user’s location to the company as a text notification. You need to build a button flow that sends the notification. In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order. 1. Add a Trigger. 2. Add a new Step to the flow. 3. Select connector and action to send text notifications. 4. Set the action properties. 5. Save the flow.

1. Add a Trigger. 2. Add a new Step to the flow. 3. Select connector and action to send text notifications. 4. Set the action properties. 5. Save the flow.

A company is using Power Automate to automate business processes. You need to recommend triggers for Instant flows. What trigger types should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. - Run a flow when the user presses a button in a canvas app. - Run a flow when user presses a button in the mobile Flow app.

- Run a flow when the user presses a button in a canvas app.-PowerApps - Run a flow when user presses a button in the mobile Flow app.-manually trigger a flow

A company uses Dynamics 365 Supply Chain Management. You need to use Power Automate to automate the process of receiving and tracking raw materials. Which type of connector should you use? A. Common Data Service B. Dynamics 365 C. Dynamics 365 for Fin & Ops D. Dynamic Signal

A. Common Data Service

A company performs on-site inspections and services for air industrial equipment. Field technicians must perform a series of maintenance checks every time they visit a customer site. Every technician performs maintenance steps in a different order. Some technicians miss steps. You need to ensure that all technicians perform the same steps in the same order. What should you use? A. Business process flow B. AI Builder C. Business rule D. Virtual Agent

A. Business process flow

You have a Power Automate flow that saves attachments from emails into OneDrive for Business. You need to determine why the flow is not working. 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. Navigate to the Power Automate admin center and view the projects. B. Navigate to the Action Items section of the Power Automate portal. C. Enable Repair Tips for the flow. D. Navigate to the flow and view the run history. E. Navigate to the Power Automate web portal and click view notifications.

A. Navigate to the Power Automate admin center and view the projects. C. Enable Repair Tips for the flow. D. Navigate to the flow and view the run history.

You are building a Power Automate flow to manage sales. The sales team saves quotes as PDF files to a Microsoft OneDrive folder. You create a Microsoft SharePoint list to help the sales team manage follow ups to quotes. You need to copy the customer name, phone number, and the amount of the potential sale from the sales quote and insert the data into the SharePoint list. Which AI Builder model should you use? A. key phrase extraction B. sentiment analysis C. text recognition D. language detection

C. text recognition

A business plans to including AI Builder. Which actions can you perform? For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - You can use a text classification model in Al Builder to retrieve text and analyze its meaning. - You can tag lnstagram posts that mention your o o new product. - You can send results about the number of mentions of your new product in lnstagram to Power Bl for inclusion on a dashboard.

- You can use a text classification model in Al Builder to retrieve text and analyze its meaning.-Yes - You can tag lnstagram posts that mention your o o new product.-Yes - You can send results about the number of mentions of your new product in lnstagram to Power Bl for inclusion on a dashboard.-Yes

A company wants users to start using Power Automate to improve personal productivity. You need to create a flow. Which two elements must you include? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. expression B. condition C. action D. trigger

C. action | D. trigger

A company plans to use Power Apps to connect to a series of custom services. There are no connectors available for the custom services. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - Custom connector for customer-specific services do not require review and certification by Microsoft. - You can build a custom connector once and reuse the connector for Power Apps and Power Automate. - You can make custom connectors publicly available for all Power Platform users without having Microsoft certify the connector

- Custom connector for customer-specific services do not require review and certification by Microsoft. -Yes - You can build a custom connector once and reuse the connector for Power Apps and Power Automate. -Yes - You can make custom connectors publicly available for all Power Platform users without having Microsoft certify the connector-No

You plan to use Power Automate to perform data-management tasks when users interact with sales opportunities in Dynamics 365. You need to identify the three types of events that can generate a trigger for the tasks. Which three types of events should you identify? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. ``` A. when a record is displayed in a view B. when a record is deleted C. when a record is created D. when a record is updated E. when a record is read ```

B. when a record is deleted C. when a record is created D. when a record is updated

A company uses Dynamics 365 Supply Chain Management. When a sales order is created for one of the customers that a specific user manages, a Microsoft Outlook task must be created to remind the user to perform any follow up activities that are required. You need to implement the functionality to create Outlook tasks. Which two features should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. ``` A. AI Builder B. Power Apps C. Business Events D. Power Automate E. Common Data Service ```

C. Business Events | D. Power Automate

A company uses a third party application and an approval process via email. At the end of the month, the IT department enters the data into Microsoft Excel to create pivot charts. The Excel pivot charts must use the same data source as Dynamics 365 Field Service to generate charts and reports. You need to recommend a solution. What should you recommend? To answer, select the appropriate configuration in the answer area. NOTE: Each correct selection is worth one point. - Create an approval workflow. - Connect to report data.

- Create an approval workflow.-Microsoft Flow | - Connect to report data.-Common Data Service and Power BI

This question requires that you evaluate the underlined text to determine if it is correct. A company requires that service representatives schedule customer visits every six months. Each service representative is required to enter a scheduled task for the next checkup as they are leaving a client site. A service representative wants to automate task entry by creating a _business process flow_ that can be initiated from the service call screen on a phone. Review the underlined text. If it makes the statement correct, select “No change is needed”. If the statement is incorrect, select the answer choice that makes the statement correct. A. No change is needed. B. a scheduled C. an instant D. an action

C. an instant

You build a flow using a template. You want to add support for additional business scenarios. You need to ensure that the new workflow does not break existing functionality. Which flow editing utilities should you use? - Check the new flow for any errors or warnings. - Run the flow using previously processed data. - Monitor the flow as it is running.

- Check the new flow for any errors or warnings.-Flow Checker - Run the flow using previously processed data.-Test - Monitor the flow as it is running.-Test

You overwrite a Power Automate flow by editing the definition and saving the changes. You need to be able to revert a flow to the current state. Which two options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. Export B. Rename C. Save As D. Share

A. Export | C. Save As

You use Power Automate to create a flow that automatically sends email to a project manager when project team members mark a task as complete. Project team members are prematurely marking tasks as complete. Project leads must validate that tasks are complete before an email is sent to the project manager to announce task completion. You need to modify the flow. Which component should you use? A. a process argument B. a condition C. an expression D. a trigger E. a solution

B. a condition

A company uses Power Automate. Which three items can trigger flows? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. ``` A. Lifecycle Services B. Microsoft 365 Admin center C. Common Data Service D. Microsoft Outlook 365 E. Microsoft Windows Desktop ```

A. Lifecycle Services C. Common Data Service D. Microsoft Outlook 365

A software company plans to use Power Automate. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - You must certify custom connectors before users in other departments within your organization can use the connectors. - You must use Microsoft Azure API apps to create a public custom connector

- You must certify custom connectors before users in other departments within your organization can use the connectors. -No - You must use Microsoft Azure API apps to create a public custom connector -Yes

A company is using Power Automate to automate business processes. You need to run a flow when a user presses a button in an app. Which trigger type should you recommend? A. Power Apps B. for a selected row C. manually trigger a flow

C. manually trigger a flow

A company uses a manual process to manage escalations for customer support calls. You must use Power Automate to automate the process for routing escalated calls. You need to create the flow. Which type of connector should you use? A. Microsoft Excel B. Common Data Service C. Office 365 Users

B. Common Data Service

You are creating a Power Automate flow. The flow must read each item in a Microsoft SharePoint list that details sales opportunities and set the value for a field named Status to Overdue if the value of a field named Follow up is less than or equal to the current date. You need to select the appropriate component to cycle through the entire list. Which component should you use? A. Condition B. Connector C. Action D. Trigger

A. Condition

You are creating a Power Automate approval flow. Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - The addition of an expense report to a Microsoft OneDrive folder can initiate an approval flow. - Approvals must follow a sequential order of approval.

- The addition of an expense report to a Microsoft OneDrive folder can initiate an approval flow.-yes - Approvals must follow a sequential order of approval.-no

A company uses Power Automate. Each time a work order is created, a service manager must review and approve the work order before a worker is dispatched. You need to create a flow to enforce the process. What should you create? ``` A. plug-in B. approval flow C. business rule D. team flow E. instant flow F. scheduled flow ```

B. approval flow

You plan to use Power Automate to monitor what people are saying about your company's products. You store the feedback for research and development purposes. You need to recommend Power Automate components to use for the solution. - Retrieve the top five posts from your company's facebook page. - Enter the resulting posts into the product database. - Combine author and link fields into a single field. - Run flow every hour.

- Retrieve the top five posts from your company's facebook page.-Action - Enter the resulting posts into the product database. -Action - Combine author and link fields into a single field.-Expression - Run flow every hour.-Trigger

You are new to working with Microsoft Flow. You create a flow that extracts birth dates for users and then sends a birthday greeting email to users on their birthday. The flow does not properly extract birth dates. Where should you make changes? A. Connectors B. Expression C. Templates

B. Expression

A company plans to use Power Automate to automate tasks. Match each flow type to its description. To answer, drag the appropriate flow type from the column on the left to its description on the right. Each option may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. - a flow that runs after it is triggered by an event - a flow that guides a user through a set oftasks - a flow that runs after a specified number of days - a flow that allows you to start tasks on-demand

- a flow that runs after it is triggered by an event - automated - a flow that guides a user through a set oftasks- business process - a flow that runs after a specified number of days -scheduled - a flow that allows you to start tasks on-demand-instant

You are creating a Power Virtual Agents chatbot for a company. Which component types should you use for each scenario? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. - The chatbot needs to capture of the user id for authentication. - A customer asks a question that needs to be handed off to a live Customer Support representative.

- The chatbot needs to capture of the user id for authentication.-Entity - A customer asks a question that needs to be handed off to a live Customer Support representative.-Topic

You are planning to allow members of your team to test your chatbot. You must ensure this is done in a secure way. A team member named User1 must test the chatbot. You need to ensure that User1 can complete testing. What should you do? A. Sign in to the authoring environment as the chatbot author. B. Sign in to Microsoft Azure DevOps as the chatbot author. C. Sign in to Microsoft Azure DevOps as User1. D. Sign in to the authoring environment as User1.

D. Sign in to the authoring environment as User1

You are authoring a Power Virtual Agents chatbot for a company. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. - You must create a custom action to display a knowledge base article that answers a common support question. - You can use Power Automate to retrieve a customer's contact numberin order to verify they are an authorized user and their support plan SLA.

- You must create a custom action to display a knowledge base article that answers a common support question.-No - You can use Power Automate to retrieve a customer's contact numberin order to verify they are an authorized user and their support plan SLA.-Yes

You create a Power Virtual Agents chatbot for use with Microsoft Teams. You are testing the chatbot. Testers report the following issues: ✑ Changes that you make to the chatbot are not seen by testers. ✑ When users enter the word refund the chatbot must ask the user the product for which they would like a refund. The chatbot does not ask the user for product information. You need to determine what needs to be done to fix the issues. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. - Missing changes - Refund responses are not working as expected.

- Missing changes-Publish the chatbot. | - Refund responses are not working as expected.-Create a refund topic.

v1 Flashcards

(144 cards)