Sure Pass Exam Data-Architect PDF

Salesforce Certified Data Architect (SP23) Questions and Answers

Question 25

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

Options:

Using leading % wildcards.

Using trailing % wildcards.

Performing large loads and deletions.

Using NOT and != operators.

Using a custom index on a deterministic formula field.

Question 26

US is implementing salesforce and will be using salesforce to track customer complaints, provide white papers on products and provide subscription (Fee) – based support.

Which license type will US users need to fulfil US’s requirements?

Options:

Lightning platform starter license.

Service cloud license.

Salesforce license.

Sales cloud license

Question 27

A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers

Options:

Review the metadata xml files for redundant fields to consolidate.

Determine if any integration points create records in Salesforce.

Run key reports to determine what fields should be required.

Export the setup audit trail to review what fields are being used.

Review the sharing model to determine impact on duplicate records.

Question 28

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?

Options:

Custom report types CANNOT contain Opportunity data.

Salesforce does NOT support Orders or Order Line Items.

Salesforce does NOT allow more than four objects in a single report type.

A report CANNOT contain data from Accounts and Contacts.

Weekend Sale Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Salesforce Certified Data Architect (SP23) Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer: