DA4 Flashcards
Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system.
Which two options should be recommended to make this report perform well and satisfy the business need?
A. Use triggers to populate denormalized related fields on the Account.
B. Use an indexed data field with bounded data filters.
C. Use Formula fields to surface information about related entities on the report.
D. Use unbounded date ranges to filter the report.
B. Use an indexed data field with bounded data filters.
D. Use unbounded date ranges to filter the report.
A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?
A. Use Salesforce Soap API in parallel mode.
B. Use Salesforce Bulk API in serial mode.
C. Use Salesforce Bulk API in parallel mode.
D. Use Salesforce Soap API in serial mode.
C. Use Salesforce Bulk API in parallel mode.
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?
Choose 2 answers
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.
A. Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.
D. Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.
Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics.
What solution addresses this requirement?
A. Use third-party AppExchange tools to monitor and measure data quality.
B. Generate reports to view the quality of sample data.
C. Use custom objects and fields to calculate data quality.
D. Export the data to an enterprise data warehouse and use BI tools for data quality.
A. Use third-party AppExchange tools to monitor and measure data quality.
A shipping and logistics company has created a large number of reports within Sales Cloud since Salesforce was introduced. Some of these reports analyze large amounts of data regarding the whereabouts of the company’s containers, and they are starting to time out when users are trying to run the reports.
What is a recommended approach to avoid these time-out issues?
A. Improve reporting performance by creating a custom Visualforce report that is using a cache of the records in the report.
B. Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.
C. Improve reporting performance by creating an Apex trigger for the Report object that will prefetch data before the report is run.
D. Improve reporting performance by creating a dashboard that is scheduled to run the reports only once per day.
B. Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.
Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc.
What is the recommended approach for defining a solution for this requirement?
A. Use a field audit trail to capture field changes.
B. Use a custom object and trigger to capture changes.
C. Use Event Monitoring to capture these changes.
D. Use a third-party AppExchange app to capture changes.
C. Use Event Monitoring to capture these changes.
Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce.
What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?
A. Extract the Salesforce data into Excel and manually compare this against the trusted source.
B. Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.
C. Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.
D. Leave the data in Salesforce alone and assume that it will auto-correct itself over time.
C. Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.
Which two statements are accurate with respect to performance testing a Force.com application?
A. All Force.com applications must be performance tested in a sandbox as well as production.
B. A performance test plan must be created and submitted to Salesforce customer support.
C. Applications with highly customized code or large volumes should be performance tested.
D. Application performance benchmarked in a sandbox can also be expected in production.
B. A performance test plan must be created and submitted to Salesforce customer support.
C. Applications with highly customized code or large volumes should be performance tested.
Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items.
What should UC’s Data Architect recommend to ensure scalability?
A. Ensure invoice line items simply reference existing Opportunity line items.
B. Ensure the account product vendor includes Wave Analytics in their offering.
C. Ensure the account product vendor provides a sound data archiving strategy.
D. Ensure the accounting product runs 100% natively on the Salesforce platform.
C. Ensure the account product vendor provides a sound data archiving strategy.
Universal Containers (UC) has a custom discount request object set as a detail object with a custom product object as the master. There is a requirement to allow the creation of generic discount requests without the custom product object as its master record.
What solution should an Architect recommend to UC?
A. Mandate the selection of a custom product for each discount request.
B. Create a placeholder product record for the generic discount request.
C. Remove the master-detail relationship and keep the objects separate.
D. Change the master-detail relationship to a lookup relationship.
D. Change the master-detail relationship to a lookup relationship.
Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ‘key’ fields which are important to their sales reps.
What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency?
Choose two answers
A. Run a report which shows the last time the key fields were updated.
B. Run one report per key field, grouped by that field, to understand its data variability.
C. Run a report that shows the percentage of blanks for the important fields.
D. Run a process that can fill in default values for blank fields.
A. Run a report which shows the last time the key fields were updated.
C. Run a report that shows the percentage of blanks for the important fields.
Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records.
What would be the recommended approach to help UC start immediately?
A. Create an after insert and update trigger on the account, contact and lead, and send an error if a duplicate is found using a custom matching criteria.
B. Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.
C. Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to block for both creates and edits.
D. Create a before insert and update trigger on account, contact, and lead, and send an error if a duplicate is found using a custom matching criteria.
B. Create a duplicate rule for account, lead, and contact, use standard matching rules for these objects, and set the action to report and alert for both creates and edits.
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.
A. Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.
Universal Containers (UC) has a requirement to create an Account plan object that is related to the Account object. Each Account plan needs to have an Account object, but the accessibility requirement of the Account plan is different from the Account object.
What should an Architect recommend?
A. Create a custom account plan object as detail with Account as mater in a master-detail
relationship.
B. Create a custom account plan object as detail with Account as master with additional sharing rules to allow access.
C. Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.
D. Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.
D. Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.
Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?
A. Use Duplicate Management.
B. Use an Enterprise Service Bus.
C. Use Data.com Clean.
D. Use a data warehouse.
A. Use Duplicate Management.
C. Use Data.com Clean.
Universal Containers (UC) has several custom Visualforce applications have been developed in which users are able to edit Opportunity records. UC struggles with data completeness on their Opportunity records and has decided to make certain fields required that have not been in the past. The newly required fields are dependent on the Stage of the Opportunity, such that certain fields are only required once an Opportunity advances to later stages. There are two fields.
What is the simplest approach to handle this new requirement?
A. Update the Opportunity page layout to mark these fields as required.
B. Use a validation rule for each field that takes the Stage into consideration.
C. Update these Opportunity field definitions in Setup to be required.
D. Write an Apex trigger that checks each field when records are saved.
B. Use a validation rule for each field that takes the Stage into consideration.
A Customer is migrating 10 million orders and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?
A. Query only indexed ID field values on the imported order to import related order lines.
B. Leverage an External ID from source system orders to import related order lines.
C. Leverage Batch Apex to update order ID on related order lines after import.
D. Leverage a sequence of numbers on the imported orders to import related order lines.
B. Leverage an External ID from source system orders to import related order lines.
Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed.
Which two techniques should be used for smooth interoperability now and in the future?
Choose 2 answers
A. Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.
B. Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.
C. Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.
D. Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.
B. Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.
C. Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.
Universal Containers 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. They want to keep data in synch between 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
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
Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters.
Which two options can be used to improve report performance?
A. Ask support to create a skinny table for Application with the necessary reporting fields.
B. Add custom indexes to all fields on Application without a standard index.
C. Run multiple reports to get different pieces of the data and combine them.
D. Add custom indexes to the Date fields used for filtering the report.
A. Ask support to create a skinny table for Application with the necessary reporting fields.
D. Add custom indexes to the Date fields used for filtering the report.
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.
D. Contact Salesforce to enable Defer Sharing Rules.
A customer is facing locking issues when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?
A. Import Account records first followed by order records after sorting orders by OrderID.
B. Import Account records first followed by order records after sorting orders by AccountID.
C. Change the relationship to Lookup and update the relationship to master-detail after import.
D. Import Order records and Account records separately and populate AccountID in orders using batch Apex.
B. Import Account records first followed by order records after sorting orders by AccountID.
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 Canvas 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.
D. Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.
