Winter Special Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

Data-Architect Salesforce Certified Data Architect (SU24) Questions and Answers

Questions 4

Universal Containers (UC) has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discountrequest. UC has opportunity as master and custom line item object as detail in master-detail relationship. UC also has a custom line item object as master and a custom discount request object as detail in another master-detail relationship. UC has a requirement to show all sums of discounts across line items at an opportunity level. What is the recommended solution to address these requirements?

Options:

A.

Use roll-up for the line-item-level summary and a trigger for the opportunity amount summary, as only onelevel roll-up is allowed.

B.

Update the master-detail relationships to lookup relationships in order to allow the discount amount to roll up.

C.

Remove the master-detail relationships and rely completely on workflow/triggers to summarize the discount amount.

D.

Roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level.

Buy Now
Questions 5

NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to runand sometimes failed to load, throwing a time out error.

Which 3 options should help improve the dashboard performance?

Choose 3 answers:

Options:

A.

Use selective queries to reduce the amount of data being returned.

B.

De-normalize the data by reducing the numberof joins.

C.

Remove widgets from the dashboard to reduce the number of graphics loaded.

D.

Run the dashboard for CEO and send it via email.

E.

Reduce the amount of data queried by archiving unused opportunity records.

Buy Now
Questions 6

Universal Container has implemented Sales Cloud to manage patient and related health records. During a recent security audit of the system, it was discovered that same standard and custom fields need to encrypted.

Which solution should a data architect recommend to encrypt existing fields?

Options:

A.

Use Apex Crypto Class encrypt customer and standard fields.

B.

Implement classic encryption toencrypt custom and standard fields.

C.

Implement shield platform encryption to encrypt and standard fields

D.

Expert data out of Salesforce and encrypt custom and standard fields.

Buy Now
Questions 7

Universal Containers (UC) has multi -level account hierarchies that represent departmentswithin their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments. What two solutions should UC implement to cleanse their data? Choose 2 answers

Options:

A.

Make use of a third -party tool to help merge duplicate Contacts across Accounts.

B.

Use Data.com to standardize Contact address information to help identify duplicates.

C.

Use Workflow rules to standardize Contact information to identify and prevent duplicates.

D.

Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.

Buy Now
Questions 8

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?

Options:

A.

Createa custom object to store aggregate data and run reports.

B.

Contact Salesforce support to enable skinny table for cases.

C.

Move data off of the platform and run reporting outside Salesforce, and give access to reports.

D.

Build reports using custom Lightning components.

Buy Now
Questions 9

Universal Containers has successfully migrated 50 million records into five different objects multiple times in a full copy sandbox. The Integration Engineer wants to re-run the test again a month before it goeslive into Production. What is the recommended approach to re-run the test?

Options:

A.

Truncate all 5 objects quickly and re-run the data migration test.

B.

Refresh the full copy sandbox and re-run the data migration test.

C.

Hard delete all 5 objects’ data andre-run the data migration test.

D.

Truncate all 5 objects and hard delete before running the migration test.

Buy Now
Questions 10

Which two aspects of data does an Enterprise data governance program aim to improve?

Options:

A.

Data integrity

B.

Data distribution

C.

Data usability

D.

Data modeling

Buy Now
Questions 11

A large retail company has recently chosen SF as its CRM solution. They have the following record counts:

    2500000 accounts

    25000000 contacts

When doing an initial performance test, the data architect noticed an extremely slow response for reports and list views.

Whatshould a data architect do to solve the performance issue?

Options:

A.

Load only the data that the users is permitted to access

B.

Add custom indexes on frequently searched account and contact objects fields

C.

Limit data loading to the 2000 most recently created records.

D.

Create a skinny table to represent account and contact objects.

Buy Now
Questions 12

Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover anycorrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?

Options:

A.

Reduce data storage by purging old data.

B.

Implement an AppExchange package.

C.

Review projecteddata storage needs.

D.

Schedule a weekly export file.

Buy Now
Questions 13

Northern Trail Outfitters (NTO) has the following systems:

Customer master-source of truth for customer information

Service cloud-customer support

Marketing cloud-marketing support

Enterprise data warehouse—business reporting

The customer datais duplicated across all these systems and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call into update their information.

NTO is planning to implement master data management (MDM) solution across the enterprise.

Which three data will an MDM tool solve?

Choose 3 answers

Options:

A.

Data completeness

B.

Data loss and recovery

C.

Data duplication

D.

Data accuracy and quality

E.

Data standardization

Buy Now
Questions 14

Universal Containers (UC) has implemented Sales Cloud for its entire salesorganization, UC has built a custom object called projects_c that stores customers project detail and employee bitable hours.

The following requirements are needed:

A subnet of individuals from the finance team will need to access to the projects object for reporting and adjusting employee utilization.

The finance users will not access to any sales objects, but they will need to interact with the custom object.

Which license type a data architect recommend for the finance team that best meets the requirements?

Options:

A.

Service Cloud

B.

Sales Cloud

C.

Light Platform Start

D.

Lighting platform plus

Buy Now
Questions 15

NTO need to extract 50 million records from a custom object everyday from its Salesforceorg. NTO is facing query timeout issues while extracting these records.

What should a data architect recommend in order to get around the time out issue?

Options:

A.

Use a custom auto number and formula field and use that to chunk records while extracting data.

B.

The REST API to extract data as it automatically chunks records by 200.

C.

Use ETL tool for extraction of records.

D.

Ask SF support to increase the query timeout value.

Buy Now
Questions 16

What makes Skinny tables fast? Choose three answers.

Options:

A.

They do not include soft-deleted records

B.

They avoid resource intensive joins

C.

Their tables are kept in sync with their source tables when the source tables are modified

D.

They can contain fields from other objects

E.

They support up to a max of 100 of columns

Buy Now
Questions 17

A national nonprofitorganization is using Salesforce to recruit members. The recruitment process requires a member to be matched with a volunteer opportunity. Given the following:

1. A record is created in Project__ c and used to track the project through completion.

2. Themember may then start volunteering and is required to track their volunteer hours, which is stored in VTOTime_c object related to the project.

3. Ability to view or edit the VTOTime__c object needs to be the same as the Project__ c

record.

4. Managers must see total hours volunteered while viewing the Project__ c record.

Which data relationship should the data architect use to support this requirementwhencreating the custom VTOTime__c object?

Options:

A.

Lookup Field on Project_c to VTOTime_c displaying a listof VTOTime__c in

a related list.

B.

Lookup field on VTOTime_c to Project_c with formula filed on Project__ c

showing Sum of hours from VTOTime__c records.

C.

Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project __c showing sum of hours from VTOTime_c records.

D.

Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.

Buy Now
Questions 18

UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups.During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported. What should a data architect recommend to make sure decrypted values are exported during data export?

Options:

A.

Set a standard profile for Data Migration user, and assign view encrypted data

B.

Create another field to copy data from encrypted field and use this field in export

C.

Leverage Apex class to decrypt data before exporting it.

D.

Set up a custom profile for data migration user and assign view encrypted data.

Buy Now
Questions 19

Universal Containers has a requirement to store more than 100 million records in salesforce and needs to create a custom big object to support this business requirement.

Which two tools should a data architect use to build custom object?

Options:

A.

Use DX to create big object.

B.

Use Metadata API to create big object.

C.

Go to Big Object in setup select new to create big object.

D.

Go to Object Manager in setup and select new to create big object.

Buy Now
Questions 20

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:

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.

Buy Now
Questions 21

Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers

Options:

A.

Use a workflow to check and prevent duplicates.

B.

Clean data before importing to Salesforce.

C.

Use Salesforce matching and duplicate rules.

D.

Import the data concurrently.

Buy Now
Questions 22

A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?

Options:

A.

Import Account records first followed by order records after sorting order by OrderID.

B.

Import Account records first followed by order records after sorting orders by AccountID.

C.

Change the relationship to Lookup and update the relationshipto master-detail after import.

D.

Import Order records and Account records separately and populate AccountID in orders using batch Apex.

Buy Now
Questions 23

Based on government regulations, a Salesforce customer plans to implement the following in Salesforce for compliance:

Access to customer information based on record ownership

Ability for customers to request removal of their information from Salesforce

Prevent users from accessing Salesforce from outside company network (virtual private network, or VPN)

What should a data architect recommend to address these requirements?

Options:

A.

Contact Salesforce support to restrict access only with VPNand other requirements

B.

Allow users access to Salesforce through a custom web application hosted within VPN.

C.

Implement IP restrictions, sharing settings, and custom Apex to support customer requests.

D.

Implement Salesforce shield with Event Monitoring to address the requirement.

Buy Now
Questions 24

Universal Containers (UC) has implemented a master data management strategy, which uses a central system of truth, to ensure the entire company has the same customer information in all systems. UC customer data changes need to be accurate at all times in all of the systems. Salesforce is the identified system of record for this information.

What is the correct solution for ensuring all systems using customer data are kept up to date?

Options:

A.

Send customer data nightly to the system of truth in a scheduled batch job.

B.

Send customer record changes from Salesforce to each system in a nightly batch job.

C.

Send customer record changes from Salesforce to the system of truth in real time.

D.

Have each system pull the record changes from Salesforce using change data capture.

Buy Now
Exam Code: Data-Architect
Exam Name: Salesforce Certified Data Architect (SU24)
Last Update: Dec 2, 2024
Questions: 253

PDF + Testing Engine

$66  $164.99

Testing Engine

$50  $124.99
buy now Data-Architect testing engine

PDF (Q&A)

$42  $104.99
buy now Data-Architect pdf