Salesforce Certified Platform Data Architect Free Dumps (Part 2, Q41-Q80) Are Also Available to Complete Your Certification Journey

1. Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce.

What are two automated approaches to fulfillthis goal? (Choose two.)

2. Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.

Which three recommendations should a data architect make is order to reduce the number of records from the org? Choose 3 answers

3. Universal Containers (UC) has implemented Sales Cloud for its entire sales organization, UC has built a custom object called projects_c that stores customers project detail and employee bitable hours.

The following requirements are needed:

A subnet of individuals from the finance team will need to access to the projects object for reporting and adjusting employee utilization.

The finance users will not access to any sales objects, but they will need to interact with the custom object.

Which license type a data architect recommend for the finance team that best meets the requirements?

4. (NTO) has multiple salesforce orgs based on geographical reports (AMER, EMEA, APAC). NTO products are in the AMER org and need to be created in the EMEA and APAC after the products are approved.

Which two features should a data architect recommend to share records between salesforce orgs? Choose 2.

5. A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delaysquerying parents order IDs in Salesforce before importing related order line items.

What is the recommended solution?

6. Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture? Choose 2 answers

7. Universal Containers (UC) is transitioning from Classic to Lightning Experience.

What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience?

8. A customer is operating in a highly reputated industry and is planning to implement SF.

The customer information maintained in SF, includes the following:

✑ Personally, identifiable information (PII)

✑ IP restrictions on profiles organized by Geographic location

✑ Financial records that need to be private and accessible only by the assigned Sales associate.

✑ User should not be allowed to export information from Salesforce.

Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity.

Which 3 Salesforce shield capabilities should a data architect recommend? Choose 3 answers:

9. 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.)

10. Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization.

Which two approaches should an architect recommend to enforce this new plan? Choose 2 answers

11. Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several optionsare being considered, including analytics snapshots, offsite storage, scheduled purges, etc.

Which three questions should be considered when designing an appropriate archiving strategy?

12. Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records.

What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues?

13. Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC.

Which two common techniques are used building a data dictionary to store information on how business entities are defined?

14. Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system- During analysis, UC users highlight a pain point that there are multiple versions of many customers.

What should the data architect do for a successful migration to mitigate the pain point?

15. US is implementing salesforce and will be using salesforce to track customer complaints, provide white papers on products and provide subscription (Fee) C based support.

Which license type will US users need to fulfil US’s requirements?

16. NTO has 1 million customer records spanning 25 years. As part of its new SF project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data.

Which 3activities will be required to identify a successful master data management strategy? Choose 3 answers:

17. Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce.

Which two design considerations should an architect take to minimize data duplication? Choose 2 answers

18. Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.

What should a data architect recommend for a daily backup and restore solution?

19. Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode.

What should an Architect consider when loading the Opportunity records?

20. For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load.

Which two recommended options assign Account ownership to mitigate potential performance problems?

21. Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, anditem color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce CustomerCommunity solution.

What is a correct technique UC should use to solve the data inconsistency?

22. Universal Containers has a requirement to store more than 100 million records in salesforce and needs to create a custom big object to support this business requirement.

Which two tools should a data architect use to build custom object?

23. Universal Containers (UC) is implementing Salesforce and will be using Salesforceto track customer complaints, provide white papers on products, and provide subscription-based support.

Which license type will UC users need to fulfill UC's requirements?

24. UC has multiple SF orgs that aredistributed across regional branches. Each branch stores local customer data inside its org’s Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.

UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all orgs in one place.

What should a data architect suggest to achieve this 360-degree view of the customer?

25. UC has millions of case records with case history and SLA data. UC’s compliance team would like historical cases to be accessible for 10 years for Audit purpose.

What solution should a data architect recommend?

26. An architect has been asked to provide errormessages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages.

What are two approaches the architect should use to achieve this solution? Choose 2 answers

27. A casino is implementing Salesforce and is planning to build a customer 360 degree view for a customer who visits its resorts.

The casino currently maintains the following systems that record customer activity:

1. Point-of-sale system: All purchases for a customer

2. Salesforce; All customer service activity and sales activities 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 Salesforee would like to view the activities from all four systems to provide support to customers. The information has to be current and real time.

What strategy should the data architect implement to satisfy this requirement?

28. To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce.

What common error should the data architect be aware of when using upsert?

29. What should a data architect do to provide additional guidance for users when they enter information in a standard field?

30. What is an advantage of using Custom metadata type over Custom setting?

31. UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported.

What should a data architect recommend to make sure decrypted values areexported during data export?

32. Universal Containers has two systems. Salesforce and an on -premise ERP system. Anarchitect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce.

What is the optimal real-time approach that achieves this solution?

33. Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records.

What would be the recommended approach to help UC start immediately?

34. Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records.

When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?

35. Universal Containers wants to implement a data -quality process to monitor the data that

users are manually entering into the system through the Salesforce UI.

Which approach should the architect recommend?

36. Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.

What should a data architect recommend to guarantee that records are not being updated at the same time?

37. Universal Containers (UC) has several custom Visualforce applications have been developed in which users are able to edit Opportunity records. UC struggles with data completeness on their Opportunity records and has decided to make certain fields requiredthat have not been in the past. The newly required fields are dependent on the Stage of the Opportunity, such that certain fields are only required once an Opportunity advances to later stages. There are two fields.

What is the simplest approach to handle this new requirement?

38. UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.

Which 3 recommendationsshould the data architect make to avoid the data skew? Choose 3 answers.

39. Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.

Which two approaches should an Architect recommend to enforce the plan throughout the organization? (Choose two.)

40. NTO processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not integrated with SF. The Sales team at NTO using Sales cloud and would like visibility into related customer orders yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate SF connect and the concept of data verification.

Which 3 considerations are needed prior to a SF Connect implementation? Choose 3 answers