Question 55 of 179 from exam AZ-204: Developing Solutions for Microsoft Azure

Question 55 of 179 from exam AZ-204: Developing Solutions for Microsoft Azure

Prev Question Next Question

Question

DRAG DROP - You are implementing an order processing system.

A point of sale application publishes orders to topics in an Azure Service Bus queue.

The Label property for the topic includes the following data:

Property Description ShipLocation the country/region where the order will be shipped Correlationid a priority value for the order Quantity a user-defined field that stores the quantity of items in an order AuditedAt a user-defined field that records the date an order is audited

The system has the following requirements for subscriptions:

Subscription type Comments FutureOrders This subscription is reserved for future use and must not receive any orders HighPriorityOrders Handle all high priority orders and international orders InternationalOrders Handle orders where the country/region is not United States HighQuantityOrders Handle only orders with quantities greater than 100 units AllOrders This subscription is used for auditing purposes. This subscription must receive every single order. AllOrders has an Action defined that updates the Auditedat property to include the date and time it was received by the subscription.

You need to implement filtering and maximize throughput while evaluating filters.

Which filter types should you implement? To answer, drag the appropriate filter types to the correct subscriptions.

Each filter type may be used once, more than once, or not at all.

You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Select and Place:

Filter types Answer Area orien Subscription Filter type CorrelationFilter : ai ale Nofilter —*| 4 HighPriorityOrders filter type ——————— InternationalOrders filter type HighQuantityOrders filter type AllOrders filter type

Explanations

Filter types ‘satfilter CorrelationFilter |No Filter Answer Area Subscription FutureOrders HighPriorityOrders InternationalOrders HighQuantityOrders AllOrders Filter type ‘saLFilter CorrelationFilter ‘saLFilter ‘satFitter

FutureOrders: SQLFilter - HighPriortyOrders: CorrelationFilter CorrelationID only - InternationalOrders: SQLFilter - Country NOT USA requires an SQL Filter HighQuantityOrders: SQLFilter - Need to use relational operators so an SQL Filter is needed.

AllOrders: No Filter - SQL Filter: SQL Filters - A SqlFilter holds a SQL-like conditional expression that is evaluated in the broker against the arriving messages' user-defined properties and system properties.

All system properties must be prefixed with sys.

in the conditional expression.

The SQL-language subset for filter conditions tests for the existence of properties (EXISTS), as well as for null-values (IS NULL), logical NOT/AND/OR, relational operators, simple numeric arithmetic, and simple text pattern matching with LIKE.

Correlation Filters - A CorrelationFilter holds a set of conditions that are matched against one or more of an arriving message's user and system properties.

A common use is to match against the CorrelationId property, but the application can also choose to match against ContentType, Label, MessageId, ReplyTo, ReplyToSessionId, SessionId, To, and any user-defined properties.

A match exists when an arriving message's value for a property is equal to the value specified in the correlation filter.

For string expressions, the comparison is case-sensitive.

When specifying multiple match properties, the filter combines them as a logical AND condition, meaning for the filter to match, all conditions must match.

Boolean filters - The TrueFilter and FalseFilter either cause all arriving messages (true) or none of the arriving messages (false) to be selected for the subscription.

https://docs.microsoft.com/en-us/azure/service-bus-messaging/topic-filters
Prev Question Next Question