ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 116 - Certified Data Architect discussion

Report
Export

Universal Containers has more than 10 million records in the Order_c object. The query has timed out when running a bulk query. What should be considered to resolve query timeout?

A.
Tooling API
Answers
A.
Tooling API
B.
PK Chunking
Answers
B.
PK Chunking
C.
Metadata API
Answers
C.
Metadata API
D.
Streaming API
Answers
D.
Streaming API
Suggested answer: B

Explanation:

PK Chunking can resolve query timeout when running a bulk query on an object with more than 10 million records. PK Chunking is a feature of the Bulk API that splits a query into multiple batches based on the record IDs (primary keys) of the queried object. This can improve the query performance and avoid timeouts by reducing the number of records processed in each batch.

asked 23/09/2024
Ben Spiers
34 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first