Get all the Information About Salesforce Data-Architect Exam 2023 Practice Test Questions
Check Real Salesforce Data-Architect Exam Question for Free (2023)
NEW QUESTION # 16
Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?
- A. Use the SOAP API to export data.
- B. Use GZIP compression to export the data.
- C. Utilize the Bulk API to export the data.
- D. Schedule a Batch Apex job to export the data.
Answer: B
Explanation:
According to the exam guide, one of the objectives is to "describe the use cases and considerations for using various tools and techniques for data migration (for example, Data Loader, Bulk API)"1. This implies that option B is the correct way to extract large volumes of data from Salesforce. The Bulk API is designed to handle large-scale data operations and avoid timeouts. Option A is not correct because the SOAP API is not optimized for large data sets and may encounter limits. Option C is not correct because GZIP compression does not prevent timeouts, but rather reduces the size of the data transferred. Option D is not correct because Batch Apex is used to process records asynchronously in Salesforce, not to export data to an external system.
NEW QUESTION # 17
A large Automobile company has implemented SF for its Sales Associates. Leads flow from its website to SF using a batch integration in SF. The Batch job connects the leads to Accounts in SF. Customer visiting their retail stores are also created in SF as Accounts.
The company has noticed a large number of duplicate accounts in SF. On analysis, it was found that certain customers could interact with its website and also visit the store. The Sales associates use Global Search to search for customers in Salesforce before they create the customers.
Which scalable option should a data Architect choose to implement to avoid duplicates?
- A. Implement a MDM solution to validate the customer information before creating Accounts in SF.
- B. Create duplicate rules in SF to validate duplicates during the account creation process
- C. Customize Account creation process to search if customer exists before creating an Account.
- D. Build Custom search based on fields on Accounts which can be matched with customer when they visit the store
Answer: B
Explanation:
The data architect should choose to implement duplicate rules in SF (Salesforce) to validate duplicates during the account creation process. Duplicate rules are a feature in Salesforce that allow users to define criteria and actions for detecting and preventing duplicate records. By creating duplicate rules for accounts, the data architect can ensure that any leads from the website or customers from the retail stores that match existing accounts in Salesforce are flagged or blocked before they are created as new accounts. This will help avoid duplicate accounts in Salesforce and maintain data quality. Option B is incorrect because implementing a MDM (Master Data Management) solution to validate the customer information before creating accounts in SF will require additional infrastructure cost and maintenance effort. Option C is incorrect because building custom search based on fields on accounts which can be matched with customer when they visit the store will require additional development effort and may not be accurate or user-friendly. Option D is incorrect because customizing account creation process to search if customer exists before creating an account will require additional configuration effort and may not be consistent or scalable.
NEW QUESTION # 18
Universal Containers (UC) is going thought major reorganization of their sales team. This would require changes to a large a number of group members and sharing rules. UCs administrator is concerned about long processing time and failure during the process.
What should a Data architect implement to make changes efficiently?
- A. Delete old sharing rules and build new sharing rules
- B. Log out all users and make changes to sharing rules.
- C. Enable Defer Sharing Calculation prior to making sharing rule changes.
- D. Log a case with salesforce to make sharing rule changes.
Answer: C
Explanation:
The correct answer is B. To make changes efficiently, a data architect should enable Defer Sharing Calculation prior to making sharing rule changes. This will allow the administrator to make multiple changes to sharing rules without recalculating them after each change, which can take a long time and cause failures. The sharing rules can be recalculated later when there are fewer users online or during off-peak hours. Option A is incorrect because logging a case with salesforce to make sharing rule changes will not speed up the process or prevent failures. Option C is incorrect because deleting old sharing rules and building new sharing rules will not reduce the processing time or failure rate. Option D is incorrect because logging out all users and making changes to sharing rules will disrupt the business operations and may not be feasible.
NEW QUESTION # 19
Universal Containers (UC) has adopted Salesforce as its primary sales automated tool. UC has 100,00 customers with a growth rate of 10% a year, UC uses an on-premise web-based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.
The UC sales team needs to be able to pull a customer record and view their account status, Invoice history, and opportunities without navigating outside of Salesforce.
What should a data architect use to provide the sales team with the required functionality?
- A. Create a custom object and migrate the last 12 months of Invoice data into Salesforce so it can be displayed on the Account layout.
- B. Create a mashup page that will present the billing system records within Salesforce.
- C. Create a visual force tab with the billing system encapsulated within an iframe.
- D. Write an Apex callout and populate a related list to display on the account record.
Answer: B
Explanation:
To provide the sales team with the required functionality, a data architect should use a mashup page that will present the billing system records within Salesforce. A mashup page is a web page that combines data from multiple sources into a single integrated view. A mashup page can be created using Visualforce or Lightning Web Components, and can use Salesforce Connect or custom integrations to access external data from the on-premise web-based billing and invoice system. This will allow the sales team to pull a customer record and view their account status, invoice history, and opportunities without navigating outside of Salesforce. Option A is incorrect because creating a custom object and migrating the last 12 months of invoice data into Salesforce so it can be displayed on the account layout will consume a lot of storage space and may not reflect the latest data from the billing system. Option B is incorrect because writing an Apex callout and populating a related list to display on the account record will require additional development effort and may not be scalable or performant for large volumes of data. Option D is incorrect because creating a visual force tab with the billing system encapsulated within an iframe will not allow the sales team to view the billing system records within the customer record, but rather in a separate tab.
NEW QUESTION # 20
Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce.
Which approach for data archiving is appropriate for this scenario?
- A. 1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.
- B. 1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.
- C. 1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.
- D. 1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.
Answer: C
NEW QUESTION # 21
Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answers
- A. Schedule a weekly export file from the Salesforce UI.
- B. Use the Force.com Workbench to export the data.
- C. Schedule jobs to export and delete using the Data Loader.
- D. Schedule jobs to export and delete using an ETL tool.
Answer: C,D
NEW QUESTION # 22
All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems:
* An ERP system feeds order data into Salesforce and updates both Account and Opportunity records.
* An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records.
* A commission system feeds commission data into Salesforce and updates both Account and Opportunity records.
How should the architect determine which of these systems is the system of record?
- A. Whatever system updates the attribute or object should be the system of record for that field or object.
- B. Data flows should be reviewed with the business users to determine the system of record per object or field.
- C. Whatever integration data flow runs last will, by default, determine which system is the system of record.
- D. Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.
Answer: B
NEW QUESTION # 23
NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and dat a. NTO's data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org.
What 3 things should a data architect do to maintain the relationship hierarchy during migration?
Choose 3 answers:
- A. Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.
- B. Replace source record ID's with new record ID's from the target org in the import file.
- C. Keep the relationship fields populated with the source record ID's in the import file.
- D. Redefine the master detail relationship fields to lookup relationship fields in the target org.
- E. Create a external id field for each object in the target org and map source record ID's to this field.
Answer: A,B,E
NEW QUESTION # 24
Northern Trail Outfitters <NTO> is streaming IoT data from connected devices to a cloud database. Every 24 hours. 100,000 records are generated.
NIO employees will need to see these lol records within Salesforce and generate weekly reports on it. Developers may also need to write programmatic logic to aggregate the records and incorporate them into workflows.
Which data pattern will allow a data architect to satisfy these requirements, while also keeping limits in mind?
- A. Unidirectional integration
- B. Bidirectional integration
- C. Persistence
- D. Virtualization
Answer: C
Explanation:
Persistence is the data pattern that will allow a data architect to satisfy the requirements, while also keeping limits in mind. Persistence means storing data from external sources in Salesforce objects, either standard or custom. This allows you to access the data within Salesforce and use it for reporting, analytics, workflows, and other features. Persistence also helps you avoid hitting API limits or performance issues when accessing large volumes of data from external systems. You can use various tools such as Data Loader, Bulk API, or Platform Events to persist IoT data from connected devices to a cloud database in Salesforce.
NEW QUESTION # 25
UC is building a salesforce application to track contacts and their respective conferences that they have attended with the following requirements:
1. Contacts will be stored in the standard contact object.
2. Conferences will be stored in a custom conference_ c object.
3. Each contact may attend multiple conferences and each conference may be related to multiple contacts.
How should a data architect model the relationship between the contact and conference objects?
- A. Implement a Contact Conference junction object with master detail relationship to both contact and conference_c
- B. Create a lookup relationship field on contact object.
- C. Create a master detail relationship field on the Contact object.
- D. Create a master detail relationship field on the Conference object.
Answer: A
Explanation:
Implementing a Contact Conference junction object with master detail relationship to both contact and conference_c is the correct way to model the relationship between the contact and conference objects, as it allows a many-to-many relationship between them. This means that each contact can attend multiple conferences, and each conference can be related to multiple contacts. Creating a master detail relationship field on either the contact or the conference object would create a one-to-many relationship, which does not meet the requirements. Creating a lookup relationship field on contact object would also create a one-to-many relationship, and would not enforce referential integrity.
NEW QUESTION # 26
NTO has a loyalty program to reward repeat customers. The following conditions exists:
1. Reward levels are earned based on the amount spent during the previous 12 months.
2. The program will track every item a customer has bought and grant them points for discount.
3. The program generates 100 million records each month.
NTO customer support would like to see a summary of a customer's recent transaction and reward level(s) they have attained.
Which solution should the data architect use to provide the information within the salesforce for the customer support agents?
- A. Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.
- B. Provide a button so that the agent can quickly open the point of sales system displaying the customer history.
- C. Create a custom big object to capture the reward program data and display it on the contact record and update nightly from the point-of-scale system.
- D. Create a custom object in salesforce to capture and store all reward program. Populate nightly from the point-of-scale system, and present on the customer record.
Answer: C
Explanation:
According to the Get Started with Big Objects unit on Trailhead, one of the use cases for custom big objects is to store and manage loyalty program data for customers. The unit states that "From loyalty programs to transactions, order, and billing information, use a custom big object to keep track of every detail." Therefore, a custom big object can be used to capture the reward program data and display it on the contact record. Additionally, according to the Big Objects Implementation Guide, big objects can handle massive amounts of data (up to billions of records) and can be updated nightly from external systems using Bulk API or batch Apex. Therefore, a custom big object can meet the requirements of NTO's loyalty program scenario.
NEW QUESTION # 27
Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations.
Which two solutions should a data architect recommend to mitigate data quality issues?
- A. Leverage picklist and lookup fields where possible
- B. Leverage third-party- AppExchange tools
- C. Leverage validation rules and workflows.
- D. Leverage Apex to validate the format of data being entered via a mobile device.
Answer: A,C
NEW QUESTION # 28
Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect
1. The data model for Org B will drastically change with different objects, fields, and picklist values.
2. Three million records will need to be migrated from org A to org B for compliance reasons.
3. The migrate will need occur within the next two month, prior to be split.
Which migrate strategy should a data architect use to successfully migrate the date?
- A. Use Data Loader for export and Data Import Wizard for import
- B. use as ETL tool to orchestrate the migration.
- C. Use the Salesforces CLI to query, export, and import
- D. Write a script to use the Bulk API
Answer: D
NEW QUESTION # 29
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
- A. Use a workflow to check and prevent duplicates.
- B. Import the data concurrently.
- C. Use Salesforce matching and duplicate rules.
- D. Clean data before importing to Salesforce.
Answer: C,D
Explanation:
Cleaning data before importing to Salesforce and using Salesforce matching and duplicate rules are two design considerations that an architect should take to minimize data duplication when migrating legacy account data from two aging systems into Salesforce. Cleaning data before importing involves removing or correcting any inaccurate, incomplete, or inconsistent data from the source systems, as well as identifying and resolving any potential duplicates. This ensures that only high-quality and unique data is imported to Salesforce. Using Salesforce matching and duplicate rules allows the architect to define how Salesforce identifies duplicate records during import and how users can handle them. This prevents or reduces the creation of duplicate records in Salesforce and improves data quality. The other options are not effective or recommended for minimizing data duplication.
NEW QUESTION # 30
Universal Containers (UC) has adopted Salesforce as its primary sales automated tool. UC has 100,00 customers with a growth rate of 10% a year, UC uses an on-premise web-based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.
The UC sales team needs to be able to pull a customer record and view their account status, Invoice history, and opportunities without navigating outside of Salesforce.
What should a data architect use to provide the sales team with the required functionality?
- A. Create a custom object and migrate the last 12 months of Invoice data into Salesforce so it can be displayed on the Account layout.
- B. Create a mashup page that will present the billing system records within Salesforce.
- C. Create a visual force tab with the billing system encapsulated within an iframe.
- D. Write an Apex callout and populate a related list to display on the account record.
Answer: B
NEW QUESTION # 31
NTO processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not integrated with SF. The Sales team at NTO using Sales cloud and would like visibility into related customer orders yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate SF connect and the concept of data verification. Which 3 considerations are needed prior to a SF Connect implementation?
Choose 3 answers:
- A. Create a 2nd system Admin user for authentication to the external source.
- B. Identify the external tables to sync into external objects
- C. Assess whether the external data source is reachable via an ODATA endpoint.
- D. Configure a middleware tool to poll external table data
- E. Develop an object relationship strategy.
Answer: B,C,E
Explanation:
The three considerations needed prior to a SF Connect implementation are to develop an object relationship strategy, identify the external tables to sync into external objects, and assess whether the external data source is reachable via an ODATA endpoint. SF Connect is a feature that allows integrating external data sources with Salesforce using external objects. External objects are similar to custom objects, but they store metadata only and not data. They enable on-demand access to external data via standard Salesforce APIs and user interfaces. To implement SF Connect, a data architect needs to consider how the external objects will relate to other objects in Salesforce, which external tables will be exposed as external objects, and whether the external data source supports ODATA protocol for data access.
NEW QUESTION # 32
DreamHouse Realty has a Salesforce deployment that manages Sales, Support, and Marketing efforts in a multi-system ERP environment. The company recently reached the limits of native reports and dashboards and needs options for providing more analytical insights.
What are two approaches an Architect should recommend? (Choose two.)
- A. Setup Audit Trails
- B. Weekly Snapshots
- C. Einstein Analytics
- D. AppExchange Apps
Answer: C,D
Explanation:
Einstein Analytics can provide more analytical insights than native reports and dashboards by allowing users to explore data from multiple sources, create interactive visualizations, and apply AI-powered features5. AppExchange Apps can also provide more analytical insights by offering pre-built solutions or integrations with external tools that can enhance the reporting and analytics capabilities of Salesforce6.
NEW QUESTION # 33
Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items. What should UC's Data Architect recommend to ensure scalability?
- A. Ensure invoice line items simply reference existing Opportunity line items.
- B. Ensure the accounting product runs 100% natively on the Salesforce platform.
- C. Ensure the account product vendor includes Wave Analytics in their offering.
- D. Ensure the account product vendor provides a sound data archiving strategy.
Answer: D
NEW QUESTION # 34
......
Use Free Data-Architect Exam Questions that Stimulates Actual EXAM : https://braindumps.getvalidtest.com/Data-Architect-brain-dumps.html