Connectors, Dataverse, AI Builder and Other
43 Questions
81 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What features are only available in Microsoft Dataverse?

  • Mobile offline
  • NoSQL storage
  • File and image support
  • Multiple currency support (correct)

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

  • Choice (correct)
  • Choices
  • Text
  • Yes/No

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

  • Choice (correct)
  • Yes/No
  • Choices
  • Autonumber

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

    <p>Select a user and assign privileges</p> Signup and view all the answers

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

    <p>Custom connector</p> Signup and view all the answers

    What is a feature of a canvas app?

    <p>Control functionality with Microsoft Power Fx formulas</p> Signup and view all the answers

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

    <p>AI Builder</p> Signup and view all the answers

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

    <p>AI Builder</p> Signup and view all the answers

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

    <p>Data loss prevention (DLP) policy</p> Signup and view all the answers

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

    <p>Microsoft Cognitive Services</p> Signup and view all the answers

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

    <p>Create data policies</p> Signup and view all the answers

    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?

    <p>Expression</p> Signup and view all the answers

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

    <p>Portal app</p> Signup and view all the answers

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

    <p>Canvas app</p> Signup and view all the answers

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

    <p>Choice field</p> Signup and view all the answers

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

    <p>Custom connector</p> Signup and view all the answers

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

    <p>Mobile offline</p> Signup and view all the answers

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

    <p>A security role must be assigned to the user when sharing the app</p> Signup and view all the answers

    Match the following terms with their correct descriptions:

    <p>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</p> Signup and view all the answers

    Match the following statements with the correct Microsoft Dataverse features:

    <p>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</p> Signup and view all the answers

    Match the following actions with the correct requirements:

    <p>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</p> Signup and view all the answers

    Match the following connectors with their specific functionalities:

    <p>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</p> Signup and view all the answers

    Match the following features with their correct descriptions:

    <p>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</p> Signup and view all the answers

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

    <p>primary key</p> Signup and view all the answers

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

    <p>multiple currencies</p> Signup and view all the answers

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

    <p>Choice</p> Signup and view all the answers

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

    <p>Choices</p> Signup and view all the answers

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

    <p>model-driven</p> Signup and view all the answers

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

    <p>Dataverse</p> Signup and view all the answers

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

    <p>Business process</p> Signup and view all the answers

    What is the primary key column in Microsoft Dataverse?

    <p>The primary key column is created when the table is created and uniquely identifies each row in the table.</p> Signup and view all the answers

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

    <p>The custom connector needs to be shared to allow other makers to use the connector in their apps and flows.</p> Signup and view all the answers

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

    <p>Policies on custom connectors are used to configure the connector at runtime, but they do not make the connector available for other makers.</p> Signup and view all the answers

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

    <p>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.</p> Signup and view all the answers

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

    <p>The Dataverse connector is a prebuilt connector in Microsoft Power Platform that is used to interact with Dataverse data.</p> Signup and view all the answers

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

    <p>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.</p> Signup and view all the answers

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

    <p>Business process flows are guided UI flows in model-driven apps for streamlined data entry, and cannot be used to interact with custom APIs.</p> Signup and view all the answers

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

    <p>The custom connector should be used in Microsoft Power Platform to connect to a custom web application's API for data exchange and automation.</p> Signup and view all the answers

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

    <p>True</p> Signup and view all the answers

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

    <p>False</p> Signup and view all the answers

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

    <p>True</p> Signup and view all the answers

    Microsoft Dataverse for Teams supports multiple currencies.

    <p>False</p> Signup and view all the answers

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

    <p>True</p> Signup and view all the answers

    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

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Description

    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.

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser