[Aug-2023] Download Real Salesforce Data-Architect Exam Dumps Test Engine Exam Questions [Q98-Q114]

Rate this post

[Aug-2023] Download Real Salesforce Data-Architect Exam Dumps Test Engine Exam Questions

New Data-Architect exam dumps Use Updated Salesforce Exam

Salesforce Certified Data Architect certification is highly valued in the industry, as it demonstrates the candidate’s ability to design and implement complex data architectures in Salesforce. It is particularly relevant for professionals who work in fields such as data management, business intelligence, analytics, and data science. Salesforce Certified Data Architect certification is recognized by leading organizations around the world and is a valuable asset for anyone looking to advance their career in the Salesforce ecosystem.

Q98. 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 data is duplicated across all these system 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

Data loss and recovery

Data standardization

Data duplication

Data accuracy and quality

Data completeness

Q99. A customer wants to maintain geographic location information including latitude and longitude in a custom object. What would a data architect recommend to satisfy this requirement?

Recommend app exchange packages to support this requirement.

Create formula fields with geolocation function for this requirement.

Create custom fields to maintain latitude and longitude information

Create a geolocation custom field to maintain this requirement

Q100. 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?

Use unbounded date ranges to filter the report.

Use Formula fields to surface information I related entities on the report.

Use an indexed data field with bounded data filters.

Use triggers to populate denormalized related fields on the Account.

Q101. Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?

Create a picklist field, values sorted alphabetically.

Create a Master -Detail to custom object ShippingStatus c.

Create a Lookup to custom object ShippingStatus c.

Create a text field and make it an external ID.

Q102. UC has to built a B2C ecommerce site on Heroku that shares customer and order data with a Heroku Postgres database. UC is currently utilizing Postgres as the single source of truth for both customers and orders. UC has asked a data architect to replicate the data into salesforce so that salesforce can now act as the system of record.
What are the 3 considerations that data architect should weigh before implementing this requirement? Choose 23 answers:

Consider whether the data is required for sales reports, dashboards and KPI’s.

Determine if the data is driver of key process implemented within salesforce.

Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application.

Ensure the data is CRM center and able to populate standard of custom objects.

A selection of the tool required to replicate the data.

Q103. Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel. NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption.
What should a data architect recommend to increase Salesforce adoption?

Use the Excel connector to Salesforce to sync data from individual Excel files.

Define a standard mapping and train sales users to import opportunity data.

Load data in external database and provide access to database to sales users.

Create a chatter group and upload all Excel files to the group.

Q104. Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode.
What should an Architect consider when loading the Opportunity records?

Use the Name field values to sort batches.

Group batches by the AccountId field.

Create indexes on Opportunity object text fields.

Order batches by Auto-number field.

Q105. Universal Containers wishes to maintain Lead data from Leads even after they are deleted and cleared from the Recycle Bin. What approach should be implemented to achieve this solution?

Use a Converted Lead report to display data on Leads that have been deleted.

Send data to a Data Warehouse and mark Leads as deleted in that system.

Use a Lead standard report and filter on the IsDeleted standard field.

Query Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.

Q106. Universal Container has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master Sales team are complaining about duplicate account and data quality issues with account data.
Which two solution should a data architect recommend to resolve the complaints?

Build a nightly batch job to de-dupe data, and merge account records.

Build a nightly sync job from ERP to Salesforce.

Implement a de-dupe solution and establish account ownership in Salesforce

Integrate Salesforce with ERP, and make ERP as system of truth.

Q107. Universal Containers (UC) is building a Service Cloud call center application and has a multisystem support solution. UC would like or ensure that all systems have access to the same customer information.
What solution should a data architect recommend?

Make Salesforce the system of record for all data.

Implement a master data management (MDM) strategy for customer data.

Load customer data in all systems.

Let each system be an owner of data it generates.

Q108. Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting performance issues and time-outs while running case reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?

Contact Salesforce support to enable skinny table for cases.

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

Create a custom object to store aggregate data and run reports.

Build reports using custom Lightning components.

Q109. An Architect needs information about who is creating, changing, or deleting certain fields within the past four months.
How can the Architect access this information?

Create a field history report for the fields in question.

After exporting the metadata, search it for the fields in question.

Remove “customize application” permissions from everyone else.

After exporting the setup audit trail, find the fields in question.

Q110. A company has 12 million records, and a nightly integration queries these records.
Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

Create a formula field instead of having multiple filter criteria.

Create custom indexes on the fields used in the filter criteria.

Modify the integration users’ profile to have View All Data.

Make sure the query doesn’t contain NULL in any filter criteria.

Q111. NTO has implemented salesforce for its sales users. The opportunity management in salesforce is implemented as follows:
1. Sales users enter their opportunities in salesforce for forecasting and reporting purposes.
2. NTO has a product pricing system (PPS) that is used to update opportunity amount field on opportunities on a daily basis.
3. PPS is the trusted source within the NTO for opportunity amount.
4. NTO uses opportunity forecast for its sales planning and management.
Sales users have noticed that their updates to the opportunity amount field are overwritten when PPS updates their opportunities.
How should a data architect address this overriding issue?

Change opportunity amount field access to read only for sales users using field level security.

Change PPS integration to update only opportunity amount fields when values is NULL.

Create a custom field for opportunity amount that PPS updates separating the field that sales user updates.

Create a custom field for opportunity amount that sales users update separating the fields that PPS updates.

Q112. Universal Containers is exporting 40 million Account records from Salesforce using Informatica Cloud. The ETL tool fails and the query log indicates a full table scan time-out failure. What is the recommended solution?

Modify the export query that includes standard index fields(s).

Modify the export job header to specify Export-in-Parallel.

Modify the export query with LIMIT clause with Batch size 10,000.

Modify the export job header to specify Sforce-Enable-PKChunking.

Q113. 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?

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

Leverage Apex class to decrypt data before exporting it.

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

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

Q114. For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems?

Let a “system user” own all the Account records and make this user part of the highest-level role in the Role Hierarchy.

Let a “system user” own all the Account records without assigning any role to this user in Role Hierarchy.

Let a “system user” own the Account records and assign this user to the lowest-level role in the Role Hierarchy.

Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.

Pass Your Data-Architect Dumps as PDF Updated on 2023 With 259 Questions: https://www.dumpleader.com/Data-Architect_exam.html

Leave a Reply Cancel reply