How to pass Salesforce Data-Architect exam with the help of dumps?

Question # 1

UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years. Which 2 solutions should a data architect recommend in order to minimize performance and storage issues? Choose 2 answers: 

A. Export data out of salesforce and store in Flat files on external system. 
B. Create a custom object to store case history and run reports on it. 
C. Leverage on premise data archival and build integration to view archived data. 
D. Leverage big object to archive case data and lightning components to show archived data. 

Show Answer

Question # 2

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 

Show Answer

Question # 3

Universal Containers has a large number of Opportunity fields (100) that they want to track field history on. Which two actions should an architect perform in order to meet this requirement? Choose 2 answers 

A. Create a custom object to store a copy of the record when changed. 
B. Create a custom object to store the previous and new field values.
 C. Use Analytic Snapshots to store a copy of the record when changed. 
D. Select the 100 fields in the Opportunity Set History Tracking page. 

Show Answer

Question # 4

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 

Show Answer

Question # 5

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 CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications ; 
B. Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications. 
C. Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers. 
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. 

Show Answer

Question # 6

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. 

Show Answer

Question # 7

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. Develop an object relationship strategy. 
C. Identify the external tables to sync into external objects 
D. Assess whether the external data source is reachable via an ODATA endpoint. 
E. Configure a middleware tool to poll external table data 

Show Answer

Question # 8

Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce? 

A. Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.
 B. Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit. 
C. Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters. 
D. Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down. 

Show Answer

Question # 9

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. Maintain a data dictionary with the justification for each field. 
D. Use the Force.com IDE to save the metadata files in source control. 

Show Answer

Question # 10

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. Load only the data that the users is permitted to access
B. Add custom indexes on frequently searched account and contact objects fields 
C. Limit data loading to the 2000 most recently created records. 
D. Create a skinny table to represent account and contact objects.

Show Answer

Question # 11

As part of addressing general data protection regulation (GDPR) requirements, UC plans to implement a data classification policy for all its internal systems that stores customer information including salesforce. What should a data architect recommend so that UC can easily classify consumer information maintained in salesforce under both standard and custom objects?

 A. Use App Exchange products to classify fields based on policy. 
B. Use data classification metadata fields available in field definition. 
C. Create a custom picklist field to capture classification of information on customer. 
D. Build reports for customer information and validate. 

Show Answer

Question # 12

Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records. What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues? 

A. Create a Custom Object Individual Consumer c to load all individual consumers. 
B. Load all individual consumers as Account records and avoid using the Contact object. 
C. Load one Account record and one Contact record for each individual consumer. 
D. Create one Account and load individual consumers as Contacts linked to that one Account. 

Show Answer

Question # 13

UC is planning a massive SF implementation with large volumes of data. As part of the org’s implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner. What should a data architect do to minimize data load times due to system calculations? 

A. Enable defer sharing calculations, and suspend sharing rule calculations 
B. Load the data through data loader, and turn on parallel processing. 
C. Leverage the Bulk API and concurrent processing with multiple batches 
D. Enable granular locking to avoid “UNABLE _TO_LOCK_ROW” error. 

Show Answer

Question # 14

Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com? 

A. Load all data using external IDs to link to parent records.
 B. Use workflow to calculate summary values instead of Roll -Up. 
C. Use triggers to calculate summary values instead of Roll -Up. 
D. Load all data after deferring sharing calculations. 

Show Answer

Question # 15

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. 

Show Answer

Question # 16

Universal Containers (UC) is transitioning from Classic to Lightning Experience. What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience? 

A. Add Notes and Attachments Related List to page Layout in Lighting Experience. 
B. Manually upload Notes in Lighting Experience. 
C. Migrate Notes and Attachment to Enhanced Notes and Files a migration tool
 D. Manually upload Attachments in Lighting Experience.

Show Answer

Question # 17

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. Missing phone number on the Contact record. 
B. Customer phone number has changed on the Contact record. 
C. Duplicate Contact records exist in the system. 
D. Duplicate Activity records on a Contact. 

Show Answer

Question # 18

Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org. Which three recommendations should a data architect make is order to reduce the number of records from the org? Choose 3 answers 

A. Use hard delete in Bulk API to permanently delete records from Salesforce. 
B. Use hard delete in batch Apex to permanently delete records from Salesforce. 
C. Identify records in objects that have not been modified or used In last 3 years. 
D. Use Rest API to permanently delete records from the Salesforce org. 
E. Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce. 

Show Answer

Question # 19

Cloud Kicks is launching a Partner Community, which will allow users to register shipment requests that are then processed by Cloud Kicks employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped. First, Cloud Kicks will introduce its community to 6,000 customers in North America, and then to 24,000 customers worldwide within the next two years. Cloud Kicks expects 12 shipment requests per week per customer, on average, and wants customers to be able to view up to three years of shipment requests and use Salesforce reports. What is the recommended solution for the Cloud Kicks Data Architect to address the requirements? 

A. Create an external custom object to track shipment requests and a child external object to track shipment items. External objects are stored off-platform in Heroku’s Postgres database. 
B. Create an external custom object to track shipment requests with five lookup custom fields for each item being shipped. External objects are stored off-platform in Heroku’s Postgres database. 
C. Create a custom object to track shipment requests and a child custom object to track shipment items. Implement an archiving process that moves data off-platform after three years. 
D. Create a custom object to track shipment requests with five lookup custom fields for each item being shipped Implement an archiving process that moves data off-platform after three years. 

Show Answer

Question # 20

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. Use Splunk to query the system logs looking for transaction time and CPU usage. 
B. Enable and use the query plan tool in the developer console. 
C. Use salesforce’s query optimizer to analyze the query in the developer console. 
D. Open a ticket with salesforce support to retrieve transaction logs to e analyzed for processing time. 

Show Answer

Question # 21

A casino is implementing salesforce and is planning to build a customer 360 view for a customer who visits its resorts. The casino currently maintained the following systems that records customer activity: 1.Point of sales system: All purchases for a customer. 2.Salesforce: All customer service activity and sales activity for a customer. 3.Mobile app: All bookings, preferences and browser activity for a customer. 4.Marketing: All email, SMS and social campaigns for a customer. Customer service agents using salesforce would like to view the activities from all system to provide supports to customers. The information has to be current and real time. What strategy should the data architect implement to satisfy this requirement?  

A. Explore external data sources in salesforce to build 360 view of customer. 
B. Use a customer data mart to view the 360 view of customer. 
C. Migrate customer activities from all 4 systems into salesforce. 
D. Periodically upload summary information in salesforce to build 360 view. 

Show Answer

Question # 22

Universal Containers (UC) is expecting to have nearly 5 million shipments records in its Salesforce org. Each shipment record has up to 10 child shipment item records. The Shipment custom object has an Organization-wide Default (OWD) sharing model set to Private and the Shipment Item custom object has a Master-Detail relationship to Shipment. There are 25 sharing rules set on the Shipment custom object, which allow shipment records to be shared to each of UC's 25 business areas around the globe. These sharing rules use public groups, one for each business area plus a number of groups for management and support roles. UC has a high turnover of Sales Reps and often needs to move Sales Reps between business areas in order to meet local demand. What feature would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements?

 A. Implement data archiving for old Shipment records.
 B. Contact Salesforce to create Skinny tables on Shipment. 
C. Configure shipment OWD to Public Read/Write. 
D. Contact Salesforce to enable Defer Sharing Rules 

Show Answer

Question # 23

Universal Containers (UC) has deployed Salesforce to manage Marketing. Sales, and Support efforts in a multi -system ERP environment After reaching the limits of native reports & dashboards. UC leadership is looking to understand what options can be used to provide more analytical insights. What two approaches should an architect recommend? Choose 2 answers 

A. AppExchange Apps 
B. Wave Analytics 
C. Weekly Snapshots 
D. Setup Audit Trails 

Show Answer

Question # 24

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. 

Show Answer

Question # 25

Universal Containers has millions of rows of data in Salesforce that are being used in reports to evaluate historical trends. Performance has become an issue, as well as data storage limits. Which two strategies should be recommended when talking with stakeholders? 

A. Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records. 
B. Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.
 C. Use Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records. 
D. Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits. 

Show Answer

Question # 26

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 

Show Answer

Question # 27

Universal Containers has two systems. Salesforce and an on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution? 

A. Implement a Master Data Management system to determine system of record. 
B. Implement a workflow rule that sends Opportunity data through Outbound Messaging. 
C. Have the ERP poll Salesforce nightly and bring in the desired Opportunities. 
D. Implement an hourly integration to send Salesforce Opportunities to the ERP system. 

Show Answer

Question # 28

Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew? 

A. Create a picklist field, values sorted alphabetically. 
B. Create a Master -Detail to custom object ShippingStatus c. 
C. Create a Lookup to custom object ShippingStatus c. 
D. Create a text field and make it an external ID. 

Show Answer

Question # 29

Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time? 

A. Load Contact records together using the Streaming API via the Upsert operation. 
B. Delete all existing records, and then load all records together via the Insert operation. 
C. Load all records via the Upsert operation to determine new records vs. existing records. 
D. Load new records via the Insert operation and existing records via the Update operation. 

Show Answer

Question # 30

A casino is implementing Salesforce and is planning to build a customer 360 degree view for a customer who visits its resorts. The casino currently maintains the following systems that record customer activity: L Point-of-sale system: All purchases for a customer 2. Salesforce; All customer service activity and sales activities for a customer 3. Mobile app: All bookings, preferences, and browser activity for a customer 4. Marketing: All email, SMS, and social campaigns for a customer Customer service agents using Salesforee would like to view the activities from all four systems to provide support to customers. The information has to be current and real time. What strategy should the data architect implement to satisfy this requirement? 

A. Explore external data sources in Salesforce to build a 360 degree view of the customer. 
B. Use a customer data mart to create the 360 degree view of the customer. 
C. Periodically upload summary information in Salesforce to build a 360 degree view. 
D. Migrate customer activities fro, all four system into Salesforce. 

Show Answer

Question # 31

Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality? 

A. Use Duplicate Management. 
B. Use an Enterprise Service Bus. 
C. Use Data.com Clean
D. Use a data wharehouse. 

Show Answer

Question # 32

US has released a new disaster recovery (DR)policy that states that cloud solutions need a business continuity plan in place separate from the cloud providers built in data recovery solution. Which solution should a data architect use to comply with the DR policy? 

A. Leverage a 3rd party tool that extract salesforce data/metadata and stores the information in an external protected system. 
B. Leverage salesforce weekly exports, and store data in Flat files on a protected system. 
C. Utilize an ETL tool to migrate data to an on-premise archive solution. 
D. Write a custom batch job to extract data changes nightly, and store in an external protected system. 

Show Answer

Question # 33

Universal Containers has a public website with several forms that create Lead records in Salesforce using the REST API. When designing these forms, which two techniques will help maintain a high level of data quality?

 A. Do client-side validation of phone number and email field formats. 
B. Prefer picklist form fields over free text fields, where possible. 
C. Ensure the website visitor is browsing using an HTTPS connection. 
D. Use cookies to track when visitors submit multiple forms. 

Show Answer

Question # 34

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. 

Show Answer

Question # 35

Northern Trail Outfitters has these simple requirements for a data export process: File format should be in CSV. Process should be scheduled and run once per week. The expert should be configurable through the Salesforce UI. Which tool should a data architect leverage to accomplish these requirements? 

A. Bulk API
 B. Data export wizard
 C. Third-party ETL tool 
D. Data loader 

Show Answer

Question # 36

DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year. A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist. What are two important considerations for the Data Architect in this scenario? (Choose two.) 

A. Standard list view in-line editing. 
B. Limitations on Org data storage.
 C. Bulk API limitations on picklist fields. 
D. Limitations on master-detail relationships. 

Show Answer

Question # 37

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. Use SOQL queries without WHERE conditions.
 B. Work with Salesforce Support to enable Skinny Tables. 
C. Reduce the number of triggers on Order _c object. 
D. Make the queries more selective using indexed fields. 

Show Answer

Question # 38

A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?

A. Query only indexed ID field values on the imported order to import related order lines. 
B. Leverage an External ID from source system orders to import related order lines. 
C. Leverage Batch Apex to update order ID on related order lines after import. 
D. Leverage a sequence of numbers on the imported orders to import related order lines. 

Show Answer

Question # 39

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 store long-term lead records in custom storage objects to avoid counting against storage limits. 
B. UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs. 
C. UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.
 D. UC can leverage a “tier”-based approach to classify the record storage need. 

Show Answer

Question # 40

UC is implementing sales cloud for patient management and would like to encrypt sensitive patient records being stored in files. Which solution should a data architect recommend to solve this requirement? 

A. Implement shield platform encryption to encrypt files.
 B. Use classic encryption to encrypt files. 
C. Implement 3rd party App Exchange app to encrypt files. 
D. Store files outside of salesforce and access them to real time. 

Show Answer

Question # 41

UC has to built a B2C ecommerce site on Heroku that shares customer and order data with a Heroku Postgres database. UC is currently utilizing Postgres as the single source of truth for both customers and orders. UC has asked a data architect to replicate the data into salesforce so that salesforce can now act as the system of record. What are the 3 considerations that data architect should weigh before implementing this requirement? Choose 23 answers: 

A. Consider whether the data is required for sales reports, dashboards and KPI’s. 
B. Determine if the data is driver of key process implemented within salesforce. 
C. Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application. 
D. Ensure the data is CRM center and able to populate standard of custom objects. 
E. A selection of the tool required to replicate the data. 
F. – Heroku Connect is required but this is confusing 

Show Answer

Question # 42

A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers 

A. Review the metadata xml files for redundant fields to consolidate. 
B. Determine if any integration points create records in Salesforce. 
C. Run key reports to determine what fields should be required. 
D. Export the setup audit trail to review what fields are being used. 
E. Review the sharing model to determine impact on duplicate records. 

Show Answer

Question # 43

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. 

Show Answer

Question # 44

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 in multiple batches 
B. Export Bulk API in parallel mode 
C. Use PK Chunking 
D. Limit Batch to 10K records 

Show Answer

Question # 45

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 as ETL tool to orchestrate the migration. 
B. Use Data Loader for export and Data Import Wizard for import 
C. Write a script to use the Bulk API 
D. Use the Salesforces CLI to query, export, and import 

Show Answer

Question # 46

UC is migrating data from legacy system to SF. UC would like to preserve the following information on records being migrated: Date time stamps for created date and last modified date. Ownership of records belonging to inactive users being migrated to Salesforce. Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers. 

A. Log a case with SF to update these fields 
B. Enable update records with Inactive Owners Permission 
C. Enable Set Audit fields upon Record Creation Permission 
D. Enable modify all and view all permission. 

Show Answer

Question # 47

Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity data. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce. What is the recommended course of action to appropriately integrate this new system? 

A. The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts. 
B. A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts. 
C. The Opportunity engagement system should become the system of record for Opportunity records. 
D. Stakeholders should be brought together to discuss the appropriate data strategy moving forward. 

Show Answer

Question # 48

UC has multiple SF orgs that are distributed across regional branches. Each branch stores local customer data inside its org’s Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs. UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all orgs in one place. What should a data architect suggest to achieve this 360-degree view of the customer? 

A. Consolidate the data from each org into a centralized datastore 
B. Use Salesforce Connect’s cross-org adapter. 
C. Build a bidirectional integration between all orgs. 
D. Use an ETL tool to migrate gap Accounts and Contacts into each org.

Show Answer

Question # 49

A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy: State in which the customer is located City in which the customer is located if available Zip code In which the customer is located if available Changes to this information should have minimum code changes What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce? 

A. Create a custom object to maintain the pricing criteria. 
B. Assign the pricing criteria within customer pricing engine. 
C. Maintain require pricing criteria in custom metadata types. 
D. Configure the pricing criteria in price books. 

Show Answer

Question # 50

Which two aspects of data does an Enterprise data governance program aim to improve? 

A. Data integrity 
B. Data distribution 
C. Data usability 
D. Data modeling

Show Answer

Question # 51

Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bi-directional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space? 

A. Use Streaming API to get the current status from the ERP and display on the Opportunity page. 
B. Create an external object Invoice _x with a Lookup relationship with Opportunity. 
C. Create a custom object Invoice _c with a master -detail relationship with Opportunity. 
D. Create a custom object Invoice _c with a Lookup relationship with Opportunity. 

Show Answer