Senior Power Platform Developer

Real-Time Assessment

June 2024

Instructions: Please read through the following questions and provide your answers. There is a 35-minute time limit for this assessment. Answer as many questions as possible within the given time frame.

SECTION 1: MULTIPLE CHOICE QUESTIONS (8 Marks)

1. Which function is used to filter data in Power Apps? (1 mark) *

Filter()

Sort()

Search()

None of the above

2. Describe a scenario where you would use an automated flow? (1 mark)*

Sending daily summary emails

Creating a single-instance report

Manual data entry

None of the above

3. What is a flow in Power Automate? (1 mark)*

A data stream

A visual representation of data

A series of steps to automate a process

A type of data storage

4. How can you trigger a flow in Power Automate? (1 mark) *

Using a button in Power Apps

At a specified time

When data changes in a specified source

All of the above

5. What is the correct syntax to set a variable in Power Apps? (1 mark)*

Set(varName, value)

Var(varName, value)

SetVariable(varName, value)

Variable(varName, value)

6. Which TWO of the following is the correct syntax to filter a gallery based on a text input? (1 mark)*

Filter(Gallery, TextInput1.Text in Title)

Filter(Gallery, Title = TextInput1.Text)

Filter(Gallery, Title.Contains(TextInput1.Text))

Filter(Gallery, Title == TextInput1.Text)

7. What is the correct syntax to navigate to a different screen? (1 mark)*

Navigate(ScreenName)

GoTo(ScreenName)

MoveTo(ScreenName)

ChangeScreen(ScreenName)

SECTION 2: SHORT ANSWER QUESTIONS (14 Marks)

1. Explain the use of the ForAll function in Power Fx and provide an example of how it might be used in a Power App. (2 marks) *

2. What is the difference between the LookUp and Filter functions in Power Fx? (2 marks) *

3. What is the difference between setting up Many-To-Many relationship in Dataverse vs Sharepoint? (2 marks) *

4. Describe the process of utilising variables to filter items displayed in a gallery in Power Apps. Also, discuss how this approach might affect the app’s performance. (2 marks) *

5. Describe the application of the Switch function in Power Fx for handling multiple conditions and compare its efficiency with nested If statements. (2 marks)*

6. Explain how Power BI integration with Power Apps can enhance data visualization and decision-making in a business app. Provide an example of a scenario where this integration would be particularly beneficial. (2 marks)*

7. Describe the purpose of custom connectors in Power Automate and provide an example of when you might need to create one. (2 marks)*

SECTION 3: LONG ANSWER QUESTIONS (8 Marks)

1. Design a Power App scenario that utilises a complex gallery filter with multiple conditions, including user input and data source fields. Explain the logic and performance considerations. (4 marks)

Design a scenario in Power Apps where you need to filter items displayed in a gallery based on multiple conditions, including user inputs and various fields from the data source. Describe the filtering logic you would implement and discuss any performance considerations that might arise due to the complexity of the filter conditions.*

2. Designing and Implementing a Power Apps Solution for a Business Scenario (4 marks)

A retail company wants to create a Power App to streamline the inventory management process. The app should allow employees to check stock levels, update inventory counts, and flag items for reorder. Describe the design of this app including data sources, key functions, and user interface elements. Additionally, explain how you would ensure data integrity and security within the app.*

Full Name*

Email Address*

Acknowledgement: By submitting this assessment, you consent to the collection, processing, and storage of your personal information for the purpose(s) of this application

WCG Senior Power Platform Developer 35-Minute Real-Time Assessment