Pass Data-Architect Exam – Real Test Engine PDF with 260 Questions [Q21-Q44]

Rate this post

Pass Data-Architect Exam – Real Test Engine PDF with 260 Questions

Get New Data-Architect Certification Practice Test Questions Exam Dumps

Salesforce Data-Architect Exam Syllabus Topics:

Section	Objectives
Topic 1: Data Governance and Management	– Security and compliance 1. Data access controls 2. Regulatory compliance considerations – Data quality management 1. Deduplication strategies 2. Data validation rules
Topic 2: Data Modeling and Database Design	– Salesforce data model design 1. Standard and custom objects usage 2. Schema design for scalability – Data modeling concepts 1. Normalization and denormalization strategies 2. Relational vs. non-relational data design
Topic 3: Master Data Management (MDM)	– MDM architecture 1. Data synchronization approaches 2. Golden record design
Topic 4: Large Data Volume and Performance	– Scalability considerations 1. Bulk data processing strategies 2. Indexing and query optimization
Topic 5: Data Integration	– Salesforce integration tools 1. Platform events and change data capture 2. MuleSoft and REST/SOAP APIs – Integration patterns 1. ETL vs real-time integration 2. API-based integration strategies

NEW QUESTION 21
Universal Containers has implemented Salesforce for its operations. In order for customers to be created in their MDM solution, the customer record needs to have the following attributes:
1. First Name
2. Last Name
3. Email
Which option should the data architect recommend to mandate this when customers are created in Salesforce?

Configure Page Layout marking attributes as required fields.

Create validation rules to check If the required attributes are entered.

Mark Fields for the attributes as required under Setup.

Build validation in Integration with MDM to check required attributes.

NEW QUESTION 22
Cloud Kicks currently has a Public Read/Write sharing model for the company’s Contacts. Cloud Kicks management team requests that only the owner of a contact record be allowed to delete that contact.
What should an Architect do to meet these requirements?

Set the profile of the users to remove delete permission from the Contact object.

Check if the current user is NOT the owner by creating a “before delete” trigger.

Set the Sharing settings as Public Read Only for the Contact object.

Check if the current user is NOT the owner by creating a validation rule on the Contact object.

NEW QUESTION 23
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

Review the setup audit trail for configuration changes.

Put the business purpose in the Description of each field.

Maintain a data dictionary with the justification for each field.

Use the Force.com IDE to save the metadata files in source control.

NEW QUESTION 24
UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.
Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.

Limit associating 10000 records looking up to same records.

Limit assigning one user 10000 records ownership.

Use picklist fields rather than lookup to custom object.

Assign 10000 opportunities to one account.

Limit associating 10000 opportunities to one account.

NEW QUESTION 25
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

Use hard delete in Bulk API to permanently delete records from Salesforce.

Use hard delete in batch Apex to permanently delete records from Salesforce.

Identify records in objects that have not been modified or used In last 3 years.

Use Rest API to permanently delete records from the Salesforce org.

Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.

NEW QUESTION 26
Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle__ c) and Service History (Service-History__ c) are both custom objects related through a lookup relationship.
Every week a batch synchronization process updates the Vehicle and Service History records in Salesforce. UC has two hours of migration window every week and is facing locking issues as part of the data migration process.
What should a data architect recommend to avoid locking issues without affecting performance of data migration?

Use Bulk API parallel mode for data migration

Use Bulk API serial mode for data migration

Insert the order in another custom object and use Batch Apex to move the records to Service_ Order__ c object.

Change the lookup configuration to “Clear the value of this field” when lookup record is deleted.

NEW QUESTION 27
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:

Consider whether the data is required for sales reports, dashboards and KPI’s.

Determine if the data is driver of key process implemented within salesforce.

Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application.

Ensure the data is CRM center and able to populate standard of custom objects.

A selection of the tool required to replicate the data.

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

Use a third-party backup solution to backup all data off platform.

Build a batch join move all records off platform, and delete all records from Salesforce.

Build a batch join to move two-year-old records off platform, and delete records from Salesforce.

Build a batch job to move all restore off platform, and delete old records from Salesforce.

NEW QUESTION 29
Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement?
Choose 2 answers

Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.

Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.

Turn on field Contact object history tracking for these ten fields, then create reports on contact history.

Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.

NEW QUESTION 30
Universal containers is implementing Salesforce lead management. UC Procure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information? Option

Ask sales people to search for populating company profile and location data

Run reports to identify records which does not have company profile and location data

Leverage external data providers populate company profile and location data

Export data out of Salesforce and send to another team to populate company profile and location data

NEW QUESTION 31
Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.
What is the fastest and most effective way for a data architect to solve the time-out issue?

Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.

Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.

Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on It.

NEW QUESTION 32
Universal Containers (UC) has implemented a master data management strategy, which uses a central system of truth, to ensure the entire company has the same customer information in all systems. UC customer data changes need to be accurate at all times in all of the systems. Salesforce is the identified system of record for this information.
What is the correct solution for ensuring all systems using customer data are kept up to date?

Send customer data nightly to the system of truth in a scheduled batch job.

Send customer record changes from Salesforce to each system in a nightly batch job.

Send customer record changes from Salesforce to the system of truth in real time.

Have each system pull the record changes from Salesforce using change data capture.

NEW QUESTION 33
Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations.
Which two solutions should a data architect recommend to mitigate data quality issues?

Leverage picklist and lookup fields where possible

Leverage Apex to validate the format of data being entered via a mobile device.

Leverage validation rules and workflows.

Leverage third-party- AppExchange tools

NEW QUESTION 34
Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed. Which two techniques should be used for smooth interoperability now and in the future.

Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.

Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.

Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.

Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.

NEW QUESTION 35
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:

Define key fields in staging database for data cleansing

Define data duplication standards and rules

Finalize an extract transform load (ETL) tool for data migration

Measure data completeness and accuracy

Measure data timeliness and consistency

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

Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.

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.

Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications.

Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications ;

NEW QUESTION 37
Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.
Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

Number of queries running at a time.

Number of joins used in report query.

Number of records returned by report query.

Number of characters in report query.

NEW QUESTION 38
Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.
What is the fastest and most effective way for a data architect to solve the time-out issue?

Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.

Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.

Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on It.

Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

NEW QUESTION 39
Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items. What should UC’s Data Architect recommend to ensure scalability?

Ensure the account product vendor provides a sound data archiving strategy.

Ensure the account product vendor includes Wave Analytics in their offering.

Ensure invoice line items simply reference existing Opportunity line items.

Ensure the accounting product runs 100% natively on the Salesforce platform.

NEW QUESTION 40
Get Cloudy Consulting is migrating their legacy system’s users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.
Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.
Which two approaches will accomplish this goal? (Choose two.)

Create the users, upload all data, and then deploy the sharing rules.

Contact Salesforce to activate indexing before uploading the data.

Defer sharing calculations until the data has finished uploading.

First, load all account records, and then load all user records.

NEW QUESTION 41
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

Create a custom object to store a copy of the record when changed.

Create a custom object to store the previous and new field values.

Use Analytic Snapshots to store a copy of the record when changed.

Select the 100 fields in the Opportunity Set History Tracking page.

NEW QUESTION 42
A data architect is working with a large B2C retailer and needs to model the consumer account structure in Salesforce.
What standard feature should be selected in this scenario?

Individual Accounts

Account Contact

Contacts

Person Accounts

NEW QUESTION 43
Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support reps case closure rates?

Enable field history tracking on the Case object.

Create a report on Case analytic snapshots.

Install AppExchange packages for available reports.

Create Contact and Opportunity Reports and Dashboards.

NEW QUESTION 44
Universal Containers is creating a new B2C service offering for consumers to ship goods across continents. This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored. What is the recommended data model for consumer account data to be stored in Salesforce?

Use the Account object with Person Accounts and a new B2C page layout.

Use the Account object with a newly created Record Type for B2C customers.

Create a new picklist value for B2C customers on the Account Type field.

Use 50 umbrella Accounts for each region, with customers as associated Contacts.