Practice with Plat-Arch-201 Dumps for Application Architect Certified Exam Questions & Answer [Q109-Q130]

NO.109 Which feature controls record-level access?

Profiles

Permission Sets

Sharing Rules

Roles only

NO.110 UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance. Which 3 recommendations should a data architect provide to prevent ownership skew? Choose 3 answer

Assigned a default user as owner of accounts, and assign role in hierarchy.

Keep users out of public groups that can be used as the source for sharing rules.

Assign a default user as owner of account and do not assign any role to default user.

Assign “view all” permission on profile to give access to account.

Assign a default user as owner of accounts and assigned top most role in hierarchy.

NO.111 A shipping and logistics company has created a large number of reports within Sales Cloud since Salesforce was introduced. Some of these reports analyze large amounts of data regarding the whereabouts of the company’s containers, and they are starting to time out when users are trying to run the reports. What is a recommended approach to avoid these time-out issues?

Improve reporting performance by creating a custom Visualforce report that is using a cache of the records in the report.

Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.

Improve reporting performance by creating an Apex trigger for the Report object that will pre- fetch data before the report is run.

Improve reporting performance by creating a dashboard that is scheduled to run the reports only once per day.

NO.112 Which API should a data architect use if exporting 1 million records from Salesforce?

Bulk API

REST API

Streaming API

SOAP API

NO.113 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?

Lookup Field on Project_c to VTOTime_c displaying a list of VTOTime__c in a related list.

Lookup field on VTOTime_c to Project_c with formula filed on Project__ c showing Sum of hours from VTOTime__c records.

Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project __c showing sum of hours from VTOTime_c records.

Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.

NO.114 Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintain two years of data in Saleforce and archive older data out of Salesforce. Which solution should a data architect recommend as an archiving solution?

Use a third-party backup solution to backup all data off platform.

Build a batch join move all records off platform, and delete all records from Salesforce.

Build a batch join to move two-year-old records off platform, and delete records from Salesforce.

Build a batch job to move all restore off platform, and delete old records from Salesforce.

NO.115 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 answer

Use hard delete in Bulk API to permanently delete records from Salesforce.

Use hard delete in batch Apex to permanently delete records from Salesforce.

Identify records in objects that have not been modified or used In last 3 years.

Use Rest API to permanently delete records from the Salesforce org.

Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.

NO.116 Universal Container (US) is replacing a home-grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis. Which solution should a data architect recommend to meet business requirement?

Leverage real-time integration to pull records into Salesforce.

Bring all data Salesforce, and delete it after a year.

Leverage mashup to display historical records in Salesforce.

Build a chair solution to go the legacy system and display records.

NO.117 A health care provider wishes to use salesforce to track patient care. The following actions are in Salesforce
1. Payment Providers: Orgas who pay for the care 2 patients.
2. Doctors: They provide care plan for patients and need to support multiple patients, they are provided access to patient information.
3. Patients: They are individuals who need care.
A data architect needs to map the actor to Sf objects. What should be the optimal selection by the data architect?

Patients as Contacts, Payment providers as Accounts, & Doctors as Accounts

Patients as Person Accounts, Payment providers as Accounts, & Doctors as Contacts

Patients as Person Accounts, Payment providers as Accounts, & Doctors as Person Account

Patients as Accounts, Payment providers as Accounts, & Doctors as Person Accounts

NO.118 Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?

After the data is migrated, perform an update on all records to set the original date in a standard Created Date field.

Create a new field on the Contact object to capture the Created Date. Hide the standard Created Date field using Field -Level Security.

Enable “Set Audit Fields” and assign the permission to the user loading the data for the duration of the migration.

Write an Apex trigger on the Contact object, before insert event to set the original value in a standard Created Date field.

NO.119 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?

Archive Case data using Salesforce Archiving process

Purchase more data storage to support case object

Use a custom object to store archived case data.

Use a custom Big object to store archived case data.

NO.120 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?

Use AppExchange package for backup and restore.

Use ETL for backup and restore from EDW.

Use Bulk API to extract data on daily basis to EDW and REST API for restore.

Change weekly backup process to daily backup, and implement a custom restore solution.

NO.121 Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?

Extract the Salesforce data into Excel and manually compare this against the trusted source.

Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

Leave the data in Salesforce alone and assume that it will auto-correct itself over time.

NO.122 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 answer

Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.

Schedule reports that will automatically catch duplicates and merge or delete the records every week.

Store all data in an external system and set up an integration to Salesforce for view -only access.

NO.123 What is the best tool for analyzing SOQL query performance?

Debug Logs

Query Plan Tool

Workbench

Data Loader

NO.124 Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of
10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce.
Which approach for data archiving is appropriate for this scenario?

1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.

1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.

1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.

1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.

NO.125 Universal Containers has a public website with several forms that create Lead records in Salesforce using the REST API. When designing these forms, which two techniques will help maintain a high level of data quality?

Do client-side validation of phone number and email field formats.

Prefer picklist form fields over free text fields, where possible.

Ensure the website visitor is browsing using an HTTPS connection.

Use cookies to track when visitors submit multiple forms.

NO.126 Which two best practices should be followed when using SOSL for searching?

Use searches against single Objects for greater speed and accuracy.

Keep searches specific and avoid wildcards where possible.

Use SOSL option to ignore custom indexes as search fields are pre-indexed.

Use Find in “ALL FIELDS” for faster searches.

NO.127 Which API is best for loading millions of records asynchronously?

REST API

SOAP API

Bulk API

Streaming API

NO.128 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 are exported during data export?

Set a standard profile for Data Migration user, and assign view encrypted data

Create another field to copy data from encrypted field and use this field in export

Leverage Apex class to decrypt data before exporting it.

Set up a custom profile for data migration user and assign view encrypted data.

NO.129 Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?

Use triggers to populate denormalized related fields on the Account.

Use an indexed data field with bounded data filters.

Use Formula fields to surface information I related entities on the report.

Use unbounded date ranges to filter the report.

NO.130 A company needs a many-to-many relationship between Account and Custom Object. What should they use?

Lookup relationship

Master-detail relationship

Junction object

External object