Quiz
Data Architect 2
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (38)
1Universal 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 orgs: 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 migration will need occur within the next two months, prior to the spilt.
Which migration strategy should a data architect use to successfully migrate the data?- AUse an ETL tool to orchestrate the migration.
- BWrite a script to use the Bulk API.
- CUse the Salesforce CLI to query, export, and import.
- DUse Data Loader for export and Data Import Wizard for import
2Northern 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 export should be configurable through the Salesforce UI.
Which tool should a data architect leverage to accomplish these requirements?- AThird-party ETL Tool.
- BData Loader.
- CBulk API
- DData Export Wizard
3Northern Trail Outfitters (NTO) has a variety of customers that include households, businesses, and individuals.
The following conditions exist within its system:
NTO has a total of five million customers.
Duplicate records exist, which is replicated across many systems, including Salesforce.
Given these conditions, there is a lack of consistent presentation and clear identification of a customer record.
Which three options should a data architect perform to resolve the issues with the customer data? Choose 3 answers- ACreate a customer master database external to Salesforce as a system of truth and sync the customer data will all systems.
- BInvest in data duplication tool to de-dupe and merge duplicate records across all systems.
- CDuplicate customer records across the systems and provide a two-way sync of data between the systems.
- DCreate a unique global customer ID for each customer and store that in all systems for referential identity.
- EUse Salesforce CDC to sync customer data across all systems to keep customer record in sync
4Universal Containers is implementing Salesforce and needs to migrate data from two legacy systems. UC would like to clean deduplicate data before migrating to Salesforce.
Which solution should a data architect recommend a clean migration?- ADefine external IDs for an object, insert data from one database, and use upsert for a second database.
- BDefine deduplicate rules in Salesforce, and load data into Salesforce from both databases.
- CSet up staging database, and define external IDs to merge, clean, deduplicate data, and load into Salesforce.
- DDefine external IDs for an object, migrate second database to first database, and load into Salesforce.
5Northern Trail Outfitters (NTO) has the following systems:
1.Customer master—source of truth for customer information.
2. Service cloud—customer support.
3. Marketing cloud—marketing communications
4. Enterprise data warehouse-business reporting
The customer data is duplicated across all these systems and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call in to update their information.
NTO is planning to implement a master data management (MDM) solution across the enterprise.
Which three data issues will an MDM tool solve? Choose 3 answers- AData loss and recovery
- BData accuracy and quality
- CData completeness
- DData duplication
- EData standardization
6Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs chance of encountering race conditions on the same record.
What should a data architect recommend to guarantee that records are not being updated at the same time?- AMigrate programmatic logic to processes and flows.
- BDisable classes or triggers that have the potential to obtain the same record.
- CEmbed the keywords FOR UPDATE after SOQL statements.
- DRefactor or optimize classes and triggers for maximum CPU performance.
7Northern 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 architecture 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?- AA middleware solution that extracts and distributes data across both the hub and spokes.
- BDevelop custom APIs to poll the spoke org for change data and push into the hub org.
- CDevelop custom APIs to poll the hub org for change data and push into the spoke orgs.
- DA backup and archive solution that extracts and restores data across orgs.
8Northern Trail Outfitters is migrating to Salesforce from a legacy CRM system that identifies the agent relationship in a look-up table. What should the data architect do in order to migrate the data to Salesforce?
- ACreate custom object to store agent relationships
- BAssign record owners based on relationship
- CMigrate the data and assign to a non-person system
- DMigrate to Salesforce without a record owner
9Northern Trail Outfitters has implemented Salesforce for its sales associates nationwide. Senior management is concerned that the executive dashboards are not reliable for their real-time decision-making. On analysis, the team found the following issues with data entered in Salesforce:
1. Information in certain records is incomplete
2. Incorrect entry in certain fields causes records to be excluded in report filters
3. Duplicate entries cause incorrect counts.
Which three steps should a data architect recommend to address the issues? Choose 3 answers- ADesign and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect
- BPeriodically export data to cleanse data and import them back into Salesforce for executive reports
- CExplore third-party data providers to enrich and augment information entered in Salesforce
- DBuild a sales data warehouse with purpose-built data marts for dashboards and senior management reporting
- ELeverage Salesforce features, such as validation rules, to avoid incomplete and incorrect records.
10During the implementation of Salesforce, a customer has the following requirements for Sales Order:
1. Sales Order information needs to be shown to users in Salesforce. 2. Sales Order are maintained in the on-premise enterprise resource planning (ERP)
3. Sales Order information has more than 150 million records.
4. Sales Order will not be updated in Salesforce
What should a data architect recommend for maintaining Sales Orders in Salesforce?- AUse external objects to maintain Sales Orders in Salesforce
- BUse Standard Order object to maintain Sales Orders in Salesforce
- CUse custom big objects to maintain Sales Orders in Salesforce
- DUse custom objects to maintain Sales Orders in Salesforce
11A large multinational B2C Salesforce customer is looking to implement their distributor management application in Salesforce. The application has the following capabilities:
1. Distributors create Sales Orders in Salesforce
2. Sales Orders are based on Product prices applicable to their region
3. Sales Orders aRe closed once they are fulfilled
4. It is decided to maintain Sales Orders in Opportunities object
How should the data architect model this requirement?- AConfigure Price Books for each region and share with distributors
- BManually update Opportunities with Prices applicable to distributors.
- CAdd custom fields in Opportunity and use triggers to update prices
- DCreated lookup to Custom Price object and share with distributors
12Universal Containers (UC) stores 10 million rows of inventory data in a cloud database. As part of creating a connected experience in Salesforce, UC would like to expose this inventory data to Sales Cloud without a direct import. UC has asked its data architect to determine if Salesforce Connect is needed. Which three considerations should the data architect make when evaluating the need for Salesforce Connect? Choose 3 answers
- AYou need to expose data via a virtual private connection.
- BYou want real-time access to the latest data from other systems.
- CYou have a large amount of data that you don’t want to copy into your Salesforce org.
- DYou have a large amount of data and would like to copy subsets of it into Salesforce.
- EYou need small amounts of external data at any one time.
13Northern Trail Outfitters (NTO) runs its entire business out of an enterprise data warehouse (EDW). NTO’s sales team is starting to use Salesforce after a recent implementation, but currently lacks the data required to advance leads and opportunities to the next stage. NTO’s management has researched Salesforce Connect and would like to use it to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects. What should a data architect consider before implementing Salesforce Connect for reporting?
- AMaximum external objects per org.
- BMaximum page size for server-driven paging.
- COData callout limits per day.
- DMaximum number of records returned.
14Universal 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 Salesforce and archive older data out of Salesforce. Which solution should a data architect recommend as an archiving solution?
- ABuild a batch job to move all records off platform, and delete old records from Salesforce.
- BBuild a batch job to move all records off platform, and delete all records from Salesforce
- CUse a third-party backup solution to back up all data off platform
- DBuild a batch job to move two-year-old records off platform, and delete old records from Salesforce
15 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 sources as comma-separated values (CSV) files for marketing purposes. Historically, UC would load these contacts into 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 process. What should a data architect recommend to UC in order to immediately avoid storage issues in the future?- AContinue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales Cloud after the sync is complete
- BLoad the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications
- CLoad the CSV files in Einsteins Analytics and sync with Marketing Cloud prior to sending marketing communications
- DLoad the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers
16Universal Containers (UC) is transitioning from Classic to Lightning Experience. What does UC need to do to ensure users have access to its notes and attachments in Lightning Experience?
- AManually upload Attachments in Lightning Experience
- BManually upload Notes in Lightning Experience
- CMigrate Notes and Attachments to Enhanced Notes and Files using a migration tool
- DAdd Notes and Attachments Related List to Page Layouts in Lightning Experience
17Universal Containers (UC) is in the process of migrating legacy inventory data from an enterprise resource planning (ERP) system into Sales Cloud with the following requirements:
1- Legacy inventory data will be stored in a custom child object called Inventory__c.
2- Inventory data should be related to the standard Account object.
3- The Inventory__c object should inherit the same sharing rules as the Account object.
4- Anytime an Account record is deleted in Salesforce, the related Inventory__c record(s) should be deleted as well.
What type of relationship field should a data architect recommend in this scenario?- ALookup relationship field on Inventory__c, related to Account
- BMaster-detail relationship field on Inventory__c, related to Account
- CMaster-detail relationship field on Account, related to Inventory__c
- DIndirect lookup relationship field on Account, related to Inventory__c
18Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records are created or updated by users. A majority of the automation tools within UC’s org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend. What should a data architect do to mitigate any unwanted results during the import?
- AEnsure duplication and matching rules are defined
- BBulkify the triggers to handle import loads
- CImport the data in smaller batches over a 24-hour
- DEnsure validation rules, triggers, and other automation tools are disabled
19Universal Containers (UC) would like to build a Human Resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately maintain and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,000 API calls into Salesforce from an on-premise application daily. Which license type should a data architect recommend that best fits these requirements?
- ALightning External Apps Starter
- BLightning Platform Starter
- CService Cloud
- DLightning Platform Plus
20 Universal Container has implemented Sales Cloud to manage patient and related health records. During a recent security audit of the system, it was discovered that some standard and custom fields need to be encrypted.
Which solution should a data architect recommend to encrypt existing fields?- AImplement shield platform encryption to encrypt custom and standard fields
- BExport data out of Salesforce and encrypt custom and standard fields
- CUser Apex Crypto Class to encrypt custom and standard fields
- DImplement classic encryption to encrypt custom and standard fields
21A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:
1- State in which the customer is located
2- City in which the customer is located
3- Zip code in which the customer is located if available
4- Changes to this information should have minimum code change.
What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?- AAssign the pricing criteria within custom pricing engine.
- BMaintain required pricing criteria in custom metadata.
- CCreate a custom object to maintain the pricing criteria.
- DConfigure the pricing criteria in price books
22Universal Containers (UC) has adopted Salesforce as its primary sales automation tool. UC has 100,000 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 up a customer record and view their account status, invoice history, and open opportunities without navigating outside of Salesforce.
What should a data architect use to provide the sales team with the required functionality?- AWrite an Apex callout and populate a related list to display on the account record
- BCreate a custom object and migrate the last 12 months of invoice data into Salesforce so it can be displayed on the Account layout
- CCreate a mashup page that will present the billing system records within Salesforce
- DCreate a visual force tab with the billing system encapsulated within an iframe
23Universal Containers (UC) is migrating from a legacy system to Salesforce CRM. UC is concerned about that quality of data being entered by users and through external integrations. Which two solutions should a data architect recommend to mitigate data quality issues? Choose 2 answers
- ALeverage validation rules and workflows
- BLeverage third-party AppExchange tools
- CLeverage Apex to validate the format of data being entered via a mobile device
- DLeverage picklist and lookup fields where possible
24Northern Trail Outfitters (NTO) uses Sales Cloud and Service Cloud to manage their sales and support processes. Some of NTOs teams ae complaining they see new fields on their page and are unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesfoce.
Which governance measure should a data architect recommend to solve this issue?- ACreate validation rules with error messages to explain why the field is used
- BCreate and manage a data dictionary, and use a governance process for changes made to common objects.
- CAdd description fields to explain why the field is used, and mark the fields as Required
- DCreate reports to identify which fields uses are leaving blank, and use external data sources to augment the missing data.
25Universal Containers (UC) 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 requirements?- ABring all data in Salesforce, and delete it after a year
- BLeverage real-time integration to pull records into Salesforce
- CLeverage mashup to display historical records in Salesforce
- DBuild a swivel chair solution to go into the legacy system and display records
26As part of addressing general data protection regulation (GDPR) requirements, Universal Containers (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?- ABuild reports that contain customer information and classify manually
- BCreate a custom picklist field to capture classification of information on the Contact object.
- CUse Data Classification metadata fields available in Field definition
- DUse an AppExchange product to classify fields based on policy
27Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting performance issues and time-outs while running case reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?- ABuild reports using custom Lightning components
- BContact salesforce support to enable skinny table for cases
- CMove data off of the platform and run reporting outside Salesforce and give access to reports
- DCreate a custom object to store aggregate data and run reports.
28Universal Containers (UC) has implemented Sales Cloud for its entire sales organization. UC has built a custom object called Projects__c that stores customer project details and employee billable hours. The following requirements are needed:
1. A subset of individuals from the finance team Will need access to the Projects object for reporting and adjusting employee utilization.
2. The finance users Will not need access to any sales objects, but they Will need to interact with the custom object.
Which license type should a data architect recommend for the finance team that best meets the requirements?- AService Cloud
- BLightning Platform Starter
- CLightning Platform Plus
- DSales Cloud
29Universal Containers has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master. Sales teams are complaining about duplicate account records and data quality issues with account data. Which two solutions should a data architect recommend to resolve the complaints? Choose 2 answers
- AImplement a de-dupe solution and establish account ownership in Salesforce
- BBuild a nightly sync job from ERP to Salesforce
- CIntegrate Salesforce with ERP and make ERP as a system of truth.
- DBuild a nightly batch job to de-dupe data, and merge account records
30Universal Containers requires all customers to provide either a phone number or an email address when registering for an account. What should the data architect use to ensure this requirement is met?
- AProcess Builder
- BRequired Fields
- CApex Class
- DValidation Rule
31Universal Containers has a requirement to store more than 100 million records in Salesforce and needs to create a custom big object to support this business requirement. Which two tools should a data architect use to build custom big object? Choose 2 answers
- AUse DX to create big object
- BUse Metadata API to create big object
- CGo to Big Object in Setup and select new to create big object
- DGo to Object Manager in Setup and select new to create big object
32Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data. Currently, it has data backup processes that runs weekly, which backs 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?- AUse AppExchange package for backup and restore
- BUse ETI- tool for backup and restore from EDW
- CChange weekly backup process to daily backup, and implement a custom restore solution
- DUse Bulk API to extract data on daily basis to EDW and REST API for restore.
33Universal Containers is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status. What solution should a data architect recommend to give the sales team visibility into order status?
- ABuild batch jobs to push order line items to Salesforce.
- BLeverage salesforce Connect to bring the order line item from the legacy system to salesforce.
- CLeverage Canvas to bring the order management UI in to the Salesforce tab.
- DBuild real-time integration to pull order line items into salesforce when viewing orders
34Universal Containers is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and automated updates at the same time. What should a data architect do in order to resolve the issue?
- AEnable parallel sharing rule calculation
- BEnable granular locking.
- CEnable defer sharing calculation.
- DEnable implicit sharing
35Universal Containers (UC) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract IDO million records from Salesforce for migration to the EDW .
What data extraction strategy should a data architect use for maximum performance?- AInstall a third-party AppExchange tool.
- BUtilize PK Chunking with the Bulk API.
- CCall the REST API in successive queries.
- DUse the Bulk API in parallel mode.
36Northern Trail Outfitters (NTO) 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? Choose 2 answers- AStandard SOQL queries
- BAsync SOQL with a custom object
- CStandard reports and dashboards
- DEinstein Analytics
37A large insurance provider is looking to implement Salesforce. The following conditions exist: 1. Multiple channels for lead acquisition 2. Duplicate leads across channels 3. Poor customer experience and higher costs On analysis, it was found that there are duplicate leads that are resulting in multiple quotes and opportunities. Which three actions should a data architect recommend to mitigate the issues? Choose 3 answers
- AStandardize lead information across all channels
- BBuild process to manually search and merge duplicates.
- CBuild a custom solution to identify and merge duplicate leads
- DImplement de-duplication strategy to prevent duplicate leads
- EImplement third-party solution to clean and enrich lead data
38Universal Containers (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 options to delete unused records from the org. Which three recommendations should a data architect make in order to reduce the number of records from the org? Choose 3 answers
- AUse hard delete in Bulk API to permanently delete records from Salesforce
- BUse hard delete in Batch Apex to permanently delete records from Salesforce
- CArchive the records in enterprise data warehouse (EDW) before deleting from Salesforce
- DIdentify records in objects that have not been modified or used in last 3 years
- EUse Rest API to permanently delete records from the Salesforce org
Information
- Description
- Quiz on Data Architect 2, created by Maribel 00 on 05/04/2025.
- Author
- Maribel 00
- Language
- English
- Views
- 0
- Tags
- Rating
- No ratings yet Rate this quiz