You are designing a database table for a client.
You have the following requirements:
✑ Maintain a comprehensive list of colors and their corresponding RGB values and hexadecimal values.
✑ Prevent the addition of duplicate colors based on the hexadecimal value for the color.
You need to recommend a design for the table.
Which two actions should the client perform after the table is created? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Answer:
BC
B: Setting a column to Business Required means that the default behavior of a model-driven or canvas app will enforce this requirement in the app.
C: With alternate keys you can now define a column in a Dataverse table to correspond to a unique identifier (or unique combination of columns) used by the external data store. This alternate key can be used to uniquely identify a record in Dataverse in place of the primary key. You must be able to define which columns represent a unique identity for your records. Once you identify the columns that are unique to the table, you can declare them as alternate keys through the customization user interface (UI) or in the code.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-field-portal https://docs.microsoft.com/en-us/powerapps/developer/data-platform/define-alternate-keys-entity
HOTSPOT -
A company uses Dynamics 365 Sales and Power BI.
Sales managers must be able to keep track of changes to their pipeline in the following ways:
✑ Notify the sales managers when an Opportunity changes sales stage.
✑ Notify the sales managers when the pipeline drops below 2.5M USD.
✑ When reviewing the pipeline in Power BI, a sales executive must be able to add a Playbook to an Opportunity.
You need to recommend a solution that meets the company requirements.
Which combination of solutions should you recommend? To answer, select the appropriate option in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Box 1: Microsoft Power Automate, Microsoft Dataverse connector, and Microsoft 365 Outlook connector
Use Microsoft Dataverse as the data source.
While Power Automate is a robust tool with ever-expanding capabilities, it also handles simple tasks with grace. A universal business need for many organizations is the ability to automate email notifications based on certain criteria: an opportunity is won, send an email to the sales manager; a case is closed, send an email to the customer; a work order is completed, send an email to the customer.
Power Automate can easily accommodate this using the Microsoft 365 Outlook connector.
Box 2: Microsoft Power Automate, Power Bi data alerts, and Microsoft 365 connector
Data alerts in the Power BI service: Set alerts to notify you when data in your dashboards changes beyond limits you set.
Box 3: Microsoft Power Automate, Power BI, Power Apps, and Microsoft Dataverse connector
Reference:
https://www.velosio.com/blog/2021/01/27/tracking-emails-the-right-way-with-power-automate/ https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts
A company is implementing Dynamics 365 Sales.
The company has turned off out-of-the-box quote calculations in order to implement its own custom calculations.
When users update a line item on a quote, they expect to see an updated total for the quote in real time. Users are reporting inconsistent behavior, with some aggregations taking up to two hours.
You review the system design and notice many asynchronous workflows.
You need to recommend a solution to enable the calculation in real time.
Which two options should you recommend? Each answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Answer:
AB
You are designing a model-driven app that allows a company to manage sales opportunities.
The company has a complex security model that includes the following requirements:
✑ The vice president of sales must be able to see opportunities for sales managers and sales representatives.
✑ Sales managers must be able to see opportunities for all sales representatives.
✑ Sales representatives must only see opportunities that they own.
You need to recommend security tools for controlling user access.
Which two tools should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Answer:
CD
With the position hierarchy security, a user at a higher position has access to the records owned by a lower position user or by the team that a user is a member of, and to the records that are directly shared to the user or the team that a user is a member of.
The hierarchy security model is an extension to the earlier security models that use business units, security roles, sharing, and teams. It can be used in conjunction with all other existing security models.
Reference:
https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/security-dev/hierarchical-security-control-access-entities
A company sells antique books. The company stores data about book locations in an existing system by using the following database fields: Room, Shelf.
The company must import the data from the existing system into a Power Platform solution. Existing data into must be modified to match the design of the new solution.
You need to recommend a solution to combine the room and shelf fields into a single column during the import process.
Which tool should you recommend?
Answer:
B
Dataverse includes a web application tool called Import Data Wizard. You use this tool to import data records from one or more comma-separated values (.csv),
XML Spreadsheet 2003 (.xml), or text files.
Use transformation mapping to modify data before importing it. For example, split a full name that is contained in the source file into a first name and a last name to match the target columns for a table.
Note:
To implement data import, you typically do the following:
✑ Create a comma-separated values (CSV), XML Spreadsheet 2003 (XMLSS), or text source file.
✑ Create a data map or use an existing data map.
✑ Create a comma-separated values (CSV), XML Spreadsheet 2003 (XMLSS), or text source file.
✑ Create a data map or use an existing data map.
✑ Associate an import file with a data map.
✑ Upload the content from a source file to the associated import file.
✑ Parse the import file.
✑ Transform the parsed data.
✑ Upload the transformed data into the target Dataverse server.
Reference:
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/import-data https://docs.microsoft.com/en-us/powerapps/developer/data-platform/add-transformation-mappings-import
A company has a Power Platform environment that connects to a third-party marketing application.
The company reports that the data in the Power Platform lead table does not match data from the marketing application.
Issues include:
✑ The owner data in the lead table and the third-party application do not match.
✑ The Topic column has more information than the related record from the marketing application.
✑ There are differences in how telephone numbers are formatted.
You need to determine which processes are causing the issues.
Which three processes may be causing the differences observed? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Answer:
ABC
A: With advanced data preparation available in Power Apps, you can create a collection of data called a dataflow, which you can then use to connect with business data from various sources, clean the data, transform it, and then load it to Microsoft Dataverse or your organization's Azure Data Lake Gen2 storage account.
B: By combining conditions and actions, you can do any of the following with business rules:
✑ Set column values
✑ Clear column values
✑ Set column requirement levels
✑ Show or hide columns
✑ Enable or disable columns
✑ Validate data and show error messages
✑ Create business recommendations based on business intelligence.
C: Duplicate detection works by comparing generated match codes of existing records with each new record being created. These match codes are created as each new record is created. Therefore, there is potential for one or more duplicate records to be created if they are processed at the exact same moment. In addition to detecting duplicates as they are created, you should schedule duplicate detection jobs to check for other potential duplicate records.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-create-business-rule https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-and-use-dataflows https://docs.microsoft.com/en-us/powerapps/developer/data-platform/duplicaterule-entities
HOTSPOT -
You are supporting the go-live process for a company. The company is responsible for migrating data to the Power Platform by using a custom solution.
The company reports the following issues:
✑ Migration processes fail due to operation timeouts.
✑ Records that include lookup columns often fail to load.
You need to recommend a solution.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Box 1: Increase multithreading and/or batch size settings
Box 2: Ensure you are loading data in a specific order.
Load the base tables in the hierarchies first.
A company wants to add an interactive checklist to a Power Platform solution to ensure that salespeople are following the same steps when qualifying leads.
You need to recommend a solution that will incorporate this checklist.
What should you recommend?
Answer:
D
HOTSPOT -
A company plans to create a Power Platform solution that integrates with Dynamics 365 Sales.
The solution must meet the following requirements:
✑ Connect directly with a Microsoft Azure SQL database as an external data source at run time where specific data is available in the Dynamics 365 Sales solution without the need for data replication.
✑ An external system needs to send data to the company's Dynamics 365 Sales solution.
You need to recommend the most suitable solution to integrate Dynamics 365 Sales with both systems.
What should you recommend? To answer, select the appropriate option in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Box 1: Use Virtual tables -
A virtual entity is a custom entity in Dynamics 365 Customer Engagement (on-premises) that has fields containing data from an external data source. Virtual entities appear in your app to users as regular entity records, but contain data that is sourced from an external database, such as an Azure SQL Database.
Records based on virtual entities are available in all clients including custom clients developed using the Dynamics 365 Customer Engagement Web Services.
Box 2: Use Dynamics 365 Web API.
Dynamics 365 Web Services API: Many times, straight database-to-database integrations aren't a possibility. In these cases, the development of a solution may depend on utilization of the Dynamics 365 Customer Engagement web services API (Application Programming Interface).
Reference:
https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/create-edit-virtual-entities
HOTSPOT -
A company plans to transition from an existing proprietary solution to a Power Platform solution. The company is consolidating data from several sources.
The company reports the following data quality issues with the existing solution:
✑ Users often encounter a character limit when entering data.
✑ The database includes multiple instances of duplicate records.
You need to recommend solutions to ensure that the data quality issues are not present in the Power Platform solution.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Box 1: Define the data type and format for each column
Increase the data type size of the column.
Box 2: Define and implement duplicate detection rules
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean
