Create a Survey Table

Four Steps for Creating a Survey Table

Question

Please select the four steps you should take when you create a Survey table.

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D. E. F. G.

Correct Answers: B, D, G and H

Dataverse identifies the two types of relationships between tables: One-to-Many (1:N) and Many-to-Many (N:N)

A One-to-Many relationship is a Parent-Child relationship, like between a company and its employees.

A Many-to-Many relationship is when multiple records from one table have the relationship with the multiple records in another table and vice versa.

When users create a Many-to-Many relationship, Dataverse creates a specific intersect matching table between the records in two tables.

After you create an N:N relationship, you cannot edit records in both tables.

Connections are a special case for the Many-to-Many relationships.

They are flexible and don't have the limitations of the N:N relationship.

The Survey table has a relationship with three tables: RentCenters, Customers, CarFleet.

Every record in a Survey table has the lookup field for the rent center code or name, the customer id, and information about the car: car id, type, make, and model.

The Survey table has a Many-to-One relationship between all three tables.

When we want to extend information from the parent table, we can create a mapping between tables.

As a result, the mapped field will be copied to the related table, like car type, make, and model from the CarFleet table.

Options B is correct because we need to create a One-to-Many relationship between Customers and the Survey table or Many-to-One from the Survey table.

Options D and G are correct because we need to create One-to-Many relationships between CarFleet and Survey tables and between RentCenters and Survey tables.

Option H is correct because we need to map the fields from the CarFleet table into the Survey table.

You can view the mappable columns in the classic interface (Number 1) for the entity (Number 2) and 1:N Relationships (Number 3)

The Type (Number 4) drop-down helps to filter the mappable table and columns (Number 5).

Hi = Power Apps

File 4 Publish All Customizations
Order Product
Ey a3 1:N Relationships

Solution Northwind Traders Type: Mappable ~ ©

bl Information
3 Components

acd New 1-to-Many Relationship * More Actions ~

« Bkntities Schema Name * Primary Entity Related Entity Type of Behavior Field Name State Customizable Fi
Lg Customer

F:) Employee
F- Inventory Transaction

@ Invoice nwind_orderdetails_nwind_products_5 Order Product Order Detail Referential Product 6 Unmanaged True

nwind_inventorytransactions_nwind_products_0 Order Product Inventory Transaction Referential Product Unmanaged True

Lap Order

Lg Order Detail
4 |g Order Product

3) Forms
& Views
ply Charts

& Fields

cal Keys
ex 1:N Relationships @
55 N:1 Relationships

33 N:N Relationships

2) nwind_purchaseorderdetails_nwind_products_12 Order Product Purchase Order Detail Referential Product Unmanaged True

All other options are incorrect.

For more information about the Dataverse types of table relationship, please visit the below URLs:

When creating a Survey table, there are a few steps that should be taken to ensure that the table is properly configured and integrated into your data model. Here are the four steps that should be taken:

B. Create N:1 relationship between Survey and Customers tables This step is important because it establishes a relationship between the Survey table and the Customers table. Specifically, it creates a many-to-one relationship where multiple surveys can be associated with a single customer. This relationship will allow you to easily analyze survey responses by customer, which is often an important metric for businesses.

D. Create 1:N relationship between CarFleet and Survey tables This step is important because it establishes a relationship between the Survey table and the CarFleet table. Specifically, it creates a one-to-many relationship where a single car in the CarFleet table can be associated with multiple surveys in the Survey table. This relationship will allow you to easily analyze survey responses by car, which is often an important metric for fleet management.

E. Create 1:1 relationship between RentCenters and Survey tables This step is important because it establishes a one-to-one relationship between the RentCenters and Survey tables. This type of relationship ensures that there is only one survey associated with each rent center. This relationship is useful when you need to ensure that survey data is properly tracked and managed by location.

H. Create a mapping between Survey and CarFleet tables This step is important because it establishes a mapping between the Survey table and the CarFleet table. This mapping allows you to associate specific survey responses with specific cars in the fleet. This relationship is useful when you need to track customer satisfaction by car type, or when you need to identify specific cars that are causing issues for customers.

Note: A and F are not relevant to the creation of a Survey table. A connection between Survey and CarFleet tables may be useful, but it is not a necessary step in creating a Survey table. Similarly, a mapping between Survey and Customers tables may be useful, but it is not a necessary step in creating a Survey table. Finally, a 1:N relationship between RentCenters and Survey tables (option G) would not be as useful as a 1:1 relationship between those tables.