Exam 70-767 topic 1 question 38 discussion

Actual exam question from Microsoft's 70-767

Question #: 38
Topic #: 1

You have a data quality project that focuses on the Products catalog for the company. The data includes a product reference number.
The product reference should use the following format: Two letters followed by an asterisk and then four or five numbers. An example of a valid number is
XX*55522. Any reference number that does not conform to the format must be rejected during the data cleansing.
You need to add a Data Quality Services (DQS) domain rule in the Products domain.
Which rule should you use?

A. value matches pattern ZA*9876[5]
B. value matches pattern AZ[*]1234[5]
C. value matches regular expression AZ[*]1234[5]
D. value matches pattern [a-zA-Z][a-zA-Z]*[0-9][0-9] [0-9][0-9] [0-9]?

Show Suggested Answer

Suggested Answer: A 🗳️
For a pattern matching rule:
Any letter (A"¦Z) can be used as a pattern for any letter; case insensitive
Any digit (0"¦9) can be used as a pattern for any digit
Any special character, except a letter or a digit, can be used as a pattern for itself
Brackets, [], define optional matching

Example: ABC:0000 -
This rule implies that the data will contain three parts: any three letters followed by a colon (:), which is again followed by any four digits.

by mrinmai at Feb. 10, 2020, 9:23 a.m.

Comments

Submit Cancel

Dieter

Highly Voted 5 years, 2 months ago

Answer A is correct. Please refer to : https://docs.microsoft.com/en-us/sql/data-quality-services/create-a-domain-rule?view=sql-server-ver15. There you find examples for the matching patterns.

upvoted 6 times

...

mrinmai

Highly Voted 5 years, 4 months ago

I think It should be D

upvoted 5 times

Yuri1101

5 years, 2 months ago

Using the regular expression, D is correct. But A is the correct answer using the matching pattern.

upvoted 7 times

...

UsefJuan

Most Recent 4 years, 5 months ago

A is the one

upvoted 1 times

...

DudeHere

4 years, 7 months ago

Answer is A: For a pattern matching rule: Any letter (A…Z) can be used as a pattern for any letter; case insensitive Any digit (0…9) can be used as a pattern for any digit Any special character, except a letter or a digit, can be used as a pattern for itself Brackets, [], define optional matching https://techcommunity.microsoft.com/t5/sql-server-integration-services/pattern-matching-in-dqs-domain-rules/ba-p/388103

upvoted 2 times

...

Slava_bcd81

4 years, 8 months ago

the only difference between A and D is that A rejects letters "a-z", only capitals, so its hard to choose as its not clearly specified by the question, I think I would choose rather D

upvoted 1 times