Salesforce Data-Architect Question Answers

Question # 61

UC developers have created a new lightning component that uses an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a time-out error. What tool should a data architect use to identify why the query is taking too long?

 A. Use Splunk to query the system logs looking for transaction time and CPU usage. 
B. Enable and use the query plan tool in the developer console. 
C. Use salesforce’s query optimizer to analyze the query in the developer console. 
D. Open a ticket with salesforce support to retrieve transaction logs to e analyzed for processing time. 

Show / Hide Answer

---

Question # 62

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. Explore external data sources in salesforce to build 360 view of customer. 
B. Use a customer data mart to view the 360 view of customer. 
C. Migrate customer activities from all 4 systems into salesforce. 
D. Periodically upload summary information in salesforce to build 360 view. 

Show / Hide Answer

---

Question # 63

Universal Containers (UC) is expecting to have nearly 5 million shipments records in its Salesforce org. Each shipment record has up to 10 child shipment item records. The Shipment custom object has an Organization-wide Default (OWD) sharing model set to Private and the Shipment Item custom object has a Master-Detail relationship to Shipment. There are 25 sharing rules set on the Shipment custom object, which allow shipment records to be shared to each of UC's 25 business areas around the globe. These sharing rules use public groups, one for each business area plus a number of groups for management and support roles. UC has a high turnover of Sales Reps and often needs to move Sales Reps between business areas in order to meet local demand. What feature would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements?

 A. Implement data archiving for old Shipment records.
 B. Contact Salesforce to create Skinny tables on Shipment. 
C. Configure shipment OWD to Public Read/Write. 
D. Contact Salesforce to enable Defer Sharing Rules 

Show / Hide Answer

---

Question # 64

Universal Containers (UC) has deployed Salesforce to manage Marketing. Sales, and Support efforts in a multi -system ERP environment After reaching the limits of native reports & dashboards. UC leadership is looking to understand what options can be used to provide more analytical insights. What two approaches should an architect recommend? Choose 2 answers 

A. AppExchange Apps 
B. Wave Analytics 
C. Weekly Snapshots 
D. Setup Audit Trails 

Show / Hide Answer

---

Question # 65

UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled. What should a data architect recommend to ensure data quality is maintained in salesforce. 

A. Activate validation rules once the leads are loaded into salesforce to maintain quality. 
B. Allow validation rules to be activated during the load of leads into salesforce. 
C. Develop custom APEX batch process to improve quality once the load is completed. 
D. Ensure the lead data is preprocessed for quality before loading into salesforce. 

Show / Hide Answer

---

Question # 66

Universal Containers has millions of rows of data in Salesforce that are being used in reports to evaluate historical trends. Performance has become an issue, as well as data storage limits. Which two strategies should be recommended when talking with stakeholders? 

A. Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records. 
B. Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.
 C. Use Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records. 
D. Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits. 

Show / Hide Answer

---

Question # 67

UC is trying to switch from legacy CRM to salesforce and wants to keep legacy CRM and salesforce in place till all the functionality is deployed in salesforce. The want to keep data in synch b/w Salesforce, legacy CRM and SAP. What is the recommendation. 

A. Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place
B. Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP
C. Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce 
D. Suggest MDM solution and link MDM to salesforce and SAP 

Show / Hide Answer

---

Question # 68

Universal Containers has two systems. Salesforce and an on -premise ERP system. An architect 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? 

A. Implement a Master Data Management system to determine system of record. 
B. Implement a workflow rule that sends Opportunity data through Outbound Messaging. 
C. Have the ERP poll Salesforce nightly and bring in the desired Opportunities. 
D. Implement an hourly integration to send Salesforce Opportunities to the ERP system. 

Show / Hide Answer

---

Question # 69

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? 

A. Create a picklist field, values sorted alphabetically. 
B. Create a Master -Detail to custom object ShippingStatus c. 
C. Create a Lookup to custom object ShippingStatus c. 
D. Create a text field and make it an external ID. 

Show / Hide Answer

---

Question # 70

Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time? 

A. Load Contact records together using the Streaming API via the Upsert operation. 
B. Delete all existing records, and then load all records together via the Insert operation. 
C. Load all records via the Upsert operation to determine new records vs. existing records. 
D. Load new records via the Insert operation and existing records via the Update operation. 

Show / Hide Answer

---

<123456789>

---

Download All 257 Questions Check Customers Feedbacks