NO.10 Ursa Major Solar provides home installment services to its customers. To track these home installments, the company uses Opportunities. At any given time, the status of the home installments can be one of the 10 values. Currently, Ursa Major Solar has 189,000 Opportunity records.
An Architect needs to create a new field to track home installment status opportunity while also improving data quality and avoiding data skew.
What should the Architect do?

NO.11 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?

NO.12 In a Salesforce org used to manage Contacts, what two options should be considered to maintain data quality? Choose 2 answers

NO.13 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?

NO.14 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?

NO.15 Universal Containers (UC) is implementing Salesforce and will be using Salesforce to 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?

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

NO.17 What makes Skinny tables fast? Choose three answers.

NO.18 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?

NO.19 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 as comma-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 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 Cloud to send marketing communications. The number of records in the Lead object has grown over time and has 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?

NO.20 Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce?

NO.21 The data architect for UC has written a SOQL query that will return all records from the Task object that do not have a value in the WhatId field:
Select id, description, Subject from Task where WhatId != NULL
When the data architect usages the query to select values for a process a time out error occurs.
What does the data architect need to change to make this query more performant?

NO.22 Universal containers is implementing Salesforce lead management. UC Precure 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

NO.23 A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:
State in which the customer is located
City in which the customer is located if available
Zip code In which the customer is located if available
Changes to this information should have minimum code changes
What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?

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

NO.25 UC is trying to switch from legacy CRM to salesforce and wants to keep legacy CRM and salesforce in place till all the functionality is deployed in salesforce. The want to keep data in synch b/w Salesforce, legacy CRM and SAP. What is the recommendation.

NO.26 A large Automobile company has implemented SF for its Sales Associates. Leads flow from its website to SF using a batch integration in SF. The Batch job connects the leads to Accounts in SF. Customer visiting their retail stores are also created in SF as Accounts.
The company has noticed a large number of duplicate accounts in SF. On analysis, it was found that certain customers could interact with its website and also visit the store. The Sales associates use Global Search to search for customers in Salesforce before they create the customers.
Which scalable option should a data Architect choose to implement to avoid duplicates?

NO.27 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.

NO.28 DreamHouse Realty has 15 million records in the Order_c custom object. When running a bulk query, the query times out.
What should be considered to address this issue?

NO.29 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?

NO.30 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

NO.31 Members of DreamHouse Realty sales team are reporting that searches are yielding too many irrelevant, outdated records. Management requires that data for historical reporting. DreamHouse Realty has enough data storage.
In this situation, which strategy should a data architect use to ensure a better user experience for the Sales Reps?

NO.32 Which two automated approaches should an architect recommend to purge old data out of Salesforce and aggregate that data in Salesforce? Choose 2 answers