DATA-ARCHITECT Online Practice Questions and Answers

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?

A. Lightning platform starter license.

B. Service cloud license.

C. Salesforce license.

D. Sales cloud license

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 matching criteria.

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 standard matching 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.

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

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

B. Whether or not Salesforce replaced a legacy CRM.

C. Whether the system of record changes for different tables.

D. The number of systems that are integrating with each other.

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?

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

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

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

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

A. Limitations on master -detail relationships.

B. Org data storage limitations.

C. Bulk API limitations on picklist fields.

D. Standard list view in -line editing.

Cloud Kicks currently has a Public Read/Write sharing model for the company's Contacts. Cloud Kicks management team requests that only the owner of a contact record be allowed to delete that contact. What should an Architect do to meet these requirements?

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

B. Check if the current user is NOT the owner by creating a "before delete" trigger.

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

D. Check if the current user is NOT the owner by creating a validation rule on the Contact object.

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?

A. Leverage data loader platform API to load data.

B. Perform Batch job in parallel mode and reduce Batch size

C. Perform Batch job in serial mode and reduce batch size

D. Defer roll-up summary fields calculation during data migration.

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 data has both profile and location information? Option

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

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

C. Leverage external data providers populate company profile and location data

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

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?

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

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

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

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

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?

A. Load all data after deferring sharing calculations.

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

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

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

Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard are not reliable for their real-time decision-making. On analysis , the team the following issues

with data entered in Salesforce.

Information in certain records is incomplete.

Incorrect entry in certain fields causes records to be excluded in report fitters.

Duplicate entries cause incorrect counts.

Which three steps should a data architect recommend to address the issues?

A. Periodically export data to cleanse data and import them back into Salesforce for executive reports.

B. Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.

C. Explore third-party data providers to enrich and augment information entered in salesforce.

D. Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.

E. design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect

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?

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

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

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

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

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:

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

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

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

D. Leverage big object to archive case data and lightning components to show archived 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?

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

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

C. Use ETL tool for extraction of records.

D. Ask SF support to increase the query timeout value.

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?

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

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

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

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