PL900 Flashcards by Josh Cole

You need this in order to tell a workflow to run

Trigger

How well did you know this?

Not at all

Perfectly

This is prompted by the user or trigger

Action

How well did you know this?

Not at all

Perfectly

This connects apps, data, and devices in the cloud

Connectors

How well did you know this?

Not at all

Perfectly

This stores and manages data from different sources

Microsoft Dataverse

How well did you know this?

Not at all

Perfectly

Returns data in a structured table format

Tabular Data

How well did you know this?

Not at all

Perfectly

Uses functions to interact with data sources and return table of data

Function based data

How well did you know this?

Not at all

Perfectly

What are two ways data loss prevention policies can be scoped

Environment or Tenant

How well did you know this?

Not at all

Perfectly

What allows you to apply and maintain business logic

Business Rules

How well did you know this?

Not at all

Perfectly

What are the three different types of apps that make up Power Apps

Canvas, Model-Driven, Portals

How well did you know this?

Not at all

Perfectly

This type of App is made for tablets or mobile devices

Canvas Apps

How well did you know this?

Not at all

Perfectly

This type of app is built from the data

Model Driven app

How well did you know this?

Not at all

Perfectly

This is meant for external-facing websites to interact with data

Portals

How well did you know this?

Not at all

Perfectly

Name this AI model
something will happen or not based on previous data history

Prediction

How well did you know this?

Not at all

Perfectly

Name this AI model
extracts text from an image

Form Processor

How well did you know this?

Not at all

Perfectly

Name this AI model
identifies objects from an uploaded image then provides a count of objects present

Object Detector

How well did you know this?

Not at all

Perfectly

Name this AI model
Categorizes text by its meaning, easier to analyze text

Text Classification

How well did you know this?

Not at all

Perfectly

Name of the web interface to build your app

Power Apps Studio

How well did you know this?

Not at all

Perfectly

What is used to display rows from a table of data
display of a row is defined by a template
this allows you to control which columns are shown and how they are formatted
then power apps will apply this to every row in your data

Galleries

How well did you know this?

Not at all

Perfectly

What works with a specific record typically a selection from a gallery
enables a user to view detailed information
save new records
edit existing ones

Forms

How well did you know this?

Not at all

Perfectly

What is the below
text inputs, buttons, dropdowns, toggles, date pickers, and sliders
Can add controls to galleries, forms, and screens
All inputs have a multitude of settings for default data, formatting, and actions

Input Controls

How well did you know this?

Not at all

Perfectly

What is the below
rich set of controls for more advanced operations
hardware backed controls for cameras, bar code scanner, gps, and more hardware features
service-backed controls such as business card reader, or object detector

Intelligent Controls

How well did you know this?

Not at all

Perfectly

can be used for actions such as sending data to a datasource, formatting information, creating animations, and more

Functions

How well did you know this?

Not at all

Perfectly

This uses similar language in excel

Functions

How well did you know this?

Not at all

Perfectly

Name this common function
often used with galleries or tables of data to narrow the rows of returned from data source
specify one or more columns in your data set to perform a logic test
returns data that falls in a certain data range, has a set value, or was created by the user

Filter

How well did you know this?

Not at all

Perfectly

Name this common function check value to see if it follows a given pattern can use to check if a user entered a properly formatted email address, if not then show a warning that a valid email is required

Match

Name this common function returns unique values from a list of data easier to build dynamic dropdowns showing users only valid values for a given column

Distinct

Name this permission type users can use, edit, and share the app but can't delete or change the owner

Co-Owner

Name this permission type users can view and use the app, but they can't change it

User

Name this User Interface Component detemines app fundamentals like components, properties, and the client type and the URL

App

Name this User Interface Component navigation for your app

Site Map

Name this User Interface Component includes a set of data entry columns for a given table can be used to create a new data row or edit an existing one

Form

Name this User Interface Component define how a list of rows for a specific table appears in your app defines the columns shown, width of each column, the sorting behavior, and default filters

View

Name this Logic Component walks a user through a standard business process

Business Process Flow

Name this Logic Component automates business process without a user interface does not require user interaction

Workflow

Name this Logic Component type of process that lets you manually invoke behaviors including custom actions, directly from a workflow

Actions

Name this Logic Component apply rules or recommendation logic to a form to set field requirements, hide or show fields, validate data, and more

Business Rule

Name this Logic Component automated workflows between apps and services to get notifications, sync files, collect data, and more

Flows

Name this Visualization Component shows one or more graphic visualization in one place

Dashboard

Name this Visualization Component individual graphic visualization that can appear in a view or a form, can be added to a dashboard

Chart

What types of tables must have their privileges explicitly specified before users can work in it

Custom Tables

What does the below: Is used to automate repetitive business processes Can send reminders on past due tasks, move business data between systems on a schedule, talk to more than 600 data sources or any publicly available API Can automate tasks on your local computer like computing data in Excel

Power Automate

Name this flow that you can create in Power Automate: A flow that you build with a trigger and then one or more actions many different types of triggers and actions arrival of an email to a specific person mention of your company in social media See these as My Flows and Team Flows Only difference between My flow and Team flow is ownership My Flow you are the owner, and Team Flow has more than one

Cloud Flows

Name this flow that you can create in Power Automate: built to augment the experience when using model driven apps and Microsoft dataverse use to create a guided experience

Business Process Flows

Name this flow that you can create in Power Automate: robotic process automation (RPA) allows you to record yourself performing actions on your desktop or within a web browser Then you can trigger a flow to perform that process for you You can pass data in or pass data out

Desktop Flows

Name this action that you can have in a flow: runs an action until conditions are met to move to the next step of the flow

Loops

Name this action that you can have in a flow: Identifies a single case to execute based on the evaluation of input

Switch

Name this action that you can have in a flow: Executes a block of actions until a specified condition evaluates to true

Do Until

Name this action that you can have in a flow: Executes a block of actions for each item in the input array

Apply to Each

Name this action that you can have in a flow: underlying definition that describes the actual logic that runs in your flow that can be manually written

Expressions

Name these 4 data operations you can have in a flow

Compose, Create CSV Table, Join, Select

Name this action use when you have to enter identical data multiple times

Compose Action

What does the below: Collection of software services, apps, and connectors that work together turns this collection into coherent, visually immersive, and interactive insights

Power BI

Name the 3 Power BI services that allow users to do the below create, share, and consume business insights

Desktop, The Service, Mobile Apps

What is the name of the Core Power BI Concept that does the below: Represents a set of resources used to host and deliver your Power BI content Shared or Dedicated

Capacities

Name this Power BI term Container for dashboards, reports, datasets, and dataflows in Power BI place where you create, publish, and manage apps for your organization

Workspaces

Name the two types of workspaces

My Workspace, Workspace

Name this term can also source data from dataflows associated with workspaces and a single dataset can be part of many workspaces

Datasets

Name this term Enables Power BI partners to build Power BI apps Can create a set of out-of-the-box content for your customers and publish it yourself

Template Apps

Name this report view allows you to view all of your data available in your report. Easy way to quickly check data types and validate data

Data View

Name this report view allows you to visually set the relationship between tables or elements

Model View

Name this filter simple type of filtering that you can use directly on the report page provides cues to ways you can filter the results in the visuals on a report page Different types of slicers: numeric, categorical, and date makes it easy to filter all the visuals on the page at once

Slicer

Name this filter applies to all pages in the report

Report

Name this filter applies to all the visuals on the current report page

Page

Name this filter applies to a single visual on the report page, can only view if you have selected a visual on the report canvas

Visual

Name this filter allows you to explore successively more detailed views within a single visual

Drillthrough

Name this tool in Power BI can help you shape and transform data

Power Query Editor

Name this tool in Power BI a place that allows you to undo any step

Applied Steps List

Name this way to aggregate your data Power BI treats each value in that field separately and doesn't summarize them use this option if you have a numeric ID column that the service shouldn't sum

Do not Summarize

Name this way to aggregate your data adds all the values in that field up

Sum

Name this way to aggregate your data Takes an arithmetic mean of the values

Average

Name this way to aggregate your data shows the smallest value

Minimum

Name this way to aggregate your data shows the largest value

Maximum

Name this way to aggregate your data counts the number of values in that field that aren't blanks

Count(not blanks)

Name this way to aggregate your data counts the number of different values in that field

Count(distinct)

Name this way to aggregate your data shows the value that has the same number of items below and above

Median

What does the below: empowers teams to easily create a powerful chatbot using a guided no code GUI without the need for data scientists or developers

Power Virtual Agents

Name the three reasons to use Power Virtual Agents

Empower your teams Reduce Costs Improve Customer Satisfaction

Name this Power Virtual Agents term defines how a chatbot conversation plays out has trigger phrases, these phrases, keywords, or questions that a user is likely to type that is related to a specific issue

Topics

Name this Power Virtual Agents term these are what you use to define how a chatbot should respond and what it should do

Conversation Nodes

Entities use this term below ability for the AI to understand a users intent identify entities in a user dialog

Natural Language Understanding

Name this Power Virtual Agents term viewed as an information unit that represents a subject: phone number, zip code, city, or even a persons name

Entities

Name some of the pre-built entities which represent common used information

age, colors, numbers, and names

A company plans to create an app by using Microsoft Power Platform. The app should be able to email sales quotes to customers. You need to automate the process of sending sales quotes. What should you use?

Power Automate

You need to build a low-code application that includes online forms for collecting and displaying information from users. What should you use?

Power Apps

You plan to use the Microsoft Teams connector in a Power Automate cloud flow. Which two components are defined by the connector? Each correct answer presents a complete solution.

Actions, Triggers

You need to create an approval process for sales quotes. Which Microsoft Power Platform component should you use?

Power Automate

A company uses Microsoft 365. All users in the company have a Microsoft 365 license assigned to them. You plan to create a chatbot using Power Virtual Agents in Microsoft Teams. You need to identify two features that are unique to the Power Virtual Agents web app. Which two features should you identify? Each correct answer presents a complete solution.

Allow users outside your company to use the chatbot. Use the chatbot on your website.

A company uses Microsoft Power Platform. The company needs to read text from uploaded images. You need to determine which connector to use. Which connector should you use?

Azure Cognitive Services

A company uses Microsoft Exchange Online. The company receives email messages from its customers. The company wants to determine whether customers are happy, satisfied, or upset. Email messages must be routed to the proper representative based on sentiment. You need to create a flow in Power Automate that can read and route the messages. Which two actions should you perform? Each correct answer presents a complete solution.

Connect to AI Builder and use the prebuilt sentiment analysis model. Connect to Azure Cognitive Service for Language and use the Sentiment action.

A company uses Microsoft Power Platform. The company builds Power Apps canvas apps, Power BI dashboards, and Power Virtual Agents chatbots. You need to identify the Microsoft Power Platform component that can be used directly with these three components. What should you identify?

Power Automate

You configure security and compliance features in Microsoft Power Platform. You need to restrict access to all social media connectors. What should you configure?

Data loss prevention (DLP) policy

A company uses Microsoft Power Platform. You need to prevent external leakage of corporate data. What should you do?

Create data policies.

A company has three branch offices in New York, Paris, and Madrid. You need to create the Microsoft Dataverse environments and the Microsoft Dataverse instances. What should you do?

Create three environments, each with one instance.

A company uses Microsoft Dataverse to create a data model for a retail organization. The company uses the standard contact table to store customer information. A customer can order one or more products. You need to create a relationship between customer and product. Which type of relationship should you use?

Many-to-many

You build a solution by using Microsoft Power Platform and Microsoft Dataverse. You must use the default Currency table that comes with your Microsoft Dataverse subscription. You need to determine the table type for the Currency table. Which table type should you identify?

Standard

A real estate company plans to use Microsoft Dataverse to track apartments. You need to create a new column to store whether an apartment is available for rent, for sale, or both. Which column type you should use?

Choices

A company uses Microsoft Power Platform. You create a custom connector from an OpenAPI file. You need to allow other makers in your organization to use the connector. What should you do?

Share the connector.

A company has a custom API. The API downloads Microsoft Excel and Microsoft Word files from an internal server. You need to fetch data inside Power Automate. Which two connectors can you use? Each correct answer presents a complete solution.

Premium HTTP connector Custom connector

A company has a public-facing portal for its partners. You need to fetch data from the portal in a flow. Which solution should you use?

Custom connector

You build a Power BI report by using Power BI Desktop. The data is based on a complex set of data that includes multiple data tables that have many-to-one relationships with each other. You need to visually represent the tables and their relationships so that you can understand the data you are working with before you build the report. What should you do?

Click on the Modeling view and examine the diagram of available tables and their relationships with each other.

A company uses Power BI. You need to collaborate with others to build visualizations. What should you use?

Workspace

You edit a Power BI report. You need to add a calculated column. Which two actions should you perform? Each correct answer presents part of the solution.

Open the report using Power BI Desktop. Select the Data tab and then select New column.

You create a Power BI report to display information about product sales using Power BI Desktop. You have two Excel spreadsheets named Data1.xlsx and Data2.xlsx. Data1.xlsx has a table called Table 1. Table 1 has two columns of information: Product name Units sold Data2.xlsx has a table called Table 2. Table 2 has two columns of information: Toy name Number sold You need to combine the data into a single dataset that can be used in the report by using Power Query Editor. The data set must contain the headers Product name and Units sold. Which two actions should you take? Each correct answer presents part of the solution.

Rename the columns in Table 2 to Product name and Units sold. Append the data from Table 1 to the data in Table 2.

A company stores data in different systems. You need to show the data by using Power BI. Which three data sources should you use? Each correct answer presents a complete solution.

SQL Server CSV file Excel workbook

You plan to create a Power BI report to display a company’s sales data. The sales team has prebuilt reports in Power BI that contain sales data. You need to recommend a solution that allows users to reuse the same dataset to build their own reports and dashboards. What should you recommend?

Share the dataset containing sales data.

You create a Power BI report. You need to share the report with internal users. Which two actions should you perform? Each correct answer presents a complete solution.

Embed the report in a secure portal. Use the Power BI mobile app.

You create Power BI reports by using Power BI Desktop. You need to recommend how to create a relationship between the two tables in Power BI Desktop. Which two sections should you recommend? Each correct answer presents a complete solution.

Data Model

You have a table in a Power BI dataset. You add a clustered column chart visual to the report page. You need to show the count of rows in the table as columns for each category in the table. Which field well should you add to the row count measure?

Y-axis

You need to create a Power BI dashboard for Power BI mobile apps. What should you do?

Edit the phone view.

A company uses Power BI. You create a Power BI report and publish it to the Power BI service. You need to create a dashboard containing tiles for individual visualizations. What are two possible ways to achieve this goal? Each correct answer presents a complete solution.

Pin a visualization. Use the Q&A question box.

You plan to create a Power Apps app. You need to enable users to read and write data from SharePoint and OneDrive for Business. Which type of app should you use?

Canvas app

A company uses Microsoft Power Platform. You need to recommend a use case for formulas in canvas apps. Which two actions should you recommend? Each correct answer presents a complete solution.

Filter a list of rows. Save data when a user selects a button.

You create a canvas app. You need to format currency values in the app to always display two decimal places. Which code segment should you use?

Text(“Currency value”, “$#, ###0.00”)

A company uses Microsoft Power Platform. You need to describe the features of Power Apps. What are two features of a canvas app? Each correct answer presents a complete solution.

Control functionality with Microsoft Power Fx formulas. Include artificial intelligence.

A company uses Microsoft Power Platform. Which two controls in a canvas app can be connected to a data source? Each correct answer presents a complete solution.

Form Gallery

You create a canvas app that is connected to a Microsoft Dataverse table. You need to share the app. Which two actions should you perform? Each correct answer presents part of the solution.

Publish the app. Assign a security role.

You configure a canvas app to track and order office stationery. The app allows users to order multiple stationery items. The items selected by the user must be reset each time a user reopens the app. You need to store user selections. Which function should you use?

Collection

You plan to create a canvas app that allows users to view a list of current scores for all local professional sporting events. Each game should display the following: Name of the game. Amount of time left in the game. A link to a map of the game’s location. You need to add controls to your Power Apps app. Which two controls should you use? Each correct answer presents part of the solution.

Screen Gallery

A company uses SharePoint and Microsoft Power Platform. You need to create a canvas app from an existing SharePoint list that can view and edit items in the list. In which two locations can you create this app? Each correct answer presents a complete solution.

Power Apps maker portal SharePoint list

A company uses Microsoft Power Platform. You model the data in Microsoft Dataverse and create a model-driven app. You need to create a new model-driven app for a different group of users. The model-driven app must restrict the columns in a table that users can change the values. Which two actions should you perform? Each correct answer presents part of the solution.

Create a new form for the Microsoft Dataverse table. Select the form in the app designer.

A company has a model-driven app. You need to enable all users to access data in the app. What should you do?

Create a new public view.

You are configuring Sitemap for a model-driven app. You need to add a table to the navigation pane of the app. Where should you add the table?

Subarea

A company uses Microsoft Dataverse. You need to define views to display data in model-driven apps. Which three items can you configure in the view designer? Each correct answer presents part of the solution

The columns included in the view. The filter for rows shown in the view. The sort order of rows in the view.

You need to create a Power Automate flow to allow managers to approve or deny vacation requests. Which two flow types should you use? Each correct answer presents a complete solution.

Business process flow Cloud flow

You have a Power Automate flow that fetches a list of contacts from Microsoft Dataverse. You need to loop through contact collection and perform operations on each record. Which connector should you use?

Control

A company has an approval process that contains an attachment. You need to ensure users can access the attachment in the approval notification. Which three solutions should you use? Each correct answer presents a complete solution.

Email inbox Power Automate portal Microsoft Teams

You have a Power Automate flow that triggers whenever a comment is posted on a blog site. You need to configure the flow to meet the following requirements: Require users to fill in their subscriber ID when posting comments. Save the subscriber ID in uppercase from the Power Automate flow. Which function should you use?

Expression

You need to modify a cloud flow. Which three solutions should you use? Each correct answer presents part of the solution.

Power Automate portal Power Automate mobile app Power Apps Studio

You have a Power Automate flow. You have a JSON array that has contacts information. You need to combine the First Name and Last Name properties of the array in a new property called Full Name. Which data operation should you use?

Select

You create a Power Automate cloud flow. The cloud flow fails at a step. You need to send an email notification to the flow owner whenever a step fails. What should you configure?

Run after

You build a Power Virtual Agents bot. You add a topic to the bot. You need to train the bot to understand how someone might ask for a topic. What should you add to the bot?

Trigger phrases

A company uses Power Virtual Agents. You need to perform actions in Microsoft Dataverse by using a chatbot. What should you use?

Power Automate

You can configure this to execute an action if the flow step has failed

Run After

This determines the number of times the flow will attempt a step if it fails

Retry Policy

This is used to shape and transform data in power automate flow

Compose Action

This operation allows you to add a new property

Select

This is used to reduce the number of objects

Filter Array

This is used to combine the elements with a separator

Join Operation

This operation does not allow you to add another property

Parse JSON

This connector converts HTML to text

Content Conversion

This connector has an Apply to Each action that can be used through collection records

Control

This area in a sitemap can be used to show tables, dashboards, and custom pages

Subarea

This displays context-specific menu items on a grid, form, or subgrid

Command Bar

This can select which of the forms is available in the app

App Designer

This is a container for other controls

Screen

This can be used to store data temporarily within the app

Collection

This function can be used to clear a collection on demand

The Clear Function

This is used to store a single value or an object

Variables

What must happen to a canvas app before it can be shared

Published

When a canvas app is connected to a Microsoft Dataverse table what must be assigned

Security Role

What is used to view, editi, and create a single row for a data source

Form

This function formats a number or a datetime value based on the specified format

Text

This function is used to extract the first text string that matches a pattern

Match

This function converts a string of text that contains number characters to a number value

Value

This feature on the dashboard allows asking a question about the data and this generates visualizations that can be pinned to the dashboard

Q&A Feature

Power BI Desktop and Power BI modile apps cannot create what

Dashboards

Power BI Desktop can be used to add what type of column

Calculated

An environment can only have how many Microsoft Dataverse instances

One

PL900 Flashcards

(158 cards)