Exam AZ-204 All Questions

View all questions & answers for the AZ-204 exam

Exam AZ-204 topic 3 question 16 discussion

Actual exam question from Microsoft's AZ-204

Question #: 16
Topic #: 3

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:

The system has the following requirements for subscriptions:

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:

Show Suggested Answer

Suggested Answer:

by jishnujrk at Nov. 15, 2020, 1:04 p.m.

Comments

Submit Cancel

stylebc

Highly Voted 5 years ago

I think that it should be -Correlation Filter (with the not existing value of any filed to avoid getting any message) -SQL filter (as we need to get all high priority AND international orders, but for Correlation filter: A match exists when an arriving message's value for a property is equal to the value specified in the correlation filter and we need not equal) -SQL filter -SQL filter -No Filter

upvoted 148 times

Mal22002

3 years, 6 months ago

HighPriorityOrders: CorrelationFilter You can apply to multiple system or user-defined properties and when multiple properties then filter combined them with AND logical operator. https://docs.microsoft.com/en-us/azure/service-bus-messaging/topic-filters 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 the following properties: ContentType Label MessageId ReplyTo ReplyToSessionId SessionId To 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.

upvoted 3 times

6c7d59c

1 week, 4 days ago

But in correlation filters you have to use only equality, right? So you cannot do something like shipLocation != 'usa'. Then I think it should be sqlFilter

upvoted 1 times

...

ferut

4 years, 6 months ago

FutureOrder, not based on the property -> Correlation Filter. AllOrders, it's clear.. no filter. The rest is based on one or more properties --> SQL filter I agree with @stylebc

upvoted 16 times

...

Mal22002

3 years, 6 months ago

How do you justify No Filter for All Orders when you need to take action? Each newly created topic subscription has an initial default subscription rule. If you don't explicitly specify a filter condition for the rule, the applied filter is the true filter that enables all messages to be selected into the subscription. The default rule has no associated annotation action https://docs.microsoft.com/en-us/azure/service-bus-messaging/topic-filters

upvoted 1 times

Mal22002

3 years, 6 months ago

Check this example with Action which is a requirement for AllOrders. https://docs.microsoft.com/en-us/azure/service-bus-messaging/service-bus-filter-examples#net-example-for-creating-subscription-filters

upvoted 1 times

...

Mal22002

3 years, 6 months ago

FutureOrders should be SQLFilter as you can check with the condition on AuditedAt user's property or EnqueuedTimeUtc system property but that is required a greater than condition but correlation filter condition needs to be matched. 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. https://docs.microsoft.com/en-us/azure/service-bus-messaging/topic-filters

upvoted 3 times

...

Load full discussion...

...

TEMPKAKAM

Highly Voted 5 years ago

The Correct answers are: No Filter Correleation Filter SQL filter SQL filter SQL filter

upvoted 40 times

rashjan

5 years ago

Why a filter for all orders?

upvoted 3 times

MrNair007

5 years ago

See the basic is subscription does not have filter then does not receive any data. And since all orders needs all the orders it should have SQL filter with 1=1 so that all orders are passed to it.

upvoted 2 times

brtx

5 years ago

https://docs.microsoft.com/en-us/azure/service-bus-messaging/topic-filters "If you don't explicitly specify a filter condition for the rule, the applied filter is the true filter that enables all messages to be selected into the subscription."

upvoted 25 times

danielcr

4 years, 9 months ago

So.. The answer is correct.

upvoted 3 times

...

TakumaK

4 years, 6 months ago

if no filter explicitly specified, the true filter will be assigned which enables ALL messages. So your comment is wrong and makes confused.

upvoted 11 times

...

JustHereToLearn

2 years, 11 months ago

I somewhat agree with this answer after going through lot of resources. The only thing that bothers me is answer for the first and last question. When you create a subscription by default a SQL filter is added which is 1=1 i.e. always evaluates to true. So my source of confusion is how "No Filter" is treated. I have two interpretations either "No Filter" is we don't add any filter or the other is absence of a filter. Mostly I believe it is treated as absence of a filter in which case the this answer looks correct.

upvoted 2 times

...

cbn

4 years, 9 months ago

How do you justify Correlation Filter for HighPriorityOrders, when it involves Region <> US ? I think it should be SQL filter as well.

upvoted 14 times

...

Christian_garcia_martin

1 year, 4 months ago

no sense at all , you want future filters and do nothing? , you want all the orders and you apply filter?

upvoted 1 times

...

nm347

Most Recent 4 hours, 41 minutes ago

ChatGPT - SQL, Correlation , SQL, SQL , No filter

upvoted 1 times

...

vizay

7 months ago

So, what's the best option to block everything? Use an SQLFilter like: 1 = 0 This is always false, guaranteed — and it will never allow any messages through.

upvoted 2 times

...

wafa_chaari

10 months ago

Given answer is correct

upvoted 1 times

...

Mattt

1 year, 1 month ago

The given answer is correct

upvoted 1 times

...

ns4098

1 year, 2 months ago

Final Answer: FutureOrders: SQLFilter HighPriorityOrders: CorrelationFilter InternationalOrders: SQLFilter HighQuantityOrders: SQLFilter AllOrders: No Filter

upvoted 2 times

...

Christian_garcia_martin

1 year, 4 months ago

copilot : for futures ---> correlation, highpriority , internal , hightQuantity -------> SQLFilter all --------------------> no filter

upvoted 1 times

...

gebpt

1 year, 5 months ago

1) SQL 1=0 2) SQL 3) SQL 4) SQL 5) No filter - takes all

upvoted 3 times

...

neelkanths

1 year, 7 months ago

Got it on 20 April 2024...Marks > 900...All questions from examtopics 400 questions... went with below answer based on the example given on microsoft learn....go with it...scored very good marks may be highest with these answers -SQL filter -Correlation Filter -SQL filter -SQL filter -No Filter

upvoted 7 times

...

jobolesonihal

1 year, 8 months ago

Given answer is correct.

upvoted 2 times

...

raymond_abcd

1 year, 10 months ago

Missing the Boolean filter option in the possible answers. Because that would be the one to choose for the future order rule. Otherwise I think you can choose SQL filter or correlation filter for the future order by making the condition always filter out all messages. The other ones I agree with the given answers.

upvoted 1 times

...

emysa341

1 year, 11 months ago

- No Filter - Correlation - Correlation - SQL Filter - SQL Filter

upvoted 1 times

...

lednari

1 year, 12 months ago

Just tested this in azure portal - No filter (if default sql 1=1 filter is removed) results in no messages - sql filter 1=0 can be used for same purpose - sql filter 1=1 will match everything and is the default when adding a subscription Therefore: No filter Sql (need to match hi pri AND international orders) Sql Sql Sql (default 1=1)

upvoted 4 times

...

longnguyendh

2 years, 3 months ago

It should be SQL, Correlation, SQL, SQL and NO Filter

upvoted 2 times

...

applepie

2 years, 4 months ago

got this question today, go with answer - Correlation Correlation SQL SQL No filter 7/30/2023, score 895/1000

upvoted 2 times

...

NightshadeRC

2 years, 4 months ago

Had this question today: 2023-07-26 I went: - Correlation Filter - SQL Filter - SQL Filter - SQL Filter - No Filter Every question on the exam was on ExamTopics. I entered every recommended answer and got 940

upvoted 10 times

Ciupaz

2 years ago

How do you remember all 375 questions?

upvoted 4 times

...

Load full discussion...