Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?

Enable 'Set Audit Fields' and assign the permission to the user loading the data for the duration of the migration.

After the data is migrated, perform an update on all records to set the original date in a standard Created Date field.

Create a new field on the Contact object to capture the Created Date. Hide the standard Created Date field using Field -Level Security.

Enable 'Set Audit Fields' and assign the permission to the user loading the data for the duration of the migration.

Write an Apex trigger on the Contact object, before insert event to set the original value in a standard Created Date field.

An architect has been asked to provide error messages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages. What are two approaches the architect should use to achieve this solution? Choose 2 answers

Create a trigger on Contact and add an error to the record with a custom label.

Create a validation rule and translate the error message with translation workbench.

Implement a third -party validation process with translate functionality.

Create a trigger on Contact and add an error to the record with a custom label.

Create a workflow field update to set the standard ErrorMessage field.

Create a validation rule and translate the error message with translation workbench.

What is an advantage of using Custom metadata type over Custom setting?

Custom metadata records are deployable using packages.

Custom metadata records are not copied from production to sandbox.

Custom metadata types are available for reporting.

Custom metadata records are deployable using packages.

Custom metadata records are editable in Apex.

Get Cloudy Consulting uses an invoicing system that has specific requirements. One requirement is that attachments associated with the Invoice_c custom object be classified by Types (i.e., ''Purchase Order'', ''Receipt'', etc.) so that reporting can be performed on invoices showing the number of attachments grouped by Type.What should an Architect do to categorize the attachments to fulfill these requirements?

Create a custom object related to the Invoice object with a picklist field for the Type.

Add additional options to the standard ContentType picklist field for the Attachment object.

Add a ContentType picklist field to the Attachment layout and create additional picklist options.

Create a custom picklist field for the Type on the standard Attachment object with the values.

Create a custom object related to the Invoice object with a picklist field for the Type.

Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues. Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers

Bulk API limitations on picklist fields.

Standard list view in -line editing.

Limitations on master -detail relationships.

Bulk API limitations on picklist fields.

Standard list view in -line editing.

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called 'Order c'; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

Work with Salesforce Support to enable Skinny Tables.

Make the queries more selective using indexed fields.

Use SOQL queries without WHERE conditions.

Work with Salesforce Support to enable Skinny Tables.

Reduce the number of triggers on Order _c object.

Make the queries more selective using indexed fields.

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?

Create a picklist field, values sorted alphabetically.

Create a Master -Detail to custom object ShippingStatus c.

Create a Lookup to custom object ShippingStatus c.

Create a text field and make it an external ID.

Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers

Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.

Turn on field Contact object history tracking for these ten fields, then create reports on contact history.

Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.

Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.

Turn on field Contact object history tracking for these ten fields, then create reports on contact history.

Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.

Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?

Create a 'before delete' trigger to check if the current user is not the owner.

Set the Sharing settings as Public Read Only for the Contact object.

Set the profile of the users to remove delete permission from the Contact object.

Create a validation rule on the Contact object to check if the current user is not the owner.

Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bi-directional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space?

Create an external object Invoice _x with a Lookup relationship with Opportunity.

Use Streaming API to get the current status from the ERP and display on the Opportunity page.

Create an external object Invoice _x with a Lookup relationship with Opportunity.

Create a custom object Invoice _c with a master -detail relationship with Opportunity.

Create a custom object Invoice _c with a Lookup relationship with Opportunity.

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

Create a custom object to store a copy of the record when changed.

Create a custom object to store the previous and new field values.

Create a custom object to store a copy of the record when changed.

Create a custom object to store the previous and new field values.

Use Analytic Snapshots to store a copy of the record when changed.

Select the 100 fields in the Opportunity Set History Tracking page.

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

Use Salesforce duplicate management.

Use validation rules on new record create and edit.

Use Salesforce duplicate management.

Use validation rules on new record create and edit.

Use workflow to delete duplicate records.

Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers

Clean data before importing to Salesforce.

Use Salesforce matching and duplicate rules.

Use a workflow to check and prevent duplicates.

Clean data before importing to Salesforce.

Use Salesforce matching and duplicate rules.

Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?

Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.

Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.

Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.

Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.

Make the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.

Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

Utilize a Validation Rule with a REGEX operator on Postal Code.

Utilize a Validation Rule with a CONTAINS operator on address fields.

Change each address field to require on the Page Layout.

Write an Apex Trigger to require all fields to be populated.

Utilize a Validation Rule with a REGEX operator on Postal Code.

Utilize a Validation Rule with a CONTAINS operator on address fields.

Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments. What two solutions should UC implement to cleanse their data? Choose 2 answers

Make use of a third -party tool to help merge duplicate Contacts across Accounts.

Use Data.com to standardize Contact address information to help identify duplicates.

Make use of a third -party tool to help merge duplicate Contacts across Accounts.

Use Data.com to standardize Contact address information to help identify duplicates.

Use Workflow rules to standardize Contact information to identify and prevent duplicates.

Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.

Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization. Which two approaches should an architect recommend to enforce this new plan?Choose 2 answers

Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.

Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.

Schedule reports that will automatically catch duplicates and merge or delete the records every week.

Store all data in an external system and set up an integration to Salesforce for view -only access.

Universal Containers wants to implement a data -quality process to monitor the data that users are manually entering into the system through the Salesforce UI. Which approach should the architect recommend?

Utilize an app from the AppExchange to create data -quality dashboards.

Allow users to import their data using the Salesforce Import tools.

Utilize a 3rd -party solution from the AppExchange for data uploads.

Utilize an app from the AppExchange to create data -quality dashboards.

Use Apex to validate the format of phone numbers and postal codes.

A manager at Cloud Kicks is importing Leads into Salesforce and needs to avoid creating duplicate records.Which two approaches should the manager take to achieve this goal? (Choose two.)

Acquire an AppExchange Lead de-duplication application.

Implement Salesforce Matching and Duplicate Rules.

Acquire an AppExchange Lead de-duplication application.

Implement Salesforce Matching and Duplicate Rules.

Run the Salesforce Lead Mass de-duplication tool.

Create a Workflow Rule to check for duplicate records.

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

Set up a Validation Rule to prevent blank values.

Mark the field required in setup at the field level.

Set up a Validation Rule to prevent blank values.

Create a Workflow to default a value into this field.

Mark the field required in setup at the field level.

Blame the customer's external system for bad data.

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?

Implement a workflow rule that sends Opportunity data through Outbound Messaging.

Implement a Master Data Management system to determine system of record.

Implement a workflow rule that sends Opportunity data through Outbound Messaging.

Have the ERP poll Salesforce nightly and bring in the desired Opportunities.

Implement an hourly integration to send Salesforce Opportunities to the ERP system.

Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., 'John Doe' in the OMS and 'Johnny Doe' in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?

Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.

Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.

Implement an integration tool to send OMS Accounts and Contacts to Salesforce.

Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.

Use the Streaming API to send Account and Contact data from Salesforce to the OMS.

An architect has been asked by a client to develop a solution that will integrate data and resolve duplicates and discrepancies between Salesforce and one or more external systems. What two factors should the architect take into consideration when deciding whether or not to use a Master Data Management system to achieve this solution?Choose 2 answers

Whether the system of record changes for different tables.

The number of systems that are integrating with each other.

Whether the systems are cloud -based or on -premise.

Whether or not Salesforce replaced a legacy CRM.

Whether the system of record changes for different tables.

The number of systems that are integrating with each other.

Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used.An Architect needs to determine which system is the system of record on a field level.What should the Architect do to achieve this goal?

Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.

Master Data Management systems determine system of record, and the Architect doesn't have to think about what data is controlled by what system.

Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.

The database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce.

Any field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record.

Salesforce is being deployed in Ursa Major Solar's disparate, multi-system ERP environment. Ursa major Solar wants to maintain data synchronization between systems.Which two techniques should be used to achieve this goal? (Choose two.)

Integrate Salesforce with the ERP environment.

Utilize an MDM strategy to outline a single source of truth.

Integrate Salesforce with the ERP environment.

Utilize workbench to update files within systems.

Utilize an MDM strategy to outline a single source of truth.

Build synchronization reports and dashboards.

All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems:* An ERP system feeds order data into Salesforce and updates both Account and Opportunity records.* An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records.* A commission system feeds commission data into Salesforce and updates both Account and Opportunity records.How should the architect determine which of these systems is the system of record?

Data flows should be reviewed with the business users to determine the system of record per object or field.

Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.

Whatever system updates the attribute or object should be the system of record for that field or object.

Whatever integration data flow runs last will, by default, determine which system is the system of record.

Data flows should be reviewed with the business users to determine the system of record per object or field.

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

Put the business purpose in the Description of each field.

Use the Force.com IDE to save the metadata files in source control.

Review the setup audit trail for configuration changes.

Put the business purpose in the Description of each field.

Maintain a data dictionary with the justification for each field.

Use the Force.com IDE to save the metadata files in source control.

How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?

Export the setup audit trail and find the fields in question.

Remove 'customize application' permissions from everyone else.

Export the metadata and search it for the fields in question.

Create a field history report for the fields in question.

Export the setup audit trail and find the fields in question.

Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answers

Schedule jobs to export and delete using an ETL tool.

Schedule jobs to export and delete using the Data Loader.

Use the Force.com Workbench to export the data.

Schedule a weekly export file from the Salesforce UI.

Schedule jobs to export and delete using an ETL tool.

Schedule jobs to export and delete using the Data Loader.

Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce.What are two automated approaches to fulfill this goal? (Choose two.)

Third-party Integration Tool (ETL)

Third-party Business Intelligence system

Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?

Review projected data storage needs.

Reduce data storage by purging old data.

Implement an AppExchange package.

Review projected data storage needs.

Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce.Which approach for data archiving is appropriate for this scenario?

1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.

1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.

1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.

1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.

1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.

A Salesforce customer has plenty of data storage. Sales Reps are complaining that searches are bringing back old records that aren't relevant any longer. Sales Managers need the data for their historical reporting. What strategy should a data architect use to ensure a better user experience for the Sales Reps?

Archive and purge old data from Salesforce on a monthly basis.

Create a Permission Set to hide old data from Sales Reps.

Use Batch Apex to archive old data on a rolling nightly basis.

Archive and purge old data from Salesforce on a monthly basis.

Set data access to Private to hide old data from Sales Reps.

Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture? Choose 2 answers

Engage with executive sponsorship to assess enterprise data strategy and goals.

Engage with business units and IT to assess current operational systems and data models.

Engage with IT program managers to assess current velocity of projects in the pipeline.

Engage with database administrators to assess current database performance metrics.

Engage with executive sponsorship to assess enterprise data strategy and goals.

Engage with business units and IT to assess current operational systems and data models.

A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers

Determine if any integration points create records in Salesforce.

Run key reports to determine what fields should be required.

Review the sharing model to determine impact on duplicate records.

Review the metadata xml files for redundant fields to consolidate.

Determine if any integration points create records in Salesforce.

Run key reports to determine what fields should be required.

Export the setup audit trail to review what fields are being used.

Review the sharing model to determine impact on duplicate records.

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

Question 1 / 40

Cloud Kicks has the following requirements:

* Their Shipment custom object must always relate to a Product, a Sender, and a Receiver (all separate custom objects).

* If a Shipment is currently associated with a Product, Sender, or Receiver, deletion of those records should not be allowed.

* Each custom object must have separate sharing models.

What should an Architect do to fulfill these requirements?

Associate the Shipment to each parent record by using a VLOOKUP formula field.

Create a required Lookup relationship to each of the three parent records.

Create a Master-Detail relationship to each of the three parent records.

Create two Master-Detail and one Lookup relationship to the parent records.

Comment (0)

Salesforce Certified Data Architect Practice Test 1

Question

Salesforce Certified Data Architect Practice Tests

Practice Tests