Salesforce Data-Architect Question Answers

Question # 41

A company has 12 million records, and a nightly integration queries these records. Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.) 

A. Make sure the query doesn't contain NULL in any filter criteria. 
B. Create a formula field instead of having multiple filter criteria. 
C. Create custom indexes on the fields used in the filter criteria. 
D. Modify the integration users' profile to have View All Data. 

Show / Hide Answer

---

Question # 42

UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years. Which 2 solutions should a data architect recommend in order to minimize performance and storage issues? Choose 2 answers: 

A. Export data out of salesforce and store in Flat files on external system. 
B. Create a custom object to store case history and run reports on it. 
C. Leverage on premise data archival and build integration to view archived data. 
D. Leverage big object to archive case data and lightning components to show archived data. 

Show / Hide Answer

---

Question # 43

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 data duplication standards and rules 
B. Define key fields in staging database for data cleansing 
C. Measure data timeliness and consistency
 D. Finalize an extract transform load (ETL) tool for data migration 
E. Measure data completeness and accuracy 

Show / Hide Answer

---

Question # 44

Universal Containers has a large number of Opportunity fields (100) that they want to track field history on. Which two actions should an architect perform in order to meet this requirement? Choose 2 answers 

A. Create a custom object to store a copy of the record when changed. 
B. Create a custom object to store the previous and new field values.
 C. Use Analytic Snapshots to store a copy of the record when changed. 
D. Select the 100 fields in the Opportunity Set History Tracking page. 

Show / Hide Answer

---

Question # 45

North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly. Which two native tools should a data architect recommend to achieve this reporting requirement? 

A. Standard reports and dashboards 
B. Async SOQL with a custom object 
C. Standard SOQL queries 
D. Einstein Analytics 

Show / Hide Answer

---

Question # 46

Universal Containers (UC) uses the following Salesforce products: Sales Cloud for customer management. Marketing Cloud for marketing. Einstein Analytics for business reporting. UC occasionally gets a list of prospects from third-party source as comma-separated values (CSV) files for marketing purposes. Historically, UC would load contact Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process. What should a data architect recommend to UC in order to immediately avoid storage issues in the future? 

A. Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications ; 
B. Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications. 
C. Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers. 
D. Continue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales after the sync is complete. 

Show / Hide Answer

---

Question # 47

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? 

A. Use Salesforce Object Query Language. 
B. Use a data definition language. 
C. Use an entity relationship diagram. 
D. Use the Salesforce Metadata API. 

Show / Hide Answer

---

Question # 48

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: 

A. Create a 2nd system Admin user for authentication to the external source.
 B. Develop an object relationship strategy. 
C. Identify the external tables to sync into external objects 
D. Assess whether the external data source is reachable via an ODATA endpoint. 
E. Configure a middleware tool to poll external table data 

Show / Hide Answer

---

Question # 49

Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce? 

A. Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.
 B. Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit. 
C. Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters. 
D. Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down. 

Show / Hide Answer

---

Question # 50

As part of a phased Salesforce rollout. there will be 3 deployments spread out over the year. The requirements have been carefully documented. Which two methods should an architect use to trace back configuration changes to the detailed requirements? Choose 2 answers 

A. Review the setup audit trail for configuration changes.
 B. Put the business purpose in the Description of each field. 
C. Maintain a data dictionary with the justification for each field. 
D. Use the Force.com IDE to save the metadata files in source control. 

Show / Hide Answer

---

<123456789>

---

Download All 257 Questions Check Customers Feedbacks