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 performat?
A. Remove
description from the requested field set.
B. Change query to SOSL.
C. Add limit 100 to the query.
D. Change the where clause to filter by a deterministic defined value.
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 when implementing 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.
Universal Containers has provided a web order form for its customer and has noticed invalid data coming in on orders. What should be used to mitigate this problem?
A. Work
Flow Rules
B. Formatted Fields
C. Apex Trigger
D. Validation Rules
Universal Containers (UC) owns several Salesforce orgs across a variety of business units. UC management has declared that it needs the ability to report on Accounts and Opportunities from each org in one place. Once the data is brought together into a global view, management would like to use advanced Al-driven analytics on the dataset. Which tool should a data architect recommend to accomplish this reporting requirement?
A. Run
standard reports and dashboards.
B. Install a third-party AppExchange tool for multi-org reporting.
C. Use Einstein Analytics for multi-org.
D. Write a Python script to aggregate and visualize the data.
Universal Containers (UC) has built a custom application on Salesforce to help track shipments around the world. A majority of the shipping records are stored on premise in an external data source. UC needs shipment details to be exposed to the custom application, and the data needs to be accessible in real time. The external data source is not OData enabled, and UC does not own a middleware tool. Which Salesforce Connect procedure should a data architect use to ensure UC's requirements are met?
A. Write
an Apex class that makes a REST callout to the external API.
B. Develop a process that calls an inviable web service method.
C. Migrate the data to Heroku and register Postgres as a data source.
D. Write a custom adapter with the Apex Connector Framework.
Cloud Kicks has the following requirements: • Their Shipment custom object must always relate to a Product, a Sender, and a Receiver (all separate custom objects). • If a Shipment is currently associated with a Product, Sender, or Receiver, deletion of those records should not be allowed. • Each custom object must have separate sharing models. What should an Architect do to fulfill these requirements?
A. Associate the Shipment to each parent record by using a VLOOKUP formula field.
B. Create a required Lookup relationship to each of the three parent records.
C. Create a Master-Detail relationship to each of the three parent records.
D. Create two Master-Detail and one Lookup relationship to the parent records.
Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers
A. Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.
B. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
C. Turn on field Contact object history tracking for these ten fields, then create reports on contact history.
D. Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.
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?
A. Remove description from the requested field set.
B. Change query to SOSL. ??
C. Add limit 100 to the query.
D. Change the where clause to filter by a deterministic defined value.
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?
A. Customer community.
B. Lightning external apps starter.
C. Customer community plus.
D. Partner community.
Developers at Universal Containers need to build a report 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 should be 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.