DRAG DROP - A company uses Microsoft Excel workbooks to store consolidated sales data. Workbooks are stored on OneDrive for Business. Match each Power BI feature to its requirement. To answer, drag the appropriate features from the column on the left to its requirement on the right. E...

Author: Vikram · Last updated Mar 21, 2026

DRAG DROP - A company plans to display support call metrics on a screen that is visible to all call center staff. You need to recommend solutions to meet the company's requirements. What should you recommend? To answer, drag the appropriate components to the correct requirements. Each component may be used once, more than once, or not at a...

Author: Oliver · Last updated Mar 21, 2026

You create a Power BI dashboard that displays Common Data Model data. You need to share the Power BI dashboard with coworkers and allow the coworkers to collaborate. What are two possible ways to achieve the goal? Each...

To allow coworkers to collaborate on a Power BI dashboard that displays Common Data Model (CDM) data, the most effective options would focus on the direct sharing and collaboration capabilities within Power BI. Let's break down each option: A) Create a Power BI workspace and grant coworkers permissions. - Why this is correct: A Power BI workspace is a shared environment where team members can collaborate on Power BI reports and dashboards. By granting coworkers appropriate permissions (e.g., Member or Contributor roles), you can give them access to the dashboard, allowing them to view, edit, and collaborate. This is a native Power BI solution that is designed specifically for collaboration. - Scenario: This option is best used when you want coworkers to have real-time access to the dashboard and to collaborate on modifying reports and visualizations. It is the most straightforward approach for teams working together in Power BI. B) Publish the dashboard as an app to your coworkers. - Why this is correct: Power BI apps are packages that include dashboards, reports, and datasets. By publishing the dashboard as an app, you can share it with specific coworkers or groups. This is a great solution for collaboration because it allows coworkers to interact with the dashboard, and the app can be updated with new versions as needed. - Scenario: This option is useful when you want to distribute the dashboard to a wider audience or to a group of coworkers. It’s an ideal option if the intention is to en...

Author: Ravi Patel · Last updated Mar 21, 2026

You are using Dynamics 365 Sales. You need to create a Power BI report that includes customer office locations. The City and State columns must be...

To create a Power BI report that combines the City and State columns into a single column (showing customer office locations), we need to use the right method for transforming the data before or during the report creation process. Let's analyze each option: A) Use Power Query Editor to merge columns. - Why this is correct: Power Query Editor allows you to transform and clean your data within Power BI. By using Power Query, you can easily merge the City and State columns into one combined column. This is a standard approach for combining fields, and Power Query provides the flexibility to format the data as needed (e.g., inserting a comma between City and State). This option allows the transformation to occur directly in Power BI, so the merged column will be available immediately in the report. - Scenario: This method is ideal for cases where you need to modify the structure of your data (e.g., combining columns) before loading it into the Power BI model for reporting. It’s also easy to update if data changes or if the transformation needs to be applied regularly. B) Import the data. - Why this is incorrect: Simply importing the data does not perform any transformation or manipulation of the data. This will bring in the City and State columns as they are, without combining them. While importing is necessary to get data into Power BI, it d...

Author: Lucas Carter · Last updated Mar 21, 2026

DRAG DROP - A company needs to create a series of mobile applications to empower their field engineers to accomplish several tasks with varying degrees of complexity. Match each app type to its definition. To answer, drag the appropriate app type from the column on the left to its definition on the rig...

Author: Joseph · Last updated Mar 21, 2026

HOTSPOT - A user is starting to learn about Power Apps. Which objects should you use? To answer, select the appropriate options in the answer are...

Author: Ethan · Last updated Mar 21, 2026

What is a benefit of deploying Microsoft 365 and Dynamics 365 apps in the same tenant?

When deploying Microsoft 365 and Dynamics 365 apps in the same tenant, the goal is to simplify integration, improve collaboration, and streamline the user experience. Let's evaluate the benefits of each option: A) You do not need to manually back up data. - Why this is incorrect: While Microsoft 365 and Dynamics 365 do provide cloud-based services with automatic backups, not needing to manually back up data isn't a direct benefit of deploying both in the same tenant. Backup policies are generally managed by Microsoft regardless of tenant configuration. However, manual backup still exists for certain scenarios, and this is not a specific advantage of co-deploying these apps in the same tenant. - Scenario: This may be true for cloud services in general but isn't specifically tied to deploying the apps in the same tenant. B) Both will use the same time zone. - Why this is incorrect: The time zone settings are generally controlled at the user or organizational level, and both Microsoft 365 and Dynamics 365 can work in different time zones if necessary. Even if they are in the same tenant, it's not guaranteed that they will automatically synchronize to the same time zone. You can set different time zones for different users or apps, so this is not a major benefit of deploying them together in the same tenant. - Scenario: Time zone synchronization is something that can be controlled on a per-user or per-app basis, regardless of the tenant. C) You can use Power BI to display data that comes from both environments. - Why this is correct: A significant benefit of deploying Microsoft 365 and Dy...

Author: Vivaan · Last updated Mar 21, 2026

A company runs a call center to handle customer support inquiries. The company tracks metrics including the number of incoming calls and call resolution rates. The company wants to display the metrics on a shared screen that is visible to all call center staff. Y...

To recommend a Power Platform feature for displaying the call center metrics on a shared screen, we need to consider factors such as real-time data visualization, ease of integration, and the ability to display dynamic metrics that can be easily understood by call center staff. Let’s evaluate each option: A) AI Builder - Purpose: AI Builder is primarily designed to help users build artificial intelligence models and capabilities (like prediction, object detection, etc.) without requiring advanced coding skills. - Rejection Reason: While AI Builder could help predict call volumes or customer sentiments based on historical data, it doesn't provide real-time data visualization or dashboarding capabilities. The purpose here is to display metrics visually in real-time, and AI Builder isn't designed for this purpose. - Scenario: Can be useful for predictive analytics or machine learning tasks, but not for real-time metric visualization. B) Power Automate - Purpose: Power Automate is used for automating workflows between applications and services. It’s great for automating tasks like sending notifications, generating reports, or moving data between systems. - Rejection Reason: Power Automate can automate data collection or notifications about call metrics, but it doesn’t offer a visual display of data. It's more about automating tasks rather than presenting information in a graphical form. - Scenario: Best used for automating alerts or report generation, but not for live dashboards. C) Power Apps - Purpose: Power Apps allows users to create custom applications with forms, data connections, and cus...

Author: Ethan Smith · Last updated Mar 21, 2026

HOTSPOT - You are a regional sales manager for a large internet retailer. You create a series of Power BI reports and dashboards to help sales associates be more productive and increase sales. Sales are not increasing as expected. You need to determine if the new reports are being used and send emails to sales associates to provide guidance on how to use the reports and das...

Author: Akash · Last updated Mar 21, 2026

You are creating Power BI reports. You need to choose which filters you can use for reports. Which three types of filters can you use? Each correct answer presents...

To answer this question accurately, let’s clarify how filters work in Power BI and which types are valid and commonly used when creating reports. --- Goal: You are creating Power BI reports and need to choose the types of filters you can use. Power BI supports multiple filtering mechanisms to refine the data shown in reports. These filters help control what data is displayed at different levels, such as a page, visual, or report level. --- ✅ A) Drill-down - Correct (with context). - While not traditionally called a "filter," drill-down in visuals functions as an interactive filtering mechanism. - Users can click on a visual element (like a bar in a chart) to filter and display more detailed data. - This is useful for exploring hierarchical data, such as year → quarter → month. --- ✅ B) Automatic - Correct. - Power BI applies automatic filters when slicers or visuals interact with each other. - Example: Clicking a category in one visual automatically filters related data in other visuals. - These filters are automatically generated based on relationships and user interactions. --- ❌ C) Data...

Author: Ming88 · Last updated Mar 21, 2026

HOTSPOT - You are building Power BI visualizations for a team. For each of the following statements, select Yes if the statement is true. Otherwise, sele...

Author: Sofia · Last updated Mar 21, 2026

A manufacturing company uses Internet of Things (IoT) devices to monitor the temperature in different parts of their warehouse. You need to view near real-time information from...

When a manufacturing company wants to view near real-time information from IoT devices in Power BI Service dashboards, it’s important to choose the right data integration and visualization tools. Let's go through the options to determine the best one: A) Scheduled refresh dataset - Purpose: Scheduled refresh allows data to be updated at regular intervals, but the refresh is typically done on a set schedule (e.g., every 1 hour, daily, etc.). - Rejection Reason: Since IoT data is often continuously generated and needs to be displayed in near real-time, a scheduled refresh would not be ideal. It introduces a delay in data updates, which means you wouldn’t get immediate insights as the refresh interval could be hours apart, which doesn't suit the requirement of real-time or near real-time monitoring. - Scenario: Useful when working with data that does not require frequent updates and is more static in nature. B) Streaming dataset - Purpose: Streaming datasets are designed for handling real-time data, where data is continuously fed into Power BI from external sources (like IoT devices, social media feeds, etc.). These datasets support real-time data flows and allow dashboards to update as new data arrives. - Selection Reason: A streaming dataset is the best option for this scenario because it allows data from IoT devices (which generate real-time data, such as temperature readings) to be displayed in near real-time on Power BI Service dashboards. This is perfect for monitoring continuously changing data like temperature, where instant feedback is needed for operational monitoring. - Scenario: Ideal for IoT and other real-time data applications, such as monitoring equipment, sensor data, and live events. C) Content Pack dataset - Purpose: Content packs are collections of pre-built reports, dashboards, and datasets that users can import into their Power BI workspace. They are often used to quickly integrate with popular services (like Google Analytics, Dynamics ...

Author: Ishaan · Last updated Mar 21, 2026

HOTSPOT - You have a Power BI report with a page named RevReceived. The page shows gross revenue received by your company. You want to create an almost identical page that shows net revenue instead of gross revenue....

Author: Daniel · Last updated Mar 21, 2026

DRAG DROP - A company plans to implement Power BI to analyze retail operations data. You need to recommend solutions for the company. Which Power BI components should the company use? To answer, drag the appropriate Power BI components to the correct requirements. Each Power BI component may be used once, more than once, or not at all...

Author: Elizabeth · Last updated Mar 21, 2026

HOTSPOT - You are creating Power BI visualizations. You need to display the visuals where a user can perform each function. Which solution should you use? To answer, select the appropriate opt...

Author: Olivia Johnson · Last updated Mar 21, 2026

A company is using Power BI. The company wants to see which data connectors are available for building dashboards. You need to evaluate the available co...

To determine the correct answer, let’s analyze what’s being asked: --- Scenario: - The company is using Power BI - The goal is to evaluate which data connectors are available - This typically involves viewing all possible data sources that can be used to build dashboards --- What Are Power BI Connectors? - Data connectors are interfaces that allow Power BI to connect to external data sources (e.g., Excel, SQL Server, Salesforce, SharePoint, etc.) - The place where you choose and view all available connectors is during the data import or connection process --- ✅ E) Power BI Desktop - Correct. - Power BI Desktop is where reports and dashboards are created, and it provides the full list of available connectors under Home > Get Data. - Here you can browse and search all connectors: file sources, databases, Azure services, online services, and more. - Ideal for evaluating and trying out data sources before building a report. - This is the most comprehensive and up-to-date interface for reviewing connector availability. --- ❌ A) Power BI Workspace - Incorrect. - Workspaces are used to collaborate,...

Author: Maya · Last updated Mar 21, 2026

HOTSPOT - A company is using Power BI. The company plans to analyze a large number of datasets. The company is concerned that this may negatively impact performance. You need to identify and implement features to mitigate any performance issues. Which features should you use? T...

Author: Olivia Johnson · Last updated Mar 21, 2026

You create a set of dashboards and reports for a project team that combines data from different sources in Power BI. Some of the data is considered sensitive. You need to distrib...

To determine the best way to distribute dashboards and reports securely in Power BI, we need to assess each option with respect to the following key factors: 1. Security/Access Control - Sensitive Data Handling: You need a solution that ensures only authorized team members can access sensitive data in the reports. 2. Collaboration and Distribution - Ease of Sharing: The solution should allow for easy distribution and collaboration within the team. 3. Compliance with Organizational Policies - Governance: There should be clear control over who can access, modify, or distribute reports. Let's evaluate the options: A) Custom Data Connector - Explanation: Custom data connectors are used to connect Power BI to various data sources that are not natively supported. They allow you to pull data into Power BI, but they are not directly related to the sharing or secure distribution of reports. - Why Rejected: - It does not provide a mechanism for sharing or securing reports. It's more of a data integration tool. - Use Case: A custom data connector can be useful if you need to pull data from a non-standard data source (e.g., a proprietary database) into Power BI, but it won't help with report distribution or security. B) Published App - Explanation: A Power BI app is a way to bundle dashboards and reports together and distribute them to users in an organized manner. You can control who has access to the app and what level of access they have (view or edit). It also provides a secure, structured way to distribute reports to large teams or external users. - Why Selected: - Published apps offer a straightforward way to distribute Power BI reports and dashboards securely. You can define who can access the app and apply role-based security. Sensitive data can be managed with row-level security, which ensures that users only see data they are authorized to view. - Apps can also be easily updated, and users receive notifications about new versions. - Use Case:...

Author: FrostFalcon88 · Last updated Mar 21, 2026

You are creating visuals in Power BI. You create area charts, pie charts, and donut charts that use your company's data. You need to display the charts to others at the company. Which two objects can you add the charts to? E...

When displaying charts and visuals to others within your company in Power BI, there are specific tools and methods for sharing and presenting them. Let's evaluate each option based on the need to display charts created in Power BI. Key factors to consider: 1. Sharing & Collaboration – How the charts will be shared with others. 2. Creation & Editing – Where the charts can be created or edited before sharing. 3. Interactivity & Access – How users interact with the charts when viewing them. Let's evaluate the options: A) Power BI Service - Explanation: The Power BI Service is the cloud-based platform where reports, dashboards, and datasets are published and shared with other users. Once a report is created in Power BI Desktop, it can be published to the Power BI Service, where it can be shared with others in the company. - Why Rejected (in this case): - Power BI Service is more of a platform for viewing, sharing, and collaborating on reports and dashboards rather than a direct location for creating charts. - Use Case: Power BI Service is suitable for sharing, viewing, and interacting with reports and dashboards. However, you first need to create the charts in Power BI Desktop and publish them to the Service to share them effectively. B) Power BI Reports - Explanation: A Power BI report is a collection of visuals (including charts, tables, maps, etc.) that are created and displayed in the Power BI environment. Once you create visuals (area charts, pie charts, donut charts) in Power BI Desktop, you publish the report to the Power BI Service. - Why Selected: - A Power BI report is the right place to create and display charts because it's the object where visuals are organized and presented in an interactive and user-friendly way. Users can view and interact with reports in Power BI Service after they have been published. - Use Case: This option is ideal for when you want to display multiple charts and provide detailed, interac...

Author: Emma Brown · Last updated Mar 21, 2026

DRAG DROP - A company is implementing Power BI to track sales. Each of the company's regions has specific quarterly and yearly sales goals. You need to build a Power BI dashboard for various reporting requirements. Which chart types should you use? To answer, drag the appropriate chart types to the correct requirements. Each chart type may be used once, more than once...

Author: Leo · Last updated Mar 21, 2026

DRAG DROP - You create a Power BI dashboard. Match each option to its function. To answer, drag the appropriate option from the column on the left to its function on the right. Each option may be used once, mor...

Author: Emma · Last updated Mar 21, 2026

You are using Dynamics 365 Sales. You need to pull data into a Power BI report for your team. The City and State columns must be combined to form one column on the report. Which function would you use? Each cor...

To pull data into a Power BI report from Dynamics 365 Sales and combine the City and State columns into one, you need to consider how to manipulate and transform the data in Power BI. Let's go over each option to determine which would be the most appropriate for this task. Key Factors: - Data Transformation: Combining columns requires manipulating or transforming the data. - Ease of Use: The solution should allow you to perform this transformation without requiring complex steps. - Integration with Power BI: The method should seamlessly integrate with Power BI for reporting purposes. Let's evaluate the options: A) Use Power Query to merge columns - Explanation: Power Query is the data transformation tool in Power BI. It allows you to load data from various sources (like Dynamics 365 Sales), and apply transformations such as merging or concatenating columns. - Why Selected: - Power Query provides a simple, built-in interface to perform this kind of transformation. You can easily combine the City and State columns into one new column using Power Query's "Merge Columns" functionality. After transforming the data in Power Query, you can load it into the Power BI report. - Use Case: Power Query is ideal for this type of task, as it allows you to transform the data before loading it into Power BI, giving you flexibility in shaping the data as needed. B) Import the data - Explanation: Importing the data refers to bringing data from an external source (such as Dynamics 365 Sales) into Power BI, typically without any data transformations or column merging applied at the time of import. - Why Rejected: - Importing the data alone will bring in the City and State columns separately but will not perform any data manipulation, such as combining those columns. Data transformation needs to happen after the import. - Use Case: Importi...

Author: Rahul · Last updated Mar 21, 2026

A carpet cleaning company uses Dynamics 365 Sales. The process for entering customer information during onsite sales calls is very complicated. The company wants a simplified screen that allows salespeople to capture the customer name, phone number, and other information while speaking t...

To address the needs of the carpet cleaning company, the goal is to simplify the data entry process for salespeople during onsite sales calls and make it easy for them to capture customer information on various mobile devices. Let’s review each of the options provided: A) Microsoft Dataverse - Explanation: Microsoft Dataverse is a cloud-based data storage platform for securely storing and managing data used by business applications. While Dataverse can be used to store customer information and could be a part of the underlying infrastructure, it doesn't provide a simplified interface for data entry or enhance user experience directly. - Rejection: It provides a backend data layer but not a user-friendly interface for salespeople. It isn't a solution for simplifying data entry directly. - Scenario Use: Useful as a backend storage system when combined with other tools. B) Power Automate - Explanation: Power Automate helps automate workflows and business processes. It can be used to trigger actions based on conditions, such as creating customer records when a form is filled or sending notifications. However, it doesn't directly provide a user interface for salespeople to input data. - Rejection: Power Automate excels at automating processes but doesn’t directly create or simplify data entry screens on mobile devices. - Scenario Use: It would be useful for automating actions after data entry (like sending alerts or creating records) but not for the actual data entry process. C) AI Builder - Explanation: AI Builder helps add AI capabilities to apps by leveraging machine learning. It’s good for features like form processing, predictions, or text recognition. However, while AI Builder could potentially streamline capturing data from documents or handwritten forms, it doesn’t address simplifying the user interface for salespeople entering data on mobile devices. - Rejecti...

Author: Chloe · Last updated Mar 21, 2026

A company using Power Platform is implementing Power BI. The company plans to connect to several data sources and create reports and dashboards. You need to identify the data sources they can connect to. Which two data sources should you ...

To answer this question, let's analyze what Power BI supports as data sources, especially in the context of a company using Power Platform to create reports and dashboards. --- Scenario: - A company is using Power BI - They want to connect to several data sources to create reports and dashboards - You need to identify valid data sources that Power BI can connect to directly and reliably --- ✅ A) Microsoft Excel - Correct. - Excel is one of the most common and fully supported data sources in Power BI. - You can import data from .xlsx, .xls, and .xlsm files stored locally or in the cloud (like OneDrive or SharePoint). - Power BI allows you to create dashboards directly from Excel tables and pivot tables. - Very useful for data that is already formatted and structured, such as sales records, KPIs, or budgets. --- ✅ B) Microsoft Dataverse - Correct. - Dataverse (formerly Common Data Service) is the underlying data platform for Power Platform apps including Power Apps, Power Automate, and D...

Author: Maya · Last updated Mar 21, 2026

You create a multi-page Power BI report for an organization. You must enable salespeople in the organization to use the report to view data relevant to their sales regio...

To address the requirement of enabling salespeople to view data relevant only to their sales region in a Power BI report, row-level security is the appropriate solution. Let’s review each of the options and explain why row-level security is the best choice. A) Sensitivity Labels - Explanation: Sensitivity labels are used to classify and protect data based on its sensitivity. They can apply encryption, restrict access, and control sharing of information within an organization. While sensitivity labels are important for data governance, they do not directly control which data users can view based on conditions like sales regions. - Rejection: Sensitivity labels are designed to protect data rather than manage visibility of data for specific users. They are not a solution for restricting data access at a granular level like sales regions in Power BI reports. - Scenario Use: Best for data classification and encryption, not for controlling user access to specific parts of the report. B) Microsoft Azure Active Directory - Explanation: Azure Active Directory (Azure AD) is an identity and access management service that provides authentication and authorization. While Azure AD is crucial for managing user identities and roles across services, it does not provide direct control over which data within a report users can access, such as restricting data to a specific sales region. - Rejection: Azure AD is primarily used for user authentication and role management, but it does not offer functionality for controlling access to specific data within a Power BI report. - Scenario Use: Used for managing user accounts, authentication, and access across services but not for data-level restrictions in reports. C) Microsoft Trust Center - Explanation: The Microsoft Trust Center provides information on Microsoft's security, privacy, and compliance practices. It is used to inform customers about the security features and privacy policies of Microsoft services. However, it is not a tool for managing access or security directly within Power BI reports. - Rejection: The Trust Center is infor...

Author: Daniel · Last updated Mar 21, 2026

HOTSPOT - You are building a Power Apps portal by using the Customer Self-Service template. For each of the following statements, select Yes if the statement is true. Otherw...

Author: SilverBear · Last updated Mar 21, 2026

User1 creates several Power BI dashboards for a company. User1 shares a dashboard with User2 who works for another company. User2 reports that she is able to view the dashboard. User2 forwards the email containing the dashboard sharing link that she received to User3. User3 reports that he receives an error message when he selects the l...

The scenario involves a situation where User1 creates a Power BI dashboard and shares it with User2, who can access it. However, when User2 forwards the dashboard link to User3, User3 reports receiving an error message. Based on this, let’s evaluate the options: A) User3 is running an out-of-date version of Power BI and must upgrade to a newer version. - Explanation: While using an outdated version of Power BI could potentially cause issues with viewing dashboards or reports, this is unlikely to be the issue here. User3 can view dashboards that they have created, which implies that their Power BI client is functional and up-to-date. - Rejection: The problem seems to be related to permissions and sharing, not an outdated version of Power BI. The fact that User3 can view their own dashboards suggests they are using the correct version. B) User2 is signed in to the dashboard and must sign out before User3 can sign in. - Explanation: Power BI doesn’t require users to sign out before another user can access shared content. If User2 forwarded the link to User3, and User3 has the appropriate permissions, User3 should be able to access the dashboard without needing User2 to sign out. - Rejection: This is not the root cause. Power BI allows multiple users to access shared content simultaneously, even if one of the users is already signed in. C) Forwarding the email does not share the dashboard with User3. - Explanation: This is the most likely explanation. When User1 shares a dashboard, they explicitly share i...

Author: William · Last updated Mar 21, 2026

HOTSPOT - A company plans to implement Power BI. Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, sele...

Author: James · Last updated Mar 21, 2026

You are developing reports for a company. You must create visualizations that include the following data: * Invoices due from a third-party enterprise resource planning (ERP) system * Number of calls made to the client from Microsoft Dataverse * Microsoft Excel fi...

To create visualizations that display data from different sources (an ERP system, Microsoft Dataverse, and an Excel file) on a single page, you need to focus on an option that allows for integrating and presenting multiple data sources together in a consolidated view. Let’s evaluate the options: A) Deployment Pipelines - Explanation: Deployment pipelines in Power BI are used to manage the lifecycle of reports and datasets across different environments (development, test, production). While deployment pipelines help with the deployment process, they are not relevant for creating visualizations or integrating data sources into a single page. - Rejection: Deployment pipelines are about managing report deployment and not about creating reports or visualizing data on a page. - Scenario Use: Deployment pipelines are useful in large-scale development and deployment environments, but not for creating visualizations. B) Tables - Explanation: In Power BI, tables are used to display raw data in tabular form. While they can be used to display data, tables are not ideal for creating visualizations (charts, graphs, etc.) that effectively communicate insights. Tables are best for showing detailed data but do not provide a summary or visual representation of the data that’s typically required in reports. - Rejection: Tables would show raw data but wouldn’t offer a comprehensive and visual summary. They do not meet the need for visualizations that can show trends, comparisons, or key insights. - Scenario Use: Tables can be used for displaying detailed data in specific situations, but they are not suitable for presenting a full visualization that includes data from multiple sources. C) Columns - Explanation: Columns in Power BI could refer to individual data columns in datasets or visualizations. If this refers to "columns" as a visual element (e.g., column charts), this could technically wo...

Author: Victoria · Last updated Mar 21, 2026

You are using the Power BI service to view a visual on a report that has been shared with you. You need to add the visual to a...

To add a visual from a report to a dashboard as a tile in the Power BI service, you need to pin the visual to the dashboard. Let’s review the available options: A) Export Data - Explanation: Exporting data allows you to download the underlying data from a visual in a report, typically in formats like Excel or CSV. While this is useful for analyzing or sharing the raw data behind a visual, it does not add the visual itself to a dashboard. - Rejection: Exporting data is not related to adding a visual to a dashboard. It’s used for data extraction, not for creating dashboard tiles. - Scenario Use: Useful when you need to download data for offline analysis or reporting but not for adding a visual to a dashboard. B) Pin - Explanation: Pinning a visual to a dashboard is the action you perform when you want to add that visual (or tile) to your dashboard. This feature allows you to capture a snapshot of the visual and place it on the dashboard for easy access and monitoring. - Selection Reason: Pinning is the specific action required to take a visual from a report and add it as a tile to a dashboard. It enables you to combine and organize visuals from various reports in one place. - Scenario Use: When you want to add a specific visual from a report to a dashboard as a tile, this is the correct action. C) Copy - Explanation: Co...

Author: Noah · Last updated Mar 21, 2026

A company manages a chain of retail stores. The company stores a list of retail store names and numbers in one Power BI table. The company stores sales transaction data including a transaction ID in another table. The transaction ID includes the store number. ...

To show the store name for all retail transactions in Power BI reports, you need to link the two tables — one containing the store names and numbers, and the other containing the transaction IDs, which include the store number. The correct solution involves merging or relating these tables to allow the store name to appear with each transaction. Let’s evaluate the options: A) Query Editor - Explanation: The Query Editor (also known as Power Query) is a tool within Power BI that allows you to clean, transform, and shape your data before loading it into the model. This tool can be used to merge tables based on common columns (e.g., store number in both tables). You can use it to combine the retail store data and transaction data into a single table by matching the store number from the sales transaction table with the store number from the retail store list. - Selection Reason: The Query Editor is the most suitable tool for transforming and combining data from multiple sources. It allows you to join the tables (using merge or lookup) based on the store number, which is the common field between the two tables, and thus, you can show the store name in the sales transaction data. - Scenario Use: Perfect for combining data from different tables before they are loaded into the Power BI model and used in reports. B) Power BI Service - Explanation: The Power BI Service is the cloud-based service where Power BI reports are published, shared, and interacted with by users. While it provides options for collaboration, sharing, and viewing reports, it does not offer tools for transforming or combining data before it is visualized. - Rejection: The Power BI Service is primarily for consuming and sharing reports and does not have the capabilities to merge or manipulate data like the Query Editor doe...

Author: Aarav · Last updated Mar 21, 2026

DRAG DROP - A company is using Power BI to build visualizations. The company's IT support team needs to know when to install Power BI Desktop on users' computers and where the Power BI Service is enough to perform tasks. You need to recommend solutions for the company. What should you recommend? To answer, drag the appropriate components to the correct requirements. Each component may be used once, ...

Author: Liam123 · Last updated Mar 21, 2026

A company creates a Power BI report for vendors to view purchase orders. Vendors must view the report by using their own tenant environment. You need to use a Power ...

To allow vendors to view a Power BI report using their own tenant environment, the most appropriate solution would be C) Template app. Explanation: - A) Dashboard: A Power BI dashboard is a collection of visualizations (tiles) pinned from reports or datasets. Dashboards cannot be used to share full reports directly with users in their own environment; they are more for viewing and summarizing data from a report. Dashboards are not a suitable solution to allow vendors to access reports in their own tenant, as they don't provide a self-contained experience. - B) Mobile app: The Power BI mobile app is a tool for consuming reports and dashboards on mobile devices. While it is an app for viewing reports, it doesn't solve the problem of allowing vendors to access reports from their own tenant. It requires access to a Power BI workspace or report shared with them, but it doesn't offer a streamlined way for vendors to access a report from their own environment without the report being explicitly shared or published with them. - C) Template app: Template apps are pre-packaged Power BI solutions that allow for the distribution of reports and dashboards across multiple tenants. Template apps are the ideal solution for your scenario, as they allow vendors to install the app into their own Power BI tenant environment. This provides them with access to reports tailored to their needs, and vendors can get the data from their own systems and not rely on the company's data tenant. The key feature is that it allows deployment to multiple tenants, making it perfect for external vendo...

Author: Amelia · Last updated Mar 21, 2026

DRAG DROP - You create and share two Power BI dashboards with an accountant. You configure the dashboards to update daily. DashboardA shows a lock when the accountant tries to view the dashboard. DashboardB displays outdated data. You need to identify the issues for the dashboards. What are the issues? To answer, drag the appropriate issues to the correct dashboards. Each issue may be used once, m...

Author: Akash · Last updated Mar 21, 2026

HOTSPOT - Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE...

Author: RadiantPhoenixX · Last updated Mar 21, 2026

You create a Power App portal. When a user signs into the portal the following error displays: User not found You confirm that the user's sign in information is corr...

To solve this issue, let’s break down what the error "User not found" means in the context of a Power Apps Portal, and how to determine its cause effectively. --- Scenario Recap: - You created a Power Apps portal - A user attempts to sign in, but receives a "User not found" error - You’ve already confirmed the user's credentials are correct, so it's not a typo or wrong password --- 🔍 Understanding the Error: This error typically means: - The user exists in Azure AD or other identity provider, but - The user does not exist as a Contact in Dataverse (which backs Power Apps Portals), or - The user isn't properly associated with a Web Role or login in the portal So you need debugging tools to investigate identity mapping issues, authentication flows, or contact entity setup. --- Option Evaluation: ❌ A) Disable custom error messages - Incorrect. - Disabling custom error messages might show more detailed system errors, but it won’t help you trace the cause of a "User not found" issue. - Also, this doesn’t provide diagnostic insight — it’s more about user experience and display than actual debugging. ❌ B) Create a custom error message...

Author: James · Last updated Mar 21, 2026

HOTSPOT - A company plans to build Power Apps portals. For each of the following statements, select Yes if the statement is true. Otherwise, select...

Author: Evelyn · Last updated Mar 21, 2026

DRAG DROP - A company is building a Power Apps portal. You need to select out-of-the-box portal types to meet the company's requirements. Which portal types should you use? To answer, drag the appropriate portal types to the correct requirements. Each portal type may be used once, more than once, or not at all. You ma...

Author: Emma · Last updated Mar 21, 2026

HOTSPOT - A user is trying to understand the differences between the various ways apps can be built by using Power Apps. For each of the following statements, select Yes if the statement is true...

Author: Andrew · Last updated Mar 21, 2026

HOTSPOT - A user is creating their first canvas app in Power Apps. The user does not know what types of controls they can include. You need to recommend solutions for the user. Which types of controls should you recommend using in Power Apps? To answer, ...

Author: Deepak · Last updated Mar 21, 2026

HOTSPOT - You are designing a Power Apps solution that allows users to upload a status report directly to the company Microsoft SharePoint project management site from their mobile device. For each of the following statements, select Yes it ...

Author: David · Last updated Mar 21, 2026

A company uses Dynamics 365 Supply Chain Management. The company wants to build customer user interfaces that add additional functionality. You need to...

To build customer user interfaces that add additional functionality in Dynamics 365 Supply Chain Management, the most appropriate solution would be B) Power Apps canvas apps. Explanation: - A) Power BI: Power BI is primarily designed for data visualization and reporting. While it can create interactive reports and dashboards, it is not suited for building custom user interfaces that allow for functional customizations or direct interaction with Dynamics 365 data for tasks such as adding functionality. Power BI is more focused on business intelligence and analytics, not application customization. - B) Power Apps canvas apps: Power Apps canvas apps are ideal for creating custom user interfaces (UIs) and adding additional functionality on top of Dynamics 365 Supply Chain Management. These apps allow you to design and build fully customized UIs that can interact with Dynamics 365 data, automate processes, and integrate with other systems. Canvas apps offer flexibility in design and are perfect for businesses that need to create specific user interfaces that enhance user interaction with their systems. - C) AI Builder: AI Builder is a tool used to incorporate artificial intelligence capabilities into Power Apps and Power Automate. It is great for creating models to predict, classify, and extract data but is not intended for building custom user interfaces or adding functional UI elements to a system like Dynamics 365. AI Builder would be useful if the company wanted to add AI-powered features (e.g., predictions, automation) to their application, but it does not fulfill the need for UI customization and user ...

Author: Maya2022 · Last updated Mar 21, 2026

DRAG DROP - You need to create a mobile application which will allow sales associates to enter customer sales leads. Which four actions should you perform in sequence? To answer, move the appropriate actions from th...

Author: Layla · Last updated Mar 21, 2026

A company uses Power Apps canvas apps. When a user opens Power Apps Studio in a browser and selects Apps I can edit, they do not see an app that they need to modify. You need to determine why the user cannot see the app. What are three possible r...

To determine why a user cannot see an app in Power Apps Studio under the "Apps I can edit" section, we need to identify potential reasons related to permissions, environment settings, or app sharing. --- Scenario Recap: - A user opens Power Apps Studio in a browser. - They select "Apps I can edit" but cannot see an app that they need to modify. --- Reasoning Through the Options: ✅ A) The user selected an incorrect Power Apps environment - Correct. - Power Apps apps are environment-specific. If the user is in the wrong environment, they won’t see apps created or shared in a different environment. - Ensuring the user is in the right environment is crucial for seeing the correct apps. - Scenario: If the user is looking for an app in Environment A but is in Environment B, they won’t see it. ✅ B) The user has not been granted the System Customizer role - Correct. - In Power Apps, to modify an app, users need the appropriate permissions. The System Customizer role grants permissions to customize apps. - Without this role, the user may not have the necessary edit permissions even if they have access to the app. - Scenario: If the user has view-only access, they can’t modify the app. ✅ C) The user has not been set as the app co-owner - Correct. - In Power App...

Author: Suresh · Last updated Mar 21, 2026

DRAG DROP - You create a model-driven app. The app is ready to be shared. You need to complete the process required to set the app up to be shared. How should you complete the process for setting up the app to be shared? To answer, drag the appropriate setting to the correct drop targets. Each source may be used once, more than once, or not at...

Author: Lucas · Last updated Mar 21, 2026

HOTSPOT - You are creating a model-driven app. For each of the following statements, select Yes if the statement is true. Otherwise, select No...

Author: Nia · Last updated Mar 21, 2026

DRAG DROP - You are creating a model-driven app to track requests for quotes. The app must use the following navigation structure: Sales - * Sales Log * Request for Quotes * Projects * Settings * Customers * Product Lines * Sales Territories Administration - * User Admin * Users * Roles You need to create the app navigation. Which sitemap component types should you use? To answer, drag the appropriate component types to the correct navigation elements....

Author: Oliver · Last updated Mar 21, 2026

You have a Microsoft Excel workbook that contains a list of tasks for a project. You store the file in OneDrive for Business. You need to create a canvas app that allow...

To create a canvas app that allows team members to update the status of their tasks stored in an Excel file in OneDrive for Business, the most appropriate solution would be A) the Generate an app from data feature. Explanation: - A) the Generate an app from data feature: This feature in Power Apps automatically creates a canvas app based on the data in your Excel file. Since your tasks are stored in an Excel workbook on OneDrive for Business, you can use this feature to quickly generate a simple app that allows users to update data (like task statuses). It connects to the Excel file as the data source and provides a pre-built app interface that can be customized as needed. This is the best choice because it allows easy integration with the Excel file and is designed for situations like yours, where you want to quickly build an app to update data stored in Excel. - B) a custom action in Common Data Service: Common Data Service (now known as Microsoft Dataverse) is a data storage platform for applications like Dynamics 365 and Power Apps. It allows for more advanced data operations, but it requires data to be stored in Dataverse, not Excel. Since your data is in an Excel file, this option isn’t applicable. A custom action in Dataverse would not work directly with an Excel file stored in OneDrive for Business. - C) Power Apps Checker: Power Apps Checker is a tool used to analyze and diagnose performance or issues with Power Apps. It doesn’t create or help with the building of apps. It's designed for testing and deb...

Author: Sofia2021 · Last updated Mar 21, 2026

HOTSPOT - You create a canvas app by using the Generate from data feature. The app connects to a Microsoft SharePoint list. For each of the following statements, select Yes if the statement is tru...

Author: FlamePhoenix2025 · Last updated Mar 21, 2026

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Ea...

Author: John · Last updated Mar 21, 2026