Assume Salesforce Data-Architect Dumps PDF Are going to be The Best Score [Q10-Q25]

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

Build synchronization reports and dashboards.

Utilize workbench to update files within systems.

Q11. Universal Containers (UC) is in the process of migrating legacy inventory data from an enterprise resources planning (ERP) system into Sales Cloud with the following requirements:
Legacy inventory data will be stored in a custom child object called Inventory_c.
Inventory data should be related to the standard Account object.
The Inventory object should Invent the same sharing rules as the Account object.
Anytime an Account record is deleted in Salesforce, the related Inventory_c record(s) should be deleted as well.
What type of relationship field should a data architect recommend in this scenario?

Master-detail relationship filed on Account, related to Inventory_c

Master-detail relationship filed on Inventory_c, related to Account

Indirect lookup relationship field on Account, related to Inventory_c

Lookup relationship fields on Inventory related to Account

According to the Salesforce documentation, a relationship field is a field that allows linking one object to another object in Salesforce. There are different types of relationship fields that have different characteristics and behaviors, such as master-detail, lookup, indirect lookup, external lookup, etc.
To recommend a type of relationship field for this scenario, where legacy inventory data will be stored in a custom child object called Inventory__c, inventory data should be related to the standard Account object, the Inventory__c object should inherit the same sharing rules as the Account object, and anytime an Account record is deleted in Salesforce, the related Inventory__c record(s) should be deleted as well, a data architect should recommend:
Master-detail relationship field on Inventory__c, related to Account (option B). This means creating a field on the Inventory__c object that references the Account object as its parent. A master-detail relationship field establishes a parent-child relationship between two objects, where the parent object controls certain behaviors of the child object. For example, a master-detail relationship field can:
Inherit the sharing and security settings from the parent object to the child object. This means that the users who can access and edit the parent record can also access and edit the related child records.
Cascade delete from the parent object to the child object. This means that when a parent record is deleted, all the related child records are also deleted.
Roll up summary fields from the child object to the parent object. This means that the parent object can display aggregated information from the child records, such as count, sum, min, max, or average.
Master-detail relationship field on Account, related to Inventory__c (option A) is not a good solution, as it reverses the direction of the relationship. This means creating a field on the Account object that references the Inventory__c object as its parent. This is not possible, as a standard object cannot be on the detail side of a master-detail relationship. Indirect lookup relationship field on Account, related to Inventory__c (option C) is also not a good solution, as it is a special type of relationship field that allows linking a custom object to a standard object on an external system using an indirect reference. This is not applicable for this scenario, as both objects are in Salesforce and do not need an external reference. Lookup relationship field on Inventory__c related to Account (option D) is also not a good solution, as it establishes a looser relationship between two objects than a master-detail relationship. A lookup relationship field does not inherit sharing and security settings from the parent object to the child object, does not cascade delete from the parent object to the child object, and does not roll up summary fields from the child object to the parent object.

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

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.

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

Export in multiple batches

Export Bulk API in parallel mode

Use PK Chunking

Limit Batch to 10K records

Q14. Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce. What approach should be suggested to address this requirement?

Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.

Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.

Store all data in shadow custom objects on any updates and deletes, and extract them as needed .

Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

Q15. NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external. Which API is the best fit for accomplishing this task?

Tooling API

SOAP API

Metadata API

Bulk API in serial mode

Q16. An Architect needs information about who is creating, changing, or deleting certain fields within the past four months.
How can the Architect access this information?

Create a field history report for the fields in question.

After exporting the metadata, search it for the fields in question.

Remove “customize application” permissions from everyone else.

After exporting the setup audit trail, find the fields in question.

Q17. DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch 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.)

Standard list view in-line editing.

Limitations on Org data storage.

Bulk API limitations on picklist fields.

Limitations on master-detail relationships.

Q18. DreamHouse Realty has a Salesforce deployment that manages Sales, Support, and Marketing efforts in a multi-system ERP environment. The company recently reached the limits of native reports and dashboards and needs options for providing more analytical insights.
What are two approaches an Architect should recommend? (Choose two.)

Weekly Snapshots

Einstein Analytics

Setup Audit Trails

AppExchange Apps

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

Remove “customize application” permissions from everyone else.

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

Create a field history report for the fields in question.

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

Q20. Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.
Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

Number of records returned by report query.

Number of characters in report query.

Number of queries running at a time.

Number of joins used in report query.

Q21. Northern Trail Outfitters Is planning to build a consent form to record customer authorization for marketing purposes.
What should a data architect recommend to fulfill this requirement?

Use custom fields to capture the authorization details.

Create a custom object to maintain the authorization.

Utilize the Authorization Form Consent object to capture the consent.

Use AppExchange solution to address the requirement.

Q22. A data architect is working with a large B2C retailer and needs to model the consumer account structure in Salesforce.
What standard feature should be selected in this scenario?

Individual Accounts

Account Contact

Contacts

Person Accounts

Q23. 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:

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

Identify the external tables to sync into external objects

Configure a middleware tool to poll external table data

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

Develop an object relationship strategy.

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

Q25. Universal Containers (UC) needs to move millions of records from an external enterprise resource planning (ERP) system into Salesforce.
What should a data architect recommend to be done while using the Bulk API in serial mode instead of parallel mode?

Placing 20 batches on the queue for upset jobs.

Inserting 1 million orders distributed across a variety of accounts with potential lock exceptions.

Leveraging a controlled feed load with 10 batches per job.

Inserting 1 million orders distributed across a variety of accounts with lock exceptions eliminated and managed.