Free Microsoft Power Platform Fundamentals MCQ Questions and Answers — Questions and Answers
Question 1: Marco is employed with PTG Ltd. His task is to create a Power App Portal. He notices that a "User not found" error message displays when a user tries to login into the portal. Given that the user's sign-in information is accurate, Marco has been entrusted with determining the reason for the issue. <br> <br> Which of the following choices should Marco make in order to determine what caused the error?
- Create a custom error message
- Enable diagnostic tools in Lifecycle Services (Correct answer)
- Enable Maintenance mode
- Disable custom error messages
Correct answer: Enable diagnostic tools in Lifecycle Services
For Power Apps Portals, enabling diagnostic tools in Lifecycle Services (LCS) provides detailed logging and error information that can help diagnose issues like a 'User not found' error. This allows Marco to investigate the root cause by examining backend processes, authentication flows, and configuration settings, even when user credentials are correct. Custom error messages only change the user experience, not the underlying issue.
Question 2: Which of the following choices ought to be used to display sales orders that exceed a particular threshold in a Power BI report?
- Common Data Service
- Connector
- Filter (Correct answer)
- Power Query
Correct answer: Filter
To display sales orders that exceed a particular threshold in a Power BI report, a filter should be applied. Filters allow users to narrow down the data displayed based on specific criteria, such as a sales order amount being greater than a certain value. This directly addresses the requirement of showing only relevant orders that meet the specified condition.
Question 3: Rico is employed with PTG Ltd. He is to create a Power Automate flow to manage sales activities. He notices that the sales team keeps quotes in a Microsoft OneDrive folder using PDF files. Rico creates a Microsoft SharePoint list to make it easier for follow-ups on quotes.
- language detection
- key phrase extraction
- sentiment analysis
- text recognition (Correct answer)
Correct answer: text recognition
Rico needs to extract information from PDF files containing quotes to populate a SharePoint list. Text recognition, often referred to as Optical Character Recognition (OCR), is the AI Builder capability that allows Power Automate to read and extract text from images or PDF documents. This enables the automation of data entry from unstructured documents into structured lists.
Question 4: Which of the following statements best describes how the Microsoft Power Platform works?
- They stand for a collection of business rules, relationships, and tables that provide a standard organized data storage for business applications.
- They stand for a series of automated processes that are initiated by a trigger and may involve sophisticated branching logic.
- They use business logic, security, and integrations to help launch application development. (Correct answer)
- They stand for a group of services that make the data tables accessible.
- They stand for a method of connecting to a data source.
- They represent a set of rows used to store data
Correct answer: They use business logic, security, and integrations to help launch application development.
The Microsoft Power Platform is a suite of low-code tools designed to enable rapid application development, automation, and data analysis. It leverages business logic, robust security features, and seamless integrations with various data sources and services to empower users to build custom applications, automate workflows, and analyze data efficiently, thereby accelerating application development.
Question 5: John utilizes Dynamics 365 Sales at TPT Ltd. He must create a Power BI report with client office locations so that the report's City and State columns are combined into a single column. <br> <br> Which of the following options is best suited to meet the requirement?
- Create a view.
- Use Power Query Editor to merge columns. (Correct answer)
- Import the data.
- Export data to Microsoft Excel.
Correct answer: Use Power Query Editor to merge columns.
The Power Query Editor in Power BI is the ideal tool for data transformation tasks, including combining columns. John can use its 'Merge Columns' feature to combine the 'City' and 'State' columns into a single new column. This allows him to create a unified location field directly within the Power BI data model, meeting the report's requirement.
Question 6: Given that you have a Power App for data updates and use Power BI for data visualization in the database, how can you immediately update the data in your corporate database from the Power BI report?
- You could select Analyse in Excel from Power BI, update the data in the Excel workbook, and import the updates using the Power app
- You cannot update data from a Power BI report
- You should add the PowerApps custom visual to the Power BI report to update the data directly (Correct answer)
- You want to incorporate the Power BI report inside the Power App so that users may examine the data and then directly change it.
Correct answer: You should add the PowerApps custom visual to the Power BI report to update the data directly
The PowerApps custom visual in Power BI allows users to embed a Power App directly into a Power BI report. This enables interactive data updates from within the report itself. Users can view data in Power BI and then use the embedded Power App to modify the underlying data in the corporate database immediately, providing a seamless experience for data analysis and modification.
Question 7: Which of the following statements best describes how the Common Data Model and Common Data Service work?
- They stand for a series of automated processes that are initiated by a trigger and may involve sophisticated branching logic.
- They stand for a collection of business rules, relationships, and tables that provide a standard organized data storage for business applications.
- They use business logic, security, and integrations to help launch application development.
- They represent a set of services that exposes the data tables. (Correct answer)
Correct answer: They represent a set of services that exposes the data tables.
The Common Data Service (now Dataverse) is a platform that provides a secure and scalable way to store and manage data for business applications. It exposes data tables and their relationships through a set of services, allowing Power Apps, Power Automate, and Power BI to interact with and leverage this structured data. The Common Data Model defines the standard schema for these tables.
Free Microsoft Power Platform Fundamentals MCQ Questions and Answers
Marco is employed with PTG Ltd.
His task is to create a Power App Portal.
He notices that a "User not found" error message displays when a user tries to login into the portal.
Given that the user's sign-in information is accurate, Marco has been entrusted with determining the reason for the issue.
Which of the following choices should Marco make in order to determine what caused the error?