Northern Trail Outfitters has these simple requirements for a data export process:
- File format should be in CSV.
- Process should be scheduled and run once per week.
- The expert should be configurable through the Salesforce UI.
Which tool should a data architect leverage to accomplish these requirements?

• A. Data loader
• B. Data export wizard
• C. Third-party ETL tool
• D. Bulk API

Cloud Kicks is launching a Partner Community, which will allow users to register shipment requests that are then processed by Cloud Kicks employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped.
First, Cloud Kicks will introduce its community to 6,000 customers in North America, and then to
24,000 customers worldwide within the next two years. Cloud Kicks expects 12 shipment requests per week per customer, on average, and wants customers to be able to view up to three years of shipment requests and use Salesforce reports.
What is the recommended solution for the Cloud Kicks Data Architect to address the requirements?

• A. Create a custom object to track shipment requests with five lookup custom fields for each item being shipped Implement an archiving process that moves data off-platform after three years.
• B. Create a custom object to track shipment requests and a child custom object to track shipment items. Implement an archiving process that moves data off-platform after three years.
• C. Create an external custom object to track shipment requests with five lookup custom fields for each item being shipped. External objects are stored off-platform in Heroku's Postgres database.
• D. Create an external custom object to track shipment requests and a child external object to track shipment items. External objects are stored off-platform in Heroku's Postgres database.

Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answer

• A. Schedule a weekly export file from the Salesforce UI.
• B. Use the Force.com Workbench to export the data.
• C. Schedule jobs to export and delete using the Data Loader.
• D. Schedule jobs to export and delete using an ETL tool.

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?

• A. Patients as Accounts, Payment providers as Accounts, & Doctors as Person Accounts
• B. Patients as Person Accounts, Payment providers as Accounts, & Doctors as Person Account
• C. Patients as Contacts, Payment providers as Accounts, & Doctors as Accounts
• D. Patients as Person Accounts, Payment providers as Accounts, & Doctors as Contacts

UC has large amount of orders coming in from its online portal. Historically all order are assigned to a generic user. Which 2 measures should data architect recommend to avoid any performance issues while working with large number of order records? Choose 2 answer

• A. Create a pool of generic users and distribute the assignment of memory to the pool of users.
• B. Clear the role field in the generic user record.
• C. Salesforce handles the assignment of orders automatically and there is no performance impact.
• D. Create a role at top of role hierarchy and assign the role to the generic user.