Latest [Feb 17, 2025] 100% Passing Guarantee – Brilliant PL-100 Exam Questions PDF [Q101-Q124]

NO.101 A company has 500 products. Each product is referenced by a product ID. Each product belongs to one of eight product categories.
You are creating an app to manage requests for new products.
The product categories will never change. Categories are defined in the column itself, not in a separate table.
The data must be structured in a way that does not allow for misspellings.
Only two new tables should be created in Microsoft Dataverse:
Products: Holds the products that can be requested.
Requests: Holds the requests for the product ID and quantity. The products are filtered by product category.
You need to identify the data types to use when building the table columns in Dataverse.
Which data type should you use? To answer, drag the appropriate data types to the correct requirements. Each data 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.

NO.102 A state planning department stores demographic data in a local SQL Server database.
The department uses a local report server to analyze the data for land development purposes.
You need to create a visual to display the demographic data.
Which component should you use? To answer, select the appropriate option in the answer area.
NOTE: Each correct selection is worth one point.

NO.103 A company has hundreds of warehouses. You are developing an app for the shipping department at the company. The app must be able 10 provide the warehouse address for shipments. You need to create the warehouse field on the app form. Which field type should you use?

NO.104 You have the following Common Data Service entities: BusinessContracts and BusinessAccounts.
You need to configure an N:N relationship between the two entities.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

NO.105 You are configuring a new Common Data Service environment by using the Power Apps Maker portal.
You need to create an entity that uses the prefix xyz.
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.

NO.106 You create a dashboard in Power BI. You share the dashboard with the sales team.
Sales team members report that they can see information for the entire company.
You need to ensure that the team is able to see only data for their team.
Where must you configure this restriction?

NO.107 You are creating a canvas app that reads and writes to a data source.
You need to configure the app to perform create and update data operations.
Which functions should you use? To answer, drag the appropriate functions to the correct data operations.
Each function 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.

NO.108 You have an existing Power Apps environment.
You need to create a Common Data Service database for the environment.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

NO.109 You need to select data types for the app.
Which data type should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

NO.110 Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You build a canvas app for a manufacturing company. The company receives parts and materials from many vendors. You create a form to collect information from packing slips.
Receivers must be able to take a picture of packing slips to receive materials instead of manually entering data in the app.
You need to ensure that users can scan packing slip information into the form.
Proposed solution: Use a Text Recognition model.
Does the solution meet the goal?

NO.111 Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You build a canvas app for a manufacturing company. The company receives parts and materials from many vendors. You create a form to collect information from packing slips.
Receivers must be able to take a picture of packing slips to receive materials instead of manually entering data in the app.
You need to ensure that users can scan packing slip information into the form.
Proposed solution: Use a Category classification model.
Does the solution meet the goal?

NO.112 A company has the following divisions: wholesale and retail.
The manufacturer wants to create a single Power BI report to allow users to view data from a Microsoft SQL Server database.
You need to ensure that each user sees data only for the team to which the user is assigned.
How should you secure the report?
To answer, drag the appropriate options to the correct action. Each option 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.

NO.113 A company uses Power Apps. The company has a SharePoint list that contains the names of partner organizations and the country/region of the partners The company requires a canvas app that has a gallery screen to display the information in the SharePoint list. Users must be able to:
* Return results for the exact word that was searched.
* View the latest records at the top of the gallery.
* Use a dropdown control to list the countries/regions of the partners. The list must display each country
/region only once.
You need to create the gallery screen in a canvas app.
Which functions should you use? To answer, drag the appropriate functions to the correct activities. Each function 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.

NO.114 A company uses several forms for biannual performance evaluations. The company conducts the evaluations by using a pen and paper process. The evaluations contain several performance areas that have a score of 1-10.
A paragraph explains the score.
The company must scan completed performance evaluations into a Common Data Service entity by using a Power Apps app. The information in the documents must automatically map to entities and convert into quantifiable information.
If any key phrases in the scored topics cause concern, the company must follow a series of actions to prepare for a follow up.
You need to extract the information and perform the actions when the evaluations are scanned.
Which component should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

NO.115 A company uses Microsoft platforms for all accessibility, compliance, and security auditing.
The auditing and compliance division of the company flags a newly created Power Apps canvas app due to accessibility issues. The app must be unpublished until it conforms to Microsoft accessibility requirements and recommendations.
You need to identify all accessibility issues for a solution.
What should you use?

NO.116 HOTSPOT
You need to configure the system to meet the requirements.
What should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

NO.117 You are creating entities in a Common Data Service database to capture sales data.
You create an entity named Sales that includes the following fields:

You create a new entity that includes a field named TotalSales. The field is used to capture the aggregated sales for each salesperson.
You need to configure the fields for the entities.
Which field types should you use? To answer, drag the appropriate field types to the correct field names. Each field 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.

NO.118 You need to select a design approach for the required features.
Which app type should you use? 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.

NO.119 Inspectors for a city building department use a Microsoft Teams channel, inspectors use SharePoint to view construction bylaws, rules, and regulations.
The city clerk email inspectors links to new bylaw proposal, inspectors vote on the proposals and provide additional feedback.
You need to demonstrate to the city clerk how they can automate the process Which option should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

NO.120 You create a canvas app within a Power Platform environment.
You need to identify potential accessibility issues for the canvas app before making the app available to other users.
Which tool should you use?

NO.121 Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company is deploying Microsoft Power Platform components to streamline a job candidate screening process.
The human resources (HR) representatives of the company plan to attend school career fairs. The HR representatives must qualify and enter potential job candidates into a Power Apps app. The HR representatives must enter the following information for each candidate:

If a candidate is currently unqualified for a job position but would eventually qualify based on follow-up criteria, the follow-up checkbox must be selected or cleared in the system immediately.
The company plans to create a similar Power Apps app that will contain the same business use case, but for internal employees and promotions.
You need to create a Power Apps app solution to automatically mark the candidate for follow up.
Proposed solution: Use a Common Data Service workflow with a PowerQuery on the data entity.
Does the solution meet the goal?

NO.122 You are creating a Power Automate cloud flow to update a column on each Item in a list of Microsoft Dataverse records. Records are sorted in order of priority.
You must use a complex expression to determine the column value. The column value must be stored in a variable to make future maintenance easier. Records must be processed based on the sorted order.
You need to add flow steps to process the list of records.
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.

NO.123 You ate designing an app to track time off for employees. Employee data, including employee ID number, is stored in an existing data source used by other apps.
Employees must be able to look up their employee ID number and enter time-off start and end dates in the app.
You need to configure the elements of the data source.
Which data elements should you use? To answer, drag the appropriate data elements to the correct dat a. Each data element 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.

NO.124 A company uses data from a publicly available web service. You plan to create a tabular report by using Power 81 Desktop to visualize data from the web service.
The data returned in one column is numeric and must be converted to a corresponding text value. The most up-to-date version of the data must always be used.
You need to create the report and make it available only to co workers.
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.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select