PL-400 Microsoft Exam Lab Questions

Pharmacy orders must be displayed in four graphs as follows:

Annual revenue over $100,000

Annual revenues under $100,000

Research facilities

Hospitals

The graphs must be interactive, and users must be able to drill down on any dimension.

When the account is entered into the system, extra fields must appear if the referral customer box is selected. If the box is not selected, the extra fields must not appear.

Note: By combining conditions and actions, you can do any of the following with business rules:

Set column values

Clear column values

Set column requirement levels

Show or hide columns

Enable or disable columns

Validate data and show error messages

Create business recommendations based on business intelligence.

Scenario: When the account is entered into the system, extra fields must appear if the referral customer box is selected. If the box is not selected, the extra fields must not appear.

Scenario: A trigger must be created that changes the Priority field to 1 in the Account record 10 days after an Account record is created.

DIFFINDAYS (date and time, date and time): Returns the difference in days between two Date and Time fields. If both dates and times fall on the same day, the difference is zero.

Note: Whenever we talk about history, the bone of contention are the below four fields:

CreatedOn

ModifiedOn

CreatedBy

ModifiedBy