Updated Nov 18, 2023 Verified Data-Architect dumps Q&As - 100% Pass
New 2023 Latest Questions Data-Architect Dumps - Use Updated Salesforce Exam
Salesforce is a cloud-based customer relationship management (CRM) software that is widely used by businesses of all sizes. As companies handle huge amounts of data, they need professionals who can manage that data efficiently. The Salesforce Certified Data Architect certification exam is designed to test an individual's ability to design and implement data solutions that meet business requirements.
NEW QUESTION # 126
UC developers have created a new lightning component that uses an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a time-out error.
What tool should a data architect use to identify why the query is taking too long?
- A. Enable and use the query plan tool in the developer console.
- B. Use salesforce's query optimizer to analyze the query in the developer console.
- C. Open a ticket with salesforce support to retrieve transaction logs to e analyzed for processing time.
- D. Use Splunk to query the system logs looking for transaction time and CPU usage.
Answer: A
NEW QUESTION # 127
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?
- A. Move data off of the platform and run reporting outside Salesforce, and give access to reports.
- B. Contact Salesforce support to enable skinny table for cases.
- C. Build reports using custom Lightning components.
- D. Create a custom object to store aggregate data and run reports.
Answer: D
NEW QUESTION # 128
In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce?
- A. Custom report types cannot contain Opportunity data.
- B. Salesforce does not support Orders or Order Line Items.
- C. Salesforce allows up to four objects in a single report type.
- D. A report cannot contain data from Accounts and Contacts.
Answer: C
Explanation:
Salesforce allows up to four objects in a single report type. This means that if an architect wants to create a report that compiles data from Accounts, Contacts, Opportunities, Orders, and Order Line Items, they will run into a difficulty because that would require five objects in a single report type. To overcome this limitation, the architect can either create two separate report types and join them in a joined report, or use an external reporting tool that can access data from multiple objects.
NEW QUESTION # 129
Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Saiesforce 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 the Opportunity Amount field on opportunities on a daily basis.
3. PPS is the trusted source within 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 overwriting issue?
- A. Create a custom field for Opportunity amount that PSS updates separating the field sales user updates.
- B. Change Opportunity Amount field access to Read Only for sales users field-level security.
- C. Change PSS integration to update only Opportunity Amount field when the value is null.
- D. Create a custom field for Opportunity amount that sales users update separating the field that PPS updates.
Answer: B
Explanation:
Changing Opportunity Amount field access to Read Only for sales users field-level security (option C) is the best way to address the overwriting issue, as it prevents sales users from updating the field that is controlled by PPS, and ensures data consistency and accuracy. Creating a custom field for Opportunity amount that PSS updates separating the field sales user updates (option A) or creating a custom field for Opportunity amount that sales users update separating the field that PPS updates (option D) are not good solutions, as they may create confusion and inconsistency with the Opportunity Forecast feature. Changing PSS integration to update only Opportunity Amount field when the value is null (option B) is also not a good solution, as it may cause data loss or conflicts with the sales users' inputs.
NEW QUESTION # 130
North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly.
Which two native tools should a data architect recommend to achieve this reporting requirement?
- A. Standard reports and dashboards
- B. Async SOQL with a custom object
- C. Standard SOQL queries
- D. Einstein Analytics
Answer: B,D
NEW QUESTION # 131
Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.
Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.
Which two approaches will accomplish this goal? (Choose two.)
- A. Create the users, upload all data, and then deploy the sharing rules.
- B. Contact Salesforce to activate indexing before uploading the data.
- C. First, load all account records, and then load all user records.
- D. Defer sharing calculations until the data has finished uploading.
Answer: A,D
NEW QUESTION # 132
Universal Containers (UC) is migrating data from legacy system to Salesforce. During data analysis it was discovered that data types of fields being migrated do not match with Salesforce data types.
Which solution should a data architect use to ensure successful data migrations?
- A. Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.
- B. Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.
- C. Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.
- D. Export legacy data into CSV files and leverage data loader to load data into Salesforce.
Answer: C
Explanation:
According to this article, migrating the legacy data leveraging an ETL tool to transform data types and load data into Salesforce can be a way to ensure successful data migrations. The article states that ETL tools can help with data cleansing, mapping, transformation, and loading, and that they can handle different data types and formats. The article also provides some best practices for data migration, such as identifying the data to migrate, creating templates for the data, preparing the destination org, and validating the data.
NEW QUESTION # 133
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
- A. Reduce the number of triggers on Order _c object.
- B. Use SOQL queries without WHERE conditions.
- C. Make the queries more selective using indexed fields.
- D. Work with Salesforce Support to enable Skinny Tables.
Answer: C,D
NEW QUESTION # 134
A large retail B2C customer wants to build a 360 view of its customer for its call center agents. The customer interaction is currently maintained in the following system: 1. Salesforce CRM
2. Custom billing solution
3. Customer Master Data management (MDM)
4. Contract Management system
5. Marketing solution
What should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:
- A. Create a custom object that will serve as a cross reference for the customer id.
- B. Create a customer data base and use this id in all systems.
- C. Store the salesforce id in all the solutions to identify the customer.
- D. Create a custom field as external id to maintain the customer Id from the MDM solution.
Answer: D
NEW QUESTION # 135
NTO has decided that it is going to build a channel sales portal with the following requirements:
1. External resellers are able to authenticate to the portal with a login.
2. Lead data, opportunity data and order data are available to authenticated users.
3. Authenticated users many need to run reports and dashboards.
4. There is no need for more than 10 custom objects or additional file storage.
Which community cloud license type should a data architect recommend to meet the portal requirements?
- A. Partner community.
- B. Customer community.
- C. Lightning external apps starter.
- D. Customer community plus.
Answer: A
NEW QUESTION # 136
What should a data architect do to provide additional guidance for users when they enter information in a standard field?
- A. Add custom help text in default value for the field.
- B. Provide custom help text under field properties.
- C. Add a label field with help text adjacent to the custom field.
- D. Create a custom page with help text for user guidance.
Answer: B
Explanation:
The correct answer is A. To provide additional guidance for users when they enter information in a standard field, a data architect should provide custom help text under field properties. This will display a help icon next to the field label that users can hover over to see the help text. Option B is incorrect because creating a custom page with help text for user guidance will require additional development effort and may not be easily accessible by users. Option C is incorrect because adding custom help text in default value for the field will overwrite the actual default value of the field and may confuse users. Option D is incorrect because adding a label field with help text adjacent to the custom field will clutter the page layout and may not be visible to users.
NEW QUESTION # 137
Which two best practices should be followed when using SOSL for searching?
- A. Use Find in "ALL FIELDS" for faster searches.
- B. Keep searches specific and avoid wildcards where possible.
- C. Use searches against single Objects for greater speed and accuracy.
- D. Use SOSL option to ignore custom indexes as search fields are pre-indexed.
Answer: A,B
NEW QUESTION # 138
UC is migrating individual customers (B2C) data from legacy systems to SF. There are millions of customers stored as accounts and contacts in legacy database.
Which object model should a data architect configure within SF?
- A. Leverage standard account and contact object in SF
- B. Leverage person account object in Salesforce
- C. Leverage custom person account object in SF
- D. Leverage custom account and contact object in SF
Answer: B
Explanation:
The best object model to configure within SF for migrating individual customers (B2C) data from legacy systems is to leverage person account object in Salesforce. Person accounts are a special type of accounts that store information about individual people by combining certain account and contact fields into a single record4. Person accounts are useful for B2C scenarios where there is no need to associate a company name with a contact. Person accounts also support standard Salesforce features and functionality, such as leads, campaigns, reports, dashboards, etc5. Leverage custom person account object in SF is not a good option because there is no such thing as a custom person account object. Leverage custom account and contact object in SF is not a good option because it would require creating and maintaining additional objects and fields that may not be necessary or compatible with standard Salesforce features. Leverage standard account and contact object in SF is not a good option because it would require filling in dummy values for the account name field, which is mandatory for standard accounts.
NEW QUESTION # 139
A large automobile manufacturer has decided to use Salesforce as its CRM. It needs to maintain the following dealer types in their CRM:
Local dealers
Regional distributor
State distributor
Service dealer
The attributes are different for each of the customer types. The CRM users should be allowed to enter only attributes related to the customer types. The processes and business rules for each of the customer types could be different.
How should the different dealers be maintained in Salesforce?
- A. Create dealers as Accounts, and build custom views for each of the dealer types.
- B. Use Accounts for dealers, and create record types for each of the dealer types.
- C. Use Accounts for dealers and custom picklist field for each of the dealer types
- D. Create Custom objects for each dealer types and custom fields for dealer attributes.
Answer: B
Explanation:
According to Trailhead2, record types are a feature that allows administrators to create different business processes, page layouts, and picklist values for different types of records within an object. Record types can be used to maintain different dealer types in Salesforce by creating record types for each of the dealer types and assigning them appropriate attributes, processes, and rules. Option A is the correct answer because it suggests using Accounts for dealers, and creating record types for each of the dealer types. Option B is incorrect because creating dealers as Accounts, and building custom views for each of the dealer types does not allow CRM users to enter only attributes related to the customer types, nor does it enable different processes and business rules for each of the customer types. Option C is incorrect because using Accounts for dealers and custom picklist field for each of the dealer types does not allow CRM users to enter only attributes related to the customer types, nor does it enable different processes and business rules for each of the customer types. Option D is incorrect because creating Custom objects for each dealer types and custom fields for dealer attributes can be unnecessary and complex, as it requires creating multiple objects and relationships instead of using the standard Account object.
NEW QUESTION # 140
As part of a phased Salesforce rollout. there will be 3 deployments spread out over the year. The requirements have been carefully documented. Which two methods should an architect use to trace back configuration changes to the detailed requirements? Choose 2 answers
- A. Review the setup audit trail for configuration changes.
- B. Put the business purpose in the Description of each field.
- C. Use the Force.com IDE to save the metadata files in source control.
- D. Maintain a data dictionary with the justification for each field.
Answer: B,D
NEW QUESTION # 141
Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker. What is a data quality problem that could cause this?
- A. Customer phone number has changed on the Contact record.
- B. Missing phone number on the Contact record.
- C. Duplicate Contact records exist in the system.
- D. Duplicate Activity records on a Contact.
Answer: C
NEW QUESTION # 142
An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode. What should be considered when loading the Opportunity records?
- A. Order batches by Auto -number field.
- B. Create indexes on Opportunity object text fields.
- C. Sort batches by Name field values.
- D. Group batches by the AccountId field.
Answer: A
Explanation:
Ordering batches by Auto-number field will ensure that the records are processed in a sequential order and avoid any locking issues that might occur when loading related records in parallel mode. Creating indexes, grouping batches by AccountId, or sorting batches by Name field values are not necessary or beneficial for loading Opportunity records using the Bulk API.
NEW QUESTION # 143
UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this? Choose two answers.
- A. Export Bulk API in parallel mode
- B. Export in multiple batches
- C. Limit Batch to 10K records
- D. Use PK Chunking
Answer: B,D
NEW QUESTION # 144
......
Salesforce Certified Data Architect exam is a challenging and comprehensive test that evaluates a candidate's expertise in various areas of data architecture. Data-Architect exam covers topics such as data modeling, data integration, data governance, data security, data migration, and data quality. Data-Architect exam consists of 60 multiple-choice questions and has a duration of 120 minutes. A passing score of 70% or higher is required to obtain the certification.
Latest Data-Architect Exam Dumps Salesforce Exam from Training: https://actualtests.vceengine.com/Data-Architect-vce-test-engine.html
