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 trailing % wildcards.
• B.Performing large loads and deletions.
• C.Using a custom index on a deterministic formula field.
• D.Using NOT and != operators.
• E.Using leading % wildcards.

Comment: *

Name: *

Email: *

Verification: *

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.

• A.Export Bulk API in parallel mode
• B.Use PK Chunking
• C.Limit Batch to 10K records
• D.Export in multiple batches

Comment: *

Name: *

Email: *

Verification: *

UC has a salesforce org with multiple automated processes defined for group membership process. UC also have multiple admins on staff that perform manual adjustments to the role hierarchy. The automated task and manual task overlap daily and UC is experiencing "Lock errors" consistently.
What should a data architect recommend mitigate these errors?

• A.Enable sharing recalculations
• B.Remove SOQL statements from APEX loops.
• C.Ask salesforce support for addition CPU power.
• D.Enable granular locking.

Comment: *

Name: *

Email: *

Verification: *

During the implementation of Salesforce, a customer has the following requirements for Sales Orders:
1. Sales Order information needs to be shown to users in Salesforce.
2. Sales Orders are maintained in the on-premises enterprise resource planning (ERP).
3. Sales Order information has more than 150 million records.
4. Sales Orders will not be updated in Salesforce.
What should a data architect recommend for maintaining Sales Orders in salesforce?

• A.Use custom big objects to maintain Sales Orders in Salesforce.
• B.Use external objects to maintain Sales Order in Salesforce.
• C.Use Standard order object to maintain Sale Orders in Salesforce
• D.Us custom objects to maintain Sales Orders in Salesforce.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week.
After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference. Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted. What statement is true with respect to a data archiving strategy for UC?

• A.UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs.
• B.UC can leverage a "tier"-based approach to classify the record storage need.
• C.UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.
• D.UC can store long-term lead records in custom storage objects to avoid counting against storage limits.

Comment: *

Name: *

Email: *

Verification: *