Salesforce Certified Platform Data Architect : Plat-Arch-201 Exam

Northern Trail Outfitters (NTO) wants to capture a list of customers that have bought a particular product. The solution architect has recommended to create a custom object for product, and to create a lookup relationship between its customers and its products.
Products will be modeled as a custom object (NTO_ Product__ c) and customers are modeled as person accounts. Every NTO product may have millions of customers looking up a single product, resulting in a lookup skew.
What should a data architect suggest to mitigate Issues related to lookup skew?

• A. Change the lookup relationship to master-detail relationship.
• B. Create a custom object to maintain the relationship between products and customers.
• C. Select Clear the value of this field option while configuring the lookup relationship.
• D. Create multiple similar products and distribute the skew across those products.

Northern Trail Outfitters <NTO> is streaming IoT data from connected devices to a cloud database. Every 24 hours. 100,000 records are generated.
NIO employees will need to see these lol records within Salesforce and generate weekly reports on it. Developers may also need to write programmatic logic to aggregate the records and incorporate them into workflows.
Which data pattern will allow a data architect to satisfy these requirements, while also keeping limits in mind?

• A. Persistence
• B. Virtualization
• C. Unidirectional integration
• D. Bidirectional integration

A casino is implementing salesforce and is planning to build a customer 360 view for a customer who visits its resorts. The casino currently maintained the following systems that records customer activity:
1. Point of sales system: All purchases for a customer.
2. Salesforce: All customer service activity and sales activity for a customer.
3. Mobile app: All bookings, preferences and browser activity for a customer.
4. Marketing: All email, SMS and social campaigns for a customer.
Customer service agents using salesforce would like to view the activities from all system to provide supports to customers. The information has to be current and real time.
What strategy should the data architect implement to satisfy this requirement?

• A. Use a customer data mart to view the 360 view of customer.
• B. Explore external data sources in salesforce to build 360 view of customer.
• C. Periodically upload summary information in salesforce to build 360 view.
• D. Migrate customer activities from all 4 systems into salesforce.

A Salesforce customer has plenty of data storage. Sales Reps are complaining that searches are bringing back old records that aren't relevant any longer. Sales Managers need the data for their historical reporting. What strategy should a data architect use to ensure a better user experience for the Sales Reps?

• A. Create a Permission Set to hide old data from Sales Reps.
• B. Archive and purge old data from Salesforce on a monthly basis.
• C. Use Batch Apex to archive old data on a rolling nightly basis.
• D. Set data access to Private to hide old data from Sales Reps.

A national nonprofit organization is using Salesforce to recruit members. The recruitment process requires a member to be matched with a volunteer opportunity. Given the following:
1. A record is created in Project__ c and used to track the project through completion.
2. The member may then start volunteering and is required to track their volunteer hours, which is stored in VTOTime_c object related to the project.
3. Ability to view or edit the VTOTime__c object needs to be the same as the Project__ c record.
4. Managers must see total hours volunteered while viewing the Project__ c record.
Which data relationship should the data architect use to support this requirement when creating the custom VTOTime__c object?

• A. Lookup Field on Project_c to VTOTime_c displaying a list of VTOTime__c in a related list.
• B. Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.
• C. Lookup field on VTOTime_c to Project_c with formula filed on Project__ c showing Sum of hours from VTOTime__c records.
• D. Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project __c showing sum of hours from VTOTime_c records.