Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Salesforce Discussions
exam questions

Exam Certified Data Architect All Questions

View all questions & answers for the Certified Data Architect exam
Go to Exam

Exam Certified Data Architect topic 1 question 100 discussion

Actual exam question from Salesforce's Certified Data Architect
Question #: 100
Topic #: 1
[All Certified Data Architect Questions]

Universal Containers (UC) is migrating data from legacy system to Salesforce. During data analysis it was discovered that data types of fields being migrated do not match with Salesforce data types.

Which solution should a data architect use to ensure successful data migrations?

  • A. Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.
  • B. Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.
  • C. Export legacy data into CSV files and leverage data loader to load data into Salesforce.
  • D. Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Shivender at July 29, 2024, 6:07 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Shivender
3 months, 1 week ago
A. Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce. This option provides the most robust and controlled approach for data migration with data type mismatches: Staging Database: Acts as a buffer, allowing for data cleansing, transformation, and validation before loading into Salesforce. Data Mapping: Enables thorough analysis and mapping of legacy data types to Salesforce data types. ETL Tool: Provides the necessary capabilities to transform data, handle errors, and load data efficiently into Salesforce.
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel