Designing Data Structures for SeeTheWorld Travel Company's Power Platform Solution

Correct Answer: A

Dataverse provides the three types of tables (entities): Standard - this is a usual custom table type user can create.

These tables store data and navigation for model-driven apps.

Activity - this is a special custom table type for storing activity information like appointments, phone calls, emails, tasks, etc.

Virtual - this custom table type has columns that bring data from external sources, like Azure SQL Database or Azure Cosmos DB.To store activity information, like a journal, you need to use an activity table type (Number 1)

This type creates columns that help you store the journal data, such as start and end time, date.

Also, Dataverse provides columns to capture the activity purpose, like subject and description.

When you create a table, there is a check box for the Enable attachments option (Number 2)

If you check the box, the app will store multiple files or notes for each journal record.

Options B and F are incorrect because a virtual table brings data from an external source that is not applicable in thiscase.

Options C and E are incorrect because you need to use an activity table type instead of a standard custom table.

Option D is incorrect because if you add the Attachment column, you can attach only one file to the journal record instead of several.

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

For the travel journal functionality, there are two main entities to consider - the journal events and the attachments.

For the journal events, an activity table would be the most suitable option. An activity table is a special type of table in Dataverse that has a predefined set of fields, such as Subject, Description, Start Time, End Time, and Owner. These fields are commonly used for tracking activities such as appointments, tasks, and phone calls.

Since the journal events are essentially a type of activity, it makes sense to use an activity table for this purpose. In addition, activity tables have the option to enable attachments, which means that users can attach files to each journal entry.

Therefore, the correct answer is either A or D.

For the attachments, it would be best to use a separate table to store them. This is because attachments can take up a lot of storage space, and it's important to keep them separate from the journal event data.

There are two options for creating this table. The first option is to create a custom table with an additional Attachment column. This column would be a file data type, which means it can store files such as images, documents, and videos. The Attachment column would be related to the activity table, which means that each attachment would be associated with a specific journal event.

The second option is to create a virtual table with an additional Attachment column. A virtual table is a type of table that doesn't have its own storage, but instead retrieves data from other tables. In this case, the virtual table would retrieve data from the activity table and the Attachment table. The Attachment column in the virtual table would be related to the Attachment table, which means that each attachment would be associated with a specific journal event.

Therefore, the correct answer is either B, C, or F.

In summary, the most suitable option for the journal events is either A or D (one activity table with enable attachments option), while the most suitable option for the attachments is either B, C, or F (one virtual table with enabled attachments option or one custom table with an additional Attachment column).