Microsoft PL-900 Microsoft Power Platform Fundamentals Exam Dumps and Practice Test Questions Set 6 Q101-120

Visit here for our full Microsoft PL-900 exam dumps and practice test questions.

Question 101: 

Which Power Automate component allows running actions repeatedly until a condition is met?

A) Do until
B) Scope
C) Condition
D) Apply to each

Answer:  A) Do until

Explanation:

The Do until component in Power Automate is specifically designed to run a set of actions repeatedly until a defined condition evaluates to true. This allows workflows to continue looping through the actions as long as the condition remains false, providing flexibility for automating repetitive tasks that depend on dynamic criteria. For example, it can be used to check whether a file has been updated, wait for an approval, or repeatedly query a data source until a value meets specific criteria. The loop is dynamic and will terminate as soon as the condition becomes true, making it ideal for scenarios where the end condition is uncertain or may occur at varying times.

Scope, on the other hand, is a way to group multiple actions together into a single logical container. This can help organize complex workflows by visually grouping related actions or managing error handling within that group. However, scope does not inherently repeat its contents; it executes the actions inside only once, and it does not evaluate conditions to determine repetition. While useful for organization and managing workflow logic, scope cannot be used when the goal is to perform repeated execution based on a condition.

The Condition action evaluates an expression and routes the workflow along different branches based on whether the result is true or false. While conditions are useful for controlling the flow of logic, they are not designed to repeat actions multiple times. Each condition evaluation occurs once, determining which path the workflow should follow. Unlike Do until, it does not continue to loop or check the condition repeatedly. Conditions are better suited for branching logic rather than iterative execution.

Apply to each is designed to iterate over a collection of items, performing the same actions for each element in a dataset. While it provides looping behavior, it differs from Do until because it always runs through every item in the collection, regardless of a specific exit condition. It cannot dynamically terminate the loop based on a condition evaluated during the iteration. Therefore, when the requirement is to repeat actions until a certain state is achieved, Do until is the most appropriate choice, as it directly addresses conditional repetition rather than simply iterating through a static list of items.

Question 102: 

Which Power BI feature enables users to combine multiple queries into a single data model?

A) Merge queries
B) Relationships
C) Measures
D) Filters

Answer:  A) Merge queries

Explanation:

Merge queries in Power BI allows users to combine two or more tables into a single query by matching data based on a common column. This is especially useful when working with datasets that are related but stored in separate tables. For example, you might have a sales table and a customer table and want to create a single combined dataset for analysis. Merge queries create a joined table in the data model, allowing subsequent visuals and calculations to use the consolidated data efficiently. This operation can be configured with different join types such as inner, left, right, or full, providing flexibility depending on the data relationship.

Relationships, in contrast, link separate tables in the data model without combining their contents into a single table. They allow users to create associations between fields in different tables so that Power BI can understand how the tables relate, enabling calculations across them. Relationships maintain separate tables in the model and rely on DAX calculations for cross-table operations. While they are essential for relational modeling, they do not perform the actual merging of data, which is what the question asks.

Measures are calculations created using DAX to derive insights from data, such as sums, averages, or percentages. Measures are not used to combine datasets; rather, they provide computed values based on existing data. They operate within the context of the data model but do not physically join tables. Measures are ideal for calculations in reports, but they cannot replace merging queries when the goal is to consolidate multiple tables into one.

Filters are used to limit the data displayed in visuals or reports. They help focus analysis on relevant subsets but do not alter the underlying structure of the data model. Filters do not combine tables or queries; they simply reduce the data visible in a specific context. Because the requirement in the question is to combine queries into a single data model, merge queries is the feature that directly addresses that need, making it the correct answer.

Question 103: 

Which Power Apps component allows displaying a list of items from a data source?

A) Gallery
B) Form
C) Label
D) Button

Answer:  A) Gallery

Explanation:

A Gallery in Power Apps is designed to display multiple records from a data source in a scrollable, visually organized list. It allows users to see, select, or interact with items, making it essential for presenting datasets in a user-friendly way. Galleries can display text, images, and other controls for each record, and they can be customized to include sorting, filtering, and formatting options. For instance, a gallery could show a list of employees with their photos and roles, or products in an inventory app, providing both functionality and an intuitive user experience.

Forms, by comparison, are primarily used to display a single record at a time and provide functionality for creating, editing, or viewing detailed information. They are not optimized for showing multiple items in a list. While forms are essential for input and editing, they do not address the requirement of presenting a full list or collection of data for browsing purposes.

Labels are simple text controls that display static or dynamic text within an app. They are useful for providing information, headings, or instructions but cannot display multiple records or collections of data. Labels show content from a single source or expression and are not designed for iterating over a dataset, which is required when showing a list of items.

Buttons are interactive controls that trigger actions when clicked, such as navigating between screens, submitting forms, or calling functions. They do not display data and cannot present lists. Their purpose is action-based rather than display-based. Because the question focuses on displaying a list of items, the gallery is the correct choice, as it is specifically designed to handle multiple records visually and interactively.

Question 104: 

Which Power BI visualization is best for showing trends over time?

A) Line chart
B) Matrix
C) Card
D) Gauge

Answer:  A) Line chart

Explanation:

Line charts are particularly effective for visualizing trends over time because they connect individual data points along a time axis, making patterns and changes immediately visible. This is ideal for displaying sales trends, website traffic, stock prices, or other metrics that change over intervals such as days, months, or years. The continuous line helps users quickly identify upward or downward trends, seasonal fluctuations, and overall trajectories, supporting both high-level and detailed analysis.

Matrix visuals, in contrast, are designed to organize data hierarchically in rows and columns, similar to a pivot table. They are excellent for showing relationships and summaries but are not intended to illustrate continuous trends over time. While they can display time-based data, the visualization does not emphasize trend direction or movement in the same way that a line chart does.

Cards display single values, such as totals, averages, or key performance indicators. They are useful for highlighting metrics at a glance but cannot convey changes or trends across multiple time periods. Cards provide snapshots rather than sequences, so they are not suitable for trend analysis.

Gauges are used to display progress toward a target or threshold, often for KPIs. They are ideal for showing current status relative to a goal but are not meant for showing historical trends or temporal patterns. Since the question asks for a visualization suitable for trends over time, the line chart is the most appropriate choice because it clearly and effectively communicates changes across a temporal dimension.

Question 105: 

Which Power Apps feature enables automatic actions based on AI predictions or business logic?

A) AI Builder
B) Collections
C) Galleries
D) Labels

Answer:  A) AI Builder

Explanation:

AI Builder in Power Apps provides a set of prebuilt and custom AI models that enable apps to automate actions, predict outcomes, and enhance decision-making. Users can integrate features such as form processing, object detection, and predictive models directly into their apps, allowing the application to perform intelligent actions automatically based on the data it receives. For example, AI Builder can predict customer churn, categorize images, or extract key information from documents, all without requiring deep coding skills.

Collections store temporary data locally during an app session, making them useful for holding records for manipulation or display, but they do not provide any predictive or AI-driven capabilities. Collections are strictly for data handling within the app and are not equipped to perform automated decision-making based on AI or complex business logic.

Galleries are designed for displaying lists of items from a data source and can include interactive elements, but they do not perform automation or predictions. While galleries help users interact with multiple records, they do not make decisions or trigger automatic actions on their own.

Labels display text within an app, whether static or dynamic, and are primarily informational. They cannot process logic, run AI models, or automate actions. Considering that the question asks about enabling automatic actions driven by AI or business logic, AI Builder is the correct answer, as it directly fulfills this functionality by providing predictive and intelligent capabilities integrated into apps.

Question 106: 

Which Dataverse feature ensures users cannot see certain fields in a table?

A) Field-level security
B) Business rules
C) Choice columns
D) Views

Answer:  A) Field-level security

Explanation:

Field-level security in Dataverse is a feature designed to provide granular control over access to specific fields within a table. This means that even if a user has access to the table itself, they may not be able to view or edit certain sensitive fields if permissions are restricted. Field-level security is essential in environments where confidential or sensitive information, such as financial details or personal data, must be protected from unauthorized users or teams. By configuring security profiles and applying them to fields, organizations can ensure that only authorized personnel can access specific data elements while keeping the rest of the table visible.

Business rules, on the other hand, are logic-based configurations that enforce data integrity, validation, or calculations automatically. They can ensure that a field meets specific conditions, set default values, or make fields required dynamically, but they do not provide mechanisms to hide fields from certain users. Business rules act at the data and user interface level, but they are not intended to control access in the way field-level security does. While they enhance data quality, they cannot restrict visibility.

Choice columns are predefined fields that allow users to select from a fixed set of values, often used for categories, statuses, or dropdowns. They provide consistency in data entry and reporting but do not influence user access. Any user with access to the table can see and interact with choice columns; they do not offer selective visibility for sensitive information. Choice columns are more about controlling input rather than securing data.

Views are used to filter or present data in a table according to specific criteria. They determine what rows and columns appear for the user in a list or grid format, enhancing usability and reporting. However, views do not restrict access at the security level. A user can still access fields outside of the view if they have permissions to the table. Views are primarily a presentation layer tool and cannot enforce field-level security.

In reasoning through the options, field-level security is the only feature explicitly designed to control visibility and access at the field level. Business rules enhance functionality and validation but cannot hide fields. Choice columns restrict values, not access, and views control presentation, not security. Therefore, field-level security is the correct answer because it directly addresses the requirement to hide fields from certain users while allowing others to interact with the same table.

Question 107: 

Which Power Automate feature is used to run flows on a schedule?

A) Scheduled flow
B) Instant flow
C) Automated flow
D) Desktop flow

Answer:  A) Scheduled flow

Explanation:

Scheduled flows in Power Automate are designed specifically to run at defined time intervals. Users can set these flows to trigger daily, weekly, monthly, or at custom intervals. This feature is extremely useful for routine tasks such as sending reports, syncing data between systems, or performing scheduled backups. Scheduled flows operate independently of user actions, making them ideal for recurring processes that do not require immediate interaction.

Instant flows require a manual trigger, such as a button click in Power Automate or Power Apps. These flows are executed on demand, making them suitable for one-off or user-initiated actions rather than recurring tasks. Since they depend on user input, they cannot be scheduled automatically, which is a key distinction from scheduled flows.

Automated flows run in response to specific events or triggers, such as when a new item is created in SharePoint or an email arrives in Outlook. While automated flows are event-driven, they are not time-driven. They respond to changes in the system rather than running at predetermined intervals. This makes them unsuitable for tasks that must run on a fixed schedule.

Desktop flows, or robotic process automation (RPA) flows, execute tasks on a local machine rather than in the cloud. They automate repetitive desktop tasks such as data entry, file processing, or application navigation. While powerful for desktop automation, desktop flows are not inherently designed to run on a schedule unless combined with other scheduling tools.

In evaluating these options, scheduled flows are the only type that natively supports execution at specific times without requiring manual interaction or triggering from an external event. Instant flows are user-initiated, automated flows respond to events, and desktop flows focus on desktop automation. Therefore, the correct answer is scheduled flow because it meets the requirement of recurring, time-based execution.

Question 108: 

Which Power BI feature allows users to restrict data visibility based on roles?

A) Row-level security
B) Filters
C) Bookmarks
D) Workspaces

Answer:  A) Row-level security

Explanation:

Row-level security (RLS) in Power BI enables organizations to control data access at a granular level, ensuring that users can only see rows in a dataset that correspond to their roles. For example, a sales manager in one region can view only their region’s data while remaining unaware of other regions’ information. RLS is implemented by defining roles and DAX filters in the dataset, allowing dynamic data restriction based on user identity or role membership.

Filters are applied within visuals, pages, or reports to control which data is displayed, but they do not enforce security. Users can still access unfiltered data if they have permissions to the dataset. Filters are primarily a presentation tool, designed to enhance reporting and user experience, rather than restrict access at the security level.

Bookmarks capture the current state of a report, including filters, slicers, and visual selections, allowing users to quickly navigate back to a specific configuration. While bookmarks improve navigation and storytelling in reports, they do not enforce any data access control. Bookmarks do not prevent users from seeing restricted rows of data if they have permissions to the underlying dataset.

Workspaces are collaborative containers in Power BI for sharing reports, dashboards, and datasets. While they manage collaboration and permissions at a higher level, they do not provide row-level restriction of data. Users may have access to all datasets in the workspace, making workspaces unsuitable for controlling visibility at the row level.

Considering all options, only row-level security explicitly enforces visibility restrictions based on user roles. Filters and bookmarks are presentation and navigation tools, and workspaces manage collaboration rather than data access. Therefore, the correct answer is row-level security.

Question 109: 

Which Power Apps component allows users to edit single records from a data source?

A) Form
B) Gallery
C) Label
D) Button

Answer:  A) Form

Explanation:

Forms in Power Apps are components designed to allow users to create, view, and edit individual records from a data source. They provide a structured interface with fields mapped to columns in the data source, enabling seamless interaction with single records. Forms support data validation, default values, and dynamic rules, making them ideal for applications where accurate and controlled data entry is required.

Galleries are visual components for displaying multiple records in a scrollable list or grid. While they are excellent for browsing, selecting, or filtering multiple items, galleries do not provide built-in editing capabilities for single records. Users typically select a record from a gallery and then use a form to edit it.

Labels are static text elements in Power Apps that display information from a data source or other components. They are read-only and cannot capture or modify data. Labels are useful for showing information dynamically but are not designed for record editing.

Buttons are action-triggering components that perform operations such as submitting data, navigating to another screen, or running a flow. While buttons can initiate record edits or submissions, they do not provide an interface for directly editing data.

Given these options, forms are specifically built for interacting with single records, offering both display and editing capabilities. Galleries only display multiple records, labels are read-only, and buttons trigger actions. Therefore, the correct choice is the form component.

Question 110: 

Which Power Automate action is used to create multiple parallel paths for execution?

A) Parallel branches
B) Scope
C) Condition
D) Apply to each

Answer:  A) Parallel branches

Explanation:

Parallel branches in Power Automate allow multiple independent sets of actions to run concurrently, rather than sequentially. This is particularly useful for tasks that can execute simultaneously, such as sending notifications to multiple recipients, updating multiple databases, or performing parallel API calls. By running actions in parallel, flows can execute more efficiently and reduce overall processing time.

Scope is an action that groups multiple steps together into a single container. Scopes provide organizational clarity and enable error handling across a set of actions, but they execute sequentially rather than concurrently. While scopes are helpful for managing complex flows, they do not enable parallel execution on their own.

Condition is a branching control that evaluates an expression and executes one of two paths: if true or if false. Conditions help implement logic in a flow, but the paths are mutually exclusive rather than simultaneous. Conditions do not allow multiple branches to execute at the same time.

Apply to each is used to iterate over a collection, performing actions on each item in sequence. While it enables processing multiple items, it runs sequentially by default. Parallel execution in loops requires additional configuration, making apply to each unsuitable for simple parallel branching.

Considering all options, parallel branches are the only action designed to run multiple sets of steps simultaneously without waiting for others to finish. Scope, condition, and apply to each either run sequentially or control logic rather than concurrency. Therefore, parallel branches is the correct answer.

Question 111: 

Which Power BI feature allows end-users to dynamically filter report data using buttons on the report?

A) Slicers
B) Relationships
C) Measures
D) Bookmarks

Answer:  A) Slicers

Explanation:

Slicers in Power BI are a visual and interactive element that allows users to filter data across reports easily. They appear as buttons or lists that display unique values from a column and enable end-users to select one or multiple options, instantly updating the visuals on the report. This interactivity makes reports more dynamic and allows for tailored data exploration, improving the analytical experience for users who may want to see trends, summaries, or specific slices of information without manually adjusting filters.

Relationships, on the other hand, define how tables are connected within the data model. While relationships are critical for ensuring accurate calculations and aggregations across related tables, they do not provide interactive filtering capabilities for end-users. They function behind the scenes to propagate data context but do not allow a user to click a button or toggle a value to change the visible data on a report page.

Measures are DAX expressions that perform calculations on data. They can be used to compute totals, averages, or other aggregations dynamically, but they do not provide a user-facing interface to filter or manipulate visuals directly. Measures are essential for analysis but require other elements like slicers or filters to interactively affect visuals.

Bookmarks capture and save a specific state of a report, including filters, slicers, and the layout of visuals. While bookmarks can be used to switch between views or highlight specific scenarios, they are static unless combined with buttons for navigation. Unlike slicers, they do not allow end-users to filter data dynamically in a flexible, exploratory way.

Slicers are the correct choice because they provide a direct, interactive filtering mechanism for end-users. Their visual representation and instant impact on report visuals make them the preferred solution when interactivity is required. Slicers allow reports to be more engaging and accessible, providing both simplicity and efficiency in filtering data.

Question 112: 

Which Dataverse column type is used to reference another table?

A) Lookup column
B) Choice column
C) Text column
D) Currency column

Answer:  A) Lookup column

Explanation:

A lookup column in Dataverse creates a relationship between two tables, allowing one table to reference a record in another table. This ensures referential integrity and enables users to connect related information, such as linking an order to a customer record or an invoice to a product. Lookup columns are essential for relational database functionality and for modeling real-world business relationships within Power Apps.

Choice columns, by contrast, provide a predefined set of options from which users can select a value. While useful for maintaining data consistency and reducing input errors, choice columns do not reference external tables. They are static lists rather than dynamic connections between entities, so they cannot maintain relational links.

Text columns are used to store string-based data such as names, descriptions, or any free-form text. They are versatile but serve only as containers for text; they do not enforce relationships or connect records across tables. Text columns are ideal for descriptive or user-input data but cannot reference other entities.

Currency columns store numerical values with a fixed currency format and are primarily used for financial calculations. They support numeric operations and formatting but have no relational functionality to connect tables. They are not relevant for referencing another table.

The lookup column is the correct answer because it specifically creates a relationship between tables in Dataverse, enabling relational data modeling. This functionality is crucial for applications that rely on interconnected data, such as CRM systems or business process automation.

Question 113: 

Which Power Automate component evaluates an expression and executes actions based on true or false outcomes?

A) Condition control
B) Scope
C) Parallel branch
D) Apply to each

Answer:  A) Condition control

Explanation:

Condition control in Power Automate is used to evaluate logical expressions and branch the flow based on whether the condition is true or false. This enables automation to make decisions dynamically, performing different actions depending on the data or context. For instance, a condition might check if an invoice amount exceeds a threshold, and execute different actions accordingly, making workflows intelligent and adaptive.

Scope is a container that groups multiple actions together for better organization or error handling. While it is useful for structuring a flow and applying configuration settings to a group of actions, it does not make conditional decisions on its own. Scope cannot evaluate true or false expressions to determine which actions to execute.

Parallel branch allows multiple sets of actions to run simultaneously. This is effective for improving efficiency or performing independent tasks concurrently but is not a conditional mechanism. Parallel branches do not evaluate expressions to decide execution paths; they simply execute actions at the same time.

Apply to each iterates through a collection of items, performing actions on each element. While useful for processing multiple records or values, it is not inherently conditional. It processes each item sequentially and does not execute actions based on a true/false evaluation unless combined with an internal condition.

Condition control is correct because it is explicitly designed for branching logic. It allows flows to respond dynamically to data, executing actions selectively, which is a foundational capability for creating complex, automated workflows.

Question 114: 

Which Power Apps control displays multiple records in a scrollable list?

A) Gallery
B) Form
C) Label
D) Button

Answer:  A) Gallery

Explanation:

Galleries in Power Apps are designed to display multiple records from a data source in a scrollable, repeatable layout. They allow users to browse lists, select items, and trigger further actions, making them ideal for dashboards, directories, or any interface that needs to present multiple items at once. Galleries support customization of templates and layout, enabling developers to create visually appealing and functional interfaces.

Forms are typically used to display and edit a single record at a time. While they can connect to a data source and allow updates, they are not intended for presenting multiple records simultaneously. Forms are better suited for detailed record-level interactions rather than browsing or selection.

Labels are static text elements used to display information on the screen. They do not display multiple records or offer interactivity beyond presenting content. Labels are essential for user interfaces but cannot function as record viewers.

Buttons trigger actions such as submitting forms or navigating between screens. They do not display data from a collection or data source. Buttons are interactive controls but are action-focused rather than display-focused.

Galleries are correct because they are explicitly designed to show multiple records in a scrollable format, providing both visual structure and user interaction for record navigation and selection.

Question 115: 

Which AI Builder model extracts structured information from documents?

A) Form processing
B) Prediction
C) Object detection
D) Category classification

Answer:  A) Form processing

Explanation:

Form processing in AI Builder is a specialized model designed to extract structured information from documents such as invoices, receipts, purchase orders, and other business forms. It works by identifying key-value pairs, tables, and text fields within a document, converting unstructured content into structured, usable data that can be integrated directly into apps, workflows, or databases. This capability is particularly useful for automating repetitive tasks that would otherwise require manual data entry, significantly improving both efficiency and accuracy. By recognizing patterns and labels within documents, form processing allows organizations to streamline operations and reduce the risk of human error.

Prediction models, by contrast, are built to analyze historical data to forecast future outcomes. These models are commonly used for trend analysis, risk assessment, and scoring scenarios based on past patterns. While prediction models are highly valuable for decision-making and data insights, they do not interact with the content of documents to extract structured information. Their functionality is analytical rather than extraction-focused, meaning they work with already structured data to produce forecasts or recommendations rather than converting unstructured text into structured fields.

Object detection models in AI Builder are designed to identify and locate specific items within images or video streams. These models are applied in scenarios such as quality inspections, inventory tracking, or identifying objects in photographs. However, object detection is a visual recognition technology and does not apply to textual or tabular data extraction. It cannot interpret documents or extract fields, so it is unrelated to the task of capturing structured information from forms or invoices.

Category classification models are used to classify input data into predefined categories. This type of model is useful for tagging content, routing information, or organizing unstructured data into logical groups. While category classification can provide high-level insights into the type of data present, it does not extract the detailed structured elements such as individual fields, tables, or key-value pairs from documents. Therefore, it cannot replace form processing for automated document handling.

Form processing is the correct choice because it is explicitly built for capturing structured data from documents. Its design allows it to automatically detect relevant fields and convert them into actionable data, enabling integration with Power Platform tools for automation, reporting, and workflow management. By using form processing, organizations can eliminate tedious manual work, ensure data accuracy, and accelerate business processes.

Question 116: 

Which Power BI feature allows navigation to a detail page filtered by a selected value?

A) Drill-through
B) Bookmark
C) Tooltip
D) Slicer

Answer:  A) Drill-through

Explanation:

Drill-through in Power BI is a feature designed to allow users to move from a summary view of data to a more detailed view that is automatically filtered based on the selected item. For example, if a user clicks on a specific product in a sales summary chart, drill-through can navigate them to a dedicated page showing all transactions for that product. This capability enhances interactivity in reports and allows users to focus on granular insights without manually applying filters. Drill-through works by creating a dedicated target page that expects one or more fields to filter its content dynamically.

Bookmarks, in contrast, are used to capture the current state of a report page, including applied filters, slicers, and visual settings. They are primarily for navigation, storytelling, or quickly returning to a specific view of the report. While bookmarks can save filtered states, they do not inherently filter the report dynamically based on user selection. A bookmark preserves a snapshot rather than dynamically adapting to a clicked value, which makes it fundamentally different from drill-through.

Tooltips display contextual information when a user hovers over a visual. They can provide additional insights without leaving the current page, such as showing detailed metrics or metadata about a data point. However, tooltips do not navigate users to a separate page or apply dynamic filters to other visuals. They are transient, overlay-based, and intended for immediate contextual reference rather than detailed data exploration.

Slicers are visual filters that allow users to filter multiple visuals on a page by selecting values. While slicers can dynamically adjust what is displayed in charts and tables, they do not facilitate page navigation. They affect the current report page’s visuals but do not create a separate drill-through experience. Drill-through is the correct option because it specifically combines both filtering and navigation to another page, providing detailed, context-sensitive data exploration.

Question 117: 

Which Power Apps component stores temporary data accessible across screens during an app session?

A) Collection
B) Label
C) Button
D) Timer

Answer:  A) Collection

Explanation:

Collections in Power Apps are a type of temporary storage used to hold data in memory while an app is running. They can store single records, tables, or complex data and can be accessed from multiple screens within the app session. Collections are particularly useful for situations where you need to manipulate data locally before saving it to a database or for temporarily storing data that comes from user input or external sources. They provide a flexible way to work with dynamic data in real-time.

Labels are controls in Power Apps used to display static or dynamic text. While they can show information from a data source or formula, labels themselves do not store data that persists across screens. Their role is purely presentational, providing users with visible feedback or content rather than acting as a temporary storage mechanism.

Buttons are interactive controls that perform actions when clicked. They are used to trigger formulas, navigate between screens, or manipulate data, but they do not store any data themselves. The value of a button lies in its ability to initiate workflows or functions, making it distinct from components like collections that store and manage data.

Timers execute actions based on elapsed time. They are typically used for scheduling, delayed actions, or periodic updates within an app. While timers can trigger actions that affect data, they do not themselves hold temporary data accessible across screens. Collections are the correct choice because they specifically provide in-memory, session-wide storage for data, enabling complex app logic that spans multiple screens.

Question 118: 

Which Power Automate feature enables multiple tasks to run simultaneously?

A) Parallel branches
B) Scope
C) Condition
D) Apply to each

Answer:  A) Parallel branches

Explanation:

Parallel branches in Power Automate allow actions to execute independently and concurrently, reducing overall processing time. Each branch runs in parallel to others without waiting for previous steps to complete. This is particularly useful in scenarios where multiple independent operations need to happen at the same time, such as sending emails while updating a database and notifying a team simultaneously. Parallel branches improve efficiency by leveraging asynchronous execution.

Scope, on the other hand, groups multiple actions together, but these actions run sequentially rather than concurrently. Scope is primarily used for organization, error handling, or logically grouping actions for clarity. While it helps in structuring flows and managing related actions, it does not enable simultaneous execution of tasks.

Conditions in Power Automate are used to evaluate expressions and branch the flow based on true or false outcomes. While conditions control the flow’s path, they do not allow multiple tasks to run at the same time. Each branch under a condition executes sequentially once the condition evaluates, which is fundamentally different from parallel processing.

Apply to each iterates over a collection of items and performs actions on each item one at a time by default. It is sequential in nature, although it can be configured for concurrency in some cases. Still, it is primarily designed for looping rather than simultaneous execution of completely independent actions. Parallel branches are correct because they natively support concurrent execution of multiple independent actions.

Question 119: 

Which Power BI feature dynamically calculates values based on filters and slicers?

A) Measures
B) Relationships
C) Dataflows
D) Bookmarks

Answer:  A) Measures

Explanation:

Measures in Power BI are formulas created using DAX (Data Analysis Expressions) that dynamically compute values based on the current context, such as filters, slicers, or visual interactions. They do not store data but calculate results in real-time, adjusting automatically when the report context changes. Measures are essential for aggregations like sums, averages, ratios, or more complex calculations that must respond to user interactions.

Relationships define connections between tables in a Power BI model, enabling the use of data across multiple tables. While relationships influence how measures calculate results, they do not themselves perform calculations. They are structural rather than computational components.

Dataflows are ETL tools in Power BI used to extract, transform, and load data into a model. They handle data preparation but do not perform dynamic calculations on-the-fly in response to user filters or slicers. Their primary purpose is to create reusable datasets, not compute context-aware metrics.

Bookmarks save report states, including filters and visual configurations, for quick access or storytelling. They capture static states rather than dynamically recalculating values. Measures are correct because they provide the ability to calculate metrics dynamically and contextually, responding instantly to user interactions like slicer changes or filter applications.

Question 120: 

Which Power Apps control allows users to select a single value from a list?

A) Dropdown
B) Gallery
C) Label
D) Timer

Answer:  A) Dropdown

Explanation:

Dropdown controls in Power Apps present a list of predefined options from which a user can select a single value. They are compact, easy to use, and ensure that only valid choices are selected, which is essential for maintaining data integrity. Dropdowns are widely used in forms and applications for input where choices must be restricted to a controlled set of values.

Galleries display multiple records from a data source and allow users to scroll through or select items. While they can support selection, galleries are designed primarily for visual browsing and are not optimized for restricting input to a single controlled value. They are better suited for displaying collections rather than enforcing a single selection.

Labels display text or calculated content but are not interactive and do not allow users to select values. Their role is purely to show information and provide feedback within the app. They cannot serve as input controls, making them unsuitable for selection purposes.

Timers execute actions based on a set time interval. While they can trigger events or updates automatically, they do not provide any mechanism for users to select values. Dropdowns are the correct choice because they are specifically designed for single-value selection from a predefined list, combining usability with controlled data entry.