Power Platform Practice Test Flashcards
In Power Apps, I am in my default environment. How many Dataverse Databases can I create in my default environment?
0
Which of these are not directly used in Power Virtual Agents?
Forms
I need to create a custom connector to connect data to my Power App. Can I publicly publish this connector?
No, I can use the custom connector and I can share the connector in my organisation without needing approval from Microsoft.
In power BI, what does a dashboard consist of?
Pinned visualisations, from one or more report.
In Canvas Apps, what is a gallery?
It contains components which make up all (or part of) a row of data.
In Power BI, I have two queries, each with 2000 rows. I want to bring in the rows from one query into the other query, so I end up with one query with 4000 rows. What should I use?
Power Query Editor - Append Queries
In Power Automate, what is an Apply to Each Loop?
The flow loops itself until it has gone through all the rows of the source data.
In Power Automate, what is an Do Until Loop?
The flow loops until a certain condition becomes True.
What are the three aggregations used in Power BI?
Min, Average, and Sum
In Power BI, I want to allow the end user to be able to restrict what data is shown on the page. What function will allow the end user to do this?
Slicers
In Power Virtual Agents, where would you be able to download the transcript of previous conversations?
Analytics
Which table types require a Dynamics 365 license?
Restricted, and Complex
I have Dynamics 365, which of these Portal templates have I just made up?
Customer self-service portal
Payroll Portal
Community Portal
Partner Portal
Payroll Portal
In Power BI’s Power Query Editor, I want to find out how many or what proportion of values in the sample data is blank. What do I not use?
Column Distribution
Which of these is not a standard Approval Type in Power Automate?
Approve/Reject - First to Respond
Approve/Reject - Two must approve
Approve/Reject - Everyone must approve
Approve/Reject - Two must approve
Which is not an ideal Trigger Phrase in Power Virtual Agents?
Give me details of your new desktop computer
In Power BI, I would like a graph which shows time in the horizontal or X-axis, and sales in the vertical or Y-axis. What should I not use?
Pie chart
What is the Common Data Model?
A collection of default tables
In the AI Builder, I want to create a model that detects spam. What model should I use?
Text category classification model
In Power Automate, I want a flow to start when new data arrives. What type of flow is this?
An automated flow
In Power BI, I want to find out how many rows are in my data. Which aggregation do I use?
Count
Which role has permission to create new resources (apps, connections, gateways and flows) but not access the data?
Environment Maker
I want to link two queries together, but I do not want to alter the columns contained in each query. What should I use?
Model tab
In Power BI, I want to create a new report from an excel data source. What can I use?
Both Power BI Desktop and the Power BI Service
In Power BI, which of these is a possible result of using a visual filter?
A bar chart changes from looking at all the data to looking at one particular category
I have changed my Canvas App and added every contacts telephone number to the gallery. What happens when I go back to the canvas app?
I can’t see the contacts telephone numbers no matter how many times I refresh the webpage. I need to publish these before I can see the changes.
Which of the following can connect to the Dataverse?
Power Automate
Power BI
Power Apps
All three
I want to classify the Dataverse in the Data Loss Prevention (DLP) policies. Which classification can I not use?
Blocked
In Power Apps, you can insert an image, camera, barcode scanner, video or audio components in your Canvas Power App by going to which menu?
Insert menu - media
I have created a canvas app, which uses tables from the Dataverse and includes a column containing the take-home pay for each employee. I accidentally entered a value of £10,000,000 for one employee. What is the best way to stop this from happening again?
Create a business rule
In Power BI’s Power Query Editor, I have a column with some text, which includes some leading and trailing spaces - such as “ Hello There “. What do I use to easily remove these spaces?
Trim