Get instant access to Data-Architect Practice Tests 2023 Free Updated Today!
Welcome to download the newest PassLeader Data-Architect PDF dumps ( 259 Q&As)
Salesforce Data-Architect (Salesforce Certified Data Architect) Exam is a certification exam that focuses on testing an individual's knowledge and skills in designing and managing complex data architectures on the Salesforce platform. Data-Architect exam is designed for individuals who have a deep understanding of Salesforce data management concepts, data modeling, and architecture principles. Passing Data-Architect exam demonstrates a candidate's ability to design and implement complex data solutions on the Salesforce platform.
NEW QUESTION # 89
DreamHouse Realty has a Salesforce org that is used to manage Contacts.
What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.)
- A. Use workflow to delete duplicate records.
- B. Use Salesforce duplicate management.
- C. Use the private sharing model.
- D. Use validation rules on new record create and edit.
Answer: B,D
Explanation:
Using Salesforce duplicate management and using validation rules on new record create and edit are two things that an architect should consider using to maintain data quality for managing Contacts. Salesforce duplicate management allows the architect to create matching rules and duplicate rules to identify, prevent, or allow duplicate records based on various criteria. Validation rules allow the architect to enforce data quality standards and business logic by displaying error messages when users try to save invalid data. The other options are not relevant or helpful for maintaining data quality
NEW QUESTION # 90
Universal Containers (UC) has a custom discount request object set as a detail object with a custom product object as the master. There is a requirement to allow the creation of generic discount requests without the custom product object as its master record. What solution should an Architect recommend to UC?
- A. Change the master-detail relationship to a lookup relationship.
- B. Remove the master-detail relationship and keep the objects separate.
- C. Create a placeholder product record for the generic discount request.
- D. Mandate the selection of a custom product for each discount request.
Answer: A
Explanation:
Changing the master-detail relationship to a lookup relationship is the best solution for allowing the creation of generic discount requests without the custom product object as its master record. A lookup relationship allows you to create child records without requiring a parent record. It also gives you more flexibility in defining the sharing and security settings for each object
NEW QUESTION # 91
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. Clean data before importing to Salesforce.
- B. Use a workflow to check and prevent duplicates.
- C. Import the data concurrently.
- D. Use Salesforce matching and duplicate rules.
Answer: A,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 # 92
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 the account product vendor provides a sound data archiving strategy.
- B. Ensure the accounting product runs 100% natively on the Salesforce platform.
- C. Ensure invoice line items simply reference existing Opportunity line items.
- D. Ensure the account product vendor includes Wave Analytics in their offering.
Answer: A
NEW QUESTION # 93
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. First, load all account records, and then load all user records.
- B. Defer sharing calculations until the data has finished uploading.
- C. Create the users, upload all data, and then deploy the sharing rules.
- D. Contact Salesforce to activate indexing before uploading the data.
Answer: B,C
NEW QUESTION # 94
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. Create indexes on Opportunity object text fields.
- B. Group batches by the AccountId field.
- C. Sort batches by Name field values.
- D. Order batches by Auto -number field.
Answer: D
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 # 95
Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed. Which two techniques should be used for smooth interoperability now and in the future.
- A. Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.
- B. Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.
- C. Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.
- D. Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.
Answer: A,D
NEW QUESTION # 96
A shipping and logistics company has created a large number of reports within Sales Cloud since Salesforce was introduced. Some of these reports analyze large amounts of data regarding the whereabouts of the company's containers, and they are starting to time out when users are trying to run the reports. What is a recommended approach to avoid these time-out issues?
- A. Improve reporting performance by creating a dashboard that is scheduled to run the reports only once per day.
- B. Improve reporting performance by creating an Apex trigger for the Report object that will pre-fetch data before the report is run.
- C. Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.
- D. Improve reporting performance by creating a custom Visualforce report that is using a cache of the records in the report.
Answer: C
NEW QUESTION # 97
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. Einstein Analytics
- C. Standard SOQL queries
- D. Async SOQL with a custom object
Answer: B,D
Explanation:
Async SOQL with a custom object (option B) and Einstein Analytics (option D) are the two native tools that can be used to report on big object data. Async SOQL allows querying big object data and storing the results in a custom object, which can then be used for reporting. Einstein Analytics can connect to big object data sources and provide advanced analytics and visualization features. Standard reports and dashboards (option A) and standard SOQL queries (option C) cannot be used to report on big object data, as they do not support big object fields
NEW QUESTION # 98
Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, and item color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution. What is a correct technique UC should use to solve the data inconsistency?
- A. Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.
- B. Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.
- C. Change integration to let product master systems update product data directly in Salesforce via the Salesforce API.
- D. Add custom fields to the Product standard object in Salesforce to store data from the different source systems.
Answer: B
Explanation:
A correct technique UC should use to solve the data inconsistency is to define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse. A data taxonomy is a hierarchical classification of data entities and attributes that defines their meaning, format, and relationships. A data taxonomy can help ensure consistency, accuracy, and completeness of product data across different systems and channels
NEW QUESTION # 99
During the implementation of Salesforce, a customer has the following requirements for Sales Orders:
1. Sales Order information needs to be shown to users in Salesforce.
2. Sales Orders are maintained in the on-premises enterprise resource planning (ERP).
3. Sales Order information has more than 150 million records.
4. Sales Orders will not be updated in Salesforce.
What should a data architect recommend for maintaining Sales Orders in salesforce?
- A. Use Standard order object to maintain Sale Orders in Salesforce
- B. Use custom big objects to maintain Sales Orders in Salesforce.
- C. Us custom objects to maintain Sales Orders in Salesforce.
- D. Use external objects to maintain Sales Order in Salesforce.
Answer: D
NEW QUESTION # 100
Northern Trail Outfitters is concerned because some of its data is sensitive and needs to be identified for access.
What should be used to provide ways to filter and identify the sensitive data?
- A. Define data classification metadata.
- B. Custom checkbox denoting sensitive data.
- C. Implement field-level security.
- D. Define data grouping metadata.
Answer: A
Explanation:
According to the official Salesforce guide1, data classification metadata is a feature that allows administrators to classify data fields based on their sensitivity level, such as confidential, restricted, or general. Data classification metadata can be used to filter and identify sensitive data fields and apply appropriate security measures, such as encryption, masking, or auditing. Option D is the correct answer because it suggests using data classification metadata to provide ways to filter and identify sensitive data. Option A is incorrect because data grouping metadata is not a feature in Salesforce. Option B is incorrect because field-level security is a feature that controls the visibility and editability of fields based on user profiles or permission sets, but it does not provide ways to filter and identify sensitive data. Option C is incorrect because creating a custom checkbox denoting sensitive data is not a scalable or reliable solution, as it requires manual maintenance and does not enforce any security measures.
NEW QUESTION # 101
To address different compliance requirements, such as general data protection regulation (GDPR), personally identifiable information (PII), of health insurance Portability and Accountability Act (HIPPA) and others, a SF customer decided to categorize each data element in SF with the following:
Data owner
Security Level, such as confidential
Compliance types such as GDPR, PII, HIPPA
A compliance audit would require SF admins to generate reports to manage compliance.
What should a data architect recommend to address this requirement?
- A. Build reports for field information, then export the information to classify and report for Audits.
- B. Create a custom object and field to capture necessary compliance information and build custom reports.
- C. Use metadata API, to extract field attribute information and use the extract to classify and build reports
- D. Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.
Answer: D
Explanation:
The data architect should recommend using field metadata attributes for compliance categorization, data owner, and data sensitivity level. This will allow the SF admins to generate reports to manage compliance based on the field metadata attributes that are defined for each data element in SF. Option A is incorrect because using metadata API to extract field attribute information and use the extract to classify and build reports will require additional development effort and may not be up-to-date with the latest changes in SF. Option C is incorrect because creating a custom object and field to capture necessary compliance information and build custom reports will require additional configuration effort and may not be consistent with the actual data elements in SF. Option D is incorrect because building reports for field information, then exporting the information to classify and report for audits will require additional manual effort and may not be accurate or timely.
NEW QUESTION # 102
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. Bring all data Salesforce, and delete it after a year.
- B. Leverage real-time integration to pull records into Salesforce.
- C. Leverage mashup to display historical records in Salesforce.
- D. Build a chair solution to go the legacy system and display records.
Answer: C
Explanation:
According to the Using Mashups article on Salesforce Developers, one of the techniques for deploying large data volumes is to use mashups to display historical records in Salesforce. The article states that "Mashups are a way to display data from an external system within a Salesforce page without copying or synchronizing the data. Mashups use a combination of Visualforce, Apex callouts, and JavaScript code that runs in the browser. Mashups are useful when you want to display large amounts of read-only data that is stored outside of Salesforce." Therefore, a data architect should recommend this solution to meet the business requirement of UC.
NEW QUESTION # 103
UC has a legacy client server app that as a relational data base that needs to be migrated to salesforce.
What are the 3 key actions that should be done when data modeling in salesforce?
Choose 3 answers:
- A. Map legacy data to salesforce objects.
- B. Map legacy data to salesforce custom objects.
- C. Implement legacy data model within salesforce using custom fields.
- D. Identify data elements to be persisted in salesforce.
- E. Work with legacy application owner to analysis legacy data model.
Answer: A,C,D
NEW QUESTION # 104
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?
- A. Build a nightly sync job from ERP to Salesforce.
- B. Build a nightly batch job to de-dupe data, and merge account records.
- C. Implement a de-dupe solution and establish account ownership in Salesforce
- D. Integrate Salesforce with ERP, and make ERP as system of truth.
Answer: C,D
NEW QUESTION # 105
Which API should a data architect use if exporting 1million records from Salesforce?
- A. REST API
- B. Bulk API
- C. Streaming API
- D. SOAP API
Answer: B
Explanation:
Using Bulk API to export 1 million records from Salesforce is the best option. Bulk API is a RESTful API that allows you to perform asynchronous operations on large sets of data. You can use Bulk API to create, update, delete, or query millions of records in batches. Bulk API is optimized for performance and scalability, and it can handle complex data loading scenarios.
NEW QUESTION # 106
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?
- A. Modify the export query that includes standard index fields(s).
- B. Modify the export job header to specify Sforce-Enable-PKChunking.
- C. Modify the export job header to specify Export-in-Parallel.
- D. Modify the export query with LIMIT clause with Batch size 10,000.
Answer: B
Explanation:
The Sforce-Enable-PKChunking header enables you to extract large data sets from Salesforce by using a technique called primary key (PK) chunking. PK chunking splits your query into multiple queries based on the record IDs of the queried object. This reduces the query time and avoids the query timeout issues that can occur with large data volumes
NEW QUESTION # 107
Cloud Kicks currently has a Public Read/Write sharing model for the company's Contacts. Cloud Kicks management team requests that only the owner of a contact record be allowed to delete that contact.
What should an Architect do to meet these requirements?
- A. Set the Sharing settings as Public Read Only for the Contact object.
- B. Check if the current user is NOT the owner by creating a validation rule on the Contact object.
- C. Set the profile of the users to remove delete permission from the Contact object.
- D. Check if the current user is NOT the owner by creating a "before delete" trigger.
Answer: D
Explanation:
Checking if the current user is NOT the owner by creating a "before delete" trigger can meet the requirement of allowing only the owner of a contact record to delete that contact. A trigger is a piece of Apex code that can execute before or after a record is inserted, updated, deleted, or undeleted. A "before delete" trigger can prevent the deletion of a record by using the addError() method.
NEW QUESTION # 108
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
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 customer data base and use this id in all systems.
- B. Store the salesforce id in all the solutions to identify the customer.
- C. Create a custom object that will serve as a cross reference for the customer id.
- D. Create a custom field as external id to maintain the customer Id from the MDM solution.
Answer: D
NEW QUESTION # 109
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. Standard lead information across all channels.
- B. Implement third-party solution to clean and event lead data.
- C. Implement de-duplication strategy to prevent duplicate leads
- D. Build process is manually search and merge duplicates.
- E. Build a custom solution to identify and merge duplicate leads.
Answer: A,B,C
NEW QUESTION # 110
Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle__ c) and Service History (Service-History__ c) are both custom objects related through a lookup relationship.
Every week a batch synchronization process updates the Vehicle and Service History records in Salesforce. UC has two hours of migration window every week and is facing locking issues as part of the data migration process.
What should a data architect recommend to avoid locking issues without affecting performance of data migration?
- A. Insert the order in another custom object and use Batch Apex to move the records to Service_ Order__ c object.
- B. Use Bulk API parallel mode for data migration
- C. Use Bulk API serial mode for data migration
- D. Change the lookup configuration to "Clear the value of this field" when lookup record is deleted.
Answer: C
NEW QUESTION # 111
......
Nov-2023 Latest PDFVCE Data-Architect Exam Dumps with PDF and Exam Engine: https://certification-questions.pdfvce.com/Salesforce/Data-Architect-exam-pdf-dumps.html