A company wants to document the data architecture of a Salesforce organization.
What are two valid metadata types that should be included? (Choose two.)

• A.RecordType
• B.Document
• C.CustomField
• D.SecuritySettings

Comment: *

Name: *

Email: *

Verification: *

Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?

• A.Move data off of the platform and run reporting outside Salesforce, and give access to reports.
• B.Create a custom object to store aggregate data and run reports.
• C.Contact Salesforce support to enable skinny table for cases.
• D.Build reports using custom Lightning components.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers has a custom object with millions of rows of data.
When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)

• A.Using leading % wildcards.
• B.Using trailing % wildcards.
• C.Performing large loads and deletions.
• D.Using NOT and != operators.
• E.Using a custom index on a deterministic formula field.

Comment: *

Name: *

Email: *

Verification: *

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 unbounded date ranges to filter the report.
• 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 triggers to populate denormalized related fields on the Account.

Comment: *

Name: *

Email: *

Verification: *

UC has a requirement to migrate 100 million order records from a legacy ERP application into the salesforce platform. UC does not have any requirements around reporting on the migrated data.
What should a data architect recommend to reduce the performance degradation of the platform?

• A.Create a custom object to store the data.
• B.Use a standard big object defined by salesforce.
• C.Use the standard "Order" object to store the data.
• D.Implement a custom big object to store the data.

Comment: *

Name: *

Email: *

Verification: *