Posted: 28 Apr 2020 15:20 EDT Last activity: 14 Jun 2021 7:38 EDT
Report filter query
I came across below questions while preparing for PCBA. Can anyone help with the answer?
1) A report needs to filter records whose location is either NewYork or Boston. Which of below will be a right answer?
a. Location = Newyork OR Boston
b. Location = Newyork OR Location=Boston
2) Scenario: In an online grocery shopping, user selects Membership Type, enters zip code to pull up city, state etc., and adds any special instructions for the delivery person. What will be the datasource for these fields?
Membership Type - Pega DB or Local DB or No DB
Address - Pega DB or Local DB or No DB
Instructions - Pega DB or Local DB or No DB
Based on my understanding, i am assuming answer is Membership Type - Local DB Address - Pega DB Instructions - No DB. Is this correct?
1) The option would be A for this as we can select multiple values in a single filter condition.
2) I think Membership type would be stored in Pega DB as we might need this value in future cases, Address details would be stored in Local Storage(DataType) as we need to populate values based on Zip Code and instructions would be only for that particular case, so no DB save is required for this.