QV_Developer_01 Free Dumps Study Materials
Question 9: A customer has an Addresses table with the fields. CustomerNumber, CustomerName,
AddressLine1, AddressLine2, City, StateCode, PostalCode, and CountryCode.
A designer needs to design a chart to show a count of distinct customers in which the customer's
CountryCode is US or CA, while ignoring all selections on the Addresses table except the
CustomerNumber and CustomerName fields.
How can the designer calculate the required value?
A. count({$<CountryCode={US, CA}, Addresses.*=>} distinct CustomerNumber)
B. count({$<CountryCode={US, CA}, AddressLine1=, AddressLine2=, City=, StateCode=, PostalCode=>}
distinct CustomerNumber)
C. count({1<CountryCode={US, CA}, CustomerName=CustomerName,
CustomerNumber=CustomerNumber>} distinct CustomerNumber)
D. count({$<CountryCode={US or CA}, AddressLine1=, AddressLine2=, City=, StateCode=,
PostalCode=>} distinct CustomerNumber)
E. count({$<(CountryCode={US} or CountryCode={CA}), AddressLine1=, AddressLine2=, City=,
StateCode=, PostalCode=>} distinct CustomerNumber)
Correct Answer: B