PL-200 Definitions

If you wanted to create a standard procedure or process for handling service requests what type of logic would be best to implement? A. Business process flow B. Business rule C. Workflow D. Flow

A

In Microsoft Dataverse, where is your data being stored? A. Tables B. Forms C. SharePoint D. Access

A

Which of the following can be done in Dataverse? A. Export data from a table. B. Export data from one or more tables as zipped markdown files. C. Load data from any file type into a table. D. All of the above.

A

Which of the following is not a User Security role? A. Application Administrator B. Delegate C. Microsoft Dataverse User D. System Customizer

A

Which of the following statements about restricted tables is false? A. Customers can add restricted tables to Dataverse. B. Restricted tables store and maintain product-specific configuration data for Dynamics 365 products that are typically not used outside of the Dynamics application. C. The restricted table is accompanied by advanced logic that creates and maintains data in a specific way when it is used within a Dynamics 365 product. D. Restricted tables require a specific Dynamics 365 product license or the Dynamics 365 Plan.

A

Which portal offers a quick way to add users and set permissions? A. Power Apps Advanced Customization B. Classic Administration Center (Solution Explorer) C. Microsoft Power Platform Admin Portal D. Power Apps Admin Portal

A

Date Only Column Type

A date and time value that only displays a date. The time value is stored as 12:00 AM (00:00:00) in the system.

Date and Time Column Type

A date and time value.

Decimal Number Column Type

A decimal value with up to 10 points of precision. See Using the right type of number for more information.

Floating Point Number Column Type

A floating point number with up to 5 points of precision. See Using the right type of number for more information.

Currency Column Type

A money value for any currencies that are configured for the environment. You can set a level of precision, or you can choose to base the precision on a specific currency or a single standard precision that is used by the organization.

Language Column Type

A number value presented as a drop-down list that contains a list of languages that have been enabled for the environment. If no other languages have been enabled, the base language will be the only option. The saved value is the Locale Identifier (LCID) value for the language.

Timezone Column Type

A number value presented as a drop-down list that contains a list of time zones.

Duration Column Type

A number value presented as a drop-down list that contains time intervals. A user can select a value from the list or type an integer value that represents the number of minutes.

Whole Number Column Type

A number value presented in a text box.

Ticker Symbol Column Type

A text value for a ticker symbol that will display a link that will open to show a quote for the stock ticker symbol.

Text Area Column Type

A text value intended to be displayed in a multi-line text box. If you require more than 4,000 characters, use a Multiline Text data type.

Multiline Text Column Type

A text value intended to be displayed in a multi-line text box. This value is limited to a maximum of 1,048,576 characters. You can also set a lower Max Length.

Text Column Type

A text value intended to be displayed in a single-line text box.

URL Column Type

A text value that is validated as a URL and rendered as a link to open the URL.

Phone Column Type

A text value that is validated as a phone number rendered as a link to initiate a phone call by using Skype.

Email Column Type

A text value that is validated as an email address and rendered as a mailto link in the column.

This section gives links to to other admin centers for Microsoft Power Platform

Admin Centers (Power Platform Admin portal)

This section gives you analytical information about your data, apps, and flows within all instances of Microsoft Dataverse. It shows information such as active users, runs, usage, and location information.

Analytics (Power Platform Admin portal)

Custom Tables

Are created for a specific business application. All licensed users of Dataverse can access custom tables if they are assigned proper security permissions to do so.

-automatically generate alphanumeric strings whenever they are created. -You can customize the format of these columns and then rely on the system to generate matching values that automatically fill them in. -appear in the Text category of columns when you create a new column.

Autonumber columns

When can you create a choice? A. When you edit an existing column B. When you define a new column C. When you delete an existing column

B

Which of the following can choices contain? A. Numbers, Images, or Text B. Numbers or Text C. Text only D. Numbers only

B

Which of the following can you use Excel for with Microsoft Dataverse tables? A. Add and create new tables to store data. B. Add, edit, or delete data. C. Add and delete tables. D. Create new entities and add data to the new table.

B

Which of the following is not a type of security role? A. User B. Global Security Role C. Environment Maker D. Delegate

B

With a P2 license in Dataverse, you can use and access any table except which of the following? A. Standard tables B. Restricted tables C. Certain tables that contain complex logic D. Custom tables

B

When creating a Table, what are the two types of relationships you can create? A. One-to-many and One-to-one B. One-to-many and Many-to-many C. Many-to-one and Many-to-many D. One-to-one and Many-to-many

B. One-to-many and Many-to-many

-Read (self), Create (self), Write (self), Delete (self) -Can run an app within the environment and perform common tasks for the records that they own. Note: This only applies to non-custom entities.

Basic User

Standard and Custom tables

Microsoft 365, Per app plan, Per user plan, Dynamics 365

Beneficial for usage reporting, including how much data is consumed, what apps are being used, what entities are used, and what is going on in each environment. The dashboards are user-friendly and provide a quick overview of activity.

Microsoft Power Platform Admin Center

-focuses on adding dashboards, forms, views, and charts to your apps. With little or no code, you can build apps that are simple or very complex. -much of the layout is determined by the components you add. -uses metadata-driven architecture so that designers can customize apps without writing code

Model-driven app design

-Rich component-focused, no-code design environments -An ability to create complex responsive apps with a similar UI across a variety of devices from desktop to mobile -Robust design capability -Apps can be distributed as a solution

Model-driven app design benefits

-how detailed data for a row is presented to the user during editing and viewing -provide a structured way to represent the data when it is rendered for interaction with the user. -are organized into header, body and footer, each capable of containing form elements like columns. -structured with areas called tabs that contain sections. Tabs and sections can be configured to support columns of elements giving further structure to the content. The first tab is the most important and should contain the priority data the user should see. While you could configure many tabs, keeping it to a smaller number with logical grouping of data can make a more usable experience because the user is not constantly tabbing around to find things.

Model-driven forms

Complex tables

Per user plan, Dynamics 365

This offers a quick way to add users and set permissions by using the gear menu within Power Apps.

Power Apps Advanced Settings

always created by Microsoft Dataverse when you create a new custom table. This is the first column that is listed and available so you have a way to identify a record in the new custom table by using a business value or an autogenerated whole number. -only one per custom table

Primary Name column

This section provides links to useful parts of Microsoft Power Platform. You can view and add capacity to your environments, view Dynamics 365 Apps, and information about your Portals.

Resources (Power Platform Admin portal)

-Max of 100 for each organization -Max of 10 for each table -Can't trigger workflows

Rollup Columns

-set a ________________ so you can start autonumbering at any value. -The _________________ of an autonumber column is the starting number that is used for the number portion of the format. -default of 1000

Seed Value

Restricted tables

Specific Dynamics 365 application licenses

The four types of tables

Standard Complex Restricted Custom

The most common auto number format is a simple string prefixed number. When this type is selected, the autonumber will consist of an automatically incrementing number with an optional string constant prefix. For example, a string prefixed number with the prefix of Contoso would generate records such as Contoso-1000, Contoso-1001, Contoso-1002, and so on.

String prefixed number

-Create, Read, Write, Delete, Customizations, Security Roles -Has full permission to customize or administer the environment, including creating, modifying, and assigning security roles. Can view all data in the environment.

System Administrator

The two environment roles that are built into every environment are __________________________________ and ______________________________

System Administrator and Environment Maker.

The ______________________________________ can perform all administrative actions on an environment, including the following tasks: -Add or remove a user or group from either the Environment Admin or Environment Maker role. -Provision a Microsoft Dataverse database for the environment. -View and manage all resources that are created within an environment. -Set data loss prevention policies.

System Administrator role

-Create (self), Read (self), Write (self), Delete (self), Customizations -Has full permission to customize the environment. However, can only view records for environment entities that they create.

System Customizer

-Microsoft Dataverse tables have a ________ as their only unique column. -This _________ is called the Primary Key and it consists of a long string of numbers and letters that are not useful to a regular user regarding meaning or significance.

GUID

-Simple to manage - Both the metadata and data are stored in the cloud -Helps secure your data - Role-based security allows you to control access to tables for different users within your organization. -Access your Dynamics 365 data - If you use Dynamics 365, data from your Dynamics 365 application is also stored within Dataverse, allowing you to extend your apps by using Power Apps. -Rich metadata - Data types and relationships are used directly within Power Apps. -Logic and validation - Define calculated columns, business rules, workflows, and business process flows to ensure data quality and drive business processes. -Productivity tools - Tables are available within the add-ins for Microsoft Excel to increase productivity and ensure data accessibility.

Benefits of using Dataverse and its tables

supports advanced developer scenarios that extend the application directly through code.

Business logic with code

-guide users to ensure they enter data consistently and follow the same steps every time. -currently supported only for model-driven apps.

Business process flows

Validate data across multiple columns in a table, and provide warning and error messages, regardless of the app that's used to create the data

Business rules

Adding a user to Dataverse automatically assigns that user to all the following roles except which one? A. Dataverse User B. Environment Maker C. System Customizer

C

An environment in Dataverse can contain all of the following except which one? A. Power Apps apps B. Power Automate flows C. Many instances of Dataverse databases D. A single Dataverse database

C

How do you make a column that is required? A. Delete the column from the table. B. Create a new column. C. Edit the column and change the Required dropdown. D. Add a column to an table.

C

What type of choice can only be used by the table and column that they are created against? A. Standard choices B. General options sets C. Local choices D. Special choices

C

When building model-driven apps, which designer is used to define the navigation of your app? A. App designer B. View designer C. Site map designer D. Dashboard designer

C

Which administrative portal shows usage data? A. Power Apps Advanced Customization B. Solution Explorer C. Microsoft Power Platform Admin Portal D. Power Apps Admin Portal

C

Which column type displays a list of options where more than one can be selected? A. Multiline Text B. Choice C. Choices D. Image

C

Which of the following sample apps is not created in your environment when you toggle "Include sample apps and data" to true? A. Asset Checkout B. Innovation Challenge C. Customer Survey D. Fundraiser

C

Which of the following statements is not true about alternate keys? A. Alternate keys make it easier for users to work with data in Microsoft Dataverse. B. Alternate keys improve database performance. C. The primary key of an table is a GUID and meaningless to users, so an alternate key can help identify the key.

C

Which portal offers a quick way to manage environments and users? A. Power Apps Advanced Customization B. Classic Administration Center (Solution Explorer) C. Microsoft Power Platform Admin Portal

C

Which table type is not a part of Dataverse? A. Standard B. Complex C. Open D. Restricted

C

When deploying role-based security in the Microsoft Dataverse, which of the following products allows you to control access to tables for different users? A. SQL Server B. Azure portal C. Dynamics 365 D. SharePoint

C. Dynamics 365

Restricted Tables

Certain tables that are tied to Dynamics 365 application functionalities require each user to have the corresponding license for that Dynamics 365 application if they want to create, update, or delete rows within the restricted tables. Additional information about restricted tables can be accessed by following the link within the summary unit of this module.

-provide an exact list of values that people can choose. -help streamline new record creation and standardize data entry, and they are best suited for a small set of standard short terms rather than a long list of complex entries. -check the data that you collect with a choice to ensure that users are not disproportionately using the default value -are managed as a separate list and then associated with a drop-down field. -When used properly and closely managed, ____________ help ensure consistent data entry and improves the quality and usefulness of the data that you collect. -can help create meaningful reports and identify trends and clusters of data.

Choices

The original of all administration portals and the portal with the deepest and most extensive administration option. This is your final stop and will have anything that you need. The Power Apps Admin Center or Advanced Settings within Power Apps mostly offer a subset of administrative options that are found within the Classic Administration Center (Solution Explorer) portal.

Classic Administration Center (Solution Explorer)

This section gives you an easy approach to receiving support from Microsoft for any needs you may have.

Help + support (Power Platform Admin portal)

Lookup Column Type

Creates a reference to a single row for a single target row type.

For more advanced makers with specific use cases, you have the option to fully customize the desired format of an autonumber column. The format might consist of string constants, automatically incrementing numbers, formatted dates, or random alphanumeric sequences.

Custom (autonumber format)

How many apps can use the same Table? A. 1 B. 20 C. 100 D. Unlimited

D

Security roles are used for all of the following except which one? A. Limiting Access to data B. Restricting access to an environment C. Restricting actions that users can perform on data D. Restricting printing

D

What is the benefit of building a model-driven app? A. Logic-focused design, no code required, and different UIs across multiple devices B. Complex responsiveness with different UIs across multiple devices C. Apps can be distributed by using complex coding and different UIs across mobile devices D. Component-focused design, no code required, complex responsiveness with similar UI across multiple devices, and apps can be distributed as solutions

D

When sharing a model-driven app, which of the following statements is true? A. Users just need to be added to a predefined security role. B. Users just need to be added to a custom security role. C. Model-driven apps do not need to be shared, they are accessible to anyone with the app link. D. Users need to be added to a predefined or custom security role and then you also need to assign one or more security roles to the app.

D

Which of the following statements is not true about views? A. You can create many views of a table. B. You can sort and filter the data in a view. C. You can choose the fields that are available in a view and edit at any time. D. You can create only two views for each table.

D

Which of the following statements is true about users? A. You can't add users to access data in Dataverse. B. Public users outside of your Azure Active Directory can access Dataverse data. C. You can enable anonymous access to any data in Dataverse. D. You can add users to access data in Dataverse from within your Azure Active Directory.

D

This section provides access to the On-premises data gateway which acts as a bridge, providing quick and secure data transfer between on-premises data and Power BI, Microsoft Flow, Logic Apps, and PowerApps.

Data (Power Platform Admin portal)

This section lets you create or add predefined connections and then monitor these connections between Dataverse and other data stores like Salesforce or SQL Server.

Data Integration (Power Platform Admin portal)

This section lets you set up policies to restrict which data connectors can be used with Dataverse to limit what data can flow into or out of Dataverse tables.

Data Policies (Power Platform Admin portal)

Another common auto number format is a date prefixed number. When this type is selected, the auto number will consist of an automatically incrementing number with a formatted date prefix. The date portion of the record will reflect the current date and time at which the record was created in UTC time. For example, a date prefixed number would generate records such as 2019-26-02-1000, 2019-27-02-1000, 2019-28-02-1000, and so on, depending on the current date and selected date format.

Date prefixed number

-Act on behalf of another user -Allows code to run as another user or impersonate. Typically used with another security role to allow access to records.

Delegate

Choices Column Type

Displays a list of options where more than one option can be selected.

Choice Column Type

Displays a list of options where only one can be selected.

Image Column Type

Displays a single image for each record in the application. Each table can have one image column. The name that you enter when creating an image column will be ignored. Image columns are always named tableImage. You can only have one image column for each table.

Yes/No Column Type

Displays two options where only one can be selected. You can choose which labels are displayed for each option. The default values are Yes and No.

-Customizations -Can create new resources that are associated with an environment, including apps, connections, custom APIs, gateways, and flows that are using Power Automate. However, does not have any privileges to access data within an environment.

Environment Maker

The ______________________________________ can create resources within an environment such as apps, connections, custom connectors, gateways, apps that use Power Apps, and flows that use Power Automate. -can distribute the apps that they build in an environment to other users within an organization by sharing the app with individual users, security groups, or to all users in the organization. -Users or groups that are assigned to these environment roles are not automatically given access to the environment's database (if it exists) and must be given access separately by a Database owner. -Whenever a new user signs up for Power Apps, they are automatically added to the this role of the default environment.

Environment Maker role

This section lists all instances of Microsoft Dataverse.

Environments (Power Platform Admin portal)

Standard Table

The base set of tables that are created for every instance of a Dataverse database. You can add more columns to any table, but you cannot delete any column from a standard, premium, or restricted table.

______________________________ control a user's access to data through a set of access levels and permissions. The combination of access levels and permissions that are included sets limits on the user's view of and interactions with that data.

User security roles

automate business processes without requiring user interaction.

Workflows

-Defining and enforcing consistent_______________________________ is a key aspect of model-driven app design. -help ensure that your app users can focus on their work and not worry about having to remember to perform a set of manual steps. -can be simple or complex, and they often change over time.

business processes

An _____________________ is a way to create and manage an instance of a Dataverse database. -lets you manage user access, security settings, and the storage -allows you to install applications that you build with Power Apps or flows that you create with Power Automate -created under a Microsoft Azure Active Directory (Azure AD) tenant, and its resources can only be accessed by users within that tenant. -bound to a geographic location

environment

Complex Tables

tables that contain complex, server-side business logic, including real-time workflows or plug-ins. Some of the tables that are used in Dynamics 365 applications are complex. To use complex tables, users are required to have a P2 or Dynamics 365 license. Care must be taken if you add server-side logic to ensure that users have the proper license to use the complex table. Additional information about complex tables can be accessed by following the link within the summary unit of this module.

Model your business data Define your business processes Build the app

three design phases of model-driven apps

Can you add attachments to custom tables in dataverse?

yes