New Year Sale - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

Data-Architect Questions and Answers

Question # 6

UC is planning a massive SF implementation with large volumes of data. As part of the org’s implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner.

What should a data architect do to minimize data load times due to system calculations?

A.

Enable defer sharing calculations, and suspend sharing rule calculations

B.

Load the data through data loader, and turn on parallel processing.

C.

Leverage theBulk API and concurrent processing with multiple batches

D.

Enable granular locking to avoid “UNABLE _TO_LOCK_ROW” error.

Full Access
Question # 7

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?

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 8

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?

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 9

US has released a newdisaster 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?

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 10

Universal Containers is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and a automated updates at the same time.

What should a data architect do in order to restore the issue?

A.

Enable granular locking

B.

Enable parallel sharing rule calculation.

C.

Enable defer sharing calculation

D.

Enable implicit sharing

Full Access
Question # 11

Universal Containers (UC) uses the following Salesforce products:

Sales Cloud for customer management.

Marketing Cloud for marketing.

Einstein Analytics for business reporting.

UC occasionally gets a list of prospects from third-party source ascomma-separated values (CSV) files for marketing purposes. Historically, UC would load contact Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has beenconsuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time andhas been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process.

What should a data architect recommend to UC in order to immediately avoid storage issues in the future?

A.

Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications ;

B.

Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications.

C.

Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.

D.

Continue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales after the sync is complete.

Full Access
Question # 12

Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode.

What should an Architect consider when loading the Opportunity records?

A.

Use the Name field values to sort batches.

B.

Order batches by Auto-number field.

C.

Create indexes on Opportunity object text fields.

D.

Group batches by the AccountId field.

Full Access
Question # 13

Developers at Universal Containers need to build areport 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 shouldbe 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 I related entities on the report.

D.

Use unbounded date ranges to filter the report.

Full Access
Question # 14

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?

A.

Archive Case data using Salesforce Archiving process

B.

Purchase more data storage to support case object

C.

Use a custom object to store archived case data.

D.

Use a custom Big object to store archived case data.

Full Access
Question # 15

DreamHouse Realty has a Salesforce org that is used to manage Contacts.

What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.)

A.

Use the private sharing model.

B.

Use Salesforce duplicate management.

C.

Use validation rules on new record create and edit.

D.

Use workflow to delete duplicate records.

Full Access
Question # 16

UC has a legacy client server app that as a relational data base that needs to be migrated to salesforce.

What are the 3 key actions that should be done when data modeling in salesforce?

Choose 3 answers:

A.

Identify data elements to be persisted in salesforce.

B.

Map legacy data to salesforce objects.

C.

Map legacy data to salesforce custom objects.

D.

Work with legacy application owner to analysis legacy data model.

E.

Implement legacy data model within salesforce using custom fields.

Full Access
Question # 17

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

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

Full Access
Question # 18

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

A.

Index key fields used in report criteria.

B.

Enable Divisions for large data objects.

C.

Create one skinny table per report.

D.

Share each report with fewer users.

Full Access
Question # 19

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 20

UC has multiple SF orgs that aredistributed 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 ofthe 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?

A.

Consolidate the data from each org into a centralized datastore

B.

Use Salesforce Connect’s cross-org adapter.

C.

Build a bidirectional integration between all orgs.

D.

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

Full Access
Question # 21

Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.

What is the fastest and most effective way for a data architect to solve the time-out issue?

A.

Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunityobject.

B.

Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.

C.

Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on It.

D.

Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

Full Access
Question # 22

Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.

Which two approaches should an Architect recommend to enforce the plan throughout the organization? (Choose two.)

A.

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

B.

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

C.

Enforce critical business processes by using Workflow, Validation Rules, and Apex code.

D.

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

Full Access
Question # 23

Universal Containers (UC) is implementing Salesforce and will be using Salesforceto track customer complaints, provide white papers on products, and provide subscription based support.

Which license type will UC users need to fulfill UC's requirements?

A.

Sales Cloud License

B.

Lightning Platform Starter License

C.

Service Cloud License

D.

Salesforce License

Full Access
Question # 24

UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this? Choose two answers.

A.

Export in multiple batches

B.

Export Bulk API in parallel mode

C.

Use PK Chunking

D.

Limit Batch to 10K records

Full Access
Question # 25

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 NTOusing 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:

A.

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

B.

Develop an object relationship strategy.

C.

Identify the external tables to sync into external objects

D.

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

E.

Configure a middleware tool to poll external table data

Full Access
Question # 26

Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.

What should a data architect recommend to guarantee that records are not being updated at the same time?

A.

Embed the keywords FOR UPDATE after SOQL statements.

B.

Disable classes or triggers that have the potential to obtain thesame record.

C.

Migrate programmatic logic to processes and flows.

D.

Refactor or optimize classes and trigger for maximum CPU performance.

Full Access
Question # 27

Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations.

Which two solutionshould a data architect recommend to mitigate data quality issues?

A.

Leverage picklist and lookup fields where possible

B.

Leverage Apex to validate the format of data being entered via a mobile device.

C.

Leverage validation rules and workflows.

D.

Leverage third-party- AppExchange tools

Full Access
Question # 28

Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?

A.

Create new custom fields fortemperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received.

B.

Create a new Container Reading custom object, which iscreated when a new measure is received for a specific container. The Container Reading custom object has a master-detail relationship to the container object.

C.

Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC’s existing data warehouse.

D.

Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour.

Full Access
Question # 29

DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to anyBranch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year.

A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.

What are two important considerations for the Data Architect in this scenario? (Choose two.)

A.

Standard list view in-line editing.

B.

Limitations on Org data storage.

C.

Bulk API limitations on picklist fields.

D.

Limitations on master-detail relationships.

Full Access
Question # 30

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 managementwants 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?

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 31

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.

A.

Use custom objects and fieldsto identify issues.

B.

Review data quality reports and dashboards.

C.

Install and run data quality analysis dashboard app

D.

Export data and check for data completeness outside of Salesforce.

Full Access
Question # 32

Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several optionsare being considered, including analytics snapshots, offsite storage, scheduled purges, etc. Which three questions should be considered when designing an appropriate archiving strategy?

A.

How many fields are defined on the custom objects that need to be archived?

B.

Which profiles and users currently have access to these custom object records?

C.

If reporting is necessary, can the information be aggregated into fewer, summary records?

D.

Will the data being archived need to be reported on or accessed inany way in the future?

E.

Are there any regulatory restrictions that will influence the archiving and purging plans?

Full Access
Question # 33

Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:

- Accounts

- Contacts

- Opportunities

- Orders

- Order Line Items

Which issue will an architect have whenimplementing this in Salesforce?

A.

Custom report types CANNOT contain Opportunity data.

B.

Salesforce does NOT support Orders or Order Line Items.

C.

Salesforce does NOT allow more than four objects in a single report type.

D.

A report CANNOT contain data from Accounts and Contacts.

Full Access