Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support reps case closure rates?

Enable field history tracking on the Case object.

Create a report on Case analytic snapshots.

Install AppExchange packages for available reports.

Create Contact and Opportunity Reports and Dashboards.

In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce?

Salesforce allows up to four objects in a single report type.

Salesforce does not support Orders or Order Line Items.

A report cannot contain data from Accounts and Contacts.

Custom report types cannot contain Opportunity data.

Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers

Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.

Create a Visualforce page combining Salesforce Account data and Invoice external object data.

Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.

Create a report combining data from the Account standard object and the Invoices external object.

Create a Visualforce page combining Salesforce Account data and Invoice external object data.

Create a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.

Universal Containers wishes to maintain Lead data from Leads even after they are deleted and cleared from the Recycle Bin. What approach should be implemented to achieve this solution?

Query Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.

Use a Lead standard report and filter on the IsDeleted standard field.

Use a Converted Lead report to display data on Leads that have been deleted.

Query Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.

Send data to a Data Warehouse and mark Leads as deleted in that system.

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?

Use GZIP compression to export the data.

Use the SOAP API to export data.

Utilize the Bulk API to export the data.

Use GZIP compression to export the data.

Schedule a Batch Apex job to export the data.

Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records. What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues?

Create one Account and load individual consumers as Contacts linked to that one Account.

Create a Custom Object Individual Consumer c to load all individual consumers.

Load all individual consumers as Account records and avoid using the Contact object.

Load one Account record and one Contact record for each individual consumer.

Create one Account and load individual consumers as Contacts linked to that one Account.

DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce. What should the Architect consider in this situation?

Load all data after deferring sharing calculations.

Calculate summary values instead of Roll-Up by using workflow.

Calculate summary values instead of Roll-Up by using triggers.

Load all data using external IDs to link to parent records.

Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.Which two approaches will accomplish this goal? (Choose two.)

Create the users, upload all data, and then deploy the sharing rules.

Defer sharing calculations until the data has finished uploading.

Create the users, upload all data, and then deploy the sharing rules.

Contact Salesforce to activate indexing before uploading the data.

First, load all account records, and then load all user records.

Defer sharing calculations until the data has finished uploading.

Cloud Kicks has the following requirements:- Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS).- A Salesforce administrator must be able to customize which fields will be sent to the external system without changing code.What are two approaches for fulfilling these requirements? (Choose two.)

An Outbound Message to determine which fields to send to the OMS.

A Field Set that determines which fields to send in an HTTP callout.

A set<sobjectFieldset> to determine which fields to send in an HTTP callout.

An Outbound Message to determine which fields to send to the OMS.

A Field Set that determines which fields to send in an HTTP callout.

Enable the field -level security permissions for the fields to send.

The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce. What three things should the architect consider to optimize performance of the data migration? Choose 3 answers

Remove custom indexes on the data being loaded.

Defer sharing calculations of the Salesforce Org.

Deactivate approval processes and workflow rules.

Review the time zones of the User loading the data.

Remove custom indexes on the data being loaded.

Determine if the legacy system is still in use.

Defer sharing calculations of the Salesforce Org.

Deactivate approval processes and workflow rules.

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?

Load new records via the Insert operation and existing records via the Update operation.

Load Contact records together using the Streaming API via the Upsert operation.

Delete all existing records, and then load all records together via the Insert operation.

Load all records via the Upsert operation to determine new records vs. existing records.

Load new records via the Insert operation and existing records via the Update operation.

An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode. What should be considered when loading the Opportunity records?

Order batches by Auto -number field.

Create indexes on Opportunity object text fields.

Group batches by the AccountId field.

Sort batches by Name field values.

Order batches by Auto -number field.

Company S was recently acquired by Company T. As part of the acquisition, all of the data for the Company S's Salesforce instance (source) must be migrated into the Company T's Salesforce instance (target). Company S has 6 million Case records.An Architect has been tasked with optimizing the data load time.What should the Architect consider to achieve this goal?

Pre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.

Directly leverage Salesforce-to-Salesforce functionality to load Case data.

Load the data in multiple sets using Bulk API parallel processes.

Utilize the Salesforce Org Migration Tool from the Setup Data Management menu.

Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers

Index key fields used in report criteria.

Create one skinny table per report.

Index key fields used in report criteria.

Enable Divisions for large data objects.

Create one skinny table per report.

Share each report with fewer users.

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.)

Make sure the query doesn't contain NULL in any filter criteria.

Create custom indexes on the fields used in the filter criteria.

Make sure the query doesn't contain NULL in any filter criteria.

Create a formula field instead of having multiple filter criteria.

Create custom indexes on the fields used in the filter criteria.

Modify the integration users' profile to have View All Data.

Universal Containers (UC) is implementing a Salesforce project with large volumes of data and daily transactions. The solution includes both real-time web service integrations and Visualforce mash -ups with back -end systems. The Salesforce Full sandbox used by the project integrates with full-scale back -end testing systems. What two types of performance testing are appropriate for this project?Choose 2 answers

Pre -go -live automated page -load testing against the Salesforce Full sandbox.

Stress testing against the web services hosted by the integration middleware.

Pre -go -live automated page -load testing against the Salesforce Full sandbox.

Post go -live automated page -load testing against the Salesforce Production org.

Pre -go -live unit testing in the Salesforce Full sandbox.

Stress testing against the web services hosted by the integration middleware.

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?

Use an indexed data field with bounded data filters.

Use Formula fields to surface information I related entities on the report.

Use triggers to populate denormalized related fields on the Account.

Use an indexed data field with bounded data filters.

Use Formula fields to surface information I related entities on the report.

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?

Use Salesforce Bulk API in parallel mode.

Use Salesforce Soap API in parallel mode.

Use Salesforce Bulk API in serial mode.

Use Salesforce Bulk API in parallel mode.

Use Salesforce Soap API in serial 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?

Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.

Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.

Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.

Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.

Use Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.

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?

Use third-party AppExchange tools to monitor and measure data quality.

Generate reports to view the quality of sample data.

Use custom objects and fields to calculate data quality.

Export the data to an enterprise data warehouse and use BI tools for 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?

Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.

Improve reporting performance by creating a custom Visualforce report that is using a cache of the records in the report.

Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.

Improve reporting performance by creating an Apex trigger for the Report object that will pre-fetch data before the report is run.

Improve reporting performance by creating a dashboard that is scheduled to run the reports only once per day.

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?

Use Event Monitoring to capture these changes.

Use a field audit trail to capture field changes.

Use a custom object and trigger to capture changes.

Use Event Monitoring to capture these changes.

Use a third-party AppExchange app to capture 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?

Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

Extract the Salesforce data into Excel and manually compare this against the trusted source.

Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

Leave the data in Salesforce alone and assume that it will auto-correct itself over time.

Which two statements are accurate with respect to performance testing a Force.com application?

A performance test plan must be created and submitted to Salesforce customer support.

Applications with highly customized code or large volumes should be performance tested.

All Force.com applications must be performance tested in a sandbox as well as production.

A performance test plan must be created and submitted to Salesforce customer support.

Applications with highly customized code or large volumes should be performance tested.

Application performance benchmarked in a sandbox can also be expected in production.

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?

Ensure the account product vendor provides a sound data archiving strategy.

Ensure invoice line items simply reference existing Opportunity line items.

Ensure the account product vendor includes Wave Analytics in their offering.

Ensure the account product vendor provides a sound data archiving strategy.

Ensure the accounting product runs 100% natively on the Salesforce platform.

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?

Change the master-detail relationship to a lookup relationship.

Mandate the selection of a custom product for each discount request.

Create a placeholder product record for the generic discount request.

Remove the master-detail relationship and keep the objects separate.

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.)

Run a report which shows the last time the key fields were updated.

Run a report that shows the percentage of blanks for the important fields.

Run a report which shows the last time the key fields were updated.

Run one report per key field, grouped by that field, to understand its data variability.

Run a report that shows the percentage of blanks for the important fields.

Run a process that can fill in default values for blank 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?

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.

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.

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.

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.

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.

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?

Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.

Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality.

Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality.

Implement an Apex Trigger on Account that queries a third-party data quality API 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?

Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.

Create a custom account plan object as detail with Account as mater in a master-detail relationship.

Create a custom account plan object as detail with Account as master with additional sharing rules to allow access.

Create an account plan object with a lookup relations to Account without any validation rules to enforce the Account association.

Create an account plan object with a lookup relationship to Account with validation rules to enforce the Account association.

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?

Use a validation rule for each field that takes the Stage into consideration.

Update the Opportunity page layout to mark these fields as required.

Use a validation rule for each field that takes the Stage into consideration.

Update these Opportunity field definitions in Setup to be required.

Write an Apex trigger that checks each field when records are saved.

A Customer is migrating 10 million order 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?

Leverage an External ID from source system orders to import related order lines.

Query only indexed ID field values on the imported order to import related order lines.

Leverage an External ID from source system orders to import related order lines.

Leverage Batch Apex to update order ID on related order lines after import.

Leverage a sequence of numbers on the imported 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.

Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.

Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.

Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.

Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.

Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.

Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.

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.

Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce

Suggest MDM solution and link MDM to salesforce and SAP

Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place

Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP

Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce

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?

Ask support to create a skinny table for Application with the necessary reporting fields.

Add custom indexes to the Date fields used for filtering the report.

Ask support to create a skinny table for Application with the necessary reporting fields.

Add custom indexes to all fields on Application without a standard index.

Run multiple reports to get different pieces of the data and combine them.

Add custom indexes to the Date fields used for filtering the report.

Salesforce Certified Data Architect Practice Test 2 - Free Online Exam Prep & Questions

Question 1 / 40

To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?

Errors with duplicate external Id values within the same CSV file.

Errors with records being updated and inserted in the same CSV file.

Errors when a duplicate Contact name is found cause upsert to fail.

Errors with using the wrong external Id will cause the load to fail.

Comment (0)

Salesforce Certified Data Architect Practice Test 2

Question

Salesforce Certified Data Architect Practice Tests

Practice Tests