Solution removes all rows with null values, which can lead to significant data loss, especially if those rows contain important information.
It may compromise data quality by eliminating rows, which can impact analysis and insights.

In Dynamics 365 Sales, when setting up a unit group, you must first define the base unit. This is the fundamental unit of measurement for a product and serves as the foundation for defining related units within the group.
For the battery manufacturer, defining a base unit (such as a single battery) is necessary before configuring related units for boxes of 12 and cases of 24 boxes, as these will be multiples or related units derived from the base unit.
Reference: Microsoft Documentation - Create Unit Groups and Units
Exam Topic Breakdown
Exam Topic Number of Questions
Topic 1 : Terra Flora 44
Topic 2 : Contoso Ltd.Background information 10
Topic 3 : Misc Questions 80
TOTAL 134
Topic 1, Terra Flora
Background information
Terra Flora, Incorporated is a boutique pet hotel that has been in business for six (6) months. The hotel guests include both dogs and cats.
The founder created the Dynamics 365 Sales Professional environment to grow their network and pipeline.
They started out using out-of-the-box capabilities only and using the Sales Professional app only. Only one environment (production) is in use.
The pet hotel is gaining in popularity and the number of bookings is growing. The founder has shifted their focus to customizing their environment to record the information they need to delight their customers by tailoring the experience to their unique pets.
Terra Flora has recently hired a part-time carer for the resident pets. The carer has been granted the Salesperson security role to allow them to record new leads and update customer information.
You are a Dynamics 365 Customer Experience consultant who has been hired to assist Terra Nova with their customizations, resolve issues, and advise on best designs to meet their requirements.
Overall configurations
To better understand their four-legged customers, Terra Flora has created a custom Portable, which is user- owned and related 1 -n with the Contact table, which represents the pets ' primary owner.
The Per table has been added to the Sales Professional app sitemap. The table has the following columns, each created WITHOUT making any changes to the advanced options.

A pet sub-grid has been added to the Contact main form, using the Active Pets view.
Additionally, Read, Write, and Update, Append, Append To, and Assign access to the Pet table has been added to the Salesperson security role.
" Onboard new pet " business process flow
The founder is creating a business process flow named Onboard new pet to ensure that appropriate information is recorded for all new pets, starting with ensuring the correct litter choices are selected for cats who will be staying at Terra Flora.
When the Onboard new pet business process flow is done, the founder wants to have access to a view that will display all active pets including the Name and Type columns, as well as the current stage on the Onboard new pet business process flow.
Pet table icon
A custom image svg file has been created for the Portable.
Terra Flora wants to ensure this image is displayed alongside the pet page within the app.
Related Pet table activities
Terra Flora wants carers to be able to see their pets ' activity history, as well as add new activities related to their pets. They want the following information to appear on their pets ' timeline:
* Tasks carers completed or should do,
* E-mails exchanged with pet ' s owner (customer).
* A record of phone calls.
Other types of activities should NOT appear to users on the Pets forms.
The founder edited the Pet table advanced setting to enable associating Pet records with activities. The founder also added Pet table to the app sitemap that i being used.
Attachments are enabled for the tfeftable, including notes and files. But users should NOT see posts in the pet
' s activity timeline.
Post configuration is NOT enabled for the Pet table.
Logs
Auditing, log access, and read logs have been enabled in the production environment Auditing has started on the Terra Flora environment and has been enabled for common entities.
Breed galas
To celebrate their upcoming first year in operation, the founder is planning a series of breed galas. The series begins with a Corgi dog breed meet-up gala.
The breed of an owner ' s pet may be mentioned in many places within the system, including:
1. Emails (subject or body)
2. Notes (including Word documents exports of PDFs uploaded as attachments)
3. Single or multiple lines of text columns on any standard table (including lead, contact and opportunity at minimum)
4. On the Pet table in either the Description or in the Breed columns.
Additionally, the breed may be referenced in several ways including singular, multiple, shorthand (for example: corgi, corgis, or corgs), and may have been misspelled.
Corgi meet-up gala
The carer needs to be assigned ownership of several Contact records (representing customers that own Corgis) that live nearby so that event flyers can be delivered personally. When the carer is delivering flyers, they need to quickly check the owner and related pet information on their phone.
When the Contact records are assigned to carer, any pets that are related to these contacts via the primary owner relationship should also be assigned to the carer.
The founder has created a business process flow on the Portable named Corgi meet-up to allow Corgis to be registered as attending the gala. This business process flow is second in the default order on the Pet table. If the carer has a conversation with the owners, the carer is required to add notes to the timeline and complete the first stage of the business process flow.
Issues
Before the creation of the Pet table, information regarding pets was either added to the owner ' s Contact record in the form of notes or created as Contact records themselves.
These Contact records used the name of the pet in the Last Name column and the owner ' s address in the first set of Address columns.
When these pet Contact records are identified, they are deactivated.
No duplicate detection rules have been published and duplicate pet records are currently present across both the Contact and Pet tables.
Auditing
When a pet ' s dietary requirements or a Contact ' s email address is updated, Terra Flora requires the following information to be logged:
1. The user who made the change.
2. The current and previous values of the columns.
3. The time and dale of the changes.
Terra Flora also needs to track any exports of records to Microsoft Excel within the compliance center.
Relationship behavior
Recently, a pet owner informed Terra Flora that their pet cat has been rehomed.
After receiving this information, the carer deleted the owner ' s Contact record from the system, which in turn deleted the Pet record.
Shortly after, the new pet owner contacted Terra Flora to book their cat for a stay and was frustrated that Terra Flora had NOT retained a record of their cat ' s dietary requirements or any of the previous carer notes about the cat.
In such situations. Terra Flora now requires that the owner ' s Contact record should NOT be allowed to be deleted if any Pet records are related to it via the primary owner look-up column.
Users should be required to update the look-up column to new owner ' s Contact record or remove the current value first before they can delete the Pet record. If the new owner ' s Contact record is selected on a pet any active bookings against the pet should also be updated to the new owner, but previous inactive bookings should NOT be updated.
Business process flows and the Corgi meet-up gala
The founder has recently made an update to the Onboard new pet business flow but now CANNOT activate it.
For the Corgi gala, the founder has asked the carer for help in:
1. completing the registrations that the founder started, and
2. registering more Corgis for the upcoming gala.
When the carer creates new pet records, the carer is UNABLE to see the Corgi meet-up business process flow.
Currently, when the carer checks the owner ' s record on their phone, the related pet information is difficult to view as they must scroll down to review the information.

* Adding Columns to the Active Onboard New Pet View (Option B):
* To display the current active stage of the " Onboard new pet " business process flow, you need to ensure that the Active Onboard new pet view includes relevant columns from the Pet table, specifically those tracking process flow stages.
* Creating and Adding a New " Onboarding Stage " Column (Option D):
* Creating a column such as " Onboarding stage " on the Pet table helps track the active stage of the onboarding process directly within the view. This allows users to see at a glance which stage each pet is in without navigating away from the main view.
* Other Options:
* Option A (Adding a page) refers to modifying the app ' s navigation, which doesn't directly impact the visibility of the business process flow stage.
* Option C (All Onboard New Pet View) may not be as relevant if you only need to focus on active onboarding records rather than all records.
References from Microsoft Documentation:
* For configuring views and columns in Dynamics 365, refer to Create and edit views.

Configure table relationship cascading behavior
The CascadeConfiguration class or CascadeConfiguration complex type) contains the properties representing actions that may be performed on the referenced table in the one-to-many relationship. Each property can be assigned one of the values of the CascadeType enum type.
* Restrict
Prevent the Referenced table record from being deleted when referencing tables exist.
Incorrect:
* Cascade All
Perform the action on all referencing table records associated with the referenced table record.
* Cascade Active
Perform the action on all active referencing table records associated with the referenced table record.
* Remove Link
Remove the value of the referencing column for all referencing table records associated with the referenced table record.

Manager on System User Record:
Suggested contacts in Teams can include users directly linked to the individual starting the chat. The manager assigned on the user's system record can be a suggested contact, as this is a common relationship that suggests frequent communication.
Record Owner of the Initiating Record:
The owner of the record being discussed or acted upon is also likely to be a suggested contact. This is because the owner has primary responsibility for the record and would commonly need to be consulted or informed about actions related to it.
Created By of the Initiating Record:
If the user is the Created By for a record, they are associated with its initial setup or creation. As a result, they may be suggested when actions on that record are taken since they are familiar with its origins.
Reference:
These selections align with the rules typically used for suggesting contacts in integrated Teams chats, ensuring relevant parties are automatically suggested based on record associations and user relationships.