Salesforce Data-Architect Question Answers

Question # 31

DreamHouse Realty has a Salesforce org that is used to manage Contacts. What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.)

 A. Use the private sharing model. 
B. Use Salesforce duplicate management.
 C. Use validation rules on new record create and edit.
 D. Use workflow to delete duplicate records. 

Show / Hide Answer

---

Question # 32

Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers

 A. Analytics/BI Owners 
B. Data Domain Stewards 
C. Salesforce Administrators
 D. Operational Data Users 

Show / Hide Answer

---

Question # 33

UC has a legacy client server app that as a relational data base that needs to be migrated to salesforce. What are the 3 key actions that should be done when data modeling in salesforce? Choose 3 answers:

A. Identify data elements to be persisted in salesforce.
 B. Map legacy data to salesforce objects.
C. Map legacy data to salesforce custom objects. 
D. Work with legacy application owner to analysis legacy data model. 
E. Implement legacy data model within salesforce using custom fields. 

Show / Hide Answer

---

Question # 34

UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application. Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers. 

A. Use picklist fields rather than lookup to custom object.
 B. Limit assigning one user 10000 records ownership. 
C. Assign 10000 opportunities to one account. 
D. Limit associating 10000 opportunities to one account. 
E. Limit associating 10000 records looking up to same records.

Show / Hide Answer

---

Question # 35

Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, and item color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution. What is a correct technique UC should use to solve the data inconsistency? 

A. Change integration to let product master systems update product data directly in Salesforce via the Salesforce API. 
B. Add custom fields to the Product standard object in Salesforce to store data from the different source systems. 
C. Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse. 
D. Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce. 

Show / Hide Answer

---

Question # 36

Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records are created or updates by users. A majority of the automation tool within UC’’ org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend. What should a data architect do to mitigate any unwanted results during the import? 

A. Ensure validation rules, triggers and other automation tools are disabled. 
B. Ensure duplication and matching rules and defined. 
C. Import the data in smaller batches over a 24-hour period. 
D. Bulkily the trigger to handle import leads. 

Show / Hide Answer

---

Question # 37

Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US-based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics. What should be the recommended solution to meet this requirement? 

A. Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality. 
B. Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality. 
C. Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality. 
D. Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality. 

Show / Hide Answer

---

Question # 38

Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage. Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

 A. Number of queries running at a time. 
B. Number of joins used in report query. 
C. Number of records returned by report query. 
D. Number of characters in report query. 

Show / Hide Answer

---

Question # 39

DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout. DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field. The Architect needs to ensure this field always contains data coming from the source system. Which two approaches should the Architect take? Choose 2 answers 

A. Set up a Validation Rule to prevent blank values. 
B. Create a Workflow to default a value into this field. 
C. Mark the field required in setup at the field level. 
D. Blame the customer's external system for bad data. 

Show / Hide Answer

---

Question # 40

Universal Containers (UC) is in the process of migrating lagacy inventory data from an enterprise resources planning (ERP) system into Sales Cloud with the following requirements: Legacy inventory data will be stored in a custom child objects called Inventory_c. Inventory data should be related to the standard Account object. The Inventory_c object should Inhent the same sharing rules as the Account object. Anytime an Account record is deleted in Salesforce, the related Inventory_c record(s) should be deleted as well. What type of relationship field should a data architect recommend in this scenario? 

A. Master-detail relationship filed on Account, related to Inventory_c 
B. Master-detail relationship filed on Inventory_c, related to Account 
C. Indirect lookup relationship field on Account, related to Inventory_c 
D. Lookup relationship fields on Inventory related to Account

Show / Hide Answer

---

<123456789>

---

Download All 257 Questions Check Customers Feedbacks