Microsoft PL-900 Microsoft Power Platform Fundamentals Exam Dumps and Practice Test Questions Set 7 Q121-140

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

Question 121: 

Which Power Automate feature repeats actions for each item in a collection?

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

Answer:  A) Apply to each

Explanation:

Applying to each is a key component in Power Automate that allows flows to iterate through a collection of items. When a flow receives multiple records, such as from a SharePoint list, Dataverse table, or Excel spreadsheet, it is often necessary to perform the same action on every item. Applying to each enables this by looping over the collection and executing the contained actions for each element, one by one. This ensures consistent processing for every record, and it is particularly useful when combined with other actions like sending emails, updating items, or creating tasks.

Scope is different from Apply to each because it is used to group multiple actions together into a single logical container. This is useful for organizing flows and handling errors, but it does not inherently iterate over a collection. Scope helps manage complexity, especially in large flows, but it cannot replace the looping functionality provided by Apply to each. It simply allows multiple actions to execute together without branching logic for each item in a dataset.

Condition evaluates a logical expression and branches the flow depending on whether the expression is true or false. While essential for decision-making within flows, Condition does not perform repeated actions over a collection. It is best used for applying different actions depending on certain criteria, but it operates on a single evaluation at a time rather than iterating through multiple items. Its focus is on branching rather than repetition.

Parallel branches allow multiple actions to run simultaneously, which is helpful for optimizing performance when tasks are independent of each other. However, parallel branches do not loop over collections and cannot perform repeated actions automatically for each item. They are designed for concurrency rather than iteration. Since the requirement of the question is to repeat actions for each item in a collection, Apply to each is the only option that directly fulfills this purpose.

Question 122: 

Which Power Apps feature allows app designers to create reusable UI components?

A) Component library
B) Gallery
C) Form
D) Button

Answer:  A) Component library

Explanation:

A component library in Power Apps is designed to help app designers create and manage reusable UI elements. These components can be anything from custom buttons and icons to complex input forms and navigation bars. Once created in a component library, these elements can be reused across multiple apps, ensuring consistency in design and behavior while reducing development time. Component libraries support standardization and make app maintenance easier, as updates to a component in the library can propagate to all apps that use it.

Galleries are used to display multiple records in a scrollable list or grid. While galleries are important for presenting dynamic data, they are not inherently reusable across apps in the same structured way that a component library allows. Galleries focus on data presentation rather than design reusability, making them useful for building interactive user interfaces but not for standardizing UI elements.

Forms in Power Apps are designed to create or edit individual records from a data source. They provide structure for data entry and validation but are tied to a specific data source or context within an app. Forms are not meant for creating reusable design components; they are functional controls for working with data, rather than reusable interface elements.

Buttons are individual controls that trigger actions in an app. While essential for interactivity, they do not provide a framework for creating and sharing complex UI designs across apps. Buttons can be part of a reusable component but on their own are not sufficient for building a library of reusable UI elements. Since the question specifically asks for a feature that enables reusable UI components, component library is the correct choice.

Question 123: 

Which Dataverse column type lets users select from predefined options?

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

Answer:  A) Choice column

Explanation:

Choice columns in Dataverse are designed to provide users with a predefined list of options to select from. This ensures data consistency and accuracy by restricting input to specific values. Choice columns can include single or multiple selections depending on the configuration, and they are commonly used for fields such as status, priority, or category. By using choice columns, organizations can enforce standardized data entry, simplify reporting, and reduce errors caused by free-text input.

Lookup columns are used to reference other tables in Dataverse. They allow users to select a record from another table, establishing relationships between tables. While lookup columns provide relational capabilities, they do not offer a predefined set of simple options for direct selection. Their purpose is linking records rather than standardizing data through fixed options.

Text columns store unstructured string data entered by users. Text columns are flexible but do not enforce any restrictions on input. They are ideal for names, descriptions, or notes, but because they allow free-form text, they cannot guarantee consistency. Text columns do not offer the dropdown selection mechanism that choice columns provide.

Currency columns are numeric fields used to store monetary values. They are configured for financial data and include formatting for currency symbols and decimal precision. Currency columns are not used for selecting from predefined options and are unsuitable for categorical data entry. Because the question focuses on selecting from a predefined list, the choice column is the correct selection.

Question 124: 

Which Power BI feature lets users save the current report view to return to later?

A) Bookmark
B) Slicer
C) Measure
D) Relationship

Answer:  A) Bookmark

Explanation:

Bookmarks in Power BI allow users to capture the current state of a report, including filters, slicers, sorting, and visual settings. This makes it easy to save a specific view of the data for later reference, reporting, or presentation purposes. Bookmarks are useful for storytelling in reports, allowing users to highlight key insights or create guided navigation through different report views. They provide a way to preserve a personalized or configured view without altering the underlying dataset.

Slicers are interactive visual filters that allow users to dynamically filter data in reports. While slicers control the displayed data, they do not save the report view itself. Slicers are temporary filters and their states are not preserved as a reusable view unless combined with bookmarks, so they cannot fulfill the requirement of saving a view for future access.

Measures are calculations created in Power BI using DAX to produce dynamic results based on the underlying data. Measures are crucial for analytical insights and summarization, but they do not capture or save report layout or filter state. Their purpose is computation rather than view preservation.

Relationships in Power BI define connections between tables, allowing data to be modeled correctly for analysis. Relationships enable accurate calculations and filtering across tables but do not provide any functionality for saving report views. Since the question focuses on preserving a specific report configuration for later use, bookmark is the correct feature.

Question 125: 

Which Power Apps control displays a single value from a data source?

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

Answer:  A) Label

Explanation:

Label controls in Power Apps are designed to display static or dynamic text, including values retrieved from a data source. They are ideal for showing single data points such as a name, number, or status. Labels are highly flexible and can be formatted in various ways, including font size, color, and alignment, to improve readability. They are the primary control for displaying information without allowing direct editing by users.

Galleries are controls used to display multiple records in a structured format, such as lists or grids. They are excellent for browsing datasets but are not intended for showing a single value. Galleries provide a repeatable layout for multiple items, making them unsuitable when the goal is to display only one piece of data.

Forms allow users to view or edit a record from a data source. While forms can display single values as part of a record, they are designed to handle multiple fields and data entry rather than simply presenting one value. Forms add complexity when only a display of a single data point is needed.

Dropdown controls let users select a value from a predefined list. Dropdowns are interactive and focus on input rather than display. They are not meant for simply showing a single value from a source because their primary function is to provide selectable options. Therefore, for the requirement of displaying a single value, label is the correct control.

Question 126: 

Which Power Automate flow type runs based on a manual trigger?

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

Answer:  A) Instant flow

Explanation:

Instant flows are designed to run immediately when a user triggers them manually. This can be done through a button in the Power Automate mobile app, within Power Automate on the web, or even through Power Apps if the flow is linked there. The main characteristic of instant flows is that they do not depend on an external event or schedule to start; instead, they give users direct control to run the flow exactly when needed. This makes them highly suitable for scenarios where a task is not predictable or needs to be executed on demand. Users can configure input parameters for these flows, allowing them to pass information dynamically at the moment of execution, enhancing flexibility.

Automated flows, by contrast, are triggered by predefined events rather than user actions. These events could include receiving an email, a new file being added to OneDrive, or a record being created in Dataverse. Because the flow depends on these triggers, users do not manually start the process, making automated flows unsuitable for situations where a manual action is explicitly required.

Scheduled flows operate on a defined timing mechanism. They run at specific intervals, such as daily, weekly, or monthly, according to a schedule set by the creator. Scheduled flows are ideal for recurring tasks but cannot respond to a user’s immediate need, which is why they do not fit the requirement for a manual trigger.

Desktop flows are intended for automating repetitive tasks on local computers using robotic process automation. While they can be triggered manually or scheduled, they primarily focus on interacting with desktop applications rather than cloud-based events. Because the question emphasizes manual triggering within Power Automate, the correct answer is instant flow. Instant flows provide the precise mechanism for a user-initiated start, fulfilling the manual trigger condition accurately.

Question 127: 

Which AI Builder model identifies physical objects in images?

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

Answer:  A) Object detection

Explanation:

Object detection models in AI Builder are specialized for recognizing and identifying tangible items within images. These models can detect multiple objects, classify them, and even determine their positions within the image using bounding boxes. This capability is widely used in inventory management, quality control, and retail scenarios where automated recognition of physical items is essential. Object detection allows users to extract actionable insights directly from visual data, making it very powerful for real-world applications.

Prediction models are used to forecast outcomes based on historical data. They analyze trends and patterns to make predictions about future events or classify inputs into specific outcomes. Prediction does not interact with images directly and is entirely data-driven, which makes it unsuitable for recognizing physical objects in pictures.

Form processing models are designed to read structured information from documents such as invoices, receipts, and forms. They can extract text, tables, and key-value pairs, converting unstructured content into usable data. Although highly effective for document automation, form processing does not detect objects in images.

Category classification models assign data to predefined categories based on patterns found in input data. While they are useful for sorting and organizing information, they do not have the capability to identify specific physical objects within images. Considering the requirement is to detect physical objects visually, object detection is the correct model, as it is explicitly designed to identify and locate items in images accurately.

Question 128: 

Which Power BI visual is used to compare performance against a target?

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

Answer:  A) Gauge

Explanation:

Gauge visuals are ideal for showing progress toward a specific goal or target. They display a single value against a defined range, often including indicators for minimum, maximum, and target thresholds. This visualization provides an intuitive understanding of how far performance is from the goal and is commonly used in dashboards for KPIs, sales targets, or operational metrics. Users can quickly see whether they are on track or need corrective action.

Line charts display trends over time, illustrating how data changes along a timeline. They are excellent for showing patterns, fluctuations, and comparisons across multiple periods but are not specifically designed to compare a single value to a target.

Matrix visuals display data in a tabular, hierarchical structure, often with rows and columns to summarize or drill down into complex datasets. They are useful for detailed comparisons but do not provide a visual indicator of progress toward a specific target in a single glance.

Card visuals present individual values in a clean format, highlighting metrics like totals or averages. While cards can display a value, they do not inherently show how that value compares to a target, lacking the range or indicator functionality that a gauge provides. Since the question emphasizes comparing performance against a target, the gauge visual is the most appropriate choice.

Question 129: 

Which Power Apps component is used to input and edit records from a data source?

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

Answer:  A) Form

Explanation:

Forms in Power Apps are specialized components designed to enable users to input new records or modify existing records directly within a connected data source. They serve as the primary interface for controlled data entry, providing fields that are mapped to specific columns in a database, SharePoint list, or Dataverse table. Each field in a form corresponds to a data attribute, and forms can include validation rules to ensure that the data entered meets defined requirements. This helps prevent errors, enforces data integrity, and ensures that all necessary information is collected before submission. Forms also support customization, allowing developers to define the layout, field order, and user experience to match business needs, making them highly versatile for applications ranging from simple data entry to complex enterprise solutions.

In contrast, galleries in Power Apps are used primarily for displaying multiple records in a visual, scrollable format. Galleries allow users to browse through lists of items, select specific records, or apply filters to view subsets of data. While galleries are highly effective for presenting and navigating data, they do not provide built-in mechanisms for editing or entering new information. A gallery might be paired with a form, where selecting an item in the gallery populates the form for editing, but by itself, a gallery is a display-only control. Its strength lies in visual navigation and summarization rather than input.

Labels are simple display controls that show static or dynamic text on the screen. They can present information such as instructions, calculated values, or status messages to the user. However, labels do not have the capability to accept user input or interact with a data source. They are purely informational and cannot be used for entering or modifying records, which limits their usefulness in scenarios where data collection is required.

Buttons in Power Apps act as interactive elements that trigger actions. For example, a button can submit a form, execute a flow in Power Automate, or navigate between screens. While essential for enabling user interactions and workflow execution, buttons do not store or edit data themselves. They function as a mechanism to initiate actions, rather than as a tool for direct data manipulation.

Considering the need to input and edit records from a data source, forms are the only component purpose-built to meet this requirement. They combine data binding, field-level validation, and editing capabilities, making them the correct choice for managing and updating data efficiently within Power Apps.

Question 130: 

Which Power Automate component ensures sensitive data like passwords is hidden in flow history?

A) Secure inputs and outputs
B) Variables
C) Scope
D) Apply to each

Answer:  A) Secure inputs and outputs

Explanation:

Secure inputs and outputs is a key feature in Power Automate that is specifically designed to protect sensitive information during the execution of a flow. When this feature is enabled for an action, any sensitive data such as passwords, API keys, personal identifiers, or other confidential information is masked in the flow run history. This ensures that even if someone has access to the flow’s execution logs, they cannot see the actual values of secured inputs or outputs. This capability is essential for maintaining compliance with data privacy regulations, ensuring organizational security policies are met, and reducing the risk of exposing sensitive data to unauthorized users. By using secure inputs and outputs, organizations can confidently automate workflows that handle confidential information without compromising security.

Variables, on the other hand, are commonly used in Power Automate to store and manage data temporarily during a flow’s execution. They allow developers to keep track of values, manipulate data, or pass information between actions within a flow. However, variables do not inherently secure the data they store. By default, the contents of variables are visible in the flow run history, which means that anyone reviewing the logs could potentially see sensitive information. To secure data in variables, additional measures like secure inputs or connecting to secure data sources would be needed. Variables alone do not provide the masking functionality that secure inputs and outputs offer.

Scope is a component used to group multiple actions into a single logical block. Scopes are useful for organizing flows, simplifying error handling, and applying conditions collectively to a group of actions. While scopes improve the structure and readability of a flow, they do not provide any data protection by themselves. Actions inside a scope will still display their input and output values in the run history unless additional security features are applied. Scopes are about organization and flow logic, not data privacy.

Apply to each is another Power Automate action used to iterate through a collection of items, performing specified actions for each element in the collection. It is highly effective for processing lists, arrays, or tables of data, but it does not automatically secure the inputs or outputs of the actions it executes. Even when looping through sensitive data, the information could be exposed in the flow run history unless secure inputs and outputs are applied.

Because the question specifically asks about hiding sensitive information in the flow history, secure inputs and outputs is the correct option. It directly addresses data privacy and ensures that confidential information is not visible during or after flow execution, providing a robust solution for security-conscious automation.

Question 131: 

Which Dataverse feature maintains the relationship between tables and ensures referential integrity?

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

Answer:  A) Lookup column

Explanation:

A lookup column in Dataverse is specifically designed to create a connection between two tables. It allows a record in one table to reference a record in another, establishing a parent-child relationship that ensures referential integrity. This means that any data entered in the child table must correspond to an existing record in the parent table, preventing orphaned or invalid data. Lookup columns are essential in scenarios where relational data must be maintained consistently across multiple tables, such as linking contacts to accounts or orders to customers. They not only maintain logical connections but also enable features like cascading updates or deletes, further reinforcing data integrity.

Choice columns, by contrast, are used to define a set of predefined options from which users can select. While they are useful for ensuring standardized inputs, such as status values or priority levels, they do not create any relational link between different tables. They are standalone fields that provide controlled vocabulary but do not enforce relationships or dependencies between data entities. Therefore, while choice columns support data consistency in terms of allowed values, they are not concerned with table relationships.

Text columns are simple fields that store alphanumeric characters. They are versatile for storing names, descriptions, or notes but do not inherently connect data across tables. They are useful for capturing raw information but lack any mechanism for enforcing referential integrity or maintaining structured relationships. Text columns are independent and do not influence relational data modeling in Dataverse.

Currency columns store numeric values related to financial amounts, including currency type and precision. They are specialized for financial data management and support calculations, rollups, and aggregations. While essential for monetary data, they do not establish links between tables or manage dependencies between related records. Currency columns are purely for numerical storage and computation and are unrelated to maintaining table relationships.

The question is focused on maintaining relationships and referential integrity, which is the primary purpose of lookup columns. The other options serve specific data storage or formatting functions but do not enforce relational links. Lookup columns are therefore the correct choice because they allow one table to reference another while ensuring that the referenced data exists and remains consistent across the system.

Question 132: 

Which Power BI feature allows users to drill down into detailed data by clicking a visual?

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

Answer:  A) Drill-through

Explanation:

Drill-through in Power BI is a feature that allows users to navigate from a high-level summary visual to a detailed report page filtered specifically for the selected value. For example, clicking on a region in a sales summary chart can open a new page showing all individual transactions for that region. This functionality is crucial for interactive data exploration, providing a focused view without cluttering the main report with excessive details. Drill-through is user-driven, making it an intuitive method for accessing deeper insights within reports.

Bookmarks, in contrast, are a way to capture the state of a report at a particular moment, including filters, visual configurations, and slicer selections. They are useful for creating storytelling in reports or toggling between different views, but they do not allow interactive navigation to a detailed page filtered by a clicked value. Bookmarks are static snapshots, not dynamic exploration tools.

Tooltips display additional information when a user hovers over a visual element. They enhance the user experience by providing context-sensitive details, such as showing the exact sales number or percentage for a specific point on a chart. However, tooltips are limited to on-hover interactions and do not allow navigation to another page or detailed dataset.

Slicers are interactive filtering tools that let users apply filter criteria across visuals in a report. While they help in dynamically slicing data and adjusting visualizations, they do not allow users to navigate to a detailed page. Slicers affect the context of visuals but are not a drill-through mechanism.

Drill-through is the only feature designed to enable navigation to a dedicated detailed page based on a specific selection in a visual. While bookmarks, tooltips, and slicers enhance interactivity or provide additional information, they do not facilitate context-specific navigation to another page. This makes drill-through the correct option for focused data exploration.

Question 133: 

Which Power Apps component stores temporary data that can be accessed across multiple screens?

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

Answer:  A) Collection

Explanation:

Collections in Power Apps are data structures that store temporary data in memory for the duration of an app session. They can hold multiple records or items and are accessible from any screen in the app, making them highly useful for passing data between different components or screens without storing it permanently in a database. Collections can be created, updated, and cleared dynamically during app runtime, which provides flexibility in handling user input, calculated values, or filtered datasets temporarily.

Labels are controls used to display static or dynamic text on the screen. While they can show data from collections, variables, or inputs, labels themselves do not store data. They are purely presentation elements and cannot retain information across screens or sessions.

Buttons are interactive controls that trigger actions or events when clicked. They can perform operations such as navigating between screens, updating collections, or submitting forms. However, buttons do not store data themselves; they are action initiators rather than storage mechanisms.

Timers are components that execute actions based on elapsed time. They can trigger events after a delay or at regular intervals but do not retain data beyond the immediate execution context. Timers are useful for automation and scheduling within the app but are unrelated to data persistence or cross-screen access.

Collections are the correct choice because they are the only component capable of holding data temporarily in memory while allowing access from multiple screens. Labels, buttons, and timers serve different functions related to display or event execution, making them unsuitable for storing shared session data.

Question 134: 

Which Power Automate feature allows multiple actions to run at the same time?

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

Answer:  A) Parallel branches

Explanation:

Parallel branches in Power Automate allow multiple actions to execute simultaneously, independently of each other. This feature is particularly useful for improving efficiency when multiple operations do not depend on one another. For example, you could send an email while simultaneously updating a database record, reducing total flow execution time. Parallel branches are essential in workflows where concurrency is necessary to optimize performance or meet timing requirements.

Scope is a grouping tool that allows multiple actions to be bundled together. Actions within a scope run sequentially, not simultaneously. Scope helps organize flows and manage error handling more effectively but does not introduce concurrency.

Condition evaluates a logical expression and executes actions based on whether the result is true or false. It creates branching logic rather than concurrent execution. While condition-based branching controls the workflow path, it does not execute multiple actions at the same time.

Apply to each is a looping construct that iterates through a collection and performs actions for each item sequentially. Even though multiple actions can exist inside the loop, they execute one after another, not concurrently. Apply to each is focused on iteration rather than simultaneous execution.

Parallel branches are correct because they are explicitly designed to allow multiple actions to run at the same time. Scope, condition, and apply to each manage sequences, branching, or iteration but do not facilitate simultaneous execution.

Question 135: 

Which Power BI feature performs dynamic calculations that respond to filters and slicers?

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

Answer:  A) Measures

Explanation:

Measures in Power BI are calculations that are evaluated in the context of the current filter or slicer settings. They are used to compute aggregations such as sums, averages, or percentages dynamically based on the user’s interactions with visuals. Because measures are context-aware, they automatically adjust as filters, slicers, or other visuals change, providing a responsive and interactive analytical experience. Measures are written using DAX (Data Analysis Expressions) to define the calculation logic.

Relationships define how tables are connected in a data model, allowing data to be joined and aggregated correctly across different tables. While relationships are fundamental to ensuring accurate analysis, they do not perform calculations themselves. They enable measures and visuals to operate correctly but are not responsible for dynamic computations.

Dataflows are used to extract, transform, and load data into Power BI datasets. They are useful for preparing and shaping data, ensuring it is clean and structured before analysis. However, dataflows are not calculation mechanisms within reports and do not respond dynamically to slicers or filters at the visual level.

Bookmarks save the current state of a report, including filters, slicers, and visual configurations. They are helpful for storytelling, navigation, or toggling views, but they do not calculate or adjust metrics dynamically. Bookmarks capture static report states rather than performing responsive computations.

Measures are the correct choice because they are designed to compute dynamic calculations that automatically respond to the current filter context. Relationships, dataflows, and bookmarks provide structural, preparatory, or navigational functionality but do not directly perform dynamic calculations in response to user interactions.

Question 136: 

Which Power Apps control allows users to pick one value from a predefined list?

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

Answer:  A) Dropdown

Explanation:

Dropdown controls in Power Apps are specifically designed to allow users to select a single value from a predefined set of options. These options are typically displayed in a compact, collapsible menu, which expands when the user clicks on it, providing a clean and organized way to make a selection. This control is particularly useful in forms and data-entry applications because it ensures that the user can only select valid options, thereby maintaining data integrity. Dropdowns can be populated with static values, dynamic data from a collection, or external data sources, making them highly versatile in a variety of application scenarios.

A Gallery, on the other hand, is primarily a visual display control used to show multiple records or items from a collection or data source. While a gallery allows selection of items, its primary purpose is to display multiple pieces of information simultaneously rather than restricting the user to a single, predefined choice. Galleries are better suited for browsing, filtering, or selecting records rather than making a single-value input.

A Label control is used simply to display text on a screen. Labels are static or dynamic textual elements that do not provide any interactive selection capability. They are purely informative and cannot accept user input or store selections. Labels are commonly used to show titles, instructions, or computed results in the app interface, but they are not suitable for choosing values from a list.

Timers in Power Apps are controls that trigger actions or events after a specific interval. They are designed for automating time-based functions, such as refreshing data, changing screens, or executing workflows after a countdown. While timers play an important role in app logic, they do not provide a mechanism for users to select data or make choices.

The correct answer is Dropdown because it directly fulfills the requirement of enabling a user to pick a single value from a predefined set. Unlike galleries, labels, or timers, dropdowns are interactive selection controls designed for user input and controlled data entry. They streamline input, reduce errors, and improve app usability, making them the best choice when a single selection from a list is required.

Question 137: 

Which Power Automate feature pauses a flow until a specified condition is true?

A) Do until
B) Scope
C) Apply to each
D) Parallel branch

Answer:  A) Do until

Explanation:

The Do until action in Power Automate is a looping control that repeatedly checks a specified condition until it evaluates as true. This means the flow pauses and continues to execute the actions within the loop until the defined condition is met. This is especially useful in scenarios where the flow needs to wait for an external process or a change in data before proceeding. By using Do until, users can avoid running actions prematurely and ensure that subsequent steps occur only when conditions are satisfied.

Scope is a grouping control that allows multiple actions to be executed together as a single unit. It is useful for organizing flows, applying error handling, or managing complex logic, but it does not have any inherent looping or conditional waiting capabilities. Actions in a scope run sequentially without pausing for a condition, which differentiates it from the functionality of Do until.

Apply to each is a loop designed to iterate through a collection or array of items. While it repeats actions for each element in the collection, it does not wait for a condition to become true; instead, it simply executes the actions for each item sequentially. This makes Apply to each ideal for processing multiple records but not suitable for conditional waiting scenarios.

Parallel branch enables multiple sets of actions to run simultaneously. It is useful for performing independent tasks concurrently to reduce overall flow execution time. However, parallel branches do not evaluate a condition to determine when to continue; they simply run in parallel, making them unsuitable for scenarios where a flow must pause until a condition is met.

Do until is the correct choice because it specifically allows a flow to wait and repeat actions until the specified condition evaluates as true. This control ensures proper synchronization with external processes or system states, providing conditional flow management that Scope, Apply to each, and Parallel branch cannot offer.

Question 138: 

Which Power BI feature lets users create reusable ETL logic for multiple datasets?

A) Dataflows
B) Datasets
C) Queries
D) Slicers

Answer:  A) Dataflows

Explanation:

Dataflows in Power BI provide a centralized and reusable mechanism for extract, transform, and load (ETL) operations. Users can define data transformation steps once and reuse them across multiple datasets and reports. This feature supports consistency, reduces duplication of work, and ensures that multiple reports can leverage the same cleaned and structured data. Dataflows are stored in the Power BI service and can pull data from a variety of sources, transforming it into a suitable format for reporting and analysis.

Datasets in Power BI are collections of data that serve as the foundation for creating reports and visualizations. While datasets store data and allow analytical operations, they do not inherently provide reusable ETL logic across multiple datasets. Each dataset is independent and typically requires separate transformation steps if not using a dataflow.

Queries are part of the Power Query editor and allow data shaping and transformation for a specific dataset or report. Queries provide the flexibility to filter, clean, and transform data, but they are usually scoped to a single dataset rather than being designed for reuse across multiple datasets.

Slicers are interactive visual filters that allow users to dynamically filter data in reports. They do not perform data transformation or ETL operations. Instead, slicers are purely for controlling the display of data based on user interaction within the report.

The correct answer is Dataflows because they enable reusable ETL logic, allowing transformations to be applied consistently across multiple datasets. Datasets, queries, and slicers do not provide this level of centralized, reusable data preparation.

Question 139: 

Which Power Apps feature automatically generates a three-screen app from a data source like SharePoint?

A) Generate app
B) Canvas app from blank
C) Model-driven app
D) Portal app

Answer:  A) Generate app

Explanation:

The Generate app feature in Power Apps automatically builds a three-screen app based on the structure of a connected data source, such as a SharePoint list. This process creates a default layout with a browse screen, details screen, and edit/create screen. The generated app provides a working baseline that can be customized further, saving time and effort in app development, especially for users who want to quickly visualize and interact with their data.

Canvas apps from blank provide complete freedom to design an app from scratch. While this allows full customization and control over the UI and logic, it does not automatically generate screens or layout from a data source. Users need to manually add controls, screens, and logic to build the app.

Model-driven apps are based on Dataverse tables and their relationships. These apps are highly structured and focus on business processes and data models rather than rapid app generation. While powerful for complex scenarios, model-driven apps do not provide automatic three-screen generation from arbitrary data sources like SharePoint.

Portal apps allow creation of external-facing websites that can be accessed by users outside the organization. Portals are intended for customer or partner interactions, not internal app generation, and are unrelated to the task of quickly generating a standard three-screen app.

The correct choice is Generate app because it specifically targets quick app creation from a data source, providing a functional template that can be immediately used and modified. Canvas from blank, model-driven apps, and portal apps do not offer this automated generation feature.

Question 140: 

Which AI Builder model classifies text into predefined categories?

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

Answer:  A) Category classification

Explanation:

Category classification in AI Builder is designed to analyze textual input and assign it to predefined categories. This is particularly useful for sorting emails, survey responses, customer feedback, or support tickets based on content type or intent. By using AI to automatically classify text, organizations can streamline processes, route items appropriately, and make decisions faster. The model is trained using labeled examples and can improve accuracy over time.

Object detection models, in contrast, are designed to identify and locate physical objects within images. These models output coordinates and labels for detected objects, making them suitable for inventory tracking, quality inspection, or image-based automation. Object detection does not process textual data or classify text into categories.

Form processing models extract structured data from documents such as invoices, receipts, or forms. These models identify fields, key-value pairs, and tables, converting unstructured document content into usable data. While valuable for data extraction, form processing does not classify text into categories.

Prediction models are used to forecast outcomes based on historical data. They can predict numerical values, trends, or probability of events occurring. Predictions are analytical rather than categorical in nature and are not designed to classify text into predefined labels.

The correct answer is Category classification because it directly addresses the need to categorize textual data. Object detection, form processing, and prediction serve different purposes and do not perform text classification into predefined categories.