Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

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
[All AZ-204 Questions]

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 Hide Answer
Suggested Answer:
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.
Reference:
https://docs.microsoft.com/en-us/azure/service-bus-messaging/topic-filters

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
stylebc
Highly Voted 3 years, 11 months 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 145 times
ferut
3 years, 5 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
2 years, 4 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
2 years, 4 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
2 years, 4 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 2 times
...
Mal22002
2 years, 4 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 2 times
...
...
TEMPKAKAM
Highly Voted 3 years, 11 months ago
The Correct answers are: No Filter Correleation Filter SQL filter SQL filter SQL filter
upvoted 40 times
Christian_garcia_martin
2 months, 3 weeks ago
no sense at all , you want future filters and do nothing? , you want all the orders and you apply filter?
upvoted 1 times
...
rashjan
3 years, 11 months ago
Why a filter for all orders?
upvoted 3 times
MrNair007
3 years, 10 months 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
3 years, 10 months 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 24 times
danielcr
3 years, 8 months ago
So.. The answer is correct.
upvoted 3 times
...
...
TakumaK
3 years, 5 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
1 year, 10 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
3 years, 8 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 13 times
...
...
ns4098
Most Recent 4 weeks, 1 day ago
Final Answer: FutureOrders: SQLFilter HighPriorityOrders: CorrelationFilter InternationalOrders: SQLFilter HighQuantityOrders: SQLFilter AllOrders: No Filter
upvoted 1 times
...
Christian_garcia_martin
2 months, 3 weeks ago
copilot : for futures ---> correlation, highpriority , internal , hightQuantity -------> SQLFilter all --------------------> no filter
upvoted 1 times
...
gebpt
3 months, 3 weeks ago
1) SQL 1=0 2) SQL 3) SQL 4) SQL 5) No filter - takes all
upvoted 1 times
...
neelkanths
5 months, 3 weeks 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 6 times
...
jobolesonihal
7 months ago
Given answer is correct.
upvoted 2 times
...
raymond_abcd
8 months, 4 weeks 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
9 months, 4 weeks ago
- No Filter - Correlation - Correlation - SQL Filter - SQL Filter
upvoted 1 times
...
lednari
10 months, 3 weeks 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
...
leviatas
1 year ago
Got this quesiton in examn, went with answer. - 2023.09.25. Got Case Study Contoso
upvoted 3 times
...
longnguyendh
1 year, 2 months ago
It should be SQL, Correlation, SQL, SQL and NO Filter
upvoted 2 times
...
applepie
1 year, 2 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
1 year, 2 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
11 months ago
How do you remember all 375 questions?
upvoted 3 times
...
...
DavidDev
1 year, 6 months ago
CorrelationFilter SqlFilter SqlFilter SqlFilter filterType
upvoted 2 times
...
Videira
1 year, 7 months ago
On my exam 2023-02-25
upvoted 3 times
...
kandrew5
1 year, 7 months ago
Priotity should have a Correlation filter according to the example in Microsoft documentation: https://learn.microsoft.com/en-us/azure/service-bus-messaging/topic-filters
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...