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?
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.
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 local bank uses Microsoft Power Platform apps to store customer data.
The bank IT director discovers that all employees can see the social security numbers of their customers. The IT team does not understand how field-level security works and needs help with the design.
You need to recommend a solution to the bank that meets the following requirements:
* The system must restrict access to customer social security numbers to the vice president of finance only.
* The vice president of finance must be able to read and update customer social security numbers.
Which two actions should you recommend? Each correct answer presents part of the solution.
NOT: Each correct selection is worth one point
Field-level security is managed by the security profiles. To implement field-level security, a system administrator performs the following tasks.
Enable field security on one or more fields for a given entity.
Associate one more existing security profiles, or create one or more new security profiles to grant the appropriate access to specific users or teams.
https://docs.microsoft.com/en-us/power-platform/admin/field-level-security
A company provides mobile diagnostic imaging services. You are designing a Power Apps solution to manage patient appointments and procedures.
Patient records are stored within the company s cloud patient billing system. The patient ID must be the only information stored within the app. The patient name and date of birth must be visible to the technician to verify the patient's identity.
You need to recommend a solution to display the patient information.
What should you recommend?
A virtual table is a custom table in Microsoft Dataverse that has columns containing data from an external data source. Virtual tables appear in your app to users as regular table rows, but contain data that is sourced from an external database, such as an Azure SQL Database. Rows based on virtual tables are available in all clients including custom clients developed using the Dataverse web services.
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-virtual-entities
A local bank uses Microsoft Power Platform apps to store customer data.
The bank IT director discovers that all employees can see the social security numbers of their customers. The IT team does not understand how field-level security works and needs help with the design.
You need to recommend a solution to the bank that meets the following requirements:
* The system must restrict access to customer social security numbers to the vice president of finance only.
* The vice president of finance must be able to read and update customer social security numbers.
Which two actions should you recommend? Each correct answer presents part of the solution.
NOT: Each correct selection is worth one point
Field-level security is managed by the security profiles. To implement field-level security, a system administrator performs the following tasks.
Enable field security on one or more fields for a given entity.
Associate one more existing security profiles, or create one or more new security profiles to grant the appropriate access to specific users or teams.
https://docs.microsoft.com/en-us/power-platform/admin/field-level-security
A company uses a third-party cloud-based app to make real-time business decisions. The app has a RESTful API.
You must design a Microsoft Power Platform solution that interacts with the third-party app. Changes made in the Microsoft Power Platform solution must be reflected in the cloud app.
You need to recommend technologies to integrate the Microsoft Power Platform solution with the cloud app.
Which two technologies should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A: To enable Logic Apps, Power Automate, or Power Apps to communicate with the REST or SOAP API, use a custom connector, which is a wrapper around a REST API (Logic Apps also supports SOAP APIs).
C: Custom APIs are a powerful way to connect to any existing API, hosted anywhere, from PowerApps. You do not need a PowerApps Enterprise subscription to register or use a Custom API.
Custom APIs are RESTful endpoints that you can connect to and use from PowerApps. All you'll need is a Swagger definition file for your endpoint.
https://powerapps.microsoft.com/hr-hr/blog/register-and-use-custom-apis-in-powerapps/
Submit Cancel