Power Platform Practice Test Flashcards

1
Q

In Power Apps, I am in my default environment. How many Dataverse Databases can I create in my default environment?

A

0

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which of these are not directly used in Power Virtual Agents?

A

Forms

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

I need to create a custom connector to connect data to my Power App. Can I publicly publish this connector?

A

No, I can use the custom connector and I can share the connector in my organisation without needing approval from Microsoft.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

In power BI, what does a dashboard consist of?

A

Pinned visualisations, from one or more report.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

In Canvas Apps, what is a gallery?

A

It contains components which make up all (or part of) a row of data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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?

A

Power Query Editor - Append Queries

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

In Power Automate, what is an Apply to Each Loop?

A

The flow loops itself until it has gone through all the rows of the source data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

In Power Automate, what is an Do Until Loop?

A

The flow loops until a certain condition becomes True.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the three aggregations used in Power BI?

A

Min, Average, and Sum

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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?

A

Slicers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

In Power Virtual Agents, where would you be able to download the transcript of previous conversations?

A

Analytics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which table types require a Dynamics 365 license?

A

Restricted, and Complex

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

I have Dynamics 365, which of these Portal templates have I just made up?

Customer self-service portal

Payroll Portal

Community Portal

Partner Portal

A

Payroll Portal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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?

A

Column Distribution

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

Approve/Reject - Two must approve

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which is not an ideal Trigger Phrase in Power Virtual Agents?

A

Give me details of your new desktop computer

17
Q

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?

A

Pie chart

18
Q

What is the Common Data Model?

A

A collection of default tables

19
Q

In the AI Builder, I want to create a model that detects spam. What model should I use?

A

Text category classification model

20
Q

In Power Automate, I want a flow to start when new data arrives. What type of flow is this?

A

An automated flow

21
Q

In Power BI, I want to find out how many rows are in my data. Which aggregation do I use?

A

Count

22
Q

Which role has permission to create new resources (apps, connections, gateways and flows) but not access the data?

A

Environment Maker

23
Q

I want to link two queries together, but I do not want to alter the columns contained in each query. What should I use?

A

Model tab

24
Q

In Power BI, I want to create a new report from an excel data source. What can I use?

A

Both Power BI Desktop and the Power BI Service

25
Q

In Power BI, which of these is a possible result of using a visual filter?

A

A bar chart changes from looking at all the data to looking at one particular category

26
Q

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?

A

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.

27
Q

Which of the following can connect to the Dataverse?

Power Automate

Power BI

Power Apps

A

All three

28
Q

I want to classify the Dataverse in the Data Loss Prevention (DLP) policies. Which classification can I not use?

A

Blocked

29
Q

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?

A

Insert menu - media

30
Q

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?

A

Create a business rule

31
Q

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?

A

Trim