How Many Questions Of Data-Architecture-And-Management-Designer Test Engine

NEW QUESTION 1
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. Weekly Snapshots
• B. Einstein Analytics
• C. Setup Audit Trails
• D. AppExchange Apps

Answer: BD

NEW QUESTION 2
Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.
What data extraction strategy should a data architect use for maximum performance?

• A. Install a third-party AppExchange tool.
• B. Call the REST API in successive queries.
• C. Utilize PK Chunking with the Bulk API.
• D. Use the Bulk API in parallel mode.

Answer: C

NEW QUESTION 3
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 data. 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. Create a external id field for each object in the target org and map source record ID’s to this field.
• C. Redefine the master detail relationship fields to lookup relationship fields in the target org.
• D. Replace source record ID’s with new record ID’s from the target org in the import file.
• E. Keep the relationship fields populated with the source record ID’s in the import file.

Answer: ABD

NEW QUESTION 4
Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., "John Doe" in the OMS and "Johnny Doe" in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?

• A. Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.
• B. Implement an integration tool to send OMS Accounts and Contacts to Salesforce.
• C. Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.
• D. Use the Streaming API to send Account and Contact data from Salesforce to the OMS.

Answer: C

NEW QUESTION 5
North Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org, NTO also owns several secondary orgs that the service, finance, and marketing teams work out of, At the moment, there is no integration between central and secondary orgs, leading to data-visibility issues.
Moving forward, NTO has identified that a hub-and-spoke model is the proper architect to manage its data, where the central org is the hub and the secondary orgs are the spokes.
Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?

• A. A middleware solution that extracts and distributes data across both the hub and spokes.
• B. Develop custom APIs to poll the hub org for change data and push into the spoke orgs.
• C. Develop custom APIs to poll the spoke for change data and push into the org.
• D. A backup and archive solution that extracts and restores data across orgs.

Answer: A

NEW QUESTION 6
Northern Trail outfitters in migrating to salesforce from a legacy CRM system that identifies the agent relationships in a look-up table.
What should the data architect do in order to migrate the data to Salesfoce?

• A. Create custom objects to store agent relationships.
• B. Migrate to Salesforce without a record owner.
• C. Assign record owner based on relationship.
• D. Migrate the data and assign to a non-person system user.

Answer: A

NEW QUESTION 7
UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality.
Which 2 solutions should a data architect recommend to monitor and measure data quality? Choose 2 answers.

• A. Use custom objects and fields to identify issues.
• B. Review data quality reports and dashboards.
• C. Install and run data quality analysis dashboard app
• D. Export data and check for data completeness outside of Salesforce.

Answer: BC

NEW QUESTION 8
Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.
What should a data architect recommend for a daily backup and restore solution?

• A. Use AppExchange package for backup and restore.
• B. Use ETL for backup and restore from EDW.
• C. Use Bulk API to extract data on daily basis to EDW and REST API for restore.
• D. Change weekly backup process to daily backup, and implement a custom restore solution.

Answer: A

NEW QUESTION 9
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. Clean data before importing to Salesforce.
• C. Use Salesforce matching and duplicate rules.
• D. Import the data concurrently.

Answer: BC

NEW QUESTION 10
Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes. Some of NTOs team are complaining they see new fields on their page unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.
Which governance measure should a data architect recommend to solve this issue?

• A. Add description fields to explain why the field is used, and mark the field as required.
• B. Create and manage a data dictionary and ups a governance process for changes made to common objects.
• C. Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.
• D. Create validation rules with error messages to explain why the fields is used

Answer: B

NEW QUESTION 11
Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used.
An Architect needs to determine which system is the system of record on a field level. What should the Architect do to achieve this goal?

• A. Master Data Management systems determine system of record, and the Architect doesn't have to think about what data is controlled by what system.
• B. Key stakeholders should review any fields that share the same purpose between systems to see how they will be used in Salesforce.
• C. The database schema for each external system should be reviewed, and fields with different names should always be separate fields in Salesforce.
• D. Any field that is an input field in either external system will be overwritten by the last record integratedand can never have a system of record.

Answer: C

NEW QUESTION 12
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?

• A. Use the Name field values to sort batches.
• B. Order batches by Auto-number field.
• C. Create indexes on Opportunity object text fields.
• D. Group batches by the AccountId field.

Answer: D

NEW QUESTION 13
UC is trying to switch from legacy CRM to salesforce and wants to keep legacy CRM and salesforce in place till all the functionality is deployed in salesforce. The want to keep data in synch b/w Salesforce, legacy CRM and SAP. What is the recommendation.

• A. Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place
• B. Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP
• C. Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce
• D. Suggest MDM solution and link MDM to salesforce and SAP

Answer: CD

NEW QUESTION 14
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. Allow validation rules to be activated during the load of leads into salesforce.
• C. Develop custom APEX batch process to improve quality once the load is completed.
• D. Ensure the lead data is preprocessed for quality before loading into salesforce.

Answer: C

NEW QUESTION 15
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. Us custom objects to maintain Sales Orders in Salesforce.
• B. Use custom big objects to maintain Sales Orders in Salesforce.
• C. Use external objects to maintain Sales Order in Salesforce.
• D. Use Standard order object to maintain Sale Orders in Salesforce

Answer: C

NEW QUESTION 16
NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.
Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:

• A. Define data duplication standards and rules
• B. Define key fields in staging database for data cleansing
• C. Measure data timeliness and consistency
• D. Finalize an extract transform load (ETL) tool for data migration
• E. Measure data completeness and accuracy

Answer: ACE

NEW QUESTION 17
Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC. Which two common techniques are used building a data dictionary to store information on how business entities are defined?

• A. Use Salesforce Object Query Language.
• B. Use a data definition language.
• C. Use an entity relationship diagram.
• D. Use the Salesforce Metadata API.

Answer: CD

NEW QUESTION 18
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. Create a field history report for the fields in question.
• B. After exporting the setup audit trail, find the fields in question.
• C. After exporting the metadata, search it for the fields in question.
• D. Remove "customize application" permissions from everyone else.

Answer: B

NEW QUESTION 19
To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?

• A. Errors with duplicate external Id values within the same CSV file.
• B. Errors with records being updated and inserted in the same CSV file.
• C. Errors when a duplicate Contact name is found cause upsert to fail.
• D. Errors with using the wrong external Id will cause the load to fail.

Answer: A

NEW QUESTION 20
......