Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents. UC creates 5 million cases per yr.Which 2 data archiving strategies should a data architect recommend? Choose 2 options:

Use Big objects for cases older than 2 years, and use nightly batch to move them.

Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.

Use custom objects for cases older than 2 years and use nightly batch to move them.

Sync cases older than 2 years to an external database, and provide access to Service agents to the database

Use Big objects for cases older than 2 years, and use nightly batch to move them.

Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.

A customer is operating in a highly reputated industry and is planning to implement SF. The customer information maintained in SF, includes the following:Personally, identifiable information (PII)IP restrictions on profiles organized by Geographic locationFinancial records that need to be private and accessible only by the assigned Sales associate.User should not be allowed to export information from Salesforce.Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity. Which 3 Salesforce shield capabilities should a data architect recommend? Choose 3 answers:

Restrict access to SF from users outside specific geography

Transaction security policies to prevent export of SF Data.

Encrypt Sensitive Customer information maintained in SF.

Event monitoring to monitor all user activities

Restrict access to SF from users outside specific geography

Prevent Sales users access to customer PII information

Transaction security policies to prevent export of SF Data.

Encrypt Sensitive Customer information maintained in SF.

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:

Develop an object relationship strategy.

Identify the external tables to sync into external objects

Assess whether the external data source is reachable via an ODATA endpoint.

Create a 2nd system Admin user for authentication to the external source.

Develop an object relationship strategy.

Identify the external tables to sync into external objects

Assess whether the external data source is reachable via an ODATA endpoint.

Configure a middleware tool to poll external table data

UC has been using SF for 10 years. Lately, users have noticed, that the pages load slowly when viewing Customer and Account list view.To mitigate, UC will implement a data archive strategy to reduce the amount of data actively loaded.Which 2 tasks are required to define the strategy? Choose 2 answers:

Identify how the archive data will be accessed and used.

Identify the data retention requirements

Identify the recovery point objective.

Identify how the archive data will be accessed and used.

Identify the recovery time objective.

Identify the data retention requirements

UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported. What should a data architect recommend to make sure decrypted values are exported during data export?

Create another field to copy data from encrypted field and use this field in export

Set a standard profile for Data Migration user, and assign view encrypted data

Create another field to copy data from encrypted field and use this field in export

Leverage Apex class to decrypt data before exporting it.

Set up a custom profile for data migration user and assign view encrypted data.

Universal containers is implementing Salesforce lead management. UC Procure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead datahas both profile and location information? Option

Leverage external data providers populate company profile and location data

Ask sales people to search for populating company profile and location data

Run reports to identify records which does not have company profile and location data

Leverage external data providers populate company profile and location data

Export data out of Salesforce and send to another team to populate company profile and location data

UC has millions of case records with case history and SLA data. UC's compliance team would like historical cases to be accessible for 10 years for Audit purpose.What solution should a data architect recommend?

Use a custom Big object to store archived case data.

Archive Case data using Salesforce Archiving process

Purchase more data storage to support case object

Use a custom object to store archived case data.

Use a custom Big object to store archived case data.

NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records.What should a data architect recommend in order to get around the time out issue?

Use ETL tool for extraction of records.

Use a custom auto number and formula field and use that to chunk records while extracting data.

The REST API to extract data as it automatically chunks records by 200.

Use ETL tool for extraction of records.

Ask SF support to increase the query timeout value.

UC has a variety of systems across its technology landscape, including SF, legacy enterprise resource planning (ERP) applications and homegrown CRM tools. UC has decided that they would like to consolidate all customer, opportunity and order data into Salesforce as part of its master data management (MDM) strategy.What are the 3 key steps that a data architect should take when merging data from multiple systems into Salesforce? Choose 3 answers:

Analyze each system's data model and perform gap analysis

Utilize an ETL tool to merge, transform and de-duplicate data.

Work with Stakeholders to define record and field survivorship rules

Create new fields to store additional values from all the systems.

Install a 3rd party AppExchange tool to handle the merger

Analyze each system's data model and perform gap analysis

Utilize an ETL tool to merge, transform and de-duplicate data.

Work with Stakeholders to define record and field survivorship rules

UC has a roll-up summary field on Account to calculate the count of contacts associated with an account. During the account load, SF is throwing an ''Unable to lock a row'' error.Which solution should a data architect recommend, to resolve the error?

Perform Batch job in serial mode and reduce batch size

Leverage data loader platform API to load data.

Perform Batch job in parallel mode and reduce Batch size

Perform Batch job in serial mode and reduce batch size

Defer roll-up summary fields calculation during data migration.

UC is migrating individual customers (B2C) data from legacy systems to SF. There are millions of customers stored as accounts and contacts in legacy database.Which object model should a data architect configure within SF?

Leverage person account object in Salesforce

Leverage custom person account object in SF

Leverage custom account and contact object in SF

Leverage standard account and contact object in SF

NTO has 1 million customer records spanning 25 years. As part of its new SF project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data.Which 3 activities will be required to identify a successful master data management strategy? Choose 3 answers:

Define the systems of record for critical data

Choose a Business Intelligence tool.

UC is migrating data from legacy system to SF. UC would like to preserve the following information on records being migrated:Date time stamps for created date and last modified date.Ownership of records belonging to inactive users being migrated to Salesforce.Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.

Enable update records with Inactive Owners Permission

Enable Set Audit fields upon Record Creation Permission

Log a case with SF to update these fields

Enable update records with Inactive Owners Permission

Enable Set Audit fields upon Record Creation Permission

Enable modify all and view all permission.

UC has migrated its Back-office data into an on-premise database with REST API access. UC recently implemented Sales cloud for its sales organization. But users are complaining about a lack of order data inside SF.UC is concerned about SF storage limits but would still like Sales cloud to have access to the data.Which design patterns should a data architect select to satisfy the requirement?

Use SF Connect to virtualize the data in SF and avoid storage limits.

Migrate and persist the data in SF to take advantage of native functionality.

Use SF Connect to virtualize the data in SF and avoid storage limits.

Develop a bidirectional integration between the on-premise system and Salesforce.

Build a UI for the on-premise system and iframe it in Salesforce

A customer needs a sales model that allows the following:Opportunities need to be assigned to sales people based on the zip code.Each sales person can be assigned to multiple zip codes.Each zip code is assigned to a sales area definition. Sales is aggregated by sales area for reporting.What should a data architect recommend?

Configure territory management feature to support opportunity assignment.

Assign opportunities using list views using zip code.

Add custom fields in opportunities for zip code and use assignment rules.

Allow sales users to manually assign opportunity ownership based on zip code.

Configure territory management feature to support opportunity assignment.

US is implementing salesforce and will be using salesforce to track customer complaints, provide white papers on products and provide subscription (Fee) -- based support.Which license type will US users need to fulfil US's requirements?

Lightning platform starter license.

US has released a new disaster recovery (DR)policy that states that cloud solutions need a business continuity plan in place separate from the cloud providers built in data recovery solution.Which solution should a data architect use to comply with the DR policy?

Leverage a 3rd party tool that extract salesforce data/metadata and stores the information in an external protected system.

Leverage salesforce weekly exports, and store data in Flat files on a protected system.

Utilize an ETL tool to migrate data to an on-premise archive solution.

Write a custom batch job to extract data changes nightly, and store in an external protected system.

NTO has been using salesforce for sales and service for 10 years. For the past 2 years, the marketing group has noticed a raise from 0 to 35 % in returned mail when sending mail using the contact information stored in salesforce.Which solution should the data architect use to reduce the amount of returned mails?

Use a 3rd-party data source to update contact information in salesforce.

Email all customer and asked them to verify their information and to call NTO if their address is incorrect.

Delete contacts when the mail is returned to save postal cost to NTO.

Have the sales team to call all existing customers and ask to verify the contact details.

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.

Limit assigning one user 10000 records ownership.

Limit associating 10000 opportunities to one account.

Limit associating 10000 records looking up to same records.

Use picklist fields rather than lookup to custom object.

Limit assigning one user 10000 records ownership.

Assign 10000 opportunities to one account.

Limit associating 10000 opportunities to one account.

Limit associating 10000 records looking up to same records.

UC has to built a B2C ecommerce site on Heroku that shares customer and order data with a Heroku Postgres database. UC is currently utilizing Postgres as the single source of truth for both customers and orders. UC has asked a data architect to replicate the data into salesforce so that salesforce can now act as the system of record.What are the 3 considerations that data architect should weigh before implementing this requirement? Choose 23 answers:

Determine if the data is driver of key process implemented within salesforce.

Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application.

A selection of the tool required to replicate the data. a. -- Heroku Connect is required but this is confusing

Consider whether the data is required for sales reports, dashboards and KPI's.

Determine if the data is driver of key process implemented within salesforce.

Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application.

Ensure the data is CRM center and able to populate standard of custom objects.

A selection of the tool required to replicate the data. a. -- Heroku Connect is required but this is confusing

What 2 data management policies does the data classification feature allow customers to classify in salesforce? Choose 2 answers:

Compliance categorization policy.

NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records.In salesforce, the customer is represented by the contact object.NTO utilizes an MDM solution with these attributes:1. The MDM solution keeps track of customer master with a master key.2. The master key is a map to the record ID's from each external system that customer data is stored within.3. The MDM solution provides de-duplication features, so it acts as the single source of truth.How should a data architect implement the storage of master key within salesforce?

Store the master key on the contact object as an external ID (Field for referential imports)

Store the master key in Heroku postgres and use Heroku connect for synchronization.

Create a custom object to store the master key with a lookup field to contact.

Create an external object to store the master key with a lookup field to contact.

Store the master key on the contact object as an external ID (Field for referential imports)

UC has large amount of orders coming in from its online portal. Historically all order are assigned to a generic user.Which 2 measures should data architect recommend to avoid any performance issues while working with large number of order records? Choose 2 answers:

Clear the role field in the generic user record.

Create a role at top of role hierarchy and assign the role to the generic user.

Clear the role field in the generic user record.

Salesforce handles the assignment of orders automatically and there is no performance impact.

Create a role at top of role hierarchy and assign the role to the generic user.

Create a pool of generic users and distribute the assignment of memory to the pool of users.

NTO has implemented salesforce for its sales users. The opportunity management in salesforce is implemented as follows:1. Sales users enter their opportunities in salesforce for forecasting and reporting purposes.2. NTO has a product pricing system (PPS) that is used to update opportunity amount field on opportunities on a daily basis.3. PPS is the trusted source within the NTO for opportunity amount.4. NTO uses opportunity forecast for its sales planning and management.Sales users have noticed that their updates to the opportunity amount field are overwritten when PPS updates their opportunities.How should a data architect address this overriding issue?

Change opportunity amount field access to read only for sales users using field level security.

Create a custom field for opportunity amount that sales users update separating the fields that PPS updates.

Create a custom field for opportunity amount that PPS updates separating the field that sales user updates.

Change opportunity amount field access to read only for sales users using field level security.

Change PPS integration to update only opportunity amount fields when values is NULL.

UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality.Which 2 solutions should a data architect recommend to monitor and measure data quality?Choose 2 answers.

Review data quality reports and dashboards.

Install and run data quality analysis dashboard app

Use custom objects and fields to identify issues.

Review data quality reports and dashboards.

Install and run data quality analysis dashboard app

Export data and check for data completeness outside of Salesforce.

UC has multiple SF orgs that are distributed across regional branches. Each branch stores local customer data inside its org's Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all orgs in one place.What should a data architect suggest to achieve this 360-degree view of the customer?

Consolidate the data from each org into a centralized datastore

Use Salesforce Connect's cross-org adapter.

Build a bidirectional integration between all orgs.

Use an ETL tool to migrate gap Accounts and Contacts into each org.

NTO has decided that it is going to build a channel sales portal with the following requirements:1. External resellers are able to authenticate to the portal with a login.2. Lead data, opportunity data and order data are available to authenticated users.3. Authenticated users many need to run reports and dashboards.4. There is no need for more than 10 custom objects or additional file storage.Which community cloud license type should a data architect recommend to meet the portal requirements?

Lightning external apps starter.

UC is implementing sales cloud for patient management and would like to encrypt sensitive patient records being stored in files.Which solution should a data architect recommend to solve this requirement?

Implement shield platform encryption to encrypt files.

Use classic encryption to encrypt files.

Implement 3rd party App Exchange app to encrypt files.

Store files outside of salesforce and access them to real time.

UC recently migrated 1 Billion customer related records from a legacy data store to Heroku Postgres. A subset of the data need to be synchronized with salesforce so that service agents are able to support customers directly within the service console. The remaining non- synchronized set of data will need to be accessed by salesforce at any point in time, but UC management is concerned about storage limitations.What should a data architect recommend to meet these requirements with minimal effort?

Virtualize the remaining set of data with salesforce connect and external objects.

Use Heroku connect to bi-directional, sync all data between systems.

As needed, make call outs into Heroku postgres and persist the data in salesforce.

Migrate the data to big objects and leverage async SOQL with custom objects.

UC is building a salesforce application to track contacts and their respective conferences that they have attended with the following requirements:1. Contacts will be stored in the standard contact object.2. Conferences will be stored in a custom conference_ c object.3. Each contact may attend multiple conferences and each conference may be related to multiple contacts.How should a data architect model the relationship between the contact and conference objects?

Implement a Contact Conference junction object with master detail relationship to both contact and conference_c

Create a master detail relationship field on the Contact object.

Create a master detail relationship field on the Conference object.

Create a lookup relationship field on contact object.

UC has a requirement to migrate 100 million order records from a legacy ERP application into the salesforce platform. UC does not have any requirements around reporting on the migrated data.What should a data architect recommend to reduce the performance degradation of the platform?

Implement a custom big object to store the data.

Create a custom object to store the data.

Use a standard big object defined by salesforce.

Use the standard ''Order'' object to store the data.

Implement a custom big object to store the data.

NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and data. NTO's data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org.What 3 things should a data architect do to maintain the relationship hierarchy during migration?Choose 3 answers:

Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.

Create a external id field for each object in the target org and map source record ID's to this field.

Replace source record ID's with new record ID's from the target org in the import file.

Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.

Create a external id field for each object in the target org and map source record ID's to this field.

Redefine the master detail relationship fields to lookup relationship fields in the target org.

Replace source record ID's with new record ID's from the target org in the import file.

Keep the relationship fields populated with the source record ID's in the import file.

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:

Leverage on premise data archival and build integration to view archived data.

Leverage big object to archive case data and lightning components to show archived data.

Export data out of salesforce and store in Flat files on external system.

Create a custom object to store case history and run reports on it.

Leverage on premise data archival and build integration to view archived data.

Leverage big object to archive case data and lightning components to show archived data.

What should a data architect do to provide additional guidance for users when they enter information in a standard field?

Provide custom help text under field properties.

Create a custom page with help text for user guidance.

Add custom help text in default value for the field.

Add a label field with help text adjacent to the custom field.

Universal Containers (UC) is going thought major reorganization of their sales team. This would require changes to a large a number of group members and sharing rules. UCs administrator is concerned about long processing time and failure during the process.What should a Data architect implement to make changes efficiently?

Enable Defer Sharing Calculation prior to making sharing rule changes.

Log a case with salesforce to make sharing rule changes.

Enable Defer Sharing Calculation prior to making sharing rule changes.

Delete old sharing rules and build new sharing rules

Log out all users and make changes to sharing rules.

Universal Container (UC) stores 10 million rows of inventory data in a cloud database, As part of creating a connected experience in Salesforce, UC would like to this inventory data to Sales Cloud without a import. UC has asked its data architect to determine if Salesforce Connect is needed.Which three consideration should the data architect make when evaluating the need for Salesforce Connect?

You want real-time access to the latest data, from other systems.

You have a large amount of data that you don't want to copy into your Salesforce org.

You need to small amounts of external data at any one time.

You want real-time access to the latest data, from other systems.

You have a large amount of data and would like to copy subsets of it into Salesforce.

You need to expose data via a virtual private connection.

You have a large amount of data that you don't want to copy into your Salesforce org.

You need to small amounts of external data at any one time.

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

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:

Become a Premium Member for full access

Unlock Premium Member

Salesforce Certified Data Architect Practice Test 4

Question

Salesforce Certified Data Architect Practice Tests

Practice Tests