DATA-ARCHITECT Online Practice Questions and Answers
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.
All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems:
An ERP system feeds order data into Salesforce and updates both Account and Opportunity records.
An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records.
A commission system feeds commission data into Salesforce and updates both Account and Opportunity records.
How should the architect determine which of these systems is the system of record?
A. Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.
B. Whatever system updates the attribute or object should be the system of record for that field or object.
C. Whatever integration data flow runs last will, by default, determine which system is the system of record.
D. Data flows should be reviewed with the business users to determine the system of record per object or field.
Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:
Accounts Contacts Opportunities Orders Order Line Items
Which issue will an architect have when implemented this in Salesforce?
A. Custom report types CANNOT contain Opportunity data.
B. Salesforce does NOT support Orders or Order Line Items.
C. Salesforce does NOT allow more than four objects in a single report type.
D. A report CANNOT contain data from Accounts and Contacts.
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.
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.
Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc. What is the recommended approach for defining a solution for this requirement?
A. Use a field audit trail to capture field changes.
B. Use a custom object and trigger to capture changes.
C. Use Event Monitoring to capture these changes.
D. Use a third-party AppExchange app to capture changes.
Based on government regulations, a Salesforce customer plans to implement the following in Salesforce for compliance:
Access to customer information based on record ownership Ability for customers to request removal of their information from Salesforce Prevent users from accessing Salesforce from outside company network (virtual private network, or VPN)
What should a data architect recommend to address these requirements?
A. Contact Salesforce support to restrict access only with VPN and other requirements
B. Allow users access to Salesforce through a custom web application hosted within VPN.
C. Implement IP restrictions, sharing settings, and custom Apex to support customer requests.
D. Implement Salesforce shield with Event Monitoring to address the requirement.
NTO has decided to franchise its brand. Upon implementation, 1000 franchisees will be able to access BTO's product information and track large customer sales and opportunities through a portal. The Franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.
Which licenses does NTO need to provide these features to the Franchisees?
A. Salesforce Sales Cloud license
B. Lightning Platform license
C. Customer Community license
D. Partner Community license
Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?
A. Create a "before delete" trigger to check if the current user is not the owner.
B. Set the Sharing settings as Public Read Only for the Contact object.
C. Set the profile of the users to remove delete permission from the Contact object.
D. Create a validation rule on the Contact object to check if the current user is not the owner.
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
NTO has 1 million customer records spanning 25 years. As part of its new SF project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data.
Which 3 activities will be required to identify a successful master data management strategy? Choose 3 answers:
A. Identify data to be replicated
B. Create a data archive strategy
C. Define the systems of record for critical data
D. Install a data warehouse
E. Choose a Business Intelligence tool.
Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard is not reliable for their real-time decision-making. On analysis, the team the following issues with data entered in Salesforce.
Information in certain records is incomplete.
Incorrect entry in certain fields causes records to be excluded in report fitters.
Duplicate entries cause incorrect counts.
Which three steps should a data architect recommend to address the issues?
A. Periodically export data to cleanse data and import them back into Salesforce for executive reports.
B. Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.
C. Explore third-party data providers to enrich and augment information entered in salesforce.
D. Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.
E. design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect
Universal Container (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 this inventory data to Sales Cloud without a import. UC has asked its data architect to determine if Salesforce Connect is needed.
Which three consideration should the data architect make when evaluating the need for Salesforce Connect?
A. You want real-time access to the latest data, from other systems.
B. You have a large amount of data and would like to copy subsets of it into Salesforce.
C. You need to expose data via a virtual private connection.
D. You have a large amount of data that you don't want to copy into your Salesforce org.
E. You need to small amounts of external data at any one time.
Universal Containers has a custom object with millions of rows of data.
When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)
A. Using leading % wildcards.
B. Using trailing % wildcards.
C. Performing large loads and deletions.
D. Using NOT and != operators.
E. Using a custom index on a deterministic formula field.
Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for 5 years. Managers at Get Cloudy Consulting need access to up to one week's worth of these status reports with all of their details.
An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce.
Which two limits should the Architect be aware of? (Choose two.)
A. Data storage limits
B. Workflow rule limits
C. API Request limits
D. Webservice callout limits
Why select/choose certbus.com?
Millions of interested professionals can touch the destination of success in exams by certbus.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.
Copyright © 2004-2025 certbus.com, All Rights Reserved.