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?

• A.1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.
• B.1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.
• C.1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.
• D.1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?

• A.Use GZIP compression to export the data.
• B.Utilize the Bulk API to export the data.
• C.Schedule a Batch Apex job to export the data.
• D.Use the SOAP API to export data.

Comment: *

Name: *

Email: *

Verification: *

UC is building a salesforce application to track contacts and their respective conferences that they have attended with the following requirements:
1. Contacts will be stored in the standard contact object.
2. Conferences will be stored in a custom conference__c object.
3. Each contact may attend multiple conferences and each conference may be related to multiple contacts.
How should a data architect model the relationship between the contact and conference objects?

• A.Create a master detail relationship field on the Conference object.
• B.Implement a Contact Conference junction object with master detail relationship to both contact and conference__c.
• C.Create a lookup relationship field on contact object.
• D.Create a master detail relationship field on the Contact object.

Comment: *

Name: *

Email: *

Verification: *

UC has to built a B2C ecommerce site on Heroku that shares customer and order data with a Heroku Postgres database. UC is currently utilizing Postgres as the single source of truth for both customers and orders. UC has asked a data architect to replicate the data into salesforce so that salesforce can now act as the system of record.
What are the 3 considerations that data architect should weigh before implementing this requirement? Choose 23 answers:

• A.Determine if the data is driver of key process implemented within salesforce.
• B.Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application.
• C.A selection of the tool required to replicate the data.
  a. - Heroku Connect is required but this is confusing
• D.Ensure the data is CRM center and able to populate standard of custom objects.
• E.Consider whether the data is required for sales reports, dashboards and KPI's.

Comment: *

Name: *

Email: *

Verification: *

NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.
Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:

• A.Define key fields in staging database for data cleansing
• B.Measure data completeness and accuracy
• C.Measure data timeliness and consistency
• D.Define data duplication standards and rules
• E.Finalize an extract transform load (ETL) tool for data migration

Comment: *

Name: *

Email: *

Verification: *