Name: Salesforce.Data-Architect.v2023-12-12.q117 Question 4
Brand: freecram
SKU: ae9dfa8849a51f0f
Price: 39.00 USD
Availability: InStock
Rating: 4.7 (2 reviews)

Valid Data-Architect Dumps shared by ExamDiscuss.com for Helping Passing Data-Architect Exam! ExamDiscuss.com now offer the newest Data-Architect exam dumps, the ExamDiscuss.com Data-Architect exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com Data-Architect dumps with Test Engine here:

Access Data-Architect Dumps Premium Version
(260 Q&As Dumps, 35%OFF Special Discount Code: freecram)

<< Prev Question Next Question >>

Question 4/117

Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.
Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

A. Change each address field to require on the Page Layout.

B. Write an Apex Trigger to require all fields to be populated.

C. Utilize a Validation Rule with a REGEX operator on Postal Code.

D. Utilize a Validation Rule with a CONTAINS operator on address fields.

Recent Comments (The most recent comments are at the top.)

Itay Eshet - Jun 13, 2024

D is correct because a custom address field can't be required, and even if it is on the page layout the state isn't (because most countries don't have values for the dependent picklist State). And CONTAINS is used instead of 9 (default) ISPICKVAL: TEXT(Home__CountryCode__s) != '' && TEXT(Home__StateCode__s) = '' && CONTAINS('AU,BR,CA,CN,IE,IN,IT,MX,US', TEXT(Home__CountryCode__s))

Sky - Apr 23, 2024

C D

IF(ISBLANK(BillingState), “None”,
IF(CONTAINS(“AK:AZ:CA:HA:ID:NV:OR:UT:WA”, TEXT(BillingStateCode)), “West”,
IF(CONTAINS(“AR:CO:MT:NM:OK:TX:WY”, TEXT(BillingStateCode)), “Southwest”,
IF(CONTAINS(“OH”, TEXT(BillingStateCode)), “Ohio”,
IF(CONTAINS(“CT:ME:MA:NH:NJ:NY:PA:RI:VT”, TEXT(BillingStateCode)), “Northeast”,
IF(CONTAINS(“DC:DE:KY:MD:NC:SC:TN:VA:WV”, TEXT(BillingStateCode)), “Mid-Atlantic”,
IF(CONTAINS(“AL:FL:GA:LA:MS”, TEXT(BillingStateCode)), “Southeast”,
IF(CONTAINS(“IL:IN:IA:KS:MI:MN:MO:NE:ND:SD:WI”, TEXT(BillingStateCode)), “Midwest”,
IF(CONTAINS(“AB:BC:MB:NB:NL:NS:NT:NU:ON:PE:QC:SK:YT”, TEXT(BillingStateCode)), “Canada”,
“Other”)))))))))

Question 4/117

Recent Comments (The most recent comments are at the top.)

LEAVE A REPLY

Download PDF File