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 19 discussion

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

Universal Containers (UC) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.
What data extraction strategy should a data architect use for maximum performance?

  • A. Utilize PK Chunking with the Bulk API.
  • B. Install a third-party AppExchange tool.
  • C. Use the Bulk API in parallel mode.
  • D. Call the REST API in successive queries.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by thneeb at June 28, 2023, 3:20 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
ETH777
10 months, 3 weeks ago
Selected Answer: A
Not B - Third-party tools often rely on underlying APIs like Bulk API or REST API. Not C - Processes entire object data in parallel and less efficient without PK chunking. Not D - Not optimised for bulk operations and can quickly reach Salesforce governor limits. A - Dividing the dataset into smaller chunks based on primary keys reduces the load on Salesforce servers. Bulk API also includes robust error handling and retry mechanisms.
upvoted 2 times
...
ksho
1 year, 2 months ago
Selected Answer: A
A. PK Chunking is the more performant solution for LDV extract. Not B, because the third-party is going to use PK Chunking. Not C, parallel mode is the default mode in Bulk API and is less performant than PK chunking. Not D, because REST API has limits per call, but also REST API is a subpar solution for creating an extract file with millions of records.
upvoted 3 times
...
thneeb
1 year, 4 months ago
Selected Answer: A
https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/async_api_headers_enable_pk_chunking.htm
upvoted 2 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