Data Enhancements, Sharing, and Analysis18% of the exam
Querying Data 360 from apps, APIs and orgs
Which way to reach Data 360 data from outside it: Data Explorer and Query Editor, the SQL Query APIs (async paging, caching, workloadName), JDBC, Python and the Connect API for Apex, companion versus standard org connections, and data shares between Data 360 orgs.
Explain how to reference Data 360 data from other systems.
~7 min read · 12 practice questions ·
What the exam expects
- Pick the retrieval method from who is asking: an admin exploring visually, an external app sending SQL over REST, a Java or Python program, or Apex inside the org.
- Run a large query through the SQL Query APIs correctly: queryId, polling, paging with rowLimit and offset, caching and workloadName.
- Explain the home org, standard Salesforce CRM connections and Data Cloud One companion connections, and what each lets a connected org do.
- Share Data 360 objects with another Data 360 org and predict how they land and who pays.
Key terms: home org (the org Data 360 is provisioned on), companion connection (bidirectional connection that syncs unified metadata to a CRM org), SQL Query APIs (Connect API endpoints that run Data 360 SQL), data share target (the connection to the receiving Data 360 org).
Key facts
Language-specific client libraries
- Detail
- JDBC, Python and the Connect API for Apex
Schema discovery for developers
- Detail
- Metadata API, before writing queries
Create SQL query response
- Detail
- queryId, metadata, first chunk; completionStatus Running
Paging parameters
- Detail
- rowLimit and offset on get SQL query rows
Result cache
- Detail
- Identical queries; 24-hour expiration
Data Explorer columns
- Detail
- Up to 10, alphabetical by default
Standard CRM connection returns
- Detail
- Data actions only; no metadata sync
Data Cloud One app
- Detail
- Available only on companion orgs
Shared object in target org
- Detail
- Modeled as a DLO
Org-to-org sharing credits
- Detail
- Consumed on source and target orgs
Sources for this section (5)
- Query Data in Data 360 (Query Guide)developer.salesforce.com (opens in a new tab)
- Query: Retrieve Campaign Engagement Recordsdeveloper.salesforce.com (opens in a new tab)
- Data Explorerhelp.salesforce.com (opens in a new tab)
- Connect Salesforce CRM Orgs to Data 360help.salesforce.com (opens in a new tab)
- Share Data Between Data 360 Orgshelp.salesforce.com (opens in a new tab)
- Why does a standard CRM connection not let an org's users open the Data Cloud One app?
- When is a SQL Query API result ready to page through?
- Which client library suits a Python notebook?
- Why set workloadName on every query request?
- What object type does a shared CIO become in the target Data 360 org?
The questions are free to read. Answers with their sources and self-grading are included with the pack.
Keep reading with the Data 360 Consultant pack
- Core concepts
- Exam traps
- Worked scenario
The pack includes:
- All 22 lessons of the Data 360 Consultant guide, with reading progress
- Interactive decision walks and step-by-step sequence steppers
- Inline practice questions and one-click topic practice (12 questions for this lesson)
- An official source cited for every claim
- An AI tutor that answers from the guide
- Unlimited timed practice exams