New 2025 Guaranteed Success with Actualtests4sure Data-Architect Dumps Salesforce PDF Questions
Exceptional Practice To Salesforce Certified Data Architect Pass the First Time
NEW QUESTION # 154
Universal Containers (UC) is implementing a Salesforce project with large volumes of data and daily transactions. The solution includes both real-time web service integrations and Visualforce mash -ups with back -end systems. The Salesforce Full sandbox used by the project integrates with full-scale back -end testing systems. What two types of performance testing are appropriate for this project?
Choose 2 answers
- A. Stress testing against the web services hosted by the integration middleware.
- B. Post go -live automated page -load testing against the Salesforce Production org.
- C. Pre -go -live automated page -load testing against the Salesforce Full sandbox.
- D. Pre -go -live unit testing in the Salesforce Full sandbox.
Answer: A,C
NEW QUESTION # 155
A large insurance provider is looking to implement Salesforce. The following exist.
1. Multiple channel for lead acquisition
2. Duplication leads across channels
3. Poor customer experience and higher costs
On analysis, it found that there are duplicate leads that are resulting to mitigate the issues?
- A. Build a custom solution to identify and merge duplicate leads.
- B. Implement third-party solution to clean and event lead data.
- C. Implement de-duplication strategy to prevent duplicate leads
- D. Standard lead information across all channels.
- E. Build process is manually search and merge duplicates.
Answer: B,C,D
NEW QUESTION # 156
UC has millions of case records with case history and SLA data. UC's compliance team would like historical cases to be accessible for 10 years for Audit purpose.
What solution should a data architect recommend?
- A. Use a custom Big object to store archived case data.
- B. Archive Case data using Salesforce Archiving process
- C. Purchase more data storage to support case object
- D. Use a custom object to store archived case data.
Answer: A
Explanation:
The best solution to store historical cases for 10 years for audit purpose is to use a custom Big object to store archived case data. Big objects are a type of custom object that can store massive amounts of data on the Salesforce platform without affecting performance or storage limits. They also support point-and-click tools, triggers, and Apex code. Big objects can be used for archiving historical data that needs to be retained for compliance or analytics purposes3. Archiving case data using Salesforce Archiving process is not a good option because it only supports archiving cases that are closed for more than one year, and it does not allow customizing the archival criteria or accessing the archived data via Apex or APIs4. Purchasing more data storage to support case object is expensive and may impact performance. Using a custom object to store archived case data is not scalable and may consume a lot of storage space.
NEW QUESTION # 157
Universal Containers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week. After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference. Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted. What statement is true with respect to a data archiving strategy for UC?
- A. UC can leverage a "tier"-based approach to classify the record storage need.
- B. UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.
- C. UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs.
- D. UC can store long-term lead records in custom storage objects to avoid counting against storage limits.
Answer: A
NEW QUESTION # 158
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 opportunity stage.
Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?
- A. Number of records returned by report query.
- B. Number of joins used in report query.
- C. Number of characters in report query.
- D. Number of queries running at a time.
Answer: A,B
NEW QUESTION # 159
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.
What should a data architect do to solve the performance issue?
- A. Create a skinny table to represent account and contact objects.
- B. Add custom indexes on frequently searched account and contact objects fields
- C. Limit data loading to the 2000 most recently created records.
- D. Load only the data that the users is permitted to access
Answer: B
NEW QUESTION # 160
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?
- A. Use triggers to populate denormalized related fields on the Account.
- B. Use unbounded date ranges to filter the report.
- C. Use an indexed data field with bounded data filters.
- D. Use Formula fields to surface information I related entities on the report.
Answer: B,C
NEW QUESTION # 161
Universal Container (US) is replacing a home grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis.
Which solution should a data architect recommend to meet business requirement?
- A. Leverage real-time integration to pull records into Salesforce.
- B. Leverage mashup to display historical records in Salesforce.
- C. Build a chair solution to go the legacy system and display records.
- D. Bring all data Salesforce, and delete it after a year.
Answer: B
NEW QUESTION # 162
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?
- A. Change opportunity amount field access to read only for sales users using field level security.
- B. Change PPS integration to update only opportunity amount fields when values is NULL.
- C. Create a custom field for opportunity amount that sales users update separating the fields that PPS updates.
- D. Create a custom field for opportunity amount that PPS updates separating the field that sales user updates.
Answer: A
Explanation:
Changing the opportunity amount field access to read only for sales users using field level security is the best way to address the overriding issue. This way, the sales users can still view the opportunity amount field but cannot edit it, and PPS can update it as the trusted source
NEW QUESTION # 163
UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.
What should a data architect recommend to ensure data quality is maintained in salesforce.
- A. Activate validation rules once the leads are loaded into salesforce to maintain quality.
- B. Ensure the lead data is preprocessed for quality before loading into salesforce.
- C. Allow validation rules to be activated during the load of leads into salesforce.
- D. Develop custom APEX batch process to improve quality once the load is completed.
Answer: D
NEW QUESTION # 164
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?
- A. Use Metadata API to create big object.
- B. Use DX to create big object.
- C. Go to Object Manager in setup and select new to create big object.
- D. Go to Big Object in setup select new to create big object.
Answer: A,D
Explanation:
To build a custom big object to support storing more than 100 million records in Salesforce, a data architect should use Metadata API or Big Object in setup. Metadata API is an API that allows developers to create, retrieve, update, or delete metadata components in Salesforce programmatically. Big Object in setup is a user interface that allows admins to create big objects declaratively without writing code. Both tools can be used to define custom big objects and their fields, indexes, and relationships in Salesforce. Option A is incorrect because DX (Developer Experience) is a set of tools that allows developers to create and manage applications on Salesforce Platform, but it does not support creating big objects directly. Option D is incorrect because Object Manager in setup is a user interface that allows admins to create and manage standard and custom objects in Salesforce, but it does not support creating big objects declaratively.
NEW QUESTION # 165
Universal Containers (UC) has built a custom application on Salesforce to help track shipments around the world. A majority of the shipping records are stored on premise in an external data source. UC needs shipment details to be exposed to the custom application, and the data needs to be accessible in real time. The external data source is not OData enabled, and UC does not own a middleware tool.
Which Salesforce Connect procedure should a data architect use to ensure UC's requirements are met?
- A. Write a custom adapter with the Apex Connector Framework.
- B. Develop a process that calls an inviable web service method.
- C. Migrate the data to Heroku and register Postgres as a data source.
- D. Write an Apex class that makes a REST callout to the external API.
Answer: A
NEW QUESTION # 166
Universal Containers (UC) uses the following Salesforce products:
Sales Cloud for customer management.
Marketing Cloud for marketing.
Einstein Analytics for business reporting.
UC occasionally gets a list of prospects from third-party source as comma-separated values (CSV) files for marketing purposes. Historically, UC would load contact Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process.
What should a data architect recommend to UC in order to immediately avoid storage issues in the future?
- A. Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.
- B. Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications ;
- C. Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications.
- D. Continue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales after the sync is complete.
Answer: B
NEW QUESTION # 167
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?
- A. Use the Account object with a newly created Record Type for B2C customers.
- B. Use 50 umbrella Accounts for each region, with customers as associated Contacts.
- C. Use the Account object with Person Accounts and a new B2C page layout.
- D. Create a new picklist value for B2C customers on the Account Type field.
Answer: C
Explanation:
The recommended data model for consumer account data to be stored in Salesforce is to use the Account object with Person Accounts and a new B2C page layout. Person Accounts are a special type of accounts that allow you to store information about individual consumers who are not associated with a business account2. Person Accounts have the following advantages3:
They allow you to use the same standard objects and features that you use for business accounts, such as contacts, opportunities, cases, etc.
They enable you to create different page layouts and record types for B2C and B2B customers, which allows you to customize the user interface and business logic for each segment.
They support large data volumes and can scale up to 50 million records or more, which meets the expected growth of consumers over the next five years.
NEW QUESTION # 168
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.)
- A. Create custom indexes on the fields used in the filter criteria.
- B. Create a formula field instead of having multiple filter criteria.
- C. Modify the integration users' profile to have View All Data.
- D. Make sure the query doesn't contain NULL in any filter criteria.
Answer: A,D
Explanation:
Making sure the query does not contain NULL in any filter criteria can avoid full table scans and leverage indexes more efficiently. Queries with NULL filters are not selective and can cause performance issues. Creating custom indexes on the fields used in the filter criteria can also enhance the query performance by reducing the number of records to scan.
NEW QUESTION # 169
Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.
Which solution should a data architect recommend a clean migration?
- A. Define external IDs for an object, migrate second database to first database, and load into Salesforce.
- B. Define duplicate rules in Salesforce, and load data into Salesforce from both databases.
- C. Define external IDs for an object, Insert data from one database, and use upsert for a second database
- D. Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.
Answer: C
NEW QUESTION # 170
Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintain two years of data in Saleforce and archive older data out of Salesforce.
Which solution should a data architect recommend as an archiving solution?
- A. Use a third-party backup solution to backup all data off platform.
- B. Build a batch join move all records off platform, and delete all records from Salesforce.
- C. Build a batch join to move two-year-old records off platform, and delete records from Salesforce.
- D. Build a batch job to move all restore off platform, and delete old records from Salesforce.
Answer: A
NEW QUESTION # 171
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.)
- A. Performing large loads and deletions.
- B. Using leading % wildcards.
- C. Using NOT and != operators.
- D. Using a custom index on a deterministic formula field.
- E. Using trailing % wildcards.
Answer: B,C,D
NEW QUESTION # 172
Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this list is one of the most valuable and important components of UC's business, and the accuracy of shipping addresses is paramount. Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don't exist. Which two scalable strategies should UC consider to improve the quality of their Account addresses?
- A. Contact each business on the list and ask them to review and update their address information.
- B. Leverage Data.com Clean to clean up Account address fields with the D&B database.
- C. Build a team of employees that validate Accounts by searching the web and making phone calls.
- D. Integrate with a third-party database or services for address validation and enrichment.
Answer: B,D
NEW QUESTION # 173
Northern trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW), NTD's sales team starting to use Salesforce after a recent implementation, but currently lacks data required to advanced and opportunity to the next stage.
NTO's management has research Salesforce Connect and would like to use It to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.
What should a data architect consider before implementing Salesforce Connect for reporting?
- A. Maximum external objects per org
- B. Maximum page size for server-driven paging
- C. Maximum number for records returned
- D. OData callout limits per day
Answer: D
Explanation:
According to the Salesforce Connect Reporting blog post, one of the considerations for using Salesforce Connect for reporting is the OData callout limits per day. The blog post states that "Salesforce Connect has a limit of 100,000 callouts per day. This limit is shared across all external data sources in your org. If you exceed this limit, you will receive an error message and no more callouts will be allowed until the next day." Therefore, a data architect should consider this limit before implementing Salesforce Connect for reporting.
NEW QUESTION # 174
Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.
Which solution should a data architect recommend a clean migration?
- A. Define external IDs for an object, migrate second database to first database, and load into Salesforce.
- B. Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.
- C. Define duplicate rules in Salesforce, and load data into Salesforce from both databases.
- D. Define external IDs for an object, Insert data from one database, and use upsert for a second database
Answer: B
Explanation:
To recommend a clean migration, the data architect should set up a staging database, and define external IDs to merge, clean duplicate data, and load into Salesforce. This will allow the data architect to consolidate and deduplicate the data from two legacy systems before importing it into Salesforce using external IDs as unique identifiers. Option A is incorrect because defining external IDs for an object, migrating second database to first database, and loading into Salesforce will not ensure that the data is clean and duplicate-free. Option B is incorrect because defining duplicate rules in Salesforce, and loading data into Salesforce from both databases will not prevent the duplicate data from being imported into Salesforce. Option D is incorrect because defining external IDs for an object, inserting data from one database, and using upsert for a second database will not handle the duplicate data from both databases.
NEW QUESTION # 175
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?
- A. After exporting the metadata, search it for the fields in question.
- B. Remove "customize application" permissions from everyone else.
- C. After exporting the setup audit trail, find the fields in question.
- D. Create a field history report for the fields in question.
Answer: C
NEW QUESTION # 176
......
Data-Architect EXAM DUMPS WITH GUARANTEED SUCCESS: https://www.actualtests4sure.com/Data-Architect-test-questions.html
Best Quality Salesforce Data-Architect Exam Questions: https://drive.google.com/open?id=1kfpSeDuoIzmDnDJWO2d9heL1Nk_eE9h6
