quiz image

Connectors, Dataverse, AI Builder and Other

FastStatistics avatar
FastStatistics
·

Start Quiz

Study Flashcards

43 Questions

What features are only available in Microsoft Dataverse?

Multiple currency support

What type of column should you create in Microsoft Dataverse to allow for adding more options or changing labels in the future?

Choice

Which type of column should be used in Microsoft Dataverse to capture the severity of a problem reported by customers?

Choice

What should you do to share a model-driven app created in Power Apps using a custom Microsoft Dataverse table?

Select a user and assign privileges

Which Microsoft Power Platform service should be used to connect to an in-house web application's API for automation?

Custom connector

What is a feature of a canvas app?

Control functionality with Microsoft Power Fx formulas

Which Microsoft Power Platform service should a company use to analyze customers' reviews on a social platform?

AI Builder

In a customer self-service portal, what Microsoft Power Platform feature should be used to extract city and product names from complaints?

AI Builder

When restricting access to social media connectors in Microsoft Power Platform, what should you configure?

Data loss prevention (DLP) policy

Which connector should be used in Microsoft Power Platform to read text from uploaded images?

Microsoft Cognitive Services

How can you prevent external leakage of corporate data in Microsoft Power Platform?

Create data policies

To require users to fill in their subscriber ID in uppercase when posting comments on a blog site in Power Automate, which function should be used?

Expression

What should be created to allow suppliers to register themselves and access information in a web-based knowledge base?

Portal app

Which feature allows users to build custom apps without writing code in Microsoft Power Platform?

Canvas app

Which type of column in Microsoft Dataverse allows users to select a single value from a list of options?

Choice field

Which Microsoft Power Platform service should be used to connect to a custom web application's API for data exchange and automation?

Custom connector

What is a unique feature of Microsoft Dataverse that is not available in Microsoft Dataverse for Teams?

Mobile offline

Which statement is true about sharing a model-driven app created in Power Apps using a custom Microsoft Dataverse table?

A security role must be assigned to the user when sharing the app

Match the following terms with their correct descriptions:

Primary key = Uniquely identifies each row in a table Custom connector = Needs to be shared for other makers to use Choice field = Allows user to select a single value from a list Text field = Allows free user text without data validations

Match the following statements with the correct Microsoft Dataverse features:

Support for multiple currencies = Not available in Microsoft Dataverse for Teams File and image support = Available in both Microsoft Dataverse versions Relational storage = Supported by Microsoft Dataverse for Teams Unique to Microsoft Dataverse = Multiple currencies and Mobile offline support

Match the following actions with the correct requirements:

Access to custom table in app = Requires assignment of a security role Sharing a model-driven app = Needs a security role assigned to a user Co-owner selection in canvas app sharing = Not applicable in model-driven apps Navigating to app details = Provides location but not permissions

Match the following connectors with their specific functionalities:

Dataverse connector = Interacts with Dataverse data only Excel Online (Business) connector = Works exclusively with Excel files in document libraries supported by Microsoft Graph Custom web application integration connector = Built for connecting to custom APIs for data exchange Business process flows connector = Guides UI flows for streamlined data entry

Match the following features with their correct descriptions:

Policies on custom connectors = Configure the connector at runtime Error message on permission denial = Displayed when user lacks required permissions Data store behavior with Choices field = Allows selection of multiple values from available options Approval options using Yes/No column type = Enables Approve and Reject selections

Every table in Microsoft Dataverse has a ______ that uniquely identifies each row.

primary key

Microsoft Dataverse for Teams does not support ______ or Mobile offline.

multiple currencies

The ______ field allows a user to select a single value from a list of options.

Choice

The ______ field allows a user to select more than one value from the list of options.

Choices

To share a ______ app, a security role must be assigned to a user.

model-driven

The ______ connector is used to interact with Dataverse data in Microsoft Power Platform.

Dataverse

______ flows are guided UI flows in model-driven apps for streamlined data entry.

Business process

What is the primary key column in Microsoft Dataverse?

The primary key column is created when the table is created and uniquely identifies each row in the table.

How can a custom connector be made available to other makers in Microsoft Power Platform?

The custom connector needs to be shared to allow other makers to use the connector in their apps and flows.

What is the purpose of policies on custom connectors in Microsoft Power Platform?

Policies on custom connectors are used to configure the connector at runtime, but they do not make the connector available for other makers.

What is the difference between the Choice and Choices fields in Microsoft Dataverse?

The Choice field allows a user to select a single value from a list of available values, while the Choices field allows a user to select more than one value from the list of available options.

What is the purpose of the Dataverse connector in Microsoft Power Platform?

The Dataverse connector is a prebuilt connector in Microsoft Power Platform that is used to interact with Dataverse data.

What is the purpose of the Excel Online (Business) connector in Microsoft Power Platform?

The Excel Online (Business) connector is a prebuilt connector in Microsoft Power Platform that is used to connect and work only with Excel files in document libraries supported by Microsoft Graph, and cannot be used to interact with custom APIs.

What is the purpose of business process flows in Microsoft Power Platform?

Business process flows are guided UI flows in model-driven apps for streamlined data entry, and cannot be used to interact with custom APIs.

Which Microsoft Power Platform service should be used to connect to a custom web application's API for data exchange and automation?

The custom connector should be used in Microsoft Power Platform to connect to a custom web application's API for data exchange and automation.

In Microsoft Dataverse, the primary key column uniquely identifies each row in a table.

True

To share a model-driven app, a co-owner can be selected instead of assigning a security role.

False

The Choices field in Microsoft Dataverse allows users to select multiple values from a list of options.

True

Microsoft Dataverse for Teams supports multiple currencies.

False

The custom connector needs to be shared to make it available to other makers.

True

Study Notes

Microsoft Power Platform Connectors

  • Azure Cognitive Services is used to read text from uploaded images
  • Custom connector is used to connect to a custom web application's API

Security and Compliance

  • Create data policies to prevent external leakage of corporate data
  • Data loss prevention (DLP) policy is used to restrict access to social media connectors

Power Apps

  • Canvas apps can be used to create a web-based knowledge base
  • Portal apps can be used to allow suppliers to register themselves to gain access to information stored in the knowledge base

Power Automate (formerly Microsoft Flow)

  • Expression function is used to save the subscriber ID in uppercase
  • AI Builder is used to analyze customers' reviews on a social platform to understand how they feel about a product

Microsoft Dataverse

  • Choice column type allows users to select one option from a list of available values
  • Choice column type allows users to select more than one option from the list of available options
  • Lookup column type is created when a one-to-many relationship is created between two tables
  • Many-to-many relationship is used to create a relationship between customer and product
  • Standard table type is used for the Currency table
  • One environment can have one Microsoft Dataverse instance
  • Three environments, each with one instance, can be created for three branch offices

AI Builder

  • Sentiment analysis, text recognition, language detection, object detection, and document processing are prebuilt models available in AI Builder
  • AI Builder can be used to extract entity information such as city, color, phone number, and location from text
  • AI Builder is used to analyze customers' reviews on a social platform to understand how they feel about a product

Microsoft Power Platform Features

  • Control functionality with Microsoft Power Fx formulas can be used in canvas apps

  • Include artificial intelligence can be used in canvas apps

  • Embed entire Power BI dashboards cannot be done in canvas apps, but individual tiles from a Power BI dashboard can be embedded### Azure Cognitive Services

  • Can analyze images and extract printed and handwritten text from the image

  • Has multiple connectors for Microsoft Power Platform

  • Can analyze images but cannot analyze the contents of files in Azure Blob storage

Microsoft Power Platform Connectors

  • Azure Blob storage connector is used for storing and accessing files, not analyzing contents
  • Microsoft Dataverse can store files but cannot analyze contents
  • Microsoft Teams connector can create channels and post messages but cannot analyze files

Data Security and Policies

  • Data policies prevent apps or flows from connecting to two different data sources that may allow data to be accessed or copied outside of the organization
  • Microsoft Entra ID conditional access can control when a user can access a Power Apps app using various signals like location and device
  • CoE toolkit enables monitoring of apps, flows, and connectors used within the organization, but does not prevent data leakage on its own

Power Apps and Power Automate

  • Power Apps is used to create apps for end users, including canvas apps, model-driven apps, or a Power Pages site
  • Power Apps cannot detect sentiment in text or extract information from text on its own
  • AI Builder is used to detect sentiment in text and extract entity information, and can be used in Power Apps apps or Power Automate flows

AI Builder

  • Has prebuilt models, including sentiment analysis, text recognition, and language detection
  • Also has custom models, such as object detection, category classification, and document processing
  • Can be used directly in Power Apps applications or Power Automate flows

Microsoft Dataverse

  • Has a single instance per environment
  • Environment is required to host a Microsoft Dataverse instance
  • Has standard tables, including out-of-the-box tables, such as the Currency table
  • Custom tables are unmanaged tables created directly in the Microsoft Dataverse environment
  • Virtual tables are custom tables with columns containing data from an external data source

Data Modeling

  • Lookup columns are created on the related table when a one-to-many relationship is created between two tables
  • Lookup columns are also known as foreign keys
  • Alternate keys are created for integrations with other systems

App Development

  • Canvas apps are built from scratch and require more time to build than portal apps
  • Canvas apps require users to be authenticated with Microsoft Entra ID
  • Canvas apps can include AI controls for form processing and object detection
  • Model-driven apps do not allow for self-service registration to gain access to the app

Microsoft Power Platform CoE Toolkit

  • Enables monitoring of apps, flows, and connectors used within the organization
  • Enables managing of data policies
  • Does not prevent data leakage on its own### Customer and Tables
  • Customer is a special lookup column that represents an account or a contact
  • Customer column cannot be created by creating a one-to-many relationship
  • Every table in Microsoft Dataverse has a primary key that uniquely identifies each row
  • Primary key column is created when the table is created

Custom Connectors

  • Custom connector needs to be shared to allow other makers to use it in their apps and flows
  • Policies on custom connectors are used to configure the connector at runtime
  • Policies do not make the connector available for other makers
  • Paconn command line tool can be used for development of custom connectors
  • Custom connector can only be submitted if the connector needs to be available publicly

Microsoft Dataverse

  • Microsoft Dataverse for Teams does not support multiple currencies or Mobile offline
  • Microsoft Dataverse and Microsoft Dataverse for Teams both have file and image support
  • Microsoft Dataverse for Teams also supports relational storage

Fields

  • Choice field allows user to select a single value from a list of available values
  • User also has the option not to choose any value from the options, in which case the data for the column will be saved as null in data store
  • Choices field allows a user to select more than one value from the list of available options
  • Approve and Reject options can be enabled using Yes/ No column type, but it can have only two values
  • Text fields allow free user text without any data validations, but cannot be used to display options to user

Security and Access

  • For users to have access to the custom table in the app, a security role must be assigned to it
  • To share a model-driven app, a security role must be assigned to a user when sharing the app
  • When sharing a canvas app, a co-owner can be selected
  • Navigating to the details page will give the user the location of the app, but it will not grant any permissions to the user
  • If the user has not already been granted permission, they will get an error message when they load the Power Apps app

Microsoft Power Platform

  • Microsoft Power Platform offers many prebuilt connectors
  • In scenarios where you need to integrate with a custom web application, you have the option to build a custom connector to connect to the custom APIs for data exchange
  • Dataverse connector is a prebuilt connector in Microsoft Power Platform that is used to interact with Dataverse data
  • Excel Online (Business) connector is a prebuilt connector in Microsoft Power Platform that is used to connect and work only with Excel files in document libraries supported by Microsoft Graph
  • Business process flows are guided UI flows in model-driven apps for streamlined data entry

Azure Cognitive Services

  • Azure Cognitive Services can analyze images and extract printed and handwritten text from the image
  • Azure Cognitive Services has multiple connectors for Microsoft Power Platform
  • Azure Blob storage has a connector, but it is used for storing and accessing files, not analyzing the contents of the files

Data Policies

  • Data policies prevent an app or a flow from connecting to two different data sources that may allow data to be accessed or copied outside of the organization
  • Microsoft Entra ID conditional access can control when a user can access a Power Apps app using various signals such as location and device
  • The Microsoft Power Platform CoE toolkit will enable monitoring of the apps, flows, and connectors used within your organization

Auditing

  • Auditing in Microsoft Dataverse captures changes to data in Microsoft Dataverse tables
  • Auditing does not prevent data leakage

Portal Apps

  • A portal app, using the Partner portal template, allows users to register themselves for your portal app web site
  • The knowledge management feature in the app can be used to allow suppliers to read documentation from the company

Test your knowledge on Microsoft Power Platform connectors by answering questions related to selecting the appropriate connector for reading text from uploaded images, preventing external leakage of corporate data, and more.

Make Your Own Quizzes and Flashcards

Convert your notes into interactive study material.

Get started for free

More Quizzes Like This

Use Quizgecko on...
Browser
Browser