SharePoint
Power Automate
PowerApps
PowerBI
Behavioral
100

What is the primary purpose of SharePoint?

To create a centralized space for document management, team collaboration, and content management.

100

What is Power Automate used for?

 Automating workflows between apps and services to sync files, get notifications, collect data, etc.

100

What is Power Apps primarily used for?

Building custom business applications without extensive coding.

100

What is Power BI?

A data visualization and business intelligence tool

100

Describe a time when you worked on a team to complete a challenging project.

(Player provides a personal example, evaluated by the "host")

200

What feature in SharePoint allows you to automate workflows and manage tasks?

SharePoint Workflows (now often integrated with Power Automate).

200

What is a trigger in Power Automate?

An event that starts a workflow, such as a new email received or a file uploaded.

200

In Power Apps, what function would you use to navigate between screens?

The Navigate function.

200

What does DAX stand for in Power BI?

Data Analysis Expressions, a formula language for calculations.

200

How do you prioritize tasks when faced with multiple deadlines?

(Player explains a method for prioritization, such as assessing deadlines and task importance)

300

Name two types of SharePoint sites commonly used in organizations.

Communication sites and team sites.

300

Which type of flow would you use to schedule recurring tasks?

Scheduled flow.

300

What is the main difference between canvas apps and model-driven apps?

Canvas apps provide more flexibility in design, while model-driven apps focus on data structure and relationships.

300

Which feature in Power BI allows you to create interactive, visual dashboards?

Power BI Service.

300

Give an example of a time when you had to learn a new tool or skill quickly.

(Player gives a situation and details steps they took to learn and apply the new skill).

400

Which SharePoint feature enables version control on documents?

Document library version history.

400

What is the purpose of connectors in Power Automate?

Connectors allow Power Automate to communicate with other apps and services.

400

What is a Power Apps collection, and when would you use it?

A collection is a temporary data storage used to store and manipulate data locally within the app, commonly for user sessions or when offline data access is needed.

400

What is Power Query in Power BI used for?

Power Query is used for data transformation and preparation, allowing users to clean and reshape data before analysis.

400

Describe a time you had a conflict with a coworker and how you resolved it.

(Player describes the situation, approach taken, and resolution outcome).

500

What is a SharePoint List, and how is it commonly used

A SharePoint List is a collection of data entries similar to an Excel table, commonly used for tracking items, managing tasks, or storing structured data.

500

What’s the difference between a cloud flow and a desktop flow in Power Automate

Cloud flows automate processes using cloud-based services, while desktop flows (formerly UI flows) automate tasks on the desktop, often interacting with legacy software.

500

How does Power Apps integrate with SharePoint?

Power Apps can use SharePoint as a data source, allowing users to create forms and applications that interact with SharePoint Lists and Libraries.

500

How does Power BI handle real-time data?

Power BI can connect to streaming data sources and update visuals in real-time, useful for live dashboards and real-time monitoring.

500

Tell me about a time when you had to go above and beyond your job responsibilities to complete a task.

(Player explains a challenging situation where extra effort was needed to achieve success).

M
e
n
u