QV_Developer_01 Exam Dumps | A customer has an Addresses table with the fields. CustomerNumber, CustomerName, AddressLine1, AddressLine2,

<< Prev Question

Question 50/50

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 or CA}, AddressLine1=, AddressLine2=, City=, StateCode=, PostalCode=>} distinct CustomerNumber)

B. count({$<CountryCode={US, CA}, Addresses.*=>} distinct CustomerNumber)

C. count({$<CountryCode={US, CA}, AddressLine1=, AddressLine2=, City=, StateCode=, PostalCode=>} distinct CustomerNumber)

D. count({$<(CountryCode={US} or CountryCode={CA}), AddressLine1=, AddressLine2=, City=, StateCode=, PostalCode=>} distinct CustomerNumber)

E. count({1<CountryCode={US, CA}, CustomerName=CustomerName, CustomerNumber=CustomerNumber>} distinct CustomerNumber)

Question 50/50

LEAVE A REPLY

Download PDF File