Special Summer Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

Data-Architect Exam Dumps - Salesforce Application Architect Questions and Answers

Question # 4

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?

Options:

A.

Use triggers to populate denormalized related fields on the Account.

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 unbounded date ranges to filter the report.

Buy Now
Question # 5

UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality.

Which 2 solutions should a data architect recommend to monitor and measure data quality?

Choose 2 answers.

Options:

A.

Use custom objects and fields to identify issues.

B.

Review data quality reports and dashboards.

C.

Install and run data quality analysis dashboard app

D.

Export data and check for data completeness outside of Salesforce.

Buy Now
Question # 6

UC has migrated its Back-office data into an on-premise database with REST API access. UC recently implemented Sales cloud for its sales organization. But users are complaining about a lack of order data inside SF.

UC is concerned about SF storage limits but would still like Sales cloud to have access to the data.

Which design patterns should a data architect select to satisfy the requirement?

Options:

A.

Migrate and persist the data in SF to take advantage of native functionality.

B.

Use SF Connect to virtualize the data in SF and avoid storage limits.

C.

Develop a bidirectional integration between the on-premise system and Salesforce.

D.

Build a UI for the on-premise system and iframe it in Salesforce

Buy Now
Question # 7

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

Options:

A.

Use SOQL queries without WHERE conditions.

B.

Work with Salesforce Support to enable Skinny Tables.

C.

Reduce the number of triggers on Order _c object.

D.

Make the queries more selective using indexed fields.

Buy Now
Question # 8

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
Question # 9

A customer is operating in a highly reputated industry and is planning to implement SF. The customer information maintained in SF, includes the following:

  • Personally, identifiable information (PII)
  • IP restrictions on profiles organized by Geographic location
  • Financial records that need to be private and accessible only by the assigned Sales associate.
  • User should not be allowed to export information from Salesforce.

Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity. Which 3 Salesforce shield capabilities should a data architect recommend? Choose 3 answers:

Options:

A.

Event monitoring to monitor all user activities

B.

Restrict access to SF from users outside specific geography

C.

Prevent Sales users access to customer PII information

D.

Transaction security policies to prevent export of SF Data.

E.

Encrypt Sensitive Customer information maintained in SF.

Buy Now
Question # 10

NTO need to extract 50 million records from a custom object everyday from its Salesforce org. 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
Question # 11

Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture? Choose 2 answers

Options:

A.

Engage with IT program managers to assess current velocity of projects in the pipeline.

B.

Engage with database administrators to assess current database performance metrics.

C.

Engage with executive sponsorship to assess enterprise data strategy and goals.

D.

Engage with business units and IT to assess current operational systems and data models.

Buy Now
Question # 12

Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they've purchased UC's new support service. Customers are expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1% of existing non-categorized customers to purchase UC's new support service every month over the next five years. What is the recommended solution to ensure long-term performance, bearing in mind the above requirements?

Options:

A.

Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.

B.

Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.

C.

Implement a new Categories custom object and a master-detail relationship from Account to Category.

D.

Implement a new Categories custom object and create a lookup field from Account to Category.

Buy Now
Question # 13

Universal Containers is creating a new B2C service offering for consumers to ship goods across continents. This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored. What is the recommended data model for consumer account data to be stored in Salesforce?

Options:

A.

Use the Account object with Person Accounts and a new B2C page layout.

B.

Use the Account object with a newly created Record Type for B2C customers.

C.

Create a new picklist value for B2C customers on the Account Type field.

D.

Use 50 umbrella Accounts for each region, with customers as associated Contacts.

Buy Now
Exam Code: Data-Architect
Exam Name: Salesforce Certified Data Architect (WI25)
Last Update: Mar 29, 2025
Questions: 253
Data-Architect pdf

Data-Architect PDF

$25.5  $84.99
Data-Architect Engine

Data-Architect Testing Engine

$28.5  $94.99
Data-Architect PDF + Engine

Data-Architect PDF + Testing Engine

$40.5  $134.99