Free Certified Data Architect Sample Questions — Certified Data Architect

Northern Trail Outfitters (NTO) needs to extract 50 million records from a custom object every day from its Salesforce org. NTO is facing query time-out issues while extracting these records. What should a data architect recommend in order to get around the time-out issue?

• A. Use a custom auto number and formula field to chunk records while extracting data,
• B. Use the Rest API to extract data as it automatically chunks records by 200
• C. Use extract, transform, load (ETL) tool for extraction of records
• D. Ask Salesforce support to increase the query timeout value

Universal 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 two.)

• A. Build a nightly batch job to de-dupe data, and merge account records
• B. Integrate Salesforce with ERP, and make ERP as system of truth
• C. Build a nightly sync job from ERP to Salesforce
• D. Implement a de-dupe solution and establish account ownership in Salesforce

Universal 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 three.)

• A. You want real-time access to the latest data from other systems
• B. You need small amounts of external data at any one time
• C. You need to expose data via a virtual private connection
• D. You have a large amount of data and would like to copy subsets of it into Salesforce
• E. You have a large amount of data that you don't want to copy into your Salesforce org

A customer wants to maintain geographic location information including latitude and longitude in a custom object. What should a data architect recommend to satisfy this requirement?

• A. Create formula fields with geolocation functions for this requirement
• B. Create custom fields to maintain latitude and longitude information
• C. Create a geolocation custom field to maintain this requirement
• D. Recommend AppExchange packages to support this requirement

Universal 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?

• A. Lookup relationship field on Inventory__c, related to Account
• B. Indirect lookup relationship field on Account, related to Inventory__c
• C. Master-detail relationship field on Inventory__c, related to Account
• D. Master-detail relationship field on Account, related to Inventory__c

A 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?

• A. Create lookup to Custom Price object and share with distributors
• B. Manually update Opportunities with Prices applicable to distributors
• C. Configure Price Books for each region and share with distributors
• D. Add custom fields in Opportunity and use triggers to update prices

Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing. UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently. What should a data architect recommend to mitigate these errors?

• A. Remove SOQL statements from Apex Loops
• B. Enable sharing recalculations
• C. Ask Salesforce support for additional CPU power
• D. Enable granular locking

Universal 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?

• A. Ensure validation rules, triggers, and other automation tools are disabled
• B. Ensure duplication and matching rules are defined
• C. Bulkify the triggers to handle import loads
• D. Import the data is smaller batches over a 24-hour period

Universal 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?

• A. Create a visual force tab with the billing system encapsulated within an iframe
• B. Create a custom object and migrate the last 12 months of invoice data into Salesforce so it can be displayed on the Account layout
• C. Write an Apex callout and populate a related list to display on the account record
• D. Create a mashup page that will present the billing system records within Salesforce

United Containers (UC) has released a new disaster recovery (DR) policy that states that cloud solutions need a business continuity plan in place separate from the cloud provider's built-in data recovery solution. Which solution should a data architect use to comply with the DR policy?

• A. Leverage a third-party tool that extracts Salesforce data/metadata, and stores the information in an external protected system
• B. Utilize an ETL tool to migrate data to an on-premise archival solution
• C. Leverage Salesforce weekly exports, and store data in flat files on a protected system
• D. Write a custom batch Job to extract data changes nightly, and store on an external protected system

Universal 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?

• A. Contact Salesforce support to enable skinny table for cases
• B. Build reports using custom Lightning components
• C. Create a custom object to store aggregate data and run reports
• D. Move data off of the platform and run reporting outside Salesforce, and give access to reports

Northern 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 three.)

• A. Explore third-party data providers to enrich and augment information entered in Salesforce
• B. Build a sales data warehouse with purpose-built data marts for dashboards and senior management reporting
• C. Design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect
• D. Periodically export data to cleanse data and import them back into Salesforce for executive reports
• E. Leverage Salesforce features, such as validation rules, to avoid incomplete and incorrect records

Universal Containers (UC) has the following systems: 1. Billing system 2. Customer support system 3. CRM system UC has been having trouble with business intelligence across the different systems. Recently UC implemented a master data management (MDM) solution that will be the system of truth for the customer records. Which MDM data element is needed to allow reporting across these systems?

• A. Phone number
• B. Email address
• C. Full name
• D. Globally Unique Identifier

Universal 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?

• A. Validation Rule
• B. Apex Class
• C. Process Builder
• D. Required Fields

To address different compliance requirements such as General Data Protection Regulation (GDPR), personally identifiable information (PII), Health Insurance Portability and Accountability Act (HIPPA) and others, a Salesforce customer decided to categorize each data element in Salesforce with the following: 1. Data owner 2. Security level (i.e. confidential) 3. Compliance type (i.e. GDPR. PII, HIPAA) A compliance audit would require Salesforce 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 the 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

Universal Containers (UC) has millions of case records with case history and service level agreement data. UC's compliance team would like historical cases to be accessible for 10 years for audit purposes. What solution should a data architect recommend?

• A. Purchase more data storage to support the case object
• B. Use a custom big object to store archived case data
• C. Archive case data using a Salesforce Archival solution
• D. Use a custom object to store archived case data

Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on geographical regions (AMER, EMEA, APAC). NTO products are mastered in the AMER org and need to be created in the EMEA and APAC orgs after the products are approved. Which two features should a data architect recommend to share records between Salesforce orgs? (Choose two.)

• A. Federated Search
• B. Salesforce 2 Salesforce
• C. Change Data Capture (CDC)
• D. Salesforce Connect

Universal Containers (UC) Is migrating data from a legacy system to Salesforce. UC would like to preserve the following information on records being migrated: 1. Date time stamps for created date and last modified date 2. Ownership of records belonging to inactive users being migrated to Salesforce Which two solutions should a data architect recommend to preserve date timestamps and ownership on records? (Choose two.)

• A. Log a case with Salesforce to allow updating these fields
• B. Enable Modify All and View All permissions
• C. Enable Update Records with Inactive Owners permission
• D. Enable Set Audit Fields upon Record Creation permission

Universal 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 dally. Which license type should a data architect recommend that best fits these requirements?

• A. Lightning Platform Plus
• B. Service Cloud
• C. Lightning External Apps Starter
• D. Lightning Platform Starter

A large healthcare provider wishes to use Salesforce to track patient care. The following actors are in Salesforce: 1. Payment providers: Organizations who pay for the care to patients. 2. Doctors: They provide care plans for patients and need to support multiple patients. They are provided access to patient information. 3. Patients: These are individuals who need care. A data architect needs to map the actors to Salesforce objects. What should be the optimal selection by the data architect?

• A. Patients as Person Accounts, Payment providers as Accounts, and Doctors as Person Accounts
• B. Patients as Person Accounts, Payment providers as Accounts, and Doctors as Contacts
• C. Patients as Contacts, Payment providers as Accounts, and Doctors as Accounts
• D. Patients as Accounts, Payment providers as Accounts, and Doctors as Person Accounts