Easter Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Download Full Version Data-Architecture-And-Management-Designer Salesforce Exam

Salesforce Certified Data Architect (WI23) Questions and Answers

Question 25

Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunitystage.

Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

Options:

A.

Number of queries running at a time.

B.

Number of joins used in report query.

C.

Number of records returned by report query.

D.

Number of characters in report query.

Question 26

Northern Trail Outfitters has these simple requirements for a data export process:

File format should be in CSV.

Process should be scheduled and run once per week.

The expert should be configurablethrough the Salesforce UI.

Which tool should a data architect leverage to accomplish these requirements?

Options:

A.

Bulk API

B.

Data export wizard

C.

Third-party ETL tool

D.

Data loader

Question 27

Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing, UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC isexperiencing "lock errors" consistently.

What should a data architect recommend to mitigate these errors?

Options:

A.

Enable granular locking.

B.

Remove SOQL statements from Apex Loops.

C.

Enable sharing recalculations.

D.

Ask Salesforce support for additional CPUpower.

Question 28

Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records are created or updatesby users. A majority of the automation tool within UC’’ org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend.

What should a data architect do to mitigate any unwanted results during the import?

Options:

A.

Ensure validation rules, triggers and other automation tools are disabled.

B.

Ensure duplication and matching rules and defined.

C.

Import the data in smaller batches over a 24-hour period.

D.

Bulkily the trigger to handle importleads.