Podcast
Questions and Answers
A company is evaluating the capabilities in Dataverse and the scenarios for using virtual tables. You need to identify the capabilities of virtual tables. What is a capability of virtual tables?
A company is evaluating the capabilities in Dataverse and the scenarios for using virtual tables. You need to identify the capabilities of virtual tables. What is a capability of virtual tables?
- Virtual tables can be configured for user and team ownership.
- Virtual tables retrieve data from an external data source. (correct)
- Virtual tables support Dataverse auditing.
- Virtual tables store data in the Dataverse environment.
Must contain string data that stores 100 characters and be rendered as a ______ control.
Must contain string data that stores 100 characters and be rendered as a ______ control.
multiline
Must contain a list of predefined options. Users must be able to select only one ______.
Must contain a list of predefined options. Users must be able to select only one ______.
option
A customer tracks events by using a custom entity. The custom entity includes a custom field for the venue of the events. The customer must be able to display the events by venue in a calendar. You need to ensure that all events display by venue in the calendar. To which component should you add a control?
A customer tracks events by using a custom entity. The custom entity includes a custom field for the venue of the events. The customer must be able to display the events by venue in a calendar. You need to ensure that all events display by venue in the calendar. To which component should you add a control?
You manage a new instance of Microsoft Dataverse. You need to create a new column for a custom table. The new column must have the schema name abc_income. What should you create first?
You manage a new instance of Microsoft Dataverse. You need to create a new column for a custom table. The new column must have the schema name abc_income. What should you create first?
A company that delivers training courses uses Microsoft Dataverse. The company wants to record course registration and attendance. The company configures a Contact table and a Course table. You need to create a relationship between the attendees and registrations. Which type of relationship should you create?
A company that delivers training courses uses Microsoft Dataverse. The company wants to record course registration and attendance. The company configures a Contact table and a Course table. You need to create a relationship between the attendees and registrations. Which type of relationship should you create?
A company runs regular events. You need to record who has attended each event. Which relationship should you create?
A company runs regular events. You need to record who has attended each event. Which relationship should you create?
An event planning company wants to capture information for each event. The captured information must include the contacts who attend the event and the capacity in which a contact attends, such as customer, vendor, supplier, or from marketing. You need to create a relationship between the records to capture this information. What should you implement?
An event planning company wants to capture information for each event. The captured information must include the contacts who attend the event and the capacity in which a contact attends, such as customer, vendor, supplier, or from marketing. You need to create a relationship between the records to capture this information. What should you implement?
You create a custom table and configure a child table relationship with the contact table. You need to configure the cascading rules for each action. Which behavior should you use?
You create a custom table and configure a child table relationship with the contact table. You need to configure the cascading rules for each action. Which behavior should you use?
You manage a Microsoft Dataverse instance for a company. The Dataverse instance has a one-to-many (1:N) relationship between a Teachers table and a Classes table. If a teacher record is deleted, the deletion must have no impact on the related class records. You need to configure the behavior of the tables. Which relationship behavior should you use?
You manage a Microsoft Dataverse instance for a company. The Dataverse instance has a one-to-many (1:N) relationship between a Teachers table and a Classes table. If a teacher record is deleted, the deletion must have no impact on the related class records. You need to configure the behavior of the tables. Which relationship behavior should you use?
A company uses Dataverse to store projects and project tasks. The Project table has a one-to-many relationship with the Project Tasks table. The Project Tasks table has a Due Date column. You need to create a column on the Project table that shows the earliest due date of the related project tasks. Which type of column should you create?
A company uses Dataverse to store projects and project tasks. The Project table has a one-to-many relationship with the Project Tasks table. The Project Tasks table has a Due Date column. You need to create a column on the Project table that shows the earliest due date of the related project tasks. Which type of column should you create?
You must schedule data to import automatically into Microsoft Dataverse. You need to define the days of the week to import the data and ensure that you are notified of any failures. Which tool should you use?
You must schedule data to import automatically into Microsoft Dataverse. You need to define the days of the week to import the data and ensure that you are notified of any failures. Which tool should you use?
You plan to create a dataflow to import data into Microsoft Dataverse by using Power Query. The dataflow has the following requirements: A table of aggregated data must be created in Dataflow storage.
• A unique identifier must be created for the table. You need to configure the Dataflow. Which solutions should you use?
You plan to create a dataflow to import data into Microsoft Dataverse by using Power Query. The dataflow has the following requirements: A table of aggregated data must be created in Dataflow storage. • A unique identifier must be created for the table. You need to configure the Dataflow. Which solutions should you use?
You plan to create a dataflow by using Power Query to transform the data. You observe that some cells display an error instead of the expected data. You need to obtain more details about the errors. What should you do?
You plan to create a dataflow by using Power Query to transform the data. You observe that some cells display an error instead of the expected data. You need to obtain more details about the errors. What should you do?
You use a dataflow to import data into Microsoft Dataverse. The data uses columns such as accountid, accountnumber, createdon, modifiedon, and versionnumber. The data must load in the least amount of time. You need to configure the incremental refresh settings for the Dataflow. Which columns should you use?
You use a dataflow to import data into Microsoft Dataverse. The data uses columns such as accountid, accountnumber, createdon, modifiedon, and versionnumber. The data must load in the least amount of time. You need to configure the incremental refresh settings for the Dataflow. Which columns should you use?
A company uses Dataverse to store the names of contacts. The company uses a shared Microsoft Excel file to collect the data. The company requires that the contacts be added to Dataverse automatically every day. You need to identify which tools are required to create and perform the import. What should you use?
A company uses Dataverse to store the names of contacts. The company uses a shared Microsoft Excel file to collect the data. The company requires that the contacts be added to Dataverse automatically every day. You need to identify which tools are required to create and perform the import. What should you use?
On a Contact record, a user creates a Note record that contains the word running. One week later, the user reports that they cannot find the Contact record associated with the Note record. You need to find the Note record. Use Categorized Search to search for the word run. Does the solution meet the goal?
On a Contact record, a user creates a Note record that contains the word running. One week later, the user reports that they cannot find the Contact record associated with the Note record. You need to find the Note record. Use Categorized Search to search for the word run. Does the solution meet the goal?
On a Contact record, a user creates a Note record that contains the word running. One week later, the user reports that they cannot find the Contact record associated with the Note record. You need to find the Note record. Use Relevance Search to search for the word run. Does the solution meet the goal?
On a Contact record, a user creates a Note record that contains the word running. One week later, the user reports that they cannot find the Contact record associated with the Note record. You need to find the Note record. Use Relevance Search to search for the word run. Does the solution meet the goal?
On a Contact record, a user creates a Note record that contains the word running. One week later, the user reports that they cannot find the Contact record associated with the Note record. You need to find the Note record. Use Quick Find search on the Notes list to search for the word run. Does the solution meet the goal?
On a Contact record, a user creates a Note record that contains the word running. One week later, the user reports that they cannot find the Contact record associated with the Note record. You need to find the Note record. Use Quick Find search on the Notes list to search for the word run. Does the solution meet the goal?
You modify a model-driven app for a bicycle repair help desk. The model-driven app is for help desk users when customers have an issue with their bicycle. After you add a custom table named bicycle, you configure the table for Microsoft Dataverse search. The table will contain information from callers about their bicycles. The account table is related to the custom table. Contact information is brought over to the custom table. You add the following columns to the table: Bicycle type Tire brand Special equipment Users must be able to perform the following types of searches: Search for all customers who have a bicycle type of Contoso and live in Florida. Search all tables for any record that contains the word broken. You need to decide which type of search will give you the results desired. Which search should you configure?
You modify a model-driven app for a bicycle repair help desk. The model-driven app is for help desk users when customers have an issue with their bicycle. After you add a custom table named bicycle, you configure the table for Microsoft Dataverse search. The table will contain information from callers about their bicycles. The account table is related to the custom table. Contact information is brought over to the custom table. You add the following columns to the table: Bicycle type Tire brand Special equipment Users must be able to perform the following types of searches: Search for all customers who have a bicycle type of Contoso and live in Florida. Search all tables for any record that contains the word broken. You need to decide which type of search will give you the results desired. Which search should you configure?
A company is implementing a data model by using Dataverse. The company requires the following columns in a new custom table:
Column Name
Special Notes
Specification
Must contain string data that stores 100 characters and be rendered as a multiline control.
Student
Must contain string data that stores up to 8,000 characters and be rendered as a multiline control.
Course Type
Must contain an input control that can store a reference to an account or a contact in the system.
Requirement
Must contain a list of predefined options. Users must be able to select only one option.
You need to choose the column type that uses the least amount of database storage for each column. Which column types should you choose?
A company is implementing a data model by using Dataverse. The company requires the following columns in a new custom table:
| Column Name | Special Notes |
|---|---|
| Specification | Must contain string data that stores 100 characters and be rendered as a multiline control. |
| Student | Must contain string data that stores up to 8,000 characters and be rendered as a multiline control. |
| Course Type | Must contain an input control that can store a reference to an account or a contact in the system. |
| Requirement | Must contain a list of predefined options. Users must be able to select only one option. |
| You need to choose the column type that uses the least amount of database storage for each column. Which column types should you choose? |
You create a parent entity and a child entity. The parent entity has a 1:N relationship with the child entity. You need to ensure that when the owner changes on the parent record that all child records are assigned to the new owner. You need to configure the relationship behavior type. What should you use?
You create a parent entity and a child entity. The parent entity has a 1:N relationship with the child entity. You need to ensure that when the owner changes on the parent record that all child records are assigned to the new owner. You need to configure the relationship behavior type. What should you use?
An event planning company wants to capture information for each event. The captured information must include the following:
- contacts who attend the event
- the capacity in which a contact attends, such as customer, vendor, supplier, or from marketing
You need to create a relationship between the records to capture the information. What should you implement?
An event planning company wants to capture information for each event. The captured information must include the following:
- contacts who attend the event
- the capacity in which a contact attends, such as customer, vendor, supplier, or from marketing You need to create a relationship between the records to capture the information. What should you implement?
A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps. The Dataverse environment contains a table that has the following columns: Name * Company * Contacted On. The company requires that the table not contain any duplicate rows when users create data in the environment. You need to implement a solution that meets the requirement. Solution: Create an alternate key for the columns. Does the solution meet the goal?
A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps. The Dataverse environment contains a table that has the following columns: Name * Company * Contacted On. The company requires that the table not contain any duplicate rows when users create data in the environment. You need to implement a solution that meets the requirement. Solution: Create an alternate key for the columns. Does the solution meet the goal?
A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps. The Dataverse environment contains a table that has the following columns: Name * Company * Contacted On The company requires that the table not contain any duplicate rows when users create data in the environment. You need to implement a solution that meets the requirement. Solution: Create a duplicate detection rule for the columns. Does the solution meet the goal?
A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps. The Dataverse environment contains a table that has the following columns: Name * Company * Contacted On The company requires that the table not contain any duplicate rows when users create data in the environment. You need to implement a solution that meets the requirement. Solution: Create a duplicate detection rule for the columns. Does the solution meet the goal?
A company uses a Microsoft Power Platform environment. The company plans to implement a Power Apps app. The application must meet the following requirements: Audit all user activity and only retain the audit logs for one year. Annually remove products that were created over a year ago. You need to configure the automated processes. What should you configure?
A company uses a Microsoft Power Platform environment. The company plans to implement a Power Apps app. The application must meet the following requirements: Audit all user activity and only retain the audit logs for one year. Annually remove products that were created over a year ago. You need to configure the automated processes. What should you configure?
You manage a Microsoft Dataverse instance. You need to create a custom bulk deletion job that deletes workflow records from the Async OperationBase table. The records must have been created in the last seven days and successfully completed. Which system job type should you select in the condition?
You manage a Microsoft Dataverse instance. You need to create a custom bulk deletion job that deletes workflow records from the Async OperationBase table. The records must have been created in the last seven days and successfully completed. Which system job type should you select in the condition?
You must create a new entity to support a new feature for an app. Records for the entity must be associated with a business unit and specify security roles for the business unit. You need to configure entity/table ownership. Which entity ownership type should you use?
You must create a new entity to support a new feature for an app. Records for the entity must be associated with a business unit and specify security roles for the business unit. You need to configure entity/table ownership. Which entity ownership type should you use?
You are designing the organization structure for a company that has 5,000 users. You need to configure security roles for the company while minimizing administrative effort. What should you do?
You are designing the organization structure for a company that has 5,000 users. You need to configure security roles for the company while minimizing administrative effort. What should you do?
You create an app for the sales team at a company. Members of the sales team cannot access the app. You need to ensure that sales team members can access the app. Where should you configure app permissions?
You create an app for the sales team at a company. Members of the sales team cannot access the app. You need to ensure that sales team members can access the app. Where should you configure app permissions?
A user has access to an existing Common Data Service database. You need to ensure that the user can create canvas apps that consume data from Dataverse. You must not grant permissions that are not required. Which out-of-the-box security role should you assign to the user?
A user has access to an existing Common Data Service database. You need to ensure that the user can create canvas apps that consume data from Dataverse. You must not grant permissions that are not required. Which out-of-the-box security role should you assign to the user?
A user has access to an existing Microsoft Dataverse database. You need to ensure that the user can create canvas apps that consume data from Dataverse. You must not grant permissions that are not required. Which out-of-the-box security role should you assign to the user?
A user has access to an existing Microsoft Dataverse database. You need to ensure that the user can create canvas apps that consume data from Dataverse. You must not grant permissions that are not required. Which out-of-the-box security role should you assign to the user?
A user needs to create a Power Apps portal app. The user is getting a permission denied error when creating the portal app. You need to configure permissions to create the portal app. Which three permissions should you configure? Each correct answer presents part of the solution.
A user needs to create a Power Apps portal app. The user is getting a permission denied error when creating the portal app. You need to configure permissions to create the portal app. Which three permissions should you configure? Each correct answer presents part of the solution.
A company uses Microsoft Power Platform in its Microsoft 365 tenant. The company requires specific users to manage environments within the tenant. You need to configure security for the tenant. What should you use? Select only one answer.
A company uses Microsoft Power Platform in its Microsoft 365 tenant. The company requires specific users to manage environments within the tenant. You need to configure security for the tenant. What should you use? Select only one answer.
A user requires access to a customized environment. The following error appears when you attempt to add the user: "User couldn't be added because they haven't met all of the access requirements." You need to identify the issue. Which three issues can cause this error? Each correct answer presents a complete solution.
A user requires access to a customized environment. The following error appears when you attempt to add the user: "User couldn't be added because they haven't met all of the access requirements." You need to identify the issue. Which three issues can cause this error? Each correct answer presents a complete solution.
You are a Dynamics 365 Customer Services administrator. You have a Production instance and Sandbox instance. Users record Production instance data in the Sandbox instance. You need to ensure that the users only record data in the Production instance. Which security function needs to be edited to prevent access to the Sandbox?
You are a Dynamics 365 Customer Services administrator. You have a Production instance and Sandbox instance. Users record Production instance data in the Sandbox instance. You need to ensure that the users only record data in the Production instance. Which security function needs to be edited to prevent access to the Sandbox?
A company uses a canvas app to manage production resources in a specific region. Employees must be at company locations to use the app. Due to a sudden requirement for employees to work remotely, employees no longer commute to a specific location to conduct their work and cannot access the canvas app. You must reconfigure the app to ensure that employees only access the app from a limited number of locations. You need to restrict access to the app. Which components should you configure?
A company uses a canvas app to manage production resources in a specific region. Employees must be at company locations to use the app. Due to a sudden requirement for employees to work remotely, employees no longer commute to a specific location to conduct their work and cannot access the canvas app. You must reconfigure the app to ensure that employees only access the app from a limited number of locations. You need to restrict access to the app. Which components should you configure?
A company uses Microsoft Dataverse. Users often must share account records with team members. You create a team template for the account table to begin setup for a simplified record sharing process. What should you do next?
A company uses Microsoft Dataverse. Users often must share account records with team members. You create a team template for the account table to begin setup for a simplified record sharing process. What should you do next?
You use Microsoft Entra ID Group teams to handle user security access to a Microsoft Dataverse application. You need to set up security group teams within Dataverse and apply security roles to them. What should you use to set up the team record in Dataverse?
You use Microsoft Entra ID Group teams to handle user security access to a Microsoft Dataverse application. You need to set up security group teams within Dataverse and apply security roles to them. What should you use to set up the team record in Dataverse?
A company uses a Dataverse table named Milestones to store project milestone information. You need to ensure that only users in the Project Managers team can view data in the Milestone status column. Which three configuration steps should you perform? Each correct answer presents part of the solution.
A company uses a Dataverse table named Milestones to store project milestone information. You need to ensure that only users in the Project Managers team can view data in the Milestone status column. Which three configuration steps should you perform? Each correct answer presents part of the solution.
Users must be able to view only the address1 columns in the Account table. You need to ensure other address columns are not visible to users when creating views and filters. What should you do?
Users must be able to view only the address1 columns in the Account table. You need to ensure other address columns are not visible to users when creating views and filters. What should you do?
You need to recommend a role for users to perform several required tasks. The solution must use the principle of least privilege. Which roles should you recommend?
You need to recommend a role for users to perform several required tasks. The solution must use the principle of least privilege. Which roles should you recommend?
A company has a sales application that is supported by an Azure SQL database. You are developing a Power Apps app for use by customer service agents. The app must reference customer data from the sales application. Data in the sales application is constantly changing and must not be replicated in Microsoft Dataverse. Some customer data is considered sensitive. You must protect data for specific fields when users view data in the app. You need to configure table creation for the app. How should you configure the app?
A company has a sales application that is supported by an Azure SQL database. You are developing a Power Apps app for use by customer service agents. The app must reference customer data from the sales application. Data in the sales application is constantly changing and must not be replicated in Microsoft Dataverse. Some customer data is considered sensitive. You must protect data for specific fields when users view data in the app. You need to configure table creation for the app. How should you configure the app?
Flashcards
What are Virtual Tables?
What are Virtual Tables?
A type of Dataverse table that retrieves data from an external data source, not stored within Dataverse.
What is the most efficient Dataverse column type for short text?
What is the most efficient Dataverse column type for short text?
The smallest storage type for text that can hold a single line of text.
What is the best Dataverse column type for longer notes?
What is the best Dataverse column type for longer notes?
This column type in Dataverse can store multiple lines of text, making it suitable for longer descriptions or notes.
What is a 1:N relationship in Dataverse?
What is a 1:N relationship in Dataverse?
Signup and view all the flashcards
What is an N:N relationship in Dataverse?
What is an N:N relationship in Dataverse?
Signup and view all the flashcards
What is a 'Parental' relationship behavior in Dataverse?
What is a 'Parental' relationship behavior in Dataverse?
Signup and view all the flashcards
What is a 'Restrict Delete' relationship behavior in Dataverse?
What is a 'Restrict Delete' relationship behavior in Dataverse?
Signup and view all the flashcards
What are 'Calculated' columns in Dataverse?
What are 'Calculated' columns in Dataverse?
Signup and view all the flashcards
What are 'Rollup' columns in Dataverse?
What are 'Rollup' columns in Dataverse?
Signup and view all the flashcards
What are 'Formula' columns in Dataverse?
What are 'Formula' columns in Dataverse?
Signup and view all the flashcards
What is 'Managing Dataverse Search'?
What is 'Managing Dataverse Search'?
Signup and view all the flashcards
What is 'Categorized Search' in Dataverse?
What is 'Categorized Search' in Dataverse?
Signup and view all the flashcards
What is 'Relevance Search' in Dataverse?
What is 'Relevance Search' in Dataverse?
Signup and view all the flashcards
What is 'Auditing' in Dataverse?
What is 'Auditing' in Dataverse?
Signup and view all the flashcards
What is the 'Data Import Wizard' in Dataverse?
What is the 'Data Import Wizard' in Dataverse?
Signup and view all the flashcards
What is 'Duplicate Detection' in Dataverse?
What is 'Duplicate Detection' in Dataverse?
Signup and view all the flashcards
What is 'Bulk Deletion' in Dataverse?
What is 'Bulk Deletion' in Dataverse?
Signup and view all the flashcards
What are 'Business Units' in Dataverse?
What are 'Business Units' in Dataverse?
Signup and view all the flashcards
What are 'Security Roles' in Dataverse?
What are 'Security Roles' in Dataverse?
Signup and view all the flashcards
What is 'Role Management' in Dataverse?
What is 'Role Management' in Dataverse?
Signup and view all the flashcards
What is 'User and Team Management' in Dataverse?
What is 'User and Team Management' in Dataverse?
Signup and view all the flashcards
What are 'Microsoft Entra ID Group Teams' in Dataverse?
What are 'Microsoft Entra ID Group Teams' in Dataverse?
Signup and view all the flashcards
What is 'Column Security,' in Dataverse?
What is 'Column Security,' in Dataverse?
Signup and view all the flashcards
What is 'Hierarchy Security' in Dataverse?
What is 'Hierarchy Security' in Dataverse?
Signup and view all the flashcards
What is 'Manager Hierarchy' in Dataverse?
What is 'Manager Hierarchy' in Dataverse?
Signup and view all the flashcards
What are 'Web Roles' in Dataverse Portals?
What are 'Web Roles' in Dataverse Portals?
Signup and view all the flashcards
Study Notes
Dataverse Management
- Dataverse is a platform for managing data models. It allows for creating and modifying standard, activity, and virtual tables.
- Virtual tables can retrieve data from external sources, be configured for user and team ownership, and are not for storing Dataverse data.
- Custom tables require specific column types for optimal storage efficiency. For example,
Special Notesshould useText Area, andSpecificationshould useMultiline Text. - Customer (Lookup) type allows for relationship with an account or a contact, but not both.
- Tables can be created or modified in Dataverse. A custom entity field for a venue can be used in a calendar for display.
- A new column's schema name (e.g.,
abc_income) needs to be created first in a solution. - Publisher prefixes are determined by the solution's publisher. Solutions are created before the column, and the prefix varies based on the solution's publisher.
Relationships
- One-to-many (1:N) relationships are appropriate for scenarios where a record in one table can relate to multiple records in another table.
- Many-to-many (N:N) relationships are appropriate when multiple records in one table can relate to multiple records in another table.
- In some cases, separate 1:N relationships are used to capture details of attendance for a given event/class or course that a student attends.
- Referential, Restrict delete - Ensures that when a parent record is deleted, the child records are not deleted
- Referential, Remove link - Allows the relationship to be maintained if one record is deleted and the other is kept.
- Parental - Ensures parent record deletion impacts all child records.
Data Import and Scheduling
- Dataflows are tools to schedule data imports into Dataverse. Dataflows include capabilities for incremental refresh and failure notifications.
- Scheduled cloud flows can be used to set specific days for imports but do not inherently provide failure notification.
- Instant cloud flows run when a trigger is activated; they are not suitable for scheduled imports.
Security and Roles
System Customizersecurity role allows enabling or disabling auditing and managing data security.- Dataverse auditing tracks changes and can be used for tracking and managing security policies.
- Security roles define access levels;
Environment AdminandSystem Customizerhave broad access. - Column-level security is used to control which users can view specific columns in a table.
- A
Business Unitis used to relate/associate a record to a group or team.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Related Documents
Description
Explore the fundamentals of Dataverse management, including the creation and modification of tables, understanding virtual tables, and the importance of custom columns. This quiz will test your knowledge on data models, relationships, and best practices for efficient data storage.
