Updated Jan 23, 2023 Verified Pass Data-Architect Exam in First Attempt Guaranteed [Q62-Q82]

Share

Updated Jan 23, 2023 Verified Pass Data-Architect Exam in First Attempt Guaranteed

Free Data-Architect Sample Questions and 100% Cover Real Exam Questions (Updated 224 Questions)

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

  • A. Use 50 umbrella Accounts for each region, with customers as associated Contacts.
  • B. Create a new picklist value for B2C customers on the Account Type field.
  • C. Use the Account object with a newly created Record Type for B2C customers.
  • D. Use the Account object with Person Accounts and a new B2C page layout.

Answer: D

 

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

Answer: B

 

NEW QUESTION 64
Universal Containers has successfully migrated 50 million records into five different objects multiple times in a full copy sandbox. The Integration Engineer wants to re-run the test again a month before it goes live into Production. What is the recommended approach to re-run the test?

  • A. Hard delete all 5 objects' data and re-run the data migration test.
  • B. Truncate all 5 objects quickly and re-run the data migration test.
  • C. Refresh the full copy sandbox and re-run the data migration test.
  • D. Truncate all 5 objects and hard delete before running the migration test.

Answer: C

 

NEW QUESTION 65
Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce.
What are two automated approaches to fulfill this goal? (Choose two.)

  • A. Third-party Business Intelligence system
  • B. Schedulable Batch Apex
  • C. Apex Triggers
  • D. Third-party Integration Tool (ETL)

Answer: B,D

 

NEW QUESTION 66
Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several options are being considered, including analytics snapshots, offsite storage, scheduled purges, etc. Which three questions should be considered when designing an appropriate archiving strategy?

  • A. How many fields are defined on the custom objects that need to be archived?
  • B. Which profiles and users currently have access to these custom object records?
  • C. Will the data being archived need to be reported on or accessed in any way in the future?
  • D. If reporting is necessary, can the information be aggregated into fewer, summary records?
  • E. Are there any regulatory restrictions that will influence the archiving and purging plans?

Answer: C,D,E

 

NEW QUESTION 67
For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems?

  • A. Let a "system user" own all the Account records without assigning any role to this user in Role Hierarchy.
  • B. Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.
  • C. Let a "system user" own the Account records and assign this user to the lowest-level role in the Role Hierarchy.
  • D. Let a "system user" own all the Account records and make this user part of the highest-level role in the Role Hierarchy.

Answer: A,C

 

NEW QUESTION 68
UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality.
Which 2 solutions should a data architect recommend to monitor and measure data quality?
Choose 2 answers.

  • A. Export data and check for data completeness outside of Salesforce.
  • B. Review data quality reports and dashboards.
  • C. Install and run data quality analysis dashboard app
  • D. Use custom objects and fields to identify issues.

Answer: B,C

 

NEW QUESTION 69
The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce. What three things should the architect consider to optimize performance of the data migration? Choose 3 answers

  • A. Review the time zones of the User loading the data.
  • B. Defer sharing calculations of the Salesforce Org.
  • C. Deactivate approval processes and workflow rules.
  • D. Remove custom indexes on the data being loaded.
  • E. Determine if the legacy system is still in use.

Answer: B,C,D

 

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

Answer: A,D

 

NEW QUESTION 71
To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?

  • A. Errors with records being updated and inserted in the same CSV file.
  • B. Errors when a duplicate Contact name is found cause upsert to fail.
  • C. Errors with duplicate external Id values within the same CSV file.
  • D. Errors with using the wrong external Id will cause the load to fail.

Answer: C

 

NEW QUESTION 72
Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?

  • A. Use custom objects and fields to calculate data quality.
  • B. Generate reports to view the quality of sample data.
  • C. Export the data to an enterprise data warehouse and use BI tools for data quality.
  • D. Use third-party AppExchange tools to monitor and measure data quality.

Answer: D

 

NEW QUESTION 73
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 job to move all restore off platform, and delete old records from Salesforce.
  • D. Build a batch join to move two-year-old records off platform, and delete records from Salesforce.

Answer: A

 

NEW QUESTION 74
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. Partner Community license
  • B. Salesforce Sales Cloud license
  • C. Customer Community license
  • D. Lightning Platform license

Answer: A

 

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

Answer: C,D

 

NEW QUESTION 76
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. Data flows should be reviewed with the business users to determine the system of record per object or field.
  • B. Whatever integration data flow runs last will, by default, determine which system is the system of record.
  • C. Whatever system updates the attribute or object should be the system of record for that field or object.
  • D. Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.

Answer: A

 

NEW QUESTION 77
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.

Answer: D

 

NEW QUESTION 78
A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?

  • A. Use Salesforce Bulk API in parallel mode.
  • B. Use Salesforce Bulk API in serial mode.
  • C. Use Salesforce Soap API in parallel mode.
  • D. Use Salesforce Soap API in serial mode.

Answer: A

 

NEW QUESTION 79
Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.
Which two approaches should an Architect recommend to enforce the plan throughout the organization? (Choose two.)

  • A. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.
  • B. Enforce critical business processes by using Workflow, Validation Rules, and Apex code.
  • C. Ensure all data is stored in an external system and set up an integration to Salesforce for view-only access.
  • D. Schedule reports that will automatically catch duplicates and merge or delete the records every week.

Answer: A,B

 

NEW QUESTION 80
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. Load all individual consumers as Account records and avoid using the Contact object.
  • B. Load one Account record and one Contact record for each individual consumer.
  • C. Create one Account and load individual consumers as Contacts linked to that one Account.
  • D. Create a Custom Object Individual Consumer c to load all individual consumers.

Answer: B

 

NEW QUESTION 81
UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance.
Which 3 recommendations should a data architect provide to prevent ownership skew?
Choose 3 answers:

  • A. Assign a default user as owner of account and do not assign any role to default user.
  • B. Keep users out of public groups that can be used as the source for sharing rules.
  • C. Assigned a default user as owner of accounts, and assign role in hierarchy.
  • D. Assign "view all" permission on profile to give access to account.
  • E. Assign a default user as owner of accounts and assigned top most role in hierarchy.

Answer: A,B,E

 

NEW QUESTION 82
......


Salesforce Data-Architect Exam Syllabus Topics:

TopicDetails
Topic 1
  • Recommend and use techniques for establishing a "golden record" or "system of truth"
  • Recommend a data archiving and purging plan that is optimal for customer's data storage management needs
Topic 2
  • Compare and contrast various techniques and considerations for designing a data model
  • Compare and contrast the various techniques, approaches and considerations for implementing Master Data Management Solutions
Topic 3
  • Describe techniques to represent a single view of the customer on the Salesforce platform
  • Recommend appropriate techniques and methods for ensuring high data quality at load time
Topic 4
  • Recommend techniques to ensure data is persisted in a consistent manner
  • Design a data model that scales considering large data volume and solution performance
Topic 5
  • Recommend a design to effectively consolidate and
  • or leverage data from multiple Salesforce instances
  • Compare and contrast various techniques, approaches and considerations

 

Download Real Salesforce Data-Architect Exam Dumps Test Engine Exam Questions: https://itcert-online.newpassleader.com/Salesforce/Data-Architect-exam-preparation-materials.html